query-8d2eaafb5bc8450ea11a1fc4d9f2ed75

rq turtle/ttl

title: Which compounds with known bioactivities were isolated from Actinomycetes (Q62606918), between 2014 and 2019, with related organisms and references? SELECT ?organism ?organism_name ?compound ?compound_inchi (GROUP_CONCAT(DISTINCT ?meshLabel; SEPARATOR = "|") AS ?bioactivities) ?isolation_reference ?reference_title WHERE { ?organism (wdt:P171*) wd:Q62606918; wdt:P225 ?organism_name. ?compound wdt:P234 ?compound_inchi; p:P703 ?statement; (wdt:P2868/wdt:P486) ?meshId. ?statement wikibase:rank wikibase:NormalRank. ?mesh wdt:P486 ?meshId; rdfs:label ?meshLabel. FILTER(LANGMATCHES(LANG(?meshLabel), "EN")) ?statement ps:P703 ?organism; prov:wasDerivedFrom ?ref. ?ref pr:P248 ?isolation_reference. ?isolation_reference wdt:P1476 ?reference_title; wdt:P577 ?reference_date. FILTER(((YEAR(?reference_date)) >= 2014 ) && ((YEAR(?reference_date)) <= 2019 )) } GROUP BY ?organism ?organism_name ?compound ?compound_inchi ?isolation_reference ?reference_title LIMIT 100000

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
#title: Which compounds with known bioactivities were isolated from Actinomycetes (Q62606918), between 2014 and 2019, with related organisms and references?
SELECT ?organism ?organism_name ?compound ?compound_inchi (GROUP_CONCAT(DISTINCT ?meshLabel; SEPARATOR = "|") AS ?bioactivities) ?isolation_reference ?reference_title WHERE {
  ?organism (wdt:P171*) wd:Q62606918;
    wdt:P225 ?organism_name.
  ?compound wdt:P234 ?compound_inchi;
    p:P703 ?statement;
    (wdt:P2868/wdt:P486) ?meshId.
  ?statement wikibase:rank wikibase:NormalRank.
  ?mesh wdt:P486 ?meshId;
    rdfs:label ?meshLabel.
  FILTER(LANGMATCHES(LANG(?meshLabel), "EN"))
  ?statement ps:P703 ?organism;
    prov:wasDerivedFrom ?ref.
  ?ref pr:P248 ?isolation_reference.
  ?isolation_reference wdt:P1476 ?reference_title;
    wdt:P577 ?reference_date.
  FILTER(((YEAR(?reference_date)) >= 2014 ) && ((YEAR(?reference_date)) <= 2019 ))
}
GROUP BY ?organism ?organism_name ?compound ?compound_inchi ?isolation_reference ?reference_title
LIMIT 100000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v13("?bioactivities") v5("?compound"):::projected v6("?compound_inchi"):::projected v11("?isolation_reference"):::projected v9("?mesh") v8("?meshId") v2("?meshLabel"):::projected v3("?organism"):::projected v4("?organism_name"):::projected v10("?ref") v1("?reference_date") v12("?reference_title"):::projected v7("?statement") a1((" ")) c12(["wikibase:NormalRank"]):::iri c5(["wd:Q62606918"]):::iri f0[["year-from-dateTime(?reference_date) >= '2014^^xsd:integer'year-from-dateTime(?reference_date) <= '2019^^xsd:integer'"]] f0 --> v1 f1[["langmatch(?meshLabel,'EN')"]] f1 --> v2 v3 --"p:direct/P171"--> c5 v3 --"p:direct/P225"--> v4 v5 --"p:direct/P234"--> v6 v5 --"p:P703"--> v7 v5 --"p:direct/P2868"--> a1 a1 --"p:direct/P486"--> v8 v7 --"wikibase:rank"--> c12 v9 --"p:direct/P486"--> v8 v9 --"rdfs:label"--> v2 v7 --"p:statement/P703"--> v3 v7 --"prov:wasDerivedFrom"--> v10 v10 --"p:reference/P248"--> v11 v11 --"p:direct/P1476"--> v12 v11 --"p:direct/P577"--> v1 bind3[/"?meshLabel"/] v2 --o bind3 bind3 --as--o v13