crw2: basepair_combined: 11 rows where group_code = "A", 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 = "A", 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	GA	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	A		5.6		11.1					83.3							36	CG,AU,AG		1	1	0	0.0	0.0	0.0	0.0	0.17	0.17	1.69	1.5	0.0	0.88
23S	6.1	64	90	A:U	cWW	3°: pseudoknot	Significant	A							100.0									36	AA		0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	2.0	2.0	0.0	0.88
23S	13	239	258	C:G	cWW		Significant	A	5.6	2.8	8.3			77.8				5.6						36	GC,CG,UA,UG,CA	GC,UG,CA	3	3	2	0.67	0.5	0.89	1.39	0.17	0.94	1.28	1.12	0.0	0.88
23S	18	287	353	G:C	cWW		Significant	A	5.6	38.9		27.8		11.1		2.8			5.6	5.6		2.8		36	GC,CG,AU,UG,AC,CC,GA,UU	GC,CG,AU	5	4	3	0.67	0.55	0.72	1.27	0.72	0.83	0.21	0.35	0.0	0.88
23S	33	688	774	U:G	No BP		Significant	A			100.0													37	UA		0	0	0	0.0	0.0	0.0	0.0	1.0	1.0	2.0	2.0	0.0	0.9
23S	38	874	903	G:C	cWW		Significant	A	40.5				45.9			2.7				10.8				37	GC,GU,AC,GA	GU,AC	0	7	0	0.0	0.05	0.0	0.05	0.41	0.86	1.82	0.61	0.0	0.9
23S	42	1035	1120	U:G	cWW		Significant	A						97.3									2.7	37	UG		0	0	0	0.0	0.0	0.0	0.0	0.0	1.0	1.77	2.0	0.02	0.88
23S	51	1348	1598	C:A	cWW	3°: base pair	Significant	A															99.9	41			0	6	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.2	1.0	0.0
23S	61	1667	1993	G:U	tSH		Significant	A					100.0											41	GU		0	0	0	0.0	0.0	0.0	0.0	0.0	1.0	2.0	2.0	0.0	1.0
23S	77	2124	2174	G:C	cWW		Significant	A	100.0															41	GC		0	0	0	0.0	0.0	0.0	0.0	1.0	1.0	2.0	2.0	0.0	1.0
23S	88	2401	2415	U:G	cWW		Significant	A	12.2	70.7				12.2							4.9			41	GC,CG,UG,UC	GC,CG	4	2	1	0.33	0.42	0.83	1.25	0.83	0.95	0.84	1.34	0.0	1.0

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

Advanced export