crw2: basepair_combined: 13 rows where group_code = "B" 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 = "B" 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	B									100.0									252	AG		0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	2.0	2.0	0.0	0.77
23S	6.1	64	90	A:U	cWW	3°: pseudoknot	Significant	B	22.6	8.2	0.8	35.4		0.4	32.3							0.4				257	GC,CG,AU,AA	GC,CG,UA,AU	11	11	8	0.73	0.49	0.67	1.16	0.67	0.67	0.76	0.15	0.0	0.79
5S	3	78	98			3°: base pair	Significant	B			0.3	1.3			10.6	0.7	85.8				0.3	0.7			0.3	302	AA,AG	AG,GA
5S	3	80	96	U:G	cWW		Significant	B	0.3	3.6	0.3			94.7								0.7		0.3		302	CG,UG	GC,UG
23S	13	239	258	C:G	cWW		Significant	B	5.1	14.9	15.6	8.7	0.7	46.7					0.7				7.2		0.4	276	GC,CG,UA,AU,UG,UC	GC,AU,UG	27	21	9	0.38	0.26	0.61	0.87	0.44	0.92	0.67	0.41	0.0	0.84
23S	18	287	353	G:C	cWW		Significant	B	8.4	6.2	15.3	21.8	4.7	4.4	14.2	0.4	1.1	0.4		8.7	2.9	5.5	0.7	4.0	1.5	275	GC,CG,UA,AU,GU,UG,AA,CU,GA,GG,UU	GC,CG,UA,AU	32	27	12	0.41	0.39	0.52	0.91	0.52	0.62	0.08	0.07	0.01	0.83
23S	33	688	774	U:G	No BP		Significant	B			88.7			9.2									2.1			282	UA,UG,UC		0	4	0	0.0	0.0	0.0	0.0	0.89	0.98	2.0	1.41	0.0	0.86
23S	38	874	903	G:C	cWW		Significant	B	53.7	4.5	2.5	4.9	34.4													244	GC,CG,UA,AU,GU	GC,CG,UA,AU	6	6	3	0.5	0.26	0.66	0.91	0.66	1.0	1.29	0.66	0.0	0.75
23S	42	1035	1120	U:G	cWW		Significant	B						100.0												239	UG		0	0	0	0.0	0.0	0.0	0.0	0.0	1.0	2.0	2.0	0.0	0.73
23S	51	1348	1598	C:A	cWW	3°: base pair	Significant	B	57.0		5.3	0.8	1.1	0.8				35.0								263	GC,UA,CA	GC,AU,UG,CA	7	5	2	0.33	0.85	0.94	1.78	0.63	0.65	0.71	0.81	0.0	0.81
23S	61	1667	1993	G:U	tSH		Significant	B	0.4				99.2											0.4		236	GU		0	1	0	0.0	0.0	0.0	0.0	0.0	1.0	1.96	1.96	0.0	0.72
23S	77	2124	2174	G:C	cWW		Significant	B	100.0																	241	GC		0	0	0	0.0	0.0	0.0	0.0	1.0	1.0	2.0	2.0	0.0	0.74
23S	88	2401	2415	U:G	cWW		Significant	B		6.6				92.9			0.4									241	CG,UG		4	0	0	0.0	0.0	0.0	0.0	0.07	1.0	1.61	1.95	0.0	0.74

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 = "B" and strength = "Significant" sorted by position_1

Advanced export