sqlite3 to obtain the filenames of selected images (over 5K)

2 posts / 0 new

Thu, 03/05/2020 - 05:13

xtalee

Dear all,

I would like to obtain the filenames of ~5,300 selected images after CTF estimation, but when typed like below using sqlite3

select filename from image_assets, image_group_1 where image_assets.image_asset_id = image_group_1.image_asset_id;

a partial list is only obtained and all ~5,300 filenames are not shown (most probably due to display limit in the shell?). I shall be most grateful if any of you happen to advise me how to figure this out.

Thank you in advance.

John

=== Never mind. Just figured this out and unlocked the scrolling limit. John ===

Wed, 03/11/2020 - 21:20

timgrant

Hi John,

If prior to your selection you type ".output wanted_file.txt" then the search will be written to file.

Hope this solves your problem!

Tim