Home » DataWarrior » Functionality » row lists
row lists [message #549] Thu, 25 April 2019 20:09 Go to next message is currently offline
Messages: 20
Registered: February 2019
Junior Member
Say I had a list of ligands that were ranked according to their binding energy from a docking program. The output from the docking program had ligand numbers that corresponded with the .sdf file I exported from DataWarrior after converting to conformers. Would it be possible to take this list of row numbers and use the row list function to view these ligands in order of ranked binding energy? I'm not sure if row lists can be used this way in Data Warrior. I have not tried it yet.
Re: row lists [message #550 is a reply to message #549] Thu, 25 April 2019 21:47 Go to previous message
thomas is currently offline  thomas
Messages: 360
Registered: June 2014
Senior Member
I just checked: If you generate conformers from an open DataWarrior window into a new SD-file, then this file contains a column 'ID' containing the original file's row number. If your docking program's output file contains these IDs as well as binding energies in TAB-delimited or CSV format, then you may merge that file into the original DataWarrior file. Because that one does not contain the IDs, you need to generate them first with 'Data -> Add row numbers' starting from 1. Then you can merge using 'Row number' and 'ID', which adds the binding energies as a new column to your original file.

Alternatively, you could create a list from those IDs, if DataWarrior would allow you to select numeric column as key column. Unfortunately, this is not possible till today, which I have now fixed in the source code. Nevertheless, creating a list would also require to create a new column with row numbers. To me merging ernergies into the original file seems to be the better solution anyway.

Previous Topic: Hiding data points and corresponding legend
Next Topic: Adjust axis range
Goto Forum:

Current Time: Thu Sep 24 17:38:32 CEST 2020

Total time taken to generate the page: 0.00735 seconds