Base-pair statistics (frequencies and scores together) (view)

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.

21 rows where strength = "Weak" and tertiary_type = "3°: pseudoknot" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: helix_number, position_1, position_2, reference_base_pair, UA, AU, GU, UG, AA, CA, predominant_types, covarying_types, Xch, Ych, PE, PES, Cov1, Cov3, C1_C3, WC, WCGU, XCons, YCons, DfDel

group_code 7

molecule 2

tertiary_type 1

  • 3°: pseudoknot · 21 ✖

strength 1

  • Weak · 21 ✖

conformation 1

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
23S 6.1 66 88 C:G cWW 3°: pseudoknot Weak T 0.1 49.5 1.5 0.5 0.1 0.8 0.1   0.9 0.1 0.3   0.3 0.3 0.3 0.3 44.8 740 CG GC,CG,UA,AU 15 8 3 0.26 0.38 0.94 1.32 0.94 0.95 -0.29 -0.15 0.12 0.39
23S 6.1 66 88 C:G cWW 3°: pseudoknot Weak 3   67.4 1.5     1.5 0.2   0.2 0.2       0.5     28.5 411 CG CG,UA 10 2 1 0.17 0.35 0.96 1.32 0.96 0.98 0.75 0.43 0.19 0.47
23S 6.1 66 88 C:G cWW 3°: pseudoknot Weak B   94.6 1.6     2.3 0.4   0.4         0.8       257 CG,UG CG,UA 2 1 0 0.0 0.29 0.96 1.25 0.96 0.98 1.63 1.86 0.0 0.79
23S 6.1 66 88 C:G cWW 3°: pseudoknot Weak A   94.4 5.6                             36 CG,UA CG,UA 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.69 0.0 0.88
23S 6.1 66 88 C:G cWW 3°: pseudoknot Weak C   92.7 3.1               1.0       2.1   1.0 96 CG,UA,UC CG,UA 2 2 1 0.5 0.5 0.97 1.47 0.97 0.97 1.66 1.51 0.01 0.92
23S 6.1 66 88 C:G cWW 3°: pseudoknot Weak E                   0.8             99.1 118     7 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.25 -0.05 0.45 0.0
23S 6.1 66 88 C:G cWW 3°: pseudoknot Weak M 0.4   0.9 1.7 0.4       2.6   0.4   0.9     0.9 91.7 233 AG UA,GU,AG,CC 3 4 1 0.29 0.39 0.58 0.96 0.37 0.42 -0.48 -0.47 0.02 0.06
16S 19.1 571 865 U:A cWW 3°: pseudoknot Weak T   0.3 98.8 0.1 0.1 0.2 0.1                   0.1 6825 UA CG,UA,GU 15 16 2 0.13 0.41 0.99 1.4 0.99 1.0 1.92 1.89 0.0 0.8
16S 19.1 571 865 U:A cWW 3°: pseudoknot Weak 3     99.7     0.1                       5788 UA   2 0 0 0.0 0.0 0.0 0.0 1.0 1.0 1.98 1.98 0.0 0.81
16S 19.1 571 865 U:A cWW 3°: pseudoknot Weak B     99.7                             4553 UA   2 0 0 0.0 0.0 0.0 0.0 1.0 1.0 1.98 1.98 0.0 0.78
16S 19.1 571 865 U:A cWW 3°: pseudoknot Weak A     100.0                             220 UA   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.83
16S 19.1 571 865 U:A cWW 3°: pseudoknot Weak C     98.8                         0.6 0.6 162 UA   0 1 0 0.0 0.0 0.0 0.0 0.99 0.99 1.94 1.89 0.01 0.89
16S 19.1 571 865 U:A cWW 3°: pseudoknot Weak E     99.6     0.3       0.1               1015 UA   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 1.99 1.97 0.0 0.96
16S 19.1 571 865 U:A cWW 3°: pseudoknot Weak M   2.3 93.0 0.7 0.6 0.8 0.7     0.1   0.1 0.1   0.1 0.2 1.3 881 CG,UA CG,UA,AU 13 15 2 0.14 0.52 0.97 1.49 0.97 0.99 1.63 1.55 0.01 0.75
23S 85.1 2328 2387 A:U cWW 3°: pseudoknot Weak T     0.1 68.4       0.5                 31.0 848 AU UA,AU 1 24 1 0.08 0.2 0.0 0.2 0.99 0.99 0.47 0.74 0.18 0.56
23S 85.1 2328 2387 A:U cWW 3°: pseudoknot Weak 3       99.1       0.9                   437 AU   0 1 0 0.0 0.0 0.0 0.0 0.99 0.99 2.0 1.9 0.0 0.69
23S 85.1 2328 2387 A:U cWW 3°: pseudoknot Weak B       100.0                           241 AU   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.74
23S 85.1 2328 2387 A:U cWW 3°: pseudoknot Weak A       100.0                           41 AU   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 1.0
23S 85.1 2328 2387 A:U cWW 3°: pseudoknot Weak C       100.0                           102 AU   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.99
23S 85.1 2328 2387 A:U cWW 3°: pseudoknot Weak E       97.4       2.6                   155 AU,AC   0 1 0 0.0 0.0 0.0 0.0 0.97 0.97 2.0 1.76 0.0 0.59
23S 85.1 2328 2387 A:U cWW 3°: pseudoknot Weak M     0.3 14.6                         85.1 309 AU UA,AU 1 23 1 0.08 1.0 1.0 2.0 1.0 1.0 -0.33 -0.32 0.61 0.15

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;