Semantic search

This page or action requires Javascript to work, please enable Javascript in your browser or use a browser where this is supported so that functionality can be served and is provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

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

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[Category:Pathway]]
 |?Common-name
 |?Nb reaction found
 |?Nb total reaction
 |?Completion rate
 |format=table
 |limit=50
 |offset=50
 |sort=completion rate, nb total reaction
 |order=descending
 |mainlabel=
}}

Results 51 – 100 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

The query [[Category:Pathway]] was answered by the "SMWSQLStore" in 0.0710 seconds.

SQLStore debug output

ASK Query

[[Category:Pathway]]

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, idst4.smw_sort,idst7.smw_sort
FROM
`sjapgem_smw_object_ids` AS t0
INNER JOIN
`sjapgem_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
(`sjapgem_smw_di_wikipage` AS t4
INNER JOIN
`sjapgem_smw_object_ids` AS idst4 ON idst4.smw_id=t4.o_id) ON t0.smw_id=t4.s_id
INNER JOIN
(`sjapgem_smw_di_wikipage` AS t7
INNER JOIN
`sjapgem_smw_object_ids` AS idst7 ON idst7.smw_id=t7.o_id) ON t0.smw_id=t7.s_id
WHERE
(t1.o_id='832')
   AND (t4.p_id='35058')
   AND (t7.p_id='35066')
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
idst4.smw_sort DESC , idst7.smw_sort ASC
LIMIT
55
OFFSET
50

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ref	s_id,o_id,s_id_2,o_id_2	o_id_2	5	const	1391	Using index; Using temporary; Using filesort
1	SIMPLE	t4	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	p_id	8	const,wikidb.t1.s_id	1	Using where
1	SIMPLE	t7	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	p_id	8	const,wikidb.t1.s_id	1	Using where
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	wikidb.t1.s_id	1	Using where
1	SIMPLE	idst4	eq_ref	PRIMARY,smw_id	PRIMARY	4	wikidb.t4.o_id	1
1	SIMPLE	idst7	eq_ref	PRIMARY,smw_id	PRIMARY	4	wikidb.t7.o_id	1

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None

	Common-name	Nb reaction found	Nb total reaction	Completion rate
PWY-7625	Phosphatidylinositol biosynthesis ii (eukaryotes)	1	1	1.0
GLUTAMINEFUM-PWY	L-glutamine degradation ii	1	1	1.0
ASPARTATE-DEG1-PWY	L-aspartate degradation i	1	1	1.0
POLYAMINSYN3-PWY	Superpathway of polyamine biosynthesis ii	1	1	1.0
PWY-1881	Formate oxidation to co2	1	1	1.0
PWY-5600	Pyruvate fermentation to acetate vii	1	1	1.0
PWY-7270	L-methionine salvage cycle ii (plants)	1	1	1.0
ORN-AMINOPENTANOATE-CAT-PWY	L-ornithine degradation i (l-proline biosynthesis)	1	1	1.0
PWY-7585	Docosahexaenoate biosynthesis ii (bacteria)	1	1	1.0
PWY-7183	Pyrimidine nucleobases salvage i	1	1	1.0
PWY-5326	Sulfite oxidation iv	1	1	1.0
PWY0-1021	L-alanine biosynthesis iii	1	1	1.0
PWY-6759	Hydrogen production iii	1	1	1.0
PWY-7583	Arachidonate biosynthesis ii (bacteria)	1	1	1.0
PWY-2161B	Glutamate removal from folates	1	1	1.0
PWY0-1301	Melibiose degradation	1	1	1.0
PWY-5461	Betanidin degradation	1	1	1.0
ASPARTATESYN-PWY	L-aspartate biosynthesis	1	1	1.0
PWY0-1391	S-methyl-5'-thioadenosine degradation iv	1	1	1.0
PWY-7595	Stearidonate biosynthesis (cyanobacteria)	1	1	1.0
PWY0-662	Prpp biosynthesis i	1	1	1.0
PWY-6698	Oxalate degradation v	1	1	1.0
PWY-5130	2-oxobutanoate degradation i	1	1	1.0
PWY-5640	Nitrobenzene degradation ii	1	1	1.0
PWY-6510	Methanol oxidation to formaldehyde ii	1	1	1.0
GLYSYN-PWY	Glycine biosynthesis i	1	1	1.0
PWY-5844	Menaquinol-9 biosynthesis	1	1	1.0
PWY-5350	Thiosulfate disproportionation iv (rhodanese)	1	1	1.0
GLUTAMINDEG-PWY	L-glutamine degradation i	1	1	1.0
PWY-5805	Nonaprenyl diphosphate biosynthesis i	1	1	1.0
PWY-5148	Acyl-coa hydrolysis	1	1	1.0
PWY1-2	L-alanine degradation iv	1	1	1.0
SAM-PWY	S-adenosyl-l-methionine biosynthesis	1	1	1.0
GLNSYN-PWY	L-glutamine biosynthesis i	1	1	1.0
PWY-5849	Menaquinol-6 biosynthesis	1	1	1.0
PWY-7089	Taxiphyllin bioactivation	1	1	1.0
PWY-5512	Udp-n-acetyl-d-galactosamine biosynthesis i	1	1	1.0
PWY-6273	Phosphatidylethanolamine biosynthesis iii	1	1	1.0
PWY-6520	Nonaprenyl diphosphate biosynthesis ii	1	1	1.0
PWY-5122	Geranyl diphosphate biosynthesis	1	1	1.0
PWY-4821	Udp-α-d-xylose biosynthesis	1	1	1.0
PWY-7686	L-malate degradation ii	1	1	1.0
ALANINE-DEG3-PWY	L-alanine degradation iii	1	1	1.0
PWY-6619	Adenine and adenosine salvage vi	1	1	1.0
PWY-7506	Phosphatidylserine biosynthesis ii	1	1	1.0
PWY0-541	Cyclopropane fatty acid (cfa) biosynthesis	1	1	1.0
PWY-6898	Thiamine salvage iii	1	1	1.0
PWY-6466	Pyridoxal 5'-phosphate biosynthesis ii	1	1	1.0
PWY-5489	Methyl parathion degradation	1	1	1.0
PWY-6183	Salicylate degradation i	1	1	1.0

Semantic search

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Metabolic network components

Reconstruction categories

Reconstruction tools

Tools