query-9950b7fdefd57f2f098b585aec133762

rq turtle/ttl

Propertiesinstance of (P31)genetic association (P2293)subclass of (P279)encodes (P688)cell component (P681)part of (P361)has part(s) (P527)physically interacts with (P129)has use (P366)

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 pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?compound ?compoundLabel where {

  # gene has genetic association with a respiratory disease  
  ?gene       wdt:P31    wd:Q7187 .
  ?gene       wdt:P2293  ?diseaseGA .
  ?diseaseGA  wdt:P279*  wd:Q3286546 .

  # gene product is localized to the membrane
  ?gene     wdt:P688             ?protein .
  ?protein  wdt:P681             ?cc .
  ?cc       wdt:P279*|wdt:P361*  wd:Q14349455 .

  # gene is involved in a pathway with another gene (gene2)
  ?pathway  wdt:P31   wd:Q4915012 ;
            wdt:P527  ?gene ;
            wdt:P527  ?gene2 .
  ?gene2    wdt:P31   wd:Q7187 . 

  # gene2 product has a Ser/Thr protein kinase domain AND known enzyme inhibitor  
  ?gene2     wdt:P688  ?protein2 .
  ?protein2  wdt:P129  ?compound ;
             wdt:P527  wd:Q24787419 ;
             p:P129    ?s2 .
  ?s2        ps:P129   ?cp2 .
  ?compound  wdt:P31   wd:Q11173 .
  FILTER EXISTS {?s2 pq:P366 wd:Q427492 .}

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?cc") v9("?compound"):::projected v10("?cp2") v3("?diseaseGA") v2("?gene") v7("?gene2") v6("?pathway") v4("?protein") v8("?protein2") v1("?s2") c22(["en"]):::literal c10(["wd:Q14349455"]):::iri c20(["bd:serviceParam"]):::iri c12(["wd:Q4915012"]):::iri c18(["wd:Q11173"]):::iri c15(["wd:Q24787419"]):::iri c2(["wd:Q427492"]):::iri c4(["wd:Q7187"]):::iri c7(["wd:Q3286546"]):::iri f0[[" "]] subgraph f0e0["Exists Clause"] e0v1 --"p:qualifier/P366"--> e0c2 e0v1("?s2"):::projected e0c2(["wd:Q427492"]):::iri end f0--EXISTS--> f0e0 f0 --> v1 f0 --> c1 f0 --> c2 v1 --"p:qualifier/P366"--> c2 v2 --"p:direct/P31"--> c4 v2 --"p:direct/P2293"--> v3 v3 --"p:direct/P279"--> c7 v2 --"p:direct/P688"--> v4 v4 --"p:direct/P681"--> v5 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v5 --"p:direct/P361"--> c10 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v5 --"p:direct/P279"--> c10 end union0r <== or ==> union0l end v6 --"p:direct/P31"--> c12 v6 --"p:direct/P527"--> v2 v6 --"p:direct/P527"--> v7 v7 --"p:direct/P31"--> c4 v7 --"p:direct/P688"--> v8 v8 --"p:direct/P129"--> v9 v8 --"p:direct/P527"--> c15 v8 --"p:P129"--> v1 v1 --"p:statement/P129"--> v10 v9 --"p:direct/P31"--> c18 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c20 --"wikibase:language"--> c22 end