Gemina MySQL Stats

Key Gemina tables

Total database size (including indices): 72.10 GB
Name Number of Rows Average Row Size Data Length Date Created
analysis 91440.14 KB 12961.27 KB2009-05-05 04:06:43
assembly_reads 2,863,83311511.12 KB 33894914643.16 GB2008-07-16 14:29:37
cm_infection 14,6551870.18 KB 27513002.62 MB2008-05-16 09:56:47
cm_infection_attrs 1,191400.04 KB 4830447.17 KB2008-05-16 09:56:47
cm_proteins 3,158,7941130.11 KB 358234692341.64 MB2009-05-05 09:17:21
cv 31260.03 KB 8160.80 KB2009-05-05 04:06:50
cvterm 489,615520.05 KB 2594684024.74 MB2009-05-05 04:06:54
cvterm_dbxref 484,606140.01 KB 67844846.47 MB2009-05-05 04:07:06
cvterm_relationship 495,868170.02 KB 84297568.04 MB2009-05-05 04:07:15
cvtermpath 7,029,025250.02 KB 175725625167.59 MB2009-05-05 04:07:25
cvtermprop 4,1163100.30 KB 12796241.22 MB2009-05-05 04:09:51
cvtermsynonym 176,811480.05 KB 84995168.11 MB2009-05-05 04:09:54
db 71250.02 KB 17841.74 KB2009-05-05 04:09:59
dbxref 12,803,977330.03 KB 431656488411.66 MB2009-05-05 04:10:01
feature 18,270,2468910.87 KB 1628965261215.17 GB2009-05-05 01:25:57
feature_cvterm 3,142,814180.02 KB 5657065253.95 MB2009-05-05 03:48:38
feature_dbxref 33,162,546140.01 KB 464275644442.77 MB2009-05-05 04:22:12
feature_relationship 16,363,832240.02 KB 394277008376.01 MB2009-05-05 04:32:48
featureloc 16,528,112310.03 KB 528329440503.85 MB2009-05-05 04:37:42
featureprop 25,792,323670.07 KB 17377678201.62 GB2009-05-05 04:49:22
incident 100220.02 KB 22002.15 KB2009-05-05 03:32:31
incident_cvterm 3170.02 KB 510.05 KB2009-05-05 03:32:37
incident_pub 104130.01 KB 13521.32 KB2009-05-05 05:08:46
incident_relationship 30170.02 KB 5100.50 KB2009-05-05 05:08:50
incidentprop 19240.02 KB 4720.46 KB2009-05-05 05:08:52
infection 12,732170.02 KB 216444211.37 KB2009-05-05 05:08:55
infection_cvterm 1,191170.02 KB 2024719.77 KB2009-05-05 03:33:09
infection_dbxref 12,732130.01 KB 165516161.64 KB2009-05-05 05:08:58
infection_pub 12,273130.01 KB 159549155.81 KB2009-05-05 05:09:01
organism 8,3411240.12 KB 10410241,016.63 KB2009-05-05 05:09:07
organism_dbxref 3,144,690130.01 KB 4088097038.99 MB2009-05-05 05:09:10
organismprop 16,653420.04 KB 708176691.58 KB2009-05-05 05:10:03
pub 12580.06 KB 6960.68 KB2009-05-05 05:10:29
read_relationship 2,700,630540.05 KB 150845660143.86 MB2008-07-16 14:37:46
readloc 2,821,297310.03 KB 9279045688.49 MB2008-07-16 14:36:37
k-unique signatures (partition 1) 14,533,016790.08 KB 11595777121.08 GB2008-07-22 10:43:48
k-unique signatures (partition 2) 17,231,833790.08 KB 13748636441.28 GB2008-07-21 12:42:37
k-unique signatures (partition 3) 18,488,179790.08 KB 14751042561.37 GB2008-07-22 11:57:54
k-unique signatures (partition 4) 14,167,449790.08 KB 11303834401.05 GB2008-07-22 13:00:30
k-unique signatures (partition 5) 14,488,304790.08 KB 11559898001.08 GB2008-07-22 13:54:53
k-unique signatures (partition 6) 17,254,066790.08 KB 13766796761.28 GB2008-07-22 14:58:33
k-unique signatures (partition 7) 15,771,897790.08 KB 12584032601.17 GB2008-07-22 15:58:55
k-unique signatures (partition 8) 62,635,285790.08 KB 49975032524.65 GB2008-07-22 19:40:06
k-unique signatures (partition 9) 1,136,806790.08 KB 9069070886.49 MB2008-07-22 12:12:14
transmission 2,048210.02 KB 4300842.00 KB2009-05-05 05:10:48
transmission_cvterm 3170.02 KB 510.05 KB2009-05-05 03:35:02
transmission_dbxref 2,048130.01 KB 2662426.00 KB2009-05-05 05:10:50
transmission_pub 2,493130.01 KB 3240931.65 KB2009-05-05 05:10:53
transmissionprop 226240.02 KB 54245.30 KB2009-05-05 05:10:55

Organisms

Total OrganismsTotal virusesTotal non-virusesplasmidsmRNAschromosomesDNARNAssingle stranded DNA chromosomesds RNA viral sequencesnegative sense ssRNA viral sequencespostive sense ssRNA viral sequencesss-RNAsss-DNAs
8,3415,5062,8351,2728,5631,570,1351,540,8484665152019,4421,33133

Features

polypeptidesexonspromotersintronsrRNAstRNAsCDSassembliestranscriptsgenes
3,214,7563,660,51053188910,62353,2193,214,7581,570,4933,209,8463,334,621