This script provides the ability to connect directly to ScienceCloud, download data from libraries or saved queries of your choice and return the results directly into StarDrop.
Version
If you are using an older version of StarDrop, please contact us at support@optibrium.com and we will be happy to help install this script on your StarDrop client.
This integration is available to use with the latest version of StarDrop (Windows and macOS). To find out which version you have installed, start StarDrop and select the Help>About menu.
Installing and using the script
Windows with .zip file
- Exit StarDrop
- Download StarDrop Script – Science Cloud (64-bit)_py3Qt.zip
- In your user area, navigate to the StarDrop Python folder in C:\Users\username\AppData\Roaming\StarDrop
- Extract the contents of the zip file into this folder overwriting any existing files
- You should now see the following folders in the StarDrop folder:
py3\ScienceCloud
widgetplugins - Start StarDrop
macOS with .zip file
- Exit StarDrop
- Download StarDrop Script – Science Cloud (OSX)_py3Qt
- Extract the contents of the zip file into this folder overwriting any existing files, you should now see the following folders in the StarDrop folder:
py3ScienceCloud
widgetplugins
- In your user area, navigate to the StarDrop folder: /Users/username/StarDrop
- Move the unzipped folders, sub-folders, and files into the StarDrop folder, overwriting any existing files
- Start StarDrop
Windows with .exe file
- Exit StarDrop
- Download StarDrop Script – Science Cloud (64-bit)_py3Qt
- When the download is complete, double-click the file to run it and follow the instructions (we recommend that you accept the default options provided)
- Start StarDrop
Click on the Custom Scripts->ScienceCloud menu and choose the desired option (Download from ScienceCloud or Run query from ScienceCloud). This will prompt you to enter a valid username and password. If you do not have a valid username, please ask your ScienceCloud contact.
If you choose Download from ScienceCloud you will be presented with a list of all the libraries to which you have access, organised by project. You may select one or more of these libraries to download. If you select more than one library, these will be combined into a single data set in StarDrop. You can also select whether to aggregate the downloaded data by compound or by batch.
If you choose Run query from ScienceCloud you will be presented with a list of all the saved queries to which you have access. You may select one of these queries to download. You can also select whether to aggregate the downloaded data by compound or by batch.
When the download is complete, you will see a dialog that lists all the available assays from your selected libraries or query and allows you to select those assays that you wish to include in the data set. You can also customise the way in which StarDrop treats each assay, by providing an alias to use as a column name, and adding additional columns showing more detailed information about the results. Any customisation that you perform will be remembered next time you download results for that assay.
If you want to update the data in StarDrop, you can repeat the download by selecting Refresh->All data from the DataSet menu. New and updated entries will be clearly identified in your data set.
Installation files
Windows with .zip file
- Exit StarDrop
- Download StarDrop Script – Science Cloud (64-bit)_py3Qt.zip
- In your user area, navigate to the StarDrop Python folder in C:\Users\username\AppData\Roaming\StarDrop
- Extract the contents of the zip file into this folder overwriting any existing files
- You should now see the following folders in the StarDrop folder:
py3\ScienceCloud
widgetplugins - Start StarDrop
macOS with .zip file
- Exit StarDrop
- Download StarDrop Script – Science Cloud (OSX)_py3Qt
- Extract the contents of the zip file into this folder overwriting any existing files, you should now see the following folders in the StarDrop folder:
py3ScienceCloud
widgetplugins
- In your user area, navigate to the StarDrop folder: /Users/username/StarDrop
- Move the unzipped folders, sub-folders, and files into the StarDrop folder, overwriting any existing files
- Start StarDrop
Windows with .exe file
- Exit StarDrop
- Download StarDrop Script – Science Cloud (64-bit)_py3Qt
- When the download is complete, double-click the file to run it and follow the instructions (we recommend that you accept the default options provided)
- Start StarDrop
How to use the script
Click on the Custom Scripts->ScienceCloud menu and choose the desired option (Download from ScienceCloud or Run query from ScienceCloud). This will prompt you to enter a valid username and password. If you do not have a valid username, please ask your ScienceCloud contact.
If you choose Download from ScienceCloud you will be presented with a list of all the libraries to which you have access, organised by project. You may select one or more of these libraries to download. If you select more than one library, these will be combined into a single data set in StarDrop. You can also select whether to aggregate the downloaded data by compound or by batch.
If you choose Run query from ScienceCloud you will be presented with a list of all the saved queries to which you have access. You may select one of these queries to download. You can also select whether to aggregate the downloaded data by compound or by batch.
When the download is complete, you will see a dialog that lists all the available assays from your selected libraries or query and allows you to select those assays that you wish to include in the data set. You can also customise the way in which StarDrop treats each assay, by providing an alias to use as a column name, and adding additional columns showing more detailed information about the results. Any customisation that you perform will be remembered next time you download results for that assay.
If you want to update the data in StarDrop, you can repeat the download by selecting Refresh->All data from the DataSet menu. New and updated entries will be clearly identified in your data set.