Schema for rgdGene2BlastTab
  Database: rn4    Primary Table: rgdGene2BlastTab    Row Count: 349,439   Data last updated: 2012-02-03
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 RGD:1302933varchar(255) values Name of sequence in other assembly (target)
identity 100float range Percent identity
aliLength 249int(10) unsigned range Length of alignment
mismatch 0int(10) unsigned range Number of mismatches
gapOpen 0int(10) unsigned range Number of gap openings
qStart 0int(10) unsigned range Start in query (0 based)
qEnd 249int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 249int(10) unsigned range End in target (non-inclusive)
eValue 3e-135double range Expectation value
bitScore 476double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
RGD:1302933RGD:130293310024900024902493e-135476
RGD:1302933RGD:130330094.825092024902479.000000000000001e-125441
RGD:1302933RGD:130329192.8622410328249242459.999999999999999e-116411
RGD:1302933RGD:306277.96245521024502435e-104372
RGD:1302933RGD:62105878.31249521024902479e-102365
RGD:1302933RGD:130310973.49249623024802465e-92332
RGD:1302933RGD:306472.24245661024502434e-89323
RGD:1302933RGD:73503671.25240671824802383e-88320
RGD:1302933RGD:236556.2221793128245292441e-68254
RGD:1302933RGD:62860347.032361232724202356e-53202

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