query-95d95c972dc71e76cd0e4e193f59fef3
TODO
Use at
- https://query.wikidata.org/sparql
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 p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?title ?pmid ?pmcid ?doi ?protLabel ?rna ?rev ?omics ?autoi
(MIN(?pdate) AS ?pubdate)
{
VALUES ?pw { wd:Q82069695 }
VALUES ?top { wd:Q7202 wd:Q128406 wd:Q908902 }
?item p:P921 [ ps:P921 ?pw].
?item p:P921 [ ps:P921 ?top].
?item wdt:P1476 ?title.
?item wdt:P577 ?pdate.
OPTIONAL {
?item wdt:P921 ?prot.
?prot wdt:P31 wd:Q8054.
?prot wdt:P703 ?pw.
}
OPTIONAL {
?item wdt:P698 ?pmid.
}
OPTIONAL {
?item wdt:P932 ?pmcid.
}
OPTIONAL {
?item wdt:P356 ?doi.
}
OPTIONAL {
?item ?rna wd:Q11053.
}
OPTIONAL {
?item ?rev wd:Q7318358.
}
OPTIONAL {
VALUES ?omic { wd:Q471857 wd:Q28946449 wd:Q1098876 wd:Q106472333 wd:Q3589153 wd:Q105406038 }
?item ?omics ?omic.
}
OPTIONAL {
?item ?autoi wd:Q8084905.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}
GROUP BY ?item ?title ?pmid ?pmcid ?doi ?protLabel ?rna ?rev ?omics ?autoi
ORDER BY ?pubdate
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v15("?autoi"):::projected
v10("?doi"):::projected
v4("?item"):::projected
v13("?omic")
v14("?omics"):::projected
v6("?pdate"):::projected
v9("?pmcid"):::projected
v8("?pmid"):::projected
v7("?prot")
v16("?pubdate")
v2("?pw")
v12("?rev"):::projected
v11("?rna"):::projected
v5("?title"):::projected
v3("?top")
a1((" "))
a2((" "))
c13(["wd:Q7318358"]):::iri
c18(["en"]):::literal
c16(["bd:serviceParam"]):::iri
c12(["wd:Q11053"]):::iri
c7(["wd:Q8054"]):::iri
c14(["wd:Q8084905"]):::iri
bind0[/VALUES ?pw/]
bind0-->v2
bind00(["wd:Q82069695"])
bind00 --> bind0
bind1[/VALUES ?top/]
bind1-->v3
bind10(["wd:Q7202"])
bind10 --> bind1
bind11(["wd:Q128406"])
bind11 --> bind1
bind12(["wd:Q908902"])
bind12 --> bind1
a1 --"p:statement/P921"--> v2
v4 --"p:P921"--> a1
a2 --"p:statement/P921"--> v3
v4 --"p:P921"--> a2
v4 --"p:direct/P1476"--> v5
v4 --"p:direct/P577"--> v6
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v4 -."p:direct/P921".-> v7
v7 --"p:direct/P31"--> c7
v7 --"p:direct/P703"--> v2
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v4 -."p:direct/P698".-> v8
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v4 -."p:direct/P932".-> v9
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v4 -."p:direct/P356".-> v10
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v4 -->v11--> c12
end
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v4 -->v12--> c13
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
bind2[/VALUES ?omic/]
bind2-->v13
bind20(["wd:Q471857"])
bind20 --> bind2
bind21(["wd:Q28946449"])
bind21 --> bind2
bind22(["wd:Q1098876"])
bind22 --> bind2
bind23(["wd:Q106472333"])
bind23 --> bind2
bind24(["wd:Q3589153"])
bind24 --> bind2
bind25(["wd:Q105406038"])
bind25 --> bind2
v4 -->v14--> v13
end
subgraph optional7["(optional)"]
style optional7 fill:#bbf,stroke-dasharray: 5 5;
v4 -->v15--> c14
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c16 -."wikibase:language".-> c18
end
bind4[/"min(?pdate)"/]
v6 --o bind4
bind4 --as--o v16