Schema Version: 1.3

feature_cvterm_dbxref


Description

Additional dbxrefs for an association. Rows in the feature_cvterm table may be backed up by dbxrefs. For example, a feature_cvterm association that was inferred via a protein-protein interaction may be backed by by refering to the dbxref for the alternate protein. Corresponds to the WITH column in a GO gene association file (but can also be used for other analagous associations). See http://www.geneontology.org/doc/GO.annotation.shtml#file for more details.

Columns

Column Type Size Foreign Key Nullable Default Comments
feature_cvterm_dbxref_id bigserial 19
nextval('chado.feature_cvterm_dbxref_feature_cvterm_dbxref_id_seq'::regclass)
feature_cvterm_id int8 19
feature_cvterm.feature_cvterm_id feature_cvterm_dbxref_feature_cvterm_id_fkey C
null
dbxref_id int8 19
dbxref.dbxref_id feature_cvterm_dbxref_dbxref_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
feature_cvterm_dbxref_pkey Primary key Asc feature_cvterm_dbxref_id
feature_cvterm_dbxref_c1 Must be unique Asc/Asc feature_cvterm_id + dbxref_id
feature_cvterm_dbxref_idx1 Performance Asc feature_cvterm_id
feature_cvterm_dbxref_idx2 Performance Asc dbxref_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the feature_cvterm_dbxref table.

Show relationships within degrees of separation