|
|---|
| |
Database: hg17 Primary Table: est (chr1_est) Row Count: 803,979 Data last updated: 2016-05-06
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 | 245522847 | int(10) unsigned | Target sequence size |
| tStart | 4266 | int(10) unsigned | Alignment start position in target |
| tEnd | 4903 | 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 | 4266,4318,4390,4407,4832, | 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 | 245522847 | 4266 | 4903 | 5 | 52,55,16,285,71, | 1,58,197,213,498, | 4266,4318,4390,4407,4832, |
| 585 | 187 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | AA411542 | 187 | 0 | 187 | chr1 | 245522847 | 4268 | 4455 | 1 | 187, | 0, | 4268, |
| 585 | 399 | 4 | 0 | 0 | 1 | 6 | 1 | 6 | + | AA485730 | 409 | 0 | 409 | chr1 | 245522847 | 4268 | 4677 | 3 | 305,9,89, | 0,311,320, | 4268,4573,4588, |
| 585 | 421 | 7 | 26 | 0 | 1 | 3 | 4 | 2136 | + | AA733167 | 457 | 0 | 457 | chr1 | 245522847 | 4268 | 6858 | 5 | 139,135,45,59,76, | 0,139,274,319,381, | 4268,4408,6586,6719,6782, |
| 585 | 258 | 6 | 0 | 4 | 1 | 2 | 1 | 1 | - | AA321532 | 270 | 0 | 270 | chr1 | 245522847 | 4372 | 4641 | 2 | 89,179, | 0,91, | 4372,4462, |
| 585 | 324 | 7 | 0 | 0 | 0 | 0 | 4 | 899 | - | AA552581 | 337 | 6 | 337 | chr1 | 245522847 | 4517 | 5747 | 5 | 129,45,69,50,38, | 0,129,174,243,293, | 4517,4647,4832,5658,5709, |
| 585 | 276 | 2 | 0 | 5 | 2 | 2 | 3 | 973 | - | AA378877 | 299 | 13 | 298 | chr1 | 245522847 | 5662 | 6918 | 6 | 12,7,12,5,60,187, | 1,13,21,34,39,99, | 5662,5683,5690,5702,5708,6731, |
| 585 | 282 | 3 | 37 | 0 | 0 | 0 | 0 | 0 | + | AA843580 | 326 | 4 | 326 | chr1 | 245522847 | 6304 | 6626 | 1 | 322, | 4, | 6304, |
| 585 | 412 | 4 | 0 | 0 | 0 | 0 | 2 | 1199 | + | AA934583 | 422 | 6 | 422 | chr1 | 245522847 | 6304 | 7919 | 3 | 188,86,142, | 6,194,280, | 6304,7519,7777, |
| 585 | 375 | 1 | 37 | 0 | 0 | 0 | 4 | 267 | - | AA278412 | 413 | 0 | 413 | chr1 | 245522847 | 6481 | 7161 | 5 | 150,52,11,134,66, | 0,150,202,213,347, | 6481,6719,6772,6784,7095, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server