phylonode_relationship

0 rows


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 Nulls Auto Default Children Parents Comments
phylonode_relationship_id serial 10 √ nextval('phylonode_relationship_phylonode_relationship_id_seq'::regclass)
subject_id int4 10 null
phylonode.phylonode_id phylonode_relationship_subject_id_fkey C
object_id int4 10 null
phylonode.phylonode_id phylonode_relationship_object_id_fkey C
type_id int4 10 null
cvterm.cvterm_id phylonode_relationship_type_id_fkey C
rank int4 10 √ null
phylotree_id int4 10 null
phylotree.phylotree_id phylonode_relationship_phylotree_id_fkey C

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_key Must be unique Asc/Asc/Asc subject_id + object_id + type_id

Relationships

Close relationships within degrees of separation