| field | example | SQL type | description |
|---|---|---|---|
| bin | 585 | smallint(5) unsigned | A field to speed indexing |
| chrom | chr1 | varchar(255) | Chromosome |
| chromStart | 52057 | int(10) unsigned | Start position in chrom |
| chromEnd | 52058 | int(10) unsigned | End position in chrom |
| name | G/C | varchar(255) | alleles |
| alleleCount | 2 | int(11) | number of alleles |
| alleleFreq | 2,2 | varchar(255) | comma separated list of frequency of each allele |
| alleleScores | 0,0 | varchar(255) | comma separated list of quality scores |
| bin | chrom | chromStart | chromEnd | name | alleleCount | alleleFreq | alleleScores |
|---|---|---|---|---|---|---|---|
| 585 | chr1 | 52057 | 52058 | G/C | 2 | 2,2 | 0,0 |
| 585 | chr1 | 52237 | 52238 | G | 1 | 1 | 0 |
| 585 | chr1 | 55544 | 55545 | T | 1 | 3 | 0 |
| 585 | chr1 | 56380 | 56381 | T/C | 2 | 1,4 | 0,0 |
| 585 | chr1 | 57951 | 57952 | C | 1 | 1 | 0 |
| 585 | chr1 | 58210 | 58211 | G | 1 | 1 | 0 |
| 585 | chr1 | 58770 | 58771 | T/C | 2 | 10,2 | 0,0 |
| 585 | chr1 | 61441 | 61442 | G | 1 | 2 | 0 |
| 585 | chr1 | 63267 | 63268 | T/C | 2 | 1,1 | 0,0 |
| 585 | chr1 | 69510 | 69511 | G | 1 | 1 | 0 |
Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.