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).

35 rows where strength = "Weak" and tertiary_type = "3°: base pair" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: helix_number, position_1, position_2, reference_base_pair, CG, UA, AU, GU, UG, AC, AG, CA, CU, GG, UC, UU, gap, Seq, predominant_types, covarying_types

group_code 7

  • 3 5
  • A 5
  • B 5
  • C 5
  • E 5
  • M 5
  • T 5

molecule 2

  • 23S 28
  • 16S 7

conformation 2

  • cWW 28
  • tHS 7

tertiary_type 1

  • 3°: base pair · 35 ✖

strength 1

  • Weak · 35 ✖

header_format 1

  • v4 35
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
435 435 16S 6 68 101   v4 G:A cWW   3°: base pair   Weak T 3.1 0.3 13.9 0.7 0.3 0.3 0.2   0.1 0.2     68.8 0.4   0.2 11.6 6584 GC,UA,GA AU,UG,GA
436 436 16S 6 68 101   v4 G:A cWW   3°: base pair   Weak 3 3.4 0.3 16.3 0.7 0.2 0.3 0.2   0.1 0.3     77.1 0.4   0.2 0.6 5599 GC,UA,GA CG,AU,GA
437 437 16S 6 68 101   v4 G:A cWW   3°: base pair   Weak B 0.7   0.1   0.2 0.3 0.2     0.3     97.0 0.5     0.6 4427 GA UG,GA
438 438 16S 6 68 101   v4 G:A cWW   3°: base pair   Weak A 78.9     6.0 0.5 1.0             11.6 0.5     1.5 199 GC,AU,GA GC,AU,UG
439 439 16S 6 68 101   v4 G:A cWW   3°: base pair   Weak C 1.8   2.4 0.6 0.6               92.7 1.8       164 UA,GA AU,GA
440 440 16S 6 68 101   v4 G:A cWW   3°: base pair   Weak E   1.5 93.1 2.6   0.3 0.2   0.2 0.2   0.1 0.2 0.1   1.3 0.1 973 UA,AU CG,UA,AU
441 441 16S 6 68 101   v4 G:A cWW   3°: base pair   Weak M 1.2   0.4 0.7 1.2       0.1       6.9 0.1   0.1 89.2 830 GA AU,GA
4628 4628 23S 25 538 555   v4 A:G cWW   3°: base pair   Weak T 11.9 0.6 0.3 3.7 6.4 3.1 2.7   43.4     0.1 0.1 0.2   1.4 26.1 881 GC,AU,GU,UG,AA,AG GC,AG,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
4630 4630 23S 25 538 555   v4 A:G cWW   3°: base pair   Weak B         0.7   1.1   97.5         0.4     0.4 281 AG GU,AG
4631 4631 23S 25 538 555   v4 A:G cWW   3°: base pair   Weak A 70.3     5.4 24.3                         37 GC,AU,GU GC,AU
4632 4632 23S 25 538 555   v4 A:G cWW   3°: base pair   Weak C       1.0     5.0   94.0                 100 AA,AG  
4633 4633 23S 25 538 555   v4 A:G cWW   3°: base pair   Weak E 38.2 2.4   9.2 20.8 13.0               0.5   5.8 10.1 207 GC,CG,AU,GU,UG,UU GC,AU,UG
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
7407 7407 23S 66 1803 1814   v4 A:G tHS   3°: base pair   Weak T 0.5 0.4 0.6 1.5 20.2 0.1 7.6 2.6 37.5 0.2 0.1 0.1       0.2 28.2 840 GU,AA,AC,AG UA,GU,AG,CC
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
7409 7409 23S 66 1803 1814   v4 A:G tHS   3°: base pair   Weak B       0.4     0.4 0.4 98.5               0.4 259 AG  
7410 7410 23S 66 1803 1814   v4 A:G tHS   3°: base pair   Weak A         75.6     17.1     2.4         4.9   41 GU,AC,CC,UU GU,AC
7411 7411 23S 66 1803 1814   v4 A:G tHS   3°: base pair   Weak C       4.0     53.5 11.9 29.7               1.0 101 AU,AA,AC,AG  
7412 7412 23S 66 1803 1814   v4 A:G tHS   3°: base pair   Weak E 2.6 1.9 0.6 1.9 89.1     0.6                 3.2 156 GC,GU CG,UA,GU,AC
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
8121 8121 23S 76 2109 2180   v4 U:U cWW   3°: base pair   Weak T 18.1   3.9 0.5 0.1 1.2 0.1     0.4   0.4     0.6 42.7 32.0 847 GC,UA,UU GC,CA,UU
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
8123 8123 23S 76 2109 2180   v4 U:U cWW   3°: base pair   Weak B                       0.4       99.6   241 UU  
8124 8124 23S 76 2109 2180   v4 U:U cWW   3°: base pair   Weak A     53.7     14.6       7.3         9.8 14.6   41 UA,UG,CA,UC,UU  
8125 8125 23S 76 2109 2180   v4 U:U cWW   3°: base pair   Weak C       1.0               1.0     1.0 97.0   101 UU  
8126 8126 23S 76 2109 2180   v4 U:U cWW   3°: base pair   Weak E 96.1     0.6   2.6                     0.6 155 GC,UG GC,AU,UG
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
8604 8604 23S 86 2351 2366   v4 G:A cWW   3°: base pair   Weak T 4.9 0.8 10.5 4.6 1.1 0.2 26.9 0.8 0.1 1.6   0.1 40.8 0.1 0.6 0.4 6.4 849 GC,UA,AU,AA,GA CG,AU,GA,UC
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
8606 8606 23S 86 2351 2366   v4 G:A cWW   3°: base pair   Weak B 0.8       0.8   12.8   0.4       84.3 0.4     0.4 242 AA,GA AG,GA
8607 8607 23S 86 2351 2366   v4 G:A cWW   3°: base pair   Weak A 36.6   4.9 48.8 9.8                         41 GC,UA,AU,GU GC,UA,AU
8608 8608 23S 86 2351 2366   v4 G:A cWW   3°: base pair   Weak C             83.3           16.7         102 AA,GA  
8609 8609 23S 86 2351 2366   v4 G:A cWW   3°: base pair   Weak E 16.1 3.9 3.9 2.6 1.9 1.3             70.3         155 GC,CG,UA,AU,GA CG,AU,GA
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

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