A set of SPARQL examples that are used in different SIB resources
Check there are no entries in the Ion channels variants portal that do not have a variant phenotype annotation
PREFIX : <http://nextprot.org/rdf/>
PREFIX cv: <http://nextprot.org/rdf/terminology/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
select distinct ?entry where {
values ?gene
{"SCN1A" "SCN2A" "SCN3A" "SCN4A" "SCN5A" "SCN8A" "SCN9A" "SCN10A" "SCN11A"} # space-separated
?entry :gene / :name / rdfs:label ?genename .
bind (str(?genename) as ?gn) # here we convert "xxx"^^xsd:string to "xxx" to match the values
filter(?gn = ?gene)
filter not exists {?entry :isoform /:proteoform /:phenotypicVariation ?phenotype} # No phenotype annotation
}