query-fd21267c75511cb2c73c51860dc9ae7b

rq turtle/ttl

Propertiesparent taxon (P171)taxon rank (P105)Plants of the World Online ID (P5037)IPNI plant ID (P961)

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#>
PREFIX gas: <http://www.bigdata.com/rdf/gas#>
SELECT DISTINCT ?qid ?ipni ?comment
WHERE
{
  SERVICE gas:service {
    gas:program gas:gasClass "com.bigdata.rdf.graph.analytics.SSSP" ;
                gas:in wd:Q21908; # parent taxon Malvales
                gas:traversalDirection "Reverse" ;
                gas:out ?item ;
                gas:out1 ?depth ;
                gas:maxIterations 10 ;
                gas:linkType wdt:P171 .
  }
  ?item wdt:P105 wd:Q7432; # taxon rank species
        wdt:P5037 ?powo.
  FILTER ( NOT EXISTS { ?item wdt:P961 ?id. } )
  OPTIONAL { ?item wdt:P171 ?linkTo }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
    ?item rdfs:label ?itemLabel .
  }
  FILTER ( !STRENDS(?powo, "-4") ) # POWO IDs ending in -4 are temporary, see: https://powo.science.kew.org/about 
  BIND (CONCAT('"', STRAFTER(?powo, "urn:lsid:ipni.org:names:"), '"') AS ?ipni ) # surround with """ for Quickstatements v2
  BIND ("parsed from existing POWO identifier" AS ?comment)
  BIND (ENCODE_FOR_URI(REPLACE(STR(?item), ".*Q", "Q")) AS ?qid)
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?comment"):::projected v4("?depth") v3("?id") v7("?ipni"):::projected v2("?item") v6("?itemLabel") v5("?linkTo") v1("?powo") v9("?qid"):::projected c4(["gas:program"]):::iri c6(["com.bigdata.rdf.graph.analytics.SSSP"]):::literal c10(["Reverse"]):::literal c23(["en"]):::literal c8(["wd:Q21908"]):::iri c18(["wd:Q7432"]):::iri c21(["bd:serviceParam"]):::iri c16(["wdt:P171"]):::iri c14(["10^^xsd:integer"]):::literal f0[["not ends-with(?powo,'-4')"]] f0 --> v1 f1[["not "]] subgraph f1e0["Exists Clause"] e0v1 --"wdt:P961"--> e0v2 e0v2("?id"):::projected e0v1("?item"):::projected end f1--EXISTS--> f1e0 f1 --> v2 f1 --> c2 f1 --> v3 v2 --"wdt:P961"--> v3 subgraph s1["http://www.bigdata.com/rdf/gas#service"] style s1 stroke-width:4px; c4 --"gas:gasClass"--> c6 c4 --"gas:in"--> c8 c4 --"gas:traversalDirection"--> c10 c4 --"gas:out"--> v2 c4 --"gas:out1"--> v4 c4 --"gas:maxIterations"--> c14 c4 --"gas:linkType"--> c16 end v2 --"wdt:P105"--> c18 v2 --"wdt:P5037"--> v1 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -->c16--> v5 end subgraph s2["http://wikiba.se/ontology#label"] style s2 stroke-width:4px; c21 -."wikibase:language".-> c23 v2 --"rdfs:label"--> v6 end bind2[/"concat('"',substring-after(?powo,'urn:lsid:ipni.org:names:'),'"')"/] v1 --o bind2 bind2 --as--o v7 bind3[/"'parsed from existing POWO identifier'"/] bind3 --as--o v8 bind4[/"encode-for-uri(replace(str(?item),'.*Q','Q'))"/] v2 --o bind4 bind4 --as--o v9