I got SQLite database containing SRA metadata from:
My problem: many tables with many columns with often non obvious content.
Columns from experiment table: design_description TEXT, library_name TEXT, library_strategy TEXT, library_source TEXT, library_selection TEXT, library_layout TEXT, library_construction_protocol TEXT,
can have empty values, contain "OTHER". The most obvious columns (librarysource and librarystrategy) do not contain anything LIKE "%RNA%" in it save for "VIRAL RNA".
Any ideas how to get RNA-Seq small/ncRNA experiments/runs for a given species?
edit: +VIRAL RNA