crw2: basepair_frequency: 47 rows where group_code = "A", molecule = "16S" and strength = "Weak" 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).

47 rows where group_code = "A", molecule = "16S" and strength = "Weak" sorted by position_1

descending

Link	rowid	molecule	helix_number	position_1 ▼	position_2	header_format	reference_base_pair	conformation	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
200	200	16S	1	13	21	v4	U:G	No BP		Weak	A						100.0												154	UG
277	277	16S	3	35	549	v4	G:C	cWW		Weak	A	3.8	1.1			94.0							0.5					0.5	184	GC,GU	CG,GU
291	291	16S	3	37	547	v4	U:A	tWS		Weak	A			100.0															183	UA
298	298	16S	4	39	403	v4	G:C	cWW		Weak	A			99.0			1.0												193	UA
375	375	16S	5	54	357	v4	C:G	cWW		Weak	A		97.5								2.5								201	CG,CA
382	382	16S	5	56	356	v4	U:A	cWW		Weak	A			97.5														2.5	201	UA
396	396	16S	5	58	354	v4	C:G	cWW		Weak	A	19.0	76.5				0.5					1.5						2.5	200	GC,CG	GC,CG
410	410	16S	6	62	105	v4	U:G	cWW		Weak	A						100.0												202	UG
438	438	16S	6	68	101	v4	G:A	cWW	3°: base pair	Weak	A	78.9			6.0	0.5	1.0							11.6	0.5			1.5	199	GC,AU,GA	GC,AU,UG
949	949	16S	12	292	308	v4	G:C	cWW		Weak	A	100.0																	229	GC
1047	1047	16S	14	342	347	v4	C:G	cWW		Weak	A	2.2	92.9				0.4											4.5	224	GC,CG	GC,CG
1082	1082	16S	15	375	388	v4	U:G	No BP		Weak	A			2.2			95.6											2.2	228	UA,UG
1117	1117	16S	16	406	436	v4	G:C	cWW		Weak	A	97.7				0.5			0.5			0.5						1.0	218	GC
1145	1145	16S	16	416	427	v4	G:U	cWW		Weak	A																	100.0	237
1166	1166	16S	16	419	424	v4	C:G	cWW		Weak	A																	100.0	237
1425	1425	16S	19.1	571	865	v4	U:A	cWW	3°: pseudoknot	Weak	A			100.0															220	UA
1474	1474	16S	20	584	757	v4	G:U	cWW		Weak	A	1.8			0.5	97.7													219	GU
1537	1537	16S	21	594	645	v4	U:G	cWW		Weak	A		26.0	15.2	3.9		51.5	1.7			1.7								231	CG,UA,AU,UG	AU,UG,CA
1551	1551	16S	21	597	643	v4	G:C	cWW		Weak	A	95.7							3.9									0.4	233	GC,AC
1607	1607	16S	21	605	633	v4	U:G	cWW		Weak	A	30.4	10.4		2.2	7.0	47.8								0.4	0.4		1.3	230	GC,CG,AU,GU,UG	GC,AU,UG
1614	1614	16S	21	606	632	v4	G:U	No BP		Weak	A	5.2			2.2	47.0	4.3						0.4	0.9	3.9	4.3	31.0	0.9	232	GC,AU,GU,UG,GG,UC,UU	GU,UC
1691	1691	16S	22	658	748	v4	C:G	cWW		Weak	A		25.1	8.2							24.7	7.3			33.3	0.5	0.9		219	CG,UA,CA,CC,GG	CA,GG,UU
1733	1733	16S	22	666	740	v4	G:U	cWW		Weak	A	32.0	16.7	0.9	0.9	49.5													222	GC,CG,GU	CG,UA,GU
1796	1796	16S	23	677	713	v4	U:G	cWW		Weak	A		87.5				2.2				0.4		9.9						232	CG,UG,CU
1845	1845	16S	23	684	706	v4	U:A	cWW		Weak	A	85.7				0.9		3.5	10.0										230	GC,AA,AC	GC,AA
1866	1866	16S	23	690	697	v4	G:U	tSH		Weak	A				34.3	65.7													233	AU,GU
2041	2041	16S	26	832	854	v4	G:U	cWW		Weak	A	3.0			2.6	93.0					0.4				0.4		0.4		230	GC,AU,GU	GU,CA
2104	2104	16S	26.1	861	868	v4	G:C	cWW		Weak	A	83.1				16.0			0.4									0.4	231	GC,GU
2195	2195	16S	28	925	1391	v4	G:U	cWW		Weak	A					100.0													177	GU
2251	2251	16S	28	935	1380	v4	A:U	cWW		Weak	A	1.1			98.9														189	AU	GC,AU
2286	2286	16S	29	942	1341	v4	G:U	cWW		Weak	A					100.0													191	GU
2342	2342	16S	30	950	1231	v4	U:G	cWW		Weak	A		0.5				99.5												184	UG
2384	2384	16S	31	960	975	v4	U:A	No BP		Weak	A						100.0												208	UG
2391	2391	16S	31	961	974	v4	U:A	No BP		Weak	A		3.3	3.3			78.5										14.8		209	CG,UA,UG,UU
2622	2622	16S	34	1052	1206	v4	U:G	cWW		Weak	A		1.6				97.8			0.5									186	UG
2629	2629	16S	34	1053	1205	v4	G:U	No BP		Weak	A	1.0			0.5	98.5													197	GU
2650	2650	16S	34	1058	1199	v4	G:U	cWW		Weak	A					100.0													195	GU
2902	2902	16S	40	1158	1178	v4	C:G	No BP		Weak	A		99.5				0.5												195	CG
2909	2909	16S	40	1159	1177	v4	U:G	No BP		Weak	A		53.0				46.0						0.5				0.5		198	CG,UG	CG,UU
3021	3021	16S	41	1255	1282	v4	G:C	cWW		Weak	A	100.0																	207	GC
3189	3189	16S	44	1401	1501	v4	G:C	cWW		Weak	A	100.0																	104	GC
3322	3322	16S	44	1425	1475	v4	U:G	cWW		Weak	A	9.9	19.3	9.9	7.0	1.2	39.2											13.4	171	GC,CG,UA,AU,UG	GC,AU,UG
3364	3364	16S	44	1435	1466	v4	G:C	cWW		Weak	A	96.0				1.2			0.6									2.3	173	GC
3406	3406	16S	44	1442	1460	v4	G:C	cWW		Weak	A	23.7	18.3	3.0	17.2	12.4	19.5							0.6	0.6		0.6	4.2	169	GC,CG,UA,AU,GU,UG	GC,AU,UG
3448	3448	16S	45	1506	1529	v4	U:G	No BP		Weak	A						95.0									5.0			80	UG,UC
3483	3483	16S	45	1511	1524	v4	G:C	cWW		Weak	A	97.5				2.5													80	GC,GU
3490	3490	16S	45	1512	1523	v4	U:G	cWW		Weak	A			4.9			95.1												82	UA,UG

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

47 rows where group_code = "A", molecule = "16S" and strength = "Weak" sorted by position_1

Advanced export