CRW2 data

Custom SQL query

Queries

Tables

alignments

molecule, group_code, taxon_scope, file_type, relative_path, raw_filename, url

37 rows

basepair_collective_score

molecule, helix_number, position_1, position_2, pair_note, header_format, reference_base_pair, conformation, ai_code, tertiary_type, header_extra, strength, group_code, Xch, Ych, PE, PES, Cov1, Cov3, C1+C3, WC, WCGU, XCons, YCons, DfDel, PNuc, Seq

9,436 rows

basepair_frequency

molecule, helix_number, position_1, position_2, pair_note, header_format, reference_base_pair, conformation, ai_code, tertiary_type, header_extra, strength, group_code, GC, CG, UA, AU, GU, UG, AA, AC, AG, CA, CC, CU, GA, GG, UC, UU, gap, Seq, predominant_types, covarying_types

9,604 rows

conservation_diagrams

molecule_code, classifier, category, format, relative_path, raw_filename, url

114 rows

model_diagram_files

diagram_id, format, relative_path, url

89 rows

model_diagrams

diagram_id, molecule, diagram_type, descriptor, parse_style

46 rows

nucleotide_frequency_tables

molecule, category, subtype, version, is_latest, is_latest_in_format, is_supporting, format, relative_path, raw_filename, url

78 rows

structures

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

1,983 rows

... and 6 hidden tables

Views

Download SQLite DB: crw2.db 4.6 MB