Big Tree Viewer Schema

Draft

Tables

tree

Name

Type

Description

tree_id

integer

Unique id for tree

root_id

integer

Id of root node

name

varchar

Name of tree

node

Name

Type

Description

node_id

integer

Unique id for node

label

varchar

Label for node

topology

Name

Type

Description

node_id

integer

Id of this node

parent_id

integer

Id of the parent node

tree_id

integer

Id of the tree that the node belongs to

LeftNode

integer

Index of the first visit to the node in a two-visit depth-first traversal of the tree. This visit happens before any children are visited. Nodes in the same tree with a (left or right) index greater than this and less than the RightNode are descendants of this node.

RightNode

integer

Index of last visit to the node in a two-visit depth-first traversal of the tree. This visit happens after any children are visited. Nodes in the same tree with a (left or right) index less than this and greater than the LeftNode are descendants of this node.

depth

integer

Depth from the root

height

integer

Height from the node's deepest leaf descendant

NumChildren

integer

Number of children

NumLeaves

integer

Number of descendants that are leaves

NumNodes

integer

Number of all descendant nodes

node_layout

This table contains the x,y position and bounding box information for each node. 

Name

Type

Description

node_id

integer

Id of the node

tree_id

integer

Id of the tree

layout_id

varchar

Layout id (ie, Cladogram or Circular)

point

geometry

PostGIS geometry of the point (x,y) position

bounding_box

geometry

PostGIS geometry containing the bounding box of the node

overview_images

This table contains path to images to use for the overview image.

Name

Type

Description

tree_id

integer

Tree id

layout_id

varchar

Layout id

image_width

integer

Width of image

image_height

integer

Height of image

image_path

varchar

Path to image on disk

node_label_lookup

This table contains a lookup for alternative labels for nodes. This is used to display a label next to triangles if the internal node does not have a label. This table is populated during loading of the tree with the first child label.

Name

Type

Description

node_id

integer

Id of the node

alt_label

varchar

Alternative label for this node