RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA421571" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA421571 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
27818939 27818939 PRJNA421571_P_NODE_86904_length_261_cov_1.617021_g84355_i0 PRJNA421571 86904 261 1.617021 4.22042481 FCB group 1783270 Bacteria Bacteria 100 1.77e-22   NR HEX6368133.1 2029185 g84355 i0 65.1 14.1494252873563 86 30 98.9 0 1 258 281 366 HEX6368133.1 S8 family peptidase [Longimicrobium sp.] diamond 3693 100 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
28054698 28054698 PRJNA421571_P_NODE_80085_length_277_cov_1.132353_g77536_i0 PRJNA421571 80085 277 1.132353 3.13661781 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 44.7 0.0111   NR MDP9177279.1 2026742 g77536 i0 33.9 0.671480144404332 62 41 67.1 0 6 191 25 86 MDP9177279.1 DUF4388 domain-containing protein [Gemmatimonadota bacterium] diamond 186 44.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28938955 28938955 PRJNA421571_P_NODE_27768_length_627_cov_1.913357_g25264_i0 PRJNA421571 27768 627 1.913357 11.99674839 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 46.2 0.0494   NR MCC7054114.1 2026741 g25264 i0 37.5 0.30622009569378 64 39 30.1 1 3 191 271 334 MCC7054114.1 glycosyltransferase [Gemmatimonadaceae bacterium] diamond 192 46.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29317707 29317707 PRJNA421571_P_NODE_79069_length_279_cov_1.495146_g76520_i0 PRJNA421571 79069 279 1.495146 4.17145734 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 57 5.31e-7   NR HEV2671960.1 2448054 g76520 i0 45.9 4.08602150537634 74 39 78.5 1 2 220 250 323 HEV2671960.1 ankyrin repeat domain-containing protein [Gemmatimonadales bacterium] diamond 1140 57 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31149485 31149485 PRJNA421571_P_NODE_80735_length_275_cov_1.485149_g78186_i0 PRJNA421571 80735 275 1.485149 4.08415975 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 43.5 0.0297   NR PYP47601.1 2026742 g78186 i0 40 0.818181818181818 75 38 78.5 3 50 265 385 455 PYP47601.1 MAG: hypothetical protein DMD50_03710 [Gemmatimonadota bacterium] diamond 225 43.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31292859 31292859 PRJNA421571_P_NODE_107255_length_239_cov_2.783133_g104706_i0 PRJNA421571 107255 239 2.783133 6.65168787 Bacteria 2 Bacteria Bacteria 99.4 5.229999999999999e-24   NR MYA11881.1 2026742 g104706 i0 63.9 15.5271966527197 72 25 90.4 1 232 17 24 94 MYA11881.1 peptidylprolyl isomerase [Gemmatimonadota bacterium] diamond 3711 99.4 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);;