Schema for mmBlastTab
  Database: rn4    Primary Table: mmBlastTab    Row Count: 8,385   Data last updated: 2015-05-27
Format description: Blast alignments of Mouse genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query RGD:1302933varchar(255) values Name of sequence in this assembly (query)
target uc007ubl.1varchar(255) values Name of sequence in other assembly (target)
identity 77.96float range Percent identity
aliLength 245int(10) unsigned range Length of alignment
mismatch 52int(10) unsigned range Number of mismatches
gapOpen 1int(10) unsigned range Number of gap openings
qStart 0int(10) unsigned range Start in query (0 based)
qEnd 245int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 243int(10) unsigned range End in target (non-inclusive)
eValue 2e-101double range Expectation value
bitScore 365double range Bit score

Connected Tables and Joining Fields
        rn4.affyExonTissuesGsMedianDistRgdGene2.query (via mmBlastTab.query)
      rn4.affyExonTissuesGsMedianDistRgdGene2.target (via mmBlastTab.query)
      rn4.affyExonTissuesGsMedianRgdGene2.name (via mmBlastTab.query)
      rn4.affyExonTissuesGsRgdGene2.name (via mmBlastTab.query)
      rn4.ceBlastTab.query (via mmBlastTab.query)
      rn4.dmBlastTab.query (via mmBlastTab.query)
      rn4.drBlastTab.query (via mmBlastTab.query)
      rn4.gnfAtlas2RgdGene2Distance.query (via mmBlastTab.query)
      rn4.gnfAtlas2RgdGene2Distance.target (via mmBlastTab.query)
      rn4.hgBlastTab.query (via mmBlastTab.query)
      rn4.rgdGene2.name (via mmBlastTab.query)
      rn4.rgdGene2BlastTab.query (via mmBlastTab.query)
      rn4.rgdGene2BlastTab.target (via mmBlastTab.query)
      rn4.rgdGene2Canonical.transcript (via mmBlastTab.query)
      rn4.rgdGene2Isoforms.transcript (via mmBlastTab.query)
      rn4.rgdGene2KeggPathway.rgdId (via mmBlastTab.query)
      rn4.rgdGene2Pep.name (via mmBlastTab.query)
      rn4.rgdGene2ToDescription.name (via mmBlastTab.query)
      rn4.rgdGene2ToDisplayId.name (via mmBlastTab.query)
      rn4.rgdGene2ToEnsembl.name (via mmBlastTab.query)
      rn4.rgdGene2ToGenbank.name (via mmBlastTab.query)
      rn4.rgdGene2ToGenbankAll.name (via mmBlastTab.query)
      rn4.rgdGene2ToGnfAtlas2.name (via mmBlastTab.query)
      rn4.rgdGene2ToKeggEntrez.name (via mmBlastTab.query)
      rn4.rgdGene2ToLocusLink.name (via mmBlastTab.query)
      rn4.rgdGene2ToPDB.name (via mmBlastTab.query)
      rn4.rgdGene2ToPfam.name (via mmBlastTab.query)
      rn4.rgdGene2ToRAE230.name (via mmBlastTab.query)
      rn4.rgdGene2ToRefSeq.name (via mmBlastTab.query)
      rn4.rgdGene2ToSymbol.rgdId (via mmBlastTab.query)
      rn4.rgdGene2ToU34A.name (via mmBlastTab.query)
      rn4.rgdGene2ToUniProt.name (via mmBlastTab.query)
      rn4.rgdGene2Xref.rgdGeneId (via mmBlastTab.query)
      rn4.rgdGenePathway.geneId (via mmBlastTab.query)
      rn4.scBlastTab.query (via mmBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
RGD:1302933uc007ubl.177.96245521024502432e-101365
RGD:1302935uc009gka.187.11357460035703570634
RGD:1302936uc009dqy.289.084584630456264820855
RGD:1302937uc007lkj.192.92438301043804372e-174609
RGD:1302938uc007ubm.277.4523552112247122461e-104376
RGD:1302939uc008goi.199.0843740043704370865
RGD:1302940uc007gqk.181.6213222268013090131802012
RGD:1302941uc033hts.187.54337411033603378e-176613
RGD:1302945uc007whi.192.38538410053805380934
RGD:1302946uc008crh.183.9471611320716071401234

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