RNA structures
- structure_id
- Unique ID taken from the file name.
- rna_group
- 16S, 23S, 5S, GRPI (group I intron) or GRPII (group II intron).
- domain_label
- Archaea, Bacteria, Chloroplast, Eukarya, Mitochondria or Cyanelle.
- intron_subgroup
- Intron subgroup (GRPI A-E or UNK, GRPII A-B); blank for rRNAs.
- folder_mismatch
- yes = files for this structure exist in more than one folder; worth a manual check.
- pdf_url
- Structure diagram (PDF).
- bpseq_url
- Base-pair list (bpseq format).
- ss_url
- Secondary-structure file (ss format).
4 rows where domain_label = "Mitochondria", intron_subgroup = "A" and rna_group = "GRPI" sorted by organism
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "structures" ( "structure_id" TEXT PRIMARY KEY, "rna_group" TEXT, "diagram_code" TEXT, "molecule_code" TEXT, "domain_code" TEXT, "domain_label" TEXT, "intron_subgroup" TEXT, "organism" TEXT, "source_folder" TEXT, "folder_mismatch" TEXT , "pdf_url" TEXT, "bpseq_url" TEXT, "ss_url" TEXT);