sparql-examples

A set of SPARQL examples that are used in different SIB resources

View the Project on GitHub sib-swiss/sparql-examples

42

Connect patents cited in UniProtKB with those in the patent database at EPO via publication number.

Use at

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