RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA380416" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA380416 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
15704711 15704711 PRJNA380416_P_NODE_11413_length_167_cov_0.864407_g11266_i0 PRJNA380416 11413 167 0.864407 1.44355969 Paenimyroides aestuarii 2968490 Bacteria Bacteria 93.2 1.3e-20   NR WP_257500167.1 2968490 g11266 i0 86.3 1.81437125748503 51 7 91.6 0 6 158 358 408 WP_257500167.1 GTPase HflX [Paenimyroides aestuarii] diamond 303 93.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Paenimyroides Paenimyroides aestuarii
27028782 27028782 PRJNA380416_P_NODE_13122_length_163_cov_0.894737_g12975_i0 PRJNA380416 13122 163 0.894737 1.45842131 Flavobacterium 237 Bacteria Bacteria 109 4.59e-29   NR WP_396163939.1 239 g12975 i0 98.1 6.80981595092025 53 1 97.5 0 3 161 19 71 WP_396163939.1 GNAT family N-acetyltransferase, partial [Flavobacterium sp.] diamond 1110 109 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
27391254 27391254 PRJNA380416_P_NODE_12163_length_165_cov_0.879310_g12016_i0 PRJNA380416 12163 165 0.87931 1.4508615 Haliscomenobacter sp. 2717303 Bacteria Bacteria 45.1 0.00136   NR WP_353480152.1 2717303 g12016 i0 43.8 2.69090909090909 48 27 87.3 0 154 11 31 78 WP_353480152.1 GIY-YIG nuclease family protein [Haliscomenobacter sp.] diamond 444 45.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Haliscomenobacteraceae Haliscomenobacter Haliscomenobacter sp.
27422903 27422903 PRJNA380416_P_NODE_11463_length_167_cov_0.864407_g11316_i0 PRJNA380416 11463 167 0.864407 1.44355969 Bacteroidota bacterium 1898104 Bacteria Bacteria 64.3 3.07e-11   NR RMF20796.1 1898104 g11316 i0 51 2.67664670658683 49 24 88 0 21 167 3 51 RMF20796.1 MAG: VOC family protein [Bacteroidota bacterium] diamond 447 64.3 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28054031 28054031 PRJNA380416_P_NODE_11785_length_166_cov_0.871795_g11638_i0 PRJNA380416 11785 166 0.871795 1.4471797 Niabella sp. 1962976 Bacteria Bacteria 50.4 2.43e-5   NR WP_300601877.1 1962976 g11638 i0 48.1 0.939759036144578 52 27 94 0 165 10 138 189 WP_300601877.1 NAD(P)/FAD-dependent oxidoreductase [Niabella sp.] diamond 156 50.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Niabella Niabella sp.
28401468 28401468 PRJNA380416_P_NODE_13526_length_162_cov_0.902655_g13379_i0 PRJNA380416 13526 162 0.902655 1.4623011 Sphingobacteriia bacterium 2035813 Bacteria Bacteria 110 1.92e-28   NR MBN8837013.1 2035813 g13379 i0 100 1 54 0 100 0 1 162 27 80 MBN8837013.1 LUD domain-containing protein [Sphingobacteriia bacterium] diamond 162 110 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia       Sphingobacteriia bacterium
28576297 28576297 PRJNA380416_P_NODE_12327_length_165_cov_0.879310_g12180_i0 PRJNA380416 12327 165 0.87931 1.4508615 Chitinophagaceae 563835 Bacteria Bacteria 95.1 4.52e-21   NR MBX9782077.1 1869212 g12180 i0 81.5 9.81818181818182 54 10 98.2 0 2 163 132 185 MBX9782077.1 VCBS repeat-containing protein [Chitinophagaceae bacterium] diamond 1620 95.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
28811597 28811597 PRJNA380416_P_NODE_13648_length_162_cov_0.849558_g13501_i0 PRJNA380416 13648 162 0.849558 1.37628396 Aurantibacillus circumpalustris 3036359 Bacteria Bacteria 41.2 0.0457   NR WP_317899087.1 3036359 g13501 i0 38.9 1 54 32 98.1 1 1 159 47 100 WP_317899087.1 glycine-rich protein [Aurantibacillus circumpalustris] diamond 162 41.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Aurantibacillaceae Aurantibacillus Aurantibacillus circumpalustris
29664047 29664047 PRJNA380416_P_NODE_12930_length_163_cov_0.894737_g12783_i0 PRJNA380416 12930 163 0.894737 1.45842131 Cloacibacterium normanense 237258 Bacteria Bacteria 107 3.99e-26   NR WP_374451376.1 237258 g12783 i0 100 0.975460122699387 53 0 97.5 0 161 3 183 235 WP_374451376.1 glycosyltransferase [Cloacibacterium normanense] diamond 159 107 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Cloacibacterium Cloacibacterium normanense
29727274 29727274 PRJNA380416_P_NODE_14050_length_161_cov_0.910714_g13903_i0 PRJNA380416 14050 161 0.910714 1.46624954 Spirosoma foliorum 2710596 Bacteria Bacteria 56.2 1.69e-7   NR WP_182462686.1 2710596 g13903 i0 48.1 4.90062111801242 52 27 96.9 0 158 3 91 142 WP_182462686.1 phosphoribosyltransferase family protein [Spirosoma foliorum] diamond 789 56.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae Spirosoma Spirosoma foliorum
29758991 29758991 PRJNA380416_P_NODE_13891_length_161_cov_0.910714_g13744_i0 PRJNA380416 13891 161 0.910714 1.46624954 Sphingobacteriia bacterium 2035813 Bacteria Bacteria 87.8 1.61e-18   NR MBN8838162.1 2035813 g13744 i0 100 0.801242236024845 43 0 80.1 0 1 129 794 836 MBN8838162.1 ligase-associated DNA damage response DEXH box helicase [Sphingobacteriia bacterium] diamond 129 87.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia       Sphingobacteriia bacterium
30186696 30186696 PRJNA380416_P_NODE_11352_length_167_cov_0.864407_g11205_i0 PRJNA380416 11352 167 0.864407 1.44355969 Bacteria 2 Bacteria Bacteria 86.3 2.94e-18   NR MDN5329286.1 2030927 g11205 i0 66.7 1.8502994011976 51 17 91.6 0 12 164 129 179 MDN5329286.1 hypothetical protein [Bacteroidales bacterium] diamond 309 86.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
30201173 30201173 PRJNA380416_P_NODE_13452_length_162_cov_0.902655_g13305_i0 PRJNA380416 13452 162 0.902655 1.4623011 Haliscomenobacter sp. 2717303 Bacteria Bacteria 44.7 0.00129   NR WP_324496331.1 2717303 g13305 i0 55.9 0.62962962962963 34 15 63 0 154 53 116 149 WP_324496331.1 response regulator transcription factor [Haliscomenobacter sp.] diamond 102 44.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Haliscomenobacteraceae Haliscomenobacter Haliscomenobacter sp.
30264910 30264910 PRJNA380416_P_NODE_3552_length_319_cov_5.088889_g3405_i0 PRJNA380416 3552 319 5.088889 16.23355591 Aureitalea sp. L 1872661 Bacteria Bacteria 45.4 0.0103   NR WP_265198814.1 2816962 g3405 i0 40.4 0.489028213166144 52 31 48.9 0 165 10 252 303 WP_265198814.1 hybrid sensor histidine kinase/response regulator [Aureitalea sp. L0-47] diamond 156 45.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Aureitalea Aureitalea sp. L0-47
30517360 30517360 PRJNA380416_P_NODE_13173_length_163_cov_0.894737_g13026_i0 PRJNA380416 13173 163 0.894737 1.45842131 Flavobacterium proteolyticum 2911683 Bacteria Bacteria 104 2.0199999999999998e-24   NR WP_194096130.1 2911683 g13026 i0 94.3 0.975460122699387 53 3 97.5 0 3 161 133 185 WP_194096130.1 S8 family serine peptidase [Flavobacterium proteolyticum] diamond 159 104 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium proteolyticum
31180520 31180520 PRJNA380416_P_NODE_13555_length_162_cov_0.902655_g13408_i0 PRJNA380416 13555 162 0.902655 1.4623011 Chitinophagales bacterium 2448779 Bacteria Bacteria 91.7 5.46e-20   NR MCZ2397875.1 2448779 g13408 i0 100 0.777777777777778 42 0 77.8 0 33 158 397 438 MCZ2397875.1 hypothetical protein [Chitinophagales bacterium] diamond 126 91.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales     Chitinophagales bacterium
31307285 31307285 PRJNA380416_P_NODE_12595_length_164_cov_0.886957_g12448_i0 PRJNA380416 12595 164 0.886957 1.45460948 Roseivirga sp. 1964215 Bacteria Bacteria 44.7 0.00272   NR MCE7992289.1 1964215 g12448 i0 46.7 0.823170731707317 45 24 82.3 0 139 5 528 572 MCE7992289.1 T9SS type A sorting domain-containing protein [Roseivirga sp.] diamond 135 44.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Roseivirgaceae Roseivirga Roseivirga sp.
32161644 32161644 PRJNA380416_P_NODE_13078_length_163_cov_0.894737_g12931_i0 PRJNA380416 13078 163 0.894737 1.45842131 Chitinophaga sp. 1869181 Bacteria Bacteria 47.4 2.69e-4   NR MBA4197074.1 1869181 g12931 i0 100 0.386503067484663 21 0 38.7 0 3 65 256 276 MBA4197074.1 5-dehydro-4-deoxy-D-glucuronate isomerase [Chitinophaga sp.] diamond 63 47.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Chitinophaga Chitinophaga sp.
32319994 32319994 PRJNA380416_P_NODE_2059_length_424_cov_2.074667_g1912_i0 PRJNA380416 2059 424 2.074667 8.79658808 Bacteroidia bacterium 2044936 Bacteria Bacteria 53.1 5.64e-5   NR GJQ22129.1 2044936 g1912 i0 36.7 0.693396226415094 98 52 62.3 3 68 331 322 419 GJQ22129.1 MAG: hypothetical protein HBSIN02_24840 [Bacteroidia bacterium] diamond 294 53.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia 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);;