 @column node_name               A name that can be set to the taxon name or any other arbitrary name
 
 @see species_tree_node_tag
+@see species_tree_node_attr
 @see species_tree_root
 @see CAFE_gene_family
 @see CAFE_species_gene

@column nb_orphan_genes                     nb_orphan_genes
@column nb_seq                              the number of sequences
@column nb_spec_nodes                       nb_spec_nodes
@column n_gene_split_genes                  n_gene_split_genes
@column n_gene_split_groups                 n_gene_split_groups
@column n_gene_split_pairs                  n_gene_split_pairs
@column nb_gene_splits                      the number split genes 
@column n_within_species_paralog_genes      n_within_species_paralog_genes
@column n_within_species_paralog_groups     n_within_species_paralog_groups
@column root_avg_gene                       root_avg_gene
@column root_avg_gene_per_spec              root_avg_gene_per_spec
@column root_avg_spec                       root_avg_spec


CREATE TABLE `species_tree_node_attr` (
  `node_id` int(10)                         unsigned NOT NULL,
  `nb_long_genes`                           int,
  `nb_short_genes`                          int,
  `avg_dupscore`                            float,
  `avg_dupscore_nondub`                     float,
  `nb_dubious_nodes`                        int,
  `nb_dup_nodes`                            int,
  `nb_genes`                               int,
  `nb_genes_in_tree`                       int,
  `nb_genes_in_tree_multi_species`         int,
  `nb_genes_in_tree_single_species`        int,
  `nb_nodes`                               int,
  `nb_orphan_genes`                        int,
  `nb_seq`                                 int,
  `nb_spec_nodes`                          int,
  `nb_gene_splits`                         int,
  `nb_split_genes`                         int,
  `root_avg_gene`                          float,
  `root_avg_gene_per_spec`                 float,
  `root_avg_spec`                          float,
  `root_max_gene`                          int,
  `root_max_spec`                          int,
  `root_min_gene`                          int,
  `root_min_spec`                          int,
  `root_nb_genes`                          int,
  `root_nb_trees`                          int,

  FOREIGN KEY (node_id) REFERENCES species_tree_node(node_id),
  PRIMARY KEY (node_id)
