Schema for rnBlastTab
  Database: mm10    Primary Table: rnBlastTab    Row Count: 57,012   Data last updated: 2019-09-20
Format description: Blast alignments of Rat genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENSMUST00000070533.4varchar(255) values Name of sequence in this assembly (query)
target ENSRNOT00000029503.6varchar(255) values Name of sequence in other assembly (target)
identity 98.08float range Percent identity
aliLength 521int(10) unsigned range Length of alignment
mismatch 10int(10) unsigned range Number of mismatches
gapOpen 0int(10) unsigned range Number of gap openings
qStart 126int(10) unsigned range Start in query (0 based)
qEnd 647int(10) unsigned range End in query (non-inclusive)
tStart 126int(10) unsigned range Start in target (0 based)
tEnd 647int(10) unsigned range End in target (non-inclusive)
eValue 0double range Expectation value
bitScore 973double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
ENSMUST00000070533.4ENSRNOT00000029503.698.085211001266471266470973
ENSMUST00000208660.1ENSRNOT00000047093.476.673305541031903296e-130462
ENSMUST00000194992.6ENSRNOT00000047093.491.352662121027502655e-130460
ENSMUST00000027032.5ENSRNOT00000047093.481.18211537013020940210803182
ENSMUST00000027035.9ENSRNOT00000033116.492.67423271041904230630
ENSMUST00000195555.1ENSRNOT00000033116.490.1729525102911284231e-104376
ENSMUST00000192650.5ENSRNOT00000033116.490.97321251373541024232e-121432
ENSMUST00000116652.7ENSRNOT00000033116.492.67423271041904230630
ENSMUST00000191647.1ENSRNOT00000033116.498.577010371071021721e-24107
ENSMUST00000191939.1ENSRNOT00000033116.498.2417030017001709e-83302

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