{"id":2793,"date":"2023-10-18T14:32:54","date_gmt":"2023-10-18T05:32:54","guid":{"rendered":"https:\/\/bdsl.jbnu.ac.kr\/blog\/?p=2793"},"modified":"2023-10-18T14:37:53","modified_gmt":"2023-10-18T05:37:53","slug":"chembl-sql","status":"publish","type":"post","link":"https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/","title":{"rendered":"ChEMBL SQL"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">ChEMBL database\ub97c \ud65c\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc5ec\ub824 \ud14c\uc774\ube14\uc5d0 \ud769\uc5b4\uc838 \uc788\ub294 \uc815\ubcf4\ub97c \ud1b5\ud569\ud574\uc57c \ud55c\ub2e4. SQL \uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud574 \uc774\ub7ec\ud55c \uc791\uc5c5\uc774 \uac00\ub2a5\ud558\ub2e4. \uc5ec\uae30\uc5d0\uc11c\ub294 \uac04\ub2e8\ud55c \uc608\uc81c\ub97c \ud1b5\ud574 ChEMBL\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ud68d\ub4dd\ud558\ub294 \ubc29\ubc95\uc744 \uc5f0\uc2b5\ud55c\ub2e4. \ud2b9\ud788,  Python\uc744 \uc774\uc6a9\ud574 \ud504\ub85c\uadf8\ub7a8\uc744 \ud1b5\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud65c\uc6a9 \ubc29\ubc95\uc744 \uc2e4\uc2b5\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc544\ub798\uc758 \ub9c1\ud06c\uc5d0\uc11c ChEMBL\uc5d0\uc11c SQL \uba85\ub839\uc5b4\ub97c \ucc38\uace0\ud560 \uc218 \uc788\ub2e4. Oracle \uae30\ubc18\uc774\ubbc0\ub85c MySQL\uc744 \uc774\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc57d\uac04\uc758 \uc218\uc815\uc774 \ud544\uc694\ud558\ub2e4. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/chembl.gitbook.io\/chembl-interface-documentation\/frequently-asked-questions\/schema-questions-and-sql-examples\">https:\/\/chembl.gitbook.io\/chembl-interface-documentation\/frequently-asked-questions\/schema-questions-and-sql-examples<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Example 1 &#8211; \uc138\uade0\uc744 \ub300\uc0c1\uc73c\ub85c \ud558\ub294 \ud654\ud569\ubb3c \ub370\uc774\ud130 \ud655\ubcf4<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\uc544\ub798 SQL script\ub294  target \ub2e8\ubc31\uc9c8\uc774 &#8216;Bacteria&#8217;\uc5d0 \uc18d\ud558\ub294 organism class\uc5d0 \ud574\ub2f9\ud558\ub294 \uacbd\uc6b0\uc758 \ud654\ud569\ubb3c \uc815\ubcf4\ub97c \uc218\uc9d1\ud558\ub294 \uba85\ub839\uc5b4\uc774\ub2e4. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT md.chembl_id AS compound_chembl_id,\ncs.canonical_smiles,\nact.standard_type,\nact.standard_value,\nact.standard_units,\ntd.chembl_id AS target_chembl_id,\ntd.organism,   td.pref_name\nFROM target_dictionary td\n  JOIN assays a ON td.tid = a.tid\n  JOIN activities act ON a.assay_id = act.assay_id\n  JOIN molecule_dictionary md ON act.molregno = md.molregno\n  JOIN compound_structures cs ON md.molregno   = cs.molregno\n  JOIN organism_class oc ON td.tax_id = oc.tax_id\n    AND oc.L1 = 'Bacteria'<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">mysql client\uc5d0 \ud574\ub2f9 script\ub97c \uc785\ub825\ud558\uba74, \uad00\ub828 \ub370\uc774\ud130\ub97c \uc5bb\uc744 \uc218 \uc788\ub2e4. \ub2e4\ub9cc, \uc774 \uacbd\uc6b0 \ub9e4\uc6b0 \ub9ce\uc740 \ub370\uc774\ud130\ub97c \ud55c\ubc88\uc5d0 \ud45c\uae30\ud558\uac8c \ub418\uba70, \uc2e4\uc81c\ub85c \uc774\ub97c \uc774\uc6a9\ud558\ub294 \uac83\uc740 \uc5b4\ub824\uc6b8 \uc218 \uc788\ub2e4. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc2e4\uc81c \ub370\uc774\ud130\ub97c \ud65c\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud504\ub85c\uadf8\ub7a8\uc744 \uc774\uc6a9\ud574 \ub370\uc774\ud130\ub97c \uc5bb\uace0 \ubd84\uc11d\ud574\uc57c \ud55c\ub2e4. \uc5ec\uae30\uc11c\ub294 Python\uc744 \uc774\uc6a9\ud574 \ub370\uc774\ud130\ub97c \ubc1b\ub294 \ubc29\ubc95\uc744 \uc2e4\uc2b5\ud55c\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Python\uc744 \uc774\uc6a9\ud55c \ub370\uc774\ud130 \ud655\ubcf4 <\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"python\" class=\"language-python\">import pandas as pd\nimport mysql.connector\n\nconnection = mysql.connector.connect(\n    host=&lt;IP ADDRESS&gt;,\n    user=&lt;USER&gt;,\n    port=&lt;PORT&gt;,\n    password=&lt;PASSWORD&gt;,\n    database='chembl_33'\n)\ncursor = connection.cursor()\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"python\" class=\"language-python\">sql = '''SELECT md.chembl_id AS compound_chembl_id,\ncs.canonical_smiles,\nact.standard_type,\nact.standard_value,\nact.standard_units,\ntd.chembl_id AS target_chembl_id,\ntd.organism,   td.pref_name\nFROM target_dictionary td\n  JOIN assays a ON td.tid = a.tid\n  JOIN activities act ON a.assay_id = act.assay_id\n  JOIN molecule_dictionary md ON act.molregno = md.molregno\n  JOIN compound_structures cs ON md.molregno   = cs.molregno\n  JOIN organism_class oc ON td.tax_id = oc.tax_id\n    AND oc.L1 = 'Bacteria' limit 10;'''<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"python\" class=\"language-python\">cursor.execute(sql)\nfor e in cursor.fetchall():\n    print(e)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">pandas\ub97c \uc774\uc6a9\ud55c \ub370\uc774\ud130 \ubc1b\uae30<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Pandas\ub294 \ub370\uc774\ud130 \uad00\ub9ac\uc5d0 \ud2b9\ud654\ub41c Python library\uc774\ub2e4. \uc774\ub97c \uc774\uc6a9\ud574\uc11c MySQL database\uc5d0\uc11c \ub370\uc774\ud130\ub97c table \ud615\ud0dc\ub85c \ubc1b\uace0 \uad00\ub9ac\ud560 \uc218 \uc788\uc5b4 \ub110\ub9ac \uc774\uc6a9\ub41c\ub2e4. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"python\" class=\"language-python\">df = pd.read_sql(sql, connection)<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Example 2 &#8211; \ud2b9\uc815 \ub2e8\ubc31\uc9c8\uc5d0 \uacb0\ud569\ud558\ub294 \ud654\ud569\ubb3c<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\ub450 \ubc88\uc9f8 \uc608\ub85c, \ud2b9\uc815 \ub2e8\ubc31\uc9c8\uc5d0 \uacb0\ud569\ud558\ub294 \ud654\ud569\ubb3c \uc804\uccb4 \uc815\ubcf4\ub97c \uac00\uc838\uc628\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL script\uc640 pandas\ub97c \uc774\uc6a9\ud574 \ub370\uc774\ud130\ub97c \ud655\ubcf4\ud55c\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"python\" class=\"language-python\">sql = \"\"\"SELECT DISTINCT\n  m.chembl_id                      AS compound_chembl_id,\n  s.canonical_smiles,\n  r.compound_key,\n  act.standard_type,\n  act.standard_relation,\n  act.standard_value,\n  act.standard_units,\n  act.activity_comment,\n  t.chembl_id                      AS target_chembl_id,\n  t.pref_name                      AS target_name,\n  t.target_type\nFROM compound_structures s\n  RIGHT JOIN molecule_dictionary m ON s.molregno = m.molregno\n  JOIN compound_records r ON m.molregno = r.molregno\n  JOIN docs d ON r.doc_id = d.doc_id\n  JOIN activities act ON r.record_id = act.record_id\n  JOIN assays a ON act.assay_id = a.assay_id\n  JOIN target_dictionary t ON a.tid = t.tid\n  JOIN target_components tc ON t.tid = tc.tid\n  JOIN component_sequences cs ON tc.component_id = cs.component_id\n    AND cs.accession = 'P08172'\n    limit 100;\n    \"\"\"\ndf = pd.read_sql(sql, connection)<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Introduction ChEMBL database\ub97c \ud65c\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc5ec\ub824 \ud14c\uc774\ube14\uc5d0 \ud769\uc5b4\uc838 \uc788\ub294 \uc815\ubcf4\ub97c \ud1b5\ud569\ud574\uc57c \ud55c\ub2e4. SQL \uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud574 \uc774\ub7ec\ud55c \uc791\uc5c5\uc774 \uac00\ub2a5\ud558\ub2e4. \uc5ec\uae30\uc5d0\uc11c\ub294 \uac04\ub2e8\ud55c \uc608\uc81c\ub97c \ud1b5\ud574 ChEMBL\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ud68d\ub4dd\ud558\ub294 \ubc29\ubc95\uc744 \uc5f0\uc2b5\ud55c\ub2e4. \ud2b9\ud788, Python\uc744 \uc774\uc6a9\ud574 \ud504\ub85c\uadf8\ub7a8\uc744 \ud1b5\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud65c\uc6a9 \ubc29\ubc95\uc744 \uc2e4\uc2b5\ud55c\ub2e4. \uc544\ub798\uc758 \ub9c1\ud06c\uc5d0\uc11c ChEMBL\uc5d0\uc11c SQL \uba85\ub839\uc5b4\ub97c \ucc38\uace0\ud560 \uc218 \uc788\ub2e4. Oracle \uae30\ubc18\uc774\ubbc0\ub85c MySQL\uc744 \uc774\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc57d\uac04\uc758 \uc218\uc815\uc774 \ud544\uc694\ud558\ub2e4. https:\/\/chembl.gitbook.io\/chembl-interface-documentation\/frequently-asked-questions\/schema-questions-and-sql-examples Example 1 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[1],"tags":[],"class_list":["post-2793","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ChEMBL SQL - Biomedical Data Science Laboratory<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ChEMBL SQL - Biomedical Data Science Laboratory\" \/>\n<meta property=\"og:description\" content=\"Introduction ChEMBL database\ub97c \ud65c\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc5ec\ub824 \ud14c\uc774\ube14\uc5d0 \ud769\uc5b4\uc838 \uc788\ub294 \uc815\ubcf4\ub97c \ud1b5\ud569\ud574\uc57c \ud55c\ub2e4. SQL \uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud574 \uc774\ub7ec\ud55c \uc791\uc5c5\uc774 \uac00\ub2a5\ud558\ub2e4. \uc5ec\uae30\uc5d0\uc11c\ub294 \uac04\ub2e8\ud55c \uc608\uc81c\ub97c \ud1b5\ud574 ChEMBL\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ud68d\ub4dd\ud558\ub294 \ubc29\ubc95\uc744 \uc5f0\uc2b5\ud55c\ub2e4. \ud2b9\ud788, Python\uc744 \uc774\uc6a9\ud574 \ud504\ub85c\uadf8\ub7a8\uc744 \ud1b5\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud65c\uc6a9 \ubc29\ubc95\uc744 \uc2e4\uc2b5\ud55c\ub2e4. \uc544\ub798\uc758 \ub9c1\ud06c\uc5d0\uc11c ChEMBL\uc5d0\uc11c SQL \uba85\ub839\uc5b4\ub97c \ucc38\uace0\ud560 \uc218 \uc788\ub2e4. Oracle \uae30\ubc18\uc774\ubbc0\ub85c MySQL\uc744 \uc774\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc57d\uac04\uc758 \uc218\uc815\uc774 \ud544\uc694\ud558\ub2e4. https:\/\/chembl.gitbook.io\/chembl-interface-documentation\/frequently-asked-questions\/schema-questions-and-sql-examples Example 1 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Biomedical Data Science Laboratory\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-18T05:32:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-18T05:37:53+00:00\" \/>\n<meta name=\"author\" content=\"sphong\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sphong\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/chembl-sql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/chembl-sql\\\/\"},\"author\":{\"name\":\"sphong\",\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/#\\\/schema\\\/person\\\/8d22f775fcc218b1184ec0d890034e9b\"},\"headline\":\"ChEMBL SQL\",\"datePublished\":\"2023-10-18T05:32:54+00:00\",\"dateModified\":\"2023-10-18T05:37:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/chembl-sql\\\/\"},\"wordCount\":44,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/chembl-sql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/chembl-sql\\\/\",\"url\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/chembl-sql\\\/\",\"name\":\"ChEMBL SQL - Biomedical Data Science Laboratory\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/#website\"},\"datePublished\":\"2023-10-18T05:32:54+00:00\",\"dateModified\":\"2023-10-18T05:37:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/chembl-sql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/chembl-sql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/chembl-sql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ChEMBL SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/\",\"name\":\"Biomedical Data Science Laboratory\",\"description\":\"Home page for Biomedical Data Science Laboratory.\",\"publisher\":{\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/#organization\",\"name\":\"Biomedical Data Science Laboratory\",\"url\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/11\\\/logo.png\",\"width\":1792,\"height\":638,\"caption\":\"Biomedical Data Science Laboratory\"},\"image\":{\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/#\\\/schema\\\/person\\\/8d22f775fcc218b1184ec0d890034e9b\",\"name\":\"sphong\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/cropped-\uc99d\uba85\uc0ac\uc9c4-96x96.jpg\",\"url\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/cropped-\uc99d\uba85\uc0ac\uc9c4-96x96.jpg\",\"contentUrl\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/cropped-\uc99d\uba85\uc0ac\uc9c4-96x96.jpg\",\"caption\":\"sphong\"},\"description\":\"Assistant professor Department of Molecular Biology Jeonbuk National University\",\"sameAs\":[\"https:\\\/\\\/bdsl.jbnu.ac.kr\"],\"url\":\"https:\\\/\\\/bdsl.jbnu.ac.kr\\\/blog\\\/author\\\/sphong\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ChEMBL SQL - Biomedical Data Science Laboratory","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/","og_locale":"en_US","og_type":"article","og_title":"ChEMBL SQL - Biomedical Data Science Laboratory","og_description":"Introduction ChEMBL database\ub97c \ud65c\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc5ec\ub824 \ud14c\uc774\ube14\uc5d0 \ud769\uc5b4\uc838 \uc788\ub294 \uc815\ubcf4\ub97c \ud1b5\ud569\ud574\uc57c \ud55c\ub2e4. SQL \uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud574 \uc774\ub7ec\ud55c \uc791\uc5c5\uc774 \uac00\ub2a5\ud558\ub2e4. \uc5ec\uae30\uc5d0\uc11c\ub294 \uac04\ub2e8\ud55c \uc608\uc81c\ub97c \ud1b5\ud574 ChEMBL\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ud68d\ub4dd\ud558\ub294 \ubc29\ubc95\uc744 \uc5f0\uc2b5\ud55c\ub2e4. \ud2b9\ud788, Python\uc744 \uc774\uc6a9\ud574 \ud504\ub85c\uadf8\ub7a8\uc744 \ud1b5\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud65c\uc6a9 \ubc29\ubc95\uc744 \uc2e4\uc2b5\ud55c\ub2e4. \uc544\ub798\uc758 \ub9c1\ud06c\uc5d0\uc11c ChEMBL\uc5d0\uc11c SQL \uba85\ub839\uc5b4\ub97c \ucc38\uace0\ud560 \uc218 \uc788\ub2e4. Oracle \uae30\ubc18\uc774\ubbc0\ub85c MySQL\uc744 \uc774\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc57d\uac04\uc758 \uc218\uc815\uc774 \ud544\uc694\ud558\ub2e4. https:\/\/chembl.gitbook.io\/chembl-interface-documentation\/frequently-asked-questions\/schema-questions-and-sql-examples Example 1 [&hellip;]","og_url":"https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/","og_site_name":"Biomedical Data Science Laboratory","article_published_time":"2023-10-18T05:32:54+00:00","article_modified_time":"2023-10-18T05:37:53+00:00","author":"sphong","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sphong","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/#article","isPartOf":{"@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/"},"author":{"name":"sphong","@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/#\/schema\/person\/8d22f775fcc218b1184ec0d890034e9b"},"headline":"ChEMBL SQL","datePublished":"2023-10-18T05:32:54+00:00","dateModified":"2023-10-18T05:37:53+00:00","mainEntityOfPage":{"@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/"},"wordCount":44,"commentCount":0,"publisher":{"@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/","url":"https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/","name":"ChEMBL SQL - Biomedical Data Science Laboratory","isPartOf":{"@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/#website"},"datePublished":"2023-10-18T05:32:54+00:00","dateModified":"2023-10-18T05:37:53+00:00","breadcrumb":{"@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/chembl-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bdsl.jbnu.ac.kr\/blog\/"},{"@type":"ListItem","position":2,"name":"ChEMBL SQL"}]},{"@type":"WebSite","@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/#website","url":"https:\/\/bdsl.jbnu.ac.kr\/blog\/","name":"Biomedical Data Science Laboratory","description":"Home page for Biomedical Data Science Laboratory.","publisher":{"@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bdsl.jbnu.ac.kr\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/#organization","name":"Biomedical Data Science Laboratory","url":"https:\/\/bdsl.jbnu.ac.kr\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-content\/uploads\/2022\/11\/logo.png","contentUrl":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-content\/uploads\/2022\/11\/logo.png","width":1792,"height":638,"caption":"Biomedical Data Science Laboratory"},"image":{"@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/#\/schema\/person\/8d22f775fcc218b1184ec0d890034e9b","name":"sphong","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-content\/uploads\/2022\/04\/cropped-\uc99d\uba85\uc0ac\uc9c4-96x96.jpg","url":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-content\/uploads\/2022\/04\/cropped-\uc99d\uba85\uc0ac\uc9c4-96x96.jpg","contentUrl":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-content\/uploads\/2022\/04\/cropped-\uc99d\uba85\uc0ac\uc9c4-96x96.jpg","caption":"sphong"},"description":"Assistant professor Department of Molecular Biology Jeonbuk National University","sameAs":["https:\/\/bdsl.jbnu.ac.kr"],"url":"https:\/\/bdsl.jbnu.ac.kr\/blog\/author\/sphong\/"}]}},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"sphong","author_link":"https:\/\/bdsl.jbnu.ac.kr\/blog\/author\/sphong\/"},"uagb_comment_info":0,"uagb_excerpt":"Introduction ChEMBL database\ub97c \ud65c\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc5ec\ub824 \ud14c\uc774\ube14\uc5d0 \ud769\uc5b4\uc838 \uc788\ub294 \uc815\ubcf4\ub97c \ud1b5\ud569\ud574\uc57c \ud55c\ub2e4. SQL \uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud574 \uc774\ub7ec\ud55c \uc791\uc5c5\uc774 \uac00\ub2a5\ud558\ub2e4. \uc5ec\uae30\uc5d0\uc11c\ub294 \uac04\ub2e8\ud55c \uc608\uc81c\ub97c \ud1b5\ud574 ChEMBL\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ud68d\ub4dd\ud558\ub294 \ubc29\ubc95\uc744 \uc5f0\uc2b5\ud55c\ub2e4. \ud2b9\ud788, Python\uc744 \uc774\uc6a9\ud574 \ud504\ub85c\uadf8\ub7a8\uc744 \ud1b5\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud65c\uc6a9 \ubc29\ubc95\uc744 \uc2e4\uc2b5\ud55c\ub2e4. \uc544\ub798\uc758 \ub9c1\ud06c\uc5d0\uc11c ChEMBL\uc5d0\uc11c SQL \uba85\ub839\uc5b4\ub97c \ucc38\uace0\ud560 \uc218 \uc788\ub2e4. Oracle \uae30\ubc18\uc774\ubbc0\ub85c MySQL\uc744 \uc774\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc57d\uac04\uc758 \uc218\uc815\uc774 \ud544\uc694\ud558\ub2e4. https:\/\/chembl.gitbook.io\/chembl-interface-documentation\/frequently-asked-questions\/schema-questions-and-sql-examples Example 1&hellip;","_links":{"self":[{"href":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-json\/wp\/v2\/posts\/2793","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-json\/wp\/v2\/comments?post=2793"}],"version-history":[{"count":6,"href":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-json\/wp\/v2\/posts\/2793\/revisions"}],"predecessor-version":[{"id":2800,"href":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-json\/wp\/v2\/posts\/2793\/revisions\/2800"}],"wp:attachment":[{"href":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-json\/wp\/v2\/media?parent=2793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-json\/wp\/v2\/categories?post=2793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bdsl.jbnu.ac.kr\/blog\/wp-json\/wp\/v2\/tags?post=2793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}