108d2fdf0aa57ebca7e2a62a028ce2c30cbe8049
kate
  Wed Jul 5 14:51:47 2017 -0700
Cleanup before merge. refs #15646

diff --git src/hg/lib/gtexEqtlCluster.sql src/hg/lib/gtexEqtlCluster.sql
new file mode 100644
index 0000000..beff5ad
--- /dev/null
+++ src/hg/lib/gtexEqtlCluster.sql
@@ -0,0 +1,22 @@
+# gtexEqtlCluster.sql was originally generated by the autoSql program, which also 
+# generated gtexEqtlCluster.c and gtexEqtlCluster.h.  This creates the database representation of
+# an object which can be loaded and saved from RAM in a fairly 
+# automatic way.
+
+#BED5+ of eQTLs (variants affecting gene expression) with a target (gene or tissue), and lists of secondary targets (e.g. tissues or genes)
+CREATE TABLE gtexEqtlCluster (
+    bin smallint not null,              # Bin number for browser speedup
+    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,	# Name of variant (rsID or GTEx identifier if none)
+    score int unsigned not null,	# Score from 0-1000
+    target varchar(255) not null,	# Name of target (gene or tissue)
+    expCount int unsigned not null,	# Number of experiment values
+    expNames longblob not null,	# Comma separated list of experiment names (e.g. tissue or gene)
+    expScores longblob not null,	# Comma separated list of effect size values
+    expProbs longblob not null,	# Comma separated list of probability variant is in causal set
+              #Indices
+    INDEX chrom (chrom,bin),
+    INDEX gene  (target)
+);