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/gtexTissueMedian.sql src/hg/lib/gtexTissueMedian.sql
new file mode 100644
index 0000000..6f3bf90
--- /dev/null
+++ src/hg/lib/gtexTissueMedian.sql
@@ -0,0 +1,13 @@
+# gtexTissueMedian.sql was originally generated by the autoSql program, which also 
+# generated gtexTissueMedian.c and gtexTissueMedian.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)
+CREATE TABLE gtexTissueMedian (
+    geneId varchar(255) not null,	# Gene identifier (ensembl)
+    tissueCount int unsigned not null,	# Number of tissues
+    scores longblob not null,	# RPKM median expression levels
+              #Indices
+    PRIMARY KEY(geneId)
+);