crw2: basepair_combined: 28 rows where conformation = "tHS" and tertiary_type = "3°: base pair" 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.

28 rows where conformation = "tHS" and tertiary_type = "3°: base pair" 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	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	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	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	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	5	53	117	A:G	tHS	3°: base pair	Significant	C							6.2		93.8								81	AA,AG		0	2	0	0.0	0.0	0.0	0.0	0.0	0.0	2.0	1.71	0.0	0.79
23S	5	53	117	A:G	tHS	3°: base pair	Significant	E				1.7					96.6					0.9		0.9	117	AG		1	1	0	0.0	0.0	0.0	0.0	0.02	0.02	1.84	1.79	0.0	0.44
23S	5	53	117	A:G	tHS	3°: base pair	Significant	M		0.4	4.7	3.9			0.4	0.9	2.1						0.9	86.6	233	UA,AU,AG	CG,UA,AU	10	7	6	0.71	0.5	0.68	1.18	0.68	0.68	-0.51	-0.56	0.02	0.1
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
23S	66	1803	1814	A:G	tHS	3°: base pair	Weak	T	0.5	0.4	0.6	1.5	20.2	0.1	7.6	2.6	37.5	0.2	0.1	0.1			0.2	28.2	840	GU,AA,AC,AG	UA,GU,AG,CC	9	27	4	0.22	0.61	0.81	1.43	0.04	0.33	-0.16	-0.58	0.02	0.58
23S	66	1803	1814	A:G	tHS	3°: base pair	Weak	3	0.9	0.7	0.2	0.9	37.3		0.2	2.0	55.9		0.2				0.4	1.3	456	GU,AC,AG	UA,GU,AG,CC	6	9	1	0.13	0.88	0.95	1.83	0.03	0.4	0.82	0.69	0.0	0.71
23S	66	1803	1814	A:G	tHS	3°: base pair	Weak	B				0.4			0.4	0.4	98.5							0.4	259	AG		0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	2.0	1.85	0.0	0.79
23S	66	1803	1814	A:G	tHS	3°: base pair	Weak	A					75.6			17.1			2.4				4.9		41	GU,AC,CC,UU	GU,AC	2	1	0	0.0	0.7	0.93	1.63	0.0	0.76	0.92	1.29	0.0	1.0
23S	66	1803	1814	A:G	tHS	3°: base pair	Weak	C				4.0			53.5	11.9	29.7							1.0	101	AU,AA,AC,AG		0	10	0	0.0	0.0	0.0	0.0	0.04	0.04	2.0	0.36	0.01	0.97
23S	66	1803	1814	A:G	tHS	3°: base pair	Weak	E	2.6	1.9	0.6	1.9	89.1			0.6								3.2	156	GC,GU	CG,UA,GU,AC	4	5	1	0.22	0.42	0.95	1.37	0.07	0.99	1.37	1.3	0.0	0.57
23S	66	1803	1814	A:G	tHS	3°: base pair	Weak	M			1.4	1.8		0.4	3.2	0.4	10.6	0.7		0.4				81.3	283	AA,AG	UA,AG,CU	3	8	3	0.55	0.22	0.66	0.88	0.17	0.19	-0.46	-0.57	0.06	0.17

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)

28 rows where conformation = "tHS" and tertiary_type = "3°: base pair" sorted by position_1

Advanced export