openmolecules.org

 
Home » DataWarrior » Functionality » 'Search ChEMBL Database' function (Problem with substructure search)
'Search ChEMBL Database' function [message #376] Mon, 27 August 2018 21:46 Go to next message
kerryfowler is currently offline  kerryfowler
Messages: 1
Registered: July 2014
Junior Member
DataWarrior is the tool I've wanted for decades, so thanks to all the developers!

In version 4.7.2 the "Search ChEMBL Database..." function works for

similar structure to (sometimes)
equal structure to
stereo isomers of
tautomers of

but not for "superstructures of" which returns the message "Error in task 'Search ChEMBL Database': Your query did not retrieve any records."

The similarity search sometimes returns an error until the similarity threshold is lowered. For example, similarity search for dopamine as query fails until similarity is decreased from 90% to %89. Substructure query fails for dopamine.
Re: 'Search ChEMBL Database' function [message #377 is a reply to message #376] Tue, 28 August 2018 21:10 Go to previous messageGo to next message
thomas is currently offline  thomas
Messages: 219
Registered: June 2014
Senior Member
Thank you very much for the hint. I wasn't aware of the problem, which was caused by a recent server
update that now uses 64-bit descriptors rather than 32 bit ones in order to accelerate the search.
Unfortunately this wasn't consistently done and the pre-screening of candidates for the substructure search
didn't work because it expected the wrong type of descriptors.
I updated the server and the problem disappeared. There is still a more cosmetic problem. Large result sets
as dopamine as substructure (which retrieves 207'075 rows) are retrieved, but cause an error when retrieving
retrieving the respective assay descriptions (about 30'000). The error message is inconclusive. After closing
the error dialog DataWarrior opens a window with the 207075 results nonetheless.

Whether I can remove the remaining problem with another server update or whether is comes with the next DataWarrior
update I still need to find out.

Thanks again and best wishes,

Thomas
Re: 'Search ChEMBL Database' function [message #378 is a reply to message #377] Tue, 28 August 2018 23:14 Go to previous message
thomas is currently offline  thomas
Messages: 219
Registered: June 2014
Senior Member
I found the issue: When the results contain more than about 3000 distinct assay references, the request to
get the assay descriptions exceeds the maximum allowed size for GET requests on the Apache web-server.
When I use a POST request, then there is no error message. Since this is a DataWarrior client issues,
the next DataWarrior update will fix this.

Thomas
Previous Topic: chEMBL structure download limit ?
Next Topic: Boxplot sorting order
Goto Forum:
  


Current Time: Wed Aug 21 17:39:38 CEST 2019

Total time taken to generate the page: 0.00348 seconds