|
|
Database: triMan1 Primary Table: all_mrna Row Count: 1,297   Data last updated: 2018-11-23
Format description: Summary info about a patSpace alignment On download server: MariaDB table dump directory
field | example | SQL type | info | description |
bin | 684 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
matches | 1042 | 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 | 0 | int(10) unsigned | range | Number of inserts in query |
qBaseInsert | 0 | int(10) unsigned | range | Number of bases inserted in query |
tNumInsert | 4 | int(10) unsigned | range | Number of inserts in target |
tBaseInsert | 4866 | int(10) unsigned | range | Number of bases inserted in target |
strand | + | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | AF055319 | varchar(255) | values | Query sequence name |
qSize | 1047 | int(10) unsigned | range | Query sequence size |
qStart | 0 | int(10) unsigned | range | Alignment start position in query |
qEnd | 1047 | int(10) unsigned | range | Alignment end position in query |
tName | JH594607 | varchar(255) | values | Target sequence name |
tSize | 45942467 | int(10) unsigned | range | Target sequence size |
tStart | 13030698 | int(10) unsigned | range | Alignment start position in target |
tEnd | 13036611 | int(10) unsigned | range | Alignment end position in target |
blockCount | 5 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 361,169,166,240,111, | longblob | | Size of each block |
qStarts | 0,361,530,696,936, | longblob | | Start of each block in query. |
tStarts | 13030698,13033153,13034913,... | 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 |
---|
684 | 1042 | 5 | 0 | 0 | 0 | 0 | 4 | 4866 | + | AF055319 | 1047 | 0 | 1047 | JH594607 | 45942467 | 13030698 | 13036611 | 5 | 361,169,166,240,111, | 0,361,530,696,936, | 13030698,13033153,13034913,13035233,13036500, |
593 | 60 | 0 | 125 | 0 | 0 | 0 | 2 | 55156 | - | DQ323604 | 185 | 0 | 185 | JH594615 | 34412642 | 1094059 | 1149400 | 3 | 13,135,37, | 0,13,148, | 1094059,1095700,1149363, |
593 | 37 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | DQ323605 | 50 | 0 | 37 | JH594615 | 34412642 | 1149363 | 1149400 | 1 | 37, | 13, | 1149363, |
596 | 383 | 3 | 0 | 0 | 0 | 0 | 1 | 282 | + | AY744134 | 391 | 5 | 391 | JH594634 | 23036994 | 1531412 | 1532080 | 2 | 93,293, | 5,98, | 1531412,1531787, |
604 | 50 | 0 | 51 | 0 | 0 | 0 | 2 | 615 | + | DQ323633 | 101 | 0 | 101 | JH594692 | 11983830 | 2534941 | 2535657 | 3 | 10,51,40, | 0,10,61, | 2534941,2535319,2535617, |
604 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | + | DQ323634 | 50 | 10 | 50 | JH594692 | 11983830 | 2535617 | 2535657 | 1 | 40, | 10, | 2535617, |
659 | 90 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | + | EF534711 | 90 | 0 | 90 | JH594693 | 11743621 | 9728381 | 9728471 | 1 | 90, | 0, | 9728381, |
623 | 299 | 0 | 126 | 0 | 0 | 0 | 2 | 2841 | - | DQ323617 | 425 | 0 | 425 | JH594738 | 7958080 | 5072326 | 5075592 | 3 | 267,135,23, | 0,267,402, | 5072326,5072750,5075569, |
602 | 91 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | + | EF534710 | 91 | 0 | 91 | JH594744 | 7568777 | 2267104 | 2267195 | 1 | 91, | 0, | 2267104, |
594 | 345 | 2 | 0 | 0 | 0 | 0 | 3 | 4890 | - | U09420 | 347 | 0 | 347 | JH594780 | 5706552 | 1299966 | 1305203 | 4 | 101,135,60,51, | 0,101,236,296, | 1299966,1301898,1305000,1305152, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|