Schema for scBlastTab
  Database: rn4    Primary Table: scBlastTab    Row Count: 1,795   Data last updated: 2012-02-17
Format description: Blast alignments of S. cerevisiae genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query RGD:2176varchar(255) values Name of sequence in this assembly (query)
target YGL006Wvarchar(255) values Name of sequence in other assembly (target)
identity 37.01float range Percent identity
aliLength 816int(10) unsigned range Length of alignment
mismatch 379int(10) unsigned range Number of mismatches
gapOpen 21int(10) unsigned range Number of gap openings
qStart 381int(10) unsigned range Start in query (0 based)
qEnd 1085int(10) unsigned range End in query (non-inclusive)
tStart 328int(10) unsigned range Start in target (0 based)
tEnd 1121int(10) unsigned range End in target (non-inclusive)
eValue 9.999999999999999e-112double range Expectation value
bitScore 399double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
RGD:2176YGL006W37.0181637921381108532811219.999999999999999e-112399
RGD:2165YER045C29.0786561951763934790.00000745.1
RGD:2163YOL058W50.744061943240214074.0000000000000003e-112399
RGD:2162YGR124W36.8559729418055005614.0000000000000004e-69257
RGD:2150YPL111W39.9432316963305103292e-53204
RGD:2141YPR192W35.16182113349230912697e-25108
RGD:2126YBL019W22.54355180144931143570.00000000357.4
RGD:2110YML035C52.8962228441788001847970666
RGD:2104YOL052C31.2375210100328213951.9999999999999998e-42167
RGD:2100YDR481C32.353401861351379663749.000000000000001e-33136

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