|
|
Database: aplCal1 Primary Table: all_mrna Row Count: 861   Data last updated: 2019-03-26
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 | 1475 | int(10) unsigned | range | Number of bases that match that aren't repeats |
misMatches | 12 | 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 | 1 | int(10) unsigned | range | Number of inserts in query |
qBaseInsert | 5 | int(10) unsigned | range | Number of bases inserted in query |
tNumInsert | 3 | int(10) unsigned | range | Number of inserts in target |
tBaseInsert | 4 | int(10) unsigned | range | Number of bases inserted in target |
strand | + | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | EZ114783 | varchar(255) | values | Query sequence name |
qSize | 1492 | int(10) unsigned | range | Query sequence size |
qStart | 0 | int(10) unsigned | range | Alignment start position in query |
qEnd | 1492 | int(10) unsigned | range | Alignment end position in query |
tName | chrM | varchar(255) | values | Target sequence name |
tSize | 14117 | int(10) unsigned | range | Target sequence size |
tStart | 92 | int(10) unsigned | range | Alignment start position in target |
tEnd | 1583 | int(10) unsigned | range | Alignment end position in target |
blockCount | 4 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 4,20,1380,83, | longblob | | Size of each block |
qStarts | 0,4,24,1409, | longblob | | Start of each block in query. |
tStarts | 92,97,118,1500, | 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 | 1475 | 12 | 0 | 0 | 1 | 5 | 3 | 4 | + | EZ114783 | 1492 | 0 | 1492 | chrM | 14117 | 92 | 1583 | 4 | 4,20,1380,83, | 0,4,24,1409, | 92,97,118,1500, |
585 | 1340 | 7 | 0 | 0 | 6 | 15 | 6 | 7 | + | EZ114664 | 1367 | 0 | 1362 | chrM | 14117 | 4551 | 5905 | 13 | 9,82,3,14,128,20,5,5,3,13,51,944,70, | 0,9,91,94,108,237,258,264,270,274,287,338,1292, | 4551,4561,4644,4648,4663,4791,4811,4816,4821,4824,4839,4891,5835, |
585 | 1085 | 7 | 0 | 0 | 0 | 0 | 1 | 1 | + | EZ114648 | 1100 | 2 | 1094 | chrM | 14117 | 6346 | 7439 | 2 | 486,606, | 2,488, | 6346,6833, |
585 | 650 | 4 | 0 | 0 | 0 | 0 | 1 | 1 | + | EZ114729 | 660 | 6 | 660 | chrM | 14117 | 7599 | 8254 | 2 | 22,632, | 6,28, | 7599,7622, |
585 | 139 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | - | EZ114549 | 425 | 282 | 425 | chrM | 14117 | 8753 | 8896 | 1 | 143, | 0, | 8753, |
585 | 667 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | - | EZ114553 | 825 | 0 | 676 | chrM | 14117 | 8753 | 9429 | 1 | 676, | 149, | 8753, |
585 | 1161 | 18 | 0 | 0 | 0 | 0 | 4 | 4 | + | EZ114698 | 1181 | 1 | 1180 | chrM | 14117 | 10978 | 12161 | 5 | 7,18,16,17,1121, | 1,8,26,42,59, | 10978,10986,11005,11022,11040, |
585 | 735 | 9 | 0 | 0 | 0 | 0 | 1 | 1 | - | EZ114747 | 744 | 0 | 744 | chrM | 14117 | 12273 | 13018 | 2 | 714,30, | 0,714, | 12273,12988, |
585 | 702 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | + | EZ114535 | 715 | 4 | 713 | chrM | 14117 | 13396 | 14105 | 1 | 709, | 4, | 13396, |
589 | 793 | 3 | 0 | 0 | 0 | 0 | 3 | 6527 | - | HM054528 | 796 | 0 | 796 | scaffold_0 | 1784514 | 543905 | 551228 | 4 | 575,85,70,66, | 0,575,660,730, | 543905,548934,550245,551162, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|