home / crw2

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.

832 rows where conformation = "cWW", group_code = "A" and molecule = "23S" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: reference_base_pair, AA, AC, AG, CA, CC, CU, GA, GG, UC, UU, sequences, Xch, Ych, PE, PES, DfDel

strength 5

  • Strong 757
  • Weak 53
  • Significant 8
  • ??? 7
  • No Support 7

tertiary_type 3

  • 3°: base pair 42
  • 3°: pseudoknot 22
  • 3°: base triple 3

molecule 1

  • 23S · 832 ✖

group_code 1

  • A · 832 ✖

conformation 1

  • cWW · 832 ✖
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 1 2902 G:C cWW   Strong A 12.1 3.0   3.0 6.1         6.1   3.0         66.7 33 GC,CG,AU,GU,CA,CU GC,AU,CA 3 0 0 0.0 0.43 0.64 1.06 0.55 0.73 -0.71 -0.97 0.05 0.27
23S 1 2 2901 G:C cWW   Strong A 9.1 21.2               3.0   3.0       3.0 60.6 33 GC,CG,CA,CU,UU GC,CG,UU 2 2 0 0.0 0.67 0.85 1.51 0.77 0.77 -0.42 -0.8 0.0 0.32
23S 1 3 2900 U:A cWW   Strong A 3.0 30.3                         3.0 12.1 51.5 33 GC,CG,UC,UU GC,CG,UU 4 2 1 0.33 0.83 0.94 1.77 0.69 0.69 -0.65 -0.81 0.07 0.39
23S 1 4 2899 U:A cWW   Strong A 18.2 6.1 15.2 21.2                     3.0   36.4 33 GC,CG,UA,AU,UC GC,CG,UA,AU 6 4 3 0.6 0.93 0.95 1.88 0.95 0.95 -0.51 -0.81 0.15 0.51
23S 1 5 2898 A:U cWW   Strong A 51.5 12.1 6.1 6.1     3.0         3.0         18.2 33 GC,CG,UA,AU,AA,CU GC,CG,UA,AU 5 5 3 0.6 0.8 0.93 1.73 0.93 0.93 -0.12 -0.33 0.02 0.66
23S 1 6 2897 A:U cWW   Strong A 63.6 3.0 9.1 3.0                   6.1     15.2 33 GC,CG,UA,AU,GG GC,CG,UA,AU 3 4 2 0.57 0.71 0.93 1.64 0.93 0.93 0.4 0.15 0.0 0.68
23S 1 7 2896 G:C cWW   Strong A 39.4 36.4 3.0 3.0 6.1         3.0             9.1 33 GC,CG,UA,AU,GU,CA GC,CG,UA,AU 2 3 0 0.0 0.82 0.9 1.72 0.9 0.97 0.69 -0.01 0.07 0.73
23S 1 8 2895 C:G cWW   Weak A 24.2 24.2 27.3 3.0   3.0         3.0           15.1 33 GC,CG,UA,AU,UG,CC GC,CG,UA,AU 5 8 2 0.31 0.9 0.93 1.82 0.93 0.96 0.1 -0.3 0.07 0.68
23S 2 15 525 G:U cWW   Strong A       16.7 5.6 44.4   5.6 11.1     13.9       2.8   36 AU,GU,UG,AC,AG,CU,UU AU,UG 5 4 1 0.22 0.3 0.61 0.91 0.17 0.67 0.33 0.77 0.0 0.88
23S 2 16 524 C:G cWW   Strong A 47.2 13.9 2.8   36.1                         36 GC,CG,UA,GU GC,CG,UA 2 5 1 0.29 0.32 0.64 0.95 0.64 1.0 1.24 0.43 0.0 0.88
23S 2 17 523 G:C cWW   Strong A 5.6 94.4                               36 GC,CG GC,CG 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.7 0.0 0.88
23S 2 18 522 U:A cWW   Strong A   94.4 5.6                             36 CG,UA CG,UA 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.7 0.0 0.88
23S 2 19 521 A:U cWW   Strong A 38.9   2.8 47.2 2.8                     8.3   36 GC,UA,AU,GU,UU GC,UA,AU 5 3 2 0.5 0.79 0.89 1.68 0.89 0.92 0.61 0.87 0.0 0.88
23S 2 20 520 C:G cWW   Strong A 16.7 47.2 5.6 8.3 13.9 8.3                       36 GC,CG,UA,AU,GU,UG GC,CG,UA,AU 6 6 4 0.67 0.58 0.78 1.36 0.78 1.0 0.27 0.41 0.0 0.88
23S 2 21 519 A:U cWW   Strong A   88.9 11.1                             36 CG,UA CG,UA 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.5 1.51 0.0 0.88
23S 2 22 518 C:G cWW   Strong A   52.8 41.7 5.6                           36 CG,UA,AU CG,UA,AU 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 0.76 0.77 0.0 0.88
23S 2 23 517 G:C cWW   Strong A 94.4     5.6                           36 GC,AU GC,AU 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.7 0.0 0.88
23S 2 24 516 G:C cWW   Strong A 75.0       25.0                         36 GC,GU   0 1 0 0.0 0.0 0.0 0.0 0.75 1.0 2.0 1.2 0.0 0.88
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
23S 3 31 474 C:G cWW   Strong A 100.0                                 36 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 3 32 473 C:G cWW   Strong A   100.0                               36 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88
23S 4 35 445 G:C cWW   Strong A 100.0                                 36 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 4 36 444 G:C cWW   Strong A 100.0                                 36 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 4 37 442 C:G cWW   Strong A   94.4 2.8     2.8                       36 CG,UA,UG CG,UA 1 0 0 0.0 0.5 0.97 1.47 0.97 1.0 1.69 1.82 0.0 0.88
23S 4 38 441 A:U cWW   Strong A     100.0                             36 UA   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88
23S 4 39 440 G:C cWW   Strong A   80.6 19.4                             36 CG,UA CG,UA 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 1.29 1.3 0.0 0.88
23S 4 40 439 U:A cWW   Strong A 91.7     8.3                           36 GC,AU GC,AU 0 0 0 0.0 1.0 1.0 2.0 1.0 1.0 1.59 1.59 0.0 0.88
23S 4 41 438 C:G cWW   Strong A 75.0     25.0                           36 GC,AU GC,AU 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 1.19 1.2 0.0 0.88
23S 4 42 437 A:U cWW   Strong A 94.4     5.6                           36 GC,AU GC,AU 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.7 0.0 0.88
23S 4 43 436 G:C cWW   Strong A       2.8 11.1                     8.3 77.8 36 AU,GU,UU   2 0 0 0.0 0.0 0.0 0.0 0.12 0.62 -0.63 -0.43 0.02 0.2
23S 4 44 434 A:U cWW   Strong A 5.6 72.2 2.8 5.6           8.3           5.6   36 GC,CG,UA,AU,CA,UU GC,CG,UA,AU 2 2 2 1.0 0.5 0.86 1.36 0.86 0.86 0.99 0.75 0.0 0.88
23S 4 45 433 G:C cWW   Strong A 86.1     13.9                           36 GC,AU GC,AU 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.42 1.43 0.0 0.88
23S 4.1 46 179 G:C cWW   Strong A 5.6 94.4                               36 GC,CG GC,CG 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.69 0.0 0.88
23S 4.1 47 178 C:G cWW   Strong A   69.4 8.3 5.6   16.7                       36 CG,UA,AU,UG CG,UA,AU 3 1 1 0.5 0.46 0.83 1.29 0.83 1.0 0.9 1.28 0.0 0.88
23S 5 54 116 G:C cWW   Strong A 100.0                                 36 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 5 55 115 G:C cWW   Strong A 100.0                                 36 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 5 56 114 A:U cWW   Strong A 55.6 13.9   30.6                           36 GC,CG,AU GC,CG,AU 5 5 5 1.0 1.0 1.0 2.0 1.0 1.0 0.61 0.61 0.0 0.88
23S 6 57 70 C:G cWW   Strong A   100.0                               36 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88
23S 6 58 69 G:C cWW   Strong A 100.0                                 36 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 6 59 68 U:G cWW   Strong A   19.4       80.6                       36 CG,UG   1 0 0 0.0 0.0 0.0 0.0 0.19 1.0 1.29 2.0 0.0 0.88
23S 6.1 61 93 C:G cWW 3°: pseudoknot Strong A 63.9 30.6                     2.8 2.8       36 GC,CG,GA,GG GC,CG 1 3 1 0.5 0.85 0.94 1.79 0.94 0.94 1.11 0.92 0.0 0.88
23S 6.1 62 92   cWW 3°: pseudoknot Strong A   94.4 2.8               2.8             36 CG,UA,CC CG,UA 1 2 1 0.67 0.5 0.97 1.47 0.97 0.97 1.82 1.64 0.0 0.88
23S 6.1 64 90 A:U cWW 3°: pseudoknot Significant A             100.0                     36 AA   0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 2.0 0.0 0.88
23S 6.1 65 89 U:A cWW 3°: pseudoknot Strong A 100.0                                 36 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 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 7 76 110 C:G cWW   Strong A   100.0                               36 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88
23S 7 77 109 G:C cWW   Strong A   77.8 22.2                             36 CG,UA CG,UA 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.24 1.24 0.0 0.88
23S 7 78 108 U:G cWW   Strong A 2.8 75.0 16.7 5.6                           36 GC,CG,UA,AU GC,CG,UA,AU 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 0.88 0.88 0.0 0.88
23S 7 79 107 C:G cWW   Strong A 58.3 16.7 11.1 13.9                           36 GC,CG,UA,AU GC,CG,UA,AU 5 5 5 1.0 1.0 1.0 2.0 1.0 1.0 0.37 0.37 0.0 0.88
23S 7 80 106 G:C cWW   Strong A 91.7     8.3                           36 GC,AU GC,AU 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.59 1.59 0.0 0.88
23S 7 81 105 G:C cWW   Strong A 100.0                                 36 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 7 85 97 G:C cWW   Strong A 94.4 5.6                               36 GC,CG GC,CG 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.69 0.0 0.88
23S 7 86 96 G:C cWW   Strong A 72.2 25.0   2.8                           36 GC,CG,AU GC,CG,AU 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.02 1.02 0.0 0.88
23S 7 87 95 U:A cWW   Strong A   83.3   8.3             2.8       5.6     36 CG,AU,CC,UC CG,AU,UC 2 3 2 0.8 0.83 0.97 1.81 0.92 0.92 1.28 1.18 0.0 0.88
23S 8 121 130 G:C cWW   Strong A 38.9     5.6 52.8   2.8                     36 GC,AU,GU,AA GU,AA 1 3 1 0.5 0.06 0.0 0.06 0.44 0.97 1.59 0.87 0.0 0.88
23S 8 122 129 G:C cWW   Strong A 91.7     8.3                           36 GC,AU GC,AU 0 0 0 0.0 1.0 1.0 2.0 1.0 1.0 1.59 1.59 0.0 0.88
23S 8 123 128 G:C cWW   Strong A 100.0                                 36 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 9 131 148 A:U cWW   Strong A 65.7     8.6                         25.7 35 GC,AU GC,AU 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 0.22 0.28 0.02 0.63
23S 9 132 147 G:C cWW   Strong A 2.8 58.3 5.6 2.8 5.6                       25.0 36 GC,CG,UA,AU,GU CG,UA,GU 2 1 1 0.67 0.67 0.93 1.59 0.93 1.0 -0.13 -0.13 0.0 0.66
23S 9 133 146 U:A cWW   Strong A 5.6 52.8 13.9                           27.8 36 GC,CG,UA GC,CG,UA 0 1 1 1.0 1.0 1.0 2.0 1.0 1.0 -0.18 -0.18 0.0 0.63
23S 9 134 145 G:C cWW   Strong A 36.1 25.0   2.8               5.6         30.6 36 GC,CG,AU,CU GC,CG,AU 3 4 5 1.0 0.83 0.92 1.75 0.92 0.92 -0.33 -0.46 0.0 0.61
23S 9 135 144 U:A cWW   Strong A 20.0 40.0 2.9 2.9                         34.3 35 GC,CG,UA,AU GC,CG,UA,AU 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 -0.5 -0.53 0.02 0.56
23S 9 136 143 G:C cWW   Strong A 16.7 5.6   2.8 2.8 2.8                     69.4 36 GC,CG,AU,GU,UG GC,CG,AU 0 0 0 0.0 0.6 0.82 1.42 0.82 1.0 -0.73 -0.71 0.0 0.27
23S 9 137 142 U:A cWW   Strong A 19.4 8.3                             72.2 36 GC,CG GC,CG 0 0 0 0.0 1.0 1.0 2.0 1.0 1.0 -0.54 -0.54 0.0 0.24
23S 10 150 176 U:A cWW   Strong A   72.2 5.6 22.2                           36 CG,UA,AU CG,UA,AU 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 0.95 0.95 0.0 0.88
23S 10 151 175 C:G cWW   Strong A   16.7 75.0 8.3                           36 CG,UA,AU CG,UA,AU 4 4 4 1.0 1.0 1.0 2.0 1.0 1.0 0.96 0.96 0.0 0.88
23S 10 152 174 A:U cWW   Strong A   80.6 19.4                             36 CG,UA CG,UA 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.29 1.29 0.0 0.88
23S 10 153 173 U:A cWW   Strong A 22.2 75.0                 2.8             36 GC,CG,CC GC,CG 1 2 1 0.67 0.89 0.97 1.86 0.97 0.97 1.24 1.19 0.0 0.88
23S 10 154 172 U:A cWW   Strong A 16.7 72.2                       2.8     8.3 36 GC,CG,GG GC,CG 3 3 3 1.0 0.86 0.97 1.83 0.97 0.97 0.74 0.79 0.0 0.81
23S 10 155 171 A:U cWW   Strong A 11.1 11.1 2.8   8.3 2.8             5.6       58.3 36 GC,CG,UA,GU,UG,GA GC,CG,UA 1 2 1 0.67 0.46 0.6 1.05 0.6 0.87 -0.7 -0.97 0.0 0.37
23S 10 156 170 A:U cWW   Strong A 2.8     2.8         8.3       8.3       77.7 36 GC,AU,AG,GA AG,GA 1 2 0 0.0 0.6 0.75 1.35 0.25 0.25 -0.76 -0.72 0.07 0.2
23S 10 157 169 C:G cWW   Strong A     8.3       5.6     2.8             83.4 36 UA,AA,CA   1 1 0 0.0 0.0 0.0 0.0 0.5 0.5 -0.68 -0.44 0.0 0.15
23S 10 158 168 U:G cWW   Weak A           2.8     5.6 2.8             88.9 36 UG,AG,CA AG,CA 1 1 1 1.0 0.5 0.75 1.25 0.0 0.25 -0.59 -0.37 0.07 0.1
23S 11 183 214 C:G cWW   Strong A   100.0                               36 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88
23S 11 184 212 C:G cWW   Strong A 36.1 55.6 8.3                             36 GC,CG,UA GC,CG,UA 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 0.7 0.7 0.0 0.88
23S 11 185 211 G:C cWW   Strong A 8.3 88.9 2.8                             36 GC,CG,UA GC,CG,UA 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.41 1.41 0.0 0.88
23S 11 186 210 G:C cWW   Strong A 33.3 55.6 11.1                             36 GC,CG,UA GC,CG,UA 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 0.65 0.65 0.0 0.88
23S 11 187 209 G:C cWW   Strong A 44.4 55.6                               36 GC,CG GC,CG 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.01 1.01 0.0 0.88
23S 11 188 208 G:C cWW   Strong A 36.1 47.2   11.1   5.6                       36 GC,CG,AU,UG GC,CG,AU 2 3 2 0.8 0.9 0.94 1.84 0.94 1.0 0.37 0.63 0.0 0.88
23S 11 194 201 G:C cWW   Strong A 100.0                                 36 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 12 224 231 U:A cWW   Strong A 22.2 30.6 36.1 11.1                           36 GC,CG,UA,AU GC,CG,UA,AU 5 5 5 1.0 1.0 1.0 2.0 1.0 1.0 0.11 0.11 0.0 0.88
23S 12 225 230 C:G cWW   Strong A   100.0                               36 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88
23S 13 235 262 U:A cWW   Strong A 27.8 38.9 11.1 2.8 19.4                         36 GC,CG,UA,AU,GU GC,CG,UA,AU 4 4 3 0.75 0.68 0.81 1.49 0.81 1.0 0.46 0.12 0.0 0.88
23S 13 236 261 C:G cWW   Strong A   75.0 25.0                             36 CG,UA CG,UA 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.19 1.19 0.0 0.88
23S 13 237 260 C:G cWW   Strong A   100.0                               36 CG   0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88
23S 13 238 259 C:G cWW   Strong A 52.8 47.2                               36 GC,CG GC,CG 1 1 0 0.0 1.0 1.0 2.0 1.0 1.0 1.0 1.0 0.0 0.88
23S 13 239 258 C:G cWW   Significant A 5.6 2.8 8.3     77.8       5.6               36 GC,CG,UA,UG,CA GC,UG,CA 3 3 2 0.67 0.5 0.89 1.39 0.17 0.94 1.28 1.12 0.0 0.88
23S 13 245 253 G:C cWW   Strong A 66.7 2.8   25.0 2.8     2.8                   36 GC,CG,AU,GU,AC GC,CG,AU 2 3 0 0.0 0.83 0.94 1.78 0.94 0.97 0.98 0.98 0.0 0.88
23S 13 246 252 C:G cWW   Strong A 55.6 13.9 13.9 13.9 2.8                         36 GC,CG,UA,AU,GU GC,CG,UA,AU 4 5 4 0.89 0.94 0.97 1.91 0.97 1.0 0.36 0.31 0.0 0.88
23S 14 266 426 G:C cWW   Strong A 97.2     2.8                           36 GC,AU GC,AU 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.82 1.82 0.0 0.88
23S 14 267 425 C:G cWW   Strong A 22.2 61.1 13.9   2.8                         36 GC,CG,UA,GU GC,CG,UA 2 3 2 0.8 0.93 0.97 1.9 0.97 1.0 0.67 0.56 0.0 0.88
23S 14 268 424 C:G cWW   Strong A 16.7 72.2 2.8 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.79 0.81 0.0 0.88
23S 16 271 366 G:C cWW   Strong A 22.2 41.7 13.9 19.4   2.8                       36 GC,CG,UA,AU,UG GC,CG,UA,AU 6 6 6 1.0 0.95 0.97 1.93 0.97 1.0 0.1 0.16 0.0 0.88
23S 16 272 365 A:U cWW   Strong A 11.1 52.8 8.3 22.2                 5.6         36 GC,CG,UA,AU,GA GC,CG,UA,AU 6 6 6 1.0 0.88 0.94 1.83 0.94 0.94 0.3 0.28 0.0 0.88
23S 16 273 364 G:C cWW   Strong A 44.4 41.7 8.3     5.6                       36 GC,CG,UA,UG GC,CG,UA 4 3 3 0.86 0.9 0.94 1.84 0.94 1.0 0.56 0.67 0.0 0.88
23S 16 274 363 C:G cWW   Weak A 33.3 30.6 8.3     2.8         5.6   5.6   13.9     36 GC,CG,UA,UG,CC,GA,UC GC,CG,UA 4 4 1 0.25 0.58 0.72 1.31 0.72 0.75 0.44 0.59 0.0 0.88
23S 18 281 359 C:G cWW   Weak A 19.4 33.3 25.0 8.3 5.6           2.8       5.6     36 GC,CG,UA,AU,GU,CC,UC GC,CG,UA,AU 5 5 3 0.6 0.79 0.86 1.65 0.86 0.92 0.15 0.06 0.0 0.88
23S 18 282 358 A:U cWW   Strong A 30.6 13.9 22.2 11.1 5.6     2.8       5.6   5.6     2.8 36 GC,CG,UA,AU,GU,AC,CU,GG GC,CG,UA,AU 4 4 4 1.0 0.71 0.8 1.51 0.8 0.86 -0.06 0.03 0.02 0.85
23S 18 283 357 G:C cWW   Strong A 22.2 33.3 19.4 2.8         5.6     5.6 2.8 5.6 2.8     36 GC,CG,UA,AU,AG,CU,GA,GG,UC GC,CG,UA,AU 7 8 5 0.67 0.67 0.78 1.44 0.78 0.78 0.17 0.2 0.0 0.88
23S 18 284 356 U:G cWW   Weak A   72.2 2.8 5.6 2.8 11.1       5.6               36 CG,UA,AU,GU,UG,CA CG,UA,AU 3 2 0 0.0 0.3 0.81 1.11 0.81 0.94 0.95 1.18 0.0 0.88

Next page

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;
Powered by Datasette · Queries took 2452.513ms