RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA529241" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 17 ✖

bioproject 1

  • PRJNA529241 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
17692970 17692970 PRJNA529241_P_NODE_210514_length_173_cov_5.727941_g208192_i0 PRJNA529241 210514 173 5.727941 9.90933793 Fusobacterium russii 854 Bacteria Bacteria 94.4 9.52e-21   NR WP_022820142.1 854 g208192 i0 69.6 4.78612716763006 69 9 98.8 1 1 171 404 472 WP_022820142.1 threonine--tRNA ligase [Fusobacterium russii] diamond 828 94.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium russii
26697538 26697538 PRJNA529241_P_NODE_384261_length_173_cov_2.514706_g381939_i0 PRJNA529241 384261 173 2.514706 4.35044138 Leptotrichia sp. oral taxon 879 1227267 Bacteria Bacteria 83.2 1.77e-17   NR WP_021743610.1 1227267 g381939 i0 67.6 1.28323699421965 74 7 98.8 1 3 173 57 130 WP_021743610.1 hypothetical protein, partial [Leptotrichia sp. oral taxon 879] diamond 222 83.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 879
26982468 26982468 PRJNA529241_P_NODE_136902_length_192_cov_5.612903_g134580_i0 PRJNA529241 136902 192 5.612903 10.77677376 Streptobacillus moniliformis 34105 Bacteria Bacteria 77.4 2.02e-16   NR WP_196762291.1 34105 g134580 i0 100 0.546875 35 0 54.7 0 106 2 40 74 WP_196762291.1 terminase gpA endonuclease subunit, partial [Streptobacillus moniliformis] diamond 105 77.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus moniliformis
27045938 27045938 PRJNA529241_P_NODE_493042_length_151_cov_5.482456_g490720_i0 PRJNA529241 493042 151 5.482456 8.27850856 Leptotrichia hongkongensis 554406 Bacteria Bacteria 48.9 7.13e-5   NR WP_232052539.1 554406 g490720 i0 89.3 0.556291390728477 28 3 55.6 0 1 84 8 35 WP_232052539.1 DNA translocase FtsK [Leptotrichia hongkongensis] diamond 84 48.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hongkongensis
27203615 27203615 PRJNA529241_P_NODE_113982_length_207_cov_0.917647_g111660_i0 PRJNA529241 113982 207 0.917647 1.89952929 Streptobacillus canis 2678686 Bacteria Bacteria 55.1 9.29e-7   NR WP_156299248.1 2678686 g111660 i0 100 0.376811594202899 26 0 37.7 0 78 1 1 26 WP_156299248.1 DNA polymerase III subunit delta [Streptobacillus canis] diamond 78 55.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus canis
27804151 27804151 PRJNA529241_P_NODE_389384_length_173_cov_2.433824_g387062_i0 PRJNA529241 389384 173 2.433824 4.21051552 Leptotrichia shahii 157691 Bacteria Bacteria 60.5 1.08e-9   NR BBM41018.1 157691 g387062 i0 40.9 1.99421965317919 115 10 98.8 1 3 173 23 137 BBM41018.1 hypothetical protein JCM16776_1238 [Leptotrichia shahii] diamond 345 60.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia shahii
28229389 28229389 PRJNA529241_P_NODE_471766_length_151_cov_9.149123_g469444_i0 PRJNA529241 471766 151 9.149123 13.81517573 Fusobacterium 848 Bacteria Bacteria 61.2 3.03e-9   NR WP_314292793.1 860 g469444 i0 67.9 2.18543046357616 56 11 97.4 1 149 3 604 659 WP_314292793.1 SMC family ATPase [Fusobacterium periodonticum] diamond 330 61.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
28245873 28245873 PRJNA529241_P_NODE_529266_length_151_cov_3.614035_g526944_i0 PRJNA529241 529266 151 3.614035 5.45719285 Leptotrichia sp. 104608 Bacteria Bacteria 52.4 3.31e-6   NR WP_291815771.1 104608 g526944 i0 96 0.496688741721854 25 1 49.7 0 149 75 177 201 WP_291815771.1 ABC transporter permease [Leptotrichia sp.] diamond 75 52.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
29618528 29618528 PRJNA529241_P_NODE_512910_length_151_cov_4.298246_g510588_i0 PRJNA529241 512910 151 4.298246 6.49035146 Leptotrichiaceae 1129771 Bacteria Bacteria 52.8 2.97e-6   NR MBF1336604.1 104608 g510588 i0 100 4.47019867549669 25 0 49.7 0 77 3 657 681 MBF1336604.1 translation initiation factor IF-2 [Leptotrichia sp.] diamond 675 52.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
29698039 29698039 PRJNA529241_P_NODE_371350_length_173_cov_2.654412_g369028_i0 PRJNA529241 371350 173 2.654412 4.59213276 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 49.7 5.16e-5   NR WP_053392307.1 712357 g369028 i0 96 0.433526011560694 25 1 43.4 0 1 75 203 227 WP_053392307.1 HD family phosphohydrolase [Leptotrichia sp. oral taxon 212] diamond 75 49.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
29871585 29871585 PRJNA529241_P_NODE_569951_length_150_cov_4.654867_g567629_i0 PRJNA529241 569951 150 4.654867 6.9823005 Fusobacterium 848 Bacteria Bacteria 43.5 0.00547   NR WP_005894635.1 848 g567629 i0 64.3 3.92 28 10 56 0 2 85 257 284 WP_005894635.1 MULTISPECIES: DNA adenine methylase [Fusobacterium] diamond 588 43.9 0.990888382687927 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium  
31278031 31278031 PRJNA529241_P_NODE_198015_length_173_cov_6.389706_g195693_i0 PRJNA529241 198015 173 6.389706 11.05419138 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 66.6 5.38e-11   NR WP_021766799.1 712359 g195693 i0 38.1 1.95953757225434 113 14 98.8 1 171 1 228 340 WP_021766799.1 cardiolipin synthase [Leptotrichia sp. oral taxon 215] diamond 339 66.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
32227433 32227433 PRJNA529241_P_NODE_578458_length_150_cov_3.716814_g576136_i0 PRJNA529241 578458 150 3.716814 5.575221 Fusobacterium necrophorum 859 Bacteria Bacteria 41.2 0.00968   NR WP_187114587.1 859 g576136 i0 74.1 1.04 27 7 54 0 148 68 59 85 WP_187114587.1 hypothetical protein, partial [Fusobacterium necrophorum] diamond 156 41.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium necrophorum
32495648 32495648 PRJNA529241_P_NODE_332439_length_173_cov_3.117647_g330117_i0 PRJNA529241 332439 173 3.117647 5.39352931 Sneathia 168808 Bacteria Bacteria 58.2 5.3e-8   NR WP_311678267.1 187101 g330117 i0 100 0.867052023121387 25 0 43.4 0 98 172 365 389 WP_311678267.1 hypothetical protein, partial [Sneathia vaginalis] diamond 150 58.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Sneathia Sneathia vaginalis
32606656 32606656 PRJNA529241_P_NODE_306320_length_173_cov_3.441176_g303998_i0 PRJNA529241 306320 173 3.441176 5.95323448 Leptotrichia sp. 104608 Bacteria Bacteria 52.4 5.61e-6   NR WP_367211652.1 104608 g303998 i0 88 0.433526011560694 25 3 43.4 0 173 99 96 120 WP_367211652.1 acyltransferase family protein [Leptotrichia sp.] diamond 75 52.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
32795375 32795375 PRJNA529241_P_NODE_475620_length_151_cov_7.850877_g473298_i0 PRJNA529241 475620 151 7.850877 11.85482427 Streptobacillus canis 2678686 Bacteria Bacteria 53.1 2.25e-6   NR WP_156299721.1 2678686 g473298 i0 100 0.496688741721854 25 0 49.7 0 75 1 290 314 WP_156299721.1 YihY/virulence factor BrkB family protein [Streptobacillus canis] diamond 75 53.1 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus canis
32795415 32795415 PRJNA529241_P_NODE_72940_length_248_cov_4.516588_g70618_i0 PRJNA529241 72940 248 4.516588 11.20113824 Streptobacillus moniliformis 34105 Bacteria Bacteria 52.8 1e-6   NR WP_196760930.1 34105 g70618 i0 100 0.30241935483871 25 0 30.2 0 1 75 35 59 WP_196760930.1 hypothetical protein, partial [Streptobacillus moniliformis] diamond 75 52.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Streptobacillus Streptobacillus moniliformis

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