9e2a8a0b99b50e87a71b0bf1f9f6df74f06c708e kate Mon Aug 15 12:48:20 2016 -0700 Finish up ASE tracks. Polish hub for release. refs #17885 diff --git src/hg/lib/gtexAse.sql src/hg/lib/gtexAse.sql index 952d44e..098d361 100644 --- src/hg/lib/gtexAse.sql +++ src/hg/lib/gtexAse.sql @@ -3,26 +3,26 @@ # 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 itemRgb int unsigned not null, # Color by ASE value medianASE float not null, # Allelic imbalance (0-.5) median - coverage float not null, # RNA-seq reads overlapping this position + coverage float not null, # RNA-seq reads overlapping this position (median) samples int unsigned not null, # Sample count donors int unsigned not null, # Donor count minASE float not null, # Minimum ASE q1ASE float not null, # Q1 ASE q3ASE float not null, # Q3 ASE maxASE float not null, # Maximum ASE stdASE float not null, # ASE standard deviation #Indices INDEX(chrom(20), chromStart) );