crw2: basepair_combined: 7 rows where conformation = "tWW" and molecule = "16S" 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.

7 rows where conformation = "tWW" and molecule = "16S" 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
16S	23.1	722	733	G:G	tWW	3°: base pair	Strong	T	0.2	0.7	3.0	1.6	0.9	0.7	29.5	0.3	5.1	0.4	0.1	0.1	1.3	55.1	0.1	0.2	0.7	7189	UA,AA,AG,GG	AA,CC,GG,UU	166	127	52	0.35	0.68	0.85	1.53	0.06	0.07	0.69	0.8	0.0	0.84
16S	23.1	722	733	G:G	tWW	3°: base pair	Strong	3	0.1		2.1	0.1	0.7	0.1	29.7	0.1	2.4				1.4	63.1			0.1	6134	UA,AA,AG,GG	AA,GG	59	60	38	0.64	0.81	0.93	1.74	0.02	0.03	0.95	0.98	0.0	0.85
16S	23.1	722	733	G:G	tWW	3°: base pair	Strong	B	0.2				0.2	0.1	24.5		2.9				0.5	71.3			0.1	4860	AA,AG,GG	AA,GG	39	43	31	0.76	0.86	0.96	1.82	0.0	0.01	1.13	1.13	0.0	0.83
16S	23.1	722	733	G:G	tWW	3°: base pair	Strong	A					0.8		20.3		0.4					78.4				241	AA,GG	AA,GG	4	6	4	0.8	0.94	0.99	1.93	0.0	0.01	1.26	1.21	0.0	0.91
16S	23.1	722	733	G:G	tWW	3°: base pair	Strong	C						0.6	75.4		1.8					21.6			0.6	167	AA,GG	AA,GG	6	8	6	0.86	0.9	0.98	1.88	0.0	0.01	1.13	1.14	0.0	0.91
16S	23.1	722	733	G:G	tWW	3°: base pair	Strong	E	0.1	0.1	12.2	0.3	3.3	0.1	56.2	0.2	0.7				5.9	20.6			0.3	1033	UA,GU,AA,GA,GG	AA,GG	16	11	3	0.22	0.47	0.77	1.25	0.13	0.16	0.64	0.98	0.0	0.98
16S	23.1	722	733	G:G	tWW	3°: base pair	Strong	M	0.2	5.2	10.2	12.1	1.8	4.4	19.3	1.9	24.0	3.3	0.9	1.0	1.2	6.0	1.1	2.8	4.5	896	CG,UA,AU,UG,AA,AG,CA,GG,UU	UA,GU,AG,CC	101	59	8	0.1	0.18	0.0	0.18	0.29	0.35	0.16	0.15	0.02	0.74

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)

7 rows where conformation = "tWW" and molecule = "16S" sorted by position_1

Advanced export