home / crw2

Base-pair collective (covariation) scores

782 rows where group_code = "A", molecule = "23S" and strength = "Strong" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: reference_base_pair, tertiary_type, Xch, Ych, PE, PES, DfDel, Seq

conformation 9

  • cWW 757
  • No BP 10
  • tWW 5
  • tSH 4
  • tHS 2
  • cWH 1
  • tHS/tSH 1
  • tSS 1
  • tWH 1

strength 1

  • Strong · 782 ✖

molecule 1

  • 23S · 782 ✖

group_code 1

  • A · 782 ✖
Link rowid molecule helix_number position_1 ▼ position_2 pair_note header_format reference_base_pair conformation ai_code tertiary_type header_extra strength group_code Xch Ych PE PES Cov1 Cov3 C1+C3 WC WCGU XCons YCons DfDel PNuc Seq
3350 3350 23S 1 1 2902   v4 G:C cWW       Strong A 3 0 0 0.0 0.43 0.64 1.06 0.55 0.73 -0.71 -0.97 0.05 0.27 33
3357 3357 23S 1 2 2901   v4 G:C cWW       Strong A 2 2 0 0.0 0.67 0.85 1.51 0.77 0.77 -0.42 -0.8 0.0 0.32 33
3364 3364 23S 1 3 2900   v4 U:A cWW       Strong A 4 2 1 0.33 0.83 0.94 1.77 0.69 0.69 -0.65 -0.81 0.07 0.39 33
3371 3371 23S 1 4 2899   v4 U:A cWW       Strong A 6 4 3 0.6 0.93 0.95 1.88 0.95 0.95 -0.51 -0.81 0.15 0.51 33
3378 3378 23S 1 5 2898   v4 A:U cWW       Strong A 5 5 3 0.6 0.8 0.93 1.73 0.93 0.93 -0.12 -0.33 0.02 0.66 33
3385 3385 23S 1 6 2897   v4 A:U cWW       Strong A 3 4 2 0.57 0.71 0.93 1.64 0.93 0.93 0.4 0.15 0.0 0.68 33
3392 3392 23S 1 7 2896   v4 G:C cWW       Strong A 2 3 0 0.0 0.82 0.9 1.72 0.9 0.97 0.69 -0.01 0.07 0.73 33
3406 3406 23S 2 15 525   v4 G:U cWW       Strong A 5 4 1 0.22 0.3 0.61 0.91 0.17 0.67 0.33 0.77 0.0 0.88 36
3413 3413 23S 2 16 524   v4 C:G cWW       Strong A 2 5 1 0.29 0.32 0.64 0.95 0.64 1.0 1.24 0.43 0.0 0.88 36
3420 3420 23S 2 17 523   v4 G:C cWW       Strong A 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.7 0.0 0.88 36
3427 3427 23S 2 18 522   v4 U:A cWW       Strong A 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.7 0.0 0.88 36
3434 3434 23S 2 19 521   v4 A:U cWW       Strong A 5 3 2 0.5 0.79 0.89 1.68 0.89 0.92 0.61 0.87 0.0 0.88 36
3441 3441 23S 2 20 520   v4 C:G cWW       Strong A 6 6 4 0.67 0.58 0.78 1.36 0.78 1.0 0.27 0.41 0.0 0.88 36
3448 3448 23S 2 21 519   v4 A:U cWW       Strong A 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.5 1.51 0.0 0.88 36
3455 3455 23S 2 22 518   v4 C:G cWW       Strong A 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 0.76 0.77 0.0 0.88 36
3462 3462 23S 2 23 517   v4 G:C cWW       Strong A 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.7 0.0 0.88 36
3469 3469 23S 2 24 516   v4 G:C cWW       Strong A 0 1 0 0.0 0.0 0.0 0.0 0.75 1.0 2.0 1.2 0.0 0.88 36
3476 3476 23S 2 30 510   v4 G:C cWW   3°: base pair   Strong A 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 0.85 0.87 0.0 0.88 36
3483 3483 23S 3 31 474   v4 C:G cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3490 3490 23S 3 32 473   v4 C:G cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3497 3497 23S 4 35 445   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3504 3504 23S 4 36 444   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3511 3511 23S 4 37 442   v4 C:G cWW       Strong A 1 0 0 0.0 0.5 0.97 1.47 0.97 1.0 1.69 1.82 0.0 0.88 36
3518 3518 23S 4 38 441   v4 A:U cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3525 3525 23S 4 39 440   v4 G:C cWW       Strong A 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 1.29 1.3 0.0 0.88 36
3532 3532 23S 4 40 439   v4 U:A cWW       Strong A 0 0 0 0.0 1.0 1.0 2.0 1.0 1.0 1.59 1.59 0.0 0.88 36
3539 3539 23S 4 41 438   v4 C:G cWW       Strong A 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 1.19 1.2 0.0 0.88 36
3546 3546 23S 4 42 437   v4 A:U cWW       Strong A 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.7 0.0 0.88 36
3553 3553 23S 4 43 436   v4 G:C cWW       Strong A 2 0 0 0.0 0.0 0.0 0.0 0.12 0.62 -0.63 -0.43 0.02 0.2 36
3560 3560 23S 4 44 434   v4 A:U cWW       Strong A 2 2 2 1.0 0.5 0.86 1.36 0.86 0.86 0.99 0.75 0.0 0.88 36
3567 3567 23S 4 45 433   v4 G:C cWW       Strong A 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.42 1.43 0.0 0.88 36
3574 3574 23S 4.1 46 179   v4 G:C cWW       Strong A 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.69 0.0 0.88 36
3581 3581 23S 4.1 47 178   v4 C:G cWW       Strong A 3 1 1 0.5 0.46 0.83 1.29 0.83 1.0 0.9 1.28 0.0 0.88 36
3595 3595 23S 5 54 116   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3602 3602 23S 5 55 115   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3609 3609 23S 5 56 114   v4 A:U cWW       Strong A 5 5 5 1.0 1.0 1.0 2.0 1.0 1.0 0.61 0.61 0.0 0.88 36
3616 3616 23S 6 57 70   v4 C:G cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3623 3623 23S 6 58 69   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3630 3630 23S 6 59 68   v4 U:G cWW       Strong A 1 0 0 0.0 0.0 0.0 0.0 0.19 1.0 1.29 2.0 0.0 0.88 36
3637 3637 23S 6.1 61 93   v4 C:G cWW   3°: pseudoknot   Strong A 1 3 1 0.5 0.85 0.94 1.79 0.94 0.94 1.11 0.92 0.0 0.88 36
3644 3644 23S 6.1 62 92   v4   cWW   3°: pseudoknot   Strong A 1 2 1 0.67 0.5 0.97 1.47 0.97 0.97 1.82 1.64 0.0 0.88 36
3658 3658 23S 6.1 65 89   v4 U:A cWW   3°: pseudoknot   Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3672 3672 23S 6.2 67 74   v4 U:A cWH   3°: pseudoknot   Strong A 2 2 1 0.5 0.5 0.89 1.39 0.89 1.0 0.8 1.06 0.02 0.85 36
3679 3679 23S 7 76 110   v4 C:G cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3686 3686 23S 7 77 109   v4 G:C cWW       Strong A 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.24 1.24 0.0 0.88 36
3693 3693 23S 7 78 108   v4 U:G cWW       Strong A 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 0.88 0.88 0.0 0.88 36
3700 3700 23S 7 79 107   v4 C:G cWW       Strong A 5 5 5 1.0 1.0 1.0 2.0 1.0 1.0 0.37 0.37 0.0 0.88 36
3707 3707 23S 7 80 106   v4 G:C cWW       Strong A 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.59 1.59 0.0 0.88 36
3714 3714 23S 7 81 105   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3721 3721 23S 7 82 104   v4 U:A tSH       Strong A 4 5 2 0.44 0.25 0.67 0.92 0.0 0.25 1.1 0.73 0.0 0.88 36
3728 3728 23S 7 85 97   v4 G:C cWW       Strong A 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.69 0.0 0.88 36
3735 3735 23S 7 86 96   v4 G:C cWW       Strong A 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.02 1.02 0.0 0.88 36
3742 3742 23S 7 87 95   v4 U:A cWW       Strong A 2 3 2 0.8 0.83 0.97 1.81 0.92 0.92 1.28 1.18 0.0 0.88 36
3749 3749 23S 8 121 130   v4 G:C cWW       Strong A 1 3 1 0.5 0.06 0.0 0.06 0.44 0.97 1.59 0.87 0.0 0.88 36
3756 3756 23S 8 122 129   v4 G:C cWW       Strong A 0 0 0 0.0 1.0 1.0 2.0 1.0 1.0 1.59 1.59 0.0 0.88 36
3763 3763 23S 8 123 128   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3770 3770 23S 9 131 148   v4 A:U cWW       Strong A 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 0.22 0.28 0.02 0.63 35
3777 3777 23S 9 132 147   v4 G:C cWW       Strong A 2 1 1 0.67 0.67 0.93 1.59 0.93 1.0 -0.13 -0.13 0.0 0.66 36
3784 3784 23S 9 133 146   v4 U:A cWW       Strong A 0 1 1 1.0 1.0 1.0 2.0 1.0 1.0 -0.18 -0.18 0.0 0.63 36
3791 3791 23S 9 134 145   v4 G:C cWW       Strong A 3 4 5 1.0 0.83 0.92 1.75 0.92 0.92 -0.33 -0.46 0.0 0.61 36
3798 3798 23S 9 135 144   v4 U:A cWW       Strong A 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 -0.5 -0.53 0.02 0.56 35
3805 3805 23S 9 136 143   v4 G:C cWW       Strong A 0 0 0 0.0 0.6 0.82 1.42 0.82 1.0 -0.73 -0.71 0.0 0.27 36
3812 3812 23S 9 137 142   v4 U:A cWW       Strong A 0 0 0 0.0 1.0 1.0 2.0 1.0 1.0 -0.54 -0.54 0.0 0.24 36
3819 3819 23S 10 150 176   v4 U:A cWW       Strong A 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 0.95 0.95 0.0 0.88 36
3826 3826 23S 10 151 175   v4 C:G cWW       Strong A 4 4 4 1.0 1.0 1.0 2.0 1.0 1.0 0.96 0.96 0.0 0.88 36
3833 3833 23S 10 152 174   v4 A:U cWW       Strong A 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.29 1.29 0.0 0.88 36
3840 3840 23S 10 153 173   v4 U:A cWW       Strong A 1 2 1 0.67 0.89 0.97 1.86 0.97 0.97 1.24 1.19 0.0 0.88 36
3847 3847 23S 10 154 172   v4 U:A cWW       Strong A 3 3 3 1.0 0.86 0.97 1.83 0.97 0.97 0.74 0.79 0.0 0.81 36
3854 3854 23S 10 155 171   v4 A:U cWW       Strong A 1 2 1 0.67 0.46 0.6 1.05 0.6 0.87 -0.7 -0.97 0.0 0.37 36
3861 3861 23S 10 156 170   v4 A:U cWW       Strong A 1 2 0 0.0 0.6 0.75 1.35 0.25 0.25 -0.76 -0.72 0.07 0.2 36
3868 3868 23S 10 157 169   v4 C:G cWW       Strong A 1 1 0 0.0 0.0 0.0 0.0 0.5 0.5 -0.68 -0.44 0.0 0.15 36
3882 3882 23S 11 183 214   v4 C:G cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3889 3889 23S 11 184 212   v4 C:G cWW       Strong A 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 0.7 0.7 0.0 0.88 36
3896 3896 23S 11 185 211   v4 G:C cWW       Strong A 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.41 1.41 0.0 0.88 36
3903 3903 23S 11 186 210   v4 G:C cWW       Strong A 3 3 3 1.0 1.0 1.0 2.0 1.0 1.0 0.65 0.65 0.0 0.88 36
3910 3910 23S 11 187 209   v4 G:C cWW       Strong A 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.01 1.01 0.0 0.88 36
3917 3917 23S 11 188 208   v4 G:C cWW       Strong A 2 3 2 0.8 0.9 0.94 1.84 0.94 1.0 0.37 0.63 0.0 0.88 36
3924 3924 23S 11 194 201   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3931 3931 23S 11 195 200   v4 A:U tSH       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3938 3938 23S 12 224 231   v4 U:A cWW       Strong A 5 5 5 1.0 1.0 1.0 2.0 1.0 1.0 0.11 0.11 0.0 0.88 36
3945 3945 23S 12 225 230   v4 C:G cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3952 3952 23S 12.1 234 430   v4 U:A tWW       Strong A 1 0 0 0.0 0.33 0.94 1.28 0.94 0.94 1.51 1.7 0.0 0.88 36
3959 3959 23S 13 235 262   v4 U:A cWW       Strong A 4 4 3 0.75 0.68 0.81 1.49 0.81 1.0 0.46 0.12 0.0 0.88 36
3966 3966 23S 13 236 261   v4 C:G cWW       Strong A 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.19 1.19 0.0 0.88 36
3973 3973 23S 13 237 260   v4 C:G cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
3980 3980 23S 13 238 259   v4 C:G cWW       Strong A 1 1 0 0.0 1.0 1.0 2.0 1.0 1.0 1.0 1.0 0.0 0.88 36
3994 3994 23S 13 245 253   v4 G:C cWW       Strong A 2 3 0 0.0 0.83 0.94 1.78 0.94 0.97 0.98 0.98 0.0 0.88 36
4001 4001 23S 13 246 252   v4 C:G cWW       Strong A 4 5 4 0.89 0.94 0.97 1.91 0.97 1.0 0.36 0.31 0.0 0.88 36
4008 4008 23S 14 265 427   v4 A:U tSS       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 2.0 0.0 0.88 36
4015 4015 23S 14 266 426   v4 G:C cWW       Strong A 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.82 1.82 0.0 0.88 36
4022 4022 23S 14 267 425   v4 C:G cWW       Strong A 2 3 2 0.8 0.93 0.97 1.9 0.97 1.0 0.67 0.56 0.0 0.88 36
4029 4029 23S 14 268 424   v4 C:G cWW       Strong A 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 0.79 0.81 0.0 0.88 36
4036 4036 23S 16 271 366   v4 G:C cWW       Strong A 6 6 6 1.0 0.95 0.97 1.93 0.97 1.0 0.1 0.16 0.0 0.88 36
4043 4043 23S 16 272 365   v4 A:U cWW       Strong A 6 6 6 1.0 0.88 0.94 1.83 0.94 0.94 0.3 0.28 0.0 0.88 36
4050 4050 23S 16 273 364   v4 G:C cWW       Strong A 4 3 3 0.86 0.9 0.94 1.84 0.94 1.0 0.56 0.67 0.0 0.88 36
4071 4071 23S 18 282 358   v4 A:U cWW       Strong A 4 4 4 1.0 0.71 0.8 1.51 0.8 0.86 -0.06 0.03 0.02 0.85 36
4078 4078 23S 18 283 357   v4 G:C cWW       Strong A 7 8 5 0.67 0.67 0.78 1.44 0.78 0.78 0.17 0.2 0.0 0.88 36
4127 4127 23S 18 290 350   v4 U:G cWW       Strong A 5 5 4 0.8 0.69 0.78 1.47 0.78 0.83 0.12 0.06 0.0 0.88 36
4134 4134 23S 18 291 349   v4 G:U cWW       Strong A 7 4 3 0.55 0.33 0.5 0.83 0.5 0.56 0.16 0.32 0.0 0.88 36
4141 4141 23S 18 292 348   v4 U:A cWW       Strong A 4 5 3 0.67 0.54 0.67 1.21 0.67 0.67 0.25 0.13 0.0 0.88 36

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "basepair_collective_score" (
   "molecule" TEXT,
   "helix_number" TEXT,
   "position_1" INTEGER,
   "position_2" INTEGER,
   "pair_note" TEXT,
   "header_format" TEXT,
   "reference_base_pair" TEXT,
   "conformation" TEXT,
   "ai_code" TEXT,
   "tertiary_type" TEXT,
   "header_extra" TEXT,
   "strength" TEXT,
   "group_code" TEXT,
   "Xch" INTEGER,
   "Ych" INTEGER,
   "PE" INTEGER,
   "PES" REAL,
   "Cov1" REAL,
   "Cov3" REAL,
   "C1+C3" REAL,
   "WC" REAL,
   "WCGU" REAL,
   "XCons" REAL,
   "YCons" REAL,
   "DfDel" REAL,
   "PNuc" REAL,
   "Seq" INTEGER
);
CREATE INDEX "idx_basepair_collective_score_molecule_position_1_position_2"
    ON "basepair_collective_score" ("molecule", "position_1", "position_2");
Powered by Datasette · Queries took 1403.838ms