contig_metadata
19 rows where bioproject = "PRJNA1120203" and tax_kingdom = "Fusobacteriati"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2826089 | 2826089 | PRJNA1120203_P_NODE_81603_length_250_cov_0.870056_g80587_i0 | PRJNA1120203 | 81603 | 250 | 0.870056 | 2.17514 | Fusobacterium mortiferum | 850 | Bacteria | Bacteria | 462 | 8.83e-126 | NTclustered | gi|1370540179|gb|CP028102.1| | 469616 | g80587 | i0 | 100 | 1 | 250 | 0 | 100 | 0 | 1 | 250 | 2648532 | 2648781 | Fusobacterium mortiferum ATCC 9817 chromosome, complete genome | blastn | 250 | 462 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium mortiferum | ||
| 2826276 | 2826276 | PRJNA1120203_P_NODE_94443_length_245_cov_0.895349_g93427_i0 | PRJNA1120203 | 94443 | 245 | 0.895349 | 2.19360505 | Fusobacterium ulcerans | 861 | Bacteria | Bacteria | 448 | 2.41e-121 | NTclustered | gi|1370545701|gb|CP028105.1| | 861 | g93427 | i0 | 99.592 | 80.6530612244898 | 245 | 1 | 100 | 0 | 1 | 245 | 510003 | 510247 | Fusobacterium ulcerans strain ATCC 49185 chromosome, complete genome | blastn | 19760 | 448 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium ulcerans | ||
| 2826302 | 2826302 | PRJNA1120203_P_NODE_96463_length_244_cov_0.900585_g95447_i0 | PRJNA1120203 | 96463 | 244 | 0.900585 | 2.1974274 | Fusobacterium mortiferum | 850 | Bacteria | Bacteria | 435 | 1.87e-117 | NTclustered | gi|1370540179|gb|CP028102.1| | 469616 | g95447 | i0 | 98.77 | 1 | 244 | 3 | 100 | 0 | 1 | 244 | 2241288 | 2241045 | Fusobacterium mortiferum ATCC 9817 chromosome, complete genome | blastn | 244 | 435 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium mortiferum | ||
| 4856161 | 4856161 | PRJNA1120203_P_NODE_86024_length_248_cov_0.880000_g85008_i0 | PRJNA1120203 | 86024 | 248 | 0.88 | 2.1824 | Fusobacterium | 848 | Bacteria | Bacteria | 268 | 2.05e-67 | NTclustered | gi|2444100754|gb|CP117525.1| | 851 | g85008 | i0 | 99.324 | 59.4959677419355 | 148 | 1 | 60 | 0 | 101 | 248 | 262091 | 261944 | Fusobacterium nucleatum strain FNV chromosome, complete genome | blastn | 14755 | 268 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 5378549 | 5378549 | PRJNA1120203_P_NODE_83485_length_249_cov_0.875000_g82469_i0 | PRJNA1120203 | 83485 | 249 | 0.875 | 2.17875 | Fusobacterium mortiferum | 850 | Bacteria | Bacteria | 455 | 1.47e-123 | NTclustered | gi|1370540179|gb|CP028102.1| | 469616 | g82469 | i0 | 99.598 | 1 | 249 | 1 | 100 | 0 | 1 | 249 | 782854 | 783102 | Fusobacterium mortiferum ATCC 9817 chromosome, complete genome | blastn | 249 | 455 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium mortiferum | ||
| 6653114 | 6653114 | PRJNA1120203_P_NODE_70926_length_266_cov_1.409326_g69910_i0 | PRJNA1120203 | 70926 | 266 | 1.409326 | 3.74880716 | Fusobacterium mortiferum | 850 | Bacteria | Bacteria | 464 | 2.64e-126 | NTclustered | gi|1370540179|gb|CP028102.1| | 469616 | g69910 | i0 | 98.12 | 1 | 266 | 5 | 100 | 0 | 1 | 266 | 1183883 | 1183618 | Fusobacterium mortiferum ATCC 9817 chromosome, complete genome | blastn | 266 | 464 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium mortiferum | ||
| 8681072 | 8681072 | PRJNA1120203_P_NODE_48667_length_324_cov_1.167331_g47651_i0 | PRJNA1120203 | 48667 | 324 | 1.167331 | 3.78215244 | Cetobacterium | 180162 | Bacteria | Bacteria | 547 | 3.18e-151 | NTclustered | gi|2666488225|gb|CP143319.1| | 188913 | g47651 | i0 | 97.214 | 22.2932098765432 | 323 | 9 | 99 | 0 | 2 | 324 | 1948736 | 1948414 | Cetobacterium somerae strain ceto chromosome, complete genome | blastn | 7223 | 547 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 11230989 | 11230989 | PRJNA1120203_P_NODE_31289_length_420_cov_1.772334_g30274_i0 | PRJNA1120203 | 31289 | 420 | 1.772334 | 7.4438028 | Fusobacterium | 848 | Bacteria | Bacteria | 771 | 0 | NTclustered | gi|1370537877|gb|CP028108.1| | 860 | g30274 | i0 | 99.762 | 489.007142857143 | 420 | 1 | 100 | 0 | 1 | 420 | 462627 | 463046 | Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome | blastn | 205383 | 771 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium periodonticum | ||
| 11753996 | 11753996 | PRJNA1120203_P_NODE_85970_length_248_cov_0.880000_g84954_i0 | PRJNA1120203 | 85970 | 248 | 0.88 | 2.1824 | Fusobacterium mortiferum | 850 | Bacteria | Bacteria | 459 | 1.13e-124 | NTclustered | gi|1370540179|gb|CP028102.1| | 469616 | g84954 | i0 | 100 | 1 | 248 | 0 | 100 | 0 | 1 | 248 | 1027908 | 1027661 | Fusobacterium mortiferum ATCC 9817 chromosome, complete genome | blastn | 248 | 459 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium mortiferum | ||
| 13029228 | 13029228 | PRJNA1120203_P_NODE_88111_length_247_cov_1.741379_g87095_i0 | PRJNA1120203 | 88111 | 247 | 1.741379 | 4.30120613 | Fusobacterium nucleatum | 851 | Bacteria | Bacteria | 457 | 4.05e-124 | NTclustered | gi|2704968189|gb|CP077126.1| | 851 | g87095 | i0 | 100 | 100 | 247 | 0 | 100 | 0 | 1 | 247 | 1399658 | 1399904 | Fusobacterium nucleatum strain KCOM3685 chromosome, complete genome | blastn | 24700 | 457 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 14304474 | 14304474 | PRJNA1120203_P_NODE_94672_length_245_cov_0.895349_g93656_i0 | PRJNA1120203 | 94672 | 245 | 0.895349 | 2.19360505 | Fusobacterium sp. oral taxon 2 | 68766 | Bacteria | Bacteria | 120 | 1.28e-29 | NR | WP_094243087.1 | 671211 | g93656 | i0 | 69.5 | 1.00408163265306 | 82 | 19 | 93.1 | 1 | 2 | 229 | 227 | 308 | WP_094243087.1 autotransporter-associated N-terminal domain-containing protein, partial [Fusobacterium sp. oral taxon 203] | diamond | 246 | 120 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium sp. oral taxon 203 | ||
| 14304521 | 14304521 | PRJNA1120203_P_NODE_97412_length_244_cov_0.900585_g96396_i0 | PRJNA1120203 | 97412 | 244 | 0.900585 | 2.1974274 | Fusobacterium mortiferum | 850 | Bacteria | Bacteria | 451 | 1.86e-122 | NTclustered | gi|1370540179|gb|CP028102.1| | 469616 | g96396 | i0 | 100 | 1 | 244 | 0 | 100 | 0 | 1 | 244 | 1731795 | 1732038 | Fusobacterium mortiferum ATCC 9817 chromosome, complete genome | blastn | 244 | 451 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium mortiferum | ||
| 16851832 | 16851832 | PRJNA1120203_P_NODE_104274_length_241_cov_0.916667_g103258_i0 | PRJNA1120203 | 104274 | 241 | 0.916667 | 2.20916747 | Fusobacterium sp. | 68766 | Bacteria | Bacteria | 121 | 5.39e-32 | NR | WP_300453215.1 | 68766 | g103258 | i0 | 93.5 | 0.771784232365145 | 62 | 4 | 77.2 | 0 | 187 | 2 | 1 | 62 | WP_300453215.1 amino acid ABC transporter substrate-binding protein [Fusobacterium sp.] | diamond | 186 | 121 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium sp. | ||
| 18127043 | 18127043 | PRJNA1120203_P_NODE_77895_length_251_cov_1.443820_g76879_i0 | PRJNA1120203 | 77895 | 251 | 1.44382 | 3.6239882 | Fusobacterium nucleatum | 851 | Bacteria | Bacteria | 453 | 5.34e-123 | NTclustered | gi|2705013194|gb|CP084126.1| | 851 | g76879 | i0 | 99.203 | 98.9362549800797 | 251 | 2 | 100 | 0 | 1 | 251 | 157852 | 158102 | Fusobacterium nucleatum strain KCOM2205 chromosome, complete genome | blastn | 24833 | 453 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 21951534 | 21951534 | PRJNA1120203_P_NODE_36558_length_381_cov_0.811688_g35543_i0 | PRJNA1120203 | 36558 | 381 | 0.811688 | 3.09253128 | Fusobacterium mortiferum | 850 | Bacteria | Bacteria | 361 | 5.309999999999999e-95 | NTclustered | gi|1370540179|gb|CP028102.1| | 469616 | g35543 | i0 | 100 | 90.4356955380577 | 195 | 0 | 51 | 0 | 187 | 381 | 671155 | 670961 | Fusobacterium mortiferum ATCC 9817 chromosome, complete genome | blastn | 34456 | 361 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium mortiferum | ||
| 21952165 | 21952165 | PRJNA1120203_P_NODE_79258_length_251_cov_0.865169_g78242_i0 | PRJNA1120203 | 79258 | 251 | 0.865169 | 2.17157419 | Fusobacterium mortiferum | 850 | Bacteria | Bacteria | 448 | 2.48e-121 | NTclustered | gi|1370540179|gb|CP028102.1| | 469616 | g78242 | i0 | 98.805 | 3.90438247011952 | 251 | 3 | 100 | 0 | 1 | 251 | 2098124 | 2098374 | Fusobacterium mortiferum ATCC 9817 chromosome, complete genome | blastn | 980 | 448 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium mortiferum | ||
| 23227943 | 23227943 | PRJNA1120203_P_NODE_96799_length_244_cov_0.900585_g95783_i0 | PRJNA1120203 | 96799 | 244 | 0.900585 | 2.1974274 | Leptotrichia sp. oral taxon 218 | 712361 | Bacteria | Bacteria | 435 | 1.87e-117 | NTclustered | gi|2028887161|gb|CP072377.1| | 712361 | g95783 | i0 | 98.77 | 3.99180327868852 | 244 | 3 | 100 | 0 | 1 | 244 | 1907066 | 1906823 | Leptotrichia sp. oral taxon 218 strain F0707 chromosome, complete genome | blastn | 974 | 435 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 218 | ||
| 28554571 | 28554571 | PRJNA1120203_P_NODE_96607_length_244_cov_0.900585_g95591_i0 | PRJNA1120203 | 96607 | 244 | 0.900585 | 2.1974274 | Fusobacterium sp. | 68766 | Bacteria | Bacteria | 155 | 6.379999999999999e-43 | NR | WP_291254847.1 | 68766 | g95591 | i0 | 98.7 | 1.94262295081967 | 79 | 1 | 97.1 | 0 | 239 | 3 | 322 | 400 | WP_291254847.1 RAMP superfamily CRISPR-associated protein [Fusobacterium sp.] | diamond | 474 | 155 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium sp. | ||
| 31766052 | 31766052 | PRJNA1120203_P_NODE_100917_length_243_cov_0.882353_g99901_i0 | PRJNA1120203 | 100917 | 243 | 0.882353 | 2.14411779 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 155 | 1.24e-41 | NR | CDE92132.1 | 1262901 | g99901 | i0 | 97.5 | 2 | 81 | 2 | 100 | 0 | 1 | 243 | 22 | 102 | CDE92132.1 chromosome partition protein Smc [Fusobacterium sp. CAG:815] | diamond | 486 | 155 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium sp. CAG:815 |
Advanced export
JSON shape: default, array, newline-delimited
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);;