- Participants are way incomplete
- No linked topics
- publications?
- events?
- data?
Online, e.g. https://www.wikidata.org/wiki/Q113500855
- click “edit” next to any statement
- what’s a statement?
- RDF triple:
?subject ?predicate ?object .or
?subject ?property_name ?property_value . - Adopted from the Wikidata introduction)
<http://example.org/DouglasAdams> <http://example.org/educated_at> "St. John's College" .
- Wikidata subjects (
item): has a label, a description and any number of aliases. URI pattern: https://www.wikidata.org/entity/Q123456789 - Wikidata
statement=property+value
| Item | Property | Value |
|---|---|---|
| wd:Q42 | rdfs:label | “Douglas Adams”^^xsd:string |
| wd:Q42 | schema:description | “A British writer”^^xsd:string@en |
| wd:Q42 | schema:description | “Ein britischer Autor”^^xsd:string@de |
| wd:Q42 | schema:description | “Un écrivain français”^^xsd:string@fr |
| wd:Q42 | wdp:P69 | Q691283 |
| wp:P69 | rdfs:label | “educated at”^^xsd:string@en |
| wd:Q691283 | label | “St. John’s College”^^xsd:string |
- Each property-value pair (
statement) can have additional annotations, such as references, validity dates, …
Example:NFDI4BIOIMAGE’s chairperson
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
select * where {
wd:Q113500855 ?property ?value .
}
limit 30PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
select * where {
wd:Q113500855 wdt:P31 ?instance_of .
?instance_of ?iprop ?ival .
}
limit 30- OpenRefine (“reconciliation”)
- QuickStatements -> https://quickstatements.toolforge.org/
- See more at https://www.wikidata.org/wiki/Wikidata:Tools
-
- Yourself
- Name
- Affiliation
- ORCID
- other IDs
- Degree
- Field of work
- Website
- Social media, github handles
- Publications -> https://orcid-scraper.toolforge.org
- …
- ROR ID
- Website
SELECT ?graph (count(?subject) as ?number_of_triples)
WHERE {
graph ?graph { ?subject ?predicate ?object }
}
group by ?graph| graph | number_of_triples |
|---|---|
| https://kg.nfdi4bioimage.de/n4bikg/core | 8 |
| https://kg.nfdi4bioimage.de/n4bikg/n4bi_zenodo_community | 3482 |
| https://kg.nfdi4bioimage.de/n4bikg/owl | 3993 |
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix dcite: <https://schema.datacite.org/meta/kernel-4.6/metadata.xsd#>
select ?s ?p ?plabel ?o ?olabel where
{
?s ?p ?o
optional {
?p rdfs:label ?plabel.
}
optional {
?o rdfs:label ?olabel .
}
}
limit 10PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix dcite: <https://schema.datacite.org/meta/kernel-4.6/metadata.xsd#>
prefix nfdicore: <https://nfdi.fiz-karlsruhe.de/ontology/>
select *
where
{
<https://doi.org/10.5281/zenodo.14013026> dcite:creator ?creator .
?creator dcite:givenName ?creator_given_name ;
dcite:familyName ?creator_family_name .
?creator dcite:affiliation ?affiliation .
filter(isiri(?affiliation))
?affiliation rdfs:label ?affiliation_name .
}
limit 40| creator | creator_given_name | creator_family_name | affiliation | affiliation_name |
|---|---|---|---|---|
| https://orcid.org/0000-0001-9568-895X | Christian | Schmidt | https://ror.org/0546hnb39 | University of Konstanz |
| https://orcid.org/0000-0001-9568-895X | Christian | Schmidt | https://ror.org/04cdgtt98 | German Cancer Research Center |
| https://orcid.org/0000-0001-9568-895X | Christian | Christian Schmidt | https://ror.org/0546hnb39 | University of Konstanz |
| https://orcid.org/0000-0001-9568-895X | Christian | Christian Schmidt | https://ror.org/04cdgtt98 | German Cancer Research Center |
| https://orcid.org/0000-0001-7734-3771 | Stefanie | Stefanie Weidtkamp-Peters | https://ror.org/01vnkaz16 | NFDI4BIOIMAGE |
| https://orcid.org/0000-0001-7734-3771 | Stefanie | Stefanie Weidtkamp-Peters | https://ror.org/024z2rq82 | Heinrich Heine University Düsseldorf |
| https://orcid.org/0000-0001-7734-3771 | Stefanie | Weidtkamp-Peters | https://ror.org/01vnkaz16 | NFDI4BIOIMAGE |
| https://orcid.org/0000-0001-7734-3771 | Stefanie | Weidtkamp-Peters | https://ror.org/024z2rq82 | Heinrich Heine University Düsseldorf |
| https://orcid.org/0000-0001-6523-7496 | Susanne | Kunis | https://ror.org/04qmmjx98 | Osnabrück University |
| b0 | Tom | Boissonnet | https://ror.org/024z2rq82 | Heinrich Heine University Düsseldorf |
| b1 | Bettina | Hagen | https://ror.org/04xx1tc24 | Max Planck Institute for Biology of Ageing |
Some records must have the full name set as ‘family name’.
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix dcite: <https://schema.datacite.org/meta/kernel-4.6/metadata.xsd#>
prefix nfdicore: <https://nfdi.fiz-karlsruhe.de/ontology/>
select *
where
{
<https://orcid.org/0000-0001-7734-3771> dcite:givenName ?first;
dcite:familyName ?last .
}| first | last |
|---|---|
| Stefanie | Stefanie Weidtkamp-Peters |
| Stefanie | Weidtkamp-Peters |
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix dcite: <https://schema.datacite.org/meta/kernel-4.6/metadata.xsd#>
prefix nfdicore: <https://nfdi.fiz-karlsruhe.de/ontology/>
select ?record (count(distinct ?creator) as ?ncreators) (count(distinct ?contributor) as ?ncontributor)
where
{
?record dcite:contributor ?contributor ;
dcite:creator ?creator .
}
group by ?recordPREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix dcite: <https://schema.datacite.org/meta/kernel-4.6/metadata.xsd#>
prefix nfdicore: <https://nfdi.fiz-karlsruhe.de/ontology/>
select ?institution (count(distinct ?record) as ?nrecords)
where
{
?record dcite:creator ?creator .
?creator dcite:affiliation ?institution .
filter(isiri(?institution))
}
group by ?institution
order by desc(?nrecords)PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix dcite: <https://schema.datacite.org/meta/kernel-4.6/metadata.xsd#>
prefix nfdicore: <https://nfdi.fiz-karlsruhe.de/ontology/>
select ?creator (count(distinct ?record) as ?nrecords)
where
{
?record dcite:creator ?creator .
?creator dcite:familyName ?name .
}
group by ?creator
order by desc(?nrecords)- related to #8
prefix nfdicore: <https://nfdi.fiz-karlsruhe.de/ontology/NFDI_>
select ?g ?p ?o where {
graph ?g {?s ?p ?o}
values ?g {
<https://kg.nfdi4bioimage.de/n4bikg/core>
<https://kg.nfdi4bioimage.de/n4bikg/services>
<https://kg.nfdi4bioimage.de/n4bikg/n4bi_zenodo_community>
}
bind(concat(str(?p), str(?o)) as ?spo)
filter(contains(?spo, str(nfdicore:)))
}- nfdicore0000003 deleted, can be replaced by obi_0000245 (organization)
- related; nfdicore0000136 changed domain to obi_0000245
- log in to n4bi-kg server
sudo -i- =rupdate –server http://localhost:3030/N4BIKG/update “drop ALL”
- Upload data via online admin interface
construct {?s ?p ?o} where {graph ?g {?s ?p ?o}}Parse error: Encountered ” <VAR1> “?o “” at line 1, column 21. ]] PREFIX adms: http://www.w3.org/ns/adms# PREFIX bibo: http://purl.org/ontology/bibo/ PREFIX core: https://ld.openmicroscopy.org/core/ PREFIX datacite: https://schema.datacite.org/meta/kernel-4.6/metadata.xsd# PREFIX dc: http://purl.org/dc/elements/1.1/ PREFIX dcite: https://schema.datacite.org/meta/kernel-4.6/metadata.xsd# PREFIX dcterms: http://purl.org/dc/terms/ PREFIX doap: http://usefulinc.com/ns/doap# PREFIX edam: http://purl.obolibrary.org/obo/edam# PREFIX edamontology: http://edamontology.org/ PREFIX foaf: http://xmlns.com/foaf/0.1/ PREFIX linkml: https://w3id.org/linkml/ PREFIX ncit: http://purl.obolibrary.org/obo/NCIT_ PREFIX nfdicore: https://nfdi.fiz-karlsruhe.de/ontology/ PREFIX obo: http://purl.obolibrary.org/obo/ PREFIX oboInOwl: http://www.geneontology.org/formats/oboInOwl# PREFIX ontology: https://nfdi.fiz-karlsruhe.de/ontology/ PREFIX orcid: https://orcid.org/ PREFIX owl: http://www.w3.org/2002/07/owl# PREFIX rdf: http://www.w3.org/1999/02/22-rdf-syntax-ns# PREFIX rdfs: http://www.w3.org/2000/01/rdf-schema# PREFIX ror: https://ror.org/ PREFIX sio: http://semanticscience.org/resource/ PREFIX skos: http://www.w3.org/2004/02/skos/core# PREFIX t4fs: http://purl.obolibrary.org/obo/T4FS_ PREFIX terms: http://purl.org/dc/terms/ PREFIX vann: http://purl.org/vocab/vann/ PREFIX wd: http://www.wikidata.org/entity/ PREFIX wdt: http://www.wikidata.org/prop/direct/ PREFIX xml: http://www.w3.org/XML/1998/namespace PREFIX xo: http://rhizomik.net/redefer/xsl/xsd2owl-functions.xsl PREFIX xs: http://www.w3.org/2001/XMLSchema# PREFIX xsd: http://www.w3.org/2001/XMLSchema# PREFIX xsi: http://www.w3.org/2001/XMLSchema-instance# PREFIX zenodo: https://zenodo.org/ns/ ]]