95d35e7bc2de062c22bb4969d1d16bd1604b6f26
kate
  Mon Aug 3 23:21:12 2015 -0700
Schemas for GTEX exon and gene tracks. Likely interim. refs #15648

diff --git src/hg/lib/gtexGeneBed.sql src/hg/lib/gtexGeneBed.sql
new file mode 100644
index 0000000..e676a58
--- /dev/null
+++ src/hg/lib/gtexGeneBed.sql
@@ -0,0 +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
+    transcriptId varchar(255) not null,	# Ensembl ID of Canonical transcript; determines genomic position
+    transcriptClass varchar(255) not null,	# GENCODE transcript class (coding, nonCoding, pseudo)
+    expCount int unsigned not null,	# Number of experiment values
+    expScores longblob not null,	# Comma separated list of experiment scores
+              #Indices
+    PRIMARY KEY(chrom)
+);