sparql-examples

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

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

NXQ_00284

rq turtle/ttl

Distribution of interaction detection methods for each year (ENYO data)

Use at

PREFIX : <http://nextprot.org/rdf/>
PREFIX cv: <http://nextprot.org/rdf/terminology/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

select distinct (str(?y) as ?year) (str(?psimi) as ?method) (count (distinct ?itid) as ?itcnt) where {
 ?entry :isoform / :binaryInteraction ?interaction.
 ?interaction :evidence ?ev; :entryAnnotationId ?itid .
  ?ev :reference ?publi; :interactionDetectionMethod / rdfs:label ?psimi .
 ?publi :year ?y.
} group by ?y ?psimi
order by desc(?year) desc(?itcnt)