|
|
Database: petMar3 Primary Table: all_est Row Count: 157,672   Data last updated: 2018-03-13
Format description: Summary info about a patSpace alignment On download server: MariaDB table dump directory
field | example | SQL type | info | description |
bin | 665 | smallint(5) unsigned | range | Indexing field to speed chromosome range queries. |
matches | 231 | int(10) unsigned | range | Number of bases that match that aren't repeats |
misMatches | 1 | 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 | 5 | int(10) unsigned | range | Number of 'N' bases |
qNumInsert | 3 | int(10) unsigned | range | Number of inserts in query |
qBaseInsert | 13 | int(10) unsigned | range | Number of bases inserted in query |
tNumInsert | 4 | int(10) unsigned | range | Number of inserts in target |
tBaseInsert | 5316 | int(10) unsigned | range | Number of bases inserted in target |
strand | - | char(2) | values | + or - for strand. First character query, second target (optional) |
qName | AA618656 | varchar(255) | values | Query sequence name |
qSize | 360 | int(10) unsigned | range | Query sequence size |
qStart | 65 | int(10) unsigned | range | Alignment start position in query |
qEnd | 315 | int(10) unsigned | range | Alignment end position in query |
tName | PIZI01000003v1 | varchar(255) | values | Target sequence name |
tSize | 25736822 | int(10) unsigned | range | Target sequence size |
tStart | 10565216 | int(10) unsigned | range | Alignment start position in target |
tEnd | 10570769 | int(10) unsigned | range | Alignment end position in target |
blockCount | 6 | int(10) unsigned | range | Number of blocks in alignment |
blockSizes | 37,5,25,80,83,7, | longblob | | Size of each block |
qStarts | 45,84,99,124,204,288, | longblob | | Start of each block in query. |
tStarts | 10565216,10565253,10565266,... | 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 |
---|
665 | 231 | 1 | 0 | 5 | 3 | 13 | 4 | 5316 | - | AA618656 | 360 | 65 | 315 | PIZI01000003v1 | 25736822 | 10565216 | 10570769 | 6 | 37,5,25,80,83,7, | 45,84,99,124,204,288, | 10565216,10565253,10565266,10568516,10570677,10570762, |
675 | 303 | 2 | 0 | 6 | 1 | 1 | 0 | 0 | + | AA618657 | 350 | 0 | 312 | PIZI01000016v1 | 15919453 | 11910225 | 11910536 | 2 | 36,275, | 0,37, | 11910225,11910261, |
606 | 270 | 2 | 0 | 3 | 0 | 0 | 2 | 2 | + | AA618655 | 317 | 9 | 284 | PIZI01000019v1 | 14876896 | 2836696 | 2836973 | 3 | 5,18,252, | 9,14,32, | 2836696,2836702,2836721, |
592 | 161 | 5 | 0 | 3 | 2 | 9 | 7 | 72313 | - | AA618646 | 287 | 48 | 226 | PIZI01000020v1 | 14679631 | 957856 | 1030338 | 8 | 24,52,60,12,7,4,6,4, | 61,93,145,206,218,225,229,235, | 957856,957886,1030239,1030301,1030314,1030322,1030327,1030334, |
592 | 122 | 1 | 0 | 2 | 2 | 2 | 4 | 177 | - | AA618645 | 228 | 83 | 210 | PIZI01000020v1 | 14679631 | 957907 | 958209 | 6 | 26,27,40,9,10,13, | 18,44,72,112,122,132, | 957907,958105,958132,958173,958184,958196, |
592 | 233 | 0 | 0 | 4 | 4 | 12 | 7 | 504 | - | AA618648 | 285 | 4 | 253 | PIZI01000020v1 | 14679631 | 989305 | 990046 | 9 | 11,41,67,63,20,5,8,8,14, | 32,52,94,161,225,246,251,259,267, | 989305,989324,989365,989921,989986,990008,990014,990023,990032, |
592 | 159 | 3 | 0 | 2 | 3 | 14 | 7 | 190 | + | AA618646 | 287 | 48 | 226 | PIZI01000020v1 | 14679631 | 1045672 | 1046026 | 8 | 4,6,5,6,12,53,54,24, | 48,52,58,63,69,82,144,202, | 1045672,1045677,1045684,1045690,1045697,1045711,1045946,1046002, |
597 | 288 | 2 | 0 | 7 | 3 | 3 | 2 | 2 | - | AA618652 | 346 | 2 | 302 | PIZI01000022v1 | 14626029 | 1671982 | 1672281 | 6 | 11,78,35,150,17,6, | 44,56,135,171,321,338, | 1671982,1671993,1672071,1672106,1672257,1672275, |
595 | 279 | 4 | 0 | 13 | 6 | 6 | 1 | 1 | + | AA618653 | 344 | 7 | 309 | PIZI01000026v1 | 13850470 | 1418794 | 1419091 | 8 | 15,19,14,52,130,53,5,8, | 7,22,42,57,110,241,295,301, | 1418794,1418810,1418829,1418843,1418895,1419025,1419078,1419083, |
602 | 244 | 2 | 0 | 3 | 4 | 5 | 5 | 2294 | + | AA618649 | 291 | 0 | 254 | PIZI01000030v1 | 12740602 | 2249720 | 2252263 | 9 | 10,7,11,13,37,100,44,22,5, | 0,10,17,28,42,79,180,225,249, | 2249720,2249731,2249739,2249751,2249766,2252092,2252192,2252236,2252258, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|