RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA893346", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 3 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 3 ✖

bioproject 1

  • PRJNA893346 · 3 ✖

analysis 1

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
27094963 27094963 PRJNA893346_P_NODE_19462_length_349_cov_1.880435_g18973_i0 PRJNA893346 19462 349 1.880435 6.56271815 Gemmatimonadota 142182 Bacteria Bacteria 60.8 3.1e-8   NR HEU4788014.1 2026741 g18973 i0 37.2 6.16332378223496 86 51 73.9 1 261 4 40 122 HEU4788014.1 S8 family serine peptidase [Gemmatimonadaceae bacterium] diamond 2151 61.2 0.993464052287582 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27971561 27971561 PRJNA893346_P_NODE_15005_length_401_cov_2.841463_g14517_i0 PRJNA893346 15005 401 2.841463 11.39426663 Longimicrobium sp. 2029185 Bacteria Bacteria 65.5 2.28e-9   NR HLL84869.1 2029185 g14517 i0 39.4 0.778054862842893 104 48 77.8 2 319 8 42 130 HLL84869.1 S8 family peptidase [Longimicrobium sp.] diamond 312 65.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
28445384 28445384 PRJNA893346_P_NODE_35846_length_247_cov_0.885057_g35356_i0 PRJNA893346 35846 247 0.885057 2.18609079 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 54.3 3.12e-6   NR MBT4977118.1 2026742 g35356 i0 50 1.55465587044534 64 31 76.5 1 191 3 3 66 MBT4977118.1 galactokinase [Gemmatimonadota bacterium] diamond 384 54.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;