Difference between revisions of "TreeBASE Data"

From Evolutionary Informatics Working Group
Jump to: navigation, search
(TreeBASE Dump)
(TreeBASE Dump)
Line 2: Line 2:
  
 
A Postgres dump for TreeBASE can be obtained [[http://www.treebase.org/~piel/tbtrees.zip here]].
 
A Postgres dump for TreeBASE can be obtained [[http://www.treebase.org/~piel/tbtrees.zip here]].
 +
 +
==Dump Contents==
 +
 +
 +
                List of relations
 +
Schema |        Name        |  Type  | Owner
 +
--------+----------------------+----------+-------
 +
public | edges                | table    | piel
 +
public | ncbi_names          | table    | piel
 +
public | ncbi_nodes          | table    | piel
 +
public | node_path            | table    | piel
 +
public | nodes                | table    | piel
 +
public | nodes_node_id        | sequence | piel
 +
public | study                | table    | piel
 +
public | study_id_seq        | sequence | piel
 +
public | taxa                | table    | piel
 +
public | taxon_id_seq        | sequence | piel
 +
public | taxon_variant_id_seq | sequence | piel
 +
public | taxon_variants      | table    | piel
 +
public | tb_labels            | table    | piel
 +
public | tb_labels_id        | sequence | piel
 +
public | trees                | table    | piel
 +
public | trees_tree_id        | sequence | piel
 +
(16 rows)

Revision as of 12:09, 10 March 2009

TreeBASE Dump

A Postgres dump for TreeBASE can be obtained [here].

Dump Contents

               List of relations
Schema |         Name         |   Type   | Owner 

+----------------------+----------+-------
public | edges                | table    | piel
public | ncbi_names           | table    | piel
public | ncbi_nodes           | table    | piel
public | node_path            | table    | piel
public | nodes                | table    | piel
public | nodes_node_id        | sequence | piel
public | study                | table    | piel
public | study_id_seq         | sequence | piel
public | taxa                 | table    | piel
public | taxon_id_seq         | sequence | piel
public | taxon_variant_id_seq | sequence | piel
public | taxon_variants       | table    | piel
public | tb_labels            | table    | piel
public | tb_labels_id         | sequence | piel
public | trees                | table    | piel
public | trees_tree_id        | sequence | piel

(16 rows)