<commit_before><commit_msg>new auxilary table genome_db_stats to hold genome level summary stats<commit_after>--
-- Table structure for table `genome_db_stats`
--
-- table to hold genome level summary statistics 
-- Used by Bio::EnsEMBL::Compara::RunnableDB::GenomeCalcStats module
-- 

CREATE TABLE genome_db_stats (
  genome_db_id    int(10) NOT NULL default '0',
  data_type       varchar(20) NOT NULL,
  count           int(10) NOT NULL,
  mean            double NOT NULL default '0',
  median          double NOT NULL default '0',
  mode            double NOT NULL,
  stddev          double NOT NULL,
  variance        double NOT NULL,
  min             double NOT NULL default '0',
  max             double NOT NULL default '0',
  overlap_count   int(10) NOT NULL default '0',
  
  UNIQUE KEY genome_db_id_type (genome_db_id, data_type)
);


{'fraction_non_alphanumeric': 0.07674144037780402, 'fraction_numerical': 0.01652892561983471, 'mean_word_length': 2.6394849785407724, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2230437', 'n_tokens_mistral': 266, 'n_tokens_neox': 252, 'n_words': 90}