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:Reaction]] [[Reconstruction tool::Pantograph]]
 |?Common-name
 |?Ec-number
 |?Reconstruction category
 |?Reconstruction source
 |?Reconstruction comment
 |?Nb gene associated
 |?Nb pathway associated
 |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:Reaction]] [[Reconstruction tool::Pantograph]] was answered by the "SMWSQLStore" in 0.0638 seconds.

SQLStore debug output

ASK Query

[[Category:Reaction]] [[Reconstruction tool::Pantograph]]

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
`esubgem_smw_object_ids` AS t0
INNER JOIN
(`esubgem_smw_fpt_inst` AS t2
INNER JOIN
`esubgem_smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id='27929'
   AND (t4.p_id='27927' AND t4.o_id='27928')
  )
  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	t4	ref\|filter	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	o_id\|p_id	5\|4	const	417 (4%)	Using where; Using temporary; Using filesort; Using rowid filter
1	SIMPLE	t2	ref	s_id,o_id,s_id_2,o_id_2	s_id_2	9	wikidb.t4.s_id,const	1	Using index
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	wikidb.t4.s_id	1	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:3
Query-Depth:1

Errors and Warnings

None

	Common-name	Ec-number	Reconstruction category	Reconstruction source	Reconstruction comment	Nb gene associated	Nb pathway associated
DIHYDROXYMETVALDEHYDRAT-RXN	2,3-dihydroxy-3-methylvalerate dehydratase 2,3-dihydroxy-3-methylvalerate hydro-lyase	Ec-4.2.1.9	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	2	4
DIPHOSPHOMEVALONTE-DECARBOXYLASE-RXN	Diphosphomevalonate decarboxylase	Ec-4.1.1.33	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	4	2
DNA-CYTOSINE-5--METHYLTRANSFERASE-RXN	Dna-cytosine methyltransferase	Ec-2.1.1.37	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	3	0
DTDPGLUCDEHYDRAT-RXN	Dtdp-glucose 4,6-dehydratase	Ec-4.2.1.46	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	3	19
DTDPKIN-RXN	Nucleoside diphosphate kinase Dtdp kinase	Ec-2.7.4.6	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	27	7
DUDPKIN-RXN	Nucleoside diphosphate kinase Dudp kinase	Ec-2.7.4.6	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	27	3
DUTP-PYROP-RXN	Deoxyuridine triphosphatase	Ec-3.6.1.9 Ec-3.6.1.23	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	11	5
DXS-RXN	1-deoxy-d-xylulose-5-phosphate synthase	Ec-2.2.1.7	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	1	5
F16BDEPHOS-RXN	Fructose 1,6-bisphosphate 1-phosphatase	Ec-3.1.3.11	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	13	7
FERREDOXIN--NITRITE-REDUCTASE-RXN		Ec-1.7.7.1	Orthology	Output pantograph a.taliana.aragem	N.a	1	2
FGAMSYN-RXN	Phosphoribosylformylglycinamide synthetase	Ec-6.3.5.3	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	3	3
FRUCTOKINASE-RXN	Manno(fructo)kinase	Ec-2.7.1.4	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	1	8
FUMHYDR-RXN	Fumarase c	Ec-4.2.1.2	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	4	16
GALACTOKIN-RXN	Galactokinase	Ec-2.7.1.6	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	2	4
GAPOXNPHOSPHN-RXN	Glyceraldehyde-3-phosphate dehydrogenase	Ec-1.2.1.12	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	8	13
GDPKIN-RXN	Nucleoside diphosphate kinase Gdp kinase	Ec-2.7.4.6	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	27	2
GDPMANDEHYDRA-RXN	Gdp-mannose 4,6-dehydratase	Ec-4.2.1.47	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	6	6
GDPREDUCT-RXN	Gdp reductase Ribonucleoside-diphosphate reductase activity, thioredoxin disulfide as acceptor	Ec-1.17.4.1	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	22	2
GLUC1PURIDYLTRANS-RXN	Utp—glucose-1-phosphate uridylyltransferase	Ec-2.7.7.64 Ec-2.7.7.9	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	3	5
GLUTAMATE-DEHYDROGENASE-RXN	Glutamate dehydrogenase (nad+)	Ec-1.4.1.2	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	4	6
GLUTAMATE-SYNTHASE-FERREDOXIN-RXN	Glutamate synthase (ferredoxin)	Ec-1.4.7.1	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	2	3
GLUTAMATE-SYNTHASE-NADH-RXN	Glutamate synthase	Ec-1.4.1.14	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	12	2
GLUTAMATESYN-RXN		Ec-1.4.1.13	Orthology	Output pantograph a.taliana.aragem	N.a	1	2
GLUTAMINESYN-RXN	Glutamine synthetase Glutamate-ammonia ligase	Ec-6.3.1.2	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	8	7
GLUTATHIONE-REDUCT-NADPH-RXN	Glutathione reductase	Ec-1.8.1.7	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	2	1
GLUTATHIONE-SYN-RXN	Glutathione synthetase	Ec-6.3.2.3	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	2	1
GLUTKIN-RXN	Glutamate 5-kinase	Ec-2.7.2.11	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	3	5
GLUTSEMIALDEHYDROG-RXN	Glutamate-5-semialdehyde dehydrogenase	Ec-1.2.1.41	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	2	5
GLYCEROL-KIN-RXN	Glycerol kinase	Ec-2.7.1.30	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	1	1
GLYRIBONUCSYN-RXN	Phosphoribosylamine-glycine ligase	Ec-6.3.4.13	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	1	3
GMP-SYN-GLUT-RXN	Xanthosine-5'-phosphate:l-glutamine amido-ligase (amp-forming)	Ec-6.3.5.2	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	9	1
GMP-SYN-NH3-RXN	Xanthosine-5'-phosphate:ammonia ligase (amp-forming)		Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	9	0
GSAAMINOTRANS-RXN	Glutamate-1-semialdehyde aminotransferase	Ec-5.4.3.8	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	1	1
GSHTRAN-RXN	Glutathione transferase	Ec-2.5.1.18	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	11	2
GTP-CYCLOHYDRO-II-RXN	Gtp cyclohydrolase ii	Ec-3.5.4.25	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	5	4
GUANOSINE-DIPHOSPHATASE-RXN		Ec-3.6.1.42	Orthology	Output pantograph a.taliana.aragem	N.a	1	0
GUANYL-KIN-RXN	Guanylate kinase	Ec-2.7.4.8	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	2	1
H2NEOPTERINP3PYROPHOSPHOHYDRO-RXN	Dihydroneopterin triphosphate pyrophosphohydrolase	Ec-3.6.1.67	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	24	1
H2PTERIDINEPYROPHOSPHOKIN-RXN	2-amino-4-hydroxy-6-hydroxymethyldihydropteridine diphosphokinase	Ec-2.7.6.3	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	2	5
H2PTEROATESYNTH-RXN		Ec-2.5.1.15	Orthology	Output pantograph a.taliana.aragem	N.a	1	1
HEMN-RXN		Ec-1.3.98.3	Orthology	Output pantograph a.taliana.aragem	N.a	1	2
HISTAMINOTRANS-RXN	Histidinol-phosphate transaminase	Ec-2.6.1.9	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	2	1
HISTCYCLOHYD-RXN	Phosphoribosyl-amp cyclohydrolase	Ec-3.5.4.19	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	3	1
HISTOLDEHYD-RXN	Histidinol dehydrogenase		Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	1	1
HISTPRATPHYD-RXN	Phosphoribosyl-atp diphosphatase	Ec-3.6.1.31	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	3	1
HOMOCYSMET-RXN	5-methyltetrahydropteroyltriglutamate-homocysteine s-methyltransferase	Ec-2.1.1.14	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	1	5
HOMOCYSTEINE-S-METHYLTRANSFERASE-RXN	S-adenosylmethionine-homocysteine s-methyltransferase	Ec-2.1.1.10	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	3	0
HOMOSERKIN-RXN	Homoserine kinase	Ec-2.7.1.39	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	1	2
HYDROXYMETHYLGLUTARYL-COA-LYASE-RXN	Hydroxymethylglutaryl-coa lyase	Ec-4.1.3.4	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	1	3
HYDROXYMETHYLGLUTARYL-COA-SYNTHASE-RXN	Hydroxymethyl glutaryl-coa synthase Hydroxymethylglutaryl-coa synthase	Ec-2.3.3.10	Annotation Orthology	Ectocarpus subulatus Output pantograph a.taliana.aragem	N.a	5	6

Semantic search

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Metabolic network components

Reconstruction categories

Reconstruction tools

Tools