Schema for scBlastTab
  Database: hg16    Primary Table: scBlastTab    Row Count: 18,286   Data last updated: 2004-03-30
Format description: Blast alignments of S. cerevisiae genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query AB000114varchar(255) values Name of sequence in this assembly (query)
target YJL005Wvarchar(255) values Name of sequence in other assembly (target)
identity 27.85float range Percent identity
aliLength 316int(10) unsigned range Length of alignment
mismatch 171int(10) unsigned range Number of mismatches
gapOpen 13int(10) unsigned range Number of gap openings
qStart 82int(10) unsigned range Start in query (0 based)
qEnd 367int(10) unsigned range End in query (non-inclusive)
tStart 874int(10) unsigned range Start in target (0 based)
tEnd 1164int(10) unsigned range End in target (non-inclusive)
eValue 0.000000000004double range Expectation value
bitScore 67.4double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
AB000114YJL005W27.85316171138236787411640.00000000000467.4
AB000449YHR135C28.093241861136347683583.5999999999999996e-31130.6
AB000462YER114C28.07114615291257718820.000242.36
AB000468YCR066W42.224519113117627650.0001340.82
AB000509YBR130C24.361561004244398471870.0007440.43
AB000516YML010W29.33733445191208162219181.3999999999999998e-68256.5
AB000824YBR001C28.01407225151595193227081.7999999999999997e-24109
AB001106YDR063W28.8913581615137131460.0000008147.37
AB001328YKR093W26.63184108522185782560.000000001257.77
AB001466YHL002W44.07592914632162710.00001446.21

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