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

38 rows where conformation = "cWW", group_code = 3 and molecule = "5S" sorted by position_1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: helix_number, reference_base_pair, GU, UG, AA, AC, AG, CA, CC, CU, GA, GG, UC, UU, gap, Seq, predominant_types, covarying_types

strength 2

  • Strong 37
  • Significant 1

molecule 1

  • 5S · 38 ✖

header_format 1

  • v4 38

group_code 1

  • 3 · 38 ✖

conformation 1

  • cWW · 38 ✖

tertiary_type 0

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
1 1 5S 1 1 119   v4 U:A cWW       Strong 3 5.2 0.7 8.7 2.6 0.5 1.3 0.3 0.5 0.3 0.2 0.2 0.2 0.2   0.3 2.3 76.6 611 GC,UA,AU,UU GC,CG,UA,AU
5 5 5S 1 2 118   v4 G:C cWW       Strong 3 20.0 1.8 3.8 3.8 0.5 1.3 0.5 1.8 0.2   0.2 0.2 0.3   0.7 0.7 64.4 610 GC,UA,AU GC,CG,UA,AU
9 9 5S 1 3 117   v4 C:G cWW       Strong 3 27.2 23.4 9.0 23.3 0.7 9.6 0.3 0.7 0.2   0.2 0.2 0.2 0.2 0.7 0.7 3.7 602 GC,CG,UA,AU,UG GC,CG,UA,AU
13 13 5S 1 4 116   v4 C:G cWW       Strong 3 9.1 46.2 13.0 2.5 5.6 13.4   0.2 0.2 0.2 0.3 0.2 0.3 0.3 0.2 6.9 1.5 606 GC,CG,UA,AU,GU,UG,UU GC,CG,UA,AU
17 17 5S 1 5 115   v4 U:A cWW       Strong 3 8.6 31.1 41.8 11.0 0.3 3.8 0.2   1.2 0.7           0.2 1.3 608 GC,CG,UA,AU,UG GC,CG,UA,AU
21 21 5S 1 6 114   v4 G:C cWW       Strong 3 47.8 7.1 33.2 9.4 1.0 0.7 0.2 0.3       0.2         0.3 609 GC,CG,UA,AU GC,CG,UA,AU
25 25 5S 1 7 113   v4 G:C cWW       Strong 3 59.0 1.3 4.4 33.9 0.8 0.2   0.2         0.2         610 GC,UA,AU GC,CG,UA,AU
29 29 5S 1 8 112   v4 C:G cWW       Strong 3 2.5 70.0 0.5 0.7 0.3 25.9         0.2             611 GC,CG,UG GC,CG,UA,AU
33 33 5S 1 9 111   v4 G:U cWW       Strong 3 42.5 0.7 0.3 2.5 52.5 0.2   0.2         0.5       0.8 610 GC,AU,GU CG,UA,GU,AC
37 37 5S 1 10 110   v4 G:C cWW       Strong 3 51.1 2.5 5.6 32.6 5.2 0.3 0.7 1.1 0.2 0.2         0.2 0.2 0.3 611 GC,CG,UA,AU,GU GC,CG,UA,AU
41 41 5S 2 16 68   v4 G:C cWW       Strong 3 57.5 32.5 7.9 0.7 0.7 0.7   0.2                   610 GC,CG,UA GC,CG,UA,AU
45 45 5S 2 17 67   v4 C:G cWW       Strong 3 9.0 69.9 7.7 5.7   3.1 0.2     3.9     0.2 0.3       611 GC,CG,UA,AU,UG,CA GC,CG,UA,AU
49 49 5S 2 18 65   v4 G:U cWW       Strong 3 36.0 3.9 5.4 42.7 9.7 0.2 0.5 0.8   0.2 0.2 0.2 0.3         611 GC,CG,UA,AU,GU GC,CG,UA,AU
53 53 5S 2 19 64   v4 C:G cWW       Strong 3 23.0 30.2 18.9 23.0 1.3 0.8 0.2 0.5 0.3 0.7 0.5     0.3 0.2 0.2   609 GC,CG,UA,AU GC,CG,UA,AU
57 57 5S 2 20 63   v4 G:C cWW       Strong 3 36.1 23.6 14.9 18.4 3.0 0.7   0.8     0.2       0.8 1.5   609 GC,CG,UA,AU,GU GC,CG,UA,AU
61 61 5S 2 21 62   v4 G:C cWW       Strong 3 37.2 17.5 19.0 16.9 2.6 3.6   1.1 0.3 0.3 0.2 0.2 0.2 0.2   0.7   610 GC,CG,UA,AU,GU,UG GC,CG,UA,AU
65 65 5S 2 22 61   v4 U:G cWW       Strong 3 25.7 10.2 29.2 16.2 0.7 15.2   0.2 0.3   0.2     1.6 0.2 0.3   610 GC,CG,UA,AU,UG GC,CG,UA,AU
69 69 5S 2 23 60   v4 G:C cWW       Strong 3 79.5 0.8 0.2 1.1 1.6 0.5   1.6 0.2   0.3 1.0 2.1 0.5 8.9 1.5 0.2 609 GC,GA,UC GC,CG,UU
73 73 5S 2 28 56   v4 C:G cWW       Strong 3 0.2 20.9   2.3 0.5 0.7   0.3   0.3 2.8 62.2   0.2 7.7 2.0   611 CG,AU,CC,CU,UC CU,GG,UC
77 77 5S 2 29 55   v4 A:U cWW       Strong 3 10.5   5.9 83.3 0.2     0.2                   611 GC,UA,AU GC,UA,AU
81 81 5S 2 30 54   v4 C:G cWW       Strong 3 2.8 94.9 1.6 0.2   0.2         0.2     0.2       611 GC,CG GC,CG,UA,AU
85 85 5S 2 31 51   v4 C:G cWW       Strong 3 5.2 85.3 4.1 0.3 0.2 0.5 0.7     2.0 0.2 0.8 0.2   0.7     611 GC,CG,UA GC,CG,UA,AU
89 89 5S 2 32 50   v4 U:A cWW       Strong 3 33.8 38.4 22.0 4.6   0.8     0.2 0.2 0.2             610 GC,CG,UA,AU GC,CG,UA,AU
93 93 5S 2 33 49   v4 G:C cWW       Strong 3 70.7 21.1 2.3 4.3 0.2 1.1               0.3       611 GC,CG,UA,AU GC,CG,UA,AU
97 97 5S 2 34 48   v4 A:U cWW       Strong 3 9.8   32.9 57.0 0.2                   0.2     611 GC,UA,AU GC,UA,AU
101 101 5S 3 70 106   v4 C:G cWW       Strong 3 9.2 78.2 5.1 1.6   0.5 1.1     0.2         0.3 3.8   610 GC,CG,UA,UU GC,CG,UA,AU
105 105 5S 3 71 105   v4 C:G cWW       Strong 3 8.9 66.7 9.7 3.1 1.0 8.2     0.2     0.2       2.1   609 GC,CG,UA,AU,UG,UU GC,CG,UA,AU
109 109 5S 3 72 104   v4 G:A cWW       Strong 3 7.7 14.8 15.6 10.0 1.1 4.8 7.4 0.3   0.5 0.8   34.9   0.5 1.1 0.5 610 GC,CG,UA,AU,UG,AA,GA CG,AU,GA,UC
113 113 5S 3 73 103   v4 A:U cWW       Strong 3 31.0 5.6 3.6 57.0 0.8 1.5   0.2         0.2       0.2 610 GC,CG,UA,AU GC,CG,UA,AU
117 117 5S 3 74 102   v4 U:G cWW       Strong 3 36.8 2.8 1.1 2.9 0.8 37.5 3.3 9.2 0.2 3.1   0.5 0.2 0.3 0.3 1.0   611 GC,CG,AU,UG,AA,AC,CA GC,UG,AA,CU
137 137 5S 3 79 97   v4 G:C cWW       Strong 3 15.9 66.2 2.0 0.5 15.1     0.2               0.2   610 GC,CG,GU GC,CG,UA,AU
141 141 5S 3 80 96   v4 U:G cWW       Significant 3 0.3 8.5 0.2   0.2 89.2           0.2   0.2 0.2 1.1   611 CG,UG GC,UG,CU
145 145 5S 3 81 95   v4 G:U cWW       Strong 3 17.4 2.0 3.9 17.7 28.7     3.0 0.3   1.0 0.7     3.9 21.1 0.3 610 GC,UA,AU,GU,AC,UC,UU CG,UA,GU,AC
149 149 5S 3 82 94   v4 U:A cWW       Strong 3 34.7 27.5 22.5 9.5 1.2 1.6     0.3   0.2 0.2 0.2   1.3 0.2 0.7 608 GC,CG,UA,AU GC,CG,UA,AU
153 153 5S 3 83 93   v4 G:C cWW       Strong 3 71.5 5.2 1.0 15.5 2.5       0.2 0.7 0.2   0.5 0.2 0.2 0.3 2.1 611 GC,CG,AU,GU GC,CG,UA,AU
157 157 5S 3 84 92   v4 G:C cWW       Strong 3 24.5 7.5 6.2 9.8 0.8 3.1 0.5 1.0 14.6 0.2   0.2 23.9 2.0 0.2 0.5 5.1 611 GC,CG,UA,AU,UG,AG,GA GC,UA,AG,CU
161 161 5S 3 85 91   v4 G:C cWW       Strong 3 64.6 17.8 0.3 2.1 2.9 2.3   1.3   0.2         0.8 0.2 7.4 611 GC,CG,AU,GU,UG GC,CG,UA,AU
165 165 5S 3 86 90   v4 G:C cWW       Strong 3 65.6 7.0 0.2 3.1 1.0 1.6           0.2     0.2 1.0 20.1 611 GC,CG,AU GC,CG,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 404.212ms