Schema for drBlastTab
  Database: mm10    Primary Table: drBlastTab    Row Count: 13,308   Data last updated: 2019-09-19
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENSMUST00000065163.14varchar(255) values Name of sequence in this assembly (query)
target ENSDART00000160545.2varchar(255) values Name of sequence in other assembly (target)
identity 68.75float range Percent identity
aliLength 192int(10) unsigned range Length of alignment
mismatch 55int(10) unsigned range Number of mismatches
gapOpen 2int(10) unsigned range Number of gap openings
qStart 0int(10) unsigned range Start in query (0 based)
qEnd 191int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 188int(10) unsigned range End in target (non-inclusive)
eValue 5e-65double range Expectation value
bitScore 244double range Bit score

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via drBlastTab.query)
      knownGeneV39.ceBlastTab.query (via drBlastTab.query)
      knownGeneV39.dmBlastTab.query (via drBlastTab.query)
      knownGeneV39.drBlastTab.query (via drBlastTab.query)
      knownGeneV39.foldUtr3.name (via drBlastTab.query)
      knownGeneV39.foldUtr5.name (via drBlastTab.query)
      knownGeneV39.gnfAtlas2Distance.query (via drBlastTab.query)
      knownGeneV39.gnfAtlas2Distance.target (via drBlastTab.query)
      knownGeneV39.kgAlias.kgID (via drBlastTab.query)
      knownGeneV39.kgColor.kgID (via drBlastTab.query)
      knownGeneV39.kgProtAlias.kgID (via drBlastTab.query)
      knownGeneV39.kgSpAlias.kgID (via drBlastTab.query)
      knownGeneV39.kgTargetAli.qName (via drBlastTab.query)
      knownGeneV39.kgXref.kgID (via drBlastTab.query)
      knownGeneV39.knownAttrs.kgID (via drBlastTab.query)
      knownGeneV39.knownBlastTab.query (via drBlastTab.query)
      knownGeneV39.knownBlastTab.target (via drBlastTab.query)
      knownGeneV39.knownCanonical.protein (via drBlastTab.query)
      knownGeneV39.knownCanonical.transcript (via drBlastTab.query)
      knownGeneV39.knownCds.name (via drBlastTab.query)
      knownGeneV39.knownGene.name (via drBlastTab.query)
      knownGeneV39.knownGeneMrna.name (via drBlastTab.query)
      knownGeneV39.knownGenePep.name (via drBlastTab.query)
      knownGeneV39.knownIsoforms.transcript (via drBlastTab.query)
      knownGeneV39.knownToEnsembl.name (via drBlastTab.query)
      knownGeneV39.knownToGnfAtlas2.name (via drBlastTab.query)
      knownGeneV39.knownToHprd.name (via drBlastTab.query)
      knownGeneV39.knownToLocusLink.name (via drBlastTab.query)
      knownGeneV39.knownToMrna.name (via drBlastTab.query)
      knownGeneV39.knownToMrnaSingle.name (via drBlastTab.query)
      knownGeneV39.knownToMupit.name (via drBlastTab.query)
      knownGeneV39.knownToPfam.name (via drBlastTab.query)
      knownGeneV39.knownToRefSeq.name (via drBlastTab.query)
      knownGeneV39.knownToSuper.gene (via drBlastTab.query)
      knownGeneV39.knownToTag.name (via drBlastTab.query)
      knownGeneV39.knownToU133.name (via drBlastTab.query)
      knownGeneV39.knownToU95.name (via drBlastTab.query)
      knownGeneV39.knownToVisiGene.name (via drBlastTab.query)
      knownGeneV39.knownToWikipedia.name (via drBlastTab.query)
      knownGeneV39.mmBlastTab.query (via drBlastTab.query)
      knownGeneV39.rnBlastTab.query (via drBlastTab.query)
      knownGeneV39.scBlastTab.query (via drBlastTab.query)
      knownGeneV39.ucscScop.ucscId (via drBlastTab.query)
      mm10.bioCycPathway.kgID (via drBlastTab.query)
      mm10.ccdsKgMap.geneId (via drBlastTab.query)
      mm10.ceBlastTab.query (via drBlastTab.query)
      mm10.dmBlastTab.query (via drBlastTab.query)
      mm10.foldUtr3.name (via drBlastTab.query)
      mm10.foldUtr5.name (via drBlastTab.query)
      mm10.hgBlastTab.query (via drBlastTab.query)
      mm10.keggPathway.kgID (via drBlastTab.query)
      mm10.kgAlias.kgID (via drBlastTab.query)
      mm10.kgColor.kgID (via drBlastTab.query)
      mm10.kgProtAlias.kgID (via drBlastTab.query)
      mm10.kgProtMap2.qName (via drBlastTab.query)
      mm10.kgSpAlias.kgID (via drBlastTab.query)
      mm10.kgTargetAli.qName (via drBlastTab.query)
      mm10.kgTxInfo.name (via drBlastTab.query)
      mm10.kgXref.kgID (via drBlastTab.query)
      mm10.knownAttrs.kgID (via drBlastTab.query)
      mm10.knownBlastTab.query (via drBlastTab.query)
      mm10.knownBlastTab.target (via drBlastTab.query)
      mm10.knownCanonical.transcript (via drBlastTab.query)
      mm10.knownCds.name (via drBlastTab.query)
      mm10.knownGene.name (via drBlastTab.query)
      mm10.knownGeneMrna.name (via drBlastTab.query)
      mm10.knownGenePep.name (via drBlastTab.query)
      mm10.knownIsoforms.transcript (via drBlastTab.query)
      mm10.knownToEnsembl.name (via drBlastTab.query)
      mm10.knownToKeggEntrez.name (via drBlastTab.query)
      mm10.knownToLocusLink.name (via drBlastTab.query)
      mm10.knownToLynx.name (via drBlastTab.query)
      mm10.knownToMrna.name (via drBlastTab.query)
      mm10.knownToMrnaSingle.name (via drBlastTab.query)
      mm10.knownToPfam.name (via drBlastTab.query)
      mm10.knownToRefSeq.name (via drBlastTab.query)
      mm10.knownToSuper.gene (via drBlastTab.query)
      mm10.knownToTag.name (via drBlastTab.query)
      mm10.knownToVisiGene.name (via drBlastTab.query)
      mm10.knownToWikipedia.name (via drBlastTab.query)
      mm10.rnBlastTab.query (via drBlastTab.query)
      mm10.scBlastTab.query (via drBlastTab.query)
      mm10.ucscScop.ucscId (via drBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
ENSMUST00000065163.14ENSDART00000160545.268.75192552019101885e-65244
ENSMUST00000209579.1ENSDART00000128224.38030558125856003051e-139494
ENSMUST00000056708.3ENSDART00000136239.266.74451140499549765183e-161566
ENSMUST00000034058.13ENSDART00000149735.264.68235821023402351e-79293
ENSMUST00000190686.6ENSDART00000129339.458.06155593015301514e-31136
ENSMUST00000037023.8ENSDART00000060444.696.4356200560563e-27117
ENSMUST00000027131.5ENSDART00000037025.759.6849617083378333818478e-132469
ENSMUST00000073076.11ENSDART00000079202.666.126051972936921057080768
ENSMUST00000022634.8ENSDART00000035676.568.0716649355218682333e-54209
ENSMUST00000180792.7ENSDART00000114248.461.0744716643798183768231e-145514

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