home / crw2

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 = "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, GC, CG, UA, AU, GU, UG, AA, AC, AG, CA, CC, CU, GA, GG, UC, UU, Seq, covarying_types

conformation 3

  • cWW 53
  • No BP 6
  • tHS 2

tertiary_type 2

  • 3°: base pair 4
  • 3°: pseudoknot 2

strength 1

  • Weak · 61 ✖

molecule 1

  • 23S · 61 ✖

header_format 1

  • v4 61

group_code 1

  • M · 61 ✖
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
3570 3570 23S 1 8 2895   v4 C:G cWW       Weak M 2.9   29.4 20.6 5.9   5.9 5.9   2.9           5.9 20.6 34 GC,UA,AU,GU,AA,AC,CA,UU GC,UA,AU
3836 3836 23S 6.1 66 88   v4 C:G cWW   3°: pseudoknot   Weak M 0.4   0.9 1.7 0.4       2.6   0.4   0.9     0.9 91.7 233 AG UA,GU,AG,CC
4046 4046 23S 10 158 168   v4 U:G cWW       Weak M 0.4     0.4             1.7           97.4 234   AU,CC
4228 4228 23S 16 274 363   v4 C:G cWW       Weak M 1.6       0.4 0.4                   0.8 96.9 254   GC,UU
4235 4235 23S 18 281 359   v4 C:G cWW       Weak M   1.6 1.2 1.2   0.4 0.8         0.4     0.4   94.1 254   CG,UA,AU
4256 4256 23S 18 284 356   v4 U:G cWW       Weak M   0.8 1.2 0.4   0.4 0.8       0.4     0.4 0.4 1.6 93.7 254   CG,AA,UU
4319 4319 23S 18 293 347   v4 U:A cWW       Weak M   0.4 0.8 3.1 1.6 0.4 0.4 0.4         0.4     1.6 91.0 254 AU CG,UA,AU
4417 4417 23S 20 327 335   v4 G:C cWW       Weak M 11.0     0.4                     0.8   87.8 254 GC GC,AU
4445 4445 23S 21 378 396   v4 C:G cWW       Weak M   5.1 2.0 2.0 0.4 3.5           2.0         85.1 255 CG,UA,AU,UG,CU CG,UA,AU
4473 4473 23S 21 382 392   v4 A:U cWW       Weak M 0.4   2.4 2.7 2.4   2.4   0.4 0.4     0.4       88.6 255 UA,AU,GU,AA GC,UA,AU
4634 4634 23S 25 538 555   v4 A:G cWW   3°: base pair   Weak M     1.2 4.3 0.8   6.2   5.5     0.4 0.4       81.3 256 AU,AA,AG GU,AA
4690 4690 23S 25.1 564 577   v4 C:G cWW       Weak M 0.4 92.7 0.8 0.4 0.4       0.4   0.4 0.4         4.2 262 CG GC,CG,UA,AU
4830 4830 23S 27 600 657   v4 G:U cWW       Weak M 0.4     1.1 15.6                       82.9 262 GU  
4928 4928 23S 31 641 647   v4 U:G cWW       Weak M   1.5 3.4     0.4 0.4   0.4       0.8   0.4   92.7 262 UA CG,UA
4935 4935 23S 32 671 809   v4 C:G cWW       Weak M   93.5 0.4 3.4 0.4 0.4   0.4                 1.6 262 CG,AU CG,UA,AU
4998 4998 23S 33 687 775   v4 C:G No BP       Weak M   89.7 0.8 3.1   4.2   0.4 0.4       0.4 0.4     0.8 262 CG,AU,UG CG,UA,AU
5054 5054 23S 33 695 767   v4 G:U cWW       Weak M 10.3 1.5 6.5 44.5 27.8 5.7 1.5 1.1               1.1   263 GC,UA,AU,GU,UG GC,CG,UA,AU
5103 5103 23S 34 703 729   v4 U:G No BP       Weak M   6.1 0.4 0.4 0.4 48.7 0.8   17.1     0.4   1.9     24.0 263 CG,UG,AG GU,UG,AA
5110 5110 23S 34 707 724   v4 G:U cWW       Weak M 1.1 0.8 1.9 4.2 3.4 0.8 0.4   0.4     0.4         86.8 263 AU,GU GC,CG,UA,AU
5306 5306 23S 37 826 831   v4 U:G cWW       Weak M   1.5 6.1 1.5 0.4 81.4       1.1           0.4 7.6 263 UA,UG AU,UG,CA
5880 5880 23S 42 1051 1108   v4 G:U cWW       Weak M 2.9 16.3 1.8 15.2 0.4 0.4 0.4   0.4 0.4   0.4 0.4   0.4 1.4 59.4 276 GC,CG,AU GC,CG,UA,AU
6125 6125 23S 46 1215 1234   v4 G:U cWW       Weak M     1.4 3.3 8.7           0.4       0.4 0.4 85.5 276 AU,GU UA,GU,CC
6587 6587 23S 54 1415 1587   v4 U:G cWW       Weak M   0.4 1.1 0.7                     0.4   97.5 276   CG,UA,AU
6685 6685 23S 56 1436 1556   v4 G:C cWW       Weak M 0.4     0.4   0.4         0.4         0.4 98.3 276   GC,AU,UG
6699 6699 23S 56 1440 1551   v4 U:A cWW       Weak M 0.4   0.4           0.4               99.0 276   GC,UA,AG
6734 6734 23S 57 1445 1466   v4 G:U cWW       Weak M 0.4 0.4 0.4 0.4   0.7                   0.4 97.4 276   GC,AU,UG
6783 6783 23S 58 1468 1524   v4 U:G cWW       Weak M         0.4                       99.7 276    
6818 6818 23S 58 1478 1513   v4 G:U cWW       Weak M         0.4                       99.7 276    
6839 6839 23S 58 1481 1510   v4 U:G cWW       Weak M         0.4   0.4                   99.4 276   GU,AA
6853 6853 23S 58 1483 1506   v4 G:U cWW       Weak M     0.4             0.7             99.0 276    
7161 7161 23S 63 1707 1751   v4 G:U cWW       Weak M 4.0 0.4   5.1 2.2               1.1       87.4 277 GC,AU,GU GC,CG,AU
7301 7301 23S 64 1770 1982   v4 G:U cWW       Weak M 9.1 47.5 8.0 10.1 0.7 22.8 0.4   0.4 0.4   0.7           276 GC,CG,UA,AU,UG GC,CG,UA,AU
7322 7322 23S 65 1775 1789   v4 U:A tHS       Weak M   2.8 93.6 1.1                       2.5   283 CG,UA,UU CG,UA,AU
7399 7399 23S 66 1799 1820   v4 G:U No BP       Weak M 0.7   0.4 1.8 89.0                       8.1 283 GU UA,GU
7413 7413 23S 66 1803 1814   v4 A:G tHS   3°: base pair   Weak M     1.4 1.8   0.4 3.2 0.4 10.6 0.7   0.4         81.3 283 AA,AG UA,AG,CU
7469 7469 23S 68 1835 1905   v4 G:C cWW       Weak M 95.2   0.3   1.0               0.3       3.2 311 GC GC,UA
7497 7497 23S 68 1841 1901   v4 U:A cWW       Weak M     95.8       0.6     0.3             3.2 311 UA  
7504 7504 23S 68 1842 1898   v4 G:U cWW       Weak M 1.0       94.5               0.6 0.3     3.5 311 GU  
7553 7553 23S 68 1851 1891   v4 U:G cWW       Weak M   1.0 3.5     3.9 1.9   0.3 0.6 0.3   1.0 0.6 1.6 0.3 84.9 311 UA,UG UG,AA,CC
7644 7644 23S 69 1907 1923   v4 G:U cWW       Weak M 1.6 0.6   0.3 94.2                       3.2 311 GU CG,GU
7672 7672 23S 69 1911 1919   v4 U:A No BP       Weak M     96.1                           3.8 311 UA  
7693 7693 23S 71 1945 1961   v4 G:C cWW       Weak M 93.9   0.3   0.3   0.3 0.6         4.5         311 GC,GA GC,AA
7707 7707 23S 71 1947 1959   v4 C:G cWW       Weak M   58.5 7.1 0.3 0.6 32.5                   1.0   311 CG,UA,UG CG,UA,GU
7847 7847 23S 73 2056 2612   v4 G:C cWW       Weak M 92.4     0.4     0.4 1.1     0.4   5.3         262 GC,GA GC,AU
7868 7868 23S 74 2065 2445   v4 C:G cWW       Weak M   95.5 2.9     1.6                       309 CG,UA CG,UA
7931 7931 23S 74 2075 2434   v4 U:A No BP       Weak M   0.3 94.8     1.0 0.6         0.3     0.6 2.3   309 UA,UU CG,UA
7938 7938 23S 75 2077 2243   v4 A:U cWW       Weak M 0.3     96.8 0.3 0.3 0.3           0.3     1.0 0.6 309 AU AU,UG,GA
8064 8064 23S 76 2100 2189   v4 G:U cWW       Weak M 1.0 1.6 4.5 1.3   2.3 1.3                 1.3 86.7 309 UA,UG GC,CG,UA,AU
8127 8127 23S 76 2109 2180   v4 U:U cWW   3°: base pair   Weak M 1.3   3.6 0.6 0.3   0.3         0.3       5.8 87.6 309 UA,UU GC,AA,UU
8162 8162 23S 77 2120 2178   v4 G:C cWW       Weak M 1.3 0.6 1.3 3.6 3.6               0.3     2.6 86.7 309 AU,GU,UU GC,CG,UA,AU
8218 8218 23S 78 2136 2155   v4 G:U cWW       Weak M     1.3 1.0                         97.7 309   UA,AU
8267 8267 23S 78 2143 2148   v4 C:G cWW       Weak M   1.6   0.3 0.3                       97.7 309   CG,AU
8365 8365 23S 80 2249 2255   v4 U:G No BP       Weak M     10.7     87.1       1.6         0.3 0.3   309 UA,UG UG,CA
8449 8449 23S 83 2291 2341   v4 U:G cWW       Weak M 0.3 1.3 1.9 0.3   11.3                     84.7 309 UG GC,AU,UG
8561 8561 23S 85.1 2328 2387   v4 A:U cWW   3°: pseudoknot   Weak M     0.3 14.6                         85.1 309 AU UA,AU
8610 8610 23S 86 2351 2366   v4 G:A cWW   3°: base pair   Weak M   0.3 26.2 4.9     36.2 2.3   4.5   0.3 5.2   1.6 1.0 17.4 309 UA,AU,AA,AC,CA,GA AA,CU,UC
8736 8736 23S 89 2455 2496   v4 G:C cWW       Weak M 12.4 81.0   2.0 3.9           0.3     0.3       306 GC,CG,AU,GU GC,CG,AU
8764 8764 23S 89 2460 2490   v4 U:G cWW       Weak M       3.3   94.4 0.7 0.3       0.3     0.3   0.6 306 AU,UG AU,UG
9023 9023 23S 93 2592 2601   v4 G:C cWW       Weak M 94.7     1.1 1.9           0.8     0.4 0.4   0.8 262 GC GC,AU
9177 9177 23S 95 2652 2668   v4 C:G cWW       Weak M   42.0 11.8 6.9 0.8 4.6 0.8 0.8 0.4 28.2   0.4       2.7 0.8 262 CG,UA,AU,UG,CA,UU CG,UA,AU
9282 9282 23S 96 2696 2711   v4 U:A cWW       Weak M     14.7 0.4                     0.4   84.5 252 UA UA,AU

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");
Powered by Datasette · Queries took 1085.727ms