d09b392333a2f5d2f943f2f36dad4be0a477381e
kate
  Thu Sep 14 13:55:37 2017 -0700
Add pvalue and TSS distance for each eQTL. Input from Casey Brown, U Penn. refs #15646

diff --git src/hg/lib/gtexEqtlCluster.sql src/hg/lib/gtexEqtlCluster.sql
index beff5ad..2cbd530 100644
--- src/hg/lib/gtexEqtlCluster.sql
+++ src/hg/lib/gtexEqtlCluster.sql
@@ -1,22 +1,24 @@
 # 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)
+    distance int not null,	# Distance from TSS
     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
+    expPvals longblob not null,	# Comma separated list of -log10 transformed p-values
     expProbs longblob not null,	# Comma separated list of probability variant is in causal set
               #Indices
     INDEX chrom (chrom,bin),
     INDEX gene  (target)
 );