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

12 rows where domain_label = "Chloroplast", intron_subgroup = "C" and rna_group = "GRPI" sorted by organism

✎ View and edit SQL

This data as json, CSV (advanced)

rna_group 1

  • GRPI · 12 ✖

intron_subgroup 1

  • C · 12 ✖

domain_label 1

  • Chloroplast · 12 ✖
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.c.A.cherimola.C3.tLEU GRPI a I1 c Chloroplast C A.cherimola.C3.tLEU GRPI/C/c.A.cherimola.C3.tLEU no https://staging.crw2.org/data/GRPI/C/c.A.cherimola.C3.tLEU/a.I1.c.A.cherimola.C3.tLEU.pdf https://staging.crw2.org/data/GRPI/C/c.A.cherimola.C3.tLEU/a.I1.c.A.cherimola.C3.tLEU.bpseq.txt https://staging.crw2.org/data/GRPI/C/c.A.cherimola.C3.tLEU/a.I1.c.A.cherimola.C3.tLEU.ss.txt
a.I1.c.G.prostrata.C3.tLEU GRPI a I1 c Chloroplast C G.prostrata.C3.tLEU GRPI/C/c.G.prostrata.C3.tLEU no https://staging.crw2.org/data/GRPI/C/c.G.prostrata.C3.tLEU/a.I1.c.G.prostrata.C3.tLEU.pdf https://staging.crw2.org/data/GRPI/C/c.G.prostrata.C3.tLEU/a.I1.c.G.prostrata.C3.tLEU.bpseq.txt https://staging.crw2.org/data/GRPI/C/c.G.prostrata.C3.tLEU/a.I1.c.G.prostrata.C3.tLEU.ss.txt
a.I1.c.N.tabacum.C3.tLEU GRPI a I1 c Chloroplast C N.tabacum.C3.tLEU GRPI/C/c.N.tabacum.C3.tLEU no https://staging.crw2.org/data/GRPI/C/c.N.tabacum.C3.tLEU/a.I1.c.N.tabacum.C3.tLEU.pdf https://staging.crw2.org/data/GRPI/C/c.N.tabacum.C3.tLEU/a.I1.c.N.tabacum.C3.tLEU.bpseq.txt https://staging.crw2.org/data/GRPI/C/c.N.tabacum.C3.tLEU/a.I1.c.N.tabacum.C3.tLEU.ss.txt
a.I1.c.O.sativa.C3.tLEU GRPI a I1 c Chloroplast C O.sativa.C3.tLEU GRPI/C/c.O.sativa.C3.tLEU no https://staging.crw2.org/data/GRPI/C/c.O.sativa.C3.tLEU/a.I1.c.O.sativa.C3.tLEU.pdf https://staging.crw2.org/data/GRPI/C/c.O.sativa.C3.tLEU/a.I1.c.O.sativa.C3.tLEU.bpseq.txt https://staging.crw2.org/data/GRPI/C/c.O.sativa.C3.tLEU/a.I1.c.O.sativa.C3.tLEU.ss.txt
a.I1.c.P.thunbergii.C3.tLEU GRPI a I1 c Chloroplast C P.thunbergii.C3.tLEU GRPI/C/c.P.thunbergii.C3.tLEU no https://staging.crw2.org/data/GRPI/C/c.P.thunbergii.C3.tLEU/a.I1.c.P.thunbergii.C3.tLEU.pdf https://staging.crw2.org/data/GRPI/C/c.P.thunbergii.C3.tLEU/a.I1.c.P.thunbergii.C3.tLEU.bpseq.txt https://staging.crw2.org/data/GRPI/C/c.P.thunbergii.C3.tLEU/a.I1.c.P.thunbergii.C3.tLEU.ss.txt
a.I1.c.S.alterniflora.C3.tLEU GRPI a I1 c Chloroplast C S.alterniflora.C3.tLEU GRPI/C/c.S.alterniflora.C3.tLEU no https://staging.crw2.org/data/GRPI/C/c.S.alterniflora.C3.tLEU/a.I1.c.S.alterniflora.C3.tLEU.pdf https://staging.crw2.org/data/GRPI/C/c.S.alterniflora.C3.tLEU/a.I1.c.S.alterniflora.C3.tLEU.bpseq.txt https://staging.crw2.org/data/GRPI/C/c.S.alterniflora.C3.tLEU/a.I1.c.S.alterniflora.C3.tLEU.ss.txt
a.I1.c.S.anglica.C3.tLEU GRPI a I1 c Chloroplast C S.anglica.C3.tLEU GRPI/C/c.S.anglica.C3.tLEU no https://staging.crw2.org/data/GRPI/C/c.S.anglica.C3.tLEU/a.I1.c.S.anglica.C3.tLEU.pdf https://staging.crw2.org/data/GRPI/C/c.S.anglica.C3.tLEU/a.I1.c.S.anglica.C3.tLEU.bpseq.txt https://staging.crw2.org/data/GRPI/C/c.S.anglica.C3.tLEU/a.I1.c.S.anglica.C3.tLEU.ss.txt
a.I1.c.S.bicolor.C3.tLEU GRPI a I1 c Chloroplast C S.bicolor.C3.tLEU GRPI/C/c.S.bicolor.C3.tLEU no https://staging.crw2.org/data/GRPI/C/c.S.bicolor.C3.tLEU/a.I1.c.S.bicolor.C3.tLEU.pdf https://staging.crw2.org/data/GRPI/C/c.S.bicolor.C3.tLEU/a.I1.c.S.bicolor.C3.tLEU.bpseq.txt https://staging.crw2.org/data/GRPI/C/c.S.bicolor.C3.tLEU/a.I1.c.S.bicolor.C3.tLEU.ss.txt
a.I1.c.S.maritima.C3.tLEU GRPI a I1 c Chloroplast C S.maritima.C3.tLEU GRPI/C/c.S.maritima.C3.tLEU no https://staging.crw2.org/data/GRPI/C/c.S.maritima.C3.tLEU/a.I1.c.S.maritima.C3.tLEU.pdf https://staging.crw2.org/data/GRPI/C/c.S.maritima.C3.tLEU/a.I1.c.S.maritima.C3.tLEU.bpseq.txt https://staging.crw2.org/data/GRPI/C/c.S.maritima.C3.tLEU/a.I1.c.S.maritima.C3.tLEU.ss.txt
a.I1.c.S.x.townsendii.C3.tLEU GRPI a I1 c Chloroplast C S.x.townsendii.C3.tLEU GRPI/C/c.S.x.townsendii.C3.tLEU no https://staging.crw2.org/data/GRPI/C/c.S.x.townsendii.C3.tLEU/a.I1.c.S.x.townsendii.C3.tLEU.pdf https://staging.crw2.org/data/GRPI/C/c.S.x.townsendii.C3.tLEU/a.I1.c.S.x.townsendii.C3.tLEU.bpseq.txt https://staging.crw2.org/data/GRPI/C/c.S.x.townsendii.C3.tLEU/a.I1.c.S.x.townsendii.C3.tLEU.ss.txt
a.I1.c.V.faba.C3.tLEU GRPI a I1 c Chloroplast C V.faba.C3.tLEU GRPI/C/c.V.faba.C3.tLEU no https://staging.crw2.org/data/GRPI/C/c.V.faba.C3.tLEU/a.I1.c.V.faba.C3.tLEU.pdf https://staging.crw2.org/data/GRPI/C/c.V.faba.C3.tLEU/a.I1.c.V.faba.C3.tLEU.bpseq.txt https://staging.crw2.org/data/GRPI/C/c.V.faba.C3.tLEU/a.I1.c.V.faba.C3.tLEU.ss.txt
a.I1.c.Z.mays.C3.tLEU GRPI a I1 c Chloroplast C Z.mays.C3.tLEU GRPI/C/c.Z.mays.C3.tLEU no https://staging.crw2.org/data/GRPI/C/c.Z.mays.C3.tLEU/a.I1.c.Z.mays.C3.tLEU.pdf https://staging.crw2.org/data/GRPI/C/c.Z.mays.C3.tLEU/a.I1.c.Z.mays.C3.tLEU.bpseq.txt https://staging.crw2.org/data/GRPI/C/c.Z.mays.C3.tLEU/a.I1.c.Z.mays.C3.tLEU.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 43.593ms