|
|---|
| |
Database: calJac4 Primary Table: xenoMrna Row Count: 5,551,440 Data last updated: 2020-09-21
Format description: Summary info about a patSpace alignment
On download server: MariaDB table dump directory
| field | example | SQL type | description |
|---|
| bin | 585 | smallint(5) unsigned | Indexing field to speed chromosome range queries. |
| matches | 57 | int(10) unsigned | Number of bases that match that aren't repeats |
| misMatches | 5 | 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 | LE705910 | varchar(255) | Query sequence name |
| qSize | 244 | int(10) unsigned | Query sequence size |
| qStart | 2 | int(10) unsigned | Alignment start position in query |
| qEnd | 64 | int(10) unsigned | Alignment end position in query |
| tName | chr1 | varchar(255) | Target sequence name |
| tSize | 217961735 | int(10) unsigned | Target sequence size |
| tStart | 33165 | int(10) unsigned | Alignment start position in target |
| tEnd | 33227 | int(10) unsigned | Alignment end position in target |
| blockCount | 1 | int(10) unsigned | Number of blocks in alignment |
| blockSizes | 62, | longblob | Size of each block |
| qStarts | 2, | longblob | Start of each block in query. |
| tStarts | 217928508, | 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 |
|---|
| 585 | 57 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | +- | LE705910 | 244 | 2 | 64 | chr1 | 217961735 | 33165 | 33227 | 1 | 62, | 2, | 217928508, |
| 585 | 48 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | JP393998 | 261 | 72 | 138 | chr1 | 217961735 | 34856 | 34922 | 1 | 66, | 72, | 34856, |
| 585 | 75 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | ++ | LE564268 | 237 | 125 | 209 | chr1 | 217961735 | 102186 | 102270 | 1 | 84, | 125, | 102186, |
| 585 | 142 | 26 | 0 | 0 | 1 | 23 | 1 | 28 | +- | LE524164 | 208 | 8 | 199 | chr1 | 217961735 | 106321 | 106517 | 2 | 27,141, | 8,58, | 217855218,217855273, |
| 585 | 286 | 31 | 0 | 0 | 0 | 0 | 2 | 3 | +- | LE526694 | 320 | 2 | 319 | chr1 | 217961735 | 107245 | 107565 | 3 | 90,64,163, | 2,92,156, | 217854170,217854261,217854327, |
| 586 | 188 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | +- | LE708296 | 318 | 25 | 228 | chr1 | 217961735 | 158700 | 158903 | 1 | 203, | 25, | 217802832, |
| 586 | 39 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | +- | EZ226414 | 135 | 3 | 51 | chr1 | 217961735 | 219300 | 219348 | 1 | 48, | 3, | 217742387, |
| 586 | 155 | 24 | 0 | 0 | 1 | 3 | 0 | 0 | ++ | LE607044 | 224 | 0 | 182 | chr1 | 217961735 | 225982 | 226161 | 2 | 142,37, | 0,145, | 225982,226124, |
| 586 | 63 | 12 | 0 | 0 | 1 | 18 | 2 | 4969 | +- | LI868666 | 284 | 156 | 249 | chr1 | 217961735 | 229458 | 234502 | 3 | 39,18,18, | 156,213,231, | 217727233,217732126,217732259, |
| 586 | 164 | 16 | 0 | 0 | 1 | 23 | 1 | 36 | ++ | LE645390 | 209 | 0 | 203 | chr1 | 217961735 | 230513 | 230729 | 2 | 114,66, | 0,137, | 230513,230663, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
US Server