SPARQL
Endpoint
Ontologies
Examples
Number of publications by type
RQ_001.sparql
PREFIX : <http://sibils.org/rdf#>
SELECT
?publi_class (count(*) as ?count)
WHERE {
?s :hasPubMedCentralId ?o.
?s a ?publi_class.
}
GROUP BY ?publi_class
Annotations of a given publication
RQ_002.sparql
PREFIX : <http://sibils.org/rdf#>
PREFIX sibils: <http://sibils.org/rdf/data/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT
(str(?doi) as ?doi)
(str(?cpt_id) as ?cpt_id)
(str(?scheme) as ?scheme)
(str(?start) as ?start)
(str(?token) as ?token)
(str(?part) as ?section)
(str(?part_type) as ?part_type)
WHERE {
VALUES ?publi { sibils:PMC2196267 }
?publi :doi ?doi.
?publi :hasAnnotation ?a .
?a :hasBody ?cpt .
?cpt skos:notation ?cpt_id .
?cpt skos:inScheme / rdfs:label ?scheme .
?a :hasTarget ?trg.
?trg :hasSource ?part.
?part a ?part_type .
?trg :hasSelector ?sel .
?sel :start ?start.
?sel :exact ?token.
# FILTER (?part_type != :Paragraph )
}
ORDER BY ?part ?start ?token
LIMIT 100
Diseases associated to ticks in the same discourse element of a publication at a distance of less than 30 characters
RQ_003.sparql
PREFIX : <http://sibils.org/rdf#>
PREFIX sibils: <http://sibils.org/rdf/data/>
PREFIX sibilc: <http://sibils.org/rdf/concept/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT
?part
(str(?word) as ?token)
?pos
(str(?word2) as ?token2)
?pos2
WHERE {
?publi :hasAnnotation ?a .
?a :hasBody sibilc:Mesh_St%7CD013987 .
?a :hasTarget ?trg .
?trg :hasSelector ?sel .
?sel :exact ?word.
?sel :start ?pos .
?trg :hasSource ?part.
?publi :hasAnnotation ?a2 .
?a2 :hasTarget ?trg2.
?trg2 :hasSelector ?sel2 .
?sel2 :exact ?word2.
?sel2 :start ?pos2 .
?trg2 :hasSource ?part.
?a2 :hasBody ?cpt2.
?cpt2 skos:inScheme :Ncit_St.
FILTER (abs(?pos2 - ?pos) < 30 && ?a != ?a2)
}