openmolecules.org Forum: Functionality » Tagging Data to a Particular Assay

Home » DataWarrior » Functionality » Tagging Data to a Particular Assay

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

Tagging Data to a Particular Assay [message #1030]

Thu, 06 August 2020 20:06

ELFritzen
Messages: 47
Registered: November 2019
Location: North Carolina, US

Member

I'm not sure this can be done in DataWarrior or not, but I thought I'd ask. In adding ADME data to a Datawarrior file, I need to add data for the same assay run at different test sites. For example I might have solubility data for the same compound run at two or three different CRO's. I'd like to keep that data in a column labeled solubility, for example, but have some way of tagging which value was done at which CRO. Currently the only way I know of doing this is to create separate columns labeled Solubility CRO1, Solubility CRO2 etc. This works, but will be very cumbersome when done for some of the other assays we're doing. It would be nice to keep all the data for the same assay in just one column. Notating the data with an asterisk and placing a comment in a the comment column would also work, but that brings up some other problems when it comes to sorting or exporting data. Does anyone else face a similar challenge?
Thanks.
Ed Fritzen
VincereBio

Ed Fritzen

Report message to a moderator

Re: Tagging Data to a Particular Assay [message #1031 is a reply to message #1030]

Fri, 07 August 2020 09:49

thomas
Messages: 715
Registered: June 2014

Senior Member

The proper alternative would be having the solubility data all in one column and a second column containing the source. If a row contains multiple measurements from different (or same) sources, then both columns should contains the same number of entries separated by '; ' or in separate lines. In dwar files line breaks are encoded as '<NL>'. You may tell DataWarrior that both columns are logically connected and the order of cell entries in both columns match. For that both columns must have the same group name defined in the column properties section. If your column titles would be 'Solubility Value' and 'Solubility Source' and the group name would be 'solubility' then the column properties section should look like this:
(Note: the white space in the column properties line must be a TAB)

<column properties>
<columnName="Solubility Value">
<columnProperty="groupName solubility">
<columnName="Solubility Source">
<columnProperty="groupName solubility">
...
</column properties>

Report message to a moderator

Re: Tagging Data to a Particular Assay [message #1033 is a reply to message #1031]

Fri, 07 August 2020 13:59

ELFritzen
Messages: 47
Registered: November 2019
Location: North Carolina, US

Member

Hi Thomas,
Thank you for the prompt reply. That's exactly what I would like to do. I could repeat the process for each assay that has been done by multiple sources. I just am not familiar with how to actually set up the columns. How do you set columns like you've shown? If I add a new column, I only get options to set "column type" and "column name". Is there another way to add columns?
Thanks,
Ed

Ed Fritzen

Report message to a moderator

Re: Tagging Data to a Particular Assay [message #1035 is a reply to message #1033]

Fri, 07 August 2020 17:46

thomas
Messages: 715
Registered: June 2014

Senior Member

sorry I wasn't clear. The problem is that DataWarrior has no GUI elements to define that. These settings are done automatically, when retrieving data from e.g. the Idorsia drug discovery database.

You basically have two options of how to set the column properties:
- open a dwar files with a text editor and type or paste the four lines just after the <column properties> line.
If there is no <column properties> line, you have to add that as well followed by a </column properties> line
after the four pasted lines.
- alternatively you can run a macro that adds the column properties. I have attached an example macro file.
You can also edit the macro file in a text editor to match your column names.

Thomas

Attachment: t.dwam
(Size: 0.26KB, Downloaded 392 times)

Report message to a moderator

Previous Topic:	.dwar file is not recognized
Next Topic:	Averaging Values in three columns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 21 18:21:45 CET 2024

Total time taken to generate the page: 0.03330 seconds