Base-pair collective (covariation) scores

89 rows where conformation = "cWW", group_code = "M" and strength = "Weak" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

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

molecule 2

strength 1

  • Weak · 89 ✖

group_code 1

conformation 1

  • cWW · 89 ✖
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
3402 3402 23S 1 8 2895   v4 C:G cWW       Weak M 5 4 1 0.22 0.47 0.67 1.14 0.67 0.74 -0.74 -0.53 0.02 0.09 34
112 112 16S 3 35 549   v4 G:C cWW       Weak M 61 55 16 0.28 0.19 0.0 0.19 0.45 0.9 0.77 1.11 0.0 0.63 733
133 133 16S 4 39 403   v4 G:C cWW       Weak M 70 60 21 0.32 0.49 0.84 1.33 0.84 0.86 0.76 0.62 0.0 0.64 747
210 210 16S 5 54 357   v4 C:G cWW       Weak M 6 4 1 0.2 0.04 0.0 0.04 0.97 0.99 1.74 1.91 0.0 0.68 791
217 217 16S 5 56 356   v4 U:A cWW       Weak M 2 2 1 0.5 0.0 0.0 0.0 0.99 0.99 1.89 1.91 0.0 0.68 793
231 231 16S 5 58 354   v4 C:G cWW       Weak M 7 5 1 0.17 0.26 0.98 1.24 0.98 0.99 1.69 1.82 0.0 0.71 827
245 245 16S 6 62 105   v4 U:G cWW       Weak M 56 47 16 0.31 0.32 0.81 1.13 0.12 0.83 0.51 0.67 0.04 0.68 827
3668 3668 23S 6.1 66 88   v4 C:G cWW   3°: pseudoknot   Weak M 3 4 1 0.29 0.39 0.58 0.96 0.37 0.42 -0.48 -0.47 0.02 0.06 233
273 273 16S 6 68 101   v4 G:A cWW   3°: base pair   Weak M 8 13 7 0.67 0.01 0.0 0.01 0.02 0.04 -0.33 -0.42 0.0 0.0 830
3878 3878 23S 10 158 168   v4 U:G cWW       Weak M 1 0 0 0.0 0.5 0.83 1.33 0.33 0.33 -0.15 -0.17 0.0 0.02 234
4060 4060 23S 16 274 363   v4 C:G cWW       Weak M 0 1 0 0.0 0.5 0.75 1.25 0.5 0.75 -0.23 -0.3 0.01 0.03 254
4067 4067 23S 18 281 359   v4 C:G cWW       Weak M 1 3 1 0.5 0.55 0.67 1.21 0.67 0.73 -0.35 -0.35 0.0 0.05 254
4088 4088 23S 18 284 356   v4 U:G cWW       Weak M 2 5 2 0.57 0.33 0.5 0.83 0.38 0.44 -0.34 -0.38 0.0 0.05 254
784 784 16S 12 292 308   v4 G:C cWW       Weak M 4 4 4 1.0 0.01 0.0 0.01 0.1 0.11 -0.31 -0.37 0.0 0.0 871
4151 4151 23S 18 293 347   v4 U:A cWW       Weak M 4 4 1 0.25 0.2 0.0 0.2 0.48 0.7 -0.43 -0.4 0.0 0.07 254
4249 4249 23S 20 327 335   v4 G:C cWW       Weak M 1 0 0 0.0 0.33 0.94 1.27 0.94 0.94 -0.36 -0.32 0.0 0.1 254
882 882 16S 14 342 347   v4 C:G cWW       Weak M 27 11 7 0.37 0.17 0.0 0.17 0.81 0.83 0.51 1.02 0.02 0.65 831
4277 4277 23S 21 378 396   v4 C:G cWW       Weak M 8 6 6 0.86 0.4 0.6 1.0 0.6 0.87 -0.54 -0.51 0.0 0.12 255
4305 4305 23S 21 382 392   v4 A:U cWW       Weak M 4 4 2 0.5 0.32 0.48 0.8 0.48 0.69 -0.47 -0.44 0.0 0.09 255
952 952 16S 16 406 436   v4 G:C cWW       Weak M 23 6 3 0.21 0.05 0.0 0.05 0.1 0.11 -0.75 -0.43 0.0 0.0 833
980 980 16S 16 416 427   v4 G:U cWW       Weak M 11 7 4 0.44 0.03 0.0 0.03 0.07 0.1 -0.46 -0.42 0.0 0.0 835
1001 1001 16S 16 419 424   v4 C:G cWW       Weak M 7 3 2 0.4 0.04 0.0 0.04 0.07 0.08 -0.42 -0.41 0.0 0.0 835
4466 4466 23S 25 538 555   v4 A:G cWW   3°: base pair   Weak M 2 10 3 0.5 0.06 0.0 0.06 0.29 0.33 -0.47 -0.61 0.01 0.15 256
4522 4522 23S 25.1 564 577   v4 C:G cWW       Weak M 3 2 1 0.4 0.5 0.98 1.48 0.98 0.99 1.47 1.45 0.0 0.8 262
1260 1260 16S 19.1 571 865   v4 U:A cWW   3°: pseudoknot   Weak M 13 15 2 0.14 0.52 0.97 1.49 0.97 0.99 1.63 1.55 0.01 0.75 881
1309 1309 16S 20 584 757   v4 G:U cWW       Weak M 69 62 11 0.17 0.14 0.0 0.14 0.58 0.73 -0.24 0.71 0.11 0.73 883
1372 1372 16S 21 594 645   v4 U:G cWW       Weak M 12 13 7 0.56 0.02 0.0 0.02 0.03 0.03 -0.41 -0.38 0.0 0.0 1021
1386 1386 16S 21 597 643   v4 G:C cWW       Weak M 7 10 2 0.23 0.01 0.0 0.01 0.04 0.04 -0.34 -0.32 0.0 0.0 1021
4662 4662 23S 27 600 657   v4 G:U cWW       Weak M 1 0 0 0.0 0.0 0.0 0.0 0.09 1.0 -0.42 -0.37 0.0 0.14 262
1442 1442 16S 21 605 633   v4 U:G cWW       Weak M 8 7 3 0.4 0.01 0.0 0.01 0.01 0.04 -0.24 -0.24 0.0 0.0 1021
4760 4760 23S 31 641 647   v4 U:G cWW       Weak M 2 2 2 1.0 0.4 0.68 1.08 0.68 0.74 -0.35 -0.32 0.0 0.06 262
1526 1526 16S 22 658 748   v4 C:G cWW       Weak M 70 45 10 0.17 0.43 0.65 1.09 0.45 0.61 -0.69 -0.81 0.08 0.35 896
1568 1568 16S 22 666 740   v4 G:U cWW       Weak M 45 76 11 0.18 0.31 0.46 0.77 0.38 0.42 0.24 -0.61 0.12 0.61 897
4767 4767 23S 32 671 809   v4 C:G cWW       Weak M 2 3 1 0.4 0.77 0.99 1.76 0.99 1.0 1.55 1.57 0.0 0.83 262
1631 1631 16S 23 677 713   v4 U:G cWW       Weak M 82 96 21 0.24 0.16 0.0 0.16 0.24 0.34 0.18 -0.05 0.03 0.74 901
1680 1680 16S 23 684 706   v4 U:A cWW       Weak M 67 78 21 0.29 0.3 0.61 0.9 0.61 0.67 0.64 0.17 0.01 0.77 901
4886 4886 23S 33 695 767   v4 G:U cWW       Weak M 34 33 20 0.6 0.33 0.63 0.96 0.63 0.96 0.48 0.75 0.0 0.84 263
4942 4942 23S 34 707 724   v4 G:U cWW       Weak M 3 4 1 0.29 0.42 0.6 1.02 0.6 0.91 -0.57 -0.53 0.01 0.11 263
5138 5138 23S 37 826 831   v4 U:G cWW       Weak M 7 7 3 0.43 0.24 0.91 1.15 0.1 0.98 1.14 0.9 0.0 0.78 263
1876 1876 16S 26 832 854   v4 G:U cWW       Weak M 12 11 5 0.43 0.03 0.0 0.03 0.05 0.08 -0.4 -0.37 0.0 0.0 1099
1939 1939 16S 26.1 861 868   v4 G:C cWW       Weak M 98 61 10 0.13 0.18 0.0 0.18 0.35 0.36 -0.79 -0.02 0.18 0.6 1096
2030 2030 16S 28 925 1391   v4 G:U cWW       Weak M 7 24 1 0.07 0.14 0.0 0.14 0.71 0.99 1.71 0.84 0.0 0.78 899
2086 2086 16S 28 935 1380   v4 A:U cWW       Weak M 12 18 3 0.2 0.45 0.94 1.39 0.94 0.94 1.47 1.32 0.0 0.83 970
2121 2121 16S 29 942 1341   v4 G:U cWW       Weak M 4 3 0 0.0 0.27 0.99 1.27 0.01 1.0 1.93 1.95 0.0 0.97 1129
2177 2177 16S 30 950 1231   v4 U:G cWW       Weak M 5 11 0 0.0 0.16 0.0 0.16 0.01 0.99 1.94 1.89 0.0 0.99 1152
5712 5712 23S 42 1051 1108   v4 G:U cWW       Weak M 7 12 4 0.42 0.82 0.89 1.71 0.89 0.91 -0.85 -0.83 0.03 0.36 276
2457 2457 16S 34 1052 1206   v4 U:G cWW       Weak M 15 6 0 0.0 0.77 0.96 1.73 0.04 0.84 1.36 1.23 0.0 0.99 1152
2485 2485 16S 34 1058 1199   v4 G:U cWW       Weak M 14 10 2 0.17 0.03 0.0 0.03 0.08 0.84 1.1 1.71 0.0 0.99 1150
5957 5957 23S 46 1215 1234   v4 G:U cWW       Weak M 6 3 1 0.22 0.31 0.72 1.04 0.33 0.93 -0.52 -0.41 0.0 0.13 276
2856 2856 16S 41 1255 1282   v4 G:C cWW       Weak M 6 4 1 0.2 0.01 0.0 0.01 0.06 0.07 -0.31 -0.32 0.0 0.0 1154
3024 3024 16S 44 1401 1501   v4 G:C cWW       Weak M 4 3 1 0.29 0.9 0.99 1.9 0.99 0.99 1.65 1.65 0.0 0.68 791
6419 6419 23S 54 1415 1587   v4 U:G cWW       Weak M 3 1 0 0.0 0.75 0.86 1.61 0.86 0.86 -0.22 -0.18 0.01 0.02 276
3157 3157 16S 44 1425 1475   v4 U:G cWW       Weak M 8 10 6 0.67 0.01 0.0 0.01 0.04 0.07 -0.4 -0.44 0.0 0.0 849
3199 3199 16S 44 1435 1466   v4 G:C cWW       Weak M 11 9 4 0.4 0.01 0.0 0.01 0.01 0.02 -0.27 -0.28 0.0 0.0 849
6517 6517 23S 56 1436 1556   v4 G:C cWW       Weak M 1 1 1 1.0 0.5 0.6 1.1 0.4 0.6 -0.2 -0.14 0.01 0.02 276
6531 6531 23S 56 1440 1551   v4 U:A cWW       Weak M 1 1 1 1.0 1.0 1.0 2.0 0.67 0.67 -0.14 -0.1 0.01 0.01 276
3241 3241 16S 44 1442 1460   v4 G:C cWW       Weak M 9 6 5 0.67 0.01 0.0 0.01 0.03 0.04 -0.25 -0.24 0.0 0.0 849
6566 6566 23S 57 1445 1466   v4 G:U cWW       Weak M 1 2 1 0.67 0.4 0.57 0.97 0.57 0.86 -0.16 -0.2 0.01 0.02 276
6615 6615 23S 58 1468 1524   v4 U:G cWW       Weak M 0 0 0 0.0 0.0 0.0 0.0 0.0 1.0 -0.15 -0.03 0.02 0.0 276
6650 6650 23S 58 1478 1513   v4 G:U cWW       Weak M 0 0 0 0.0 0.0 0.0 0.0 0.0 1.0 -0.1 -0.03 0.01 0.0 276
6671 6671 23S 58 1481 1510   v4 U:G cWW       Weak M 0 0 0 0.0 1.0 1.0 2.0 0.0 0.5 -0.1 -0.06 0.0 0.0 276
6685 6685 23S 58 1483 1506   v4 G:U cWW       Weak M 0 0 0 0.0 0.0 0.0 0.0 0.33 0.33 -0.1 -0.07 0.0 0.01 276
3318 3318 16S 45 1511 1524   v4 G:C cWW       Weak M 27 45 10 0.28 0.63 0.83 1.45 0.83 0.98 0.83 0.75 0.0 0.58 674
3325 3325 16S 45 1512 1523   v4 U:G cWW       Weak M 12 5 2 0.23 0.14 0.0 0.14 0.03 0.99 1.76 1.89 0.0 0.58 675
6993 6993 23S 63 1707 1751   v4 G:U cWW       Weak M 3 2 1 0.4 0.57 0.74 1.31 0.74 0.91 -0.44 -0.48 0.0 0.11 277
7133 7133 23S 64 1770 1982   v4 G:U cWW       Weak M 20 18 6 0.32 0.52 0.75 1.26 0.75 0.98 0.29 0.69 0.0 0.89 276
7301 7301 23S 68 1835 1905   v4 G:C cWW       Weak M 1 2 1 0.67 0.2 0.0 0.2 0.99 1.0 1.7 1.6 0.0 0.96 311
7329 7329 23S 68 1841 1901   v4 U:A cWW       Weak M 2 0 0 0.0 0.0 0.0 0.0 0.99 0.99 1.64 1.73 0.0 0.96 311
7336 7336 23S 68 1842 1898   v4 G:U cWW       Weak M 1 5 0 0.0 0.0 0.0 0.0 0.01 0.99 1.7 1.54 0.0 0.96 311
7385 7385 23S 68 1851 1891   v4 U:G cWW       Weak M 7 10 5 0.59 0.2 0.0 0.2 0.3 0.55 -0.56 -0.54 0.0 0.15 311
7476 7476 23S 69 1907 1923   v4 G:U cWW       Weak M 2 3 1 0.4 0.25 0.98 1.23 0.03 1.0 1.64 1.58 0.0 0.96 311
7525 7525 23S 71 1945 1961   v4 G:C cWW       Weak M 3 6 1 0.22 0.05 0.0 0.05 0.94 0.94 1.89 1.68 0.0 1.0 311
7539 7539 23S 71 1947 1959   v4 C:G cWW       Weak M 12 5 4 0.47 0.19 0.0 0.19 0.66 0.99 0.95 1.5 0.0 1.0 311
7679 7679 23S 73 2056 2612   v4 G:C cWW       Weak M 5 3 2 0.5 0.05 0.0 0.05 0.93 0.93 1.83 1.65 0.0 0.84 262
7700 7700 23S 74 2065 2445   v4 C:G cWW       Weak M 2 1 1 0.67 0.64 0.98 1.63 0.98 1.0 1.7 1.81 0.0 0.99 309
7770 7770 23S 75 2077 2243   v4 A:U cWW       Weak M 3 2 1 0.4 0.25 0.98 1.23 0.98 0.98 1.73 1.84 0.01 0.98 309
7896 7896 23S 76 2100 2189   v4 G:U cWW       Weak M 6 6 2 0.33 0.44 0.63 1.08 0.63 0.81 -0.5 -0.54 0.0 0.13 309
7959 7959 23S 76 2109 2180   v4 U:U cWW   3°: base pair   Weak M 8 6 3 0.43 0.25 0.6 0.85 0.45 0.47 -0.47 -0.47 0.01 0.12 309
7994 7994 23S 77 2120 2178   v4 G:C cWW       Weak M 7 5 4 0.67 0.33 0.51 0.85 0.51 0.78 -0.53 -0.47 0.0 0.13 309
8050 8050 23S 78 2136 2155   v4 G:U cWW       Weak M 2 2 2 1.0 1.0 1.0 2.0 1.0 1.0 -0.13 -0.16 0.01 0.02 309
8099 8099 23S 78 2143 2148   v4 C:G cWW       Weak M 1 1 1 1.0 0.5 0.86 1.36 0.86 1.0 -0.14 -0.13 0.0 0.02 309
8281 8281 23S 83 2291 2341   v4 U:G cWW       Weak M 3 3 1 0.33 0.17 0.0 0.17 0.26 1.0 -0.42 -0.44 0.01 0.15 309
8393 8393 23S 85.1 2328 2387   v4 A:U cWW   3°: pseudoknot   Weak M 1 23 1 0.08 1.0 1.0 2.0 1.0 1.0 -0.33 -0.32 0.61 0.15 309
8442 8442 23S 86 2351 2366   v4 G:A cWW   3°: base pair   Weak M 35 12 5 0.21 0.04 0.0 0.04 0.38 0.38 -0.14 0.42 0.04 0.82 309
8568 8568 23S 89 2455 2496   v4 G:C cWW       Weak M 6 6 3 0.5 0.76 0.95 1.71 0.95 0.99 1.22 1.14 0.0 0.98 306
8596 8596 23S 89 2460 2490   v4 U:G cWW       Weak M 1 3 0 0.0 0.67 0.98 1.65 0.03 0.98 1.68 1.63 0.0 0.97 306
8855 8855 23S 93 2592 2601   v4 G:C cWW       Weak M 3 4 0 0.0 0.25 0.96 1.22 0.96 0.98 1.81 1.69 0.01 0.83 262
9009 9009 23S 95 2652 2668   v4 C:G cWW       Weak M 20 25 13 0.58 0.33 0.61 0.94 0.61 0.67 0.83 0.49 0.01 0.83 262
9114 9114 23S 96 2696 2711   v4 U:A cWW       Weak M 1 1 1 1.0 0.5 0.97 1.47 0.97 0.97 -0.34 -0.36 0.0 0.12 252

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");