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).
3 rows where domain_label = "Cyanelle" and rna_group = "23S" sorted by organism
This data as json, CSV (advanced)
| 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.23.y.C.paradoxa | 23S | d | 23 | y | Cyanelle | C.paradoxa | 23S/y/C.paradoxa | no | https://staging.crw2.org/data/23S/y/C.paradoxa/d.23.y.C.paradoxa.bpseq.txt | |||
| d.233.y.C.paradoxa | 23S | d | 233 | y | Cyanelle | C.paradoxa | 23S/y/C.paradoxa | no | https://staging.crw2.org/data/23S/y/C.paradoxa/d.233.y.C.paradoxa.pdf | https://staging.crw2.org/data/23S/y/C.paradoxa/d.233.y.C.paradoxa.bpseq.txt | https://staging.crw2.org/data/23S/y/C.paradoxa/d.233.y.C.paradoxa.ss.txt | |
| d.235.y.C.paradoxa | 23S | d | 235 | y | Cyanelle | C.paradoxa | 23S/y/C.paradoxa | no | https://staging.crw2.org/data/23S/y/C.paradoxa/d.235.y.C.paradoxa.pdf | https://staging.crw2.org/data/23S/y/C.paradoxa/d.235.y.C.paradoxa.bpseq.txt | https://staging.crw2.org/data/23S/y/C.paradoxa/d.235.y.C.paradoxa.ss.txt |
Advanced export
JSON shape: default, array, newline-delimited, object
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);