Schema for ceBlastTab
  Database: hg19    Primary Table: ceBlastTab    Row Count: 4,389   Data last updated: 2024-08-23
Format description: Blast alignments of C. elegans genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query ENST00000524756.5_4varchar(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.knownCanonToDecipher.name (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.knownToDecipher.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_4Y53C10A.427.184822631765528194322e-28124
ENST00000229633.7_4C26F1.7b35.6614377547181351728e-1783.2
ENST00000239174.7_8R13A5.555.779262178253901643e-1889
ENST00000400473.6_5Y71F9B.6b34.1221112441043022384475e-26114
ENST00000374606.10_4F21C3.541.74115651011501133e-2093.2
ENST00000581777.2_9F44A2.5b28.6715010131422902443900.000000000960.8
ENST00000309755.9_11C47D12.7a42.62596307621587276181e-130463
ENST00000253329.3_7F39H2.2a60.753211251032003211e-107387
ENST00000451613.5_5W09D6.1b32.2941523714173585984721e-39161
ENST00000323688.10_4F44A6.1a40.97310176347355643692e-46183

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