|
|---|
| |
Database: sacCer1 Primary Table: est (chr1_est) Row Count: 378 Data last updated: 2016-04-18
Format description: Summary info about a patSpace alignment
On download server: MariaDB table dump directory
| field | example | SQL type | info | description |
|---|
| bin | 585 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
| matches | 442 | int(10) unsigned | range | Number of bases that match that aren't repeats |
| misMatches | 5 | int(10) unsigned | range | Number of bases that don't match |
| repMatches | 0 | int(10) unsigned | range | Number of bases that match but are part of repeats |
| nCount | 0 | int(10) unsigned | range | Number of 'N' bases |
| qNumInsert | 9 | int(10) unsigned | range | Number of inserts in query |
| qBaseInsert | 25 | int(10) unsigned | range | Number of bases inserted in query |
| tNumInsert | 3 | int(10) unsigned | range | Number of inserts in target |
| tBaseInsert | 15 | int(10) unsigned | range | Number of bases inserted in target |
| strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
| qName | AA417479 | varchar(255) | values | Query sequence name |
| qSize | 472 | int(10) unsigned | range | Query sequence size |
| qStart | 0 | int(10) unsigned | range | Alignment start position in query |
| qEnd | 472 | int(10) unsigned | range | Alignment end position in query |
| tName | chr1 | varchar(255) | values | Target sequence name |
| tSize | 230208 | int(10) unsigned | range | Target sequence size |
| tStart | 51171 | int(10) unsigned | range | Alignment start position in target |
| tEnd | 51633 | int(10) unsigned | range | Alignment end position in target |
| blockCount | 11 | int(10) unsigned | range | Number of blocks in alignment |
| blockSizes | 14,5,4,12,16,8,13,15,11,20,... | longblob | | Size of each block |
| qStarts | 0,23,29,34,54,71,80,94,110,... | longblob | | Start of each block in query. |
| tStarts | 51171,51193,51198,51202,512... | 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 | 442 | 5 | 0 | 0 | 9 | 25 | 3 | 15 | - | AA417479 | 472 | 0 | 472 | chr1 | 230208 | 51171 | 51633 | 11 | 14,5,4,12,16,8,13,15,11,20,329, | 0,23,29,34,54,71,80,94,110,123,143, | 51171,51193,51198,51202,51220,51236,51244,51257,51272,51283,51304, |
| 586 | 457 | 1 | 0 | 0 | 7 | 14 | 3 | 5 | - | AA417480 | 472 | 0 | 472 | chr1 | 230208 | 146593 | 147056 | 8 | 5,4,10,8,10,20,40,361, | 0,6,11,25,34,46,70,111, | 146593,146598,146602,146614,146622,146633,146655,146695, |
| 586 | 381 | 0 | 0 | 1 | 1 | 1 | 2 | 4 | + | AA417481 | 390 | 7 | 390 | chr1 | 230208 | 160868 | 161254 | 3 | 24,342,16, | 7,32,374, | 160868,160895,161238, |
| 586 | 279 | 5 | 0 | 3 | 0 | 0 | 0 | 0 | - | AA417477 | 287 | 0 | 287 | chr1 | 230208 | 187934 | 188221 | 1 | 287, | 0, | 187934, |
| 585 | 547 | 4 | 0 | 0 | 0 | 0 | 1 | 1 | - | DB638289 | 551 | 0 | 551 | chr1 | 230208 | 4924 | 5476 | 2 | 157,394, | 0,157, | 4924,5082, |
| 585 | 604 | 8 | 0 | 12 | 3 | 7 | 3 | 5 | - | DB641078 | 631 | 0 | 631 | chr1 | 230208 | 8720 | 9349 | 5 | 49,49,95,33,398, | 0,52,102,197,233, | 8720,8771,8820,8916,8951, |
| 585 | 204 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | - | DB637090 | 205 | 0 | 205 | chr1 | 230208 | 8979 | 9184 | 1 | 205, | 0, | 8979, |
| 585 | 481 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | + | DB645815 | 483 | 0 | 483 | chr1 | 230208 | 9327 | 9810 | 1 | 483, | 0, | 9327, |
| 585 | 419 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | + | DB662025 | 419 | 0 | 419 | chr1 | 230208 | 9497 | 9916 | 1 | 419, | 0, | 9497, |
| 585 | 224 | 2 | 0 | 0 | 1 | 28 | 0 | 0 | - | DB637020 | 254 | 0 | 254 | chr1 | 230208 | 31383 | 31609 | 2 | 123,103, | 0,151, | 31383,31506, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server