3a63c684fc647b345d52e96147b3344453b3d28a
kate
  Fri Jul 31 10:12:14 2015 -0700
1. Fix tissue ordering problem (hgGtex). 2. Add stats table (rename gtexTissueData to gtexTissueMedian and use gtexTissueData for stats.  3. Extend gtexInfo table.refs #15645

diff --git src/hg/lib/gtexTissueData.sql src/hg/lib/gtexTissueData.sql
index 47b69af..8c18699 100644
--- src/hg/lib/gtexTissueData.sql
+++ src/hg/lib/gtexTissueData.sql
@@ -1,13 +1,18 @@
 # gtexTissueData.sql was originally generated by the autoSql program, which also 
 # generated gtexTissueData.c and gtexTissueData.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
-#GTEX Expression median level by tissue (RPKM levels, unmapped)
+#GTEX Expression data summarized by tissue (RPKM)
 CREATE TABLE gtexTissueData (
     geneId varchar(255) not null,	# Gene identifier (ensembl)
-    tissueCount int unsigned not null,	# Number of tissues
-    scores longblob not null,	# RPKM median expression levels
+    tissue varchar(255) not null,	# Tissue short name
+    min double not null,	# Minimum expression level
+    q1 double not null,	# 1st quartile expression level
+    median double not null,	# Median expression level
+    q3 double not null,	# 3rd quartile expression level
+    max double not null,	# Maximum expression level
               #Indices
-    PRIMARY KEY(geneId)
+    INDEX(geneId),
+    INDEX(tissue)
 );