query-b4d80a058166d1ee360af77b9f4b5147

rq turtle/ttl

الأيضات والأنواع التي توجد فيها Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolity a druhy, ve kterých se vyskytují Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in Métabolites et les espèces qui les hébergent Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in I metaboliti e le specie in cui si trovano Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolieten en de soorten waarin ze voorkomen Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolier och arterna de finns i Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in Metabolites and the species where they are found in

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX prov: <http://www.w3.org/ns/prov#>

SELECT ?compound ?compoundLabel ?speciesLabel ?sourceLabel ?doi ?wpid WHERE {
  ?compound wdt:P31 wd:Q11173.
  MINUS { ?compound wdt:P31 wd:Q8054. }
  ?compound p:P703 ?statement.
  ?statement rdf:type wikibase:BestRank.
  ?statement ps:P703 ?species.
  OPTIONAL {
    ?statement (prov:wasDerivedFrom/pr:P248) ?source.
    OPTIONAL { ?source wdt:P2410 ?wpid. }
    OPTIONAL { ?source wdt:P356 ?doi. }
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ASC(?compound)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?compound"):::projected v6("?doi"):::projected v4("?source") v3("?species") v2("?statement") v5("?wpid"):::projected a1((" ")) c6(["wikibase:BestRank"]):::iri c15(["en"]):::literal c13(["bd:serviceParam"]):::iri c2(["wd:Q11173"]):::iri c3(["wd:Q8054"]):::iri v1 --"p:direct/P31"--> c2 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v1 --"p:direct/P31"--> c3 end v1 --"p:P703"--> v2 v2 --"a"--> c6 v2 --"p:statement/P703"--> v3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."prov:wasDerivedFrom".-> a1 a1 --"p:reference/P248"--> v4 subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P2410".-> v5 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P356".-> v6 end end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end