Schema for DB Cactus 241-way - DB table version Cactus Alignment & Conservation of Placental Mammals from Zoonomia Project (241 Species)
  Database: hg38    Primary Table: phyloP241way    Row Count: 2,787,340   Data last updated: 2021-04-25
Format description: Wiggle track values to display as y-values (first 6 fields are bed6)
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 10074int(10) unsigned Start position in chromosome
chromEnd 11098int(10) unsigned End position in chromosome
name chr1.920165varchar(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 941815562int(10) unsigned offset in File to fetch data
file /gbdb/hg38/cactus241way/phy...varchar(255) path name to data file, one byte per value
lowerLimit -4.522double lowest data value in this block
dataRange 4.614double lowerLimit + dataRange = upperLimit
validCount 1024int(10) unsigned number of valid data values in this block
sumData -187.227double sum of the data points, for average and stddev calc
sumSquares 506.714double sum of data points squared, for stddev calc

Sample Rows
 
binchromchromStartchromEndnamespancountoffsetfilelowerLimitdataRangevalidCountsumDatasumSquares
585chr11007411098chr1.92016511024941815562/gbdb/hg38/cactus241way/phyloP241way.wib-4.5224.6141024-187.227506.714
585chr11109812122chr1.92016611024941816586/gbdb/hg38/cactus241way/phyloP241way.wib-8.66117.062102438.5443232.05
585chr11212213146chr1.92016711024941817610/gbdb/hg38/cactus241way/phyloP241way.wib-9.54618.4171024643.9648178.19
585chr11314614170chr1.92016811024941818634/gbdb/hg38/cactus241way/phyloP241way.wib-15.25624.1221024587.5545727.87
585chr11417015194chr1.92016911024941819658/gbdb/hg38/cactus241way/phyloP241way.wib-15.95524.7541024554.5687533.83
585chr11519416218chr1.92017011024941820682/gbdb/hg38/cactus241way/phyloP241way.wib-6.93315.7771024434.0256149.57
585chr11621817242chr1.92017111024941821706/gbdb/hg38/cactus241way/phyloP241way.wib-2028.8891024695.72412391.2
585chr11724218266chr1.92017211024941822730/gbdb/hg38/cactus241way/phyloP241way.wib-15.17624.0610241353.813939
585chr11826619290chr1.92017311024941823754/gbdb/hg38/cactus241way/phyloP241way.wib-8.99317.8781024117.2635101.41
585chr11929020314chr1.92017411024941824778/gbdb/hg38/cactus241way/phyloP241way.wib-5.76110.6151024-26.3821403.7

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