crw2: basepair_combined: 13 rows where group_code = "E" 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.

13 rows where group_code = "E" 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	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	Cov3	C1_C3	WC	WCGU	XCons	YCons	DfDel	PNuc
23S	5	53	117	A:G	tHS	3°: base pair	Significant	E				1.7					96.6					0.9			0.9	117	AG		1	1	0	0.0	0.0	0.0	0.0	0.02	0.02	1.84	1.79	0.0	0.44
23S	6.1	64	90	A:U	cWW	3°: pseudoknot	Significant	E			0.8														99.1	118			4	0	0	0.0	0.0	0.0	0.0	1.0	1.0	1.04	-0.05	0.45	0.0
5S	3	78	98			3°: base pair	Significant	E									100.0									298	AG
5S	3	80	96	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
23S	13	239	258	C:G	cWW		Significant	E	0.5		29.0	0.5	1.5	2.5				9.0	24.0		0.5	1.0	25.5	5.5	0.5	200	UA,UG,CA,CC,UC,UU	UA,GU,CC	22	18	7	0.35	0.36	0.55	0.91	0.3	0.34	0.84	0.47	0.0	0.76
23S	18	287	353	G:C	cWW		Significant	E	18.9	1.4	3.3	2.8	9.9		1.9	1.9	2.4		6.1	0.5	3.8	9.9	1.4	0.9	35.0	212	GC,UA,AU,GU,AG,CC,GA,GG	GC,CG,UA,AU	15	19	4	0.23	0.16	0.0	0.16	0.41	0.56	-0.32	-0.54	0.06	0.53
23S	33	688	774	U:G	No BP		Significant	E			88.8			1.0									9.8	0.5		205	UA,UC		0	3	0	0.0	0.0	0.0	0.0	0.89	0.9	2.0	1.42	0.0	0.78
23S	38	874	903	G:C	cWW		Significant	E	2.4	0.9			1.9		0.9						90.6				3.3	212	GC,GA	CG,GA	3	3	3	1.0	0.15	0.0	0.15	0.03	0.05	1.6	1.33	0.0	0.78
23S	42	1035	1120	U:G	cWW		Significant	E		0.5	0.5			96.6										1.9	0.5	206	UG		0	1	0	0.0	0.0	0.0	0.0	0.01	0.98	1.9	1.76	0.0	0.78
23S	51	1348	1598	C:A	cWW	3°: base pair	Significant	E			3.7				2.4										93.9	164	UA,AA		1	11	0	0.0	0.0	0.0	0.0	0.6	0.6	-0.3	0.74	0.63	0.04
23S	61	1667	1993	G:U	tSH		Significant	E				0.7	99.3													153	GU		1	0	0	0.0	0.0	0.0	0.0	0.01	1.0	1.95	2.0	0.0	0.58
23S	77	2124	2174	G:C	cWW		Significant	E	100.0																	155	GC		0	0	0	0.0	0.0	0.0	0.0	1.0	1.0	2.0	2.0	0.0	0.59
23S	88	2401	2415	U:G	cWW		Significant	E	3.2	54.2	4.5	4.5		19.4			11.0							3.2		155	GC,CG,UA,AU,UG,AG,UU	GC,CG,UA,AU	13	8	7	0.67	0.27	0.67	0.93	0.67	0.86	0.43	1.08	0.0	0.59

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)

13 rows where group_code = "E" and strength = "Significant" sorted by position_1

Advanced export