sbd-data-book

modelsForNanomaterials.rq

Code examples: curl

SPARQL

PREFIX npo: <http://purl.bioontology.org/ontology/npo#>
PREFIX obo: <http://purl.obolibrary.org/obo/>
PREFIX rdfs:    <http://www.w3.org/2000/01/rdf-schema#>
PREFIX sbd:     <https://www.sbd4nano.eu/rdf/#>
PREFIX sbdbel:  <https://www.sbd4nano.eu/bel/#>
PREFIX dc:      <http://purl.org/dc/elements/1.1/>
PREFIX dct:     <http://purl.org/dc/terms/>
PREFIX skos:    <http://www.w3.org/2004/02/skos/core#>

SELECT ?material (SAMPLE(?material_) AS ?materialLabel) (COUNT(DISTINCT ?model) AS ?count)
WHERE {
  ?material rdfs:label ?material_ .
  ?model a sbd:Model .
  { ?model sbdbel:NP ?material . } UNION { ?model dct:subject / skos:narrower ?material . }
  OPTIONAL { ?model rdfs:label ?rdfsLabel }
  BIND(COALESCE(?rdfsLabel, str(?model)) AS ?modelLabel)
} GROUP BY ?material
  ORDER BY DESC(?count)

run

Output

material count
ZnO 50
R-TiO2 46
Fe2O3 39
SiO2 34
Al2O3 33
lanthanum(3+);oxygen(2-) 32
oxonickel 31
oxygen(2-);yttrium(3+) 31
Cobalt (II) oxide nanoparticle 30
indium(3+);oxygen(2-) 30
chromium(3+);oxygen(2-) 30
dioxotin 30
dioxozirconium 30
antimony(3+);oxygen(2-) 29
oxocopper 25
oxo(oxovanadiooxy)vanadium 24
oxo(oxobismuthanyloxy)bismuthane 23
Au nanopartice 20
Fe3O4 17
trioxotungsten 16
(Fe2O3)n(Fe3O4)m 16
CNT: Carbon nanotubes 14
oxo(oxomanganiooxy)manganese 12
oxygen(2-);ytterbium(3+) 9
gadolinium(3+);oxygen(2-) 9
dioxocerium 9
hafnium(4+);oxygen(2-) 7
Co3O4 nanoparticle 7
nickel(3+);oxygen(2-) 7
Metal Oxide 6
titanium dioxide nanoparticle 4
Ag nanoparticle 4
Nanoparticle 3
iron 2
copper 2
dioxosilane 2
nickel(2+) 2
Al nanoparticle 2
Cobalt molecular entity 2
trioxomolybdenum 2
MWCNT40nm-COOH 2
Fullerene C60 2
Metal 1
cobalt ferrite (CoFe2O4) 1
platinum 1
zinc;iron(3+);oxygen(2-) 1
silicon(4+) 1
oxido(oxo)alumane 1
germanium 1
tellanylidenecadmium 1
Cobalt nanoparticle 1
Cobalt cations 1
Beryyllium oxide 1
Barium oxide 1
Disilver Oxide Ag2O 1
Arsenic pentoxide 1
FeO 1
dipotassium;oxygen(2-) 1
oxygen(2-);rubidium(1+) 1
manganese;oxygen(2-) 1
oxo(oxotitaniooxy)titanium 1
oxygen(2-);scandium(3+) 1
oxocalcium 1
oxocadmium 1
oxomagnesium 1
dioxolead 1
dioxogermane 1
dioxomanganese 1
(dioxo-lambda5-stibanyl)oxy-dioxo-lambda5-stibane 1
dioxovanadiooxy(dioxo)vanadium 1
oxolead 1
trioxochromium 1
oxomanganese 1
digallium;oxygen(2-) 1
dysprosium(3+);oxygen(2-) 1
europium(3+);oxygen(2-) 1
neodymium(3+);oxygen(2-) 1
lutetium(3+);oxygen(2-) 1
oxygen(2-);terbium(3+) 1
holmium(3+);oxygen(2-) 1
erbium(3+);oxygen(2-) 1
dilithium;oxygen(2-) 1
lambda1-thallanyloxythallium 1
oxovanadium 1
dioxomolybdenum 1
oxomercury 1
oxo(oxothallanyloxy)thallane 1
oxotitanium 1
oxygen(2-);tantalum(5+) 1
oxogermanium 1
cerium-144(3+);oxygen(2-) 1
disodium;oxygen(2-) 1
strontium;oxygen(2-) 1
oxoniobium 1
dioxoniobium 1
dioxotungsten 1
oxido(oxo)chromium 1
dicesium;oxygen(2-) 1
copper;copper(1+);oxygen(2-) 1
manganese;oxygen(2-) 1

Code examples

curl

curl -s https://raw.githubusercontent.com/h2020-sbd4nano/sbd-data-book/master/sparql/modelsForNanomaterials.rq | sed 's+<lang/>+en+' > modelsForNanomaterials.rq

curl -H "Accept: text/tab-separated-values" -G https://sbd4nanolandscape.rdf.bigcat-bioinformatics.org/sparql --data-urlencode query@modelsForNanomaterials.rq

This SPARQL query is available under CCZero.