query-652aeeb4b86c23f5a60d689e66d428fb

rq turtle/ttl

PropertiespKa (P1117)

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:Dimensions
PREFIX wp:      <http://vocabularies.wikipathways.org/wp#>
PREFIX dcterms:  <http://purl.org/dc/terms/>
PREFIX dc:      <http://purl.org/dc/elements/1.1/> 
SELECT DISTINCT ?pwTitle ?metabolite1Label ?pKa1 ?pKa2 ?metabolite2Label WHERE {
  ?metabolite2 wdt:P1117 ?pKa2 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  {SELECT * WHERE {
    ?metabolite1 wdt:P1117 ?pKa1 .
    {SELECT * WHERE {
       SERVICE <http://sparql.wikipathways.org/> {
         ?pathway dc:identifier ?pw ;
                  dc:title ?pwTitle ;
                   wp:organismName "Homo sapiens"^^xsd:string .
         ?interaction rdf:type wp:Interaction ;
                wp:participants ?wpmb1, ?wpmb2 ;
                dcterms:isPartOf ?pathway .
          ?wpmb1 wp:bdbWikidata ?metabolite1 .
          ?wpmb2 wp:bdbWikidata ?metabolite2 .
         FILTER (?wpmb1 != ?wpmb2)}
     }
    }
   }
  }
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v10("?interaction") v3("?metabolite1") v1("?metabolite2") v4("?pKa1"):::projected v2("?pKa2"):::projected v7("?pathway") v8("?pw") v9("?pwTitle"):::projected v5("?wpmb1") v6("?wpmb2") c12([http://vocabularies.wikipathways.org/wp#Interaction]):::iri c10(["Homo sapiens"]):::literal c3(["bd:serviceParam"]):::iri c5(["#91;AUTO_LANGUAGE#93;,en"]):::literal v1 --"wdt:P1117"--> v2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c3 --"wikibase:language"--> c5 end v3 --"wdt:P1117"--> v4 subgraph s2["http://sparql.wikipathways.org/"] style s2 stroke-width:4px; f0[["?wpmb1 != ?wpmb2"]] f0 --> v5 f0 --> v6 v7 --http://purl.org/dc/elements/1.1/identifier--> v8 v7 --http://purl.org/dc/elements/1.1/title--> v9 v7 --http://vocabularies.wikipathways.org/wp#organismName--> c10 v10 --"a"--> c12 v10 --http://vocabularies.wikipathways.org/wp#participants--> v5 v10 --http://vocabularies.wikipathways.org/wp#participants--> v6 v10 --http://purl.org/dc/terms/isPartOf--> v7 v5 --http://vocabularies.wikipathways.org/wp#bdbWikidata--> v3 v6 --http://vocabularies.wikipathways.org/wp#bdbWikidata--> v1 end