Schema Version: 1.3

phylonode_dbxref


Description

For example, for orthology, paralogy group identifiers; could also be used for NCBI taxonomy; for sequences, refer to phylonode_feature, feature associated dbxrefs.

Columns

Column Type Size Foreign Key Nullable Default Comments
phylonode_dbxref_id bigserial 19
nextval('chado.phylonode_dbxref_phylonode_dbxref_id_seq'::regclass)
phylonode_id int8 19
phylonode.phylonode_id phylonode_dbxref_phylonode_id_fkey C
null
dbxref_id int8 19
dbxref.dbxref_id phylonode_dbxref_dbxref_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
phylonode_dbxref_pkey Primary key Asc phylonode_dbxref_id
phylonode_dbxref_idx1 Performance Asc phylonode_id
phylonode_dbxref_idx2 Performance Asc dbxref_id
phylonode_dbxref_phylonode_id_dbxref_id_key Must be unique Asc/Asc phylonode_id + dbxref_id

Relationships

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

Show relationships within degrees of separation