openmolecules.org Forum: Functionality » 'Search ChEMBL Database' function

Home » DataWarrior » Functionality » 'Search ChEMBL Database' function (Problem with substructure search)

Show: Today's Messages :: Polls :: Message Navigator

'Search ChEMBL Database' function [message #376]

Mon, 27 August 2018 21:46

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.

Report message to a moderator

Re: 'Search ChEMBL Database' function [message #377 is a reply to message #376]

Tue, 28 August 2018 21:10

thomas
Messages: 502
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

Report message to a moderator

Re: 'Search ChEMBL Database' function [message #378 is a reply to message #377]

Tue, 28 August 2018 23:14

thomas
Messages: 502
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon May 23 20:50:02 CEST 2022

Total time taken to generate the page: 0.01447 seconds