cvterm

8626 rows


Description

A term, class, universal or type within an ontology or controlled vocabulary. This table is also used for relations and properties. cvterms constitute nodes in the graph defined by the collection of cvterms and cvterm_relationships

Columns

Column Type Size Nulls Auto Default Children Parents Comments
cvterm_id serial 10 √ nextval('cvterm_cvterm_id_seq'::regclass)
bs_sample.type_id bs_sample_type_id_fkey R
bs_sample_cvterm.cvterm_id bs_sample_cvterm_cvterm_id_fkey R
bs_sample_element_cvterm.cvterm_id bs_sample_element_cvterm_cvterm_id_fkey R
bs_sample_relationship.type_id bs_sample_relationship_type_id_fkey R
md_image_cvterm.cvterm_id md_image_cvterm_cvterm_id_fkey R
cvterm_pub_ranking.cvterm_id cvterm_pub_ranking_cvterm_id_fkey R
locusgroup.relationship_id locusgroup_relationship_id_fkey R
locusgroup_member.evidence_id locusgroup_member_evidence_id_fkey R
project_md_image.type_id project_md_image_type_id_fkey R
all_gs_traits.cvterm_id Implied Constraint R
analysisprop.type_id analysisprop_type_id_fkey C
contact.type_id contact_type_id_fkey R
contact_relationship.type_id contact_relationship_type_id_fkey C
cvprop.type_id cvprop_type_id_fkey R
cvterm_dbxref.cvterm_id cvterm_dbxref_cvterm_id_fkey C
cvterm_relationship.object_id cvterm_relationship_object_id_fkey C
cvterm_relationship.subject_id cvterm_relationship_subject_id_fkey C
cvterm_relationship.type_id cvterm_relationship_type_id_fkey C
cvtermpath.object_id cvtermpath_object_id_fkey C
cvtermpath.subject_id cvtermpath_subject_id_fkey C
cvtermpath.type_id cvtermpath_type_id_fkey N
cvtermprop.cvterm_id cvtermprop_cvterm_id_fkey C
cvtermprop.type_id cvtermprop_type_id_fkey C
cvtermsynonym.cvterm_id cvtermsynonym_cvterm_id_fkey C
cvtermsynonym.type_id cvtermsynonym_type_id_fkey C
dbxrefprop.type_id dbxrefprop_type_id_fkey R
environment_cvterm.cvterm_id environment_cvterm_cvterm_id_fkey C
feature.type_id feature_type_id_fkey C
feature_cvterm.cvterm_id feature_cvterm_cvterm_id_fkey C
feature_cvtermprop.type_id feature_cvtermprop_type_id_fkey C
feature_genotype.cvterm_id feature_genotype_cvterm_id_fkey C
feature_relationship.type_id feature_relationship_type_id_fkey C
feature_relationshipprop.type_id feature_relationshipprop_type_id_fkey C
featureprop.type_id featureprop_type_id_fkey C
featureprop_json.type_id featureprop_json_type_id_fkey R
genotype.type_id genotype_type_id_fkey C
genotypeprop.type_id genotypeprop_type_id_fkey C
nd_experiment.type_id nd_experiment_type_id_fkey C
nd_experiment_stock.type_id nd_experiment_stock_type_id_fkey C
nd_experiment_stockprop.type_id nd_experiment_stockprop_type_id_fkey C
nd_experimentprop.type_id nd_experimentprop_type_id_fkey C
nd_geolocationprop.type_id nd_geolocationprop_type_id_fkey C
nd_protocol.type_id nd_protocol_type_id_fkey C
nd_protocol_reagent.type_id nd_protocol_reagent_type_id_fkey C
nd_protocolprop.type_id nd_protocolprop_type_id_fkey C
nd_reagent.type_id nd_reagent_type_id_fkey C
nd_reagent_relationship.type_id nd_reagent_relationship_type_id_fkey C
nd_reagentprop.type_id nd_reagentprop_type_id_fkey C
organism_relationship.type_id organism_relationship_type_id_fkey R
organismpath.type_id organismpath_type_id_fkey R
organismprop.type_id organismprop_type_id_fkey C
phendesc.type_id phendesc_type_id_fkey C
phenotype.assay_id phenotype_assay_id_fkey N
phenotype.attr_id phenotype_attr_id_fkey N
phenotype.cvalue_id phenotype_cvalue_id_fkey N
phenotype.observable_id phenotype_observable_id_fkey C
phenotype_comparison_cvterm.cvterm_id phenotype_comparison_cvterm_cvterm_id_fkey C
phenotype_cvterm.cvterm_id phenotype_cvterm_cvterm_id_fkey C
phenotypeprop.type_id phenotypeprop_type_id_fkey C
phenstatement.type_id phenstatement_type_id_fkey C
phylonode.type_id phylonode_type_id_fkey C
phylonode_relationship.type_id phylonode_relationship_type_id_fkey C
phylonodeprop.type_id phylonodeprop_type_id_fkey C
phylotree.type_id phylotree_type_id_fkey C
project.type_id project_type_id_fkey N
project_relationship.type_id project_relationship_type_id_fkey R
projectprop.type_id projectprop_type_id_fkey C
pub.type_id pub_type_id_fkey C
pub_relationship.type_id pub_relationship_type_id_fkey C
pubprop.type_id pubprop_type_id_fkey C
stock.type_id stock_type_id_fkey C
stock_cvterm.cvterm_id stock_cvterm_cvterm_id_fkey C
stock_cvtermprop.type_id stock_cvtermprop_type_id_fkey C
stock_dbxrefprop.type_id stock_dbxrefprop_type_id_fkey C
stock_relationship.type_id stock_relationship_type_id_fkey C
stock_relationship_cvterm.cvterm_id stock_relationship_cvterm_cvterm_id_fkey R
stockcollection.type_id stockcollection_type_id_fkey C
stockcollectionprop.type_id stockcollectionprop_type_id_fkey R
stockprop.type_id stockprop_type_id_fkey C
synonym.type_id synonym_type_id_fkey C
chadoprop.type_id chadoprop_type_id_fkey R
common_nameprop.type_id organismprop_type_id_fkey R
pcr_experiment_sequence.type_id pcr_experiment_sequence_type_id_fkey R
snpprop.type_id snpprop_type_id_fkey R
list.type_id list_type_id_fkey R
listprop.type_id listprop_type_id_fkey R
sp_orderprop.type_id sp_orderprop_type_id_fkey R
cv_id int4 10 null
cv.cv_id cvterm_cv_id_fkey C

The cv/ontology/namespace to which this cvterm belongs
name varchar 1024 null

A concise human-readable name or label for the cvterm. uniquely identifies a cvterm within a cv
definition text 2147483647 √ null

A human-readable text definition
dbxref_id int4 10 null
dbxref.dbxref_id cvterm_dbxref_id_fkey N

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

Indexes

Constraint Name Type Sort Column(s)
cvterm_pkey Primary key Asc cvterm_id
cvterm_c1 Must be unique Asc/Asc/Asc name + cv_id + is_obsolete
cvterm_c2 Must be unique Asc dbxref_id
cvterm_idx1 Performance Asc cv_id
cvterm_idx2 Performance Asc name
cvterm_idx3 Performance Asc dbxref_id

Relationships

Close relationships within degrees of separation