SARS-CoV-2-Queries

humanInteractionCounts.rq

Ejemplos de código: curl

SPARQL

SELECT ?virus ?virusLabel ?gene ?geneLabel ?count WITH {
  SELECT ?virus ?gene (COUNT(DISTINCT ?work) AS ?count) WHERE {
    ?virus wdt:P171+ wd:Q57751738 .
    ?work wdt:P921 ?virus, ?gene .
    ?gene wdt:P703 wd:Q15978631 .
    { ?gene wdt:P31 wd:Q7187 } UNION { ?gene wdt:P31 wd:Q8054 }
  } GROUP BY ?virus ?gene
} AS %ARTICLES WHERE {
  INCLUDE %ARTICLES
  SERVICE wikibase:label { bd:serviceParam wikibase:language "es,en". }
}
ORDER BY DESC(?count) ?virus ?gene

ejecutar o editar

Resultados

virus	gene	count
SARS-CoV-2 (edit)	angiotensin I converting enzyme 2 (edit)	24
SARS-CoV-2 (edit)	Transmembrane serine protease 2 (edit)	9
SARS-CoV (edit)	angiotensin I converting enzyme 2 (edit)	7
SARS-CoV (edit)	Transmembrane serine protease 2 (edit)	4
SARS coronavirus (edit)	angiotensin I converting enzyme 2 (edit)	3
SARS-CoV-2 (edit)	Furin, paired basic amino acid cleaving enzyme (edit)	3
Betacoronavirus (edit)	angiotensin I converting enzyme 2 (edit)	2
MERS-CoV (edit)	DPP-4 (edit)	2
SARS-CoV-2 (edit)	Enzima convertidora de angiotensina II (edit)	2
SARS-CoV-2 (edit)	TMPRSS2 (edit)	2
Betacoronavirus (edit)	proteína C reactiva (edit)	1
Human coronavirus 229E (edit)	TMPRSS2 (edit)	1
Human coronavirus 229E (edit)	Transmembrane serine protease 2 (edit)	1
Human coronavirus 229E (edit)	peptidylprolyl isomerase A (edit)	1
Human coronavirus 229E (edit)	CD13 (edit)	1
Human coronavirus 229E (edit)	angiotensin I converting enzyme 2 (edit)	1
SARS coronavirus (edit)	MASP2 (edit)	1
SARS coronavirus (edit)	factor de necrosis tumoral (edit)	1
SARS coronavirus (edit)	Interferon induced transmembrane protein 3 (edit)	1
SARS coronavirus (edit)	Interferon induced transmembrane protein 2 (edit)	1
SARS coronavirus (edit)	Interferon induced transmembrane protein 1 (edit)	1
MERS-CoV (edit)	Transmembrane serine protease 2 (edit)	1
SARS-CoV-2 (edit)	IL6 (edit)	1
SARS-CoV-2 (edit)	HLA-E (edit)	1
SARS-CoV-2 (edit)	BSG (edit)	1
SARS-CoV-2 (edit)	FURIN (edit)	1
SARS-CoV-2 (edit)	MX1 (edit)	1
SARS-CoV-2 (edit)	IGHV3-53 (edit)	1
SARS-CoV-2 (edit)	TRBV11-2 (edit)	1
SARS-CoV-2 (edit)	PIKFYVE (edit)	1
SARS-CoV-2 (edit)	thioredoxin reductase 1 (edit)	1
SARS-CoV-2 (edit)	CCHC-type zinc finger nucleic acid binding protein (edit)	1
SARS-CoV-2 (edit)	transmembrane serine protease 4 (edit)	1
SARS-CoV-2 (edit)	Transmembrane protein 41B (edit)	1
SARS-CoV-2 (edit)	Translocase of outer mitochondrial membrane 70 (edit)	1
SARS-CoV-2 (edit)	Factor de von Willebrand (edit)	1
SARS-CoV-2 (edit)	ADAMTS13 (edit)	1
SARS-CoV-2 (edit)	heme oxygenase 1 (edit)	1
Coronavirus Humana NL63 (edit)	angiotensin I converting enzyme 2 (edit)	1
SARS-CoV (edit)	MASP2 (edit)	1
SARS-CoV (edit)	factor de necrosis tumoral (edit)	1
SARS-CoV (edit)	C-type lectin domain family 4 member G (edit)	1
SARS-CoV (edit)	C-type lectin domain family 4 member M (edit)	1
SARS-CoV (edit)	Hepsin (edit)	1
SARS-CoV (edit)	Transmembrane serine protease 11D (edit)	1
SARS-CoV (edit)	Interferon induced transmembrane protein 3 (edit)	1
SARS-CoV (edit)	Interferon induced transmembrane protein 2 (edit)	1
SARS-CoV (edit)	Interferon induced transmembrane protein 1 (edit)	1
SARS-CoV (edit)	BCL2 like 1 (edit)	1
SARS-CoV (edit)	ADAM metallopeptidase domain 17 (edit)	1
SARS-CoV (edit)	Proteína X asociada a Bcl-2 (edit)	1

Ejemplos de código

curl

curl -s https://raw.githubusercontent.com/egonw/SARS-CoV-2-Queries/master/sparql/humanInteractionCounts.rq | sed 's+<lang/>+es+' > humanInteractionCounts.rq

curl -H "Accept: text/tab-separated-values" -G https://query.wikidata.org/bigdata/namespace/wdq/sparql --data-urlencode query@humanInteractionCounts.rq

Esta consulta SPARQL está disponible en CCZero.

This site is open source. Improve this page.