Schema for scBlastTab
  Database: hg17    Primary Table: scBlastTab    Row Count: 16,395   Data last updated: 2005-06-04
Format description: Blast alignments of S. cerevisiae genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query AB000409varchar(255) values Name of sequence in this assembly (query)
target YPL153Cvarchar(255) values Name of sequence in other assembly (target)
identity 34.65float range Percent identity
aliLength 303int(10) unsigned range Length of alignment
mismatch 161int(10) unsigned range Number of mismatches
gapOpen 11int(10) unsigned range Number of gap openings
qStart 41int(10) unsigned range Start in query (0 based)
qEnd 334int(10) unsigned range End in query (non-inclusive)
tStart 191int(10) unsigned range Start in target (0 based)
tEnd 467int(10) unsigned range End in target (non-inclusive)
eValue 5.6e-38double range Expectation value
bitScore 153.3double range Bit score

Connected Tables and Joining Fields
        hg17.bioCycPathway.kgID (via scBlastTab.query)
      hg17.ccdsKgMap.geneId (via scBlastTab.query)
      hg17.ceBlastTab.query (via scBlastTab.query)
      hg17.dmBlastTab.query (via scBlastTab.query)
      hg17.drBlastTab.query (via scBlastTab.query)
      hg17.dupSpMrna.mrnaID (via scBlastTab.query)
      hg17.foldUtr3.name (via scBlastTab.query)
      hg17.foldUtr5.name (via scBlastTab.query)
      hg17.gladHumESDistance.query (via scBlastTab.query)
      hg17.gladHumESDistance.target (via scBlastTab.query)
      hg17.gnfAtlas2Distance.query (via scBlastTab.query)
      hg17.gnfAtlas2Distance.target (via scBlastTab.query)
      hg17.gnfU95Distance.query (via scBlastTab.query)
      hg17.gnfU95Distance.target (via scBlastTab.query)
      hg17.humanHprdP2P.query (via scBlastTab.query)
      hg17.humanHprdP2P.target (via scBlastTab.query)
      hg17.humanVidalP2P.query (via scBlastTab.query)
      hg17.humanVidalP2P.target (via scBlastTab.query)
      hg17.humanWankerP2P.query (via scBlastTab.query)
      hg17.humanWankerP2P.target (via scBlastTab.query)
      hg17.keggPathway.kgID (via scBlastTab.query)
      hg17.kgAlias.kgID (via scBlastTab.query)
      hg17.kgProtAlias.kgID (via scBlastTab.query)
      hg17.kgSpAlias.kgID (via scBlastTab.query)
      hg17.kgTargetAli.qName (via scBlastTab.query)
      hg17.kgXref.kgID (via scBlastTab.query)
      hg17.knownBlastTab.query (via scBlastTab.query)
      hg17.knownBlastTab.target (via scBlastTab.query)
      hg17.knownCanonical.transcript (via scBlastTab.query)
      hg17.knownExpDistance.query (via scBlastTab.query)
      hg17.knownExpDistance.target (via scBlastTab.query)
      hg17.knownGene.name (via scBlastTab.query)
      hg17.knownGeneLink.name (via scBlastTab.query)
      hg17.knownGeneMrna.name (via scBlastTab.query)
      hg17.knownGenePep.name (via scBlastTab.query)
      hg17.knownIsoforms.transcript (via scBlastTab.query)
      hg17.knownToAllenBrain.name (via scBlastTab.query)
      hg17.knownToEnsembl.name (via scBlastTab.query)
      hg17.knownToGnf1h.name (via scBlastTab.query)
      hg17.knownToGnfAtlas2.name (via scBlastTab.query)
      hg17.knownToHInv.name (via scBlastTab.query)
      hg17.knownToHprd.name (via scBlastTab.query)
      hg17.knownToKeggEntrez.name (via scBlastTab.query)
      hg17.knownToLocusLink.name (via scBlastTab.query)
      hg17.knownToPfam.name (via scBlastTab.query)
      hg17.knownToRefSeq.name (via scBlastTab.query)
      hg17.knownToSuper.gene (via scBlastTab.query)
      hg17.knownToU133.name (via scBlastTab.query)
      hg17.knownToU133Plus2.name (via scBlastTab.query)
      hg17.knownToU95.name (via scBlastTab.query)
      hg17.knownToVisiGene.name (via scBlastTab.query)
      hg17.mmBlastTab.query (via scBlastTab.query)
      hg17.rankProp.query (via scBlastTab.query)
      hg17.rankProp.target (via scBlastTab.query)
      hg17.rnBlastTab.query (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
AB000409YPL153C34.6530316111413341914675.6e-38153.3
AB000781YAL024C31.087450114811554125813320.0000247.37
AB000815YJR060W28.5756351701262202710.00236.96
AB001328YKR093W22.86140943121431182560.00006342.74
AB002292YLR371W20.5226820061824446509130.000002749.68
AB002294YJL056C23.1121213052144186808670.0000000000008372.02
AB002311YLL016W33.5119412436938847259175e-24109
AB002315YDR457W35.139622712438822288932671.4e-54209.5
AB002331YKL005C33.72865117318172823620.000008448.14
AB002360YAL041W26.6718012254456222814540.0000000009160.85

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