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 domain_label = "Cyanelle" and rna_group = "16S" sorted by organism

✎ View and edit SQL

This data as json, CSV (advanced)

rna_group 1

  • 16S · 1 ✖

domain_label 1

  • Cyanelle · 1 ✖

intron_subgroup 0

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
d.16.y.C.paradoxa 16S d 16 y Cyanelle   C.paradoxa 16S/y/C.paradoxa no https://staging.crw2.org/data/16S/y/C.paradoxa/d.16.y.C.paradoxa.pdf https://staging.crw2.org/data/16S/y/C.paradoxa/d.16.y.C.paradoxa.bpseq.txt https://staging.crw2.org/data/16S/y/C.paradoxa/d.16.y.C.paradoxa.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 203.213ms