Columns
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 |