openmolecules.org

 
Home » DataWarrior » Functionality » row lists
row lists [message #549] Thu, 25 April 2019 20:09 Go to next message
pc419714@ohio.edu is currently offline  pc419714@ohio.edu
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: 646
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.

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


Current Time: Thu Mar 28 19:33:56 CET 2024

Total time taken to generate the page: 0.08194 seconds