home / crw2

Base-pair collective (covariation) scores

460 rows where conformation = "cWW", group_code = "A" and molecule = "16S" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: reference_base_pair, tertiary_type, Xch, Ych, PE, WCGU, DfDel

strength 4

  • Strong 419
  • Weak 36
  • No Support 4
  • ??? 1

molecule 1

  • 16S · 460 ✖

group_code 1

  • A · 460 ✖

conformation 1

  • cWW · 460 ✖
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
4 4 16S 1 9 25   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 0.99 1.0 1.94 2.0 0.0 0.56 148
11 11 16S 1 10 24   v4 A:U cWW       Strong A 3 2 2 0.8 0.97 0.99 1.97 0.99 1.0 1.17 1.21 0.0 0.56 147
18 18 16S 1 11 23   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.57 151
25 25 16S 1 12 22   v4 U:G cWW       Strong A 2 3 2 0.8 0.86 0.99 1.84 0.91 0.99 1.57 1.53 0.0 0.56 149
39 39 16S 2 17 918   v4 U:A cWW   3°: pseudoknot   Strong A 0 1 0 0.0 0.0 0.0 0.0 0.99 1.0 2.0 1.93 0.0 0.56 148
46 46 16S 2 18 917   v4 C:G cWW   3°: pseudoknot   Strong A 1 0 0 0.0 0.0 0.0 0.0 0.99 1.0 1.94 1.96 0.0 0.56 149
53 53 16S 2 19 916   v4 A:U cWW   3°: pseudoknot   Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 1.96 0.0 0.57 150
60 60 16S 3 27 556   v4 G:C cWW       Strong A 5 3 2 0.5 0.87 0.95 1.83 0.95 0.95 0.84 1.0 0.0 0.58 155
67 67 16S 3 28 555   v4 A:U cWW       Strong A 4 5 2 0.44 0.7 0.87 1.57 0.87 0.99 0.9 0.61 0.01 0.62 168
74 74 16S 3 29 554   v4 U:A cWW       Strong A 13 11 6 0.5 0.69 0.87 1.56 0.87 0.97 0.62 1.06 0.01 0.66 177
81 81 16S 3 30 553   v4 U:A cWW       Strong A 8 8 6 0.75 0.88 0.94 1.81 0.94 0.99 0.45 0.48 0.0 0.67 178
88 88 16S 3 32 552   v4 A:U cWW       Strong A 1 1 1 1.0 0.67 0.99 1.66 0.99 0.99 1.87 1.93 0.0 0.67 178
95 95 16S 3 33 551   v4 A:U cWW       Strong A 5 6 3 0.55 0.98 0.99 1.98 0.99 0.99 1.16 1.17 0.0 0.69 183
102 102 16S 3 34 550   v4 C:G cWW       Strong A 4 0 0 0.0 0.0 0.0 0.0 0.29 1.0 1.13 2.0 0.0 0.69 183
109 109 16S 3 35 549   v4 G:C cWW       Weak A 2 3 1 0.4 0.2 0.0 0.2 0.05 0.99 1.89 1.65 0.0 0.69 184
116 116 16S 3 36 548   v4 C:G cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 1.95 0.0 0.69 184
130 130 16S 4 39 403   v4 G:C cWW       Weak A 0 1 0 0.0 0.0 0.0 0.0 0.99 1.0 2.0 1.93 0.0 0.73 193
137 137 16S 4 40 402   v4 C:G cWW       Strong A 10 11 10 0.95 0.97 0.99 1.96 0.99 1.0 0.61 0.56 0.0 0.73 195
144 144 16S 4 41 401   v4 G:C cWW       Strong A 5 5 5 1.0 0.94 0.99 1.94 0.99 1.0 1.52 1.54 0.0 0.73 193
151 151 16S 4 42 400   v4 G:C cWW       Strong A 2 3 1 0.4 0.44 0.97 1.42 0.97 1.0 1.86 1.58 0.0 0.74 197
158 158 16S 4 43 399   v4 C:G cWW       Strong A 7 7 7 1.0 1.0 1.0 2.0 1.0 1.0 0.84 0.92 0.0 0.75 198
165 165 16S 4 44 398   v4 A:U cWW       Strong A 15 15 12 0.8 0.9 0.97 1.87 0.97 0.99 0.91 0.92 0.0 0.75 199
172 172 16S 4 45 396   v4 G:C cWW       Strong A 13 9 5 0.46 0.68 0.78 1.46 0.78 0.99 0.1 0.18 0.0 0.71 188
179 179 16S 4 46 395   v4 G:C cWW       Strong A 8 10 6 0.67 0.74 0.91 1.65 0.91 0.99 0.65 0.68 0.0 0.76 201
186 186 16S 5 47 361   v4 C:G cWW   3°: base pair   Strong A 4 4 4 1.0 0.77 0.98 1.75 0.98 0.98 1.64 1.47 0.02 0.73 199
193 193 16S 5 52 359   v4 C:G cWW       Strong A 1 1 1 1.0 0.5 0.99 1.49 0.99 0.99 1.86 1.73 0.02 0.73 199
200 200 16S 5 53 358   v4 A:U cWW       Strong A 0 1 0 0.0 0.29 0.97 1.26 0.97 0.97 1.92 1.71 0.0 0.76 201
207 207 16S 5 54 357   v4 C:G cWW       Weak A 0 0 0 0.0 0.0 0.0 0.0 0.97 0.97 2.0 1.85 0.0 0.76 201
214 214 16S 5 56 356   v4 U:A cWW       Weak A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 2.0 1.8 0.02 0.74 201
221 221 16S 5 57 355   v4 G:C cWW       Strong A 0 1 0 0.0 0.0 0.0 0.0 0.98 0.98 2.0 1.67 0.02 0.73 200
228 228 16S 5 58 354   v4 C:G cWW       Weak A 4 3 2 0.57 0.91 0.98 1.88 0.98 0.98 1.24 1.11 0.02 0.74 200
235 235 16S 6 61 106   v4 G:C cWW       Strong A 0 1 0 0.0 0.0 0.0 0.0 0.99 0.99 2.0 1.96 0.0 0.77 203
242 242 16S 6 62 105   v4 U:G cWW       Weak A 0 0 0 0.0 0.0 0.0 0.0 0.0 1.0 2.0 2.0 0.0 0.77 202
249 249 16S 6 63 104   v4 C:G cWW       Strong A 10 9 5 0.53 0.67 0.94 1.61 0.94 0.99 1.27 1.43 0.0 0.77 202
256 256 16S 6 66 103   v4 A:U cWW       Strong A 10 11 9 0.86 0.96 0.98 1.94 0.98 0.99 0.68 0.83 0.01 0.74 199
263 263 16S 6 67 102   v4 C:G cWW       Strong A 11 11 11 1.0 1.0 1.0 2.0 1.0 1.0 0.29 0.23 0.0 0.76 201
270 270 16S 6 68 101   v4 G:A cWW   3°: base pair   Weak A 4 8 3 0.5 0.36 0.87 1.23 0.86 0.88 1.45 0.91 0.0 0.74 199
277 277 16S 6 69 99   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 202
284 284 16S 6 70 98   v4 U:A cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 202
291 291 16S 6 73 97   v4 C:G cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 202
298 298 16S 6 74 96   v4 A:U cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 202
305 305 16S 6 75 95   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 202
312 312 16S 6 76 93   v4 G:U cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 0.04 0.04 -0.17 -0.2 0.0 0.0 201
319 319 16S 6 77 92   v4 A:U cWW       Strong A 3 1 0 0.0 0.53 0.78 1.31 0.78 0.97 -0.65 -0.53 0.01 0.14 201
326 326 16S 6 78 91   v4 A:U cWW       Strong A 4 5 4 0.89 0.74 0.92 1.66 0.92 0.96 -0.72 -0.65 0.01 0.27 202
333 333 16S 6 79 90   v4 G:C cWW       Strong A 8 5 4 0.61 0.76 0.86 1.61 0.86 1.0 -0.84 -0.78 0.01 0.29 203
340 340 16S 6 80 89   v4 A:U cWW       Strong A 9 8 7 0.82 0.96 0.98 1.95 0.98 1.0 -0.62 -0.65 0.02 0.58 196
347 347 16S 6 81 88   v4 A:U cWW       Strong A 12 13 10 0.8 0.97 0.98 1.96 0.98 0.99 0.14 0.13 0.0 0.74 198
354 354 16S 6 82 87   v4 G:C cWW       Strong A 16 15 14 0.9 0.89 0.94 1.83 0.94 0.98 0.26 0.27 0.0 0.77 202
361 361 16S 6.1 113 314   v4 G:C cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 0.97 0.97 2.0 1.85 0.0 0.77 203
368 368 16S 6.1 114 313   v4 U:A cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 0.97 0.97 2.0 1.85 0.0 0.77 204
375 375 16S 6.1 115 312   v4 G:C cWW       Strong A 3 3 3 1.0 0.88 0.97 1.86 0.97 0.97 1.31 1.2 0.0 0.77 203
382 382 16S 7 122 239   v4 G:U cWW       Strong A 1 5 0 0.0 0.04 0.0 0.04 0.04 0.04 1.83 1.4 0.0 0.77 204
389 389 16S 7 123 238   v4 U:A cWW       Strong A 0 0 0 0.0 1.0 1.0 2.0 1.0 1.0 1.96 1.96 0.0 0.78 206
396 396 16S 7 124 237   v4 C:G cWW       Strong A 1 1 0 0.0 0.5 0.99 1.5 0.99 1.0 1.96 1.93 0.0 0.78 206
403 403 16S 7 125 236   v4 U:A cWW       Strong A 2 3 0 0.0 0.0 0.0 0.0 0.09 0.99 1.9 1.52 0.0 0.82 217
410 410 16S 7 126 235   v4 G:C cWW       Strong A 5 4 2 0.44 0.32 0.89 1.22 0.16 1.0 1.43 1.3 0.0 0.82 217
417 417 16S 7 127 234   v4 G:C cWW       Strong A 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.77 1.8 0.0 0.82 216
424 424 16S 7 128 233   v4 G:C cWW       Strong A 10 12 10 0.91 0.98 0.99 1.97 0.99 0.99 0.24 0.22 0.0 0.81 213
431 431 16S 7 129 232   v4 A:G cWW   3°: base pair   Strong A 11 6 2 0.23 0.0 0.0 0.0 0.5 1.0 1.04 1.49 0.0 0.82 216
438 438 16S 7 131 231   v4 A:U cWW       Strong A 7 6 3 0.46 0.88 0.97 1.84 0.97 0.99 0.84 0.93 0.0 0.82 216
445 445 16S 7 132 230   v4 C:G cWW       Strong A 4 5 4 0.89 0.87 0.99 1.86 0.99 0.99 1.59 1.6 0.0 0.82 216
452 452 16S 7 136 227   v4 C:G cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 1.95 2.0 0.0 0.71 188
459 459 16S 7 137 226   v4 U:G cWW       Strong A 1 0 0 0.0 0.0 0.0 0.0 0.98 0.99 1.96 1.92 0.0 0.77 203
466 466 16S 7 138 225   v4 G:C cWW       Strong A 0 1 0 0.0 0.0 0.0 0.0 0.99 0.99 2.0 1.88 0.0 0.8 211
473 473 16S 7 139 224   v4 A:U cWW       Strong A 15 15 13 0.87 0.98 0.99 1.96 0.99 0.99 0.14 0.14 0.0 0.8 212
480 480 16S 7 140 223   v4 U:A cWW       Strong A 14 14 9 0.64 0.9 0.95 1.85 0.95 0.98 0.21 0.1 0.02 0.79 214
487 487 16S 7 141 222   v4 G:C cWW       Strong A 4 4 4 1.0 1.0 1.0 2.0 1.0 1.0 1.48 1.31 0.02 0.78 211
494 494 16S 7 142 221   v4 G:C cWW       Strong A 2 2 2 1.0 0.75 0.99 1.74 0.99 0.99 1.8 1.71 0.0 0.81 216
501 501 16S 8 144 178   v4 G:C cWW       Strong A 15 15 15 1.0 0.97 0.99 1.96 0.99 1.0 0.45 0.39 0.01 0.8 214
508 508 16S 8 145 177   v4 G:G cWW   3°: base pair   Strong A 18 14 12 0.75 0.85 0.94 1.79 0.94 0.99 0.45 0.56 0.0 0.81 214
515 515 16S 8 146 176   v4 G:C cWW       Strong A 13 16 13 0.9 0.79 0.94 1.73 0.94 1.0 0.89 0.81 0.0 0.81 215
522 522 16S 8 147 175   v4 G:C cWW       Strong A 8 7 5 0.67 0.87 0.98 1.85 0.98 0.99 1.13 1.11 0.0 0.82 216
536 536 16S 8 153 168   v4 C:G cWW       Strong A 8 6 1 0.14 0.21 0.88 1.09 0.86 0.92 1.44 1.45 0.0 0.79 209
543 543 16S 8 154 167   v4 U:A cWW       Strong A 6 6 4 0.67 0.81 0.98 1.79 0.98 0.98 1.41 1.43 0.0 0.81 216
550 550 16S 8 155 166   v4 A:U cWW       Strong A 5 7 4 0.67 0.94 0.98 1.92 0.98 0.99 1.05 0.98 0.0 0.82 216
557 557 16S 8 156 165   v4 C:G cWW       Strong A 3 0 0 0.0 0.0 0.0 0.0 0.92 1.0 1.6 2.0 0.0 0.82 216
564 564 16S 8 157 164   v4 U:G cWW       Strong A 0 0 0 0.0 0.0 0.0 0.0 0.0 1.0 1.95 2.0 0.0 0.81 216
571 571 16S 8 158 163   v4 G:C cWW       Strong A 1 1 1 1.0 1.0 1.0 2.0 1.0 1.0 1.96 1.96 0.0 0.82 216
578 578 16S 9 184 193   v4 G:C cWW       Strong A 21 15 5 0.28 0.25 0.47 0.72 0.16 0.5 0.36 0.5 0.0 0.81 214
585 585 16S 9 185 192   v4 U:A cWW       Strong A 14 13 13 0.96 0.91 0.95 1.86 0.95 0.96 0.15 0.13 0.0 0.82 216
592 592 16S 9 186 191   v4 C:G cWW       Strong A 2 4 0 0.0 0.67 0.98 1.65 0.98 0.99 1.75 1.67 0.0 0.81 215
599 599 16S 10 198 219   v4 G:U cWW       Strong A 4 6 3 0.6 0.47 0.91 1.38 0.91 0.98 1.48 1.15 0.0 0.83 219
606 606 16S 10 199 218   v4 A:U cWW       Strong A 24 17 11 0.54 0.75 0.85 1.61 0.85 0.98 0.03 0.22 0.0 0.8 217
613 613 16S 10 200 217   v4 G:C cWW       Strong A 7 7 6 0.86 0.76 0.86 1.61 0.86 0.93 -0.94 -0.92 0.0 0.4 219
620 620 16S 10 201 216   v4 G:U cWW       Strong A 4 4 1 0.25 0.61 0.8 1.42 0.8 0.91 -0.77 -0.73 0.01 0.28 220
627 627 16S 10 202 215   v4 G:C cWW       Strong A 5 4 3 0.67 0.93 0.97 1.9 0.97 0.97 -0.71 -0.77 0.01 0.22 221
634 634 16S 10 203 214   v4 G:C cWW       Strong A 3 4 1 0.29 0.69 0.81 1.5 0.81 0.98 -0.74 -0.77 0.0 0.2 221
641 641 16S 10 206 213   v4 C:G cWW       Strong A 5 2 2 0.57 0.91 0.95 1.86 0.95 0.96 -0.74 -0.75 0.0 0.22 221
648 648 16S 10 207 212   v4 C:G cWW       Strong A 1 1 0 0.0 0.19 0.0 0.19 0.62 0.98 -0.47 -0.66 0.0 0.21 221
655 655 16S 11 240 286   v4 G:C cWW       Strong A 8 7 5 0.67 0.52 0.94 1.45 0.94 1.0 1.41 1.62 0.0 0.84 221
662 662 16S 11 241 285   v4 G:C cWW       Strong A 8 8 8 1.0 0.95 0.99 1.94 0.99 1.0 1.42 1.5 0.0 0.83 221
669 669 16S 11 242 284   v4 G:C cWW       Strong A 4 4 2 0.5 0.57 0.81 1.38 0.81 0.99 0.51 0.8 0.0 0.83 220
676 676 16S 11 245 283   v4 U:U cWW   3°: base pair   Strong A 2 3 2 0.8 0.99 0.99 1.99 0.0 0.0 1.01 1.01 0.0 0.84 221
683 683 16S 11 247 277   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.84 221
690 690 16S 11 248 276   v4 C:G cWW       Strong A 4 4 4 1.0 1.0 1.0 2.0 1.0 1.0 1.69 1.69 0.0 0.84 223
697 697 16S 11 249 275   v4 U:G cWW       Strong A 2 2 2 1.0 0.95 1.0 1.94 0.0 0.92 1.6 1.58 0.0 0.84 223
704 704 16S 11 252 274   v4 U:A cWW       Strong A 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 1.26 1.26 0.0 0.84 222
711 711 16S 11 253 273   v4 A:U cWW       Strong A 6 5 5 0.91 0.99 1.0 1.98 1.0 1.0 0.75 0.75 0.0 0.84 223
718 718 16S 11 254 272   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.8 212

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 953.91ms