A set of SPARQL examples that are used in different SIB resources
Connect patents cited in UniProtKB with those in the patent database at EPO via publication number.
PREFIX patent: <http://data.epo.org/linked-data/def/patent/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX up: <http://purl.uniprot.org/core/>
SELECT ?citation ?patent ?application ?applicationNo
WHERE
{
?citation a up:Patent_Citation ;
skos:exactMatch ?patent .
FILTER(CONTAINS(STR(?patent), 'EP'))
BIND(SUBSTR(STR(?patent), 35) AS ?applicationNo)
SERVICE <https://data.epo.org/linked-data/query>{
?application patent:publicationNumber ?applicationNo
}
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?application"):::projected
v3("?applicationNo"):::projected
v2("?citation"):::projected
v1("?patent"):::projected
c3(["up:Patent_Citation"]):::iri
f0[["contains(str(?patent),'EP')"]]
f0 --> v1
v2 --"a"--> c3
v2 --"skos:exactMatch"--> v1
bind1[/"substring(str(?patent),'35^^xsd:integer')"/]
v1 --o bind1
bind1 --as--o v3
subgraph s1["https://data.epo.org/linked-data/query"]
style s1 stroke-width:4px;
v4 --"patent:publicationNumber"--> v3
end