crw2: basepair_frequency: 38 rows where group_code = "A", header_format = "v4" and molecule = "5S" sorted by position

predominant_types: Base-pair types shown in bold in the published table (most frequent).
covarying_types: Base-pair types marked * in the published table (involved in a covariation).
header_format: legacy = entry not yet revised to the v4 layout (no type / conformation).

38 rows where group_code = "A", header_format = "v4" and molecule = "5S" sorted by position_1

descending

Link	rowid	molecule	helix_number	position_1 ▼	position_2	header_format	reference_base_pair	conformation	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
3	3	5S	1	1	119	v4	U:A	cWW	Strong	A	11.4	6.8	13.6	4.5	4.5								2.3			2.3	54.5	44	GC,CG,UA,AU,GU,GA,UU	GC,CG,UA,AU
7	7	5S	1	2	118	v4	G:C	cWW	Strong	A	27.9	16.3		4.7	2.3				2.3								46.5	43	GC,CG,AU,GU,AG	GC,CG,AU
11	11	5S	1	3	117	v4	C:G	cWW	Strong	A	36.4	15.9	4.5	15.9													27.3	44	GC,CG,UA,AU	GC,CG,UA,AU
15	15	5S	1	4	116	v4	C:G	cWW	Strong	A	9.1	20.5	20.5	11.4		20.5										2.3	15.9	44	GC,CG,UA,AU,UG,UU	GC,CG,UA,AU
19	19	5S	1	5	115	v4	U:A	cWW	Strong	A	2.3	13.6	38.6	31.8		6.8				2.3							4.5	44	GC,CG,UA,AU,UG,CA	GC,CG,UA,AU
23	23	5S	1	6	114	v4	G:C	cWW	Strong	A	65.9	15.9		15.9	2.3													44	GC,CG,AU,GU	GC,CG,AU
27	27	5S	1	7	113	v4	G:C	cWW	Strong	A	72.7	15.9		9.1	2.3													44	GC,CG,AU,GU	GC,CG,AU
31	31	5S	1	8	112	v4	C:G	cWW	Strong	A		97.7				2.3												44	CG,UG
35	35	5S	1	9	111	v4	G:U	cWW	Strong	A	38.6			2.3	59.1													44	GC,AU,GU
39	39	5S	1	10	110	v4	G:C	cWW	Strong	A	93.2			2.3													4.5	44	GC,AU	GC,AU
43	43	5S	2	16	68	v4	G:C	cWW	Strong	A	97.7			2.3														44	GC,AU	GC,AU
47	47	5S	2	17	67	v4	C:G	cWW	Strong	A	2.3	81.8	13.6							2.3								44	GC,CG,UA,CA	GC,CG,UA
51	51	5S	2	18	65	v4	G:U	cWW	Strong	A	90.9			4.5	4.5													44	GC,AU,GU	GC,AU
55	55	5S	2	19	64	v4	C:G	cWW	Strong	A	77.3	4.5		9.1		6.8		2.3										44	GC,CG,AU,UG,AC	GC,AU,UG
59	59	5S	2	20	63	v4	G:C	cWW	Strong	A	18.2	45.5	6.8	13.6	9.1	4.5										2.3		44	GC,CG,UA,AU,GU,UG,UU	GC,CG,UA,AU
63	63	5S	2	21	62	v4	G:C	cWW	Strong	A	63.6	11.4	2.3	18.2	2.3						2.3							44	GC,CG,UA,AU,GU,CC	GC,CG,UA,AU
67	67	5S	2	22	61	v4	U:G	cWW	Strong	A	93.2			4.5	2.3													44	GC,AU,GU	GC,AU
71	71	5S	2	23	60	v4	G:C	cWW	Strong	A	65.9		2.3		15.9	2.3		2.3							11.4			44	GC,UA,GU,UG,AC,UC	GC,UA
75	75	5S	2	28	56	v4	C:G	cWW	Strong	A				2.3		2.3				2.3		77.3		2.3		13.6		44	AU,UG,CA,CU,GG,UU	CU,GG
79	79	5S	2	29	55	v4	A:U	cWW	Strong	A	2.3		34.1	63.6														44	GC,UA,AU	GC,UA,AU
83	83	5S	2	30	54	v4	C:G	cWW	Strong	A		88.6	11.4															44	CG,UA	CG,UA
87	87	5S	2	31	51	v4	C:G	cWW	Strong	A		97.7								2.3								44	CG,CA
91	91	5S	2	32	50	v4	U:A	cWW	Strong	A		63.6	34.1						2.3									44	CG,UA,AG	CG,UA
95	95	5S	2	33	49	v4	G:C	cWW	Strong	A	100.0																	44	GC
99	99	5S	2	34	48	v4	A:U	cWW	Strong	A	25.0		47.7	27.3														44	GC,UA,AU	GC,UA,AU
103	103	5S	3	70	106	v4	C:G	cWW	Strong	A		2.3	25.0				18.2								2.3	52.3		44	CG,UA,AA,UC,UU	CG,AA,UU
107	107	5S	3	71	105	v4	C:G	cWW	Strong	A	4.5	2.3	29.5	11.4		20.5			2.3			2.3				27.3		44	GC,CG,UA,AU,UG,AG,CU,UU	GC,CG,UA,AU
111	111	5S	3	72	104	v4	G:A	cWW	Strong	A	27.3	31.8	13.6	9.1	2.3					2.3						13.6		44	GC,CG,UA,AU,GU,CA,UU	GC,CG,UA,AU
115	115	5S	3	73	103	v4	A:U	cWW	Strong	A	15.9	40.9	27.3	2.3		11.4											2.3	44	GC,CG,UA,AU,UG	GC,CG,UA,AU
119	119	5S	3	74	102	v4	U:G	cWW	Strong	A	34.1	18.2	11.4	15.9	6.8	2.3		2.3								9.1		44	GC,CG,UA,AU,GU,UG,AC,UU	GC,CG,UA,AU
139	139	5S	3	79	97	v4	G:C	cWW	Strong	A	13.6	86.4																44	GC,CG	GC,CG
143	143	5S	3	80	96	v4	U:G	cWW	Significant	A						100.0												44	UG
147	147	5S	3	81	95	v4	G:U	cWW	Strong	A	36.4			11.4	52.3													44	GC,AU,GU
151	151	5S	3	82	94	v4	U:A	cWW	Strong	A	40.9	29.5	6.8	22.7														44	GC,CG,UA,AU	GC,CG,UA,AU
155	155	5S	3	83	93	v4	G:C	cWW	Strong	A	13.6	13.6	4.5	54.5	13.6													44	GC,CG,UA,AU,GU	GC,CG,UA,AU
159	159	5S	3	84	92	v4	G:C	cWW	Strong	A	68.2	4.5	6.8	2.3		2.3			2.3								13.6	44	GC,CG,UA,AU,UG,AG	GC,CG,UA,AU
163	163	5S	3	85	91	v4	G:C	cWW	Strong	A	36.4	25.0		11.4	2.3	9.1											15.9	44	GC,CG,AU,GU,UG	GC,CG,AU
167	167	5S	3	86	90	v4	G:C	cWW	Strong	A	11.4	40.9	2.3	6.8		13.6										9.1	15.9	44	GC,CG,UA,AU,UG,UU	GC,CG,UU

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "basepair_frequency" (
   "molecule" TEXT,
   "helix_number" TEXT,
   "position_1" INTEGER,
   "position_2" INTEGER,
   "pair_note" TEXT,
   "header_format" TEXT,
   "reference_base_pair" TEXT,
   "conformation" TEXT,
   "ai_code" TEXT,
   "tertiary_type" TEXT,
   "header_extra" TEXT,
   "strength" TEXT,
   "group_code" TEXT,
   "GC" REAL,
   "CG" REAL,
   "UA" REAL,
   "AU" REAL,
   "GU" REAL,
   "UG" REAL,
   "AA" REAL,
   "AC" REAL,
   "AG" REAL,
   "CA" REAL,
   "CC" REAL,
   "CU" REAL,
   "GA" REAL,
   "GG" REAL,
   "UC" REAL,
   "UU" REAL,
   "gap" REAL,
   "Seq" INTEGER,
   "predominant_types" TEXT,
   "covarying_types" TEXT
);
CREATE INDEX "idx_basepair_frequency_molecule_position_1_position_2"
    ON "basepair_frequency" ("molecule", "position_1", "position_2");

Base-pair frequencies

38 rows where group_code = "A", header_format = "v4" and molecule = "5S" sorted by position_1

Advanced export