home / crw2

Nucleotide frequency tables (all versions)

5 rows where category = "MODEL", format = "xlsx" and molecule = "16S"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: subtype, version, is_latest_in_format

is_latest 2

  • yes 3
  • no 2

molecule 1

  • 16S · 5 ✖

format 1

  • xlsx · 5 ✖

category 1

  • MODEL · 5 ✖
Link rowid ▼ molecule category subtype version is_latest is_latest_in_format is_supporting format relative_path raw_filename url
55 55 16S MODEL BP 2 no no no xlsx freqtable/xlsx/16S-MODEL-BP.combined.v2.xlsx 16S-MODEL-BP.combined.v2.xlsx https://staging.crw2.org/data/freqtable/xlsx/16S-MODEL-BP.combined.v2.xlsx
56 56 16S MODEL BP 3 no no no xlsx freqtable/xlsx/16S-MODEL-BP.combined.v3.xlsx 16S-MODEL-BP.combined.v3.xlsx https://staging.crw2.org/data/freqtable/xlsx/16S-MODEL-BP.combined.v3.xlsx
57 57 16S MODEL BP 4 yes yes no xlsx freqtable/xlsx/16S-MODEL-BP.combined.v4.xlsx 16S-MODEL-BP.combined.v4.xlsx https://staging.crw2.org/data/freqtable/xlsx/16S-MODEL-BP.combined.v4.xlsx
58 58 16S MODEL SB 1 yes yes no xlsx freqtable/xlsx/16S-MODEL-SB.xlsx 16S-MODEL-SB.xlsx https://staging.crw2.org/data/freqtable/xlsx/16S-MODEL-SB.xlsx
59 59 16S MODEL TR 1 yes yes no xlsx freqtable/xlsx/16S-MODEL-TR.xlsx 16S-MODEL-TR.xlsx https://staging.crw2.org/data/freqtable/xlsx/16S-MODEL-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);
Powered by Datasette · Queries took 68.196ms