RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA550047" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 24 ✖

bioproject 1

  • PRJNA550047 · 24 ✖

analysis 1

  • diamond · 24 ✖

tax_clade 0

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
5619784 5619784 PRJNA550047_P_NODE_400345_length_265_cov_3.484375_g398373_i0 PRJNA550047 400345 265 3.484375 9.23359375 Fusobacterium massiliense 1852365 Bacteria Bacteria 166 3.389999999999999e-47   NR WP_074017320.1 1852365 g398373 i0 100 0.939622641509434 83 0 94 0 264 16 366 448 WP_074017320.1 oxaloacetate decarboxylase subunit alpha [Fusobacterium massiliense] diamond 249 166 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium massiliense
26951272 26951272 PRJNA550047_P_NODE_228502_length_301_cov_6.947368_g226533_i0 PRJNA550047 228502 301 6.947368 20.91157768 Leptotrichia wadei 157687 Bacteria Bacteria 101 2.01e-22   NR WP_315344394.1 157687 g226533 i0 98 0.508305647840532 51 1 50.8 0 155 3 374 424 WP_315344394.1 GTPase [Leptotrichia wadei] diamond 153 101 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
26951297 26951297 PRJNA550047_P_NODE_277782_length_299_cov_5.862832_g275813_i0 PRJNA550047 277782 299 5.862832 17.52986768 Fusobacterium sp. 68766 Bacteria Bacteria 174 7.6e-53   NR WP_412587706.1 68766 g275813 i0 80.5 1.13377926421405 113 3 94.3 1 17 298 1 113 WP_412587706.1 epoxyqueuosine reductase QueH [Fusobacterium sp.] diamond 339 174 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp.
27678644 27678644 PRJNA550047_P_NODE_430724_length_253_cov_12.994444_g428752_i0 PRJNA550047 430724 253 12.994444 32.87594332 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 98.6 9.59e-22   NR WP_053392727.1 712357 g428752 i0 74.7 0.984189723320158 83 21 98.4 0 251 3 3123 3205 WP_053392727.1 autotransporter-associated N-terminal domain-containing protein [Leptotrichia sp. oral taxon 212] diamond 249 98.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
27930853 27930853 PRJNA550047_P_NODE_270745_length_299_cov_11.314159_g268776_i0 PRJNA550047 270745 299 11.314159 33.82933541 Fusobacterium sp. 68766 Bacteria Bacteria 183 1.6599999999999994e-54   NR WP_300453054.1 68766 g268776 i0 76.2 1.30434782608696 130 0 99.3 1 1 297 47 176 WP_300453054.1 glycosyltransferase [Fusobacterium sp.] diamond 390 183 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp.
28277993 28277993 PRJNA550047_P_NODE_256046_length_300_cov_6.660793_g254077_i0 PRJNA550047 256046 300 6.660793 19.982379 Fusobacterium sp. 68766 Bacteria Bacteria 202 3.18e-62   NR WP_412363812.1 68766 g254077 i0 100 0.99 99 0 99 0 2 298 133 231 WP_412363812.1 LacI family DNA-binding transcriptional regulator [Fusobacterium sp.] diamond 297 202 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp.
28278059 28278059 PRJNA550047_P_NODE_402406_length_264_cov_6.094241_g400434_i0 PRJNA550047 402406 264 6.094241 16.08879624 Streptobacillus canis 2678686 Bacteria Bacteria 168 3.4199999999999993e-46   NR WP_156299492.1 2678686 g400434 i0 100 0.988636363636364 87 0 98.9 0 2 262 68 154 WP_156299492.1 phosphoenolpyruvate carboxylase [Streptobacillus canis] diamond 261 168 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus canis
28436251 28436251 PRJNA550047_P_NODE_506866_length_228_cov_8.787097_g504893_i0 PRJNA550047 506866 228 8.787097 20.03458116 Leptotrichia wadei 157687 Bacteria Bacteria 86.3 1.52e-17   NR WP_146961161.1 157687 g504893 i0 55.3 1 76 33 100 1 1 228 354 428 WP_146961161.1 autotransporter-associated N-terminal domain-containing protein [Leptotrichia wadei] diamond 228 86.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
29036208 29036208 PRJNA550047_P_NODE_369108_length_277_cov_8.127451_g367137_i0 PRJNA550047 369108 277 8.127451 22.51303927 Fusobacterium sp. 68766 Bacteria Bacteria 178 4.2399999999999996e-54   NR WP_291253417.1 68766 g367137 i0 98.9 0.996389891696751 92 1 99.6 0 276 1 110 201 WP_291253417.1 GntR family transcriptional regulator [Fusobacterium sp.] diamond 276 178 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp.
29162628 29162628 PRJNA550047_P_NODE_541869_length_216_cov_11.237762_g539896_i0 PRJNA550047 541869 216 11.237762 24.27356592 Fusobacterium sp. 68766 Bacteria Bacteria 139 1.0699999999999998e-37   NR WP_291254124.1 68766 g539896 i0 94.4 0.986111111111111 71 4 98.6 0 215 3 155 225 WP_291254124.1 coproporphyrinogen-III oxidase family protein [Fusobacterium sp.] diamond 213 139 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp.
29162656 29162656 PRJNA550047_P_NODE_598429_length_198_cov_14.024000_g596456_i0 PRJNA550047 598429 198 14.024 27.76752 uncultured Fusobacterium sp. 159267 Bacteria Bacteria 129 1.14e-33   NR WP_294064482.1 159267 g596456 i0 98.5 1 66 1 100 0 1 198 290 355 WP_294064482.1 APC family permease [uncultured Fusobacterium sp.] diamond 198 129 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium uncultured Fusobacterium sp.
30029736 30029736 PRJNA550047_P_NODE_391191_length_268_cov_10.882051_g389219_i0 PRJNA550047 391191 268 10.882051 29.16389668 Fusobacterium 848 Bacteria Bacteria 119 9.1e-32   NR WP_008821659.1 860 g389219 i0 77.1 2.78731343283582 83 19 92.9 0 18 266 1 83 WP_008821659.1 manganese efflux pump MntP family protein [Fusobacterium periodonticum] diamond 747 119 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
30204188 30204188 PRJNA550047_P_NODE_393932_length_267_cov_9.592784_g391960_i0 PRJNA550047 393932 267 9.592784 25.61273328 Streptobacillus moniliformis 34105 Bacteria Bacteria 57.4 3.9e-8   NR WP_064613702.1 34105 g391960 i0 40.2 1.08988764044944 97 20 93.3 3 267 19 9 81 WP_064613702.1 hypothetical protein, partial [Streptobacillus moniliformis] diamond 291 57.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus moniliformis
30362772 30362772 PRJNA550047_P_NODE_214812_length_301_cov_19.109649_g212843_i0 PRJNA550047 214812 301 19.109649 57.52004349 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 161 5.16e-47   NR WP_021765869.1 712359 g212843 i0 80 0.996677740863787 100 20 99.7 0 300 1 24 123 WP_021765869.1 carbohydrate ABC transporter permease [Leptotrichia sp. oral taxon 215] diamond 300 161 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
30710018 30710018 PRJNA550047_P_NODE_602294_length_197_cov_11.306452_g600321_i0 PRJNA550047 602294 197 11.306452 22.27371044 uncultured Fusobacterium sp. 159267 Bacteria Bacteria 119 2.19e-29   NR WP_298059861.1 159267 g600321 i0 90.8 0.989847715736041 65 6 99 0 197 3 15 79 WP_298059861.1 hypothetical protein [uncultured Fusobacterium sp.] diamond 195 119 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium uncultured Fusobacterium sp.
30867810 30867810 PRJNA550047_P_NODE_201254_length_342_cov_6.014870_g199293_i0 PRJNA550047 201254 342 6.01487 20.5708554 Leptotrichia wadei 157687 Bacteria Bacteria 95.9 2.63e-20   NR WP_021745653.1 157687 g199293 i0 100 0.421052631578947 48 0 42.1 0 2 145 54 101 WP_021745653.1 plasmid recombination protein [Leptotrichia wadei] diamond 144 95.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
30899560 30899560 PRJNA550047_P_NODE_103554_length_345_cov_8.117647_g101594_i0 PRJNA550047 103554 345 8.117647 28.00588215 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 93.6 6.86e-20   NR WP_053392380.1 712357 g101594 i0 96 0.434782608695652 50 2 43.5 0 3 152 176 225 WP_053392380.1 hypothetical protein [Leptotrichia sp. oral taxon 212] diamond 150 93.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
31025964 31025964 PRJNA550047_P_NODE_235035_length_301_cov_3.951754_g233066_i0 PRJNA550047 235035 301 3.951754 11.89477954 Leptotrichia hongkongensis 554406 Bacteria Bacteria 85.9 5.4e-17   NR WP_374124448.1 554406 g233066 i0 85.7 0.488372093023256 49 7 48.8 0 151 297 794 842 WP_374124448.1 type VI-A CRISPR-associated RNA-guided ribonuclease Cas13a [Leptotrichia hongkongensis] diamond 147 85.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hongkongensis
31261916 31261916 PRJNA550047_P_NODE_490595_length_233_cov_16.137500_g488622_i0 PRJNA550047 490595 233 16.1375 37.600375 Leptotrichia 32067 Bacteria Bacteria 153 1.62e-44   NR MBF1337453.1 104608 g488622 i0 100 1.931330472103 75 0 96.6 0 233 9 185 259 MBF1337453.1 ABC transporter ATP-binding protein [Leptotrichia sp.] diamond 450 153 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
31563680 31563680 PRJNA550047_P_NODE_346276_length_286_cov_14.849765_g344305_i0 PRJNA550047 346276 286 14.849765 42.4703279 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 164 1.8e-46   NR WP_053392231.1 712357 g344305 i0 83.2 0.996503496503496 95 16 99.7 0 2 286 37 131 WP_053392231.1 sensor histidine kinase [Leptotrichia sp. oral taxon 212] diamond 285 164 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
31595242 31595242 PRJNA550047_P_NODE_244916_length_300_cov_12.220264_g242947_i0 PRJNA550047 244916 300 12.220264 36.660792 Fusobacterium massiliense 1852365 Bacteria Bacteria 99.4 7.230000000000001e-22   NR WP_074016383.1 1852365 g242947 i0 100 0.5 50 0 50 0 299 150 149 198 WP_074016383.1 carboxypeptidase M32 [Fusobacterium massiliense] diamond 150 99.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium massiliense
31816541 31816541 PRJNA550047_P_NODE_76277_length_345_cov_11.275735_g74317_i0 PRJNA550047 76277 345 11.275735 38.90128575 uncultured Ilyobacter sp. 544433 Bacteria Bacteria 80.9 9.59e-16   NR WP_319204596.1 544433 g74317 i0 80.9 1.63478260869565 47 9 40.9 0 199 339 63 109 WP_319204596.1 glycosyltransferase family 2 protein [uncultured Ilyobacter sp.] diamond 564 80.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Ilyobacter uncultured Ilyobacter sp.
31911307 31911307 PRJNA550047_P_NODE_214497_length_301_cov_20.100877_g212528_i0 PRJNA550047 214497 301 20.100877 60.50363977 Fusobacterium sp. SYSU M8D9 68766 Bacteria Bacteria 96.3 1.19e-20   NR WP_294725797.1 3159562 g212528 i0 96.1 0.508305647840532 51 2 50.8 0 300 148 660 710 WP_294725797.1 PP2C family protein-serine/threonine phosphatase [Fusobacterium sp. SYSU M8D902] diamond 153 96.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp. SYSU M8D902
31974716 31974716 PRJNA550047_P_NODE_445658_length_248_cov_12.805714_g443686_i0 PRJNA550047 445658 248 12.805714 31.75817072 Fusobacterium animalis ATCC 51191 997347 Bacteria Bacteria 133 1.18e-37   NR EGQ72690.1 997347 g443686 i0 84.1 0.991935483870968 82 13 99.2 0 2 247 48 129 EGQ72690.1 UDP-N-acetylmuramoylalanyl-D-glutamate--2,6-diaminopimelate ligase, partial [Fusobacterium animalis ATCC 51191] diamond 246 133 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium animalis

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