df66e5b7936616048e5503a03196ef1684a63a07
kate
  Wed Mar 16 12:07:50 2016 -0700
New schema for GTEX gene bed file.  Removes bogus transcriptId and replaces transcriptClass with geneType. refs #15645

diff --git src/hg/lib/gtexGeneBed.sql src/hg/lib/gtexGeneBed.sql
index e676a58..29869db 100644
--- src/hg/lib/gtexGeneBed.sql
+++ src/hg/lib/gtexGeneBed.sql
@@ -1,21 +1,20 @@
 # 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
-    transcriptId varchar(255) not null,	# Ensembl ID of Canonical transcript; determines genomic position
-    transcriptClass varchar(255) not null,	# GENCODE transcript class (coding, nonCoding, pseudo)
+    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)
 );