@prefix this: . @prefix sub: . @prefix np: . @prefix grlc: . @prefix dct: . @prefix nt: . @prefix npx: . @prefix xsd: . @prefix rdfs: . @prefix orcid: . @prefix prov: . sub:Head { this: a np:Nanopublication; np:hasAssertion sub:assertion; np:hasProvenance sub:provenance; np:hasPublicationInfo sub:pubinfo . } sub:assertion { sub:get-mvikg-gene-variants a grlc:grlc-query; dct:description "Lists the sequence variant records of the MVIKG knowledge graph that belong to a gene ('partid'), with the sample they were observed in, Sequence Ontology type, effect and review status. Only records signed by a current admin, maintainer or member of the mvikg space count, in their newest non-invalidated version; the review status is the latest npx:approvesOf / npx:disapprovesOf verdict of a current mvikg admin on that version (none: pending)."; dct:license ; rdfs:label "Get MVIKG variants of a gene"; grlc:endpoint ; grlc:sparql """prefix rdf: prefix rdfs: prefix dct: prefix np: prefix npa: prefix npx: prefix gen: prefix sosa: prefix biolink: prefix mvikg: prefix obo: select ?variant ?variant_label ?sample ?sample_label ?type ?effect ?status ?np ?np_label where { { select ?variant ?np (sample(?l) as ?vl) (sample(coalesce(?samc, ?sam)) as ?sample) (min(?saml) as ?sl) (group_concat(distinct ?tl; separator=', ') as ?type) (sample(?e) as ?effect) (max(?verdict) as ?mv) where { service { select (group_concat(distinct ?pk; separator=' ') as ?memberKeys) (group_concat(distinct ?apk; separator=' ') as ?adminKeys) where { graph npa:graph { npa:thisRepo npa:hasCurrentSpaceState ?sg . } graph ?sg { ?ri a gen:RoleInstantiation ; npa:forSpace ; npa:hasRoleType ?tier ; npa:forAgent ?agent . filter(?tier in (gen:AdminRole, gen:MaintainerRole, gen:MemberRole)) ?acct a npa:AccountState ; npa:agent ?agent ; npa:pubkey ?pk . bind(if(?tier = gen:AdminRole, ?pk, '') as ?apk) } } } graph ?a { ?_partid_iri biolink:has_sequence_variant ?variant . ?variant a biolink:SequenceVariant ; dct:isPartOf . } graph npa:graph { ?np np:hasAssertion ?a ; npx:introduces ?variant ; dct:created ?date ; npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?inv npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } } filter(contains(?memberKeys, ?pubkey)) optional { graph npa:graph { ?np2 npx:introduces ?variant ; dct:created ?date2 ; npa:hasValidSignatureForPublicKeyHash ?pubkey2 . filter not exists { ?inv2 npx:invalidates ?np2 ; npa:hasValidSignatureForPublicKeyHash ?pubkey2 . } } filter(contains(?memberKeys, ?pubkey2) && concat(str(?date2), '>', str(?np2)) > concat(str(?date), '>', str(?np))) } filter(!bound(?np2)) optional { graph ?a { ?variant rdfs:label ?l } } optional { graph ?a { ?variant mvikg:effect ?e } } optional { graph ?a { ?variant a ?t . filter(?t != biolink:SequenceVariant) } bind(if(?t = obo:SO_0000159, 'deletion', if(?t = obo:SO_0000667, 'insertion', if(?t = obo:SO_0000694, 'SNP', if(?t = obo:SO_0001483, 'SNV', if(?t = obo:SO_0001059, 'sequence alteration', if(?t = obo:SO_1000002, 'substitution', if(?t = obo:SO_1000032, 'delins', if(?t = obo:SO_0002007, 'MNV', replace(replace(str(?t), '^.*[/#]', ''), '_', ':'))))))))) as ?tl) } optional { graph ?a { ?_partid_iri sosa:isFeatureOfInterestOf ?sam } } optional { graph npa:graph { ?samonp npx:introduces ?sam . ?samnp npx:supersedes* ?samonp ; npx:introduces ?samc ; rdfs:label ?saml ; npa:hasValidSignatureForPublicKeyHash ?sampk . filter not exists { ?saminv npx:invalidates ?samnp ; npa:hasValidSignatureForPublicKeyHash ?sampk . } } } optional { values ?vpred { npx:approvesOf npx:disapprovesOf } graph ?va { ?vagent ?vpred ?np . } graph npa:graph { ?vnp np:hasAssertion ?va ; dct:created ?vdate ; npa:hasValidSignatureForPublicKeyHash ?vpk . filter not exists { ?vinv npx:invalidates ?vnp ; npa:hasValidSignatureForPublicKeyHash ?vpk . } } filter(contains(?adminKeys, ?vpk)) bind(concat(str(?vdate), '>', if(?vpred = npx:disapprovesOf, 'd', 'a')) as ?verdict) } } group by ?variant ?np } bind(coalesce(str(?vl), replace(str(?variant), '^.*/np/', '')) as ?variant_label) bind(coalesce(str(?sl), replace(str(?sample), '^.*/np/', '')) as ?sample_label) bind(if(!bound(?mv), '⏳ pending', if(strends(?mv, 'd'), '🚫 rejected', '✅ approved')) as ?status) bind('^' as ?np_label) } order by ?variant_label""" . } sub:provenance { sub:assertion prov:wasAttributedTo orcid:0000-0002-1267-0234 . } sub:pubinfo { this: dct:created "2026-11-12T13:26:12.587+01:00"^^xsd:dateTime; dct:creator orcid:0000-0002-1267-0234; dct:license ; npx:embeds sub:get-mvikg-gene-variants; rdfs:label "Get MVIKG variants of a gene"; nt:wasCreatedFromProvenanceTemplate ; nt:wasCreatedFromPubinfoTemplate , ; nt:wasCreatedFromTemplate . sub:sig npx:hasAlgorithm "RSA"; npx:hasPublicKey "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB"; npx:hasSignature "HguU3mxaPNid16sHokcs+pOAYbB53kW3StSFQeQ6cCM7aJ1oqSf32YiqLfuv6cLMe3v+wpdKu36BPb/P5tao81zJfM+n+Uw9oHCua7c4CIETXzeIoVC9je+gouSIMKMg1/jwMEr/fdETkgq88Ia38jVjt0id552Ty7QbOXrBr+Y="; npx:hasSignatureTarget this:; npx:signedBy orcid:0000-0002-1267-0234 . }