phylotree

0 rows


Description

Global anchor for phylogenetic tree.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
phylotree_id serial 10 √ nextval('phylotree_phylotree_id_seq'::regclass)
phylonode.phylotree_id phylonode_phylotree_id_fkey C
phylonode_relationship.phylotree_id phylonode_relationship_phylotree_id_fkey C
phylotree_pub.phylotree_id phylotree_pub_phylotree_id_fkey C
dbxref_id int4 10 null
dbxref.dbxref_id phylotree_dbxref_id_fkey C
name varchar 255 √ null
type_id int4 10 √ null
cvterm.cvterm_id phylotree_type_id_fkey C

Type: protein, nucleotide, taxonomy, for example. The type should be any SO type, or “taxonomy”.
analysis_id int4 10 √ null
analysis.analysis_id phylotree_analysis_id_fkey C
comment text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
phylotree_pkey Primary key Asc phylotree_id
phylotree_idx1 Performance Asc phylotree_id

Relationships

Close relationships within degrees of separation