|
|
Database: mm10 Primary Table: all_mrna Row Count: 881,044   Data last updated: 2020-08-17
Format description: Summary info about a patSpace alignment On download server: MariaDB table dump directory
field | example | SQL type | description |
bin | 608 | smallint(5) unsigned | Indexing field to speed chromosome range queries. |
matches | 867 | int(10) unsigned | Number of bases that match that aren't repeats |
misMatches | 1 | int(10) unsigned | Number of bases that don't match |
repMatches | 202 | 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 | AK016604 | varchar(255) | Query sequence name |
qSize | 1070 | int(10) unsigned | Query sequence size |
qStart | 0 | int(10) unsigned | Alignment start position in query |
qEnd | 1070 | int(10) unsigned | Alignment end position in query |
tName | chr1 | varchar(255) | Target sequence name |
tSize | 195471971 | int(10) unsigned | Target sequence size |
tStart | 3073252 | int(10) unsigned | Alignment start position in target |
tEnd | 3074322 | int(10) unsigned | Alignment end position in target |
blockCount | 1 | int(10) unsigned | Number of blocks in alignment |
blockSizes | 1070, | longblob | Size of each block |
qStarts | 0, | longblob | Start of each block in query. |
tStarts | 3073252, | 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 |
---|
608 | 867 | 1 | 202 | 0 | 0 | 0 | 0 | 0 | + | AK016604 | 1070 | 0 | 1070 | chr1 | 195471971 | 3073252 | 3074322 | 1 | 1070, | 0, | 3073252, |
608 | 38 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | LF220752 | 45 | 0 | 38 | chr1 | 195471971 | 3102681 | 3102719 | 1 | 38, | 7, | 3102681, |
608 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | LF222339 | 45 | 5 | 45 | chr1 | 195471971 | 3137202 | 3137242 | 1 | 40, | 0, | 3137202, |
76 | 38 | 0 | 0 | 0 | 0 | 0 | 1 | 107858 | - | LF304952 | 46 | 2 | 40 | chr1 | 195471971 | 3174444 | 3282340 | 2 | 18,20, | 6,24, | 3174444,3282320, |
609 | 45 | 0 | 0 | 0 | 0 | 0 | 1 | 424 | + | LF288482 | 45 | 0 | 45 | chr1 | 195471971 | 3175523 | 3175992 | 2 | 21,24, | 0,21, | 3175523,3175968, |
609 | 3959 | 1 | 190 | 0 | 1 | 1 | 1 | 6291 | - | AK220428 | 4160 | 0 | 4151 | chr1 | 195471971 | 3205903 | 3216344 | 3 | 462,952,2736, | 9,472,1424, | 3205903,3206365,3213608, |
609 | 2817 | 1 | 170 | 0 | 0 | 0 | 2 | 6122 | - | AK135172 | 2988 | 0 | 2988 | chr1 | 195471971 | 3206522 | 3215632 | 3 | 795,585,1608, | 0,795,1380, | 3206522,3213438,3214024, |
76 | 3205 | 0 | 429 | 0 | 0 | 0 | 2 | 453383 | - | AY534250 | 3652 | 0 | 3634 | chr1 | 195471971 | 3214481 | 3671498 | 3 | 2487,200,947, | 18,2505,2705, | 3214481,3421701,3670551, |
609 | 860 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | BC169294 | 927 | 11 | 871 | chr1 | 195471971 | 3216022 | 3216882 | 1 | 860, | 56, | 3216022, |
76 | 960 | 0 | 129 | 0 | 0 | 0 | 2 | 453383 | - | BC169293 | 1160 | 61 | 1150 | chr1 | 195471971 | 3216877 | 3671349 | 3 | 91,200,798, | 10,101,301, | 3216877,3421701,3670551, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|