RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA1196438" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 12 ✖

bioproject 1

  • PRJNA1196438 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
26819499 26819499 PRJNA1196438_P_NODE_58741_length_260_cov_1.668449_g58314_i0 PRJNA1196438 58741 260 1.668449 4.3379674 Fusobacterium sp. 68766 Bacteria Bacteria 55.8 1.04e-6   NR MCM1010241.1 68766 g58314 i0 100 0.311538461538462 27 0 31.2 0 178 258 1 27 MCM1010241.1 hypothetical protein [Fusobacterium sp.] diamond 81 55.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp.
27217634 27217634 PRJNA1196438_P_NODE_64862_length_252_cov_1.446927_g64435_i0 PRJNA1196438 64862 252 1.446927 3.64625604 Bacteria 2 Bacteria Bacteria 83.6 1.71e-16   NR MCI0502861.1 2060921 g64435 i0 50.6 1.98809523809524 83 41 98.8 0 2 250 257 339 MCI0502861.1 DUF6020 family protein [Fusobacteriota bacterium] diamond 501 84.3 0.991696322657177 Bacteria   Fusobacteriati Fusobacteriota         Fusobacteriota bacterium
27262261 27262261 PRJNA1196438_P_NODE_81463_length_230_cov_6.566879_g81036_i0 PRJNA1196438 81463 230 6.566879 15.1038217 Leptotrichia sp. oral taxon 215 str. W9775 1321779 Bacteria Bacteria 79.3 1.09e-17   NR ERK67767.1 1321779 g81036 i0 82.7 0.678260869565217 52 9 67.8 0 3 158 5 56 ERK67767.1 hypothetical protein HMPREF1984_01027 [Leptotrichia sp. oral taxon 215 str. W9775] diamond 156 79.3 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
27893617 27893617 PRJNA1196438_P_NODE_36685_length_294_cov_2.108597_g36259_i0 PRJNA1196438 36685 294 2.108597 6.19927518 Fusobacterium sp. 68766 Bacteria Bacteria 92.4 2.5900000000000003e-21   NR MCM1010180.1 68766 g36259 i0 46.3 0.969387755102041 95 51 96.9 0 9 293 50 144 MCM1010180.1 hypothetical protein [Fusobacterium sp.] diamond 285 92.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp.
28481039 28481039 PRJNA1196438_P_NODE_68246_length_249_cov_0.886364_g67819_i0 PRJNA1196438 68246 249 0.886364 2.20704636 root 1 Root_unresolved Root_unresolved 114 1.09e-29   NR MCI7344416.1 859 g67819 i0 61 2.96385542168675 82 32 98.8 0 247 2 59 140 MCI7344416.1 hypothetical protein [Fusobacterium necrophorum] diamond 738 114 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium necrophorum
28777692 28777692 PRJNA1196438_P_NODE_46947_length_278_cov_1.517073_g46520_i0 PRJNA1196438 46947 278 1.517073 4.21746294 Leptotrichia sp. oral taxon 847 1785996 Bacteria Bacteria 68.9 3.26e-11   NR WP_068154486.1 1785996 g46520 i0 47.8 1.5431654676259 69 34 74.5 1 276 70 358 424 WP_068154486.1 5-methylcytosine restriction system specificity protein McrC [Leptotrichia sp. oral taxon 847] diamond 429 68.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 847
28809091 28809091 PRJNA1196438_P_NODE_82168_length_229_cov_2.974359_g81741_i0 PRJNA1196438 82168 229 2.974359 6.81128211 Fusobacterium animalis ATCC 51191 997347 Bacteria Bacteria 122 3.28e-33   NR EGQ72690.1 997347 g81741 i0 85.3 5.89519650655022 75 11 98.3 0 225 1 77 151 EGQ72690.1 UDP-N-acetylmuramoylalanyl-D-glutamate--2,6-diaminopimelate ligase, partial [Fusobacterium animalis ATCC 51191] diamond 1350 122 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium animalis
29219992 29219992 PRJNA1196438_P_NODE_23329_length_312_cov_2.539749_g22903_i0 PRJNA1196438 23329 312 2.539749 7.92401688 Fusobacterium sp. 68766 Bacteria Bacteria 88.6 7.02e-18   NR MCM1010717.1 68766 g22903 i0 88 0.480769230769231 50 6 48.1 0 163 312 77 126 MCM1010717.1 hypothetical protein [Fusobacterium sp.] diamond 150 88.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp.
30546399 30546399 PRJNA1196438_P_NODE_23273_length_312_cov_2.552301_g22847_i0 PRJNA1196438 23273 312 2.552301 7.96317912 Fusobacterium sp. 68766 Bacteria Bacteria 64.7 1.28e-9   NR MCM1009322.1 68766 g22847 i0 62 0.480769230769231 50 19 48.1 0 151 2 173 222 MCM1009322.1 hypothetical protein [Fusobacterium sp.] diamond 150 64.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp.
31558056 31558056 PRJNA1196438_P_NODE_44976_length_281_cov_1.500000_g44549_i0 PRJNA1196438 44976 281 1.5 4.215 Fusobacterium sp. 68766 Bacteria Bacteria 186 4.4099999999999995e-57   NR MCM1010421.1 68766 g44549 i0 93.5 0.99288256227758 93 6 99.3 0 279 1 145 237 MCM1010421.1 UDP-3-O-acyl-N-acetylglucosamine deacetylase [Fusobacterium sp.] diamond 279 186 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp.
31905760 31905760 PRJNA1196438_P_NODE_66217_length_251_cov_0.876404_g65790_i0 PRJNA1196438 66217 251 0.876404 2.19977404 Fusobacterium sp. 68766 Bacteria Bacteria 63.5 1.33e-9   NR MCM1010497.1 68766 g65790 i0 38.5 4.9601593625498 78 48 93.2 0 3 236 19 96 MCM1010497.1 DUF1566 domain-containing protein [Fusobacterium sp.] diamond 1245 63.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp.
32570512 32570512 PRJNA1196438_P_NODE_41099_length_287_cov_2.098131_g40672_i0 PRJNA1196438 41099 287 2.098131 6.02163597 Fusobacterium mortiferum 850 Bacteria Bacteria 144 4.51e-39   NR MBM6690699.1 850 g40672 i0 66.3 0.993031358885017 95 32 99.3 0 285 1 200 294 MBM6690699.1 aspartate aminotransferase family protein [Fusobacterium mortiferum] diamond 285 144 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium mortiferum

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