Schema Version: 1.3 Module: chado

feature_cvterm


Description

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

Columns

Column Type Size Foreign Key Nullable Default Comments
feature_cvterm_id bigserial 19
nextval('sequence.feature_cvterm_feature_cvterm_id_seq'::regclass)
feature_id int8 19
feature.feature_id feature_cvterm_feature_id_fkey C
null
cvterm_id int8 19
cvterm.cvterm_id feature_cvterm_cvterm_id_fkey C
null
pub_id int8 19
pub.pub_id feature_cvterm_pub_id_fkey C
null

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 - i.e. the feature does NOT have the specified function, process, component, part, etc. See GO docs for more details.

rank int4 10
0

Table contained -1 rows

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