RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA1046144" 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

  • PRJNA1046144 · 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
3998995 3998995 PRJNA1046144_P_NODE_49764_length_248_cov_1.608939_g49469_i0 PRJNA1046144 49764 248 1.608939 3.99016872 Kaistella sp. 2782235 Bacteria Bacteria 170 4.07e-50   NR WP_332024246.1 2782235 g49469 i0 96.3 2.9758064516129 82 3 99.2 0 1 246 33 114 WP_332024246.1 acyl-CoA dehydrogenase family protein, partial [Kaistella sp.] diamond 738 170 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Kaistella Kaistella sp.
14201520 14201520 PRJNA1046144_P_NODE_65472_length_229_cov_0.900000_g65177_i0 PRJNA1046144 65472 229 0.9 2.061 Pseudomonadati 3379134 Bacteria Bacteria 93.6 6.27e-23   NR PHN95910.1 361581 g65177 i0 97.6 1.65065502183406 42 1 55 0 102 227 1 42 PHN95910.1 23S rRNA (pseudouridine(1915)-N(3))-methyltransferase RlmH, partial [Tenacibaculum discolor] diamond 378 94.4 0.991525423728813 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Tenacibaculum Tenacibaculum discolor
26845612 26845612 PRJNA1046144_P_NODE_64001_length_230_cov_0.894410_g63706_i0 PRJNA1046144 64001 230 0.89441 2.057143 Dysgonomonas sp. 1891233 Bacteria Bacteria 53.1 6.5e-6   NR MDU1889872.1 1891233 g63706 i0 57.9 1.48695652173913 38 16 49.6 0 229 116 348 385 MDU1889872.1 glycosyltransferase [Dysgonomonas sp.] diamond 342 53.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Dysgonomonadaceae Dysgonomonas Dysgonomonas sp.
27319814 27319814 PRJNA1046144_P_NODE_43743_length_262_cov_1.492228_g43448_i0 PRJNA1046144 43743 262 1.492228 3.90963736 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 157 1.75e-47   NR MCA6440974.1 1869212 g43448 i0 96.6 0.99618320610687 87 3 99.6 0 262 2 20 106 MCA6440974.1 hypothetical protein [Chitinophagaceae bacterium] diamond 261 157 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
27730580 27730580 PRJNA1046144_P_NODE_64884_length_229_cov_0.900000_g64589_i0 PRJNA1046144 64884 229 0.9 2.061 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 157 7.059999999999999e-46   NR MCA6440710.1 1869212 g64589 i0 98.7 0.982532751091703 75 1 98.3 0 3 227 56 130 MCA6440710.1 sterol desaturase family protein [Chitinophagaceae bacterium] diamond 225 157 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
27793505 27793505 PRJNA1046144_P_NODE_64944_length_229_cov_0.900000_g64649_i0 PRJNA1046144 64944 229 0.9 2.061 Flavobacteriaceae bacterium 1871037 Bacteria Bacteria 150 3.2299999999999993e-40   NR PZO26169.1 1871037 g64649 i0 100 0.982532751091703 75 0 98.3 0 3 227 375 449 PZO26169.1 MAG: membrane assembly protein AsmA, partial [Flavobacteriaceae bacterium] diamond 225 150 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
28108982 28108982 PRJNA1046144_P_NODE_56325_length_235_cov_0.867470_g56030_i0 PRJNA1046144 56325 235 0.86747 2.0385545 Sediminibacterium sp. 1917865 Bacteria Bacteria 153 3.03e-41   NR MBR2648801.1 1917865 g56030 i0 100 0.94468085106383 74 0 94.5 0 13 234 1 74 MBR2648801.1 gliding motility-associated C-terminal domain-containing protein [Sediminibacterium sp.] diamond 222 153 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Sediminibacterium Sediminibacterium sp.
28993523 28993523 PRJNA1046144_P_NODE_63848_length_230_cov_0.894410_g63553_i0 PRJNA1046144 63848 230 0.89441 2.057143 Flavobacterium sp. 239 Bacteria Bacteria 73.2 5.83e-13   NR WP_396190144.1 239 g63553 i0 50.6 1.0304347826087 79 35 97.8 1 228 4 88 166 WP_396190144.1 hypothetical protein, partial [Flavobacterium sp.] diamond 237 73.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
28993527 28993527 PRJNA1046144_P_NODE_68128_length_227_cov_0.911392_g67833_i0 PRJNA1046144 68128 227 0.911392 2.06885984 Kaistella 2782231 Bacteria Bacteria 45.4 0.00333   NR WP_251832976.1 2782231 g67833 i0 100 0.303964757709251 23 0 30.4 0 227 159 437 459 WP_251832976.1 MULTISPECIES: NADH-quinone oxidoreductase subunit N [Kaistella] diamond 69 45.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Kaistella  
29214483 29214483 PRJNA1046144_P_NODE_54449_length_238_cov_1.349112_g54154_i0 PRJNA1046144 54449 238 1.349112 3.21088656 Bacteroidota bacterium 1898104 Bacteria Bacteria 70.9 4.26e-12   NR MDQ6815257.1 1898104 g54154 i0 44.7 2.98739495798319 76 42 95.8 0 3 230 519 594 MDQ6815257.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Bacteroidota bacterium] diamond 711 70.9 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
29521866 29521866 PRJNA1046144_P_NODE_49370_length_249_cov_1.555556_g49075_i0 PRJNA1046144 49370 249 1.555556 3.87333444 Aridibaculum 3042723 Bacteria Bacteria 154 3.78e-44   NR HNF30072.1 1869212 g49075 i0 90.4 10 83 8 100 0 1 249 140 222 HNF30072.1 acyl-CoA dehydrogenase family protein [Chitinophagaceae bacterium] diamond 2490 155 0.993548387096774 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
29592710 29592710 PRJNA1046144_P_NODE_63770_length_230_cov_0.894410_g63475_i0 PRJNA1046144 63770 230 0.89441 2.057143 Pedobacter duraquae 425511 Bacteria Bacteria 42 0.045   NR WP_133555282.1 425511 g63475 i0 39.6 0.691304347826087 53 25 69.1 1 205 47 17 62 WP_133555282.1 HupE/UreJ family protein [Pedobacter duraquae] diamond 159 42 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Pedobacter Pedobacter duraquae
29719155 29719155 PRJNA1046144_P_NODE_69730_length_226_cov_0.917197_g69435_i0 PRJNA1046144 69730 226 0.917197 2.07286522 Bacteroidota bacterium 1898104 Bacteria Bacteria 45.1 0.00172   NR MBI3519890.1 1898104 g69435 i0 47.2 0.955752212389381 36 19 47.8 0 1 108 100 135 MBI3519890.1 T9SS type A sorting domain-containing protein [Bacteroidota bacterium] diamond 216 45.1 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
29774381 29774381 PRJNA1046144_P_NODE_66571_length_228_cov_0.905660_g66276_i0 PRJNA1046144 66571 228 0.90566 2.0649048 Sediminibacterium 504481 Bacteria Bacteria 160 5.819999999999999e-45   NR MCA6448441.1 1869212 g66276 i0 100 2.98684210526316 76 0 100 0 228 1 334 409 MCA6448441.1 transpeptidase family protein [Chitinophagaceae bacterium] diamond 681 160 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
29972046 29972046 PRJNA1046144_P_NODE_62191_length_231_cov_0.888889_g61896_i0 PRJNA1046144 62191 231 0.888889 2.05333359 Xanthocytophaga flavus 3048013 Bacteria Bacteria 58.9 4.38e-8   NR WP_313987658.1 3048013 g61896 i0 100 0.363636363636364 28 0 36.4 0 1 84 235 262 WP_313987658.1 uroporphyrinogen-III synthase [Xanthocytophaga flavus] diamond 84 58.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Rhodocytophagaceae Xanthocytophaga Xanthocytophaga flava
30027320 30027320 PRJNA1046144_P_NODE_42211_length_266_cov_1.263959_g41916_i0 PRJNA1046144 42211 266 1.263959 3.36213094 Sediminibacterium 504481 Bacteria Bacteria 168 8.4e-49   NR WP_133473885.1 1086393 g41916 i0 93.2 15.812030075188 88 6 99.2 0 266 3 43 130 WP_133473885.1 DNA polymerase III subunit beta [Sediminibacterium goheungense] diamond 4206 168 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Sediminibacterium Sediminibacterium goheungense
30098327 30098327 PRJNA1046144_P_NODE_58132_length_234_cov_0.872727_g57837_i0 PRJNA1046144 58132 234 0.872727 2.04218118 Pseudopedobacter saltans 151895 Bacteria Bacteria 102 6.97e-24   NR PZP44090.1 151895 g57837 i0 100 0.666666666666667 52 0 66.7 0 232 77 330 381 PZP44090.1 MAG: efflux RND transporter periplasmic adaptor subunit [Pseudopedobacter saltans] diamond 156 102 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Pseudopedobacter Pseudopedobacter saltans
30446164 30446164 PRJNA1046144_P_NODE_56813_length_235_cov_0.867470_g56518_i0 PRJNA1046144 56813 235 0.86747 2.0385545 Pedobacter sp. 1411316 Bacteria Bacteria 137 4.93e-37   NR WP_308850549.1 1411316 g56518 i0 89.7 1.99148936170213 78 8 99.6 0 2 235 253 330 WP_308850549.1 glycosyltransferase family 2 protein [Pedobacter sp.] diamond 468 137 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Pedobacter Pedobacter sp.
30540751 30540751 PRJNA1046144_P_NODE_51253_length_245_cov_1.397727_g50958_i0 PRJNA1046144 51253 245 1.397727 3.42443115 Hydrobacter penzbergensis 1235997 Bacteria Bacteria 157 5.53e-46   NR WP_092722649.1 1235997 g50958 i0 91.4 0.991836734693878 81 7 99.2 0 1 243 67 147 WP_092722649.1 GLPGLI family protein [Hydrobacter penzbergensis] diamond 243 157 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Hydrobacter Hydrobacter penzbergensis
30572151 30572151 PRJNA1046144_P_NODE_44033_length_261_cov_2.088542_g43738_i0 PRJNA1046144 44033 261 2.088542 5.45109462 Hydrobacter penzbergensis 1235997 Bacteria Bacteria 149 2.28e-39   NR WP_092723772.1 1235997 g43738 i0 100 0.839080459770115 73 0 83.9 0 1 219 936 1008 WP_092723772.1 SusC/RagA family TonB-linked outer membrane protein [Hydrobacter penzbergensis] diamond 219 149 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Hydrobacter Hydrobacter penzbergensis
31109365 31109365 PRJNA1046144_P_NODE_67715_length_227_cov_0.911392_g67420_i0 PRJNA1046144 67715 227 0.911392 2.06885984 Parabacteroides goldsteinii 328812 Bacteria Bacteria 64.7 2.98e-10   NR WP_195585378.1 328812 g67420 i0 61.9 1.75770925110132 42 16 55.5 0 226 101 218 259 WP_195585378.1 hypothetical protein [Parabacteroides goldsteinii] diamond 399 64.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Tannerellaceae Parabacteroides Parabacteroides goldsteinii
31227683 31227683 PRJNA1046144_P_NODE_65275_length_229_cov_0.900000_g64980_i0 PRJNA1046144 65275 229 0.9 2.061 Bacteria 2 Bacteria Bacteria 144 3.44e-38   NR MBV9988189.1 1869212 g64980 i0 94.7 5.96069868995633 75 4 98.3 0 228 4 268 342 MBV9988189.1 amidophosphoribosyltransferase [Chitinophagaceae bacterium] diamond 1365 145 0.993103448275862 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
31425653 31425653 PRJNA1046144_P_NODE_62836_length_230_cov_1.770186_g62541_i0 PRJNA1046144 62836 230 1.770186 4.0714278 Flavobacterium caeni 490189 Bacteria Bacteria 141 5.3e-37   NR WP_091141221.1 490189 g62541 i0 89.5 0.991304347826087 76 8 99.1 0 230 3 735 810 WP_091141221.1 CusA/CzcA family heavy metal efflux RND transporter [Flavobacterium caeni] diamond 228 141 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium caeni
31860257 31860257 PRJNA1046144_P_NODE_64837_length_229_cov_0.900000_g64542_i0 PRJNA1046144 64837 229 0.9 2.061 Pedobacter 84567 Bacteria Bacteria 141 1.7299999999999999e-40   NR WP_047800431.1 1663685 g64542 i0 94.7 2.94759825327511 75 4 98.3 0 3 227 27 101 WP_047800431.1 crossover junction endodeoxyribonuclease RuvC [Pedobacter sp. BMA] diamond 675 142 0.992957746478873 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Pedobacter Pedobacter sp. BMA
31868378 31868378 PRJNA1046144_P_NODE_58977_length_233_cov_0.878049_g58682_i0 PRJNA1046144 58977 233 0.878049 2.04585417 Flavobacterium lindanitolerans 428988 Bacteria Bacteria 58.2 5.23e-8   NR WP_277014250.1 428988 g58682 i0 48.4 0.798283261802575 62 32 79.8 0 6 191 147 208 WP_277014250.1 prtrc system protein e [Flavobacterium lindanitolerans] diamond 186 58.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium lindanitolerans
31900179 31900179 PRJNA1046144_P_NODE_61077_length_232_cov_0.883436_g60782_i0 PRJNA1046144 61077 232 0.883436 2.04957152 Flavobacterium 237 Bacteria Bacteria 157 1.06e-43   NR WP_056073485.1 237 g60782 i0 98.7 0.982758620689655 76 1 98.3 0 230 3 137 212 WP_056073485.1 MULTISPECIES: AMP-binding protein [Flavobacterium] diamond 228 157 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium  
32438289 32438289 PRJNA1046144_P_NODE_60759_length_232_cov_0.883436_g60464_i0 PRJNA1046144 60759 232 0.883436 2.04957152 Cytophagaceae bacterium 2026729 Bacteria Bacteria 67.8 1.63e-11   NR HSZ24431.1 2026729 g60464 i0 49.3 0.943965517241379 73 36 93.1 1 218 3 141 213 HSZ24431.1 hypothetical protein [Cytophagaceae bacterium] diamond 219 67.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae   Cytophagaceae bacterium
32596203 32596203 PRJNA1046144_P_NODE_52880_length_241_cov_2.116279_g52585_i0 PRJNA1046144 52880 241 2.116279 5.10023239 Candidatus Amoebophilus sp. 36-38 1895716 Bacteria Bacteria 122 2.94e-30   NR OJW69350.1 1895716 g52585 i0 90.5 0.784232365145228 63 6 78.4 0 240 52 504 566 OJW69350.1 MAG: single-stranded-DNA-specific exonuclease RecJ [Candidatus Amoebophilus sp. 36-38] diamond 189 122 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Amoebophilaceae Candidatus Amoebophilus Candidatus Amoebophilus sp. 36-38

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);;