5bdc0c1e3a2e6a4bccc42597fd123ef594a634ce kate Thu Oct 5 14:55:00 2017 -0700 Fix 95% set definition again, as per Farhad Hormozdiari (author of CAVIAR). refs #15646 diff --git src/hg/lib/gtexEqtl.sql src/hg/lib/gtexEqtl.sql index ab22e7b..05200d6 100644 --- src/hg/lib/gtexEqtl.sql +++ src/hg/lib/gtexEqtl.sql @@ -1,29 +1,29 @@ # gtexEqtl.sql was originally generated by the autoSql program, which also # generated gtexEqtl.c and gtexEqtl.h. This creates the database representation of # an object which can be loaded and saved from RAM in a fairly # automatic way. #BED 9+ of expression Quantitative Trait Loci (eQTL). These are variants affecting gene expression CREATE TABLE gtexEqtl ( 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, # Variant/gene score int unsigned not null, # Score from 0-1000 (highest probabiliity in cluster * 1000) strand char(1) not null, # . thickStart int unsigned not null, # Start position thickEnd int unsigned not null, # End position reserved int unsigned not null, # R,G,B color: red +effect, blue -effect. Bright for high, pale for lower (cutoff effectSize 2.0 RPKM). variant varchar(255) not null, # Variant (rsID or GTEx identifier if none) gene varchar(255) not null, # Target gene distance int not null, # Distance from TSS effectSize float not null, # Effect size (FPKM) pValue float not null, # Nominal p-value - causalProb float not null, # Probability variant is causal + causalProb float not null, # Probability variant is in 95 percent credible set #Indices INDEX (chrom,bin), PRIMARY KEY (name), INDEX (gene), INDEX (variant) );