Schema for hgBlastTab
  Database: danRer11    Primary Table: hgBlastTab    Row Count: 13,550   Data last updated: 2022-07-12
Format description: Blast alignments of Human genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENSDART00000171137.2varchar(255) values Name of sequence in this assembly (query)
target ENST00000300289.10varchar(255) values Name of sequence in other assembly (target)
identity 78.52float range Percent identity
aliLength 447int(10) unsigned range Length of alignment
mismatch 96int(10) unsigned range Number of mismatches
gapOpen 0int(10) unsigned range Number of gap openings
qStart 1int(10) unsigned range Start in query (0 based)
qEnd 448int(10) unsigned range End in query (non-inclusive)
tStart 46int(10) unsigned range Start in target (0 based)
tEnd 493int(10) unsigned range End in target (non-inclusive)
eValue 0double range Expectation value
bitScore 750double range Bit score

Connected Tables and Joining Fields
        danRer11.ensGene.name (via hgBlastTab.query)
      danRer11.ensGtp.transcript (via hgBlastTab.query)
      danRer11.ensPep.name (via hgBlastTab.query)
      danRer11.ensemblSource.name (via hgBlastTab.query)
      danRer11.ensemblToGeneName.name (via hgBlastTab.query)
      danRer11.mmBlastTab.query (via hgBlastTab.query)
      knownGeneV39.knownToEnsembl.value (via hgBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
ENSDART00000171137.2ENST00000300289.1078.524479601448464930750
ENSDART00000161245.2ENST00000380605.364.9160721023219251147210795
ENSDART00000141461.3ENST00000676491.1553401530034003405e-115412
ENSDART00000190819.1ENST00000299821.1539.8762731220058706026e-102370
ENSDART00000106388.5ENST00000379715.1063.37172621117221741e-61233
ENSDART00000066722.8ENST00000397276.681.96194284322201012941e-68258
ENSDART00000190818.1ENST00000360807.848.7937116742295772075787e-57221
ENSDART00000082110.5ENST00000357585.468.04341106238379313695e-116416
ENSDART00000086495.5ENST00000545746.577.685511221055005510912
ENSDART00000185422.1ENST00000342232.565.836791741217673176610732

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.