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.

82 rows where group_code = "C" and tertiary_type = "3°: base pair" 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, Cov3, WCGU, DfDel, PNuc

conformation 7

strength 5

molecule 2

tertiary_type 1

  • 3°: base pair · 82 ✖

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 2 30 510 G:C cWW 3°: base pair Strong C 6.5   6.5       80.4   6.5                 46 GC,UA,AA,AG GC,AA 1 2 0 0.0 0.33 0.87 1.2 0.13 0.13 1.31 1.56 0.0 0.45
16S 5 47 361 C:G cWW 3°: base pair Strong C   96.8               0.6 1.3     0.6     0.6 156 CG   1 1 0 0.0 0.0 0.0 0.0 0.97 0.97 1.88 1.85 0.01 0.85
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
16S 6 68 101 G:A cWW 3°: base pair Weak C 1.8   2.4 0.6 0.6               92.7 1.8       164 UA,GA AU,GA 4 5 1 0.22 0.08 0.0 0.08 0.05 0.06 1.78 1.65 0.0 0.9
16S 7 129 232 A:G cWW 3°: base pair Strong C     0.6 4.8   1.8     91.0       0.6 0.6     0.6 167 AU,AG UA,AG 6 6 1 0.17 0.07 0.0 0.07 0.05 0.07 1.75 1.57 0.01 0.91
16S 8 145 177 G:G cWW 3°: base pair Strong C 72.6     17.9 1.8   0.6 0.6         0.6 3.6     2.4 168 GC,AU,GG GC,AU 9 16 7 0.56 0.71 0.93 1.64 0.93 0.94 1.09 0.91 0.02 0.9
16S 8 152 169 A:C tHW 3°: base pair Strong C     0.6 3.0     1.8 89.9 1.8   0.6     0.6     1.8 168 AU,AC UA,AC,GG 2 5 1 0.29 0.14 0.0 0.14 0.04 0.04 1.73 1.32 0.01 0.91
16S 11 245 283 U:U cWW 3°: base pair Strong C           0.6           0.6       98.8   170 UU   1 0 0 0.0 0.0 0.0 0.0 0.0 0.01 1.95 1.95 0.0 0.93
23S 19.2 319 323 G:C cWW 3°: base pair Strong C 3.0 94.0       1.0                     2.0 100 GC,CG GC,CG 1 1 1 1.0 0.75 0.99 1.74 0.99 1.0 1.54 1.62 0.0 0.95
16S 13 321 332 A:G cWW 3°: base pair Strong C             1.2   98.8                 166 AG   0 2 0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 1.91 0.0 0.91
16S 15 367 393 U:A cWW 3°: base pair Strong C     98.2     1.8                       165 UA   0 3 0 0.0 0.0 0.0 0.0 0.98 1.0 2.0 1.87 0.0 0.91
23S 21 383 391 C:A cWW 3°: base pair ??? C     1.0             96.0             3.0 100 CA   0 0 0 0.0 0.0 0.0 0.0 0.01 0.01 1.82 1.75 0.02 0.94
16S 17 438 496 U:A tWH 3°: base pair Strong C     98.8     0.6             0.6         163 UA   1 1 0 0.0 0.0 0.0 0.0 0.99 0.99 1.95 1.95 0.0 0.9
16S 17 440 497 C:G cWW 3°: base pair Strong C   0.6 2.5 0.6                       95.7 0.6 162 UA,UU CG,UU 4 3 1 0.29 0.17 0.0 0.17 0.04 0.04 1.85 1.71 0.01 0.89
16S 17 441 493 A:A cWW 3°: base pair Strong C 3.1 67.5 11.0 4.3 1.2   0.6   4.3 4.9     2.5       0.6 163 GC,CG,UA,AU,AG,CA,GA GC,CG,UA,AU 19 17 9 0.5 0.58 0.86 1.44 0.86 0.88 0.72 0.76 0.01 0.89
16S 17 450 483 G:C cWW 3°: base pair Strong C 93.2   0.6 1.9       1.2             2.5   0.6 162 GC,UC GC,UA,AU 4 3 1 0.29 0.4 0.96 1.36 0.96 0.96 1.54 1.78 0.01 0.89
23S 24.1 531 2018 C:G cWW 3°: base pair Strong C   97.0 2.0       1.0                     100 CG,UA CG,UA 2 2 2 1.0 0.67 0.99 1.66 0.99 0.99 1.78 1.81 0.0 0.97
23S 25 537 556 G:A cWW 3°: base pair Strong C     1.0       7.0 1.0   1.0     90.0         100 AA,GA AC,GA 4 1 1 0.4 0.1 0.0 0.1 0.01 0.01 1.44 1.92 0.0 0.97
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 563 578 A:G cWW 3°: base pair Strong C     4.0       3.0   1.0       92.0         100 UA,AA,GA AG,GA 5 1 1 0.33 0.12 0.0 0.12 0.04 0.04 1.52 1.92 0.0 0.97
23S 25.1 565 576 C:U cWW 3°: base pair Strong C   2.0 1.0 3.0               94.0           100 CG,AU,CU UA,CU 2 1 1 0.67 0.17 0.0 0.17 0.06 0.06 1.73 1.78 0.0 0.97
16S 19.1 575 880 G:C cWW 3°: base pair Strong C 98.8     1.2                           162 GC GC,AU 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.91 1.91 0.0 0.89
16S 20 582 758 C:C No BP 3°: base pair Strong C   0.6 3.0 1.2   73.8   0.6 0.6   1.8     1.2 15.9 1.2   164 UA,UG,UC AU,UG,CC 8 17 4 0.32 0.12 0.0 0.12 0.05 0.79 1.55 0.98 0.0 0.9
16S 21 611 629 C:A cWW 3°: base pair Strong C   1.2   4.1 0.6 0.6 22.4 1.2 15.9 40.0 0.6 2.9 5.9     1.2 3.6 170 AU,AA,AG,CA,CU,GA AG,CA,UU 15 17 3 0.19 0.3 0.59 0.89 0.06 0.07 0.4 0.69 0.02 0.9
23S 31 637 651 A:G cWW 3°: base pair Strong C     1.0 12.0   1.0 20.0 5.0 58.0             1.0 2.0 100 AU,AA,AC,AG UA,AG 2 18 1 0.1 0.03 0.0 0.03 0.13 0.14 1.81 0.33 0.02 0.95
16S 22 663 742 A:G cWW 3°: base pair Strong C   0.6 0.6 2.4 0.6 1.2 0.6   93.5               0.6 168 AU,AG UA,GU,AG 3 5 1 0.25 0.2 0.0 0.2 0.04 0.05 1.77 1.65 0.01 0.92
16S 23 674 716 G:A cWW 3°: base pair Strong C 2.4           0.6           96.4       0.6 169 GC,GA   2 3 0 0.0 0.0 0.0 0.0 0.02 0.02 1.9 1.77 0.01 0.92
23S 32 674 806 G:C cWW 3°: base pair ??? C 100.0                                 100 GC   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.97
23S 33 698 763 C:G cWW 3°: base pair Strong C   99.0 1.0                             100 CG CG,UA 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.92 1.92 0.0 0.97
23S 34 713 718 G:A cWW 3°: base pair Strong C     2.0 2.0 2.0   4.0           88.0 1.0 1.0     100 UA,AU,GU,AA,GA AU,GA,UC 4 4 1 0.25 0.25 0.91 1.16 0.04 0.06 1.48 1.6 0.0 0.97
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
23S 38 847 933 U:A cWW 3°: base pair Strong C 64.0   4.0 6.0 3.0 1.0 1.0 1.0 2.0 5.0       11.0 1.0   1.0 100 GC,UA,AU,GU,AG,CA,GG GC,AU,UG,CA 10 8 2 0.22 0.34 0.77 1.11 0.75 0.79 0.91 0.48 0.01 0.96
23S 38 857 920 G:A cWW 3°: base pair Strong C     2.0       7.0   1.0       89.0     1.0   100 UA,AA,GA AG,GA,UU 5 2 2 0.57 0.18 0.0 0.18 0.02 0.02 1.41 1.84 0.0 0.97
16S 30 945 1236 G:A cWW 3°: base pair Strong C                 1.9 0.6     97.5         160 GA AG,GA 2 1 1 0.67 0.75 0.99 1.74 0.0 0.0 1.81 1.87 0.0 0.88
16S 33.2 1026 1035 G:A cWW 3°: base pair Strong C 0.6 1.2 5.0 5.0     2.5   0.6       67.7 1.2   0.6 15.5 161 UA,AU,AA,GA CG,AU,GA 8 6 1 0.14 0.37 0.88 1.25 0.14 0.14 0.28 0.67 0.03 0.75
23S 42 1032 1122 A:G cWW 3°: base pair Strong C       1.0     5.0   94.0                 100 AA,AG   0 3 0 0.0 0.0 0.0 0.0 0.01 0.01 2.0 1.63 0.0 0.97
23S 42 1039 1116 A:G cWW 3°: base pair Strong C 3.0     78.0 13.0   3.0         1.0     2.0     100 GC,AU,GU,AA,UC GC,AU 6 3 1 0.22 0.14 0.0 0.14 0.81 0.94 1.15 1.52 0.0 0.97
23S 42 1040 1115 A:G cWW 3°: base pair Strong C 22.0   7.0 62.0 1.0   5.0 2.0         1.0         100 GC,UA,AU,AA,AC GC,UA,AU 9 7 7 0.88 0.76 0.91 1.67 0.91 0.92 0.87 0.7 0.0 0.97
16S 34 1061 1195 G:C cWW 3°: base pair No Support C 100.0                                 162 GC   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 1.94 0.01 0.89
16S 34 1062 1194 U:U cWW 3°: base pair Strong C     1.2                       1.8 96.9   163 UU   0 3 0 0.0 0.0 0.0 0.0 0.01 0.01 2.0 1.78 0.0 0.9
23S 43.1 1082 1086 U:A tWW 3°: base pair Strong C     98.0                       2.0     100 UA,UC   0 1 0 0.0 0.0 0.0 0.0 0.98 0.98 2.0 1.86 0.0 0.97
23S 44 1087 1102 G:C cWW 3°: base pair Strong C 92.0     6.0 1.0                     1.0   100 GC,AU GC,AU 4 4 4 1.0 0.75 0.98 1.73 0.98 0.99 1.59 1.6 0.0 0.97
23S 46 1196 1250 C:G cWW 3°: base pair Strong 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 46 1203 1242 U:U cWW 3°: base pair Strong C 1.0 57.0 23.0 3.0   7.0       1.0           8.0   100 CG,UA,AU,UG,UU GC,CG,UA,AU 10 13 7 0.61 0.63 0.84 1.47 0.84 0.91 0.8 0.68 0.0 0.97
23S 46 1204 1241 A:A cWW 3°: base pair Strong C 1.0 6.0 51.0 4.0   3.0 9.0     11.0   1.0 2.0 1.0 5.0 6.0   100 CG,UA,AU,UG,AA,CA,GA,UC,UU GC,CG,UA,AU 11 14 5 0.4 0.22 0.62 0.84 0.62 0.65 0.58 0.74 0.0 0.97
23S 46.1 1263 2016 U:U cWW 3°: base pair Strong C                               100.0   100 UU   0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 2.0 0.0 0.97
16S 42 1303 1334 C:G cWW 3°: base pair Strong C   98.8                       0.6     0.6 169 CG   1 0 0 0.0 0.0 0.0 0.0 0.99 0.99 1.88 2.0 0.01 0.92
16S 42 1307 1330 U:U cWW 3°: base pair Strong C       5.9                     1.2 92.9   169 AU,UU   2 2 0 0.0 0.0 0.0 0.0 0.06 0.06 1.68 1.91 0.0 0.93
23S 51 1348 1598 C:A cWW 3°: base pair Significant C 96.0     2.0 2.0                         100 GC,AU,GU GC,AU 2 3 2 0.8 0.5 0.98 1.48 0.98 1.0 1.86 1.76 0.0 0.97
16S 43 1357 1365 A:G cWW 3°: base pair Strong C     0.6       2.4   3.0       93.5       0.6 169 AA,AG,GA AG,GA 6 3 3 0.67 0.5 0.97 1.47 0.01 0.01 1.58 1.74 0.0 0.92
23S 52 1359 1372 A:U cWW 3°: base pair Strong C       92.0   2.0 2.0 4.0                   100 AU,UG,AA,AC AU,UG 1 4 1 0.4 0.25 0.94 1.19 0.92 0.94 1.86 1.48 0.0 0.97
16S 44 1399 1504 C:G cWW 3°: base pair Strong C   99.3                             0.7 135 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 1.92 0.01 0.74
16S 44 1402 1500 C:A cWW 3°: base pair Strong C                   100.0               142 CA   0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 2.0 0.0 0.78
16S 44 1407 1494 C:G cWW 3°: base pair ??? C   100.0                               148 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.81
16S 44 1413 1487 A:G cWW 3°: base pair Strong C   5.4 3.4 3.4     1.3   83.9 2.0   0.7           149 CG,UA,AU,AG,CA UA,AG,CU 9 10 4 0.42 0.25 0.88 1.13 0.12 0.12 1.41 1.41 0.0 0.82
23S 55 1425 1573 G:G cWW 3°: base pair Strong C 1.0   3.0 1.0 3.0 12.0               80.0       100 UA,GU,UG,GG UA,AU,GG 5 5 1 0.2 0.2 0.0 0.2 0.05 0.2 1.31 1.49 0.0 0.97
23S 59 1527 1544 G:A No BP 3°: base pair Strong C 2.0 4.0 9.0 11.0 1.0 3.0 5.0   1.0 24.0 2.0 1.0 8.0 1.0 1.0 1.0 26.0 100 GC,CG,UA,AU,UG,AA,CA,CC,GA GC,AU,UG,CA 14 6 6 0.6 0.32 0.54 0.86 0.35 0.41 -0.63 -0.43 0.05 0.72
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 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 63.1 1752 1756 C:G cWW 3°: base pair Strong C   82.2 10.9     5.9               1.0       101 CG,UA,UG CG,UA 6 2 2 0.5 0.61 0.93 1.54 0.93 0.99 1.27 1.5 0.0 0.98
23S 66 1800 1817 C:G tWW 3°: base pair Strong C   39.6               60.4               101 CG,CA   0 7 0 0.0 0.0 0.0 0.0 0.4 0.4 2.0 1.03 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 1855 1887 U:C cWW 3°: base pair Strong C 68.3     17.8 9.9   3.0 1.0                   101 GC,AU,GU,AA GC,AU 7 9 4 0.5 0.56 0.86 1.42 0.86 0.96 1.24 0.97 0.0 0.98
23S 68 1856 1886 U:U cWW 3°: base pair Strong C 97.0     3.0                           101 GC,AU GC,AU 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.81 1.81 0.0 0.98
23S 68 1858 1884 A:G tHS/tSH 3°: base pair Strong C       3.0     21.8   75.2                 101 AU,AA,AG   0 13 0 0.0 0.0 0.0 0.0 0.03 0.03 2.0 1.06 0.0 0.98
23S 68 1859 1883 U:U cWW 3°: base pair Strong C 88.1     5.0 5.9   1.0                     101 GC,AU,GU GC,AU 2 5 0 0.0 0.42 0.93 1.35 0.93 0.99 1.68 1.43 0.0 0.98
23S 69.1 1925 1929 C:G tWW 3°: base pair Strong C   100.0                               101 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.98
23S 75 2086 2233 U:U cWW 3°: base pair Strong C     97.0 2.0                       1.0   100 UA,AU UA,AU 2 3 2 0.8 0.67 0.99 1.66 0.99 0.99 1.86 1.81 0.0 0.97
23S 76 2104 2185 C:U cWW 3°: base pair Strong C   24.8 25.7   1.0 48.5                       101 CG,UA,UG GU,UG 11 10 6 0.57 0.02 0.0 0.02 0.51 1.0 1.12 1.1 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 81.1 2282 2427 G:C cWW 3°: base pair Strong 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 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 86 2352 2365 A:G cWW 3°: base pair Strong C             12.7   87.3                 102 AA,AG   0 9 0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 1.45 0.0 0.99
23S 90 2507 2582 C:G cWW 3°: base pair Strong C   100.0                               97 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.94
23S 90 2512 2574 C:G cWW 3°: base pair Strong C   89.9 7.1     3.0                       99 CG,UA,UG CG,UA 5 4 3 0.67 0.7 0.97 1.67 0.97 1.0 1.51 1.63 0.0 0.96
23S 96 2675 2732 A:G cWW 3°: base pair Strong C   3.4 5.2   12.1       79.3                 58 CG,UA,GU,AG UA,GU,AG 3 2 2 0.8 0.83 0.97 1.8 0.09 0.21 0.98 1.19 0.0 0.56
23S 99 2808 2891 G:U No BP 3°: base pair ??? C     71.2 13.5   3.8               3.8   1.9 5.7 52 UA,AU,UG,GG UA,AU,GG 4 1 1 0.4 0.75 0.94 1.69 0.9 0.94 0.85 0.33 0.04 0.48
23S 99 2813 2887 A:A cWW 3°: base pair Strong C   18.0 78.0 4.0                           50 CG,UA,AU CG,UA,AU 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.1 1.09 0.0 0.48
23S 99 2814 2886 A:A cWW 3°: base pair Strong C   84.0 6.0       2.0   6.0             2.0   50 CG,UA,AA,AG,UU CG,UA 3 1 1 0.5 0.38 0.9 1.27 0.9 0.9 1.26 1.46 0.0 0.48
23S 101 2844 2872 G:A cWW 3°: base pair Strong C     4.0 4.0 2.0   8.0   82.0                 50 UA,AU,GU,AA,AG UA,GU,AG 1 4 1 0.4 0.33 0.88 1.21 0.08 0.1 1.62 1.16 0.0 0.48
23S 101 2845 2871 U:U cWW 3°: base pair No Support C 30.0   4.0 42.0 16.0 2.0   2.0       4.0           50 GC,UA,AU,GU,UG,AC,CU GC,UA,AU 4 3 0 0.0 0.59 0.76 1.35 0.76 0.94 0.53 0.75 0.0 0.48
23S 101 2849 2866 U:U No BP 3°: base pair Strong C         2.0 10.0               20.0   68.0   50 GU,UG,GG,UU GG,UU 2 3 1 0.4 0.62 0.88 1.5 0.0 0.12 1.24 1.12 0.0 0.48

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;