{ "info": { "author": "Ohkawa Kazufumi", "author_email": "kerolinq@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 2 - Pre-Alpha", "License :: OSI Approved :: MIT License", "Operating System :: MacOS :: MacOS X", "Operating System :: POSIX", "Programming Language :: Python", "Topic :: Scientific/Engineering :: Chemistry" ], "description": "============\n pychembldb\n============\n\n`pychembldb` is a Python interface for ChEMBLdb\n\nRequirements\n------------\n* Python 2.7 or later (not support 3.x)\n* MySQL-python >= 1.2.4 or psycopg2 >= 2.5.1\n* SQLAlchemy >= 0.8.0b2\n\nChEMBLdb\n~~~~~~~~\n\n* pychembldb-0.1.x support chembl_14\n* pychembldb-0.2.x support chembl_15 and chembl_16\n* pychembldb-0.3.x support chembl_17,18,19\n\nSetup\n-----\n\nInstall\n~~~~~~~\n\n::\n\n pip install pychembldb\n\nor install from github\n\n::\n\n git clone https://github.com/kzfm/pychembldb.git\n cd pychembldb\n sudo python setup.py install\n\nSetting up engine_url\n~~~~~~~~~~~~~~~~~~~~~\n\nif you change engine_url, you should set CHEMBL_URI environment variable (default:mysql://root@localhost/chembl_18)\n\nex) PostgreSQL\n\n::\n\n export CHEMBL_URI=\"postgresql+psycopg2://localhost/chembl_18\"\n\n or\n\n export CHEMBL_URI=\"postgresql+psycopg2://USER:PASSWORD@localhost/chembl_18\" \n\n\nBasic Usage\n-----------\n\n::\n\n from pychembldb import *\n for target in chembldb.query(Target).filter_by(pref_name=\"Tyrosine-protein kinase ABL\"):\n for assay in target.assays:\n for activity in assay.activities:\n print activity.published_value, activity.compound.molecule.structure.standard_inchi_key\n\nExamples\n--------\n\nfilter activities and compound structures by Target(Protein).\n\n::\n\n from pychembldb import *\n for target in chembldb.query(Target).filter_by(pref_name=\"Tyrosine-protein kinase ABL\"):\n for assay in target.assays:\n for activity in assay.activities:\n print activity.published_value, activity.compound.molecule.structure.standard_inchi_key\n\nSearch activities and compound structures from Journal-ID(doi).\n\n::\n\n for journal in chembldb.query(Doc).filter_by(doi=\"10.1016/S0960-894X(01)80693-4\"):\n for assay in journal.assays:\n for activity in assay.activities:\n print activity.published_value, activity.compound.molecule.structure.standard_inchi_key\n\nGet SMILES from Molecule synonyms.\n\n::\n\n chembldb.query(MoleculeSynonym).filter_by(synonyms=\"Gleevec\").first().molecule.structure.canonical_smiles\n # 'CN1CCN(Cc2ccc(cc2)C(=O)Nc3ccc(C)c(Nc4nccc(n4)c5cccnc5)c3)CC1'\n\nCount the number of MedChem Friendly Compounds.\n\n::\n\n chembldb.query(CompoundProperty).filter_by(med_chem_friendly='Y').count()\n\nSee also.\n\n* http://docs.sqlalchemy.org/en/rel_0_8/orm/tutorial.html\n* ftp://ftp.ebi.ac.uk/pub/databases/chembl/ChEMBLdb/latest/chembl_18_erd.png\n\nHistory\n-------\n\n0.3.6 (2014-09-02)\n~~~~~~~~~~~~~~~~~~\n* Support ChEMBLdb 19\n\n0.3.4 (2014-06-07)\n~~~~~~~~~~~~~~~~~~\n* Update document\n* Support ATC Classifications\n\n0.3.3 (2014-06-06)\n~~~~~~~~~~~~~~~~~~\n* Support ChEMBLdb 18\n\n0.3.2 (2014-01-13)\n~~~~~~~~~~~~~~~~~~\n* Fix bug\n\n0.3.1 (2013-12-17)\n~~~~~~~~~~~~~~~~~~\n* Support ChEMBLdb 17\n\n0.2.1 (2013-06-15)\n~~~~~~~~~~~~~~~~~~\n* Support ChEMBLdb 16\n\n0.2.0 (2013-02-03)\n~~~~~~~~~~~~~~~~~~\n* Support ChEMBLdb 15\n\n0.1.1 (2013-01-29)\n~~~~~~~~~~~~~~~~~~\n* Several bug fixes\n* Add synonyms relation\n\n0.1 (2013-01-29)\n~~~~~~~~~~~~~~~~~~\n* first release", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://github.com/kzfm/pychembldb", "keywords": "chemoinformatics cheminformatics", "license": "MIT", "maintainer": null, "maintainer_email": null, "name": "pychembldb", "package_url": "https://pypi.org/project/pychembldb/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/pychembldb/", "project_urls": { "Download": "UNKNOWN", "Homepage": "http://github.com/kzfm/pychembldb" }, "release_url": "https://pypi.org/project/pychembldb/0.3.6/", "requires_dist": null, "requires_python": null, "summary": "ChEMBLdb interface for Python", "version": "0.3.6" }, "last_serial": 1210055, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "602b304d6540e9fcfaf9d445921a48be", "sha256": "c5d70903e2ba849e922ebc45b5db6fa3e41aa6ba72e59c2c7d5005952ce6341e" }, "downloads": -1, "filename": "pychembldb-0.1.tar.gz", "has_sig": false, "md5_digest": "602b304d6540e9fcfaf9d445921a48be", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2685, "upload_time": "2013-01-28T20:48:12", "url": "https://files.pythonhosted.org/packages/73/6a/4179b5f0f3e6af9d9dfac24128aeca3c37cb45e2618088f4ab265593ea22/pychembldb-0.1.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "c9c4459c65cea3675180f3e5985a740e", "sha256": "14c772cb8e9aafc4fb8667a26bbd3b73ad3082ed30dcfd0be504a5693c123bff" }, "downloads": -1, "filename": "pychembldb-0.1.1.tar.gz", "has_sig": false, "md5_digest": "c9c4459c65cea3675180f3e5985a740e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2756, "upload_time": "2013-01-29T11:35:13", "url": "https://files.pythonhosted.org/packages/a3/64/b03ecf47f62503d6194be489115c76cc4763d51ab69ffad484fa76773245/pychembldb-0.1.1.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "3693773b1b65efa3792c9ecbf4a2a96e", "sha256": "a28bffcc3b9eff1e827e2c7b2e45b6ff4084ba141c7dc4db5e1c018e22b2da7e" }, "downloads": -1, "filename": "pychembldb-0.2.0.tar.gz", "has_sig": false, "md5_digest": "3693773b1b65efa3792c9ecbf4a2a96e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3750, "upload_time": "2013-02-03T02:37:27", "url": "https://files.pythonhosted.org/packages/b8/42/c102a35a239e216ee44586cf2431a65561f933b211689a78457bfbd895ff/pychembldb-0.2.0.tar.gz" } ], "0.2.1": [ { "comment_text": "", "digests": { "md5": "db2abfdd5daf436d04d0071db1b5c9f5", "sha256": "eb1e87b6eaa1070f184d096e2b6a54044440faded8c91b80cc7dc2bb695c370a" }, "downloads": -1, "filename": "pychembldb-0.2.1.tar.gz", "has_sig": false, "md5_digest": "db2abfdd5daf436d04d0071db1b5c9f5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3769, "upload_time": "2013-06-15T07:08:03", "url": "https://files.pythonhosted.org/packages/06/a3/840ed36866dfb4425657d8c4dab171aa038065da969dd340b4b0723c0425/pychembldb-0.2.1.tar.gz" } ], "0.3.1": [ { "comment_text": "", "digests": { "md5": "351ca38059fb702d86d97b306fdb5e54", "sha256": "b01958da48fb244d58bb1a60f985b8990a7aed3d12c25397e622a7b431f3ccac" }, "downloads": -1, "filename": "pychembldb-0.3.1.tar.gz", "has_sig": false, "md5_digest": "351ca38059fb702d86d97b306fdb5e54", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3585, "upload_time": "2013-12-17T10:57:32", "url": "https://files.pythonhosted.org/packages/61/b1/078dacfe14f9798045d1b75a0c6eb4a71d1c74437882a5f5ca5c0d1fae18/pychembldb-0.3.1.tar.gz" } ], "0.3.2": [ { "comment_text": "", "digests": { "md5": "a050721b32c885c313f6120fc3faae18", "sha256": "774501f2efe8119eb48b19b3ec5a43acf238973ece43e66d5669a6a8923d1dc9" }, "downloads": -1, "filename": "pychembldb-0.3.2.tar.gz", "has_sig": false, "md5_digest": "a050721b32c885c313f6120fc3faae18", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3956, "upload_time": "2014-01-12T22:28:35", "url": "https://files.pythonhosted.org/packages/5e/19/1ec4c971e3407f94dd11cefa06ce0762b7fe39722c7ed6cd188a376c097b/pychembldb-0.3.2.tar.gz" } ], "0.3.3": [ { "comment_text": "", "digests": { "md5": "e17f7b67207005bfc8c8818e16b4903b", "sha256": "6981ffb14c3a41024c52f088b6ae3767ec4ae1c63011e34d17af46e3a33d6fdd" }, "downloads": -1, "filename": "pychembldb-0.3.3.tar.gz", "has_sig": false, "md5_digest": "e17f7b67207005bfc8c8818e16b4903b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4058, "upload_time": "2014-06-06T04:02:33", "url": "https://files.pythonhosted.org/packages/43/c8/bf08bfadaed1f70f02349c6f537753d28c80bcc6909e4177ef21e06826ee/pychembldb-0.3.3.tar.gz" } ], "0.3.4": [ { "comment_text": "", "digests": { "md5": "ac2c7cf65ab532b504cebfd5ceca252b", "sha256": "1be9a4a559f6a24eb8f60a116ac70fd2c99213c332a422f94926e4a453dd6c68" }, "downloads": -1, "filename": "pychembldb-0.3.4.tar.gz", "has_sig": false, "md5_digest": "ac2c7cf65ab532b504cebfd5ceca252b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4244, "upload_time": "2014-06-07T06:34:30", "url": "https://files.pythonhosted.org/packages/1f/11/187e09871e3d8941f0679691202837193c603136743e504c1dbe6235cd0b/pychembldb-0.3.4.tar.gz" } ], "0.3.5": [ { "comment_text": "", "digests": { "md5": "ab8fa902983dd5e2d0c842766bfa0c2b", "sha256": "cc178a84132ba4773a25d177096181500bdf3748a56943991adaac3bf28e7781" }, "downloads": -1, "filename": "pychembldb-0.3.5.tar.gz", "has_sig": false, "md5_digest": "ab8fa902983dd5e2d0c842766bfa0c2b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4247, "upload_time": "2014-09-02T08:25:47", "url": "https://files.pythonhosted.org/packages/4b/8c/95e1195fe31be180e45b9e34dacd98c60237fc1fec0ec7b16c3dbce369bb/pychembldb-0.3.5.tar.gz" } ], "0.3.6": [ { "comment_text": "", "digests": { "md5": "3e47bbdfdcb6ad75a09c224971a545c7", "sha256": "dfbcf68466691c7a4116738b3fac262cf03ff2b9ee384ef2eba3fcd1c89f958c" }, "downloads": -1, "filename": "pychembldb-0.3.6.tar.gz", "has_sig": false, "md5_digest": "3e47bbdfdcb6ad75a09c224971a545c7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4270, "upload_time": "2014-09-02T08:27:49", "url": "https://files.pythonhosted.org/packages/a6/b6/5c9e9b14ed3715c18796e53ba7a51c938c90bb477b9bfde9f1fb3c4bfaa8/pychembldb-0.3.6.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "3e47bbdfdcb6ad75a09c224971a545c7", "sha256": "dfbcf68466691c7a4116738b3fac262cf03ff2b9ee384ef2eba3fcd1c89f958c" }, "downloads": -1, "filename": "pychembldb-0.3.6.tar.gz", "has_sig": false, "md5_digest": "3e47bbdfdcb6ad75a09c224971a545c7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4270, "upload_time": "2014-09-02T08:27:49", "url": "https://files.pythonhosted.org/packages/a6/b6/5c9e9b14ed3715c18796e53ba7a51c938c90bb477b9bfde9f1fb3c4bfaa8/pychembldb-0.3.6.tar.gz" } ] }