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:Metabolite]]
 |?Common-name
 |format=table
 |limit=50
 |offset=100
 |sort=
 |order=asc
 |mainlabel=
}}

Results 101 – 150 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

The query [[Category:Metabolite]] was answered by the "SMWSQLStore" in 0.0476 seconds.

SQLStore debug output

ASK Query

[[Category:Metabolite]]

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
`cokagem_smw_object_ids` AS t0
INNER JOIN
`cokagem_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id='516')
  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
100

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	3316	Using index; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	wikidb.t1.s_id	1	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None

	Common-name
2-Hydroxy-carboxylates	A 2-hydroxy carboxylate
2-KETO-3-DEOXY-6-P-GLUCONATE	2-dehydro-3-deoxy-d-gluconate 6-phosphate
2-KETO-3-METHYL-VALERATE	(s)-3-methyl-2-oxopentanoate
2-KETO-6-AMINO-CAPROATE	6-amino-2-oxohexanoate
2-KETO-GLUTARAMATE	2-oxoglutaramate
2-KETO-ISOVALERATE	3-methyl-2-oxobutanoate
2-KETOGLUTARATE	2-oxoglutarate
2-LYSOPHOSPHATIDYLETHANOLAMINES	A 1-acyl 2-lyso-phosphatidylethanolamine
2-Lysophosphatidylcholines	A 1-acyl-sn-glycero-3-phosphocholine
2-METHYL-3-HYDROXY-BUTYRYL-COA	(2s,3s)-3-hydroxy-2-methylbutanoyl-coa
2-METHYL-3-PHYTYL-14-NAPHTHOQUINONE	Phylloquinone
2-METHYL-6-SOLANYL-14-BENZOQUINONE	2-methyl-6-all-trans-nonaprenyl-1,4-benzoquinol
2-METHYL-ACETO-ACETYL-COA	2-methylacetoacetyl-coa
2-METHYL-BUTYRYL-COA	2-methylbutanoyl-coa
2-METHYLMALEATE	Citraconate
2-Me-Branched-234-Sat-FA	A 2-methyl branched 2,3,4-saturated fatty acid
2-Me-Branched-234-Sat-FALD	A 2-methyl branched 2,3,4-saturated fatty aldehyde
2-Me-Branched-234-Sat-Fatty-Acyl-CoA	A 2-methyl branched 2,3,4-saturated fatty acyl-coa
2-Methoxy-6-Polyprenyl-14-Benzoquinols	A 2-methoxy-6-all-trans-polyprenyl-1,4-benzoquinol
2-Methoxy-6-polyprenyl-phenols	A 2-methoxy-6-(all-trans-polyprenyl)phenol
2-O-MeCytidine4-tRNAGLY-GCC	A 2'-o-methylcytidine4 in trnagly(gcc)
2-O-MeGuan-34-tRNAs	A 2'-o-methylguanosine34 in trna
2-O-Methylcytidine-32-tRNAs	A 2'-o-methylcytidine32 in trna
2-O-Methylcytidine-34-tRNAs	A 2'-o-methylcytidine34 in trna
2-O-Methylguanosine18	A 2'-o-methylguanosine18 in trna
2-OCTAPRENYL-6-HYDROXYPHENOL	3-(all-trans-octaprenyl)benzene-1,2-diol
2-OCTAPRENYL-6-METHOXYPHENOL	2-methoxy-6-(all-trans-octaprenyl)phenol
2-OCTAPRENYLPHENOL	2-octaprenylphenol
2-OH-3-Methyl-Saturated-Fatty-Acyl-CoA	A 2-hydroxy-3-methyl-branched 2,3,4-saturated fatty acyl-coa
2-OXOBUTANOATE	2-oxobutanoate
2-Octenoyl-ACPs
2-Oxo-carboxylates	A 2-oxo carboxylate
2-PG	2-phospho-d-glycerate
2-PHOSPHO-4-CYTIDINE-5-DIPHOSPHO-2-C-MET	2-phospho-4-(cytidine 5'-diphospho)-2-c-methyl-d-erythritol
2-PROTOCATECHUOYLPHLOROGLUCINOLCARBOXYLA	2-protocatechuoylphloroglucinolcarboxylate
2-Palmitoyl-L-Phosphatidate	A 1-acyl-2-palmitoyl-sn-glycerol 3-phosphate
2-Prime-Ribonucleoside-Monophosphates	A ribonucleoside 2'-phosphate
2-TRANS6-TRANS-FARNESAL	(2e,6e)-farnesal
2-hydroxyacyl-glutathiones	S-(2-hydroxyacyl)glutathione
2-phospho-ligated-tRNA
2-trans-4-cis-dienoyl-CoAs	A 2-trans-4-cis-dienoyl-coa
23-DIPHOSPHOGLYCERATE	2,3-diphospho-d-glycerate
23-EPOXY-23-DIHYDRO-2-METHYL-14-NAPHTHOQ	Vitamin k 2,3-epoxide
23-HYDROXY-DELTA1-2,31-NORCYCLOARTENONE
23S-RRNA-N2-METHYLGUANINE2445	An n2-methylguanine2445 in 23s rrna
23S-rRNA-2-O-methyluridine2552	A 2'-o-methyluridine2552 in 23s rrna
23S-rRNA-2-methyladenine2503	A 2-methyladenine2503 in 23s rrna
23S-rRNA-5-methylcytosine1962	A 5-methylcytosine1962 in 23s rrna
23S-rRNA-5-methyluracil1939	A 5-methyluracil1939 in 23s rrna
23S-rRNA-N3-methylpseudouridine1915	An n3-methylpseudouridine1915 in 23s rrna

Semantic search

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Metabolic network components

Reconstruction categories

Reconstruction tools

Tools