Nucleotide frequency tables (all versions)

6 rows where format = "xlsx", is_latest = "yes" and molecule = "23S"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: subtype, version

category 3

molecule 1

is_latest 1

format 1

  • xlsx · 6 ✖
Link rowid ▼ molecule category subtype version is_latest is_latest_in_format is_supporting format relative_path raw_filename url
62 62 23S LOUSY BP 1 yes yes no xlsx freqtable/xlsx/23S-LOUSY-BP.xlsx 23S-LOUSY-BP.xlsx https://staging.crw2.org/data/freqtable/xlsx/23S-LOUSY-BP.xlsx
65 65 23S MODEL BP 4 yes yes no xlsx freqtable/xlsx/23S-MODEL-BP.combined.v4.xlsx 23S-MODEL-BP.combined.v4.xlsx https://staging.crw2.org/data/freqtable/xlsx/23S-MODEL-BP.combined.v4.xlsx
66 66 23S MODEL SB 1 yes yes no xlsx freqtable/xlsx/23S-MODEL-SB.xlsx 23S-MODEL-SB.xlsx https://staging.crw2.org/data/freqtable/xlsx/23S-MODEL-SB.xlsx
67 67 23S MODEL TR 1 yes yes no xlsx freqtable/xlsx/23S-MODEL-TR.xlsx 23S-MODEL-TR.xlsx https://staging.crw2.org/data/freqtable/xlsx/23S-MODEL-TR.xlsx
68 68 23S TENT BP 1 yes yes no xlsx freqtable/xlsx/23S-TENT-BP.xlsx 23S-TENT-BP.xlsx https://staging.crw2.org/data/freqtable/xlsx/23S-TENT-BP.xlsx
69 69 23S TENT TR 1 yes yes no xlsx freqtable/xlsx/23S-TENT-TR.xlsx 23S-TENT-TR.xlsx https://staging.crw2.org/data/freqtable/xlsx/23S-TENT-TR.xlsx

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "nucleotide_frequency_tables" (
   "molecule" TEXT,
   "category" TEXT,
   "subtype" TEXT,
   "version" INTEGER,
   "is_latest" TEXT,
   "is_latest_in_format" TEXT,
   "is_supporting" TEXT,
   "format" TEXT,
   "relative_path" TEXT,
   "raw_filename" TEXT
, "url" TEXT);