RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA432257", 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 · 8 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 8 ✖

bioproject 1

  • PRJNA432257 · 8 ✖

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
27360448 27360448 PRJNA432257_S_NODE_52163_length_227_cov_41.784211_g51782_i0 PRJNA432257 52163 227 41.784211 94.85015897 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 41.6 0.0468   NR MBI2072291.1 2026742 g51782 i0 40 0.52863436123348 40 24 52.9 0 198 79 97 136 MBI2072291.1 hypothetical protein [Gemmatimonadota bacterium] diamond 120 41.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27724433 27724433 PRJNA432257_S_NODE_63924_length_211_cov_1.367816_g63543_i0 PRJNA432257 63924 211 1.367816 2.88609176 Longimicrobium 1804994 Bacteria Bacteria 42.7 0.00369   NR MBW3573041.1 2026742 g63543 i0 60.6 2.16113744075829 33 13 46.9 0 201 103 25 57 MBW3573041.1 CsbD family protein [Gemmatimonadota bacterium] diamond 456 42.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28939106 28939106 PRJNA432257_S_NODE_107208_length_169_cov_3.977273_g106827_i0 PRJNA432257 107208 169 3.977273 6.72159137 Longimicrobium sp. 2029185 Bacteria Bacteria 39.7 0.0314   NR HEX6368234.1 2029185 g106827 i0 48.4 1.10059171597633 31 16 55 0 116 24 39 69 HEX6368234.1 hypothetical protein [Longimicrobium sp.] diamond 186 39.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
30029198 30029198 PRJNA432257_S_NODE_82711_length_190_cov_34.973856_g82330_i0 PRJNA432257 82711 190 34.973856 66.4503264 Pseudomonadati 3379134 Bacteria Bacteria 60.8 7.51e-9   NR HEX9691098.1 2448054 g82330 i0 65.8 1.81578947368421 38 13 60 0 8 121 434 471 HEX9691098.1 glycosyltransferase [Gemmatimonadales bacterium] diamond 345 61.2 0.993464052287582 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30265673 30265673 PRJNA432257_S_NODE_56152_length_221_cov_8.744565_g55771_i0 PRJNA432257 56152 221 8.744565 19.32548865 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 53.1 6.02e-6   NR HEX9582062.1 2448054 g55771 i0 54.9 0.692307692307692 51 21 69.2 1 2 154 502 550 HEX9582062.1 hypothetical protein [Gemmatimonadales bacterium] diamond 153 53.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31750808 31750808 PRJNA432257_S_NODE_31077_length_275_cov_268.025210_g30696_i0 PRJNA432257 31077 275 268.02521 737.0693275 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 51.2 4.31e-5   NR HEX6314514.1 2026741 g30696 i0 50 1.18909090909091 54 27 58.9 0 75 236 14 67 HEX6314514.1 isoprenylcysteine carboxylmethyltransferase family protein [Gemmatimonadaceae bacterium] diamond 327 51.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31972326 31972326 PRJNA432257_S_NODE_124738_length_153_cov_1.181034_g124357_i0 PRJNA432257 124738 153 1.181034 1.80698202 Longimicrobium sp. 2029185 Bacteria Bacteria 54.3 8.85e-7   NR HEX2205056.1 2029185 g124357 i0 56.1 0.803921568627451 41 18 80.4 0 125 3 72 112 HEX2205056.1 methyl-accepting chemotaxis protein [Longimicrobium sp.] diamond 123 54.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
32699378 32699378 PRJNA432257_S_NODE_62020_length_213_cov_6.761364_g61639_i0 PRJNA432257 62020 213 6.761364 14.40170532 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 102 4.01e-25   NR MCX5755675.1 2026742 g61639 i0 100 0.774647887323944 55 0 77.5 0 179 15 169 223 MCX5755675.1 heme exporter protein CcmB [Gemmatimonadota bacterium] diamond 165 102 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);;