Schema for mmBlastTab
  Database: hg19    Primary Table: mmBlastTab    Row Count: 66,798   Data last updated: 2014-04-09
Format description: Blast alignments of Mouse genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query uc001aal.1varchar(255) values Name of sequence in this assembly (query)
target uc008lnp.1varchar(255) values Name of sequence in other assembly (target)
identity 81.48float range Percent identity
aliLength 297int(10) unsigned range Length of alignment
mismatch 55int(10) unsigned range Number of mismatches
gapOpen 0int(10) unsigned range Number of gap openings
qStart 6int(10) unsigned range Start in query (0 based)
qEnd 304int(10) unsigned range End in query (non-inclusive)
tStart 4294967295int(10) unsigned range Start in target (0 based)
tEnd 297int(10) unsigned range End in target (non-inclusive)
eValue 8e-132double range Expectation value
bitScore 467double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
uc001aal.1uc008lnp.181.48297550630442949672952978e-132467
uc001abw.1uc029vbl.169.145671411212068042949672955417e-168588
uc001abx.2uc029vbl.171.145511411112066442949672955414e-172602
uc001aby.4uc029vbi.174.75507120130538805800756
uc001abz.4uc029vbh.172.897451856429496729573642949672957370988
uc001aca.2uc008wgs.295.536272614294967295627429496729562501162
uc001acb.1uc008wgs.299.121141042949672951141212363e-60228
uc001acd.3uc012drk.163.26252027429496729561142949672956110710
uc001ace.3uc012drk.158.876712089429496729566342949672956110681
uc001acf.3uc012drk.161.336311698429496729557642949672956110682

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