|
|---|
| |
Database: bosTau2 Primary Table: all_est Row Count: 2,019,805 Data last updated: 2016-06-03
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 | 389 | int(10) unsigned | Number of bases that match that aren't repeats |
| misMatches | 8 | 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 | AJ674068 | varchar(255) | Query sequence name |
| qSize | 397 | int(10) unsigned | Query sequence size |
| qStart | 0 | int(10) unsigned | Alignment start position in query |
| qEnd | 397 | int(10) unsigned | Alignment end position in query |
| tName | chr1 | varchar(255) | Target sequence name |
| tSize | 102834029 | int(10) unsigned | Target sequence size |
| tStart | 15783 | int(10) unsigned | Alignment start position in target |
| tEnd | 16180 | int(10) unsigned | Alignment end position in target |
| blockCount | 1 | int(10) unsigned | Number of blocks in alignment |
| blockSizes | 397, | longblob | Size of each block |
| qStarts | 0, | longblob | Start of each block in query. |
| tStarts | 15783, | 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 | 389 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | - | AJ674068 | 397 | 0 | 397 | chr1 | 102834029 | 15783 | 16180 | 1 | 397, | 0, | 15783, |
| 585 | 488 | 0 | 0 | 0 | 1 | 2 | 1 | 4 | - | BF604790 | 490 | 0 | 490 | chr1 | 102834029 | 22435 | 22927 | 2 | 447,41, | 0,449, | 22435,22886, |
| 585 | 284 | 4 | 179 | 0 | 0 | 0 | 0 | 0 | - | DY119663 | 467 | 0 | 467 | chr1 | 102834029 | 26838 | 27305 | 1 | 467, | 0, | 26838, |
| 585 | 811 | 2 | 0 | 0 | 0 | 0 | 3 | 8339 | + | DN544833 | 815 | 2 | 815 | chr1 | 102834029 | 27197 | 36349 | 4 | 544,97,123,49, | 2,546,643,766, | 27197,28469,31254,36300, |
| 585 | 454 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | + | AJ696888 | 456 | 0 | 456 | chr1 | 102834029 | 27199 | 27655 | 1 | 456, | 0, | 27199, |
| 585 | 534 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | + | AM015055 | 546 | 0 | 537 | chr1 | 102834029 | 27206 | 27743 | 1 | 537, | 0, | 27206, |
| 585 | 536 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | - | AM016121 | 546 | 9 | 546 | chr1 | 102834029 | 27206 | 27743 | 1 | 537, | 0, | 27206, |
| 585 | 751 | 5 | 0 | 0 | 0 | 0 | 2 | 3416 | + | CX952345 | 781 | 6 | 762 | chr1 | 102834029 | 27206 | 31378 | 3 | 535,97,124, | 6,541,638, | 27206,28469,31254, |
| 585 | 829 | 0 | 0 | 0 | 0 | 0 | 4 | 11155 | - | CV983699 | 829 | 0 | 829 | chr1 | 102834029 | 27267 | 39251 | 5 | 474,97,123,67,68, | 0,474,571,694,761, | 27267,28469,31254,36300,39183, |
| 585 | 776 | 1 | 0 | 0 | 0 | 0 | 4 | 11155 | - | DT850199 | 778 | 1 | 778 | chr1 | 102834029 | 27328 | 39260 | 5 | 413,97,123,67,77, | 0,413,510,633,700, | 27328,28469,31254,36300,39183, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server