chado Module

Columns

Search:

Table	Type	Column	Type	Size	Nulls	Default	Comments
chadoprop	Table	chadoprop_id	bigserial	19		nextval('cv.chadoprop_chadoprop_id_seq'::regclass)
cvtermpath	Table	cv_id	int8	19		null	Closures will mostly be within one cv. If the closure of a relationship traverses a cv, then this refers to the cv of the object_id cvterm.
cvprop	Table	cv_id	int8	19		null
cv	Table	cv_id	bigserial	19		nextval('cv.cv_cv_id_seq'::regclass)
cvterm	Table	cv_id	int8	19		null	The cv or ontology or namespace to which this cvterm belongs.
cvprop	Table	cvprop_id	bigserial	19		nextval('cv.cvprop_cvprop_id_seq'::regclass)
cvterm_dbxref	Table	cvterm_dbxref_id	bigserial	19		nextval('cv.cvterm_dbxref_cvterm_dbxref_id_seq'::regclass)
cvterm_dbxref	Table	cvterm_id	int8	19		null
cvtermprop	Table	cvterm_id	int8	19		null
cvtermsynonym	Table	cvterm_id	int8	19		null
cvterm	Table	cvterm_id	bigserial	19		nextval('cv.cvterm_cvterm_id_seq'::regclass)
cvterm_relationship	Table	cvterm_relationship_id	bigserial	19		nextval('cv.cvterm_relationship_cvterm_relationship_id_seq'::regclass)
cvtermpath	Table	cvtermpath_id	bigserial	19		nextval('cv.cvtermpath_cvtermpath_id_seq'::regclass)
cvtermprop	Table	cvtermprop_id	bigserial	19		nextval('cv.cvtermprop_cvtermprop_id_seq'::regclass)
cvtermsynonym	Table	cvtermsynonym_id	bigserial	19		nextval('cv.cvtermsynonym_cvtermsynonym_id_seq'::regclass)
dbprop	Table	db_id	int8	19		null
dbprop	Table	dbprop_id	bigserial	19		nextval('cv.dbprop_dbprop_id_seq'::regclass)
cvterm	Table	dbxref_id	int8	19		null	Primary identifier dbxref - The unique global OBO identifier for this cvterm. Note that a cvterm may have multiple secondary dbxrefs - see also table: cvterm_dbxref.
cvterm_dbxref	Table	dbxref_id	int8	19		null
dbxrefprop	Table	dbxref_id	int8	19		null
dbxrefprop	Table	dbxrefprop_id	bigserial	19		nextval('cv.dbxrefprop_dbxrefprop_id_seq'::regclass)
cvterm	Table	definition	text	2147483647	√	null	A human-readable text definition.
cv	Table	definition	text	2147483647	√	null	A text description of the criteria for membership of this ontology.
cvterm_dbxref	Table	is_for_definition	int4	10		0	A cvterm.definition should be supported by one or more references. If this column is true, the dbxref is not for a term in an external database - it is a dbxref for provenance information for the definition.
cvterm	Table	is_obsolete	int4	10		0	Boolean 0=false,1=true; see GO documentation for details of obsoletion. Note that two terms with different primary dbxrefs may exist if one is obsolete.
cvterm	Table	is_relationshiptype	int4	10		0	Boolean 0=false,1=true relations or relationship types (also known as Typedefs in OBO format, or as properties or slots) form a cv/ontology in themselves. We use this flag to indicate whether this cvterm is an actual term/class/universal or a relation. Relations may be drawn from the OBO Relations ontology, but are not exclusively drawn from there.
cv	Table	name	varchar	255		null	The name of the ontology. This corresponds to the obo-format -namespace-. cv names uniquely identify the cv. In OBO file format, the cv.name is known as the namespace.
cvterm	Table	name	varchar	1024		null	A concise human-readable name or label for the cvterm. Uniquely identifies a cvterm within a cv.
cvtermpath	Table	object_id	int8	19		null
cvterm_relationship	Table	object_id	int8	19		null	The object of the subj-predicate-obj sentence. The cvterm_relationship refers to the object. In a graph, this typically corresponds to the parent node.
cvtermpath	Table	pathdistance	int4	10	√	null	The number of steps required to get from the subject cvterm to the object cvterm, counting from zero (reflexive relationship).
chadoprop	Table	rank	int4	10		0	Property-Value ordering. Any cv can have multiple values for any particular property type - these are ordered in a list using rank, counting from zero. For properties that are single-valued rather than multi-valued, the default 0 value should be used.
dbprop	Table	rank	int4	10		0
dbxrefprop	Table	rank	int4	10		0
cvprop	Table	rank	int4	10		0	Property-Value ordering. Any cv can have multiple values for any particular property type - these are ordered in a list using rank, counting from zero. For properties that are single-valued rather than multi-valued, the default 0 value should be used.
cvtermprop	Table	rank	int4	10		0	Property-Value ordering. Any cvterm can have multiple values for any particular property type - these are ordered in a list using rank, counting from zero. For properties that are single-valued rather than multi-valued, the default 0 value should be used.
cvterm_relationship	Table	subject_id	int8	19		null	The subject of the subj-predicate-obj sentence. The cvterm_relationship is about the subject. In a graph, this typically corresponds to the child node.
cvtermpath	Table	subject_id	int8	19		null
cvtermsynonym	Table	synonym	varchar	1024		null
cvtermprop	Table	type_id	int8	19		null	The name of the property or slot is a cvterm. The meaning of the property is defined in that cvterm.
cvtermsynonym	Table	type_id	int8	19	√	null	A synonym can be exact, narrower, or broader than.
cvterm_relationship	Table	type_id	int8	19		null	The nature of the relationship between subject and object. Note that relations are also housed in the cvterm table, typically from the OBO relationship ontology, although other relationship types are allowed.
cvprop	Table	type_id	int8	19		null	The name of the property or slot is a cvterm. The meaning of the property is defined in that cvterm.
chadoprop	Table	type_id	int8	19		null	The name of the property or slot is a cvterm. The meaning of the property is defined in that cvterm.
cvtermpath	Table	type_id	int8	19	√	null	The relationship type that this is a closure over. If null, then this is a closure over ALL relationship types. If non-null, then this references a relationship cvterm - note that the closure will apply to both this relationship AND the OBO_REL:is_a (subclass) relationship.
dbprop	Table	type_id	int8	19		null
dbxrefprop	Table	type_id	int8	19		null
cvprop	Table	value	text	2147483647	√	null	The value of the property, represented as text. Numeric values are converted to their text representation.
dbxrefprop	Table	value	text	2147483647		''::text
cvtermprop	Table	value	text	2147483647		''::text	The value of the property, represented as text. Numeric values are converted to their text representation.
chadoprop	Table	value	text	2147483647	√	null	The value of the property, represented as text. Numeric values are converted to their text representation.
dbprop	Table	value	text	2147483647	√	null

Showing 1 to 52 of 52 entries