|
|
Database: danRer3 Primary Table: all_est Row Count: 2,043,404 Data last updated: 2017-11-02
Format description: Summary info about a patSpace alignment On download server: MariaDB table dump directory
field | example | SQL type | description |
bin | 589 | smallint(5) unsigned | Indexing field to speed chromosome range queries. |
matches | 452 | 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 | 0 | 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 | AA606023 | varchar(255) | Query sequence name |
qSize | 460 | int(10) unsigned | Query sequence size |
qStart | 7 | int(10) unsigned | Alignment start position in query |
qEnd | 460 | int(10) unsigned | Alignment end position in query |
tName | chr1 | varchar(255) | Target sequence name |
tSize | 55805710 | int(10) unsigned | Target sequence size |
tStart | 637823 | int(10) unsigned | Alignment start position in target |
tEnd | 638276 | int(10) unsigned | Alignment end position in target |
blockCount | 1 | int(10) unsigned | Number of blocks in alignment |
blockSizes | 453, | longblob | Size of each block |
qStarts | 0, | longblob | Start of each block in query. |
tStarts | 637823, | 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 |
---|
589 | 452 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | - | AA606023 | 460 | 7 | 460 | chr1 | 55805710 | 637823 | 638276 | 1 | 453, | 0, | 637823, |
589 | 293 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | + | AA495020 | 295 | 0 | 295 | chr1 | 55805710 | 638276 | 638571 | 1 | 295, | 0, | 638276, |
590 | 287 | 2 | 0 | 0 | 0 | 0 | 7 | 3073 | - | AA566428 | 290 | 0 | 289 | chr1 | 55805710 | 725375 | 728737 | 8 | 10,5,25,9,7,30,149,54, | 1,11,16,41,50,57,87,236, | 725375,725386,725392,725418,725428,725436,727197,728683, |
592 | 330 | 1 | 0 | 0 | 0 | 0 | 2 | 2884 | + | AA495253 | 331 | 0 | 331 | chr1 | 55805710 | 944676 | 947891 | 3 | 152,103,76, | 0,152,255, | 944676,945562,947815, |
592 | 377 | 0 | 0 | 0 | 2 | 2 | 4 | 3233 | + | AA494991 | 397 | 18 | 397 | chr1 | 55805710 | 945561 | 949171 | 7 | 104,53,28,56,15,50,71, | 18,122,175,203,260,276,326, | 945561,947815,947869,947987,948043,948058,949100, |
592 | 311 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | AA497179 | 338 | 27 | 338 | chr1 | 55805710 | 952182 | 952493 | 1 | 311, | 0, | 952182, |
592 | 281 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | AA494992 | 288 | 7 | 288 | chr1 | 55805710 | 952212 | 952493 | 1 | 281, | 0, | 952212, |
594 | 307 | 1 | 0 | 0 | 0 | 0 | 5 | 5 | + | AA494681 | 310 | 2 | 310 | chr1 | 55805710 | 1300993 | 1301306 | 6 | 16,19,48,151,9,65, | 2,18,37,85,236,245, | 1300993,1301010,1301030,1301079,1301231,1301241, |
610 | 224 | 1 | 0 | 0 | 2 | 4 | 1 | 1 | + | AA566431 | 229 | 0 | 229 | chr1 | 55805710 | 3328122 | 3328348 | 3 | 150,57,18, | 0,151,211, | 3328122,3328272,3328330, |
610 | 184 | 1 | 0 | 0 | 2 | 2 | 0 | 0 | + | AA566473 | 187 | 0 | 187 | chr1 | 55805710 | 3328127 | 3328312 | 3 | 10,151,24, | 0,11,163, | 3328127,3328137,3328288, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|