A set of SPARQL examples that are used in different SIB resources
Proteins involved in diseases due to intronic variants with one selected publication
PREFIX : <http://nextprot.org/rdf/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX ncit: <http://ncicb.nci.nih.gov/xml/owl/EVS/Thesaurus.owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sio: <http://semanticscience.org/resource/>
PREFIX so: <http://purl.obolibrary.org/obo/SO_>
SELECT DISTINCT ?entry (str(?gen) as ?gene) ?diseaseTitle ?sampleArticle WHERE {
SERVICE <https://rdf.disgenet.org/sparql> {
SELECT DISTINCT ?protein ?diseaseTitle (sample(?article) as ?sampleArticle) WHERE {
?vda sio:SIO_000628 ?variant,?disease .
?vda sio:SIO_000772 ?article .
?disease a sio:SIO_010299 ; dcterms:title ?diseaseTitle . # true disease, use ncit:C7057 for traits
?variant a so:0001627 ; dcterms:title ?variantTitle . # intron variant
?variant so:associated_with ?gene .
?gene a ncit:C16612; sio:SIO_010078 ?protein .
} group by ?protein ?diseaseTitle
}
BIND(IRI(replace(str(?protein),"purl","www")) AS ?unipage) .
?entry :swissprotPage ?unipage .
?entry :gene / :recommendedName / rdfs:label ?gen .
} order by ?entry