Schema for scBlastTab
  Database: ce6    Primary Table: scBlastTab    Row Count: 1,942   Data last updated: 2010-08-19
Format description: Blast alignments of S. cerevisiae genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query C42D4.8varchar(255) values Name of sequence in this assembly (query)
target YOR116Cvarchar(255) values Name of sequence in other assembly (target)
identity 46.35float range Percent identity
aliLength 1439int(10) unsigned range Length of alignment
mismatch 680int(10) unsigned range Number of mismatches
gapOpen 21int(10) unsigned range Number of gap openings
qStart 13int(10) unsigned range Start in query (0 based)
qEnd 1378int(10) unsigned range End in query (non-inclusive)
tStart 11int(10) unsigned range Start in target (0 based)
tEnd 1432int(10) unsigned range End in target (non-inclusive)
eValue 0double range Expectation value
bitScore 1170double range Bit score

Connected Tables and Joining Fields
        ce6.dmBlastTab.query (via scBlastTab.query)
      ce6.drBlastTab.query (via scBlastTab.query)
      ce6.hgBlastTab.query (via scBlastTab.query)
      ce6.kimExpDistance.query (via scBlastTab.query)
      ce6.kimExpDistance.target (via scBlastTab.query)
      ce6.mmBlastTab.query (via scBlastTab.query)
      ce6.orfToGene.name (via scBlastTab.query)
      ce6.rnBlastTab.query (via scBlastTab.query)
      ce6.sangerBlastTab.query (via scBlastTab.query)
      ce6.sangerBlastTab.target (via scBlastTab.query)
      ce6.sangerCanonical.transcript (via scBlastTab.query)
      ce6.sangerGene.name (via scBlastTab.query)
      ce6.sangerGeneToWBGeneID.sangerGene (via scBlastTab.query)
      ce6.sangerIsoforms.transcript (via scBlastTab.query)
      ce6.sangerLinks.orfName (via scBlastTab.query)
      ce6.sangerPep.name (via scBlastTab.query)
      ce6.sangerToRefSeq.name (via scBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
C42D4.8YOR116C46.3514396802113137811143201170
T21H3.3YBR109C59.86147581014701465e-50191
F38A1.8YDR292C41.5733216173186252976213e-58221
T26C5.3dYBR220C31.52514299977541475582e-54207
Y71H2B.10cYKL135C40.255543061040576536006.9999999999999995e-115409
C42C1.5YDL055C58.043671463036503611e-117417
ZC376.5YDR120C33.585393041518511395706e-74273
T06E6.2bYDL155W31.525416641063591644118e-33135
ZC373.5YJR024C37.56205117538235252273e-32133
Y49E10.2YPL059W54.3710344132132321355.0000000000000005e-25107

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