crw2: basepair_combined: 12 rows where conformation = "No BP", group_code = 3 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.

12 rows where conformation = "No BP", group_code = 3 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	GG	UC	UU	gap	sequences	predominant_types	covarying_types	Xch	Ych	PE	PES	Cov1	Cov3	C1_C3	WC	WCGU	XCons	YCons	DfDel	PNuc
16S	20	582	758	C:C	No BP	3°: base pair	Strong	3	0.1	8.9	2.3			57.7		0.1		0.1	12.3	0.6			17.5	0.3		5946	CG,UA,UG,CC,UC	UG,CC	56	55	17	0.31	0.29	0.7	0.99	0.11	0.69	1.2	0.89	0.0	0.83
16S	34	1064	1192	G:C	No BP		Strong	3	79.8		0.4		1.8	0.2		0.1	0.1			15.9	0.1	0.4	0.8	0.2	0.1	5606	GC,CU	GC,UA,AG,CU	9	32	6	0.29	0.82	0.96	1.78	0.8	0.82	1.23	1.21	0.0	0.78
23S	55	1420	1578	A:U	No BP		Strong	3	8.1	18.8	9.1	10.5	1.0	0.4		0.2	0.8	0.4		1.2				39.5	9.8	484	GC,CG,UA,AU,UU	GC,CG,UU	26	22	11	0.46	0.53	0.74	1.27	0.52	0.53	-0.18	-0.05	0.02	0.69
23S	59	1527	1544	G:A	No BP	3°: base pair	Strong	3	2.9	32.6	4.7	0.4	13.4		0.8		0.2				33.8	0.2		0.4	10.4	485	GC,CG,UA,GU,GA	CG,AU,GA	15	10	6	0.48	0.59	0.75	1.34	0.45	0.6	0.12	-0.1	0.0	0.69
23S	71	1935	1962	G:C	No BP		Strong	3	56.9	39.9			2.5	0.5		0.2										436	GC,CG,GU	GC,CG	4	3	2	0.57	0.93	0.97	1.89	0.97	1.0	0.97	0.88	0.0	0.69
23S	76.1	2112	2169	G:A	No BP	3°: pseudoknot	Strong	3	0.2			2.1	0.9				20.1				76.7					437	AU,AG,GA	AG,GA	8	8	7	0.88	0.86	0.97	1.83	0.02	0.03	1.24	1.07	0.0	0.69
23S	76.1	2113	2170	U:A	No BP	3°: pseudoknot	Strong	3		27.5	66.8			0.9				2.5			2.1			0.2		437	CG,UA,CA,GA	CG,UA	11	10	7	0.67	0.83	0.94	1.77	0.94	0.95	0.98	1.11	0.0	0.69
23S	76.1	2117	2172	A:U	No BP	3°: pseudoknot	Strong	3	8.9			88.8	0.2					0.7		0.5	0.9					437	GC,AU	GC,AU,CA	5	4	2	0.44	0.86	0.98	1.84	0.98	0.98	1.44	1.45	0.0	0.69
23S	84	2296	2322	U:A	No BP		Strong	3			92.9					0.2		0.2			0.9		5.0	0.7		437	UA,UC	UA,AC	1	5	0	0.0	0.03	0.0	0.03	0.93	0.93	1.88	1.64	0.0	0.69
23S	94	2637	2781	U:A	No BP		Strong	3	1.1	20.3	71.0	0.8		1.1	0.3	0.3		1.8	1.1	0.3	0.3		1.3	0.5		379	CG,UA	GC,CG,UA,AU	10	15	7	0.56	0.76	0.93	1.7	0.93	0.94	1.02	0.92	0.0	0.6
23S	98	2796	2800	U:A	No BP		Strong	3	3.1	1.0	7.0	1.0		0.8				1.6						0.3	85.2	384	GC,UA	GC,CG,UA,AU	7	7	3	0.43	0.67	0.82	1.49	0.82	0.88	-0.56	-0.55	0.0	0.09
23S	101	2849	2866	U:U	No BP	3°: base pair	Strong	3			0.3		2.0	2.6			0.3	0.3		0.9	0.6	30.4	0.3	59.4	3.2	352	GU,UG,GG,UU	CA,GG,UU	16	12	7	0.5	0.82	0.93	1.75	0.0	0.05	0.82	0.7	0.02	0.54

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)

12 rows where conformation = "No BP", group_code = 3 and strength = "Strong" sorted by position_1

Advanced export