|
|---|
| |
Database: hg38 Primary Table: all_est Row Count: 10,001,332 Data last updated: 2019-09-20
Format description: Summary info about a patSpace alignment
| field | example | SQL type | description |
|---|
| bin | 585 | smallint(5) unsigned | Indexing field to speed chromosome range queries. |
| matches | 187 | int(10) unsigned | Number of bases that match that aren't repeats |
| misMatches | 0 | int(10) unsigned | Number of bases that don't match |
| repMatches | 0 | int(10) unsigned | Number of bases that match but are part of repeats |
| nCount | 0 | int(10) unsigned | Number of 'N' bases |
| qNumInsert | 0 | int(10) unsigned | Number of inserts in query |
| qBaseInsert | 0 | int(10) unsigned | Number of bases inserted in query |
| tNumInsert | 0 | int(10) unsigned | Number of inserts in target |
| tBaseInsert | 0 | int(10) unsigned | Number of bases inserted in target |
| strand | - | char(2) | + or - for strand. First character query, second target (optional) |
| qName | AA411542 | varchar(255) | Query sequence name |
| qSize | 187 | int(10) unsigned | Query sequence size |
| qStart | 0 | int(10) unsigned | Alignment start position in query |
| qEnd | 187 | int(10) unsigned | Alignment end position in query |
| tName | chr1 | varchar(255) | Target sequence name |
| tSize | 248956422 | int(10) unsigned | Target sequence size |
| tStart | 14405 | int(10) unsigned | Alignment start position in target |
| tEnd | 14592 | int(10) unsigned | Alignment end position in target |
| blockCount | 1 | int(10) unsigned | Number of blocks in alignment |
| blockSizes | 187, | longblob | Size of each block |
| qStarts | 0, | longblob | Start of each block in query. |
| tStarts | 14405, | longblob | Start of each block in target. |
|
| |
|
|
|
Connected Tables and Joining Fields
|
|
|
Sample Rows
|
|---|
| |
| bin | matches | misMatches | repMatches | nCount | qNumInsert | qBaseInsert | tNumInsert | tBaseInsert | strand | qName | qSize | qStart | qEnd | tName | tSize | tStart | tEnd | blockCount | blockSizes | qStarts | tStarts |
|---|
| 585 | 187 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | AA411542 | 187 | 0 | 187 | chr1 | 248956422 | 14405 | 14592 | 1 | 187, | 0, | 14405, |
| 585 | 258 | 6 | 0 | 4 | 1 | 2 | 1 | 1 | - | AA321532 | 270 | 0 | 270 | chr1 | 248956422 | 14509 | 14778 | 2 | 89,179, | 0,91, | 14509,14599, |
| 585 | 276 | 2 | 0 | 5 | 2 | 2 | 3 | 973 | - | AA378877 | 299 | 13 | 298 | chr1 | 248956422 | 15799 | 17055 | 6 | 12,7,12,5,60,187, | 1,13,21,34,39,99, | 15799,15820,15827,15839,15845,16868, |
| 585 | 319 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | + | AA843580 | 326 | 4 | 326 | chr1 | 248956422 | 16441 | 16763 | 1 | 322, | 4, | 16441, |
| 585 | 412 | 4 | 0 | 0 | 0 | 0 | 2 | 1199 | + | AA934583 | 422 | 6 | 422 | chr1 | 248956422 | 16441 | 18056 | 3 | 188,86,142, | 6,194,280, | 16441,17656,17914, |
| 585 | 412 | 1 | 0 | 0 | 0 | 0 | 4 | 267 | - | AA278412 | 413 | 0 | 413 | chr1 | 248956422 | 16618 | 17298 | 5 | 150,52,11,134,66, | 0,150,202,213,347, | 16618,16856,16909,16921,17232, |
| 585 | 470 | 8 | 0 | 0 | 0 | 0 | 5 | 7629 | - | AA434149 | 481 | 3 | 481 | chr1 | 248956422 | 16696 | 24803 | 6 | 42,92,32,147,99,66, | 0,42,134,166,313,412, | 16696,17617,17710,17914,18267,24737, |
| 585 | 95 | 0 | 0 | 0 | 0 | 0 | 3 | 94 | - | AA291826 | 95 | 0 | 95 | chr1 | 248956422 | 16745 | 16934 | 4 | 20,53,13,9, | 0,20,73,86, | 16745,16857,16911,16925, |
| 585 | 350 | 1 | 0 | 1 | 6 | 13 | 4 | 280 | - | AA079569 | 413 | 48 | 413 | chr1 | 248956422 | 16758 | 17390 | 9 | 10,3,70,35,5,35,54,132,8, | 0,10,13,84,120,126,162,218,357, | 16758,16852,16858,16928,16963,16968,17003,17236,17382, |
| 585 | 283 | 2 | 0 | 0 | 9 | 19 | 4 | 420 | - | AA084023 | 342 | 9 | 313 | chr1 | 248956422 | 16987 | 17692 | 11 | 4,4,11,10,9,9,10,4,12,125,87, | 29,34,39,57,69,79,90,101,107,121,246, | 16987,16991,16995,17010,17020,17029,17038,17048,17230,17243,17605, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server