Obtain list of matched pairs with common core from an ID. about mmpdb HOT 4 OPEN

Hi Mike,

this is not a standard use case that we implemented, so you need a workaround. You can generate a list of all matched pairs if you index to a .csv file rather than a sqlite database. As a next step, you'd then need to match the activities with the pairs in the .csv file and filter to teh pairs that you are interested in - this should be rather straightforward with for example pandas.

Bests,
Christian

from mmpdb.

Hi Christian,

Thanks for the pointer, I've managed to pull together the values I need from the csv output.

This would seem to be a useful feature for the main application? Its pretty much the first thing I do with matched pairs, just list the relationships within a set of compounds.

Thanks again,
Mike

from mmpdb.

Is your organization interesting in funding that development, with the results contributed back to mmpdb?

from mmpdb.

Hi Andrew,

Not for functionality like this I'm afraid.

The CSV file output contains the exact information needed, which will work for small datasets.
Seems a pretty useful addition to be able to recreate that for a list of provided ids direct from the sqlite database.

Thanks,
Mike

from mmpdb.