crw2: basepair_combined: 11 rows where group_code = 3, molecule = "23S" 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.

11 rows where group_code = 3, molecule = "23S" 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	3		0.5		1.5					97.5					0.2			0.2	405	AG		2	2	0	0.0	0.0	0.0	0.0	0.02	0.02	1.9	1.86	0.0	0.64
23S	6.1	64	90	A:U	cWW	3°: pseudoknot	Significant	3	14.1	5.1	0.7	22.1		0.2	29.0							0.2			28.4	411	GC,CG,AU,AA	GC,CG,AA	15	11	8	0.61	0.45	0.67	1.12	0.59	0.59	0.89	-0.72	0.19	0.47
23S	13	239	258	C:G	cWW		Significant	3	3.3	8.2	20.3	4.9	1.0	31.6				3.9	9.8		0.2	0.4	13.9	2.1	0.4	512	GC,CG,UA,AU,UG,CA,CC,UC,UU	AU,UG,CC,GA	52	42	18	0.38	0.22	0.47	0.69	0.37	0.7	0.71	0.13	0.0	0.81
23S	18	287	353	G:C	cWW		Significant	3	12.4	6.5	9.4	14.5	6.5	3.1	8.2	1.1	1.5	0.2	2.9	4.8	3.4	6.9	1.0	2.7	14.9	523	GC,CG,UA,AU,GU,UG,AA,CC,CU,GA,GG,UU	GC,CG,UA,AU	52	50	19	0.37	0.4	0.5	0.9	0.5	0.62	-0.35	-0.31	0.02	0.71
23S	33	688	774	U:G	No BP		Significant	3			89.5			5.3									5.0	0.2		524	UA,UG,UC		0	7	0	0.0	0.0	0.0	0.0	0.9	0.95	2.0	1.4	0.0	0.83
23S	38	874	903	G:C	cWW		Significant	3	30.6	2.6	1.2	2.4	21.3		0.4	0.2					39.8				1.4	493	GC,CG,AU,GU,GA	CG,AU,GA	9	16	6	0.48	0.09	0.0	0.09	0.37	0.59	1.42	0.2	0.0	0.77
23S	42	1035	1120	U:G	cWW		Significant	3		0.2	0.2			98.3										0.8	0.4	482	UG		0	1	0	0.0	0.0	0.0	0.0	0.0	0.99	1.93	1.89	0.0	0.76
23S	51	1348	1598	C:A	cWW	3°: base pair	Significant	3	32.1		4.3	0.4	0.6	0.4	0.9			19.7							41.6	468	GC,UA,CA	GC,AU,UG,CA	8	22	2	0.13	0.78	0.9	1.68	0.63	0.65	-0.67	0.12	0.33	0.43
23S	61	1667	1993	G:U	tSH		Significant	3	0.2			0.2	99.3											0.2		430	GU		1	1	0	0.0	0.0	0.0	0.0	0.01	1.0	1.96	1.98	0.0	0.68
23S	77	2124	2174	G:C	cWW		Significant	3	100.0																	437	GC		0	0	0	0.0	0.0	0.0	0.0	1.0	1.0	2.0	2.0	0.0	0.69
23S	88	2401	2415	U:G	cWW		Significant	3	2.3	29.5	1.6	1.6		59.3			4.1						0.5	1.1		437	GC,CG,UG,AG	GC,AU,UG	21	10	8	0.52	0.1	0.0	0.1	0.35	0.94	0.7	1.49	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)

11 rows where group_code = 3, molecule = "23S" and strength = "Significant" sorted by position_1

Advanced export