crw2: basepair_combined: 11 rows where group_code = "T", 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 = "T", 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	T		0.4	1.5	2.1			0.8	0.3	66.2					0.1		0.3	28.1	719	AU,AG	UA,AG	12	11	6	0.52	0.28	0.94	1.22	0.06	0.06	0.42	0.29	0.01	0.49
23S	6.1	64	90	A:U	cWW	3°: pseudoknot	Significant	T	7.8	3.0	0.5	13.6	0.1	0.1	23.2	4.6	0.7		0.3	0.3	0.4	0.3		0.5	44.5	740	GC,CG,AU,AA,AC	GC,CG,AA,UU	23	25	11	0.46	0.35	0.62	0.97	0.45	0.46	-0.16	-0.86	0.12	0.39
23S	13	239	258	C:G	cWW		Significant	T	5.7	5.5	22.5	12.1	2.5	21.2	1.4		0.1	4.4	5.9	0.3	0.3	0.2	9.6	4.7	3.3	866	GC,CG,UA,AU,GU,UG,CA,CC,UC,UU	UA,AU,CC,GG	88	82	33	0.39	0.25	0.42	0.67	0.47	0.72	0.25	-0.19	0.01	0.8
23S	18	287	353	G:C	cWW		Significant	T	7.6	3.9	8.3	10.7	4.1	1.8	7.2	0.9	1.8	0.7	1.7	3.1	2.5	4.1	0.8	2.4	38.3	877	GC,CG,UA,AU,GU,AA,CU,GA,GG,UU	GC,CG,UA,AU	70	69	26	0.37	0.39	0.49	0.89	0.49	0.59	-0.88	-0.86	0.01	0.52
23S	33	688	774	U:G	No BP		Significant	T			90.9	1.5	0.1	3.6				0.1					3.3	0.3	0.2	886	UA,UG,UC	UA,AU	4	14	3	0.33	0.17	0.0	0.17	0.93	0.96	1.84	1.42	0.0	0.85
23S	38	874	903	G:C	cWW		Significant	T	29.1	1.5	2.2	2.6	12.9	0.3	0.6	0.3					22.8		0.2	0.5	26.8	859	GC,UA,AU,GU,GA	GC,CG,UA,AU	18	22	10	0.5	0.14	0.0	0.14	0.48	0.67	0.13	-0.62	0.01	0.6
23S	42	1035	1120	U:G	cWW		Significant	T	0.2	0.2	1.5	0.7	0.2	69.2	0.1	0.2					0.1			0.6	26.8	858	UG	GC,AU,UG	9	13	5	0.46	0.23	0.96	1.19	0.04	0.99	0.49	0.39	0.0	0.6
23S	51	1348	1598	C:A	cWW	3°: base pair	Significant	T	29.1		7.8	1.3	0.6	0.5	1.5	0.8	0.1	15.5	0.6	0.2	0.1			0.1	41.5	844	GC,UA,CA	GC,AU,UG,CA	26	35	4	0.13	0.59	0.8	1.39	0.66	0.67	-0.81	-0.5	0.2	0.47
23S	61	1667	1993	G:U	tSH		Significant	T	0.1		1.2	0.6	97.3		0.1						0.1	0.1		0.1	0.2	807	GU	UA,GU	4	6	2	0.4	0.5	0.99	1.49	0.02	0.99	1.81	1.87	0.0	0.77
23S	77	2124	2174	G:C	cWW		Significant	T	67.5		0.2			0.1		0.1							0.2	0.1	31.6	847	GC	GC,UA	3	2	2	0.8	0.29	0.99	1.28	0.99	0.99	0.4	0.41	0.0	0.55
23S	88	2401	2415	U:G	cWW		Significant	T	1.3	15.7	2.4	1.4		45.0			2.1	0.4			0.2		0.4	0.6	30.6	847	CG,UA,UG,AG	GC,AU,UG,CA	30	23	14	0.53	0.13	0.0	0.13	0.3	0.95	-0.33	0.08	0.0	0.56

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 = "T", molecule = "23S" and strength = "Significant" sorted by position_1

Advanced export