Provide csv output for foldseek results table

[malovic@…]

Add a context menu entry to save foldseek results table in comma-separated values or tab-separated values format.

On Mar 11, 2025, at 9:04 AM, Emir MALOVIC via ChimeraX-users wrote:

Hello,

...

Am I able to somehow copy the Similar Structures table or export it into Excel? A copy/paste function would be ideal and quick.

I am using the Chimera 1.10 dev.

Please let me know at your earliest convenience!
Thank you,
Emir

[Tom Goddard]

Begin forwarded message:

From: Eric Pettersen
Subject: Re: Copy and paste in ChimeraX table does not work on Mac
Date: March 11, 2025 at 1:03:24 PM PDT
To: Tom Goddard

Hi Tom,

ItemTable inherits from QTableView, so I guess QTableView does not support copy/paste. I'm not really sure what would go into the paste buffer anyway. ItemTable does support write_values() method for writing the table contents as a CSV or TSV file, which can be hooked up to a context-menu entry or an explicit interface button. The Rotamers, Check Waters, and Axes/Planes/Centroids tools hook up context-menu entries for their buttons. Writing a CSV/TSV file also preserves the headers.

--Eric

[Tom Goddard]

Fixed in 1.10.

Added similar structures context menu entry to save comma-separated-values or tab-separated-values.

It saves the entire table. Currently no way to save just the selected rows.

I didn't make a command to do it because the command should work for any results even those not shown in the user interface panel so it couldn't use the generic user interface table save and would require more work. The command could be added if a good case were made for it.