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

2 posts / 0 new
Last post
xtalee
sqlite3 to obtain the filenames of selected images (over 5K)

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 ===

timgrant
Hi John,

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

Log in or register to post comments