d6039d2a5b455ea12543034b5f959886d6d7e51f
kate
  Thu Mar 24 20:45:39 2016 -0700
1. Add -log option to bedScore. 2. Score GTEx gene track bed files based on total median expression level across all tissues, for use in dense mode (gray-scale based on total expression), and display score on details page. 3. Implement viz for squished mode -- show color of highest expressed tissue if over threshold, and show tissue name in mouseover.  refs #15645

diff --git src/hg/lib/gtexGeneBed.sql src/hg/lib/gtexGeneBed.sql
index 29869db..ec3f563 100644
--- src/hg/lib/gtexGeneBed.sql
+++ src/hg/lib/gtexGeneBed.sql
@@ -1,20 +1,21 @@
 # gtexGeneBed.sql was originally generated by the autoSql program, which also 
 # generated gtexGeneBed.c and gtexGeneBed.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #BED6+ with additional fields for gene and transcript IDs, and expression experiment scores
 CREATE TABLE gtexGeneBed (
     chrom varchar(255) not null,	# Reference sequence chromosome or scaffold
     chromStart int unsigned not null,	# Start position in chromosome
     chromEnd int unsigned not null,	# End position in chromosome
     name varchar(255) not null,	# Gene symbol
     score int unsigned not null,	# Score from 0-1000
     strand char(1) not null,	# + or - for strand
     geneId varchar(255) not null,	# Ensembl gene ID, referenced in GTEx data tables
     geneType varchar(255) not null,	# GENCODE gene biotype
     expCount int unsigned not null,	# Number of experiment values
     expScores longblob not null,	# Comma separated list of experiment scores
               #Indices
-    PRIMARY KEY(chrom)
+    PRIMARY KEY(geneId),
+    INDEX(chrom(20), chromStart)
 );