Skip to main content

Download, open, and query ChEMBL through SQLite

Project description

chembl_downloader

PyPI PyPI - Python Version PyPI - License

Don't worry about downloading/extracting ChEMBL or versioning - just use chembl_downloader to write code that knows how to download it and use it automatically.

Installation

$ pip install chembl-downloader

Download A Specific Version

import chembl_downloader

path = chembl_downloader.download(version='28')

After it's been downloaded and extracted once, it's smart and doesn't need to download again. It gets stored using pystow automatically in the ~/.data/chembl directory.

We'd like to implement something such that it could load directly into SQLite from the archive, but it appears this is a paid feature.

Download the Latest Version

First, you'll have to install bioversions with pip install bioversions, whose job it is to look up the latest version of many databases. Then, you can modify the previous code slightly by omitting the version keyword argument:

import chembl_downloader

path = chembl_downloader.download()

The version keyword argument is available for all functions in this package, but like the username and password will be omitted for brevity.

Automate Connection

Inside the archive is a single SQLite database file. Normally, people manually untar this folder then do something with the resulting file. Don't do this, it's not reproducible! Instead, the file can be downloaded and a connection can be opened automatically with:

import chembl_downloader

with chembl_downloader.cursor(version='28') as cursor:
    cursor.execute(...)  # run your query string
    rows = cursor.fetchall()  # get your results

You now know everything I can teach you. Please use these tools to do re-usable, reproducible science!

Store in a Different Place

If you want to store the data elsewhere using pystow (e.g., in pyobo I also keep a copy of this file), you can use the prefix argument.

import chembl_downloader

# It gets downloaded/extracted to 
# ~/.data/pyobo/raw/chembl/29/chembl_29/chembl_29_sqlite/chembl_29.db
path = chembl_downloader.download(prefix=['pyobo', 'raw', 'chembl'])

See the pystow documentation on configuring the storage location further.

Download via CLI

After installing, run the following CLI command to ensure it and send the path to stdout

$ chembl_downloader

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

chembl_downloader-0.0.1.tar.gz (7.3 kB view details)

Uploaded Source

Built Distribution

chembl_downloader-0.0.1-py3-none-any.whl (6.3 kB view details)

Uploaded Python 3

File details

Details for the file chembl_downloader-0.0.1.tar.gz.

File metadata

  • Download URL: chembl_downloader-0.0.1.tar.gz
  • Upload date:
  • Size: 7.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.2 importlib_metadata/4.6.1 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.61.2 CPython/3.9.5

File hashes

Hashes for chembl_downloader-0.0.1.tar.gz
Algorithm Hash digest
SHA256 20933f833d6b5274900e8838c6d1b5cefb59942ea0bc1f4ddfc1d8c71a050a2a
MD5 40fd2a3576aad9de63ab330aa12ccaef
BLAKE2b-256 f724992fb5a92981774999e94feb67c7860b4d21b77c8e4ca9139da9c9c52c8d

See more details on using hashes here.

Provenance

File details

Details for the file chembl_downloader-0.0.1-py3-none-any.whl.

File metadata

  • Download URL: chembl_downloader-0.0.1-py3-none-any.whl
  • Upload date:
  • Size: 6.3 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.2 importlib_metadata/4.6.1 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.61.2 CPython/3.9.5

File hashes

Hashes for chembl_downloader-0.0.1-py3-none-any.whl
Algorithm Hash digest
SHA256 22b346ea9947811801239e8df08a393d548cd42d3e526796e4a41c4fabe2e20a
MD5 4f45a191b71ffa2a6d21969a429e4bce
BLAKE2b-256 9f6685fc208f7c423048fd8bf38c7bd7b7ad45b339f8e739c42880e375cbd170

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page