Schema Version: 1.3 Module: chado

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('sequence.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.

These relationships often cross chado module boundries, in which case the table name will be prefixed with the module it is in. When querying these tables do not include the module name, as all chado tables are contained within the same schema.

Show relationships within degrees of separation