|
|---|
| |
Database: hg19 Primary Table: all_est Row Count: 9,238,188 Data last updated: 2019-09-19
Format description: Summary info about a patSpace alignment
On download server: MariaDB table dump directory
| field | example | SQL type | description |
|---|
| bin | 585 | smallint(5) unsigned | Indexing field to speed chromosome range queries. |
| matches | 468 | int(10) unsigned | Number of bases that match that aren't repeats |
| misMatches | 10 | 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 | 1 | int(10) unsigned | Number of 'N' bases |
| qNumInsert | 2 | int(10) unsigned | Number of inserts in query |
| qBaseInsert | 89 | int(10) unsigned | Number of bases inserted in query |
| tNumInsert | 3 | int(10) unsigned | Number of inserts in target |
| tBaseInsert | 158 | int(10) unsigned | Number of bases inserted in target |
| strand | + | char(2) | + or - for strand. First character query, second target (optional) |
| qName | AA853941 | varchar(255) | Query sequence name |
| qSize | 605 | int(10) unsigned | Query sequence size |
| qStart | 1 | int(10) unsigned | Alignment start position in query |
| qEnd | 569 | int(10) unsigned | Alignment end position in query |
| tName | chr1 | varchar(255) | Target sequence name |
| tSize | 249250621 | int(10) unsigned | Target sequence size |
| tStart | 14403 | int(10) unsigned | Alignment start position in target |
| tEnd | 15040 | int(10) unsigned | Alignment end position in target |
| blockCount | 5 | int(10) unsigned | Number of blocks in alignment |
| blockSizes | 52,55,16,285,71, | longblob | Size of each block |
| qStarts | 1,58,197,213,498, | longblob | Start of each block in query. |
| tStarts | 14403,14455,14527,14544,14969, | 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 | 468 | 10 | 0 | 1 | 2 | 89 | 3 | 158 | + | AA853941 | 605 | 1 | 569 | chr1 | 249250621 | 14403 | 15040 | 5 | 52,55,16,285,71, | 1,58,197,213,498, | 14403,14455,14527,14544,14969, |
| 585 | 187 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | AA411542 | 187 | 0 | 187 | chr1 | 249250621 | 14405 | 14592 | 1 | 187, | 0, | 14405, |
| 585 | 258 | 6 | 0 | 4 | 1 | 2 | 1 | 1 | - | AA321532 | 270 | 0 | 270 | chr1 | 249250621 | 14509 | 14778 | 2 | 89,179, | 0,91, | 14509,14599, |
| 585 | 324 | 7 | 0 | 0 | 0 | 0 | 4 | 899 | - | AA552581 | 337 | 6 | 337 | chr1 | 249250621 | 14654 | 15884 | 5 | 129,45,69,50,38, | 0,129,174,243,293, | 14654,14784,14969,15795,15846, |
| 585 | 276 | 2 | 0 | 5 | 2 | 2 | 3 | 973 | - | AA378877 | 299 | 13 | 298 | chr1 | 249250621 | 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 | 249250621 | 16441 | 16763 | 1 | 322, | 4, | 16441, |
| 585 | 412 | 4 | 0 | 0 | 0 | 0 | 2 | 1199 | + | AA934583 | 422 | 6 | 422 | chr1 | 249250621 | 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 | 249250621 | 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 | 249250621 | 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 | 249250621 | 16745 | 16934 | 4 | 20,53,13,9, | 0,20,73,86, | 16745,16857,16911,16925, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server