Extract format data from chembl with Dask #cheminformatics #memo #chembl

Happy new year. I hope reader had nice year-end holidays. I started running from 1st Jan. I would like to run 1500 km in this year. ast year, I posted about REST api usage of chembl multitask target prediction. It allows predict possible target without any ML env in user PC. But sometime user would

ChEMBL multitask prediction with python requrests #memo #chembl #cheminfo

ChEMBL provides multitask prediction model from its github repo. And shared useful blog post.https://chembl.blogspot.com/2019/05/multi-task-neural-network-on-chembl.html By using the code, we can get predicted target list from given molecules. And the prediction can run python, C++, JS and Knime! ChEMBL team provides not only source code but also predicted results when we search compound in ChEMBL DB.

Make curated Kinase inhibitor dataset from ChEMBL30 #memo #chemoinformatcs

Kinase is one of the attractive target for drug discovery. So there are lots of data not only protein but also inhibitor available. ChEMBL is useful public data source for Kinase inhibitor data however to use the data, we need to retrieve data from the DB and curate it. Of course there are commercial database

Extract macro cyclic compounds from ChEMBLDB with rdkit_cartridge #chemoinformatics #RDKit

As you know, RDKit has really useful postgreSQL cartridge. So it’s easy to do substructure or similarity search of query structure from postgresql ChEMBLDB. But I don’t know how to retrieve only macrocyclic compound from ChEMBLDB with the cartridge. I searched RDKit mailing list and got good answer! Thanks for the community. This is the

Modify version of RDKit/Contrib/pzc #chemoinformatics #RDKit #ChEMBL #pychembldb

In 2013, Dr. Paul Czodrowski published nice article in JCIM. And the code is available from github. And also Paul contributed rdkit with the code. https://github.com/pzc/rdkit/tree/master/Contrib/pzc This code can build model from chembl activity data set with given accession number as a query. I had interest the code however, the code is old. So it

Update conda package of rdkit-postgresql #rdkit #postgresql

Yesterday, I enjoyed mishima.syk #16. Due to recent COVID-19, we moved the meeting to virtual style and worked very well. As same as RDKit UGM 2020, we used Zoom for presentation and discord for discussion and chat. Discord was very useful and easy to use. Thank for all participants and member of the community. The

FPSim2 for fast compound search #fpsim2 #rdkit #chemoinformatics

In the previous posts, I described various way to search compounds from data source such as ChEMBL. For example… using rdkit postgre cartridge, GPUsim which is developed by schrodinger and rdSubstructLibrary which is implemented in RDKit. All methods are very useful. And today I tried to use FPSim2 which was described in ChEMBL-OG. The package

Integration razi and pychembldb #RDKit #Chemoinformatics #razi #sqlalchemy #ChEMBL

As you know, sqlalchemy is very useful ORM of python. I love the package and also chemoinformatician is familiar to ChEMBLDB I think. There are very useful package for these people one is razi and the other is pychembldb. Razi is chemical cartridge for postgressql with rdkit functionality and pychembldb is python wrapper of ChEMBLDB

GET TID and PREF_NAME from CHEMBL

I want to retrieve relationship between TID and PREF_NAME in specific case from ChEMBL DB. SQL query is following. I ran the sql and got result like …. :-)  

SQL query for CHEMBL21

It was just memorandum for my self. PostgreSql can save sql result as csv using COPY( sql statement ) TO ‘filelocation/filename’ And ‘\i file.sql’ command can execute SQL from file. https://www.postgresql.org/docs/9.1/static/app-psql.html