Base-pair collective (covariation) scores

61 rows where group_code = "M", molecule = "23S" 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, PES, Cov3, WCGU, DfDel, PNuc, Seq

conformation 3

strength 1

  • Weak · 61 ✖

molecule 1

  • 23S · 61 ✖

group_code 1

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
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
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
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
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
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
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
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
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
4830 4830 23S 33 687 775   v4 C:G No BP       Weak M 8 4 0 0.0 0.4 0.94 1.34 0.94 0.98 1.34 1.62 0.01 0.83 262
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
4935 4935 23S 34 703 729   v4 U:G No BP       Weak M 20 4 1 0.08 0.04 0.0 0.04 0.09 0.73 -0.3 0.73 0.04 0.64 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
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
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
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
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
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
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
7154 7154 23S 65 1775 1789   v4 U:A tHS       Weak M 2 5 1 0.29 0.61 0.97 1.59 0.97 0.97 1.73 1.59 0.0 0.91 283
7231 7231 23S 66 1799 1820   v4 G:U No BP       Weak M 3 3 1 0.33 0.12 0.0 0.12 0.03 1.0 1.27 1.37 0.0 0.83 283
7245 7245 23S 66 1803 1814   v4 A:G tHS   3°: base pair   Weak M 3 8 3 0.55 0.22 0.66 0.88 0.17 0.19 -0.46 -0.57 0.06 0.17 283
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
7504 7504 23S 69 1911 1919   v4 U:A No BP       Weak M 0 0 0 0.0 0.0 0.0 0.0 1.0 1.0 1.71 1.71 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
7763 7763 23S 74 2075 2434   v4 U:A No BP       Weak M 4 7 3 0.55 0.06 0.0 0.06 0.95 0.96 1.85 1.67 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
8197 8197 23S 80 2249 2255   v4 U:G No BP       Weak M 1 8 1 0.22 0.12 0.0 0.12 0.11 0.98 1.88 1.4 0.0 0.99 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");