query-5eaad0a0d7c8838269f26a15d03a7308

rq turtle/ttl

PropertiesEntrez Gene ID (P351)found in taxon (P703)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT ?entrez_id ?cid ?article ?label WHERE {
    ?cid wdt:P351 ?entrez_id .
    ?cid wdt:P703 wd:Q15978631 . 
    OPTIONAL { ?cid rdfs:label ?label filter (lang(?label) = "en") . }
    ?article schema:about ?cid .
    ?article schema:inLanguage "en" .
    FILTER (SUBSTR(str(?article), 1, 25) = "https://en.wikipedia.org/") . 
    FILTER (SUBSTR(str(?article), 1, 38) != "https://en.wikipedia.org/wiki/Template")
} limit 10

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?article"):::projected v3("?cid"):::projected v4("?entrez_id"):::projected v2("?label"):::projected c6(["en"]):::literal c9(["wd:Q15978631"]):::iri f0[["substring(str(?article),'1^^xsd:integer','38^^xsd:integer') != 'https://en.wikipedia.org/wiki/Template'"]] f0 --> v1 f1[["substring(str(?article),'1^^xsd:integer','25^^xsd:integer') = 'https://en.wikipedia.org/'"]] f1 --> v1 v3 --"wdt:P351"--> v4 v3 --"wdt:P703"--> c9 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."rdfs:label".-> v2 end v1 --"schema:about"--> v3 v1 --"schema:inLanguage"--> c6