Schema for drBlastTab
  Database: mm39    Primary Table: drBlastTab    Row Count: 13,312   Data last updated: 2024-08-15
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENSMUST00000047357.10varchar(255) values Name of sequence in this assembly (query)
target ENSDART00000188799.1varchar(255) values Name of sequence in other assembly (target)
identity 85.57float range Percent identity
aliLength 790int(10) unsigned range Length of alignment
mismatch 106int(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 782int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 790int(10) unsigned range End in target (non-inclusive)
eValue 0double range Expectation value
bitScore 1304double 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)
      mm39.bioCycPathway.kgID (via drBlastTab.query)
      mm39.ceBlastTab.query (via drBlastTab.query)
      mm39.dmBlastTab.query (via drBlastTab.query)
      mm39.foldUtr3.name (via drBlastTab.query)
      mm39.foldUtr5.name (via drBlastTab.query)
      mm39.hgBlastTab.query (via drBlastTab.query)
      mm39.kgAlias.kgID (via drBlastTab.query)
      mm39.kgColor.kgID (via drBlastTab.query)
      mm39.kgProtAlias.kgID (via drBlastTab.query)
      mm39.kgSpAlias.kgID (via drBlastTab.query)
      mm39.kgTargetAli.qName (via drBlastTab.query)
      mm39.kgXref.kgID (via drBlastTab.query)
      mm39.knownAttrs.kgID (via drBlastTab.query)
      mm39.knownBlastTab.query (via drBlastTab.query)
      mm39.knownBlastTab.target (via drBlastTab.query)
      mm39.knownCanonical.transcript (via drBlastTab.query)
      mm39.knownCds.name (via drBlastTab.query)
      mm39.knownGene.name (via drBlastTab.query)
      mm39.knownGeneMrna.name (via drBlastTab.query)
      mm39.knownIsoforms.transcript (via drBlastTab.query)
      mm39.knownToEnsembl.name (via drBlastTab.query)
      mm39.knownToLocusLink.name (via drBlastTab.query)
      mm39.knownToMrna.name (via drBlastTab.query)
      mm39.knownToMrnaSingle.name (via drBlastTab.query)
      mm39.knownToMupit.name (via drBlastTab.query)
      mm39.knownToNextProt.name (via drBlastTab.query)
      mm39.knownToPfam.name (via drBlastTab.query)
      mm39.knownToRefSeq.name (via drBlastTab.query)
      mm39.knownToSuper.gene (via drBlastTab.query)
      mm39.knownToTag.name (via drBlastTab.query)
      mm39.knownToVisiGene.name (via drBlastTab.query)
      mm39.knownToWikipedia.name (via drBlastTab.query)
      mm39.rnBlastTab.query (via drBlastTab.query)
      mm39.scBlastTab.query (via drBlastTab.query)
      mm39.ucscScop.ucscId (via drBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
ENSMUST00000047357.10ENSDART00000188799.185.5779010620782079001304
ENSMUST00000065163.15ENSDART00000160545.268.75192552019101885e-65244
ENSMUST00000209579.2ENSDART00000128224.38030558125856003051e-139494
ENSMUST00000056708.4ENSDART00000136239.266.74451140499549765183e-161566
ENSMUST00000034058.14ENSDART00000149735.264.68235821023402351e-79293
ENSMUST00000190686.7ENSDART00000129339.458.06155593015301514e-31136
ENSMUST00000037023.9ENSDART00000060444.696.4356200560563e-27117
ENSMUST00000027131.6ENSDART00000037025.759.6849617083378333818478e-132469
ENSMUST00000073076.12ENSDART00000079202.666.126051972936921057080768
ENSMUST00000022634.9ENSDART00000035676.568.0716649355218682333e-54209

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