| 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/phas... | varchar(255) | path name to data file, one byte per value |
| lowerLimit | 0 | double | lowest data value in this block |
| dataRange | 0.384 | double | lowerLimit + dataRange = upperLimit |
| validCount | 1024 | int(10) unsigned | number of valid data values in this block |
| sumData | 64.731 | double | sum of the data points, for average and stddev calc |
| sumSquares | 12.8925 | 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/phastCons46way.wib | 0 | 0.384 | 1024 | 64.731 | 12.8925 |
| 585 | chr1 | 11941 | 12965 | chr1.1 | 1 | 1024 | 1024 | /gbdb/hg19/multiz46way/phastCons46way.wib | 0 | 1 | 1024 | 253.978 | 234.139 |
| 585 | chr1 | 12965 | 13989 | chr1.2 | 1 | 1024 | 2048 | /gbdb/hg19/multiz46way/phastCons46way.wib | 0 | 1 | 1024 | 242.398 | 215.177 |
| 585 | chr1 | 13989 | 15013 | chr1.3 | 1 | 1024 | 3072 | /gbdb/hg19/multiz46way/phastCons46way.wib | 0 | 1 | 1024 | 269.27 | 231.397 |
| 585 | chr1 | 15013 | 16037 | chr1.4 | 1 | 1024 | 4096 | /gbdb/hg19/multiz46way/phastCons46way.wib | 0 | 1 | 1024 | 228.599 | 200.103 |
| 585 | chr1 | 16037 | 17061 | chr1.5 | 1 | 1024 | 5120 | /gbdb/hg19/multiz46way/phastCons46way.wib | 0 | 1 | 1024 | 317.281 | 283.605 |
| 585 | chr1 | 17061 | 18085 | chr1.6 | 1 | 1024 | 6144 | /gbdb/hg19/multiz46way/phastCons46way.wib | 0 | 1 | 1024 | 471.588 | 446.302 |
| 585 | chr1 | 18085 | 19109 | chr1.7 | 1 | 1024 | 7168 | /gbdb/hg19/multiz46way/phastCons46way.wib | 0 | 1 | 1024 | 140.302 | 120.129 |
| 585 | chr1 | 19109 | 20133 | chr1.8 | 1 | 1024 | 8192 | /gbdb/hg19/multiz46way/phastCons46way.wib | 0 | 0.68 | 1024 | 35.245 | 9.63821 |
| 585 | chr1 | 20133 | 21157 | chr1.9 | 1 | 1024 | 9216 | /gbdb/hg19/multiz46way/phastCons46way.wib | 0 | 0.914 | 1024 | 61.252 | 27.3045 |
Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.