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.

86 rows where group_code = "A" 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, GU, UG, UC, UU, gap, sequences, covarying_types, Xch, Ych, PE, PES, Cov3, WCGU, DfDel, PNuc

conformation 7

strength 5

molecule 3

tertiary_type 1

  • 3°: base pair · 86 ✖

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 A 75.0 2.8 13.9 8.3                           36 GC,CG,UA,AU GC,CG,UA,AU 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 0.85 0.87 0.0 0.88
16S 5 47 361 C:G cWW 3°: base pair Strong A 91.0 0.5 4.5               0.5     1.0     2.5 199 GC,UA GC,CG,UA 4 4 4 1.0 0.77 0.98 1.75 0.98 0.98 1.64 1.47 0.02 0.73
23S 5 53 117 A:G tHS 3°: base pair Significant A   5.6   11.1         83.3                 36 CG,AU,AG   1 1 0 0.0 0.0 0.0 0.0 0.17 0.17 1.69 1.5 0.0 0.88
16S 6 68 101 G:A cWW 3°: base pair Weak A 78.9     6.0 0.5 1.0             11.6 0.5     1.5 199 GC,AU,GA GC,AU,UG 4 8 3 0.5 0.36 0.87 1.23 0.86 0.88 1.45 0.91 0.0 0.74
5S 3 75 101     3°: base pair Strong A 52.3 6.8 18.2 4.5 2.3 2.3                 9.1 4.5   44 GC,CG,UA,AU,GU,UG,UC,UU GC,CG,UA,AU                          
5S 3 76 100     3°: base pair Strong A 31.8 11.4 11.4 20.5 4.5 6.8       2.3         2.3 9.1   44 GC,CG,UA,AU,GU,UG,CA,UC,UU GC,CG,UA,AU                          
5S 3 77 99     3°: base pair Strong A   13.6 86.4                             44 CG,UA CG,UA                          
5S 3 78 98     3°: base pair Significant A     2.3       2.3   86.4 9.1               44 UA,AA,AG,CA AG,CA                          
16S 7 129 232 A:G cWW 3°: base pair Strong A   38.9 11.1     50.0                       216 CG,UA,UG   11 6 2 0.23 0.0 0.0 0.0 0.5 1.0 1.04 1.49 0.0 0.82
16S 8 145 177 G:G cWW 3°: base pair Strong A 55.1 29.0 2.8 6.5   5.6       0.9               214 GC,CG,UA,AU,UG GC,CG,UA,AU 18 14 12 0.75 0.85 0.94 1.79 0.94 0.99 0.45 0.56 0.0 0.81
16S 8 152 169 A:C tHW 3°: base pair Strong A       0.5     47.9 35.8 0.9   11.2 2.3       1.4   215 AA,AC,CC,CU AA,CC,UU 7 13 1 0.1 0.24 0.6 0.85 0.01 0.01 1.33 0.73 0.0 0.81
16S 11 245 283 U:U cWW 3°: base pair Strong A                     44.3       0.5 55.2   221 CC,UU CC,UU 2 3 2 0.8 0.99 0.99 1.99 0.0 0.0 1.01 1.01 0.0 0.84
23S 19.2 319 323 G:C cWW 3°: base pair Strong A 19.4 77.8       2.8                       36 GC,CG,UG GC,CG 2 1 1 0.67 0.88 0.97 1.85 0.97 1.0 1.11 1.29 0.0 0.88
16S 13 321 332 A:G cWW 3°: base pair Strong A   12.7 42.1           43.0   2.2             228 CG,UA,AG,CC UA,AG,CC 5 4 3 0.67 0.78 0.87 1.65 0.55 0.55 0.54 0.89 0.0 0.86
16S 15 367 393 U:A cWW 3°: base pair Strong A 10.9 84.3 2.2               0.4           2.2 229 GC,CG,UA GC,CG,UA 3 4 3 0.86 0.97 1.0 1.96 1.0 1.0 1.17 1.35 0.02 0.85
23S 21 383 391 C:A cWW 3°: base pair ??? A                                 99.9 37     0 3 1 0.67 0.0 0.0 0.0 0.0 0.0 0.0 0.51 0.9 0.0
16S 17 438 496 U:A tWH 3°: base pair Strong A     77.0     0.4       0.4       21.7     0.4 226 UA,GG UA,GG 4 4 4 1.0 0.96 0.99 1.95 0.77 0.78 1.16 1.19 0.0 0.85
16S 17 440 497 C:G cWW 3°: base pair Strong A     4.0     0.4 0.4     4.4 11.1       5.8 73.8   225 UA,CA,CC,UC,UU AA,CC,UU 4 7 2 0.36 0.44 0.85 1.29 0.04 0.04 1.3 0.9 0.0 0.85
16S 17 441 493 A:A cWW 3°: base pair Strong A 13.0 69.1 0.9   1.8 0.4 1.3 0.9 3.6 6.3   0.4 1.3   0.9     223 GC,CG,AG,CA GC,CG,AA 11 15 6 0.46 0.46 0.83 1.3 0.83 0.85 0.88 0.79 0.0 0.84
16S 17 450 483 G:C cWW 3°: base pair Strong A                                 100.0 237     0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
23S 24.1 531 2018 C:G cWW 3°: base pair Strong A 32.4 10.8 2.7 2.7 21.6 2.7 8.1     2.7 10.8     5.4       37 GC,CG,UA,AU,GU,UG,AA,CA,CC,GG GC,CG,AA 5 5 2 0.4 0.28 0.51 0.79 0.49 0.73 0.48 0.08 0.0 0.9
23S 25 537 556 G:A cWW 3°: base pair Strong A 29.7 40.5 21.6 5.4   2.7                       37 GC,CG,UA,AU,UG GC,CG,UA,AU 7 6 6 0.92 0.95 0.97 1.93 0.97 1.0 0.23 0.25 0.0 0.9
23S 25 538 555 A:G cWW 3°: base pair Weak A 70.3     5.4 24.3                         37 GC,AU,GU GC,AU 2 3 1 0.4 0.18 0.0 0.18 0.76 1.0 1.7 1.12 0.0 0.9
23S 25.1 563 578 A:G cWW 3°: base pair Strong A   43.2       21.6 16.2   16.2       2.7         37 CG,UG,AA,AG,GA CG,AA 3 1 0 0.0 0.29 0.59 0.88 0.43 0.65 0.33 1.3 0.0 0.9
23S 25.1 565 576 C:U cWW 3°: base pair Strong A 100.0                                 37 GC   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.9
16S 19.1 575 880 G:C cWW 3°: base pair Strong A 97.2     2.8                           216 GC,AU GC,AU 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.81 1.82 0.0 0.82
16S 20 582 758 C:C No BP 3°: base pair Strong A     1.8     94.9                 3.2     217 UG,UC   0 4 0 0.0 0.0 0.0 0.0 0.02 0.97 2.0 1.52 0.0 0.82
16S 21 611 629 C:A cWW 3°: base pair Strong A   79.4 6.4     3.2 3.2   7.3               0.5 218 CG,UA,UG,AA,AG CG,UA 7 6 4 0.61 0.32 0.86 1.18 0.86 0.89 1.09 1.49 0.0 0.82
23S 31 637 651 A:G cWW 3°: base pair Strong A 70.3 29.7                               37 GC,CG GC,CG 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.12 1.12 0.0 0.9
16S 22 663 742 A:G cWW 3°: base pair Strong A           0.9 6.3   92.8                 221 AA,AG   1 3 0 0.0 0.0 0.0 0.0 0.0 0.01 1.93 1.65 0.0 0.84
16S 23 674 716 G:A cWW 3°: base pair Strong A 100.0                                 232 GC   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88
23S 32 674 806 G:C cWW 3°: base pair ??? A 100.0                                 37 GC   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.9
23S 33 698 763 C:G cWW 3°: base pair Strong A   83.8 8.1     8.1                       37 CG,UA,UG CG,UA 2 1 0 0.0 0.5 0.92 1.42 0.92 1.0 1.36 1.59 0.0 0.9
23S 34 713 718 G:A cWW 3°: base pair Strong A 35.1 62.2       2.7                       37 GC,CG,UG GC,CG 3 2 2 0.8 0.93 0.97 1.9 0.97 1.0 0.9 1.06 0.0 0.9
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
23S 38 847 933 U:A cWW 3°: base pair Strong A                                 100.0 36     0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 0.9 0.0
23S 38 857 920 G:A cWW 3°: base pair Strong A 64.9 5.4   16.2 13.5                         37 GC,CG,AU,GU GC,CG,AU 2 3 1 0.4 0.61 0.86 1.48 0.86 1.0 1.07 0.85 0.0 0.9
16S 30 945 1236 G:A cWW 3°: base pair Strong A                 12.6       87.4         190 AG,GA AG,GA 5 4 3 0.67 1.0 1.0 2.0 0.0 0.0 1.39 1.47 0.0 0.72
16S 33.2 1026 1035 G:A cWW 3°: base pair Strong A                                 100.0 204     0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
23S 42 1032 1122 A:G cWW 3°: base pair Strong A 59.5         21.6     5.4       8.1       5.4 37 GC,UG,AG,GA GC,UG 1 2 0 0.0 0.61 0.86 1.47 0.63 0.86 0.58 0.79 0.05 0.85
23S 42 1039 1116 A:G cWW 3°: base pair Strong A 19.4 30.6 27.8 5.6 11.1       2.8         2.8       36 GC,CG,UA,AU,GU,AG,GG GC,CG,UA,AU 7 5 5 0.83 0.76 0.83 1.59 0.83 0.94 0.14 -0.12 0.02 0.88
23S 42 1040 1115 A:G cWW 3°: base pair Strong A 25.0 16.7 8.3 41.7 8.3                         36 GC,CG,UA,AU,GU GC,CG,UA,AU 3 2 1 0.4 0.86 0.92 1.77 0.92 1.0 0.22 0.08 0.02 0.88
16S 34 1061 1195 G:C cWW 3°: base pair No Support A 36.0     7.6 55.8                       0.5 197 GC,AU,GU   1 2 1 0.67 0.0 0.0 0.0 0.44 1.0 1.62 1.01 0.0 0.74
16S 34 1062 1194 U:U cWW 3°: base pair Strong A   37.9 9.1     52.5       0.5               198 CG,UA,UG UG,CA 1 1 0 0.0 0.01 0.0 0.01 0.47 0.99 1.04 1.55 0.0 0.75
23S 43.1 1082 1086 U:A tWW 3°: base pair Strong A   59.5 40.5                             37 CG,UA CG,UA 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 1.03 1.03 0.0 0.9
23S 44 1087 1102 G:C cWW 3°: base pair Strong A 64.9 5.4   29.7                           37 GC,CG,AU GC,CG,AU 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 0.85 0.85 0.0 0.9
23S 46 1196 1250 C:G cWW 3°: base pair Strong A   100.0                               37 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.9
23S 46 1203 1242 U:U cWW 3°: base pair Strong A 32.4 13.5 8.1 29.7 2.7 10.8                   2.7   37 GC,CG,UA,AU,GU,UG,UU GC,CG,UA,AU 7 7 4 0.57 0.76 0.84 1.6 0.84 0.97 0.08 0.15 0.0 0.9
23S 46 1204 1241 A:A cWW 3°: base pair Strong A 10.8 2.7 21.6 5.4   48.6                   10.8   37 GC,CG,UA,AU,UG,UU GC,AU,UG 2 4 0 0.0 0.32 0.65 0.96 0.41 0.89 1.04 0.26 0.0 0.9
23S 46.1 1263 2016 U:U cWW 3°: base pair Strong A 53.7   2.4 17.1                 7.3 19.5       41 GC,UA,AU,GA,GG GC,UA,AU 1 3 1 0.5 0.42 0.73 1.15 0.73 0.73 1.18 0.29 0.0 1.0
16S 42 1303 1334 C:G cWW 3°: base pair Strong A 28.0 65.2   6.8                           207 GC,CG,AU GC,CG,AU 5 5 5 1.0 1.0 1.0 2.0 1.0 1.0 0.82 0.82 0.0 0.78
16S 42 1307 1330 U:U cWW 3°: base pair Strong A         0.5           2.9       0.5 96.1   207 CC,UU CC,UU 2 2 2 1.0 0.75 0.99 1.74 0.0 0.01 1.77 1.79 0.0 0.78
23S 51 1348 1598 C:A cWW 3°: base pair Significant A                                 99.9 41     0 6 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.2 1.0 0.0
16S 43 1357 1365 A:G cWW 3°: base pair Strong A 56.8 5.8 35.4 1.9                           206 GC,CG,UA GC,CG,UA,AU 8 8 8 1.0 1.0 1.0 2.0 1.0 1.0 0.66 0.66 0.0 0.78
23S 52 1359 1372 A:U cWW 3°: base pair Strong A 53.7 9.8 14.6 17.1 2.4         2.4               41 GC,CG,UA,AU,GU,CA GC,CG,UA,AU 5 5 5 1.0 0.9 0.95 1.85 0.95 0.98 0.32 0.29 0.0 1.0
16S 44 1399 1504 C:G cWW 3°: base pair Strong A   100.0                               104 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.39
16S 44 1402 1500 C:A cWW 3°: base pair Strong A                   100.0               104 CA   0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 2.0 0.0 0.39
16S 44 1407 1494 C:G cWW 3°: base pair ??? A   96.8       3.2                       95 CG,UG   1 0 0 0.0 0.0 0.0 0.0 0.97 1.0 1.87 2.0 0.0 0.36
16S 44 1413 1487 A:G cWW 3°: base pair Strong A   2.7   0.7         96.6                 148 CG,AG   0 0 0 0.0 0.0 0.0 0.0 0.03 0.03 1.84 1.94 0.0 0.56
23S 55 1425 1573 G:G cWW 3°: base pair Strong A   39.0   2.4   58.5                       41 CG,AU,UG AU,UG 7 1 0 0.0 0.06 0.0 0.06 0.41 1.0 0.89 1.83 0.0 1.0
23S 59 1527 1544 G:A No BP 3°: base pair Strong A         73.2                       26.8 41 GU   0 1 0 0.0 0.0 0.0 0.0 0.0 1.0 0.57 0.56 0.07 0.73
23S 59 1528 1543 A:G tHS 3°: base pair Strong A 10.3 61.5     2.6                       25.6 39 GC,CG,GU GC,CG 2 3 3 1.0 0.8 0.97 1.77 0.97 1.0 0.17 0.03 0.0 0.71
23S 62 1690 1697 A:G tHS 3°: base pair Strong A         4.9       63.4 17.1   4.9 2.4     7.3   41 GU,AG,CA,CU,GA,UU AG,CA,UU 4 4 4 1.0 0.67 0.88 1.54 0.0 0.05 0.55 0.69 0.0 1.0
23S 63.1 1752 1756 C:G cWW 3°: base pair Strong A   92.7       7.3                       41 CG,UG   2 0 0 0.0 0.0 0.0 0.0 0.93 1.0 1.62 2.0 0.0 1.0
23S 66 1800 1817 C:G tWW 3°: base pair Strong A   100.0                               41 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 1.0
23S 66 1803 1814 A:G tHS 3°: base pair Weak A         75.6     17.1     2.4         4.9   41 GU,AC,CC,UU GU,AC 2 1 0 0.0 0.7 0.93 1.63 0.0 0.76 0.92 1.29 0.0 1.0
23S 68 1855 1887 U:C cWW 3°: base pair Strong A                                 99.9 41     0 2 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.24 1.0 0.0
23S 68 1856 1886 U:U cWW 3°: base pair Strong A                                 100.0 41     0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
23S 68 1858 1884 A:G tHS/tSH 3°: base pair Strong A                                 100.0 41     0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
23S 68 1859 1883 U:U cWW 3°: base pair Strong A                                 99.9 41     4 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.63 0.0 1.0 0.0
23S 69.1 1925 1929 C:G tWW 3°: base pair Strong A           100.0                       41 UG   0 0 0 0.0 0.0 0.0 0.0 0.0 1.0 2.0 2.0 0.0 1.0
23S 75 2086 2233 U:U cWW 3°: base pair Strong A   9.8 87.8                         2.4   41 CG,UA,UU CG,UA 1 2 1 0.67 0.8 0.98 1.78 0.98 0.98 1.54 1.38 0.0 1.0
23S 76 2104 2185 C:U cWW 3°: base pair Strong A 43.9 7.3 4.9 12.2 29.3                     2.4   41 GC,CG,UA,AU,GU,UU GC,CG,UA,AU 6 7 4 0.61 0.43 0.68 1.12 0.68 0.98 0.75 0.47 0.0 1.0
23S 76 2109 2180 U:U cWW 3°: base pair Weak A     53.7     14.6       7.3         9.8 14.6   41 UA,UG,CA,UC,UU   1 4 0 0.0 0.0 0.0 0.0 0.54 0.68 1.62 0.43 0.0 1.0
23S 81.1 2282 2427 G:C cWW 3°: base pair Strong A 97.6 2.4                               41 GC,CG GC,CG 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.83 1.83 0.0 1.0
23S 86 2351 2366 G:A cWW 3°: base pair Weak A 36.6   4.9 48.8 9.8                         41 GC,UA,AU,GU GC,UA,AU 4 4 2 0.5 0.81 0.9 1.71 0.9 1.0 0.77 0.8 0.0 1.0
23S 86 2352 2365 A:G cWW 3°: base pair Strong A   61.0 31.7 7.3                           41 CG,UA,AU CG,UA,AU 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 0.76 0.76 0.0 1.0
23S 90 2507 2582 C:G cWW 3°: base pair Strong A   100.0                               41 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 1.0
23S 90 2512 2574 C:G cWW 3°: base pair Strong A 2.4 90.2 7.3                             41 GC,CG,UA GC,CG,UA 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 1.46 1.46 0.0 1.0
23S 96 2675 2732 A:G cWW 3°: base pair Strong A   24.4               53.7 4.9   17.1         41 CG,CA,CC,GA   1 4 0 0.0 0.0 0.0 0.0 0.24 0.24 1.34 0.94 0.0 1.0
23S 99 2808 2891 G:U No BP 3°: base pair ??? A 7.9 2.6 2.6       2.6     36.8     13.2       34.3 38 GC,CG,UA,AA,CA,GA GC,CA 5 1 1 0.33 0.27 0.68 0.95 0.2 0.2 0.43 -0.11 0.32 0.61
23S 99 2813 2887 A:A cWW 3°: base pair Strong A 47.4 18.4 18.4 7.9               7.9           38 GC,CG,UA,AU,CU GC,CG,UA,AU 5 5 6 1.0 0.85 0.92 1.77 0.92 0.92 0.24 0.17 0.0 0.93
23S 99 2814 2886 A:A cWW 3°: base pair Strong A   76.3 7.9     5.3           5.3       2.6 2.6 38 CG,UA,UG,CU,UU CG,UA 2 2 1 0.5 0.38 0.86 1.24 0.86 0.92 1.39 0.99 0.02 0.9
23S 101 2844 2872 G:A cWW 3°: base pair Strong A 73.7 7.9 5.3   13.2                         38 GC,CG,UA,GU GC,CG,UA 2 4 2 0.67 0.5 0.87 1.37 0.87 1.0 1.31 0.78 0.0 0.93
23S 101 2845 2871 U:U cWW 3°: base pair No Support A 100.0                                 38 GC   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.93
23S 101 2849 2866 U:U No BP 3°: base pair Strong A     2.6     10.5                   78.9 7.9 38 UA,UG,UU   0 1 0 0.0 0.0 0.0 0.0 0.03 0.14 2.0 0.8 0.07 0.85

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;