 
 CREATE TABLE `species_tree_node_attr` (
   `node_id` int(10)                         unsigned NOT NULL,
-  `nb_long_genes`                           mediumtext,
-  `nb_short_genes`                          mediumtext,
-  `avg_dupscore`                            mediumtext,
-  `avg_dupscore_nondub`                     mediumtext,
-  `avg_gene_split_perc_id`                  mediumtext,
-  `avg_within_species_paralog_perc_id`      mediumtext,
-  `nb_dubious_nodes`                        mediumtext,
-  `nb_genes`                               mediumtext,
-  `nb_genes_in_tree`                       mediumtext,
-  `nb_genes_in_tree_multi_species`         mediumtext,
-  `nb_genes_in_tree_single_species`        mediumtext,
-  `nb_nodes`                               mediumtext,
-  `nb_orphan_genes`                        mediumtext,
-  `nb_seq`                                 mediumtext,
-  `nb_spec_nodes`                          mediumtext,
-  `n_gene_split_genes`                     mediumtext,
-  `n_gene_split_groups`                    mediumtext,
-  `n_gene_split_pairs`                     mediumtext,
-  `nb_gene_splits`                         mediumtext,
-  `nb_split_genes`                         mediumtext,
-  `n_within_species_paralog_genes`         mediumtext,
-  `n_within_species_paralog_groups`        mediumtext,
-  `n_within_species_paralog_pairs`         mediumtext,
-  `root_avg_gene`                          mediumtext,
-  `root_avg_gene_per_spec`                 mediumtext,
-  `root_avg_spec`                          mediumtext,
-  `root_max_gene`                          mediumtext,
-  `root_max_spec`                          mediumtext,
-  `root_min_gene`                          mediumtext,
-  `root_min_spec`                          mediumtext,
-  `root_nb_genes`                          mediumtext,
-  `root_nb_trees`                          mediumtext,
+  `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)

@column goc_50                              the number of orthologs with 50% gene order conservation among their neighbours
@column goc_75                              the number of orthologs with 75% gene order conservation among their neighbours
@column goc_100                             the number of orthologs with 100% gene order conservation among their neighbours
@column goc_quality_threshold               the chosen threshold for "high quality" orthologs based on gene order conservation = 50% 
@column ortholog_quality_threshold          the chosen threshold for "high quality" orthologs based on the whole genome alignments coverage of homologous pairs = 50%
@column threshold_on_ds

@see method_link_species_set

@column nb_short_genes                      the number of genes shorter than the avg length of their orthologs
@column avg_dupscore                        the average duplication score
@column avg_dupscore_nondub                 avg_dupscore_nondub
@column nb_dubious_nodes                    nb_dubious_nodes
@column nb_dup_nodes                        nb_dup_nodes
@column nb_genes                            the number of genes
@column nb_genes_in_tree                    the number of genes in the tree 
@column nb_genes_in_tree_multi_species      nb_genes_in_tree_multi_species
