RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA630877" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA630877 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
27049331 27049331 PRJNA630877_S_NODE_144702_length_163_cov_1.073770_g125565_i0 PRJNA630877 144702 163 1.07377 1.7502451 Bacteroidales bacterium 2030927 Bacteria Bacteria 41.2 0.0436   NR MBR1569521.1 2030927 g125565 i0 37.2 0.791411042944785 43 27 79.1 0 140 12 515 557 MBR1569521.1 GH92 family glycosyl hydrolase [Bacteroidales bacterium] diamond 129 41.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
27460231 27460231 PRJNA630877_S_NODE_122183_length_187_cov_1.739726_g103046_i0 PRJNA630877 122183 187 1.739726 3.25328762 Bacteroidota bacterium 1898104 Bacteria Bacteria 42.7 0.0179   NR RMD96636.1 1898104 g103046 i0 44.2 0.834224598930481 52 28 83.4 1 162 7 8 58 RMD96636.1 MAG: hypothetical protein D6816_18675 [Bacteroidota bacterium] diamond 156 42.7 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
27523178 27523178 PRJNA630877_S_NODE_110403_length_205_cov_2.103659_g91266_i0 PRJNA630877 110403 205 2.103659 4.3125009500000004 Bacteroidaceae bacterium 2212467 Bacteria Bacteria 43.9 0.00881   NR MBQ2299686.1 2212467 g91266 i0 34.2 1.06829268292683 73 41 96.6 1 6 203 1125 1197 MBQ2299686.1 discoidin domain-containing protein [Bacteroidaceae bacterium] diamond 219 43.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae   Bacteroidaceae bacterium
27901909 27901909 PRJNA630877_S_NODE_119245_length_191_cov_1.760000_g100108_i0 PRJNA630877 119245 191 1.76 3.3616 Reichenbachiella faecimaris 692418 Bacteria Bacteria 42 0.0356   NR WP_084373050.1 692418 g100108 i0 43.2 0.581151832460733 37 21 58.1 0 31 141 514 550 WP_084373050.1 T9SS type A sorting domain-containing protein [Reichenbachiella faecimaris] diamond 111 42 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Reichenbachiellaceae Reichenbachiella Reichenbachiella faecimaris
28123153 28123153 PRJNA630877_S_NODE_102905_length_220_cov_12.273743_g83768_i0 PRJNA630877 102905 220 12.273743 27.0022346 Bacteroidota bacterium 1898104 Bacteria Bacteria 42 0.0483   NR MEY4541892.1 1898104 g83768 i0 31.7 0.818181818181818 60 38 77.7 1 49 219 127 186 MEY4541892.1 hypothetical protein [Bacteroidota bacterium] diamond 180 42 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28249232 28249232 PRJNA630877_S_NODE_147386_length_160_cov_1.848739_g128249_i0 PRJNA630877 147386 160 1.848739 2.9579824 Cyclobacteriaceae bacterium 2099675 Bacteria Bacteria 41.6 0.0304   NR HEX7014416.1 2099675 g128249 i0 43.5 0.8625 46 23 86.3 1 146 9 407 449 HEX7014416.1 NADH-quinone oxidoreductase subunit L [Cyclobacteriaceae bacterium] diamond 138 41.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cyclobacteriaceae   Cyclobacteriaceae bacterium
28628525 28628525 PRJNA630877_S_NODE_75867_length_315_cov_3.054745_g56730_i0 PRJNA630877 75867 315 3.054745 9.62244675 Flavobacterium stagni 2506421 Bacteria Bacteria 43.5 0.0439   NR WP_129460995.1 2506421 g56730 i0 29.4 0.647619047619048 68 47 63.8 1 7 207 131 198 WP_129460995.1 glycosyltransferase [Flavobacterium stagni] diamond 204 43.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium stagni
28723106 28723106 PRJNA630877_S_NODE_148287_length_159_cov_3.322034_g129150_i0 PRJNA630877 148287 159 3.322034 5.28203406 Candidatus Nephrothrix sp. EaCA 2044729 Bacteria Bacteria 60.8 4.74e-9   NR PGH37420.1 2044729 g129150 i0 55.8 0.981132075471698 52 23 98.1 0 2 157 797 848 PGH37420.1 MAG: hypothetical protein CRN43_21290 [Candidatus Nephrothrix sp. EaCA] diamond 156 60.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae Candidatus Nephrothrix Candidatus Nephrothrix sp. EaCA
28944381 28944381 PRJNA630877_S_NODE_15208_length_1746_cov_19.234604_g8308_i0 PRJNA630877 15208 1746 19.234604 335.83618584 Flavobacteriaceae bacterium 1871037 Bacteria Bacteria 69.3 4.1e-8   NR MCP4483311.1 1871037 g8308 i0 28.1 0.596219931271478 210 141 34.4 2 1267 668 726 935 MCP4483311.1 hypothetical protein [Flavobacteriaceae bacterium] diamond 1041 69.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
29417539 29417539 PRJNA630877_S_NODE_54889_length_499_cov_2.539301_g35926_i0 PRJNA630877 54889 499 2.539301 12.67111199 Phocaeicola vulgatus 821 Bacteria Bacteria 125 8.72e-34   NR WP_050229787.1 821 g35926 i0 95.2 0.75751503006012 126 6 75.8 0 413 36 1 126 WP_050229787.1 hypothetical protein [Phocaeicola vulgatus] diamond 378 125 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae Phocaeicola Phocaeicola vulgatus
29606702 29606702 PRJNA630877_S_NODE_117370_length_194_cov_1.372549_g98233_i0 PRJNA630877 117370 194 1.372549 2.66274506 Cyclobacteriaceae bacterium 2099675 Bacteria Bacteria 42.4 0.0266   NR NOT77233.1 2099675 g98233 i0 43.2 0.572164948453608 37 20 55.7 1 112 5 350 386 NOT77233.1 adenosylhomocysteinase [Cyclobacteriaceae bacterium] diamond 111 42.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cyclobacteriaceae   Cyclobacteriaceae bacterium
29954524 29954524 PRJNA630877_S_NODE_132051_length_175_cov_1.641791_g112914_i0 PRJNA630877 132051 175 1.641791 2.87313425 Muribaculaceae bacterium 2498093 Bacteria Bacteria 41.6 0.0396   NR MFG6387112.1 2498093 g112914 i0 34.5 0.942857142857143 55 30 94.3 1 11 175 669 717 MFG6387112.1 type IX secretion system sortase PorU [Muribaculaceae bacterium] diamond 165 41.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Muribaculaceae   Muribaculaceae bacterium
29986083 29986083 PRJNA630877_S_NODE_134691_length_172_cov_1.801527_g115554_i0 PRJNA630877 134691 172 1.801527 3.09862644 Bacteroidota bacterium 1898104 Bacteria Bacteria 41.6 0.0377   NR HQJ76511.1 1898104 g115554 i0 50 0.802325581395349 46 21 80.2 2 5 142 571 614 HQJ76511.1 alginate lyase family protein [Bacteroidota bacterium] diamond 138 41.6 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
30365627 30365627 PRJNA630877_S_NODE_84252_length_276_cov_1.489362_g65115_i0 PRJNA630877 84252 276 1.489362 4.11063912 Hymenobacter artigasi 2719616 Bacteria Bacteria 44.3 0.0158   NR WP_210428120.1 2719616 g65115 i0 33.9 1.3804347826087 62 40 67.4 1 1 186 17 77 WP_210428120.1 bifunctional metallophosphatase/5'-nucleotidase [Hymenobacter artigasi] diamond 381 44.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Hymenobacter Hymenobacter artigasi
30397296 30397296 PRJNA630877_S_NODE_95893_length_238_cov_0.994924_g76756_i0 PRJNA630877 95893 238 0.994924 2.36791912 Galbibacter orientalis 453852 Bacteria Bacteria 42.7 0.0118   NR WP_008615155.1 453852 g76756 i0 40 0.69327731092437 55 33 69.3 0 41 205 53 107 WP_008615155.1 diacylglycerol kinase [Galbibacter orientalis] diamond 165 42.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Galbibacter Galbibacter orientalis
30649315 30649315 PRJNA630877_S_NODE_116873_length_195_cov_0.857143_g97736_i0 PRJNA630877 116873 195 0.857143 1.67142885 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 43.5 0.0109   NR MBC7588771.1 1869212 g97736 i0 54.8 0.476923076923077 31 14 47.7 0 94 186 170 200 MBC7588771.1 glycosyltransferase family 39 protein [Chitinophagaceae bacterium] diamond 93 43.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
30712711 30712711 PRJNA630877_S_NODE_38814_length_796_cov_29.313907_g22480_i0 PRJNA630877 38814 796 29.313907 233.33869972 Bacteroidota bacterium 1898104 Bacteria Bacteria 48.5 0.0219   NR MEY3677884.1 1898104 g22480 i0 28.3 0.46356783919598 99 56 36.9 2 398 105 356 440 MEY3677884.1 hypothetical protein [Bacteroidota bacterium] diamond 369 48.5 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31249859 31249859 PRJNA630877_S_NODE_41275_length_738_cov_3.721664_g24284_i0 PRJNA630877 41275 738 3.721664 27.46588032 Bacteroidota bacterium 1898104 Bacteria Bacteria 115 6.62e-28   NR MEO1519119.1 1898104 g24284 i0 44.1 0.719512195121951 177 79 72 2 532 2 1 157 MEO1519119.1 hypothetical protein [Bacteroidota bacterium] diamond 531 115 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31376596 31376596 PRJNA630877_S_NODE_89756_length_256_cov_1.767442_g70619_i0 PRJNA630877 89756 256 1.767442 4.52465152 Phaeodactylibacter sp. 1940289 Bacteria Bacteria 43.1 0.0319   NR MCO6493313.1 1940289 g70619 i0 41.8 0.64453125 55 32 64.5 0 41 205 237 291 MCO6493313.1 hypothetical protein [Phaeodactylibacter sp.] diamond 165 43.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Haliscomenobacteraceae Phaeodactylibacter Phaeodactylibacter sp.
31420648 31420648 PRJNA630877_S_NODE_158356_length_151_cov_2.000000_g139219_i0 PRJNA630877 158356 151 2 3.02 root 1 Root_unresolved Root_unresolved 41.2 0.0383   NR MBP9186374.1 2044936 g139219 i0 40.9 1.90728476821192 44 26 87.4 0 20 151 924 967 MBP9186374.1 hypothetical protein [Bacteroidia bacterium] diamond 288 41.6 0.990384615384615 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
31471509 31471509 PRJNA630877_S_NODE_157976_length_152_cov_1.054054_g138839_i0 PRJNA630877 157976 152 1.054054 1.60216208 Flavobacteriaceae bacterium 1871037 Bacteria Bacteria 53.1 2.26e-6   NR MCP4485568.1 1871037 g138839 i0 46 2.96052631578947 50 27 98.7 0 3 152 27 76 MCP4485568.1 reverse transcriptase family protein [Flavobacteriaceae bacterium] diamond 450 53.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
32072374 32072374 PRJNA630877_S_NODE_59538_length_444_cov_2.483871_g40440_i0 PRJNA630877 59538 444 2.483871 11.02838724 Aquimarina sp. ERC-38 2949996 Bacteria Bacteria 45.4 0.0369   NR WP_265771143.1 2949996 g40440 i0 36.8 0.513513513513513 76 41 50 2 393 172 1741 1811 WP_265771143.1 RHS repeat domain-containing protein [Aquimarina sp. ERC-38] diamond 228 45.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Aquimarina Aquimarina sp. ERC-38
32135795 32135795 PRJNA630877_S_NODE_79538_length_296_cov_42.772549_g60401_i0 PRJNA630877 79538 296 42.772549 126.60674504 Saprospiraceae bacterium 2202734 Bacteria Bacteria 44.3 0.00596   NR MBX2928275.1 2202734 g60401 i0 39.5 0.77027027027027 76 38 74 4 46 264 2 72 MBX2928275.1 DUF2085 domain-containing protein [Saprospiraceae bacterium] diamond 228 44.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
32167492 32167492 PRJNA630877_S_NODE_80578_length_292_cov_1.693227_g61441_i0 PRJNA630877 80578 292 1.693227 4.94422284 Elizabethkingia anophelis 1117645 Bacteria Bacteria 46.2 0.00327   NR WP_078407069.1 1117645 g61441 i0 33.3 1.6027397260274 78 42 80.1 1 234 1 169 236 WP_078407069.1 energy transducer TonB [Elizabethkingia anophelis] diamond 468 46.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Elizabethkingia Elizabethkingia anophelis
32452334 32452334 PRJNA630877_S_NODE_113619_length_200_cov_1.106918_g94482_i0 PRJNA630877 113619 200 1.106918 2.213836 Cytophagales bacterium 2053541 Bacteria Bacteria 42.7 0.0208   NR HYG39968.1 2053541 g94482 i0 31.9 1.035 69 39 91.5 1 186 4 56 124 HYG39968.1 acyltransferase [Cytophagales bacterium] diamond 207 42.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales     Cytophagales bacterium
32483832 32483832 PRJNA630877_S_NODE_108059_length_210_cov_1.343195_g88922_i0 PRJNA630877 108059 210 1.343195 2.8207095 Bacteroidales bacterium 2030927 Bacteria Bacteria 42.7 0.0251   NR MBQ1697568.1 2030927 g88922 i0 42.6 0.671428571428571 47 27 67.1 0 192 52 340 386 MBQ1697568.1 hypothetical protein [Bacteroidales bacterium] diamond 141 42.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
32704376 32704376 PRJNA630877_S_NODE_142200_length_165_cov_1.330645_g123063_i0 PRJNA630877 142200 165 1.330645 2.19556425 Winogradskyella sp. PE311 3366943 Bacteria Bacteria 41.2 0.0471   NR WP_411126914.1 3366943 g123063 i0 38 0.909090909090909 50 30 90.9 1 1 150 236 284 WP_411126914.1 hypothetical protein [Winogradskyella sp. PE311] diamond 150 41.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Winogradskyella Winogradskyella sp. PE311
32704379 32704379 PRJNA630877_S_NODE_85980_length_269_cov_2.293860_g66843_i0 PRJNA630877 85980 269 2.29386 6.1704834 Bacteroidaceae bacterium 2212467 Bacteria Bacteria 43.1 0.0355   NR MBO6059867.1 2212467 g66843 i0 38.3 0.524163568773234 47 29 52.4 0 156 16 44 90 MBO6059867.1 RagB/SusD family nutrient uptake outer membrane protein [Bacteroidaceae bacterium] diamond 141 43.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae   Bacteroidaceae 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);;