310 likes | 427 Views
Academia use cases : 1. Implementation of Open PHACTS API into MOE 2. Implementation of Open PHACTS API into Google Spreadsheet. Richter Lars, Pharmacoinformatics Research Group, University of Vienna 6th Open PHACTS Community Workshop. Structure of presentation.
E N D
Academiausecases:1. Implementationof Open PHACTS API into MOE 2. Implementationof Open PHACTS API into Google Spreadsheet Richter Lars, Pharmacoinformatics Research Group, University of Vienna 6th Open PHACTS Community Workshop
Structure of presentation • 1. Implementation of Open PHACTS API into MOE • Intro MOE • PresentationofApp‘sfunctionality • Presentationoftheunderlyingcode • Concludingremarks • 2. Implementation of Open PHACTS API into Google Spreadsheet • Intro Google Spreadsheet • PresentationofApp‘sfunctionality • Presentationoftheunderlyingcode • Concludingremarks
Structure of presentation • 1. Implementation of Open PHACTS API into MOE • Intro MOE • PresentationofApp‘sfunctionality • Presentationoftheunderlyingcode • Concludingremarks • 2. Implementation of Open PHACTS API into Google Spreadsheet • Intro Google Spreadsheet • PresentationofApp‘sfunctionality • Presentationoftheunderlyingcode • Concludingremarks
Intro MOE • MOE (Molecular Operating Environment) • Fullyintegrateddrugdiscoverysoftwarepackage • Structure-Based Design • Cheminformaticsand QSAR • Pharmacophore Design • Molecular Modeling andSimulations, … • Widelyused in UniVieresearchgroup • Central workbenchforthegroup • SVL (Scientific Vector Language) • Programming languagebuiltinto MOE • makes MOE customizable • Add newtools • Adaptexistingtools
Standard routine OpenPHACTS-MOE Import datadirectlyinto MOE bytarget ID input • Get all pharmacologicaldatafor a proteintarget. • collectpharmacologicaldatafromvarioussources • Publications • Public databases • Bring them in coherentformat • Merge different sources • Import datainto MOE
Structure of presentation • 1. Implementationof Open PHACTS API into MOE (MOE App) • Intro MOE • PresentationofApp‘sfunctionality • Presentationoftheunderlyingcode • Concludingremarks • 2. Implementationof Open PHACTS API into Google Spreadsheet (Google App) • Intro Google Spreadsheet • PresentationofApp‘sfunctionality • Presentationoftheunderlyingcode • Concludingremarks
Structure of presentation • 1. Implementation of Open PHACTS API into MOE • Intro MOE • PresentationofApp‘sfunctionality • Presentationoftheunderlyingcode • Concludingremarks • 2. Implementation of Open PHACTS API into Google Spreadsheet • Intro Google Spreadsheet • PresentationofApp‘sfunctionality • Presentationoftheunderlyingcode • Concludingremarks
Structure of presentation • 1. Implementation of Open PHACTS API into MOE • Intro MOE • PresentationofApp‘sfunctionality • Presentationoftheunderlyingcode • Concludingremarks • 2. Implementation of Open PHACTS API into Google Spreadsheet • Intro Google Spreadsheet • PresentationofApp‘sfunctionality • Presentationoftheunderlyingcode • Concludingremarks
Concluding remarks • User meets OpenPHACTS in his familiar environment (here MOE) • Code will be available from SVL exchange, once it has been cross-checked by CCG developers • Potential difficulty with error handling (discussion with CCG necessary)
Structure of presentation • 1. Implementationof Open PHACTS API into MOE • Intro MOE • Presentation of App‘s functionality • Presentationoftheunderlyingcode • Concludingremarks • 2. Implementationof Open PHACTS API into Google Spreadsheet • Intro Google Spreadsheet • Presentation of App‘s functionality • Presentationoftheunderlyingcode • Concludingremarks
Intro Spreadsheet • Google Spreadsheet • Create andeditspreadsheet online whilecollaboratingwithothers live • Free forindividuals, but hasfeesforbusiness • Import/ Export of Microsoft Excel files • Written in JavaScript • Code runs on cloud not on client • Google App Script • Based on JavaScript • Customize Google Spreadsheet • Add new functionality • Adapt existing functionality
Structure of presentation • 1. Implementationof Open PHACTS API into MOE • Intro MOE • Presentation of App‘s functionality • Presentationoftheunderlyingcode • Concludingremarks • 2. Implementationof Open PHACTS API into Google Spreadsheet • Intro Google Spreadsheet • Presentation of App‘s functionality • Presentationoftheunderlyingcode • Concludingremarks
Structure of presentation • 1. Implementationof Open PHACTS API into MOE • Intro MOE • Presentation of App‘s functionality • Presentationoftheunderlyingcode • Concludingremarks • 2. Implementationof Open PHACTS API into Google Spreadsheet • Intro Google Spreadsheet • Presentation of App‘s functionality • Presentationoftheunderlyingcode • Concludingremarks
Presentation of underlying code Panel.html
Presentation of underlying code Fetch TSV fromOpenPHACTS Convert TSV into JS Array Write JS Array to Google Spreadsheet
Structure of presentation • 1. Implementationof Open PHACTS API into MOE • Intro MOE • Presentation of App‘s functionality • Presentationoftheunderlyingcode • Concludingremarks • 2. Implementationof Open PHACTS API into Google Spreadsheet • Intro Google Spreadsheet • Presentation of App‘s functionality • Presentationoftheunderlyingcode • Concludingremarks
Concluding remarks • Code already freely available, link to spreadsheet is available • Current limitations • problem with larger queries maximum number of results is set to 100 • poor error handling currently implemented