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.

61 rows where group_code = "C", molecule = "23S" and strength = "Weak" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: reference_base_pair, GC, CG, UA, AU, GU, UG, AA, AC, AG, CA, CC, CU, GA, GG, UC, UU, gap, sequences, covarying_types, Xch, Ych, PE, PES, Cov1, Cov3, C1_C3, WCGU, DfDel, PNuc

conformation 3

tertiary_type 2

strength 1

  • Weak · 61 ✖

molecule 1

  • 23S · 61 ✖

group_code 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 1 8 2895 C:G cWW   Weak C 2.3 6.8 56.8 2.3   2.3 9.1     20.5               44 GC,CG,UA,AU,UG,AA,CA GC,CG,UA,AU 4 4 1 0.25 0.26 0.68 0.94 0.68 0.7 0.57 1.32 0.0 0.43
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 10 158 168 U:G cWW   Weak C 1.0   11.1 4.0   41.4 7.1 2.0 14.1 5.1         2.0 1.0 11.1 99 UA,AU,UG,AA,AC,AG,CA,UC GC,UG,AA 6 13 3 0.32 0.17 0.0 0.17 0.18 0.65 0.17 0.32 0.07 0.85
23S 16 274 363 C:G cWW   Weak C 1.0 1.0 2.0       2.0 1.0   1.0           1.0 91.0 100 UA,AA GC,CG,UA 5 2 0 0.0 0.43 0.56 0.98 0.44 0.44 -0.85 -0.64 0.32 0.09
23S 18 281 359 C:G cWW   Weak C 4.0 1.0 6.1 17.2 1.0 2.0 2.0 1.0   2.0     3.0 1.0 2.0 9.1 48.3 99 GC,UA,AU,UG,AA,CA,GA,UC,UU GC,CG,UA,AU 14 9 3 0.26 0.32 0.55 0.87 0.55 0.61 -0.8 -0.62 0.05 0.49
23S 18 284 356 U:G cWW   Weak C 1.0 4.0 9.1 11.1 2.0 10.1 12.1 5.1 2.0 3.0 2.0   2.0 2.0 4.0 7.1 23.2 99 CG,UA,AU,GU,UG,AA,AC,AG,CA,CC,GA,GG,UC,UU GU,UG,AA,CC 22 16 4 0.21 0.22 0.34 0.56 0.33 0.49 -0.48 -0.68 0.01 0.74
23S 18 293 347 U:A cWW   Weak C   1.0 40.0 8.0     9.0 2.0 1.0 11.0   1.0 3.0 1.0   3.0 20.0 100 UA,AU,AA,AC,CA,GA,UU UA,AU,GG 17 10 5 0.37 0.23 0.61 0.84 0.61 0.61 0.12 0.16 0.14 0.78
23S 20 327 335 G:C cWW   Weak C 96.0     1.0                         3.0 100 GC GC,AU 0 0 0 0.0 1.0 1.0 2.0 1.0 1.0 1.74 1.67 0.01 0.94
23S 21 378 396 C:G cWW   Weak C   4.0   3.0   91.0     2.0                 100 CG,AU,UG,AG AU,UG 3 1 1 0.5 0.33 0.94 1.27 0.07 0.98 1.47 1.81 0.0 0.97
23S 21 382 392 A:U cWW   Weak C       40.0 57.0     2.0                 1.0 100 AU,GU,AC GU,AC 10 0 0 0.0 0.05 0.0 0.05 0.4 0.98 0.93 1.76 0.0 0.96
23S 25 538 555 A:G cWW 3°: base pair Weak C       1.0     5.0   94.0                 100 AA,AG   0 2 0 0.0 0.0 0.0 0.0 0.01 0.01 2.0 1.63 0.0 0.97
23S 25.1 564 577 C:G cWW   Weak C   100.0                               100 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.97
23S 27 600 657 G:U cWW   Weak C       2.0 98.0                         100 AU,GU   1 0 0 0.0 0.0 0.0 0.0 0.02 1.0 1.86 2.0 0.0 0.97
23S 31 641 647 U:G cWW   Weak C   2.0 8.0     86.0           2.0       2.0   100 CG,UA,UG,CU,UU UG,CU 2 7 1 0.22 0.14 0.0 0.14 0.1 0.96 1.76 1.36 0.0 0.97
23S 32 671 809 C:G cWW   Weak C   98.0                             2.0 100 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 1.82 0.02 0.95
23S 33 687 775 C:G No BP   Weak C   95.0             2.0     3.0           100 CG,AG,CU   1 2 0 0.0 0.0 0.0 0.0 0.95 0.95 1.86 1.81 0.0 0.97
23S 33 695 767 G:U cWW   Weak C     2.0 1.0 96.0                     1.0   100 UA,GU UA,GU 3 1 1 0.5 0.5 0.98 1.48 0.03 0.99 1.73 1.86 0.0 0.97
23S 34 703 729 U:G No BP   Weak C           100.0                       100 UG   0 0 0 0.0 0.0 0.0 0.0 0.0 1.0 2.0 2.0 0.0 0.97
23S 34 707 724 G:U cWW   Weak C 4.0     7.0 87.0     1.0               1.0   100 GC,AU,GU GU,AC 5 1 0 0.0 0.08 0.0 0.08 0.11 0.98 1.52 1.71 0.0 0.97
23S 37 826 831 U:G cWW   Weak C     1.0     96.0               1.0     2.0 100 UG   1 0 0 0.0 0.0 0.0 0.0 0.01 0.99 1.92 1.74 0.02 0.95
23S 42 1051 1108 G:U cWW   Weak C       83.0 14.0       1.0               2.0 100 AU,GU   2 1 0 0.0 0.0 0.0 0.0 0.85 0.99 1.37 1.74 0.02 0.95
23S 46 1215 1234 G:U cWW   Weak C       2.0 96.0                     2.0   100 AU,GU,UU   3 0 0 0.0 0.0 0.0 0.0 0.02 0.98 1.72 2.0 0.0 0.97
23S 54 1415 1587 U:G cWW   Weak C 29.0 1.0 45.0 13.0   2.0 1.0     1.0     1.0   2.0 2.0 3.0 100 GC,UA,AU,UG,UC,UU GC,CG,UA,AU 12 4 1 0.12 0.83 0.91 1.73 0.91 0.93 0.37 0.24 0.01 0.94
23S 56 1436 1556 G:C cWW   Weak C 19.0 1.0 1.0 13.0 61.0 1.0             2.0       2.0 100 GC,AU,GU,GA CG,UA,GU 7 7 2 0.29 0.05 0.0 0.05 0.35 0.98 1.05 0.81 0.0 0.95
23S 56 1440 1551 U:A cWW   Weak C 9.0   2.0 32.0 5.0   9.0 5.0 2.0 3.0 1.0 4.0   1.0   2.0 25.0 100 GC,UA,AU,GU,AA,AC,AG,CA,CU,UU GC,AU,CA 10 13 5 0.43 0.28 0.59 0.87 0.57 0.64 0.21 -0.32 0.09 0.73
23S 57 1445 1466 G:U cWW   Weak C 2.0 9.0   3.0 27.0                       59.0 100 GC,CG,AU,GU CG,GU 8 2 2 0.4 0.64 0.88 1.52 0.34 1.0 -0.29 -0.58 0.38 0.4
23S 58 1468 1524 U:G cWW   Weak C 46.0   3.0 2.0 3.0 3.0   1.0 1.0 1.0 2.0 6.0 7.0   1.0 12.0 12.0 100 GC,UA,AU,GU,UG,CC,CU,GA,UU GC,AG,CA,UU 6 8 1 0.14 0.33 0.68 1.01 0.58 0.65 0.04 -0.09 0.0 0.85
23S 58 1478 1513 G:U cWW   Weak C 21.0   4.0 4.0 41.0   2.0 1.0 1.0       5.0 8.0     13.0 100 GC,UA,AU,GU,AA,GA,GG UA,GU,AC 8 11 2 0.21 0.11 0.0 0.11 0.33 0.81 0.59 -0.18 0.02 0.84
23S 58 1481 1510 U:G cWW   Weak C     7.0       1.0     1.0       2.0     89.0 100 UA,GG UA,GG 7 0 0 0.0 0.5 0.82 1.32 0.64 0.64 -0.21 -0.46 0.0 0.0
23S 58 1483 1506 G:U cWW   Weak C   1.0 1.0   3.0 3.0 1.0 1.0   2.0     42.0 3.0   1.0 42.0 100 GU,UG,CA,GA,GG UG,AC,GA 12 3 1 0.13 0.25 0.79 1.04 0.03 0.14 -0.17 -0.37 0.15 0.56
23S 63 1707 1751 G:U cWW   Weak C 27.7     21.8 49.5     1.0                   101 GC,AU,GU GU,AC 8 16 5 0.42 0.02 0.0 0.02 0.49 0.99 1.23 1.14 0.0 0.98
23S 64 1770 1982 G:U cWW   Weak C 3.0     1.0 93.1               1.0       2.0 101 GC,GU   1 2 0 0.0 0.0 0.0 0.0 0.04 0.99 1.74 1.73 0.02 0.96
23S 65 1775 1789 U:A tHS   Weak C     100.0                             101 UA   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.98
23S 66 1799 1820 G:U No BP   Weak C 1.0       96.0               3.0         101 GU,GA   0 3 0 0.0 0.0 0.0 0.0 0.01 0.97 2.0 1.73 0.0 0.98
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 68 1835 1905 G:C cWW   Weak C 100.0                                 101 GC   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.98
23S 68 1841 1901 U:A cWW   Weak C     100.0                             101 UA   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.98
23S 68 1842 1898 G:U cWW   Weak C 1.0       99.0                         101 GU   0 1 0 0.0 0.0 0.0 0.0 0.01 1.0 2.0 1.92 0.0 0.98
23S 68 1851 1891 U:G cWW   Weak C           100.0                       101 UG   0 0 0 0.0 0.0 0.0 0.0 0.0 1.0 2.0 2.0 0.0 0.98
23S 69 1907 1923 G:U cWW   Weak C         100.0                         101 GU   0 0 0 0.0 0.0 0.0 0.0 0.0 1.0 2.0 2.0 0.0 0.98
23S 69 1911 1919 U:A No BP   Weak C     100.0                             101 UA   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.98
23S 71 1945 1961 G:C cWW   Weak C 100.0                                 101 GC   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.98
23S 71 1947 1959 C:G cWW   Weak C 1.0 99.0                               101 CG GC,CG 0 0 0 0.0 1.0 1.0 2.0 1.0 1.0 1.92 1.92 0.0 0.98
23S 73 2056 2612 G:C cWW   Weak C             96.2   3.8                 52 AA,AG   0 1 0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 1.77 0.0 0.51
23S 74 2065 2445 C:G cWW   Weak C   100.0                               99 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.96
23S 74 2075 2434 U:A No BP   Weak C     100.0                             99 UA   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.96
23S 75 2077 2243 A:U cWW   Weak C       99.0               1.0           100 AU   1 0 0 0.0 0.0 0.0 0.0 0.99 0.99 1.92 2.0 0.0 0.97
23S 76 2100 2189 G:U cWW   Weak C     1.0 7.9 90.1             1.0           101 AU,GU UA,GU 6 1 1 0.29 0.1 0.0 0.1 0.09 0.99 1.44 1.92 0.0 0.98
23S 76 2109 2180 U:U cWW 3°: base pair Weak C       1.0               1.0     1.0 97.0   101 UU   2 1 0 0.0 0.0 0.0 0.0 0.01 0.01 1.84 1.92 0.0 0.98
23S 77 2120 2178 G:C cWW   Weak C 2.0     7.9 90.1                         101 GC,AU,GU   4 1 0 0.0 0.0 0.0 0.0 0.1 1.0 1.6 1.86 0.0 0.98
23S 78 2136 2155 G:U cWW   Weak C 21.8 4.0 3.0 20.8 36.6 1.0 2.0     2.0     4.0 1.0   2.0 2.0 101 GC,CG,UA,AU,GU,AA,CA,GA,UU CG,UA,GU 9 16 5 0.4 0.11 0.0 0.11 0.51 0.89 0.46 0.33 0.0 0.96
23S 78 2143 2148 C:G cWW   Weak C           95.0                     5.0 101 UG   0 0 0 0.0 0.0 0.0 0.0 0.0 1.0 1.62 1.62 0.0 0.93
23S 80 2249 2255 U:G No BP   Weak C     2.0     98.0                       102 UA,UG   0 2 0 0.0 0.0 0.0 0.0 0.02 1.0 2.0 1.86 0.0 0.99
23S 83 2291 2341 U:G cWW   Weak C     1.0     97.1             2.0         102 UG,GA UG,GA 1 1 0 0.0 0.67 0.99 1.66 0.01 0.98 1.86 1.81 0.0 0.99
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 86 2351 2366 G:A cWW 3°: base pair Weak C             83.3           16.7         102 AA,GA   8 0 0 0.0 0.0 0.0 0.0 0.0 0.0 1.35 2.0 0.0 0.99
23S 89 2455 2496 G:C cWW   Weak C 100.0                                 102 GC   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.99
23S 89 2460 2490 U:G cWW   Weak C           100.0                       102 UG   0 0 0 0.0 0.0 0.0 0.0 0.0 1.0 2.0 2.0 0.0 0.99
23S 93 2592 2601 G:C cWW   Weak C 94.5                       5.5         55 GC,GA   0 2 0 0.0 0.0 0.0 0.0 0.94 0.94 2.0 1.7 0.0 0.53
23S 95 2652 2668 C:G cWW   Weak C 5.2 27.6 8.6 39.7   19.0                       58 GC,CG,UA,AU,UG GC,CG,UA,AU 6 4 2 0.4 0.69 0.81 1.5 0.81 1.0 0.23 0.43 0.0 0.56
23S 96 2696 2711 U:A cWW   Weak C     96.6                         3.4   58 UA,UU   0 1 0 0.0 0.0 0.0 0.0 0.97 0.97 2.0 1.78 0.0 0.56

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;