Schema for Vertebrate Cons - Vertebrate Conservation by PhastCons
Database: hg19    Primary Table: phastCons46way    Row Count: 2,808,750
Format description: Wiggle track values to display as y-values (first 6 fields are bed6)
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 10917int(10) unsigned Start position in chromosome
chromEnd 11941int(10) unsigned End position in chromosome
name chr1.0varchar(255) Name of item
span 1int(10) unsigned each value spans this many bases
count 1024int(10) unsigned number of values in this block
offset 0int(10) unsigned offset in File to fetch data
file /gbdb/hg19/multiz46way/phas...varchar(255) path name to data file, one byte per value
lowerLimit 0double lowest data value in this block
dataRange 0.384double lowerLimit + dataRange = upperLimit
validCount 1024int(10) unsigned number of valid data values in this block
sumData 64.731double sum of the data points, for average and stddev calc
sumSquares 12.8925double sum of data points squared, for stddev calc
Sample Rows
binchromchromStartchromEndnamespancountoffsetfilelowerLimitdataRangevalidCountsumDatasumSquares
585chr11091711941chr1.0110240/gbdb/hg19/multiz46way/phastCons46way.wib00.384102464.73112.8925
585chr11194112965chr1.1110241024/gbdb/hg19/multiz46way/phastCons46way.wib011024253.978234.139
585chr11296513989chr1.2110242048/gbdb/hg19/multiz46way/phastCons46way.wib011024242.398215.177
585chr11398915013chr1.3110243072/gbdb/hg19/multiz46way/phastCons46way.wib011024269.27231.397
585chr11501316037chr1.4110244096/gbdb/hg19/multiz46way/phastCons46way.wib011024228.599200.103
585chr11603717061chr1.5110245120/gbdb/hg19/multiz46way/phastCons46way.wib011024317.281283.605
585chr11706118085chr1.6110246144/gbdb/hg19/multiz46way/phastCons46way.wib011024471.588446.302
585chr11808519109chr1.7110247168/gbdb/hg19/multiz46way/phastCons46way.wib011024140.302120.129
585chr11910920133chr1.8110248192/gbdb/hg19/multiz46way/phastCons46way.wib00.68102435.2459.63821
585chr12013321157chr1.9110249216/gbdb/hg19/multiz46way/phastCons46way.wib00.914102461.25227.3045

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.