crw2: basepair_frequency: 47 rows where group_code = "E", 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 = "E", 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
202	202	16S	1	13	21	v4	U:G	No BP		Weak	E		0.1	0.1			98.9											0.8	815	UG
279	279	16S	3	35	549	v4	G:C	cWW		Weak	E	90.8			0.1	7.1						0.1		0.2		0.3	0.2	1.1	904	GC,GU	GC,UU
293	293	16S	3	37	547	v4	U:A	tWS		Weak	E			98.0			0.8				0.1					0.1	0.1	0.9	912	UA
300	300	16S	4	39	403	v4	G:C	cWW		Weak	E	2.4		4.0		1.5		0.8	0.4		0.1	0.1		89.7				1.0	919	GC,UA,GA	AC,GA
377	377	16S	5	54	357	v4	C:G	cWW		Weak	E		99.6				0.2						0.1					0.1	946	CG
384	384	16S	5	56	356	v4	U:A	cWW		Weak	E			99.5				0.2						0.1		0.1		0.1	958	UA
398	398	16S	5	58	354	v4	C:G	cWW		Weak	E		99.6				0.1			0.1					0.1			0.1	960	CG
412	412	16S	6	62	105	v4	U:G	cWW		Weak	E																	100.0	965
440	440	16S	6	68	101	v4	G:A	cWW	3°: base pair	Weak	E		1.5	93.1	2.6		0.3	0.2		0.2	0.2		0.1	0.2	0.1		1.3	0.1	973	UA,AU	CG,UA,AU
951	951	16S	12	292	308	v4	G:C	cWW		Weak	E	0.3			43.2	51.6		0.1	1.3	0.1			0.1	1.5			1.8	0.1	1025	AU,GU	GU,AC
1049	1049	16S	14	342	347	v4	C:G	cWW		Weak	E		100.0																1018	CG
1084	1084	16S	15	375	388	v4	U:G	No BP		Weak	E	0.1	0.2	0.1			98.0							0.1	0.2		0.1	1.3	1026	UG	GC,UG
1119	1119	16S	16	406	436	v4	G:C	cWW		Weak	E																	100.0	1030
1147	1147	16S	16	416	427	v4	G:U	cWW		Weak	E																	100.0	1030
1168	1168	16S	16	419	424	v4	C:G	cWW		Weak	E																	100.0	1030
1427	1427	16S	19.1	571	865	v4	U:A	cWW	3°: pseudoknot	Weak	E			99.6			0.3				0.1								1015	UA
1476	1476	16S	20	584	757	v4	G:U	cWW		Weak	E	0.2				97.7								2.1					1033	GU,GA
1539	1539	16S	21	594	645	v4	U:G	cWW		Weak	E																	100.0	1042
1553	1553	16S	21	597	643	v4	G:C	cWW		Weak	E																	100.0	1042
1609	1609	16S	21	605	633	v4	U:G	cWW		Weak	E																	100.0	1042
1616	1616	16S	21	606	632	v4	G:U	No BP		Weak	E																	100.0	1042
1693	1693	16S	22	658	748	v4	C:G	cWW		Weak	E	0.5	0.8	0.1	82.3	4.8		0.8	2.1	0.6	1.8	0.1	0.8	1.8	0.3	2.8	0.4	0.1	1028	AU,GU,AC,UC	CG,AU,GA,UC
1735	1735	16S	22	666	740	v4	G:U	cWW		Weak	E	1.1		0.1	0.3	6.9		0.1		0.8				90.6	0.1			0.1	1028	GU,GA	AG,GA
1798	1798	16S	23	677	713	v4	U:G	cWW		Weak	E			84.4			8.0	0.4			5.6		0.9			0.7	0.1		1029	UA,UG,CA	UA,CU
1847	1847	16S	23	684	706	v4	U:A	cWW		Weak	E	29.8	0.1	0.1	1.1	68.6							0.1			0.2		0.1	1028	GC,GU	CG,GU,UC
1868	1868	16S	23	690	697	v4	G:U	tSH		Weak	E	0.6			0.4	98.4								0.5	0.1				1032	GU
2043	2043	16S	26	832	854	v4	G:U	cWW		Weak	E	0.9	0.7	0.3	0.5	4.3	0.2	61.3	23.8	2.6	0.1			0.6	0.1	0.7	3.7	0.4	1040	GU,AA,AC,AG,UU	CG,GU,AA,UC
2106	2106	16S	26.1	861	868	v4	G:C	cWW		Weak	E	95.3	0.6		0.6	1.7						0.1				0.1	1.7		1019	GC	GC,CG,UU
2197	2197	16S	28	925	1391	v4	G:U	cWW		Weak	E					99.7									0.1		0.1	0.1	974	GU
2253	2253	16S	28	935	1380	v4	A:U	cWW		Weak	E				99.5				0.1	0.1			0.2					0.1	973	AU
2288	2288	16S	29	942	1341	v4	G:U	cWW		Weak	E	0.3			0.1	99.4											0.1	0.1	975	GU
2344	2344	16S	30	950	1231	v4	U:G	cWW		Weak	E		0.2	0.1			97.6								0.9		0.1	1.0	974	UG
2386	2386	16S	31	960	975	v4	U:A	No BP		Weak	E			0.7			99.0			0.1					0.2				1006	UG
2393	2393	16S	31	961	974	v4	U:A	No BP		Weak	E		0.1	2.4			96.7					0.4			0.1	0.3			1007	UA,UG	UG,CC
2624	2624	16S	34	1052	1206	v4	U:G	cWW		Weak	E		0.2				99.3										0.1	0.4	999	UG
2631	2631	16S	34	1053	1205	v4	G:U	No BP		Weak	E					99.8												0.2	997	GU
2652	2652	16S	34	1058	1199	v4	G:U	cWW		Weak	E					99.2							0.5					0.3	1000	GU
2904	2904	16S	40	1158	1178	v4	C:G	No BP		Weak	E		80.9	0.1			2.7		0.1	0.1	0.8	12.7	0.7		0.2	1.2	0.1	0.5	1019	CG,UG,CC	CG,UC
2911	2911	16S	40	1159	1177	v4	U:G	No BP		Weak	E	0.1	1.6	0.7	0.4		65.6	10.1	2.2	8.0	2.3	0.2	0.2	0.4	5.1	0.3	2.3	0.7	1018	UG,AA,AC,AG,CA,GG,UU	UG,AA,CC
3023	3023	16S	41	1255	1282	v4	G:C	cWW		Weak	E						0.2	0.1										99.7	1027		UG,AA
3191	3191	16S	44	1401	1501	v4	G:C	cWW		Weak	E	99.8							0.1									0.1	860	GC
3324	3324	16S	44	1425	1475	v4	U:G	cWW		Weak	E	8.4	0.9	4.1	25.9	50.5	0.9	0.5	2.3				0.2	0.4		5.5	0.2	0.1	962	GC,UA,AU,GU,AC,UC	CG,GU,AA,UC
3366	3366	16S	44	1435	1466	v4	G:C	cWW		Weak	E	24.1	4.8	0.8	24.7	31.7	8.5	0.1	0.4	0.3	0.1	0.1	0.2	2.6		0.3	0.2	1.1	979	GC,CG,AU,GU,UG,GA	GU,UG,AC,CA
3408	3408	16S	44	1442	1460	v4	G:C	cWW		Weak	E	0.3		0.1				31.0	0.1	0.1				61.3	0.2			6.9	1001	AA,GA	AG,GA
3450	3450	16S	45	1506	1529	v4	U:G	No BP		Weak	E		2.0	0.4			95.8			0.1						0.1		1.4	684	CG,UG
3485	3485	16S	45	1511	1524	v4	G:C	cWW		Weak	E	93.9				4.4			0.4					0.3	0.6			0.4	708	GC,GU
3492	3492	16S	45	1512	1523	v4	U:G	cWW		Weak	E		0.1	0.3			94.4				0.1				0.1	0.3	4.2	0.4	710	UG,UU	UG,CA

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 = "E", molecule = "16S" and strength = "Weak" sorted by position_1

Advanced export