Schema Version: 1.3 Module: chado.phylogeny

TABLES 9
VIEWS 0
COLUMNS 43
Constraints 23

chado.phylogeny Tables

Table / View Referenced Foreign Keys Columns Type Comments
phylonode 7 4 9 Table

This is the most pervasive element in the phylogeny module, cataloging the "phylonodes" of tree graphs. Edges are implied by the parent_phylonode_id reflexive closure. For all nodes in a nested set implementation the left and right index will be between the parents left and right indexes.

phylonode_dbxref 0 2 3 Table

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

phylonode_organism 0 2 3 Table

This linking table should only be used for nodes in taxonomy trees; it provides a mapping between the node and an organism. One node can have zero or one organisms, one organism can have zero or more nodes (although typically it should only have one in the standard NCBI taxonomy tree).

phylonode_pub 0 2 3 Table
phylonode_relationship 0 4 6 Table

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.

phylonodeprop 0 2 5 Table
phylotree 4 3 6 Table

Global anchor for phylogenetic tree.

phylotree_pub 0 2 3 Table

Tracks citations global to the tree e.g. multiple sequence alignment supporting tree construction.

phylotreeprop 0 2 5 Table

A phylotree can have any number of slot-value property tags attached to it. This is an alternative to hardcoding a list of columns in the relational schema, and is completely extensible.