crw2: basepair_frequency: 42 rows where group_code = "E" 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).

42 rows where group_code = "E" and molecule = "5S" sorted by position_1

descending

Link	rowid	molecule	helix_number	position_1 ▼	position_2	pair_note	header_format	reference_base_pair	conformation	ai_code	tertiary_type	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
4	4	5S	1	1	119		v4	U:A	cWW			Strong	E																	100.0	1
8	8	5S	1	2	118		v4	G:C	cWW			Strong	E																	100.0	1
12	12	5S	1	3	117		v4	C:G	cWW			Strong	E	49.7	0.3	0.7	46.2	1.7		0.3	1.0										292	GC,AU	GC,CG,UA,AU
16	16	5S	1	4	116		v4	C:G	cWW			Strong	E	15.1	35.4	10.0	1.7	10.7	9.6		0.3	0.3					1.7		14.4	0.7	291	GC,CG,UA,GU,UG,UU	GC,CG,UU
20	20	5S	1	5	115		v4	U:A	cWW			Strong	E	14.3	46.8	13.3	18.1	0.7	4.4	0.3			0.7				0.3		0.3	0.7	293	GC,CG,UA,AU,UG	GC,CG,UA,AU
24	24	5S	1	6	114		v4	G:C	cWW			Strong	E	4.1	11.9	69.0	12.6		0.3	0.3	0.7							0.3	0.3	0.3	294	GC,CG,UA,AU	GC,CG,UA,AU
28	28	5S	1	7	113		v4	G:C	cWW			Strong	E	25.9	0.3	8.8	63.9						0.3			0.3				0.3	294	GC,UA,AU	GC,CG,UA,AU
32	32	5S	1	8	112		v4	C:G	cWW			Strong	E	3.4	94.9			0.3	0.7					0.3			0.3				295	GC,CG	GC,CG
36	36	5S	1	9	111		v4	G:U	cWW			Strong	E	24.1	0.7	0.3	1.0	72.1			0.3					1.0		0.3			294	GC,GU	CG,UA,GU,AC
40	40	5S	1	10	110		v4	G:C	cWW			Strong	E	55.3	1.0	5.4	26.8	8.5			2.0		0.3					0.3	0.3		295	GC,UA,AU,GU,AC	GC,CG,UA,AU
44	44	5S	2	16	68		v4	G:C	cWW			Strong	E	22.8	65.3	11.9															294	GC,CG,UA	GC,CG,UA
48	48	5S	2	17	67		v4	C:G	cWW			Strong	E	16.6	61.0	13.2	6.8		1.0				0.7				0.7				295	GC,CG,UA,AU	GC,CG,UA,AU
52	52	5S	2	18	65		v4	G:U	cWW			Strong	E	9.8	7.1	7.5	73.2	0.3	0.3	0.7	0.7			0.3							295	GC,CG,UA,AU	GC,CG,UA,AU
56	56	5S	2	19	64		v4	C:G	cWW			Strong	E	15.0	49.8	14.7	16.4	1.0			0.3	0.3	1.0	1.0			0.3				293	GC,CG,UA,AU	GC,CG,UA,AU
60	60	5S	2	20	63		v4	G:C	cWW			Strong	E	45.1	34.8	8.9	7.2	1.7	0.3		1.7							0.3			293	GC,CG,UA,AU	GC,CG,UA,AU
64	64	5S	2	21	62		v4	G:C	cWW			Strong	E	15.0	32.3	25.9	17.3	1.7	6.1			0.3	0.7		0.3		0.3				294	GC,CG,UA,AU,UG	GC,CG,UA,AU
68	68	5S	2	22	61		v4	U:G	cWW			Strong	E	12.6	18.7	50.7	11.9	0.7	3.7		0.3	0.7		0.3				0.3			294	GC,CG,UA,AU,UG	GC,CG,UA,AU
72	72	5S	2	23	60		v4	G:C	cWW			Strong	E	78.0	0.3		1.7	0.7	0.3		2.7	0.3		0.7	0.3	0.3		13.5	0.3	0.7	296	GC,AC,UC	GC,CG,AU
76	76	5S	2	28	56		v4	C:G	cWW			Strong	E	0.3				0.7	1.0		0.7		0.3	4.7	75.5			14.8	1.7	0.3	298	CC,CU,UC	CU,UC
80	80	5S	2	29	55		v4	A:U	cWW			Strong	E	12.1		6.7	80.2	0.3			0.3									0.3	298	GC,UA,AU	GC,UA,AU
84	84	5S	2	30	54		v4	C:G	cWW			Strong	E	5.7	91.9	1.7	0.3										0.3				298	GC,CG	GC,CG,UA,AU
88	88	5S	2	31	51		v4	C:G	cWW			Strong	E	10.7	81.5	4.0	0.7	0.3	0.3	0.3				0.3	1.7						298	GC,CG,UA	GC,CG,UA,AU
92	92	5S	2	32	50		v4	U:A	cWW			Strong	E	70.4	16.5	2.7	10.1		0.3												297	GC,CG,UA,AU	GC,CG,UA,AU
96	96	5S	2	33	49		v4	G:C	cWW			Strong	E	56.7	33.6	5.0	2.3		2.0								0.3				298	GC,CG,UA,AU,UG	GC,CG,UA,AU
100	100	5S	2	34	48		v4	A:U	cWW			Strong	E	4.4		31.5	63.4											0.3		0.3	298	GC,UA,AU	GC,UA,AU
104	104	5S	3	70	106		v4	C:G	cWW			Strong	E	9.4	84.5	3.4	2.0		0.7												297	GC,CG,UA,AU	GC,CG,UA,AU
108	108	5S	3	71	105		v4	C:G	cWW			Strong	E	17.9	56.4	13.5	3.7	2.0	6.4												296	GC,CG,UA,AU,GU,UG	GC,CG,UA,AU
112	112	5S	3	72	104		v4	G:A	cWW			Strong	E	12.1	27.2	30.2	18.5	1.7	9.7					0.3					0.3		298	GC,CG,UA,AU,UG	GC,CG,UA,AU
116	116	5S	3	73	103		v4	A:U	cWW			Strong	E	63.0	5.7	2.0	26.9	2.0	0.3												297	GC,CG,UA,AU,GU	GC,CG,UA,AU
120	120	5S	3	74	102		v4	U:G	cWW			Strong	E	72.5	4.0	0.3	3.0	0.7	0.3		17.4				1.0				0.7		298	GC,CG,AU,AC	GC,CG,UA,AU
124	124	5S	3	75	101	Tertiary	legacy			B	3°: base pair	Strong	E				57.7			2.7	20.8	18.8									298	AU,AA,AC,AG
128	128	5S	3	76	100	Tertiary	legacy			B	3°: base pair	Strong	E													99.7	0.3				298	GA
132	132	5S	3	77	99	Tertiary	legacy			B	3°: base pair	Strong	E			99.7			0.3												298	UA
136	136	5S	3	78	98	Tertiary	legacy			B	3°: base pair	Significant	E									100.0									298	AG
140	140	5S	3	79	97		v4	G:C	cWW			Strong	E	16.1	80.9	2.7					0.3										298	GC,CG,UA	GC,CG,UA
144	144	5S	3	80	96		v4	U:G	cWW			Significant	E	0.7	14.8			0.3	80.9						0.3			0.3	2.7		298	CG,UG,UU	GC,UG,CU
148	148	5S	3	81	95		v4	G:U	cWW			Strong	E	22.1	3.0	6.4	26.8	4.4			6.0								31.2		298	GC,CG,UA,AU,GU,AC,UU	GC,CG,UU
152	152	5S	3	82	94		v4	U:A	cWW			Strong	E	47.1	21.5	15.2	12.5	2.4	0.7			0.3		0.3							297	GC,CG,UA,AU,GU	GC,CG,UA,AU
156	156	5S	3	83	93		v4	G:C	cWW			Strong	E	86.6	5.0	0.3	6.0	1.0						0.3			0.3			0.3	298	GC,CG,AU	GC,CG,UA,AU
160	160	5S	3	84	92		v4	G:C	cWW			Strong	E		0.3	1.3	10.1	0.7		0.7	1.7	29.9			0.3	51.0	4.0				298	AU,AG,GA,GG	AG,CU,GA
164	164	5S	3	85	91		v4	G:C	cWW			Strong	E	88.9	6.4	0.7	1.0	2.0	0.3		0.3							0.3			298	GC,CG,GU	GC,CG,UA,AU
168	168	5S	3	86	90		v4	G:C	cWW			Strong	E	94.0	1.0		5.0														298	GC,AU	GC,CG,AU

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

42 rows where group_code = "E" and molecule = "5S" sorted by position_1

Advanced export