crw2: basepair_combined: 14 rows where conformation = "tHS", molecule = "23S" and strength = "Strong" 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.

14 rows where conformation = "tHS", molecule = "23S" and strength = "Strong" 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	UU	gap	sequences	predominant_types	covarying_types	Xch	Ych	PE	PES	Cov1	Cov3	C1_C3	WC	WCGU	XCons	YCons	DfDel	PNuc
23S	59	1528	1543	A:G	tHS	3°: base pair	Strong	T	5.7	7.2	4.7	11.2	0.6	1.0	0.9	0.2	21.4	0.2	0.1	0.1		1.5	44.9	859	GC,CG,UA,AU,AG	GC,UA,AG,CU	18	21	12	0.61	0.31	0.58	0.89	0.52	0.55	-0.74	-0.81	0.0	0.45
23S	59	1528	1543	A:G	tHS	3°: base pair	Strong	3	10.1	12.2	7.5	19.3	1.0	1.0	0.6	0.4	36.2						11.5	483	GC,CG,UA,AU,AG	GC,UA,AG	13	17	12	0.8	0.34	0.61	0.95	0.56	0.58	-0.04	-0.14	0.01	0.68
23S	59	1528	1543	A:G	tHS	3°: base pair	Strong	B	5.3	0.4	12.1		1.1	1.5	1.1	0.8	65.5						12.1	264	GC,UA,AG	GC,UA,AG	5	5	3	0.6	0.78	0.94	1.72	0.2	0.23	0.4	0.35	0.0	0.71
23S	59	1528	1543	A:G	tHS	3°: base pair	Strong	A	10.3	61.5			2.6										25.6	39	GC,CG,GU	GC,CG	2	3	3	1.0	0.8	0.97	1.77	0.97	1.0	0.17	0.03	0.0	0.71
23S	59	1528	1543	A:G	tHS	3°: base pair	Strong	C		3.0	4.0	3.0		4.0	5.0		9.0	2.0		1.0		13.0	56.0	100	CG,UA,AU,UG,AA,AG,CA,UU	AG,CA,UU	5	4	0	0.0	0.35	0.55	0.9	0.23	0.32	-0.68	-0.83	0.1	0.43
23S	59	1528	1543	A:G	tHS	3°: base pair	Strong	E	17.2	18.9	2.2	51.7	0.6	0.6			1.1						7.8	180	GC,CG,UA,AU	GC,CG,UA,AU	6	9	6	0.8	0.94	0.98	1.92	0.98	0.99	0.05	0.14	0.01	0.63
23S	59	1528	1543	A:G	tHS	3°: base pair	Strong	M											0.4				99.7	276			0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	-0.03	-0.06	0.0	0.0
23S	62	1690	1697	A:G	tHS	3°: base pair	Strong	T				0.4	0.4		10.8		53.5	2.9		0.4	0.1	3.9	27.7	836	AA,AG,CA,UU	AG,CA,UU	15	36	10	0.39	0.36	0.83	1.2	0.01	0.01	0.15	-0.16	0.0	0.58
23S	62	1690	1697	A:G	tHS	3°: base pair	Strong	3					0.7		7.9		80.1	3.1		0.7	0.2	7.2	0.2	458	AA,AG,CA,UU	AG,CA,UU	11	19	7	0.47	0.52	0.91	1.43	0.0	0.01	1.33	1.06	0.0	0.72
23S	62	1690	1697	A:G	tHS	3°: base pair	Strong	B							11.1		74.8	2.3				11.5	0.4	262	AA,AG,CA,UU	AG,CA,UU	5	11	2	0.25	0.55	0.89	1.44	0.0	0.0	1.33	0.9	0.0	0.8
23S	62	1690	1697	A:G	tHS	3°: base pair	Strong	A					4.9				63.4	17.1		4.9	2.4	7.3		41	GU,AG,CA,CU,GA,UU	AG,CA,UU	4	4	4	1.0	0.67	0.88	1.54	0.0	0.05	0.55	0.69	0.0	1.0
23S	62	1690	1697	A:G	tHS	3°: base pair	Strong	C				1.0			46.5		50.5	1.0					1.0	101	AA,AG	AG,CA	1	10	1	0.18	0.02	0.0	0.02	0.01	0.01	1.82	0.84	0.0	0.97
23S	62	1690	1697	A:G	tHS	3°: base pair	Strong	E					0.6		4.5		93.5	0.6		0.6				155	AA,AG	GU,AG,CA	2	4	1	0.33	0.2	0.0	0.2	0.0	0.01	1.84	1.61	0.0	0.59
23S	62	1690	1697	A:G	tHS	3°: base pair	Strong	M				0.7			2.5		10.5	3.2					83.0	277	AA,AG,CA	AG,CA	3	7	2	0.4	0.5	0.81	1.31	0.04	0.04	-0.44	-0.51	0.0	0.15

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)

14 rows where conformation = "tHS", molecule = "23S" and strength = "Strong" sorted by position_1

Advanced export