ba22bbbe65670b6378e16e7d60a214102e600a8f
kate
  Thu Jun 30 19:10:06 2016 -0700
Initial load of GTEx ASE data from NY Genome Center (Analysis group lab)

diff --git src/hg/lib/gtexAse.sql src/hg/lib/gtexAse.sql
new file mode 100644
index 0000000..3e57170
--- /dev/null
+++ src/hg/lib/gtexAse.sql
@@ -0,0 +1,22 @@
+# gtexAse.sql was originally generated by the autoSql program, which also 
+# generated gtexAse.c and gtexAse.h.  This creates the database representation of
+# an object which can be loaded and saved from RAM in a fairly 
+# automatic way.
+
+#BED9+ with additional fields for ASE, coverage, and sample count
+CREATE TABLE gtexAse (
+    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,	# SNP Id
+    score int unsigned not null,	# Score from 0-1000; derived from median ASE level
+    strand char(1) not null,	# n/a
+    thickStart int unsigned not null,	# n/a
+    thickEnd int unsigned not null,	# n/a
+    rgb int unsigned not null,	# Color by ASE value
+    ASE float not null,	# Allelic imbalance (0-.5)
+    coverage float not null,	# RNA-seq reads overlapping this position
+    samples int unsigned not null,	# Sample count
+              #Indices
+    INDEX(chrom(20), chromStart)
+);