Schema Version: 1.3 Module: chado

Columns

Columns

Table Type Column Type Size Nulls Default Comments
cvtermsynonym Table cvtermsynonym_id bigserial 19 nextval('cv.cvtermsynonym_cvtermsynonym_id_seq'::regclass)
cvterm_dbxref Table cvterm_id int8 19 null
dbprop Table db_id int8 19 null
cvterm_dbxref Table cvterm_dbxref_id bigserial 19 nextval('cv.cvterm_dbxref_cvterm_dbxref_id_seq'::regclass)
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.
cvtermprop Table cvtermprop_id bigserial 19 nextval('cv.cvtermprop_cvtermprop_id_seq'::regclass)
cvtermpath Table cvtermpath_id bigserial 19 nextval('cv.cvtermpath_cvtermpath_id_seq'::regclass)
cvterm Table definition text 2147483647 √ null

A human-readable text definition.
cvtermsynonym Table type_id int8 19 √ null

A synonym can be exact, narrower, or broader than.
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_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.
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.
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).
cvprop Table value text 2147483647 √ null

The value of the property, represented as text. Numeric values are converted to their text representation.
cv Table definition text 2147483647 √ null

A text description of the criteria for membership of this ontology.
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.
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.
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.
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.
dbxrefprop Table value text 2147483647 ''::text
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.
cvprop Table cv_id int8 19 null
cvtermsynonym Table synonym varchar 1024 null
dbprop Table rank int4 10 0
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.
cvtermpath Table object_id int8 19 null
cv Table cv_id bigserial 19 nextval('cv.cv_cv_id_seq'::regclass)
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.
dbxrefprop Table rank int4 10 0
cvtermprop Table cvterm_id int8 19 null
cvtermsynonym Table cvterm_id int8 19 null
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.
chadoprop Table chadoprop_id bigserial 19 nextval('cv.chadoprop_chadoprop_id_seq'::regclass)
cvprop Table cvprop_id bigserial 19 nextval('cv.cvprop_cvprop_id_seq'::regclass)
cvterm_dbxref Table dbxref_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.
cvterm Table cv_id int8 19 null

The cv or ontology or namespace to which this cvterm belongs.
cvterm_relationship Table cvterm_relationship_id bigserial 19 nextval('cv.cvterm_relationship_cvterm_relationship_id_seq'::regclass)
dbprop Table dbprop_id bigserial 19 nextval('cv.dbprop_dbprop_id_seq'::regclass)
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.
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.
dbxrefprop Table dbxref_id int8 19 null
dbprop Table type_id int8 19 null
cvtermpath Table subject_id int8 19 null
cvterm Table name varchar 1024 null

A concise human-readable name or label for the cvterm. Uniquely identifies a cvterm within a cv.
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.
dbxrefprop Table dbxrefprop_id bigserial 19 nextval('cv.dbxrefprop_dbxrefprop_id_seq'::regclass)
dbprop Table value text 2147483647 √ null
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.
dbxrefprop Table type_id int8 19 null
cvterm Table cvterm_id bigserial 19 nextval('cv.cvterm_cvterm_id_seq'::regclass)