Base-pair frequencies

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).
header_format
legacy = entry not yet revised to the v4 layout (no type / conformation).

61 rows where group_code = 3, molecule = "23S" and strength = "Weak" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: reference_base_pair, UA, UG, AA, AC, AG, CA, CC, CU, GA, GG, UC, UU, gap, covarying_types

conformation 3

tertiary_type 2

strength 1

  • Weak · 61 ✖

molecule 1

  • 23S · 61 ✖

header_format 1

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 GC CG UA AU GU UG AA AC AG CA CC CU GA GG UC UU gap Seq predominant_types covarying_types
3565 3565 23S 1 8 2895   v4 C:G cWW       Weak 3 5.6 27.1 27.5 1.2   19.9         0.4     0.4     18.0 251 GC,CG,UA,UG GC,CG,UA,AU
3831 3831 23S 6.1 66 88   v4 C:G cWW   3°: pseudoknot   Weak 3   67.4 1.5     1.5 0.2   0.2 0.2       0.5     28.5 411 CG CG,UA
4041 4041 23S 10 158 168   v4 U:G cWW       Weak 3 1.2 2.1 20.9 0.2   55.6 0.5   0.5 0.5     0.7 0.2   0.2 17.4 426 CG,UA,UG GC,AU,UG,CA
4223 4223 23S 16 274 363   v4 C:G cWW       Weak 3 2.9 6.0 7.5 0.4 0.4 3.5 1.7 3.1 1.0 1.2 2.1 0.8 1.4 0.2 1.2 3.9 62.9 518 GC,CG,UA,UG,AC,CC,UU CG,UA,GU,AC
4230 4230 23S 18 281 359   v4 C:G cWW       Weak 3 9.7 8.5 3.5 8.5 7.4 4.1 1.9 12.4 1.4 0.6 1.6 3.1 0.6 2.3 0.6 2.5 31.4 516 GC,CG,UA,AU,GU,UG,AC,CU,GG,UU CG,UA,GU,AC
4251 4251 23S 18 284 356   v4 U:G cWW       Weak 3 9.5 24.2 5.0 8.3 5.4 4.3 1.9 6.2 2.1 2.1 2.9 1.4 0.8 1.7 5.2 4.8 14.2 517 GC,CG,UA,AU,GU,UG,AC,AG,CA,CC,UC,UU GC,CG,UA,AU
4314 4314 23S 18 293 347   v4 U:A cWW       Weak 3 10.1 1.9 50.7 1.5 1.1 3.7 2.8 1.3 2.2 1.9 0.9 1.5 2.2 2.2 3.6 1.7 10.6 534 GC,UA,UG,AA,AG,GA,GG,UC GC,UA,AG,CU
4412 4412 23S 20 327 335   v4 G:C cWW       Weak 3 96.1 0.4   2.6       0.2             0.2   0.6 537 GC,AU GC,CG,AU
4440 4440 23S 21 378 396   v4 C:G cWW       Weak 3 2.0 59.9 1.1 0.4 1.3 35.1                 0.2     538 GC,CG,UG GC,CG,UA,AU
4468 4468 23S 21 382 392   v4 A:U cWW       Weak 3 4.3 1.9   29.3 7.1 0.2   11.1       0.4     0.2 45.5 0.2 539 GC,AU,GU,AC,UU CG,AC,UU
4629 4629 23S 25 538 555   v4 A:G cWW   3°: base pair   Weak 3 20.0 1.0   4.0 10.3 5.1 0.6   52.2         0.4   2.3 4.2 525 GC,AU,GU,UG,AG,UU GC,AG,UU
4685 4685 23S 25.1 564 577   v4 C:G cWW       Weak 3   99.6                 0.2 0.2           526 CG  
4825 4825 23S 27 600 657   v4 G:U cWW       Weak 3 33.8   0.2 0.8 65.0                       0.2 520 GC,GU UA,GU
4923 4923 23S 31 641 647   v4 U:G cWW       Weak 3   9.4 0.2     50.9                     39.5 521 CG,UG  
4930 4930 23S 32 671 809   v4 C:G cWW       Weak 3   99.8                             0.2 483 CG  
4993 4993 23S 33 687 775   v4 C:G No BP       Weak 3   99.0               0.2 0.2     0.4     0.2 524 CG  
5049 5049 23S 33 695 767   v4 G:U cWW       Weak 3 5.3   0.2   94.1 0.2   0.2                   524 GC,GU UA,GU,AC
5098 5098 23S 34 703 729   v4 U:G No BP       Weak 3   22.5       77.3       0.2               524 CG,UG UG,CA
5105 5105 23S 34 707 724   v4 G:U cWW       Weak 3 0.2     2.9 96.2     0.2       0.2         0.4 524 AU,GU GU,AC
5301 5301 23S 37 826 831   v4 U:G cWW       Weak 3   34.1       65.3                 0.2   0.4 493 CG,UG  
5875 5875 23S 42 1051 1108   v4 G:U cWW       Weak 3 47.7     30.1 21.2     0.4         0.2     0.2 0.2 482 GC,AU,GU GC,AU
6120 6120 23S 46 1215 1234   v4 G:U cWW       Weak 3 0.6     0.2 92.1     5.7               1.2 0.2 495 GU,AC GU,AC
6582 6582 23S 54 1415 1587   v4 U:G cWW       Weak 3 12.7 11.2 6.4 1.9 6.4 17.5 3.3   1.2 1.9 0.2 0.4 7.7 6.9 0.2 9.4 12.6 481 GC,CG,UA,GU,UG,AA,GA,GG,UU GC,UG,AA,CU
6680 6680 23S 56 1436 1556   v4 G:C cWW       Weak 3 63.0 1.0 2.9 2.9 13.0 0.2 4.3 3.1 0.6 0.2   1.0 3.5 0.4 2.5 1.2   484 GC,UA,AU,GU,AA,AC,GA,UC GC,CG,AA,UU
6694 6694 23S 56 1440 1551   v4 U:A cWW       Weak 3 8.9 21.1 4.3 12.4 30.8 5.2 0.6 1.2 0.6 0.2 0.8 3.3 0.2 1.0 2.3 1.2 5.6 483 GC,CG,UA,AU,GU,UG,CU,UC CG,UA,GU,AC
6729 6729 23S 57 1445 1466   v4 G:U cWW       Weak 3 2.1 5.6   2.1 57.7 5.2 0.2 5.8 0.8 1.9 1.6 1.0 0.4 5.4 0.6 5.4 4.2 485 GC,CG,AU,GU,UG,AC,GG,UU CG,GU,AC
6778 6778 23S 58 1468 1524   v4 U:G cWW       Weak 3 3.1 18.8 6.0 4.1 1.0 18.6 8.0 0.6 14.6 0.2   1.0 6.4 5.2 0.2 4.7 7.3 485 GC,CG,UA,AU,UG,AA,AG,GA,GG,UU GC,CG,AA,UU
6813 6813 23S 58 1478 1513   v4 G:U cWW       Weak 3 27.5 3.5 0.8 5.4 30.4 1.4 2.9 0.2 0.6 8.5 1.9   1.9 1.7 0.2   13.2 484 GC,CG,AU,GU,AA,CA GU,UG,AC,CA
6834 6834 23S 58 1481 1510   v4 U:G cWW       Weak 3 4.7 5.6 0.6 1.0 2.9 6.6 0.2 0.4 0.2 1.6 1.4 21.9 0.4 0.4   0.8 51.1 485 GC,CG,GU,UG,CU GC,UG,AA,CU
6848 6848 23S 58 1483 1506   v4 G:U cWW       Weak 3 33.2 7.2 21.0 4.5 6.2 5.8   0.2   7.2 0.2 0.2 3.5 3.3 0.2 1.0 6.1 485 GC,CG,UA,AU,GU,UG,CA,GA,GG GC,CG,UA,AU
7156 7156 23S 63 1707 1751   v4 G:U cWW       Weak 3 26.2 2.4   6.4 63.5           1.1           0.4 455 GC,CG,AU,GU CG,GU
7296 7296 23S 64 1770 1982   v4 G:U cWW       Weak 3 13.7 47.2 0.2 1.4 35.4 0.5           1.2 0.2       0.2 432 GC,CG,GU CG,UA,GU
7317 7317 23S 65 1775 1789   v4 U:A tHS       Weak 3     98.9       0.2               0.9     458 UA  
7394 7394 23S 66 1799 1820   v4 G:U No BP       Weak 3 40.0       58.3     0.2                 1.5 458 GC,GU GU,AC
7408 7408 23S 66 1803 1814   v4 A:G tHS   3°: base pair   Weak 3 0.9 0.7 0.2 0.9 37.3   0.2 2.0 55.9   0.2         0.4 1.3 456 GU,AC,AG UA,GU,AG,CC
7464 7464 23S 68 1835 1905   v4 G:C cWW       Weak 3 99.8       0.2                         439 GC  
7492 7492 23S 68 1841 1901   v4 U:A cWW       Weak 3     100.0                             440 UA  
7499 7499 23S 68 1842 1898   v4 G:U cWW       Weak 3 0.9       98.9             0.2           440 GU  
7548 7548 23S 68 1851 1891   v4 U:G cWW       Weak 3           100.0                       455 UG  
7639 7639 23S 69 1907 1923   v4 G:U cWW       Weak 3 0.2       99.5               0.2         438 GU  
7667 7667 23S 69 1911 1919   v4 U:A No BP       Weak 3     98.6             0.9           0.2 0.2 440 UA  
7688 7688 23S 71 1945 1961   v4 G:C cWW       Weak 3 99.1     0.2             0.5           0.2 436 GC GC,AU
7702 7702 23S 71 1947 1959   v4 C:G cWW       Weak 3   99.5                             0.5 436 CG  
7842 7842 23S 73 2056 2612   v4 G:C cWW       Weak 3 65.8     32.8     1.0 0.5                   412 GC,AU GC,AU
7863 7863 23S 74 2065 2445   v4 C:G cWW       Weak 3   99.3                             0.7 424 CG  
7926 7926 23S 74 2075 2434   v4 U:A No BP       Weak 3     99.3                         0.7   437 UA  
7933 7933 23S 75 2077 2243   v4 A:U cWW       Weak 3       99.8                         0.2 436 AU  
8059 8059 23S 76 2100 2189   v4 G:U cWW       Weak 3 13.5   0.9 5.7 72.1 5.9 0.5         0.2   0.9     0.2 437 GC,AU,GU,UG GU,UG,AA
8122 8122 23S 76 2109 2180   v4 U:U cWW   3°: base pair   Weak 3 34.1   5.0 0.2   2.3       0.7   0.2     0.9 56.3 0.2 437 GC,UA,UG,UU GC,CA,UU
8157 8157 23S 77 2120 2178   v4 G:C cWW       Weak 3 57.0 1.1 0.5 23.3 17.6                       0.4 437 GC,AU,GU GC,CG,UA,AU
8213 8213 23S 78 2136 2155   v4 G:U cWW       Weak 3 1.6 8.2 2.5 18.3 28.1   1.8 0.9 0.2 0.9   0.2 1.4 0.2     35.6 437 CG,UA,AU,GU CG,UA,GU,AC
8262 8262 23S 78 2143 2148   v4 C:G cWW       Weak 3   60.3     0.2 3.4       0.2             35.9 438 CG,UG CG,GU
8360 8360 23S 80 2249 2255   v4 U:G No BP       Weak 3           99.1               0.7     0.2 434 UG  
8444 8444 23S 83 2291 2341   v4 U:G cWW       Weak 3 5.0 12.4 5.5 0.2   75.5     0.2 0.5         0.2   0.5 437 GC,CG,UA,UG GC,AU,UG,CA
8556 8556 23S 85.1 2328 2387   v4 A:U cWW   3°: pseudoknot   Weak 3       99.1       0.9                   437 AU  
8605 8605 23S 86 2351 2366   v4 G:A cWW   3°: base pair   Weak 3 9.6 1.4 1.8 5.5 2.1 0.5 7.1   0.2       71.5 0.2     0.2 438 GC,AU,GU,AA,GA CG,AU,GA
8731 8731 23S 89 2455 2496   v4 G:C cWW       Weak 3 56.7     6.0 37.1     0.2                   420 GC,AU,GU GC,AU
8759 8759 23S 89 2460 2490   v4 U:G cWW       Weak 3           67.1                   32.6 0.2 420 UG,UU  
9018 9018 23S 93 2592 2601   v4 G:C cWW       Weak 3 99.3       0.2                       0.5 417 GC  
9172 9172 23S 95 2652 2668   v4 C:G cWW       Weak 3 1.4 35.8 8.4 3.4 1.2 24.3       4.6 7.5       13.2 0.2   416 CG,UA,AU,UG,CA,CC,UC CG,AU,UC
9277 9277 23S 96 2696 2711   v4 U:A cWW       Weak 3   4.6 74.3     14.9       2.4   1.7       2.2   417 CG,UA,UG,CA,UU CG,UA

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "basepair_frequency" (
   "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,
   "GC" REAL,
   "CG" REAL,
   "UA" REAL,
   "AU" REAL,
   "GU" REAL,
   "UG" REAL,
   "AA" REAL,
   "AC" REAL,
   "AG" REAL,
   "CA" REAL,
   "CC" REAL,
   "CU" REAL,
   "GA" REAL,
   "GG" REAL,
   "UC" REAL,
   "UU" REAL,
   "gap" REAL,
   "Seq" INTEGER,
   "predominant_types" TEXT,
   "covarying_types" TEXT
);
CREATE INDEX "idx_basepair_frequency_molecule_position_1_position_2"
    ON "basepair_frequency" ("molecule", "position_1", "position_2");