query-373093923ff834744b033a51abd118a2

rq turtle/ttl

أعداد الجينات والأيض لكل مسار Gene and metabolite counts per pathway Gene and metabolite counts per pathway Počty genů a metabolitů pro jednotlivé pathways Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Décompte des gènes et métabolites par voie génétique Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Conteggio dei geni e dei metaboliti per percorso Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Aantal genen en metabolieten per route Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway Gene and metabolite counts per pathway

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Gene and metabolite counts per path
#defaultView:ScatterChart
SELECT ?path ?genes ?metabolites ?pathway WHERE {
  {SELECT DISTINCT ?path (COUNT(?pwPart) AS ?genes) WHERE {
      ?path wdt:P2410 ?WikipathsID.
      ?path wdt:P527 ?pwPart.
      ?pwPart wdt:P31 wd:Q7187.
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
    }
    GROUP BY ?path ?genes
  }
  {SELECT DISTINCT ?path (COUNT(?pwPart) AS ?metabolites) WHERE {
      ?path wdt:P2410 ?WikipathsID.
      ?path wdt:P527 ?pwPart.
      ?pwPart wdt:P31 wd:Q11173.
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
    }
    GROUP BY ?path ?metabolites
  }
  OPTIONAL { ?path rdfs:label ?pathway. }
}
ORDER BY DESC(?genes)

Query found at