17,519
edits
(Created page with " <sparql tryit="1"> # list all taxon items PREFIX pp: <https://ppsdb.wikibase.cloud/entity/> PREFIX ppt: <https://ppsdb.wikibase.cloud/prop/direct/> SELECT DISTINCT ?item ?itemLabel WHERE { ?item ppt:P18 pp:Q2. SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } </sparql>") |
No edit summary |
||
Line 1: | Line 1: | ||
===List all taxon items=== | |||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# list all taxon items | # list all taxon items | ||
Line 7: | Line 7: | ||
SELECT DISTINCT ?item ?itemLabel WHERE { | SELECT DISTINCT ?item ?itemLabel WHERE { | ||
?item ppt:P18 pp:Q2. | ?item ppt:P18 pp:Q2. | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
</sparql> | |||
===List all interactions, optionally the localization and interaction type=== | |||
<sparql tryit="1"> | |||
PREFIX pp: <https://ppsdb.wikibase.cloud/entity/> | |||
PREFIX ppt: <https://ppsdb.wikibase.cloud/prop/direct/> | |||
PREFIX pps: <https://ppsdb.wikibase.cloud/prop/> | |||
PREFIX ppss: <https://ppsdb.wikibase.cloud/prop/statement/> | |||
PREFIX ppsq: <https://ppsdb.wikibase.cloud/prop/qualifier/> | |||
SELECT DISTINCT ?host ?hostLabel ?typeLabel ?symbiontLabel ?localizationLabel WHERE { | |||
?host pps:P19 ?interaction. | |||
?interaction ppss:P19 ?symbiont. | |||
OPTIONAL { | |||
?interaction ppsq:P20 ?localization. | |||
} | |||
OPTIONAL { | |||
?interaction ppsq:P26 ?type. | |||
} | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
</sparql> | </sparql> |