Schema for ceBlastTab
  Database: dm2    Primary Table: ceBlastTab    Row Count: 4,528   Data last updated: 2007-04-06
Format description: Blast alignments of C. elegans genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query CG10354-RAvarchar(255) values Name of sequence in this assembly (query)
target Y48B6A.3varchar(255) values Name of sequence in other assembly (target)
identity 54.19float range Percent identity
aliLength 799int(10) unsigned range Length of alignment
mismatch 322int(10) unsigned range Number of mismatches
gapOpen 8int(10) unsigned range Number of gap openings
qStart 0int(10) unsigned range Start in query (0 based)
qEnd 791int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 763int(10) unsigned range End in target (non-inclusive)
eValue 0double range Expectation value
bitScore 861double range Bit score

Connected Tables and Joining Fields
        dm2.arbExpDistance.query (via ceBlastTab.query)
      dm2.arbExpDistance.target (via ceBlastTab.query)
      dm2.drBlastTab.query (via ceBlastTab.query)
      dm2.flyBase2004Xref.name (via ceBlastTab.query)
      dm2.flyBaseBlastTab.query (via ceBlastTab.query)
      dm2.flyBaseBlastTab.target (via ceBlastTab.query)
      dm2.flyBaseCanonical.transcript (via ceBlastTab.query)
      dm2.flyBaseGene.name (via ceBlastTab.query)
      dm2.flyBaseIsoforms.transcript (via ceBlastTab.query)
      dm2.flyBaseNoncoding.name (via ceBlastTab.query)
      dm2.flyBasePep.name (via ceBlastTab.query)
      dm2.flyBaseToCG.name (via ceBlastTab.query)
      dm2.flyBaseToDescription.name (via ceBlastTab.query)
      dm2.flyBaseToPfam.name (via ceBlastTab.query)
      dm2.flyBaseToRefSeq.name (via ceBlastTab.query)
      dm2.flyBaseToUniProt.name (via ceBlastTab.query)
      dm2.flyP2P.query (via ceBlastTab.query)
      dm2.flyP2P.target (via ceBlastTab.query)
      dm2.hgBlastTab.query (via ceBlastTab.query)
      dm2.mmBlastTab.query (via ceBlastTab.query)
      dm2.rnBlastTab.query (via ceBlastTab.query)
      dm2.scBlastTab.query (via ceBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
CG10354-RAY48B6A.354.197993228079107630861
CG9773-RAT07A5.253.0223210814127302316e-59223
CG13761-RBT22A3.4a25.714202861043449324402e-31133
CG8344-RAF09F7.360.761129422429113723115201326
CG14750-RAW02A11.237.7917210523173101827.999999999999999e-32132
CG3408-RAF56A8.3a42.2115486219173161671.9999999999999998e-26116
CG32555-RAH08M01.2b26.92613401130578136144e-57220
CG9333-RAF38G1.129.817384901133757197436e-101365
CG6815-RAF54B3.353.755862563058205751.0000000000000001e-163573
CG15738-RAB0334.525.3231221410353341945000.00000448.5

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