Schema for scBlastTab
  Database: dm1    Primary Table: scBlastTab    Row Count: 9,220   Data last updated: 2005-01-08
Format description: Blast alignments of S. cerevisiae genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query CG11023-RAvarchar(255) values Name of sequence in this assembly (query)
target YPL020Cvarchar(255) values Name of sequence in other assembly (target)
identity 27.83float range Percent identity
aliLength 309int(10) unsigned range Length of alignment
mismatch 185int(10) unsigned range Number of mismatches
gapOpen 9int(10) unsigned range Number of gap openings
qStart 161int(10) unsigned range Start in query (0 based)
qEnd 460int(10) unsigned range End in query (non-inclusive)
tStart 331int(10) unsigned range Start in target (0 based)
tEnd 612int(10) unsigned range End in target (non-inclusive)
eValue 1.7000000000000002e-27double range Expectation value
bitScore 118.6double range Bit score

Connected Tables and Joining Fields
        dm1.arbExpDistance.query (via scBlastTab.query)
      dm1.arbExpDistance.target (via scBlastTab.query)
      dm1.bdgpBlastTab.query (via scBlastTab.query)
      dm1.bdgpBlastTab.target (via scBlastTab.query)
      dm1.bdgpCanonical.transcript (via scBlastTab.query)
      dm1.bdgpGene.name (via scBlastTab.query)
      dm1.bdgpGenePep.name (via scBlastTab.query)
      dm1.bdgpIsoforms.transcript (via scBlastTab.query)
      dm1.bdgpSwissProt.bdgpName (via scBlastTab.query)
      dm1.bdgpToCanonical.name (via scBlastTab.query)
      dm1.bdgpToLocusLink.name (via scBlastTab.query)
      dm1.bdgpToPfam.name (via scBlastTab.query)
      dm1.bdgpToRefSeq.name (via scBlastTab.query)
      dm1.blastFBPep00.name (via scBlastTab.query)
      dm1.drBlastTab.query (via scBlastTab.query)
      dm1.fbTranscript.transcriptId (via scBlastTab.query)
      dm1.hgBlastTab.query (via scBlastTab.query)
      dm1.pscreen.geneIds (via scBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
CG11023-RAYPL020C27.8330918591614603316121.7000000000000002e-27118.6
CG2671-RAYPR032W38.3472902269641110.00538.89
CG2671-RCYPR032W38.3472902269641110.00538.89
CG31973-RAYBR289W23.46162935116253371930.000144.28
CG31973-RBYBR289W23.46162935100237371930.0002944.28
CG11371-RBYHR164C20.35403288852991743890.0002942.74
CG11376-RAYLR422W22.813772551317072059147718430.0000002753.91
CG12178-RAYDR456W35.65418232882473424502.1e-66248.4
CG2674-RAYDR502C64.2338313702240503831.9999999999999998e-138486.9
CG2674-RBYLR180W73.951193102714631224.2e-49188.7

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