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

21 rows where conformation = "cWW" and tertiary_type = "3°: base triple" 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, AU, GU, AC, GA, UU, Seq, predominant_types, covarying_types

group_code 7

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

tertiary_type 1

  • 3°: base triple · 21 ✖

strength 1

  • Strong 21

molecule 1

  • 23S 21

header_format 1

  • v4 21

conformation 1

  • cWW · 21 ✖
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
5174 5174 23S 35 740 757   v4 C:G cWW   3°: base triple   Strong T 0.2 29.0 1.7 6.5 19.5   0.8 1.1   0.5 0.9 0.2     1.2 37.4 0.9 887 CG,AU,GU,UU CG,AC,UU
5175 5175 23S 35 740 757   v4 C:G cWW   3°: base triple   Strong 3   28.2   0.2 6.9   1.1 1.1     1.0 0.4     1.9 58.0 1.2 524 CG,GU,UU CG,AA,UU
5176 5176 23S 35 740 757   v4 C:G cWW   3°: base triple   Strong B   52.5     5.0   2.1 0.7     1.8 0.7     3.2 33.7 0.4 282 CG,GU,AA,UC,UU CG,AA,UU
5177 5177 23S 35 740 757   v4 C:G cWW   3°: base triple   Strong A       2.7 56.8                     27.0 13.5 37 AU,GU,UU  
5178 5178 23S 35 740 757   v4 C:G cWW   3°: base triple   Strong C   92.0               4.0         1.0 3.0   100 CG,CA,UU CG,UU
5179 5179 23S 35 740 757   v4 C:G cWW   3°: base triple   Strong E         0.5     2.0             0.5 97.1   205 AC,UU AC,UU
5180 5180 23S 35 740 757   v4 C:G cWW   3°: base triple   Strong M 0.8 6.5 5.7 21.7 52.1   0.4 1.5     1.1         9.5 0.8 263 CG,UA,AU,GU,UU CG,UA,GU,AC
7722 7722 23S 71 1950 1956   v4 G:U cWW   3°: base triple   Strong T   0.2 13.0 0.4 44.2 9.8 2.0 2.9 0.8 25.4     0.2     1.1   848 UA,GU,UG,AA,AC,CA GU,UG,AC,CA
7723 7723 23S 71 1950 1956   v4 G:U cWW   3°: base triple   Strong 3     3.4 0.2 58.5 2.8 1.4     32.1     0.5     1.1   436 UA,GU,UG,CA GU,UG,CA
7724 7724 23S 71 1950 1956   v4 G:U cWW   3°: base triple   Strong B     4.6   94.2         0.8     0.4         240 UA,GU UA,GU
7725 7725 23S 71 1950 1956   v4 G:U cWW   3°: base triple   Strong A     9.8   58.5 17.1 14.6                     41 UA,GU,UG,AA GU,UG,AA
7726 7726 23S 71 1950 1956   v4 G:U cWW   3°: base triple   Strong C         98.0     2.0                   101 GU,AC GU,AC
7727 7727 23S 71 1950 1956   v4 G:U cWW   3°: base triple   Strong E       0.6 3.2 3.2       89.0     0.6     3.2   155 GU,UG,CA,UU GU,UG,CA
7728 7728 23S 71 1950 1956   v4 G:U cWW   3°: base triple   Strong M   0.6 30.5 0.6 6.8 22.8 3.5 7.4 2.3 24.1           1.3   311 UA,GU,UG,AA,AC,AG,CA CG,UA,GU,AC
7848 7848 23S 73 2057 2611   v4 G:C cWW   3°: base triple   Strong T 40.9 2.6 0.1 54.9 1.1     0.3         0.1         727 GC,CG,AU GC,CG,UA,AU
7849 7849 23S 73 2057 2611   v4 G:C cWW   3°: base triple   Strong 3 51.7 4.6 0.2 43.0       0.5                   412 GC,CG,AU GC,CG,UA,AU
7850 7850 23S 73 2057 2611   v4 G:C cWW   3°: base triple   Strong B 90.3     8.9       0.8                   236 GC,AU GC,AU
7851 7851 23S 73 2057 2611   v4 G:C cWW   3°: base triple   Strong A   46.3 2.4 51.2                           41 CG,UA,AU CG,UA,AU
7852 7852 23S 73 2057 2611   v4 G:C cWW   3°: base triple   Strong C 100.0                                 53 GC  
7853 7853 23S 73 2057 2611   v4 G:C cWW   3°: base triple   Strong E       100.0                           135 AU  
7854 7854 23S 73 2057 2611   v4 G:C cWW   3°: base triple   Strong M 11.8     84.7 3.1               0.4         262 GC,AU,GU GC,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 757.506ms