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: 715
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: 715
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

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

Mon, 01 May 2023 16:45

rkp@23
Messages: 3
Registered: April 2023

Junior Member

I am having a similar issue,
I am trying to query organohalides on ChemBL and searching using the "superstructures of" filter.
The search did not yield any result.
I have attached a screenshot of the query I used.

Is there any issue with the ChemBL server search in the version 5.5.0?

Attachment: Screen Shot 2023-05-01 at 10.46.38 AM.png
(Size: 225.49KB, Downloaded 161 times)

[Updated on: Mon, 01 May 2023 16:47]

Report message to a moderator

Re: 'Search ChEMBL Database' function [message #1905 is a reply to message #1890]

Sat, 27 May 2023 18:01

thomas
Messages: 715
Registered: June 2014

Senior Member

Assuming that your '[3]' atom list contains Cl,Br,I I could confirm that no rows are returned on the current chembl server with the version 32 database. It also shows a message that your search is not specific enough and would return too many records. If you use the same query, but use iodine instead of all three halogene atoms, then 101'394 rows are returned containing 10'531 distinct structures. Currently, the server limits results to 50'000 distinct structures for sub-structure queries and to 100'000 structures for other structure searches. The idea of the limit is a historic one to make sure that a result download is not taking forever and both, client and server resources are fit to handle the result. For the next server version I will increase these limits by a factor of 2.

Report message to a moderator

Previous Topic:	Calculating similarity to one query compound
Next Topic:	Unable to Create New Form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Nov 25 07:10:23 CET 2024

Total time taken to generate the page: 0.03532 seconds