| 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.525 | double | lowest data value in this block |
| dataRange | 2.796 | double | lowerLimit + dataRange = upperLimit |
| validCount | 1024 | int(10) unsigned | number of valid data values in this block |
| sumData | -58.49 | double | sum of the data points, for average and stddev calc |
| sumSquares | 301.144 | 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/phyloP46wayPrimates.wib | -2.525 | 2.796 | 1024 | -58.49 | 301.144 |
| 585 | chr1 | 11941 | 12965 | chr1.1 | 1 | 1024 | 1024 | /gbdb/hg19/multiz46way/phyloP46wayPrimates.wib | -3.91 | 4.199 | 1024 | -40.509 | 311.968 |
| 585 | chr1 | 12965 | 13989 | chr1.2 | 1 | 1024 | 2048 | /gbdb/hg19/multiz46way/phyloP46wayPrimates.wib | -3.735 | 3.919 | 1024 | -41.118 | 307.183 |
| 585 | chr1 | 13989 | 15013 | chr1.3 | 1 | 1024 | 3072 | /gbdb/hg19/multiz46way/phyloP46wayPrimates.wib | -3.594 | 3.778 | 1024 | 50.895 | 189.576 |
| 585 | chr1 | 15013 | 16037 | chr1.4 | 1 | 1024 | 4096 | /gbdb/hg19/multiz46way/phyloP46wayPrimates.wib | -3.173 | 3.357 | 1024 | 18.93 | 214.706 |
| 585 | chr1 | 16037 | 17061 | chr1.5 | 1 | 1024 | 5120 | /gbdb/hg19/multiz46way/phyloP46wayPrimates.wib | -3.666 | 3.85 | 1024 | 45.495 | 188.234 |
| 585 | chr1 | 17061 | 18085 | chr1.6 | 1 | 1024 | 6144 | /gbdb/hg19/multiz46way/phyloP46wayPrimates.wib | -1.499 | 1.683 | 1024 | 86.199 | 132.37 |
| 585 | chr1 | 18085 | 19109 | chr1.7 | 1 | 1024 | 7168 | /gbdb/hg19/multiz46way/phyloP46wayPrimates.wib | -2.819 | 3.003 | 1024 | 34.609 | 195.032 |
| 585 | chr1 | 19109 | 20133 | chr1.8 | 1 | 1024 | 8192 | /gbdb/hg19/multiz46way/phyloP46wayPrimates.wib | -3.099 | 3.283 | 1024 | 38.196 | 194.668 |
| 585 | chr1 | 20133 | 21157 | chr1.9 | 1 | 1024 | 9216 | /gbdb/hg19/multiz46way/phyloP46wayPrimates.wib | -3.214 | 3.398 | 1024 | 7.408 | 231.051 |
Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.