@prefix ex: <https://sparql.metanetx.org/.well-known/sparql-examples/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix schema: <https://schema.org/> .
@prefix sh: <http://www.w3.org/ns/shacl#> .

ex:11 a sh:SPARQLExecutable,
        sh:SPARQLSelectExecutable ;
    rdfs:comment "Building on example 10. ...in addition reactions are endowed with a direction, flux bounds and possibly the description of the enzymes that catalyze it."@en ;
    sh:prefixes _:sparql_examples_prefixes ;
    sh:select """PREFIX mnx: <https://rdf.metanetx.org/schema/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

# Building on example 10. ...in addition reactions are endowed with a direction, flux
# bounds and possibly the description of the enzymes that
# catalyze it.

SELECT ?reac_orig_label ?reac_mnx_label ?lb ?ub ?dir ?cata_orig (GROUP_CONCAT(?cplx_label ; separator=' OR ') AS ?cplx_info )
WHERE{
    ?mnet rdfs:label 'bigg_e_coli_core';
          mnx:gpr ?gpr .
    ?gpr rdfs:label ?reac_orig_label ;
         rdfs:comment ?cata_orig ;
         mnx:reac ?reac ;
         mnx:cata ?cata .
    ?reac rdfs:label ?reac_mnx_label .
    ?cata mnx:lb ?lb ;
          mnx:ub ?ub ;
          mnx:dir ?dir ;
          mnx:cplx ?cplx .
    ?cplx rdfs:label ?cplx_label .
}
GROUP BY ?reac ?reac_orig_label ?reac_mnx_label ?lb ?ub ?dir ?cata_orig ORDER BY (?reac)""" ;
    schema:target <https://rdf.metanetx.org/sparql/> .

