home / crw2

RNA structures

One row per structure. Use the search box (organism or structure ID) and the filters at the top; the pdf / bpseq / ss columns link to the files.
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).

1 row where intron_subgroup = "D" sorted by organism

✎ View and edit SQL

This data as json, CSV (advanced)

rna_group 1

  • GRPI 1

intron_subgroup 1

  • D · 1 ✖

domain_label 1

  • Mitochondria 1
structure_id rna_group diagram_code molecule_code domain_code domain_label intron_subgroup organism ▼ source_folder folder_mismatch pdf_url bpseq_url ss_url
a.I1.m.P.anserina.D.CYTB GRPI a I1 m Mitochondria D P.anserina.D.CYTB GRPI/D/m.P.anserina.D.CYTB no https://staging.crw2.org/data/GRPI/D/m.P.anserina.D.CYTB/a.I1.m.P.anserina.D.CYTB.pdf https://staging.crw2.org/data/GRPI/D/m.P.anserina.D.CYTB/a.I1.m.P.anserina.D.CYTB.bpseq.txt https://staging.crw2.org/data/GRPI/D/m.P.anserina.D.CYTB/a.I1.m.P.anserina.D.CYTB.ss.txt

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 45.569ms