crw2: basepair_combined: 15 rows where conformation = "No BP", group_code = 3 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).
sequences: Number of sequences in the group.

15 rows where conformation = "No BP", group_code = 3 and strength = "Weak" sorted by position_1

descending

molecule	helix_number	position_1 ▼	position_2	reference_base_pair	conformation	strength	group_code	GC	CG	UA	AU	GU	UG	AA	AC	AG	CA	CC	CU	GA	GG	UC	UU	gap	sequences	predominant_types	covarying_types	Xch	Ych	PE	PES	Cov1	C1_C3	WC	WCGU	XCons	YCons	DfDel	PNuc
16S	1	13	21	U:G	No BP	Weak	3		0.1	0.2			99.0			0.1					0.1		0.1	0.4	3097	UG		4	7	1	0.18	0.05	0.05	0.0	1.0	1.93	1.91	0.0	0.43
16S	15	375	388	U:G	No BP	Weak	3		0.1	0.4			98.5			0.1						0.1	0.4	0.3	5867	UG		3	21	1	0.08	0.01	0.01	0.0	0.99	1.96	1.88	0.0	0.81
16S	21	606	632	G:U	No BP	Weak	3	2.0	0.8	0.8	1.9	56.4	1.6	0.3	0.1	0.4		0.4	0.3	2.4	9.7	1.5	2.8	18.4	6068	GC,GU,GA,GG,UU	GU,UG,AA,CC	67	128	12	0.12	0.1	0.1	0.07	0.78	0.34	0.02	0.01	0.69
23S	33	687	775	C:G	No BP	Weak	3		99.0								0.2	0.2			0.4			0.2	524	CG		2	1	0	0.0	0.0	0.0	0.99	0.99	1.96	1.94	0.0	0.83
23S	34	703	729	U:G	No BP	Weak	3		22.5				77.3				0.2								524	CG,UG	UG,CA	20	0	0	0.0	0.01	0.01	0.23	1.0	1.23	1.98	0.0	0.83
16S	31	960	975	U:A	No BP	Weak	3			72.2			27.5											0.1	5561	UA,UG		1	14	0	0.0	0.0	0.0	0.72	1.0	1.97	1.14	0.0	0.77
16S	31	961	974	U:A	No BP	Weak	3	0.1	0.1	68.1			20.8					0.2				8.9	1.5	0.3	5546	UA,UG,UC	UA,CC	4	37	0	0.0	0.01	0.01	0.69	0.89	1.94	0.72	0.0	0.77
16S	34	1053	1205	G:U	No BP	Weak	3	3.0			0.1	96.4							0.2					0.3	5581	GC,GU		2	13	0	0.0	0.01	0.01	0.03	1.0	1.95	1.77	0.0	0.78
16S	40	1158	1178	C:G	No BP	Weak	3		96.4				0.5				0.2	2.2	0.1			0.2		0.2	5825	CG,CC	CG,UC	7	9	1	0.12	0.06	0.06	0.97	0.97	1.91	1.77	0.0	0.81
16S	40	1159	1177	U:G	No BP	Weak	3		6.6	0.2	0.1		87.0	1.8	0.4	1.8	0.4		0.1	0.1	0.9	0.1	0.4	0.3	5822	CG,UG	UG,AA,CU	65	16	5	0.12	0.14	0.14	0.07	0.94	1.29	1.71	0.0	0.81
16S	45	1506	1529	U:G	No BP	Weak	3		0.9	0.3			96.7			0.1		0.1			0.2	0.7	0.1	0.9	1484	UG	UG,CC	6	8	0	0.0	0.03	0.03	0.01	0.99	1.88	1.8	0.0	0.2
23S	66	1799	1820	G:U	No BP	Weak	3	40.0				58.3			0.2									1.5	458	GC,GU	GU,AC	0	4	0	0.0	0.01	0.01	0.41	1.0	1.83	0.9	0.0	0.72
23S	69	1911	1919	U:A	No BP	Weak	3			98.6							0.9						0.2	0.2	440	UA		2	0	0	0.0	0.0	0.0	0.99	0.99	1.9	1.98	0.0	0.7
23S	74	2075	2434	U:A	No BP	Weak	3			99.3													0.7		437	UA		0	1	0	0.0	0.0	0.0	0.99	0.99	2.0	1.94	0.0	0.69
23S	80	2249	2255	U:G	No BP	Weak	3						99.1								0.7			0.2	434	UG		1	0	0	0.0	0.0	0.0	0.0	0.99	1.94	1.97	0.0	0.69

Advanced export

JSON shape: default, array, newline-delimited

CREATE VIEW basepair_combined as
select f.molecule, f.helix_number, f.position_1, f.position_2,
       f.reference_base_pair, f.conformation, f.tertiary_type, f.strength, f.group_code,
       f.GC, f.CG, f.UA, f.AU, f.GU, f.UG, f.AA, f.AC, f.AG, f.CA, f.CC, f.CU, f.GA, f.GG, f.UC, f.UU, f.gap, f.Seq as sequences,
       f.predominant_types, f.covarying_types,
       s.Xch, s.Ych, s.PE, s.PES, s.Cov1, s.Cov3, s."C1+C3" as C1_C3,
       s.WC, s.WCGU, s.XCons, s.YCons, s.DfDel, s.PNuc
from basepair_frequency f
left join basepair_collective_score s
  on s.molecule = f.molecule and s.position_1 = f.position_1
 and s.position_2 = f.position_2 and s.group_code = f.group_code;

Base-pair statistics (frequencies and scores together) (view)

15 rows where conformation = "No BP", group_code = 3 and strength = "Weak" sorted by position_1

Advanced export