RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1035005" and tax_phylum = "Fusobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fusobacteriota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1035005 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
22684683 22684683 PRJNA1035005_P_NODE_4278_length_517_cov_1.743243_g3880_i0 PRJNA1035005 4278 517 1.743243 9.01256631 Fusobacterium nucleatum 851 Bacteria Bacteria 265 1.58e-88   NR WP_249525714.1 851 g3880 i0 100 0.754352030947776 130 0 75.4 0 29 418 2 131 WP_249525714.1 hypothetical protein [Fusobacterium nucleatum] diamond 390 265 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
27003348 27003348 PRJNA1035005_P_NODE_68242_length_248_cov_0.891429_g67836_i0 PRJNA1035005 68242 248 0.891429 2.21074392 uncultured Fusobacterium sp. 159267 Bacteria Bacteria 140 4.01e-40   NR WP_293959480.1 159267 g67836 i0 97.2 0.858870967741935 71 2 85.9 0 1 213 132 202 WP_293959480.1 YkoF family thiamine/hydroxymethylpyrimidine-binding protein [uncultured Fusobacterium sp.] diamond 213 140 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium uncultured Fusobacterium sp.
27098332 27098332 PRJNA1035005_P_NODE_26582_length_287_cov_1.415888_g26176_i0 PRJNA1035005 26582 287 1.415888 4.06359856 Fusobacterium sp. 68766 Bacteria Bacteria 125 4.0699999999999997e-32   NR MBS5036829.1 68766 g26176 i0 98.4 1.33797909407666 64 1 66.9 0 192 1 1 64 MBS5036829.1 efflux RND transporter periplasmic adaptor subunit [Fusobacterium sp.] diamond 384 125 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp.
27793420 27793420 PRJNA1035005_P_NODE_38124_length_272_cov_1.386935_g37718_i0 PRJNA1035005 38124 272 1.386935 3.7724632 Leptotrichia hongkongensis 554406 Bacteria Bacteria 136 6.54e-38   NR WP_374141460.1 554406 g37718 i0 94.3 0.772058823529412 70 4 77.2 0 272 63 167 236 WP_374141460.1 restriction endonuclease [Leptotrichia hongkongensis] diamond 210 136 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hongkongensis
28203536 28203536 PRJNA1035005_P_NODE_44846_length_263_cov_1.642105_g44440_i0 PRJNA1035005 44846 263 1.642105 4.31873615 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 120 1.2499999999999999e-31   NR WP_021767200.1 712359 g44440 i0 92 0.992395437262357 87 7 99.2 0 262 2 46 132 WP_021767200.1 DUF456 domain-containing protein [Leptotrichia sp. oral taxon 215] diamond 261 120 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
28456499 28456499 PRJNA1035005_P_NODE_4046_length_531_cov_2.124454_g3648_i0 PRJNA1035005 4046 531 2.124454 11.28085074 Fusobacterium animalis 76859 Bacteria Bacteria 233 2.09e-71   NR WP_369231877.1 76859 g3648 i0 71 0.994350282485876 176 51 99.4 0 2 529 140 315 WP_369231877.1 DnaB-like helicase C-terminal domain-containing protein, partial [Fusobacterium animalis] diamond 528 233 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium animalis
28519641 28519641 PRJNA1035005_P_NODE_78747_length_244_cov_1.263158_g78341_i0 PRJNA1035005 78747 244 1.263158 3.08210552 Fusobacterium polymorphum 76857 Bacteria Bacteria 107 7.14e-28   NR WP_335967944.1 76857 g78341 i0 70.5 0.959016393442623 78 23 95.9 0 236 3 6 83 WP_335967944.1 hypothetical protein [Fusobacterium polymorphum] diamond 234 107 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
29087990 29087990 PRJNA1035005_P_NODE_48308_length_259_cov_1.510753_g47902_i0 PRJNA1035005 48308 259 1.510753 3.91285027 Fusobacterium hwasookii 1583098 Bacteria Bacteria 102 1.94e-23   NR WP_005919897.1 1583098 g47902 i0 55.8 1.1003861003861 95 33 99.6 2 2 259 113 207 WP_005919897.1 toprim domain-containing protein [Fusobacterium hwasookii] diamond 285 102 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium hwasookii
29277107 29277107 PRJNA1035005_P_NODE_35369_length_275_cov_2.212871_g34963_i0 PRJNA1035005 35369 275 2.212871 6.08539525 Fusobacterium hwasookii 1583098 Bacteria Bacteria 98.6 3.0200000000000002e-22   NR WP_029494009.1 1583098 g34963 i0 58.2 0.992727272727273 91 38 99.3 0 275 3 111 201 WP_029494009.1 hypothetical protein [Fusobacterium hwasookii] diamond 273 98.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium hwasookii
29403622 29403622 PRJNA1035005_P_NODE_87129_length_239_cov_2.084337_g86723_i0 PRJNA1035005 87129 239 2.084337 4.98156543 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 55.8 2.26e-7   NR WP_021767975.1 712359 g86723 i0 86.7 0.564853556485356 45 4 56.5 2 136 2 114 156 WP_021767975.1 hypothetical protein [Leptotrichia sp. oral taxon 215] diamond 135 55.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
31394132 31394132 PRJNA1035005_P_NODE_12036_length_344_cov_1.726937_g11631_i0 PRJNA1035005 12036 344 1.726937 5.94066328 Fusobacterium vincentii 155615 Bacteria Bacteria 130 2.65e-32   NR WP_341485137.1 155615 g11631 i0 63.4 0.976744186046512 112 40 97.7 1 5 340 649 759 WP_341485137.1 relaxase/mobilization nuclease domain-containing protein [Fusobacterium vincentii] diamond 336 130 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium vincentii

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