Schema Version: 1.3

phylonode_relationship


Description

This is for relationships that are not strictly hierarchical; for example, horizontal gene transfer. Most phylogenetic trees are strictly hierarchical, nevertheless it is here for completeness.

Columns

Column Type Size Foreign Key Nullable Default Comments
phylonode_relationship_id bigserial 19
nextval('chado.phylonode_relationship_phylonode_relationship_id_seq'::regclass)
subject_id int8 19
phylonode.phylonode_id phylonode_relationship_subject_id_fkey C
null
object_id int8 19
phylonode.phylonode_id phylonode_relationship_object_id_fkey C
null
type_id int8 19
cvterm.cvterm_id phylonode_relationship_type_id_fkey C
null
rank int4 10
√ null
phylotree_id int8 19
phylotree.phylotree_id phylonode_relationship_phylotree_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
phylonode_relationship_pkey Primary key Asc phylonode_relationship_id
phylonode_relationship_idx1 Performance Asc subject_id
phylonode_relationship_idx2 Performance Asc object_id
phylonode_relationship_idx3 Performance Asc type_id
phylonode_relationship_subject_id_object_id_type_id_key Must be unique Asc/Asc/Asc subject_id + object_id + type_id

Relationships

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

Show relationships within degrees of separation