Skip to content

Instantly share code, notes, and snippets.

Avatar
💭
I don't want a status.

Egon Willighagen egonw

💭
I don't want a status.
View GitHub Profile
@egonw
egonw / getBridgeDbDatabases.sh
Created Feb 15, 2021
Script to download all release BridgeDb Derby databases
View getBridgeDbDatabases.sh
!/bin/bash
wget -nc https://bridgedb.github.io/data/gene.json
wget -nc https://bridgedb.github.io/data/corona.json
wget -nc https://bridgedb.github.io/data/other.json
jq -r '.mappingFiles | .[] | "\(.file)=\(.downloadURL)"' gene.json > files.txt
jq -r '.mappingFiles | .[] | "\(.file)=\(.downloadURL)"' corona.json >> files.txt
jq -r '.mappingFiles | .[] | "\(.file)=\(.downloadURL)"' other.json >> files.txt
View gist:338d963c1904048dcfcd65c951670d5f
SELECT ?wpid ?pathway ?pathwayLabel ?cpx ?complex ?complexLabel ?part ?partLabel WITH {
SELECT DISTINCT ?complex ?cpx ?part WHERE {
?complex wdt:P7718 ?cpx ;
wdt:P527+ ?part .
{ ?part wdt:P31 wd:Q78782478 . }
UNION
{ ?part wdt:P31 wd:Q8054 . }
}
} AS %PARTS WHERE {
INCLUDE %PARTS
@egonw
egonw / start-server.sh
Created Nov 2, 2020
BridgeDb Webservice shell script
View start-server.sh
#!/bin/sh
# change to directory of this script
cd $(dirname $0)
CLASSPATH=dist/org.bridgedb.jar:\
dist/org.bridgedb.bio.jar:\
dist/org.bridgedb.rdb.jar:\
dist/org.bridgedb.server.jar:\
dist/org.bridgedb.webservice.bridgerest.jar:\
View threadreaderapp.txt
https://threadreaderapp.com/thread/1307246078589370370.html -> not #openscience
https://threadreaderapp.com/thread/1307579858646708224.html Balans van de Wetenschap 2020
@egonw
egonw / LICENSES.txt
Created Aug 30, 2020
Full list of license of dependencies of BridgeDb 3.0.0-SNAPSHOT
View LICENSES.txt
(3-Clause BSD License) Protocol Buffers [Core] (com.google.protobuf:protobuf-java:3.6.1 - https://developers.google.com/protocol-buffers/protobuf-java/)
(Aduna BSD license) OpenRDF Rio compliance tests (org.openrdf.sesame:sesame-rio-compliance:2.7.1 - http://www.openrdf.org/sesame-compliance/sesame-rio-compliance/)
(Aduna BSD license) OpenRDF Rio compliance test suite (org.openrdf.sesame:sesame-rio-testsuite:2.7.1 - http://www.openrdf.org/sesame-testsuites/sesame-rio-testsuite/)
(Aduna BSD license) OpenRDF Sesame: DatasetRepository (wrapper) (org.openrdf.sesame:sesame-repository-dataset:2.7.1 - http://www.openrdf.org/sesame-core/sesame-repository/sesame-repository-dataset/)
(Aduna BSD license) OpenRDF Sesame: Federation SAIL (org.openrdf.sesame:sesame-sail-federation:2.7.1 - http://www.openrdf.org/sesame-core/sesame-sail/sesame-sail-federation/)
(Aduna BSD license) OpenRDF Sesame: HTTP client (org.openrdf.sesame:sesame-http-client:2.7.1 - http://www.openrdf.org/sesame-core/sesame
View keybase.md

Keybase proof

I hereby claim:

  • I am egonw on github.
  • I am egonw (https://keybase.io/egonw) on keybase.
  • I have a public key ASCLt1J4TK6uvvwRip-pDwxy6jFT_C_LmFfZvGqMM9RqDAo

To claim this, I am signing this object:

View gist:d8f9f4f034bac1e6d0f550485fd50703
SELECT DISTINCT ?item ?itemLabel ?itemDescription ?image ?location ?distance ?sitelink WHERE {
SERVICE wikibase:around {
?item wdt:P625 ?location.
bd:serviceParam wikibase:center "[AUTO_COORDINATES]".
bd:serviceParam wikibase:radius "[RADIUS]".
bd:serviceParam wikibase:distance ?distance.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,es,de". }
FILTER(NOT EXISTS {
?item wdt:P18 ?image
View SMILESes for CDK Depict
COP(=O)([O-])OCC P not seen as chiral
[C@](COP(=O)([O-])OCC[N+](C)(C)C)([H])(O)COC=O P seen as chiral
[C@](COP(=O)([O-])OCC[N+](C)(C)C)([H])(OC=O)COC=O P seen as chiral
[C@](COP(=O)([O-])OCC[N+](C)(C)C)([H])(OC(CCCCCCCCCCCCCCCCC)=O)COC(CCCCCCCCCCCCCCCCC)=O P seen as chiral
View pfas.alreadyInWikidata
# ALVYVCQIFHTIRD-UHFFFAOYSA-N is already in Wikidata
# RVZRBWKZFJCCIB-UHFFFAOYSA-N is already in Wikidata
# LOQGSOTUHASIHI-UHFFFAOYSA-N is already in Wikidata
# ISFKSWMQWIRDNC-UHFFFAOYSA-N is already in Wikidata
# YYXWJNBPHDUWJP-UHFFFAOYSA-N is already in Wikidata
# UWEYRJFJVCLAGH-UHFFFAOYSA-N is already in Wikidata
# YVBBRRALBYAZBM-UHFFFAOYSA-N is already in Wikidata
# JUGSKHLZINSXPQ-UHFFFAOYSA-N is already in Wikidata
# KWXGJTSJUKTDQU-UHFFFAOYSA-N is already in Wikidata
# KHXKESCWFMPTFT-UHFFFAOYSA-N is already in Wikidata
@egonw
egonw / literature2Quickstatements.js
Last active Dec 14, 2019
Tool that takes a DOI and PubMed ID and creates Quickstatements for Wikidata
View literature2Quickstatements.js
# (C) 2019 Andra Waagmeester
# 2019 Egon Willighagen
#
# If you used this code, please cite this paper: https://www.biorxiv.org/content/10.1101/799684v1
#
# Install first (see https://pypi.org/project/wikidataintegrator/):
#
# pip install wikidataintegrator
#
# MIT License