| field | example | SQL type | description |
|---|---|---|---|
| bin | 585 | smallint(5) unsigned | Indexing field to speed chromosome range queries. |
| chrom | chr1 | varchar(255) | Reference sequence chromosome or scaffold |
| chromStart | 10917 | int(10) unsigned | Start position in chromosome |
| chromEnd | 11941 | int(10) unsigned | End position in chromosome |
| name | chr1.0 | varchar(255) | Name of item |
| span | 1 | int(10) unsigned | each value spans this many bases |
| count | 1024 | int(10) unsigned | number of values in this block |
| offset | 0 | int(10) unsigned | offset in File to fetch data |
| file | /gbdb/hg19/multiz46way/phyl... | varchar(255) | path name to data file, one byte per value |
| lowerLimit | -2.884 | double | lowest data value in this block |
| dataRange | 3.751 | double | lowerLimit + dataRange = upperLimit |
| validCount | 1024 | int(10) unsigned | number of valid data values in this block |
| sumData | -51.824 | double | sum of the data points, for average and stddev calc |
| sumSquares | 439.636 | double | sum of data points squared, for stddev calc |
| bin | chrom | chromStart | chromEnd | name | span | count | offset | file | lowerLimit | dataRange | validCount | sumData | sumSquares |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 585 | chr1 | 10917 | 11941 | chr1.0 | 1 | 1024 | 0 | /gbdb/hg19/multiz46way/phyloP46wayPlacental.wib | -2.884 | 3.751 | 1024 | -51.824 | 439.636 |
| 585 | chr1 | 11941 | 12965 | chr1.1 | 1 | 1024 | 1024 | /gbdb/hg19/multiz46way/phyloP46wayPlacental.wib | -3.784 | 4.614 | 1024 | 18.452 | 584.967 |
| 585 | chr1 | 12965 | 13989 | chr1.2 | 1 | 1024 | 2048 | /gbdb/hg19/multiz46way/phyloP46wayPlacental.wib | -4.463 | 5.256 | 1024 | 13.497 | 619.992 |
| 585 | chr1 | 13989 | 15013 | chr1.3 | 1 | 1024 | 3072 | /gbdb/hg19/multiz46way/phyloP46wayPlacental.wib | -2.955 | 3.748 | 1024 | 124.943 | 520.224 |
| 585 | chr1 | 15013 | 16037 | chr1.4 | 1 | 1024 | 4096 | /gbdb/hg19/multiz46way/phyloP46wayPlacental.wib | -4.574 | 5.367 | 1024 | -10.212 | 609.317 |
| 585 | chr1 | 16037 | 17061 | chr1.5 | 1 | 1024 | 5120 | /gbdb/hg19/multiz46way/phyloP46wayPlacental.wib | -3.003 | 3.796 | 1024 | 132.87 | 492.162 |
| 585 | chr1 | 17061 | 18085 | chr1.6 | 1 | 1024 | 6144 | /gbdb/hg19/multiz46way/phyloP46wayPlacental.wib | -3.287 | 4.415 | 1024 | 187.27 | 581.024 |
| 585 | chr1 | 18085 | 19109 | chr1.7 | 1 | 1024 | 7168 | /gbdb/hg19/multiz46way/phyloP46wayPlacental.wib | -3.139 | 4.07 | 1024 | 41.172 | 488.423 |
| 585 | chr1 | 19109 | 20133 | chr1.8 | 1 | 1024 | 8192 | /gbdb/hg19/multiz46way/phyloP46wayPlacental.wib | -3.794 | 4.725 | 1024 | -20.879 | 575.903 |
| 585 | chr1 | 20133 | 21157 | chr1.9 | 1 | 1024 | 9216 | /gbdb/hg19/multiz46way/phyloP46wayPlacental.wib | -3.726 | 4.657 | 1024 | 14.749 | 580.199 |
Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.