Skip to main content
Schema for ceBlastTab
  Database: hg19    Primary Table: ceBlastTab    Row Count: 4,411   Data last updated: 2026-07-16
Format description: Blast alignments of C. elegans genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENST00000524756.5_5varchar(255) values Name of sequence in this assembly (query)
target Y53C10A.4varchar(255) values Name of sequence in other assembly (target)
identity 27.18float range Percent identity
aliLength 482int(10) unsigned range Length of alignment
mismatch 263int(10) unsigned range Number of mismatches
gapOpen 17int(10) unsigned range Number of gap openings
qStart 65int(10) unsigned range Start in query (0 based)
qEnd 528int(10) unsigned range End in query (non-inclusive)
tStart 19int(10) unsigned range Start in target (0 based)
tEnd 432int(10) unsigned range End in target (non-inclusive)
eValue 2e-28double range Expectation value
bitScore 124double range Bit score

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via ceBlastTab.query)
      hg19.dmBlastTab.query (via ceBlastTab.query)
      hg19.drBlastTab.query (via ceBlastTab.query)
      hg19.foldUtr3.name (via ceBlastTab.query)
      hg19.foldUtr5.name (via ceBlastTab.query)
      hg19.gnfAtlas2Distance.query (via ceBlastTab.query)
      hg19.gnfAtlas2Distance.target (via ceBlastTab.query)
      hg19.gnfU95Distance.query (via ceBlastTab.query)
      hg19.gnfU95Distance.target (via ceBlastTab.query)
      hg19.humanHprdP2P.query (via ceBlastTab.query)
      hg19.humanHprdP2P.target (via ceBlastTab.query)
      hg19.humanVidalP2P.query (via ceBlastTab.query)
      hg19.humanVidalP2P.target (via ceBlastTab.query)
      hg19.humanWankerP2P.query (via ceBlastTab.query)
      hg19.humanWankerP2P.target (via ceBlastTab.query)
      hg19.keggPathway.kgID (via ceBlastTab.query)
      hg19.kgAlias.kgID (via ceBlastTab.query)
      hg19.kgColor.kgID (via ceBlastTab.query)
      hg19.kgProtAlias.kgID (via ceBlastTab.query)
      hg19.kgProtMap2.qName (via ceBlastTab.query)
      hg19.kgSpAlias.kgID (via ceBlastTab.query)
      hg19.kgTargetAli.qName (via ceBlastTab.query)
      hg19.kgTxInfo.name (via ceBlastTab.query)
      hg19.kgXref.kgID (via ceBlastTab.query)
      hg19.knownAttrs.kgID (via ceBlastTab.query)
      hg19.knownBlastTab.query (via ceBlastTab.query)
      hg19.knownBlastTab.target (via ceBlastTab.query)
      hg19.knownCanonical.transcript (via ceBlastTab.query)
      hg19.knownCds.name (via ceBlastTab.query)
      hg19.knownGene.name (via ceBlastTab.query)
      hg19.knownGeneMrna.name (via ceBlastTab.query)
      hg19.knownGenePep.name (via ceBlastTab.query)
      hg19.knownGeneTxMrna.name (via ceBlastTab.query)
      hg19.knownGeneTxPep.name (via ceBlastTab.query)
      hg19.knownIsoforms.transcript (via ceBlastTab.query)
      hg19.knownToAllenBrain.name (via ceBlastTab.query)
      hg19.knownToEnsembl.name (via ceBlastTab.query)
      hg19.knownToGnfAtlas2.name (via ceBlastTab.query)
      hg19.knownToHInv.name (via ceBlastTab.query)
      hg19.knownToHprd.name (via ceBlastTab.query)
      hg19.knownToKeggEntrez.name (via ceBlastTab.query)
      hg19.knownToLocusLink.name (via ceBlastTab.query)
      hg19.knownToLynx.name (via ceBlastTab.query)
      hg19.knownToMrna.name (via ceBlastTab.query)
      hg19.knownToMrnaSingle.name (via ceBlastTab.query)
      hg19.knownToMupit.name (via ceBlastTab.query)
      hg19.knownToNextProt.name (via ceBlastTab.query)
      hg19.knownToPfam.name (via ceBlastTab.query)
      hg19.knownToRefSeq.name (via ceBlastTab.query)
      hg19.knownToSuper.gene (via ceBlastTab.query)
      hg19.knownToTag.name (via ceBlastTab.query)
      hg19.knownToTreefam.name (via ceBlastTab.query)
      hg19.knownToU133.name (via ceBlastTab.query)
      hg19.knownToU133Plus2.name (via ceBlastTab.query)
      hg19.knownToU95.name (via ceBlastTab.query)
      hg19.knownToVisiGene.name (via ceBlastTab.query)
      hg19.knownToWikipedia.name (via ceBlastTab.query)
      hg19.mmBlastTab.query (via ceBlastTab.query)
      hg19.rnBlastTab.query (via ceBlastTab.query)
      hg19.scBlastTab.query (via ceBlastTab.query)
      hg19.ucscScop.ucscId (via ceBlastTab.query)
      knownGeneV39.bioCycPathway.kgID (via ceBlastTab.query)
      knownGeneV39.ceBlastTab.query (via ceBlastTab.query)
      knownGeneV39.dmBlastTab.query (via ceBlastTab.query)
      knownGeneV39.drBlastTab.query (via ceBlastTab.query)
      knownGeneV39.foldUtr3.name (via ceBlastTab.query)
      knownGeneV39.foldUtr5.name (via ceBlastTab.query)
      knownGeneV39.gnfAtlas2Distance.query (via ceBlastTab.query)
      knownGeneV39.gnfAtlas2Distance.target (via ceBlastTab.query)
      knownGeneV39.kgAlias.kgID (via ceBlastTab.query)
      knownGeneV39.kgColor.kgID (via ceBlastTab.query)
      knownGeneV39.kgProtAlias.kgID (via ceBlastTab.query)
      knownGeneV39.kgSpAlias.kgID (via ceBlastTab.query)
      knownGeneV39.kgTargetAli.qName (via ceBlastTab.query)
      knownGeneV39.kgXref.kgID (via ceBlastTab.query)
      knownGeneV39.knownAttrs.kgID (via ceBlastTab.query)
      knownGeneV39.knownBlastTab.query (via ceBlastTab.query)
      knownGeneV39.knownBlastTab.target (via ceBlastTab.query)
      knownGeneV39.knownCanonical.protein (via ceBlastTab.query)
      knownGeneV39.knownCanonical.transcript (via ceBlastTab.query)
      knownGeneV39.knownCds.name (via ceBlastTab.query)
      knownGeneV39.knownGene.name (via ceBlastTab.query)
      knownGeneV39.knownGeneMrna.name (via ceBlastTab.query)
      knownGeneV39.knownGenePep.name (via ceBlastTab.query)
      knownGeneV39.knownIsoforms.transcript (via ceBlastTab.query)
      knownGeneV39.knownToEnsembl.name (via ceBlastTab.query)
      knownGeneV39.knownToGnfAtlas2.name (via ceBlastTab.query)
      knownGeneV39.knownToHprd.name (via ceBlastTab.query)
      knownGeneV39.knownToLocusLink.name (via ceBlastTab.query)
      knownGeneV39.knownToMrna.name (via ceBlastTab.query)
      knownGeneV39.knownToMrnaSingle.name (via ceBlastTab.query)
      knownGeneV39.knownToMupit.name (via ceBlastTab.query)
      knownGeneV39.knownToPfam.name (via ceBlastTab.query)
      knownGeneV39.knownToRefSeq.name (via ceBlastTab.query)
      knownGeneV39.knownToSuper.gene (via ceBlastTab.query)
      knownGeneV39.knownToTag.name (via ceBlastTab.query)
      knownGeneV39.knownToU133.name (via ceBlastTab.query)
      knownGeneV39.knownToU95.name (via ceBlastTab.query)
      knownGeneV39.knownToVisiGene.name (via ceBlastTab.query)
      knownGeneV39.knownToWikipedia.name (via ceBlastTab.query)
      knownGeneV39.mmBlastTab.query (via ceBlastTab.query)
      knownGeneV39.rnBlastTab.query (via ceBlastTab.query)
      knownGeneV39.scBlastTab.query (via ceBlastTab.query)
      knownGeneV39.ucscScop.ucscId (via ceBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
ENST00000524756.5_5Y53C10A.427.184822631765528194322e-28124
ENST00000239174.7_8R13A5.555.779262178253901643e-1889
ENST00000912071.1_2H14A12.326.86242146620238372723e-1682
ENST00000374606.10_4F21C3.541.74115651011501133e-2093.2
ENST00000920281.2_2ZK675.236.4247524273468133798022e-80298
ENST00001123109.1_1F52G2.1a44.26235125372391323641e-53207
ENST00000338244.6_7C51E3.636.185393121193623235391e-80297
ENST00000644969.2_11Y73B6A.5d52.2236014964277734347853e-100363
ENST00000869866.2_2D2045.646.54767398619776157800685
ENST00000861425.1_2Y110A7A.848.71427216246471554818e-104374

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