| phylonode_id |
serial |
10 |
|
√ |
nextval('phylonode_phylonode_id_seq'::regclass) |
|
|
|
| phylotree_id |
int4 |
10 |
|
|
null |
|
| phylotree.phylotree_id |
phylonode_phylotree_id_fkey |
C |
|
|
| parent_phylonode_id |
int4 |
10 |
√ |
|
null |
|
| phylonode.phylonode_id |
phylonode_parent_phylonode_id_fkey |
C |
|
Root phylonode can have null parent_phylonode_id value. |
| left_idx |
int4 |
10 |
|
|
null |
|
|
|
| right_idx |
int4 |
10 |
|
|
null |
|
|
|
| type_id |
int4 |
10 |
√ |
|
null |
|
| cvterm.cvterm_id |
phylonode_type_id_fkey |
C |
|
Type: e.g. root, interior, leaf. |
| feature_id |
int4 |
10 |
√ |
|
null |
|
| feature.feature_id |
phylonode_feature_id_fkey |
C |
|
Phylonodes can have optional features attached to them e.g. a protein or nucleotide sequence usually attached to a leaf of the phylotree for non-leaf nodes, the feature may be a feature that is an instance of SO:match; this feature is the alignment of all leaf features beneath it. |
| label |
varchar |
255 |
√ |
|
null |
|
|
|
| distance |
float8 |
17,17 |
√ |
|
null |
|
|
|
