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).

31 rows where domain_label = "Eukarya" and intron_subgroup = "UNK" sorted by organism

✎ View and edit SQL

This data as json, CSV (advanced)

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);