Schema for scBlastTab
  Database: hg19    Primary Table: scBlastTab    Row Count: 2,365   Data last updated: 2024-08-23
Format description: Blast alignments of S. cerevisiae genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENST00000571105.5_6varchar(255) values Name of sequence in this assembly (query)
target YGR007Wvarchar(255) values Name of sequence in other assembly (target)
identity 35.78float range Percent identity
aliLength 327int(10) unsigned range Length of alignment
mismatch 181int(10) unsigned range Number of mismatches
gapOpen 9int(10) unsigned range Number of gap openings
qStart 23int(10) unsigned range Start in query (0 based)
qEnd 339int(10) unsigned range End in query (non-inclusive)
tStart 8int(10) unsigned range Start in target (0 based)
tEnd 317int(10) unsigned range End in target (non-inclusive)
eValue 5e-46double range Expectation value
bitScore 179double range Bit score

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via scBlastTab.query)
      hg19.ceBlastTab.query (via scBlastTab.query)
      hg19.dmBlastTab.query (via scBlastTab.query)
      hg19.drBlastTab.query (via scBlastTab.query)
      hg19.foldUtr3.name (via scBlastTab.query)
      hg19.foldUtr5.name (via scBlastTab.query)
      hg19.gnfAtlas2Distance.query (via scBlastTab.query)
      hg19.gnfAtlas2Distance.target (via scBlastTab.query)
      hg19.gnfU95Distance.query (via scBlastTab.query)
      hg19.gnfU95Distance.target (via scBlastTab.query)
      hg19.humanHprdP2P.query (via scBlastTab.query)
      hg19.humanHprdP2P.target (via scBlastTab.query)
      hg19.humanVidalP2P.query (via scBlastTab.query)
      hg19.humanVidalP2P.target (via scBlastTab.query)
      hg19.humanWankerP2P.query (via scBlastTab.query)
      hg19.humanWankerP2P.target (via scBlastTab.query)
      hg19.keggPathway.kgID (via scBlastTab.query)
      hg19.kgAlias.kgID (via scBlastTab.query)
      hg19.kgColor.kgID (via scBlastTab.query)
      hg19.kgProtAlias.kgID (via scBlastTab.query)
      hg19.kgProtMap2.qName (via scBlastTab.query)
      hg19.kgSpAlias.kgID (via scBlastTab.query)
      hg19.kgTargetAli.qName (via scBlastTab.query)
      hg19.kgTxInfo.name (via scBlastTab.query)
      hg19.kgXref.kgID (via scBlastTab.query)
      hg19.knownAttrs.kgID (via scBlastTab.query)
      hg19.knownBlastTab.query (via scBlastTab.query)
      hg19.knownBlastTab.target (via scBlastTab.query)
      hg19.knownCanonToDecipher.name (via scBlastTab.query)
      hg19.knownCanonical.transcript (via scBlastTab.query)
      hg19.knownCds.name (via scBlastTab.query)
      hg19.knownGene.name (via scBlastTab.query)
      hg19.knownGeneMrna.name (via scBlastTab.query)
      hg19.knownGenePep.name (via scBlastTab.query)
      hg19.knownGeneTxMrna.name (via scBlastTab.query)
      hg19.knownGeneTxPep.name (via scBlastTab.query)
      hg19.knownIsoforms.transcript (via scBlastTab.query)
      hg19.knownToAllenBrain.name (via scBlastTab.query)
      hg19.knownToDecipher.name (via scBlastTab.query)
      hg19.knownToEnsembl.name (via scBlastTab.query)
      hg19.knownToGnfAtlas2.name (via scBlastTab.query)
      hg19.knownToHInv.name (via scBlastTab.query)
      hg19.knownToHprd.name (via scBlastTab.query)
      hg19.knownToKeggEntrez.name (via scBlastTab.query)
      hg19.knownToLocusLink.name (via scBlastTab.query)
      hg19.knownToLynx.name (via scBlastTab.query)
      hg19.knownToMrna.name (via scBlastTab.query)
      hg19.knownToMrnaSingle.name (via scBlastTab.query)
      hg19.knownToMupit.name (via scBlastTab.query)
      hg19.knownToNextProt.name (via scBlastTab.query)
      hg19.knownToPfam.name (via scBlastTab.query)
      hg19.knownToRefSeq.name (via scBlastTab.query)
      hg19.knownToSuper.gene (via scBlastTab.query)
      hg19.knownToTag.name (via scBlastTab.query)
      hg19.knownToTreefam.name (via scBlastTab.query)
      hg19.knownToU133.name (via scBlastTab.query)
      hg19.knownToU133Plus2.name (via scBlastTab.query)
      hg19.knownToU95.name (via scBlastTab.query)
      hg19.knownToVisiGene.name (via scBlastTab.query)
      hg19.knownToWikipedia.name (via scBlastTab.query)
      hg19.mmBlastTab.query (via scBlastTab.query)
      hg19.rnBlastTab.query (via scBlastTab.query)
      hg19.ucscScop.ucscId (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
ENST00000571105.5_6YGR007W35.7832718192333983175e-46179
ENST00000374606.10_4YLR200W47.42975101411161032e-1678.6
ENST00000451613.5_5YBR115C21.46874332326082388990.00000000000170.5
ENST00000228347.9_4YOR207C63.071121399913112831114301433
ENST00000393001.1_5YOR289W35.75179914132287632428e-26112
ENST00000264932.11_4YKL148C66.24619190247664386400839
ENST00000370205.6_7YBR070C33.33195113631216492372e-1886.7
ENST00000225430.9_11YBR084C-A61.97142540014201421e-42167
ENST00000297283.4_7YKL152C52.232471152425122463e-70259
ENST00000357137.9_4YER078C35.534702691146502444942e-79291

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