{"id":3728,"date":"2024-08-16T10:00:39","date_gmt":"2024-08-16T08:00:39","guid":{"rendered":"http:\/\/18.198.170.41\/?p=3728"},"modified":"2024-08-18T22:23:27","modified_gmt":"2024-08-18T20:23:27","slug":"knime-workflows-for-downloading-of-molport-data-for-offline-usage","status":"publish","type":"post","link":"https:\/\/blog.molport.com\/tutorials\/knime-workflows-for-downloading-of-molport-data-for-offline-usage\/","title":{"rendered":"KNIME Workflows for Downloading Molport Data for Offline Use"},"content":{"rendered":"<p style=\"text-align: justify;\">Molport provides a number of ways to access data and catalog information on commercially available compounds: the <a href=\"https:\/\/www.molport.com\/shop\/index\">Molport website<\/a>, the\u00a0<a href=\"https:\/\/www.molport.com\/shop\/molport-database-description\">Molport downloadable database<\/a>,\u00a0<a href=\"https:\/\/www.molport.com\/shop\/api-documentation-v-3-0\">Molport web services<\/a>\u00a0(API). With web services you can instantly check the current stock level information for MolPort compounds from your software application, Microsoft Excel, Optibrium\u00a0<a href=\"https:\/\/www.optibrium.com\/stardrop\/\">StarDrop<\/a>,\u00a0<a href=\"https:\/\/www.3ds.com\/products-services\/biovia\/products\/data-science\/pipeline-pilot\/\">Pipeline Pilot<\/a>\u00a0or\u00a0<a href=\"https:\/\/www.molport.com\/shop\/knime-nodes\">KNIME nodes<\/a>.<\/p>\n<p style=\"text-align: justify;\">A certain type of data analysis, like filtering by specific parameters, diversity selection, virtual screening or docking, require you to have full data locally. Full data download and its preparation for use require a certain amount of effort on the user\u2019s side. Following Molport user requests, we created example workflow that automate this process using <a href=\"https:\/\/www.molport.com\/shop\/knime-nodes\">KNIME software<\/a>. Now you can get to Molport data in KNIME easier.<\/p>\n<p style=\"text-align: justify;\">The workflow is named \u201c<strong><em>LoadMolPortData<\/em><\/strong>\u201d. It allows you to acquire FTP based Molport compound data files. There are multiple file types and for large collection there are multiple files to download. For each compound data includes the largest available stock amount, the fastest shipping time, price ranges for 1mg\/5mg\/50mg\/100mg\/250mg\/1g, whether it is available as a Screening Compound or a Building Block, the QC type, the InChI and the InChIKey. Access to this data is free, however requires use of credentials. To get yours, register or login to Molport website at <a href=\"https:\/\/www.molport.com\/shop\/sign-in\">https:\/\/www.molport.com\/shop\/sign-in<\/a> and once you are logged in navigate to FTP request page located here <a href=\"https:\/\/www.molport.com\/shop\/user-ftp-access\">https:\/\/www.molport.com\/shop\/user-ftp-access<\/a>. Then set up the workflow example to get Molport compound data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4629 size-full\" src=\"https:\/\/blog.molport.com\/wp-content\/uploads\/2022\/04\/LoadMolpoerData_v3_image.png\" alt=\"\" width=\"956\" height=\"631\" srcset=\"https:\/\/blog.molport.com\/wp-content\/uploads\/2022\/04\/LoadMolpoerData_v3_image.png 956w, https:\/\/blog.molport.com\/wp-content\/uploads\/2022\/04\/LoadMolpoerData_v3_image-300x198.png 300w, https:\/\/blog.molport.com\/wp-content\/uploads\/2022\/04\/LoadMolpoerData_v3_image-370x245.png 370w\" sizes=\"(max-width: 956px) 100vw, 956px\" \/><\/p>\n<p style=\"background: white; vertical-align: baseline; margin: 12pt 0cm 0cm; text-align: justify;\"><span style=\"font-size: 14.5pt; font-family: 'inherit',serif; color: #111111;\">Some companies have a restriction for FTP access. You may need to work with your system administrator to add Molport FTP location to allowed list.<\/span><\/p>\n<p style=\"background: white; vertical-align: baseline; margin: 12pt 0cm 19.8pt; text-align: justify;\"><span style=\"font-size: 14.5pt; font-family: 'inherit',serif; color: #111111;\">Example workflow contains descriptions and is compatible with KNIME version 5.2 or later.<\/span><\/p>\n<p><b>Files for download<\/b>:<br \/>\n<a href=\"https:\/\/blog.molport.com\/wp-content\/uploads\/2022\/04\/LoadMolportData_v3_example.zip\">LoadMolportData_v3_example<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Molport provides a number of ways to access data and catalog information on commercially available compounds: the Molport website, the\u00a0Molport downloadable database,\u00a0Molport web services\u00a0(API). With web services you can instantly check the current stock level information for MolPort compounds from your software application, Microsoft Excel, Optibrium\u00a0StarDrop,\u00a0Pipeline Pilot\u00a0or\u00a0KNIME nodes. A certain type of data analysis, like<\/p>\n","protected":false},"author":6,"featured_media":3988,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[69,28],"tags":[36],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/blog.molport.com\/wp-json\/wp\/v2\/posts\/3728"}],"collection":[{"href":"https:\/\/blog.molport.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.molport.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.molport.com\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.molport.com\/wp-json\/wp\/v2\/comments?post=3728"}],"version-history":[{"count":9,"href":"https:\/\/blog.molport.com\/wp-json\/wp\/v2\/posts\/3728\/revisions"}],"predecessor-version":[{"id":4632,"href":"https:\/\/blog.molport.com\/wp-json\/wp\/v2\/posts\/3728\/revisions\/4632"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.molport.com\/wp-json\/wp\/v2\/media\/3988"}],"wp:attachment":[{"href":"https:\/\/blog.molport.com\/wp-json\/wp\/v2\/media?parent=3728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.molport.com\/wp-json\/wp\/v2\/categories?post=3728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.molport.com\/wp-json\/wp\/v2\/tags?post=3728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}