Schema Version: 1.3

phylotree


Description

Global anchor for phylogenetic tree.

Columns

Column Type Size Foreign Key Nullable Default Comments
phylotree_id bigserial 19
nextval('chado.phylotree_phylotree_id_seq'::regclass)
dbxref_id int8 19
dbxref.dbxref_id phylotree_dbxref_id_fkey C
null
name varchar 255
√ null
type_id int8 19
cvterm.cvterm_id phylotree_type_id_fkey C
√ null

Type: protein, nucleotide, taxonomy, for example. The type should be any SO type, or "taxonomy".
analysis_id int8 19
analysis.analysis_id phylotree_analysis_id_fkey C
√ null
comment text 2147483647
√ null

Table contained -1 rows

Indexes

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

Relationships

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

Show relationships within degrees of separation