crw2: basepair_combined: 8 rows where conformation = "cWW", group_code = "C" and strength = "Significant" 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.

8 rows where conformation = "cWW", group_code = "C" and strength = "Significant" sorted by position_1

descending

molecule	helix_number	position_1 ▼	position_2	reference_base_pair	conformation	tertiary_type	strength	group_code	GC	UA	AU	GU	UG	AA	AC	AG	CA	CU	GA	GG	UC	UU	gap	sequences	predominant_types	covarying_types	Xch	Ych	PE	PES	Cov1	Cov3	C1_C3	WC	WCGU	XCons	YCons	DfDel	PNuc
23S	6.1	64	90	A:U	cWW	3°: pseudoknot	Significant	C			5.2			54.2	34.4	1.0				1.0		1.0	3.1	96	AU,AA,AC	AA,GG,UU	2	8	1	0.2	0.05	0.0	0.05	0.05	0.05	1.57	0.66	0.03	0.9
23S	13	239	258	C:G	cWW		Significant	C	29.0	8.0	5.0	17.0	5.0	3.0			4.0		1.0		12.0	16.0		100	GC,UA,AU,GU,UG,AA,CA,UC,UU	GC,CA,UU	11	19	6	0.4	0.28	0.49	0.77	0.42	0.64	0.48	0.3	0.0	0.97
23S	18	287	353	G:C	cWW		Significant	C	2.0	23.0	12.0	1.0		18.0	2.0	7.0	5.0	2.0	3.0		2.0	4.0	19.0	100	GC,UA,AU,AA,AC,AG,CA,CU,GA,UC,UU	GC,UA,AU	17	16	7	0.42	0.24	0.46	0.7	0.46	0.47	-0.36	-0.25	0.01	0.79
23S	38	874	903	G:C	cWW		Significant	C	91.0		1.0	2.0	2.0		2.0						2.0			100	GC,GU,UG,AC,UC	GC,AU,UG	3	3	2	0.67	0.33	0.94	1.27	0.92	0.96	1.56	1.67	0.0	0.97
23S	42	1035	1120	U:G	cWW		Significant	C		1.0			98.0									1.0		100	UG		0	2	0	0.0	0.0	0.0	0.0	0.01	0.99	2.0	1.84	0.0	0.97
23S	51	1348	1598	C:A	cWW	3°: base pair	Significant	C	96.0		2.0	2.0												100	GC,AU,GU	GC,AU	2	3	2	0.8	0.5	0.98	1.48	0.98	1.0	1.86	1.76	0.0	0.97
23S	77	2124	2174	G:C	cWW		Significant	C	99.0						1.0									101	GC		1	0	0	0.0	0.0	0.0	0.0	0.99	0.99	1.92	2.0	0.0	0.98
23S	88	2401	2415	U:G	cWW		Significant	C		2.0			93.1				3.0		1.0		1.0			101	UA,UG,CA	UG,CA	3	4	2	0.57	0.43	0.96	1.39	0.02	0.95	1.73	1.6	0.0	0.98

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)

8 rows where conformation = "cWW", group_code = "C" and strength = "Significant" sorted by position_1

Advanced export