|
|
Database: calJac1 Primary Table: all_mrna Row Count: 1,693   Data last updated: 2020-05-07
Format description: Summary info about a patSpace alignment On download server: MariaDB table dump directory
field | example | SQL type | info | description |
bin | 9 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
matches | 674 | int(10) unsigned | range | Number of bases that match that aren't repeats |
misMatches | 6 | 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 | 248780 | int(10) unsigned | range | Number of bases inserted in target |
strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | EF215371 | varchar(255) | values | Query sequence name |
qSize | 680 | int(10) unsigned | range | Query sequence size |
qStart | 0 | int(10) unsigned | range | Alignment start position in query |
qEnd | 680 | int(10) unsigned | range | Alignment end position in query |
tName | Contig0 | varchar(255) | values | Target sequence name |
tSize | 2416186 | int(10) unsigned | range | Target sequence size |
tStart | 963089 | int(10) unsigned | range | Alignment start position in target |
tEnd | 1212549 | int(10) unsigned | range | Alignment end position in target |
blockCount | 5 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 232,120,135,146,47, | longblob | | Size of each block |
qStarts | 0,232,352,487,633, | longblob | | Start of each block in query. |
tStarts | 963089,975360,991996,100653... | 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 |
---|
9 | 674 | 6 | 0 | 0 | 0 | 0 | 4 | 248780 | - | EF215371 | 680 | 0 | 680 | Contig0 | 2416186 | 963089 | 1212549 | 5 | 232,120,135,146,47, | 0,232,352,487,633, | 963089,975360,991996,1006530,1212502, |
602 | 676 | 4 | 0 | 0 | 0 | 0 | 5 | 2415 | - | EF215092 | 680 | 0 | 680 | Contig1 | 2551648 | 2277957 | 2281052 | 6 | 40,213,103,131,94,99, | 0,40,253,356,487,581, | 2277957,2277998,2279036,2279415,2279670,2280953, |
586 | 679 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | - | EF215108 | 680 | 0 | 680 | Contig101 | 1235070 | 156372 | 157052 | 1 | 680, | 0, | 156372, |
585 | 674 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | - | EF214983 | 680 | 0 | 680 | Contig10183 | 89210 | 17887 | 18567 | 1 | 680, | 0, | 17887, |
592 | 680 | 0 | 0 | 0 | 0 | 0 | 4 | 6900 | + | EF214868 | 680 | 0 | 680 | Contig102 | 1157145 | 1010185 | 1017765 | 5 | 117,159,108,187,109, | 0,117,276,384,571, | 1010185,1010733,1014142,1015015,1017656, |
585 | 543 | 1 | 53 | 0 | 1 | 83 | 5 | 5730 | + | EF215078 | 680 | 0 | 680 | Contig10237 | 79719 | 13274 | 19601 | 6 | 49,145,180,69,68,86, | 0,49,277,457,526,594, | 13274,13513,15393,15649,19428,19515, |
585 | 2528 | 0 | 0 | 0 | 0 | 0 | 8 | 22456 | + | DQ826671 | 2536 | 8 | 2536 | Contig10241 | 68271 | 34716 | 59700 | 9 | 92,139,152,152,157,100,79,50,1607, | 8,100,239,391,543,700,800,879,929, | 34716,37075,39504,43080,49055,52384,55109,56627,58093, |
585 | 535 | 1 | 0 | 0 | 2 | 140 | 3 | 9071 | + | EF215283 | 680 | 4 | 680 | Contig10258 | 71156 | 24255 | 33862 | 5 | 81,70,131,124,130, | 4,86,295,426,550, | 24255,24336,26654,29763,33732, |
585 | 680 | 0 | 0 | 0 | 0 | 0 | 2 | 3542 | - | EF215269 | 680 | 0 | 680 | Contig10263 | 59098 | 9490 | 13712 | 3 | 498,78,104, | 0,498,576, | 9490,11113,13608, |
585 | 676 | 0 | 0 | 0 | 1 | 4 | 1 | 4 | + | EF215413 | 680 | 0 | 680 | Contig10295 | 85377 | 24799 | 25479 | 2 | 642,34, | 0,646, | 24799,25445, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|