sparql-examples

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

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

NXQ_00020

rq turtle/ttl

Proteins with at least 2 HPA antibodies whose genes are located on chromosome 21 and that are highly expressed according to IHC in heart

Use at

PREFIX : <http://nextprot.org/rdf/>
PREFIX nextprot_cv: <http://nextprot.org/rdf/terminology/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

select ?entry WHERE {
 SELECT DISTINCT ?entry ?id WHERE {
 ?entry :gene / :chromosome "21"^^xsd:string .
 ?entry :isoform / :expressionProfile ?s1.
 ?s1 :term / :childOf nextprot_cv:TS-0445.
 ?s1 :evidence ?evi.
 ?evi :observedExpression :High.
 ?evi :evidenceCode nextprot_cv:ECO_0001055.
 ?entry :isoform / :antibodyMapping ?map.
	 ?map :evidence / :reference / :accession ?id .
 }
} group by ?entry having (count(?id)>=2)
:gene
:chromosome
:isoform
:expressionProfile
:term
:childOf
:evidence
:observedExpression
:evidenceCode
:isoform
:antibodyMapping
:evidence
:reference
:accession
as
?_anon_cf59833c8ba14673a3755a4de276c41e5454
?entry
?evi
?id
?map
?s1
:High
:terminology/ECO_0001055
:terminology/TS-0445
21
>= '2^^xsd:integer'
count(?id)