|
|---|
| |
Database: hg16 Primary Table: all_est Row Count: 8,199,967 Data last updated: 2019-09-21
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 | 393 | int(10) unsigned | Number of bases that match that aren't repeats |
| misMatches | 7 | 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 | AA936549 | varchar(255) | Query sequence name |
| qSize | 409 | int(10) unsigned | Query sequence size |
| qStart | 9 | int(10) unsigned | Alignment start position in query |
| qEnd | 409 | int(10) unsigned | Alignment end position in query |
| tName | chr1 | varchar(255) | Target sequence name |
| tSize | 246127941 | int(10) unsigned | Target sequence size |
| tStart | 4224 | int(10) unsigned | Alignment start position in target |
| tEnd | 4624 | int(10) unsigned | Alignment end position in target |
| blockCount | 1 | int(10) unsigned | Number of blocks in alignment |
| blockSizes | 400, | longblob | Size of each block |
| qStarts | 9, | longblob | Start of each block in query. |
| tStarts | 4224, | 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 | 393 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | + | AA936549 | 409 | 9 | 409 | chr1 | 246127941 | 4224 | 4624 | 1 | 400, | 9, | 4224, |
| 585 | 372 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | + | AA293168 | 380 | 0 | 380 | chr1 | 246127941 | 4263 | 4643 | 1 | 380, | 0, | 4263, |
| 585 | 391 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | + | AA458890 | 399 | 0 | 399 | chr1 | 246127941 | 4263 | 4662 | 1 | 399, | 0, | 4263, |
| 585 | 442 | 2 | 0 | 0 | 3 | 7 | 1 | 140 | + | AA478024 | 451 | 0 | 451 | chr1 | 246127941 | 4264 | 4848 | 5 | 58,270,24,76,16, | 0,63,334,359,435, | 4264,4322,4592,4616,4832, |
| 585 | 451 | 2 | 0 | 0 | 1 | 5 | 1 | 140 | + | AA279139 | 471 | 13 | 471 | chr1 | 246127941 | 4266 | 4859 | 3 | 56,370,27, | 13,74,444, | 4266,4322,4832, |
| 585 | 468 | 10 | 0 | 1 | 2 | 89 | 3 | 158 | + | AA853941 | 605 | 1 | 569 | chr1 | 246127941 | 4266 | 4903 | 5 | 52,55,16,285,71, | 1,58,197,213,498, | 4266,4318,4390,4407,4832, |
| 585 | 396 | 5 | 37 | 0 | 0 | 0 | 4 | 11151 | + | AA588542 | 468 | 30 | 468 | chr1 | 246127941 | 4266 | 15855 | 5 | 108,90,3,157,80, | 30,138,228,231,388, | 4266,4376,4467,6469,15775, |
| 585 | 468 | 4 | 0 | 0 | 1 | 5 | 1 | 140 | + | AA565014 | 477 | 0 | 477 | chr1 | 246127941 | 4267 | 4879 | 3 | 55,370,47, | 0,60,430, | 4267,4322,4832, |
| 585 | 187 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | AA411542 | 187 | 0 | 187 | chr1 | 246127941 | 4268 | 4455 | 1 | 187, | 0, | 4268, |
| 585 | 399 | 4 | 0 | 0 | 1 | 6 | 1 | 6 | + | AA485730 | 409 | 0 | 409 | chr1 | 246127941 | 4268 | 4677 | 3 | 305,9,89, | 0,311,320, | 4268,4573,4588, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server