@prefix ex:<https://purl.expasy.org/sparql-examples/neXtProt/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix schema: <https://schema.org/> .
@prefix sh: <http://www.w3.org/ns/shacl#> .
ex:NXQ_00257 a sh:SPARQLExecutable, sh:SPARQLSelectExecutable ;
  sh:prefixes _:sparql_examples_prefixes ;
  rdfs:comment '''Frequent variants at a PTM site'''@en ;
  schema:keywords "evidence", "variant", "sequence variation", "snorql-only" ;
  schema:target <https://sparql.nextprot.org/sparql> ;
  sh:select '''PREFIX : <http://nextprot.org/rdf/>
PREFIX cv: <http://nextprot.org/rdf/terminology/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

select  distinct ?entry (str(?ptmlab) as ?ptmlabSTR) ?varpos (str(?varAA) as ?varAASTR) ?freq where {
?entry :isoform ?iso .
?iso :swissprotDisplayed true .
?iso :variant ?var .
?var :start ?varpos .
?var :variation ?varAA .
?iso :ptm  ?ptm .
?ptm :term / rdfs:label ?ptmlab.
?ptm :start ?varpos .
?var :evidence ?ev .
?ev :allele-frequency ?freq .
filter (?freq > 0.5 )
}
order by desc(?freq)''' .