Semantic search

Jump to navigation Jump to search
Condition
Printout selection
Options
Parameters [
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
class:

An additional CSS class to set for the table
transpose:

Display table headers vertically and results horizontally
sep:

The separator between results
Sort options
Delete
Add sorting condition
SQLStore debug output
ASK Query
[[Category:Reaction]] [[Reconstruction tool::Meneco]]
SQL Query
SELECT DISTINCT
  t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
  `sjapgem_smw_object_ids` AS t0
INNER JOIN
  (`sjapgem_smw_fpt_inst` AS t2
INNER JOIN
  `sjapgem_smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.o_id='643'
   AND (t4.p_id='27659' AND t4.o_id='596')
  )
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  55
OFFSET
  50
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt4refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id5const86Using where; Using temporary; Using filesort
1SIMPLEt2refs_id,o_id,s_id_2,o_id_2s_id_29wikidb.t4.s_id,const1Using index
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4wikidb.t4.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:3
Query-Depth:1
Errors and Warnings
None
 Common-nameEc-numberReconstruction categoryReconstruction sourceReconstruction commentNb gene associatedNb pathway associated
RXN-14812Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN-16016Ec-2.3.1Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling01
RXN-16017Ec-2.3.1Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling01
RXN-1602-CPD-17271/WATER//CPD66-43/STEARIC ACID/PROTON.46.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN-16097Ec-1.3.1.93Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling03
RXN-16415-TETRACOSANOATE/ATP/CO-A//CPD-10280/AMP/PPI.43.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN-17105Ec-1.14.19Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling01
RXN-4181-CPD-4101/DIMETHYL-GLYCINE//EPISTEROL/BETAINE.45.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN-4208-CPD-4124/DIMETHYL-GLYCINE//CPD-4125/BETAINE.44.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN-4307Ec-2.5.1.27Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling01
RXN-4311Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN-4313Ec-3.2.2Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling01
RXN-4313-CPD-4205/WATER//CPD-15318/CPD-4209.35.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN-4313-CPD-4205/WATER//CPD-16551/CPD-4209.35.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN-4315Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN-701Ec-1.8.1Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN-7952-CPD66-43/WATER//GLYCEROL/PALMITATE/PROTON.42.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN-9548Ec-3.1.2.14Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling01
RXN-9549Ec-3.1.2.14Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling03
RXN3O-203Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling01
RXN3O-5304Ec-2.3.1.86
Ec-2.3.1
Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling01
RXN3O-8214Ec-2.3.1Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN3O-9780Ec-2.3.1Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling02
RXN66-28Ec-1.3.1.72Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling01
RXN66-320Ec-5.3.3.5Manual
Gap-filling
Gapfilling solution with meneco draft medium
Reactions add sjap
Added for gapfilling
Curation sterols (girard et al.)
02
RXN66-321Ec-1.3.1.72Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling01
RXN66-474-R-2-HYDROXYSTEARATE/ATP/CO-A//CPD-14717/AMP/PPI.48.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN66-475-CPD-14717//CPD-14719/FORMYL-COA.32.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN66-476-CPD-14719/NAD/WATER//CPD-7830/NADH/PROTON.42.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
RXN66-476-CPD-388/NAD/WATER//CPD-8462/NADH/PROTON.40.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
SULFITE-REDUCT-RXNEc-1.8.1.2Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling02
TRANS-2-ENOYL-COA-REDUCTASE-NAD+-RXN-CPD-10267/NAD//T2-DECENOYL-COA/NADH/PROTON.43.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
TRANS-2-ENOYL-COA-REDUCTASE-NAD+-RXN-CPD-10279/NAD//CPD-14281/NADH/PROTON.37.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
TRANS-2-ENOYL-COA-REDUCTASE-NAD+-RXN-CPD-10280/NAD//CPD-14282/NADH/PROTON.37.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
TRANSENOYLCOARED-RXN-CPD-10267/NADP//T2-DECENOYL-COA/NADPH/PROTON.45.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00
TRANSENOYLCOARED-RXN-HEXANOYL-COA/NADP//CPD0-2121/NADPH/PROTON.42.Gap-fillingGapfilling solution with meneco draft mediumAdded for gapfilling00