feature_cvterm

0 rows


Description

Associate a term from a cv with a feature, for example, GO annotation

Columns

Column Type Size Nulls Auto Default Children Parents Comments
feature_cvterm_id serial 10 nextval('feature_cvterm_feature_cvterm_id_seq'::regclass)
feature_cvterm_dbxref.feature_cvterm_id feature_cvterm_dbxref_feature_cvterm_id_fkey C
feature_cvterm_pub.feature_cvterm_id feature_cvterm_pub_feature_cvterm_id_fkey C
feature_cvtermprop.feature_cvterm_id feature_cvtermprop_feature_cvterm_id_fkey C
feature_id int4 10 null
feature.feature_id feature_cvterm_feature_id_fkey C
cvterm_id int4 10 null
cvterm.cvterm_id feature_cvterm_cvterm_id_fkey C
pub_id int4 10 null
pub.pub_id feature_cvterm_pub_id_fkey C

Provenance for the annotation. Each annotation should have a single primary publication (which may be of the appropriate type for computational analyses) where more details can be found. Additional provenance dbxrefs can be attached using feature_cvterm_dbxref

is_not bool 1 false

if this is set to true, then this annotation is interpreted as a NEGATIVE annotation - ie the feature does NOT have the specified function, process, component, part, etc. See GO docs for more details

rank int4 10 0

Indexes

Constraint Name Type Sort Column(s)
feature_cvterm_pkey Primary key Asc feature_cvterm_id
feature_cvterm_c1 Must be unique Asc/Asc/Asc/Asc feature_id + cvterm_id + pub_id + rank
feature_cvterm_idx1 Performance Asc feature_id
feature_cvterm_idx2 Performance Asc cvterm_id
feature_cvterm_idx3 Performance Asc pub_id

Relationships