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

29 rows where domain_label = "Archaea" and rna_group = "5S" sorted by organism

✎ View and edit SQL

This data as json, CSV (advanced)

rna_group 1

  • 5S · 29 ✖

domain_label 1

  • Archaea · 29 ✖

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.5.a.A.fulgidus 5S d 5 a Archaea   A.fulgidus 5S/a/A.fulgidus no https://staging.crw2.org/data/5S/a/A.fulgidus/d.5.a.A.fulgidus.pdf https://staging.crw2.org/data/5S/a/A.fulgidus/d.5.a.A.fulgidus.bpseq.txt https://staging.crw2.org/data/5S/a/A.fulgidus/d.5.a.A.fulgidus.ss.txt
d.5.a.A.pernix 5S d 5 a Archaea   A.pernix 5S/a/A.pernix no https://staging.crw2.org/data/5S/a/A.pernix/d.5.a.A.pernix.pdf https://staging.crw2.org/data/5S/a/A.pernix/d.5.a.A.pernix.bpseq.txt https://staging.crw2.org/data/5S/a/A.pernix/d.5.a.A.pernix.ss.txt
d.5.a.D.mobilis 5S d 5 a Archaea   D.mobilis 5S/a/D.mobilis no https://staging.crw2.org/data/5S/a/D.mobilis/d.5.a.D.mobilis.pdf https://staging.crw2.org/data/5S/a/D.mobilis/d.5.a.D.mobilis.bpseq.txt https://staging.crw2.org/data/5S/a/D.mobilis/d.5.a.D.mobilis.ss.txt
d.5.a.H.marismortui 5S d 5 a Archaea   H.marismortui 5S/a/H.marismortui no https://staging.crw2.org/data/5S/a/H.marismortui/d.5.a.H.marismortui.pdf https://staging.crw2.org/data/5S/a/H.marismortui/d.5.a.H.marismortui.bpseq.txt https://staging.crw2.org/data/5S/a/H.marismortui/d.5.a.H.marismortui.ss.txt
d.5.a.H.mediterranei.1 5S d 5 a Archaea   H.mediterranei.1 5S/a/H.mediterranei.1 no https://staging.crw2.org/data/5S/a/H.mediterranei.1/d.5.a.H.mediterranei.1.pdf https://staging.crw2.org/data/5S/a/H.mediterranei.1/d.5.a.H.mediterranei.1.bpseq.txt https://staging.crw2.org/data/5S/a/H.mediterranei.1/d.5.a.H.mediterranei.1.ss.txt
d.5.a.H.morrhuae.1 5S d 5 a Archaea   H.morrhuae.1 5S/a/H.morrhuae.1 no https://staging.crw2.org/data/5S/a/H.morrhuae.1/d.5.a.H.morrhuae.1.pdf https://staging.crw2.org/data/5S/a/H.morrhuae.1/d.5.a.H.morrhuae.1.bpseq.txt https://staging.crw2.org/data/5S/a/H.morrhuae.1/d.5.a.H.morrhuae.1.ss.txt
d.5.a.H.morrhuae.2 5S d 5 a Archaea   H.morrhuae.2 5S/a/H.morrhuae.2 no https://staging.crw2.org/data/5S/a/H.morrhuae.2/d.5.a.H.morrhuae.2.pdf https://staging.crw2.org/data/5S/a/H.morrhuae.2/d.5.a.H.morrhuae.2.bpseq.txt https://staging.crw2.org/data/5S/a/H.morrhuae.2/d.5.a.H.morrhuae.2.ss.txt
d.5.a.H.saccharovorum 5S d 5 a Archaea   H.saccharovorum 5S/a/H.saccharovorum no https://staging.crw2.org/data/5S/a/H.saccharovorum/d.5.a.H.saccharovorum.pdf https://staging.crw2.org/data/5S/a/H.saccharovorum/d.5.a.H.saccharovorum.bpseq.txt https://staging.crw2.org/data/5S/a/H.saccharovorum/d.5.a.H.saccharovorum.ss.txt
d.5.a.H.salinarum.1 5S d 5 a Archaea   H.salinarum.1 5S/a/H.salinarum.1 no https://staging.crw2.org/data/5S/a/H.salinarum.1/d.5.a.H.salinarum.1.pdf https://staging.crw2.org/data/5S/a/H.salinarum.1/d.5.a.H.salinarum.1.bpseq.txt https://staging.crw2.org/data/5S/a/H.salinarum.1/d.5.a.H.salinarum.1.ss.txt
d.5.a.H.salinarum.2 5S d 5 a Archaea   H.salinarum.2 5S/a/H.salinarum.2 no https://staging.crw2.org/data/5S/a/H.salinarum.2/d.5.a.H.salinarum.2.pdf https://staging.crw2.org/data/5S/a/H.salinarum.2/d.5.a.H.salinarum.2.bpseq.txt https://staging.crw2.org/data/5S/a/H.salinarum.2/d.5.a.H.salinarum.2.ss.txt
d.5.a.H.volcanii 5S d 5 a Archaea   H.volcanii 5S/a/H.volcanii no https://staging.crw2.org/data/5S/a/H.volcanii/d.5.a.H.volcanii.pdf https://staging.crw2.org/data/5S/a/H.volcanii/d.5.a.H.volcanii.bpseq.txt https://staging.crw2.org/data/5S/a/H.volcanii/d.5.a.H.volcanii.ss.txt
d.5.a.M.barkeri 5S d 5 a Archaea   M.barkeri 5S/a/M.barkeri no https://staging.crw2.org/data/5S/a/M.barkeri/d.5.a.M.barkeri.pdf https://staging.crw2.org/data/5S/a/M.barkeri/d.5.a.M.barkeri.bpseq.txt https://staging.crw2.org/data/5S/a/M.barkeri/d.5.a.M.barkeri.ss.txt
d.5.a.M.fervidus 5S d 5 a Archaea   M.fervidus 5S/a/M.fervidus no https://staging.crw2.org/data/5S/a/M.fervidus/d.5.a.M.fervidus.pdf https://staging.crw2.org/data/5S/a/M.fervidus/d.5.a.M.fervidus.bpseq.txt https://staging.crw2.org/data/5S/a/M.fervidus/d.5.a.M.fervidus.ss.txt
d.5.a.M.formicicum 5S d 5 a Archaea   M.formicicum 5S/a/M.formicicum no https://staging.crw2.org/data/5S/a/M.formicicum/d.5.a.M.formicicum.pdf https://staging.crw2.org/data/5S/a/M.formicicum/d.5.a.M.formicicum.bpseq.txt https://staging.crw2.org/data/5S/a/M.formicicum/d.5.a.M.formicicum.ss.txt
d.5.a.M.jannaschii.rrnA 5S d 5 a Archaea   M.jannaschii.rrnA 5S/a/M.jannaschii.rrnA no https://staging.crw2.org/data/5S/a/M.jannaschii.rrnA/d.5.a.M.jannaschii.rrnA.pdf https://staging.crw2.org/data/5S/a/M.jannaschii.rrnA/d.5.a.M.jannaschii.rrnA.bpseq.txt https://staging.crw2.org/data/5S/a/M.jannaschii.rrnA/d.5.a.M.jannaschii.rrnA.ss.txt
d.5.a.M.jannaschii.rrnB 5S d 5 a Archaea   M.jannaschii.rrnB 5S/a/M.jannaschii.rrnB no https://staging.crw2.org/data/5S/a/M.jannaschii.rrnB/d.5.a.M.jannaschii.rrnB.pdf https://staging.crw2.org/data/5S/a/M.jannaschii.rrnB/d.5.a.M.jannaschii.rrnB.bpseq.txt https://staging.crw2.org/data/5S/a/M.jannaschii.rrnB/d.5.a.M.jannaschii.rrnB.ss.txt
d.5.a.M.thermautotrophicus.1 5S d 5 a Archaea   M.thermautotrophicus.1 5S/a/M.thermoautotrophicus.1 no https://staging.crw2.org/data/5S/a/M.thermoautotrophicus.1/d.5.a.M.thermautotrophicus.1.pdf https://staging.crw2.org/data/5S/a/M.thermoautotrophicus.1/d.5.a.M.thermautotrophicus.1.bpseq.txt https://staging.crw2.org/data/5S/a/M.thermoautotrophicus.1/d.5.a.M.thermautotrophicus.1.ss.txt
d.5.a.M.thermolithotrophicus.2 5S d 5 a Archaea   M.thermolithotrophicus.2 5S/a/M.thermoautotrophicus.2 no https://staging.crw2.org/data/5S/a/M.thermoautotrophicus.2/d.5.a.M.thermolithotrophicus.2.pdf https://staging.crw2.org/data/5S/a/M.thermoautotrophicus.2/d.5.a.M.thermolithotrophicus.2.bpseq.txt https://staging.crw2.org/data/5S/a/M.thermoautotrophicus.2/d.5.a.M.thermolithotrophicus.2.ss.txt
d.5.a.M.tindarius.1 5S d 5 a Archaea   M.tindarius.1 5S/a/M.tindarius.1 no https://staging.crw2.org/data/5S/a/M.tindarius.1/d.5.a.M.tindarius.1.pdf https://staging.crw2.org/data/5S/a/M.tindarius.1/d.5.a.M.tindarius.1.bpseq.txt https://staging.crw2.org/data/5S/a/M.tindarius.1/d.5.a.M.tindarius.1.ss.txt
d.5.a.M.vacuolata 5S d 5 a Archaea   M.vacuolata 5S/a/M.vacuolata no https://staging.crw2.org/data/5S/a/M.vacuolata/d.5.a.M.vacuolata.pdf https://staging.crw2.org/data/5S/a/M.vacuolata/d.5.a.M.vacuolata.bpseq.txt https://staging.crw2.org/data/5S/a/M.vacuolata/d.5.a.M.vacuolata.ss.txt
d.5.a.N.magadii 5S d 5 a Archaea   N.magadii 5S/a/N.magadii no https://staging.crw2.org/data/5S/a/N.magadii/d.5.a.N.magadii.pdf https://staging.crw2.org/data/5S/a/N.magadii/d.5.a.N.magadii.bpseq.txt https://staging.crw2.org/data/5S/a/N.magadii/d.5.a.N.magadii.ss.txt
d.5.a.P.aerophilum 5S d 5 a Archaea   P.aerophilum 5S/a/P.aerophilum no https://staging.crw2.org/data/5S/a/P.aerophilum/d.5.a.P.aerophilum.pdf https://staging.crw2.org/data/5S/a/P.aerophilum/d.5.a.P.aerophilum.bpseq.txt https://staging.crw2.org/data/5S/a/P.aerophilum/d.5.a.P.aerophilum.ss.txt
d.5.a.P.occultum 5S d 5 a Archaea   P.occultum 5S/a/P.occultum no https://staging.crw2.org/data/5S/a/P.occultum/d.5.a.P.occultum.pdf https://staging.crw2.org/data/5S/a/P.occultum/d.5.a.P.occultum.bpseq.txt https://staging.crw2.org/data/5S/a/P.occultum/d.5.a.P.occultum.ss.txt
d.5.a.P.woesei 5S d 5 a Archaea   P.woesei 5S/a/P.woesei no https://staging.crw2.org/data/5S/a/P.woesei/d.5.a.P.woesei.pdf https://staging.crw2.org/data/5S/a/P.woesei/d.5.a.P.woesei.bpseq.txt https://staging.crw2.org/data/5S/a/P.woesei/d.5.a.P.woesei.ss.txt
d.5.a.S.acidocaldarius.1 5S d 5 a Archaea   S.acidocaldarius.1 5S/a/S.acidocaldarius.1 no https://staging.crw2.org/data/5S/a/S.acidocaldarius.1/d.5.a.S.acidocaldarius.1.pdf https://staging.crw2.org/data/5S/a/S.acidocaldarius.1/d.5.a.S.acidocaldarius.1.bpseq.txt https://staging.crw2.org/data/5S/a/S.acidocaldarius.1/d.5.a.S.acidocaldarius.1.ss.txt
d.5.a.S.solfataricus 5S d 5 a Archaea   S.solfataricus 5S/a/S.solfataricus no https://staging.crw2.org/data/5S/a/S.solfataricus/d.5.a.S.solfataricus.pdf https://staging.crw2.org/data/5S/a/S.solfataricus/d.5.a.S.solfataricus.bpseq.txt https://staging.crw2.org/data/5S/a/S.solfataricus/d.5.a.S.solfataricus.ss.txt
d.5.a.Sulfolobus.sp.B12 5S d 5 a Archaea   Sulfolobus.sp.B12 5S/a/Sulfolobus.sp.B12 no https://staging.crw2.org/data/5S/a/Sulfolobus.sp.B12/d.5.a.Sulfolobus.sp.B12.pdf https://staging.crw2.org/data/5S/a/Sulfolobus.sp.B12/d.5.a.Sulfolobus.sp.B12.bpseq.txt https://staging.crw2.org/data/5S/a/Sulfolobus.sp.B12/d.5.a.Sulfolobus.sp.B12.ss.txt
d.5.a.T.acidophilum 5S d 5 a Archaea   T.acidophilum 5S/a/T.acidophilum.1 no https://staging.crw2.org/data/5S/a/T.acidophilum.1/d.5.a.T.acidophilum.pdf https://staging.crw2.org/data/5S/a/T.acidophilum.1/d.5.a.T.acidophilum.bpseq.txt https://staging.crw2.org/data/5S/a/T.acidophilum.1/d.5.a.T.acidophilum.ss.txt
d.5.a.T.celer.1 5S d 5 a Archaea   T.celer.1 5S/a/T.celer.1 no https://staging.crw2.org/data/5S/a/T.celer.1/d.5.a.T.celer.1.pdf https://staging.crw2.org/data/5S/a/T.celer.1/d.5.a.T.celer.1.bpseq.txt https://staging.crw2.org/data/5S/a/T.celer.1/d.5.a.T.celer.1.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 436.468ms