https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/Head https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg http://www.nanopub.org/nschema#hasAssertion https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/assertion https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg http://www.nanopub.org/nschema#hasProvenance https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/provenance https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg http://www.nanopub.org/nschema#hasPublicationInfo https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/pubinfo https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.nanopub.org/nschema#Nanopublication https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/assertion https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/get-kg-approved-samples http://purl.org/dc/terms/description Lists mvikg/r/kg sample records whose approval status is 'approved' (latest admin npx:approvesOf/disapprovesOf verdict from a current mvikg admin decides the status; no verdict means pending). One row per record: its label, who created it and when. https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/get-kg-approved-samples http://purl.org/dc/terms/license https://creativecommons.org/licenses/by/4.0/ https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/get-kg-approved-samples http://www.w3.org/1999/02/22-rdf-syntax-ns#type https://w3id.org/kpxl/grlc/grlc-query https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/get-kg-approved-samples http://www.w3.org/2000/01/rdf-schema#label Get mvikg/r/kg approved samples https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/get-kg-approved-samples https://w3id.org/kpxl/grlc/endpoint https://w3id.org/np/l/nanopub-query-1.1/repo/full https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/get-kg-approved-samples https://w3id.org/kpxl/grlc/sparql prefix npa: <http://purl.org/nanopub/admin/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix npx: <http://purl.org/nanopub/x/> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix foaf: <http://xmlns.com/foaf/0.1/> select distinct ?Name ?ModifiedBy ?Modified_noheader ?np ?np_label where { { select distinct ?dnp ?label ?creator ?created where { { select ?stableThing ?dnp where { graph npa:graph { ?dnp npx:introduces ?stableThing ; dct:created ?ddateRaw ; npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?inv npx:invalidates ?dnp ; npa:hasValidSignatureForPublicKey ?pubkey . } } filter not exists { graph npa:graph { ?dnp2 npx:introduces ?stableThing ; dct:created ?ddate2Raw ; npa:hasValidSignatureForPublicKey ?pubkey2 . filter not exists { ?inv2 npx:invalidates ?dnp2 ; npa:hasValidSignatureForPublicKey ?pubkey2 . } } filter(?ddate2Raw > ?ddateRaw) } } } bind(iri(concat(str(?dnp), '/assertion')) as ?da) graph ?da { ?stableThing a <http://www.w3.org/ns/sosa/Sample> ; dct:isPartOf <https://w3id.org/spaces/mvikg/r/kg> . } bind(iri(concat(str(?dnp), '/pubinfo')) as ?pi) graph ?pi { ?dnp dct:creator ?creator ; dct:created ?createdRaw . } bind(replace(str(?createdRaw), '[.]000Z$', 'Z') as ?created) optional { graph ?da { ?stableThing rdfs:label ?lblEntity } } optional { graph ?pi { ?dnp rdfs:label ?lblPub } } bind(coalesce(?lblEntity, ?lblPub, str(?stableThing)) as ?label) } } optional { graph ?vda { ?admin ?verdictPred ?dnp . filter(?verdictPred in (npx:approvesOf, npx:disapprovesOf)) } filter(exists { service <https://w3id.org/np/l/nanopub-query-1.1/repo/spaces> { graph npa:graph { <http://purl.org/nanopub/admin/thisRepo> npa:hasCurrentSpaceState ?g . } graph ?g { ?ri a gen:RoleInstantiation ; npa:forSpace <https://w3id.org/spaces/mvikg> ; npa:forAgent ?admin ; npa:hasRoleType gen:AdminRole . } } }) bind(iri(replace(str(?vda), '/assertion$', '')) as ?vnp) graph ?vpi { ?vnp dct:created ?vcreatedRaw . } bind(xsd:dateTime(?vcreatedRaw) as ?vcreated) filter not exists { graph ?vda2 { ?admin2 ?verdictPred2 ?dnp . filter(?verdictPred2 in (npx:approvesOf, npx:disapprovesOf)) } filter(exists { service <https://w3id.org/np/l/nanopub-query-1.1/repo/spaces> { graph npa:graph { <http://purl.org/nanopub/admin/thisRepo> npa:hasCurrentSpaceState ?g2 . } graph ?g2 { ?ri2 a gen:RoleInstantiation ; npa:forSpace <https://w3id.org/spaces/mvikg> ; npa:forAgent ?admin2 ; npa:hasRoleType gen:AdminRole . } } }) bind(iri(replace(str(?vda2), '/assertion$', '')) as ?vnp2) graph ?vpi2 { ?vnp2 dct:created ?vcreated2Raw . } filter(xsd:dateTime(?vcreated2Raw) > ?vcreated) } optional { graph ?vda { ?vda rdfs:comment ?reason } } } bind(if(bound(?verdictPred), if(?verdictPred = npx:approvesOf, 'approved', 'rejected'), 'pending') as ?finalStatus) filter(?finalStatus = 'approved') bind(str(?dnp) as ?np) bind('^' as ?np_label) bind(?label as ?Name) optional { ?creator foaf:name ?cname } bind(coalesce(?cname, replace(str(?creator), '^.*/', '')) as ?ModifiedBy) bind(?created as ?Modified_noheader) } https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/provenance https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/assertion http://www.w3.org/ns/prov#wasAttributedTo https://orcid.org/0009-0005-5515-1230 https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/pubinfo https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg http://purl.org/dc/terms/created 2026-11-09T16:24:24Z https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg http://purl.org/dc/terms/creator https://orcid.org/0009-0005-5515-1230 https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg http://purl.org/dc/terms/license https://creativecommons.org/licenses/by/4.0/ https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg http://purl.org/nanopub/x/embeds https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/get-kg-approved-samples https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg http://purl.org/nanopub/x/supersedes https://w3id.org/np/RAXJc9AM9dMQwSrtK8IhKKEOIFb0TXar1cOIm-L7icaTQ https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg http://purl.org/nanopub/x/supersedes https://w3id.org/np/RAb6fKUl7koLp0VK7ijeSQheDLk3bzp5Lvwx8hxj2h9AY https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg http://www.w3.org/2000/01/rdf-schema#label Get mvikg/r/kg approved samples https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg http://www.w3.org/2004/02/skos/core#changeNote Replaced the supersedes-chain exclusion filter with the project's standard resolution pattern (npa:graph + npx:introduces + npa:hasValidSignatureForPublicKey, excluding npx:invalidates), matching how the real builder picks a resource's current defining nanopub. This requires the content nanopub to re-introduce the SAME stable entity IRI on every version (now fixed for the two phenotype records that had drifted to a fresh IRI per publish). Label now checks both the entity's own label and the nanopub-level label, preferring whichever is present (samples only have the latter, phenotypes only the former). https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg https://w3id.org/np/o/ntemplate/wasCreatedFromProvenanceTemplate https://w3id.org/np/RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RACJ58Gvyn91LqCKIO9zu1eijDQIeEff28iyDrJgjSJF8 https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg https://w3id.org/np/o/ntemplate/wasCreatedFromPubinfoTemplate https://w3id.org/np/RAukAcWHRDlkqxk7H2XNSegc1WnHI569INvNr-xdptDGI https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg https://w3id.org/np/o/ntemplate/wasCreatedFromTemplate https://w3id.org/np/RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/sig http://purl.org/nanopub/x/hasAlgorithm RSA https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/sig http://purl.org/nanopub/x/hasPublicKey MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAjO3oH8Lq/l1oZIUY3FlCz5DnndybGvAhBdmEJ/yq7Nv3GZEYPrEro23rCBCp0GiriOXlVbk61pA/7JFE6tqzTresINW6QQMxE9sIhCBlX4cG66JFD8ud6bMvUyzCR8LQA6zfrSbafGE06rvglJd4MDUcTwvUKqtL9UCnOaowVfnZ3sPOe9EqlmJuO3iHGxBSXMPOPEJZUzMXsFDWFuMZTnrR8gY3r5nVF5a8L/MD135ZH8qW5yGXOB28CmVYCAbw2o07QEKzyzFKN+W1gfnprYZvuKzwGexnzcdzc1S8N/M5bzhWQ40EKCEqgUE8c81OzEMm1HUlUKEJ/o5I/FKKAwIDAQAB https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/sig http://purl.org/nanopub/x/hasSignature IbSmVDeHN1fZYA+9OfUiDcNagaBqFiyEs3PWNYjS1s5xC2WyGfPuSVAB9R9E+sCs81VVNqdH9DqBdMpCGQZQ95DXPoiD3Una4JpcDTPGeYDqGIps8A+wTHaiY7LngreNB8g4gprzPR+oN11D0WXMdlVX43/ylnF/tWXjtkoUvxSjSEzmT1UXzDwm4P9nGD0CiyHJXygmF544M6OVOBx3Yd367o2PjftWEQJ4Wbz2T3EiDDTfXTG5v8mYSqrIsUrhlWN9ZLnTMqdnKlyu7wXxffDMew06L9hmI6N2ScrcitJ4kLP1aDstqLzRpZv8wHSTBAuLIOoJSqVDwHX/mWPA9A== https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/sig http://purl.org/nanopub/x/hasSignatureTarget https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg https://w3id.org/np/RA0UF9u2bt3TS0E86VE8FuMh786LswrKs0sKujkgndpSg/sig http://purl.org/nanopub/x/signedBy https://orcid.org/0009-0005-5515-1230