contig_metadata
19 rows where bioproject = "PRJNA1073712" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187549 | 187549 | PRJNA1073712_P_NODE_13041_length_248_cov_0.880000_g12958_i0 | PRJNA1073712 | 13041 | 248 | 0.88 | 2.1824 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 453 | 5.2600000000000005e-123 | NTclustered | gi|1276720946|gb|CP024705.1| | 2663009 | g12958 | i0 | 99.597 | 99.8588709677419 | 248 | 1 | 100 | 0 | 1 | 248 | 1394309 | 1394062 | Fusobacterium pseudoperiodonticum strain KCOM 2653 chromosome, complete genome | blastn | 24765 | 453 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 4014085 | 4014085 | PRJNA1073712_P_NODE_7564_length_287_cov_1.677570_g7481_i0 | PRJNA1073712 | 7564 | 287 | 1.67757 | 4.8146259 | Fusobacterium polymorphum | 76857 | Bacteria | Bacteria | 529 | 1.01e-145 | NTclustered | gi|2706071841|gb|CP077111.1| | 76857 | g7481 | i0 | 100 | 466.560975609756 | 286 | 0 | 99 | 0 | 1 | 286 | 2465405 | 2465120 | Fusobacterium polymorphum strain KCOM1275 chromosome, complete genome | blastn | 133903 | 529 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 7840272 | 7840272 | PRJNA1073712_P_NODE_7467_length_288_cov_2.032558_g7384_i0 | PRJNA1073712 | 7467 | 288 | 2.032558 | 5.85376704 | Leptotrichia sp. oral taxon 498 | 712368 | Bacteria | Bacteria | 494 | 3.68e-135 | NTclustered | gi|1227268105|gb|CP016753.1| | 712368 | g7384 | i0 | 97.578 | 398.038194444444 | 289 | 5 | 100 | 2 | 1 | 288 | 593348 | 593635 | Leptotrichia sp. oral taxon 498, complete genome | blastn | 114635 | 494 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 498 | ||
| 8669367 | 8669367 | PRJNA1073712_P_NODE_16387_length_242_cov_0.911243_g16304_i0 | PRJNA1073712 | 16387 | 242 | 0.911243 | 2.20520806 | Fusobacterium | 848 | Bacteria | Bacteria | 448 | 2.3799999999999995e-121 | NTclustered | gi|2704983719|gb|CP077132.1| | 851 | g16304 | i0 | 100 | 100.01652892562 | 242 | 0 | 100 | 0 | 1 | 242 | 1895048 | 1895289 | Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome | blastn | 24204 | 448 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 10390855 | 10390855 | PRJNA1073712_P_NODE_14449_length_245_cov_0.895349_g14366_i0 | PRJNA1073712 | 14449 | 245 | 0.895349 | 2.19360505 | Leptotrichia sp. HMT-225 | 3058373 | Bacteria | Bacteria | 448 | 2.41e-121 | NTclustered | gi|2557559843|gb|CP130323.1| | 3058373 | g14366 | i0 | 99.592 | 16.5020408163265 | 245 | 1 | 100 | 0 | 1 | 245 | 715968 | 715724 | Leptotrichia sp. HMT-225 chromosome, complete genome | blastn | 4043 | 448 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. HMT-225 | ||
| 10390857 | 10390857 | PRJNA1073712_P_NODE_14629_length_245_cov_0.895349_g14546_i0 | PRJNA1073712 | 14629 | 245 | 0.895349 | 2.19360505 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 442 | 1.1199999999999994e-119 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g14546 | i0 | 99.184 | 1 | 245 | 2 | 100 | 0 | 1 | 245 | 1927585 | 1927829 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 245 | 442 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 11666222 | 11666222 | PRJNA1073712_P_NODE_13090_length_248_cov_0.880000_g13007_i0 | PRJNA1073712 | 13090 | 248 | 0.88 | 2.1824 | Fusobacterium massiliense | 1852365 | Bacteria | Bacteria | 157 | 2.15e-43 | NR | WP_074016534.1 | 1852365 | g13007 | i0 | 98.8 | 0.991935483870968 | 82 | 1 | 99.2 | 0 | 1 | 246 | 210 | 291 | WP_074016534.1 biosynthetic-type acetolactate synthase large subunit [Fusobacterium massiliense] | diamond | 246 | 157 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium massiliense | ||
| 12941350 | 12941350 | PRJNA1073712_P_NODE_15431_length_243_cov_1.794118_g15348_i0 | PRJNA1073712 | 15431 | 243 | 1.794118 | 4.35970674 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 438 | 1.4399999999999996e-118 | NTclustered | gi|1276709865|gb|CP024700.1| | 2663009 | g15348 | i0 | 99.177 | 99.3827160493827 | 243 | 2 | 100 | 0 | 1 | 243 | 293465 | 293707 | Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome | blastn | 24150 | 438 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 15043807 | 15043807 | PRJNA1073712_P_NODE_12652_length_248_cov_1.360000_g12569_i0 | PRJNA1073712 | 12652 | 248 | 1.36 | 3.3728 | Fusobacterium | 848 | Bacteria | Bacteria | 453 | 5.2600000000000005e-123 | NTclustered | gi|2704983719|gb|CP077132.1| | 851 | g12569 | i0 | 99.597 | 100 | 248 | 1 | 100 | 0 | 1 | 248 | 79793 | 79546 | Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome | blastn | 24800 | 453 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 15490141 | 15490141 | PRJNA1073712_P_NODE_10693_length_255_cov_1.467033_g10610_i0 | PRJNA1073712 | 10693 | 255 | 1.467033 | 3.74093415 | Fusobacterium nucleatum | 851 | Bacteria | Bacteria | 472 | 1.5e-128 | NTclustered | gi|2705009267|gb|CP084119.1| | 851 | g10610 | i0 | 100 | 209.321568627451 | 255 | 0 | 100 | 0 | 1 | 255 | 2297826 | 2297572 | Fusobacterium nucleatum strain KCOM1801 chromosome, complete genome | blastn | 53377 | 472 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 18039243 | 18039243 | PRJNA1073712_P_NODE_14415_length_245_cov_0.895349_g14332_i0 | PRJNA1073712 | 14415 | 245 | 0.895349 | 2.19360505 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 392 | 1.15e-104 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g14332 | i0 | 95.51 | 2.1265306122449 | 245 | 11 | 100 | 0 | 1 | 245 | 640406 | 640650 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 521 | 392 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 18867749 | 18867749 | PRJNA1073712_P_NODE_15135_length_244_cov_0.900585_g15052_i0 | PRJNA1073712 | 15135 | 244 | 0.900585 | 2.1974274 | Fusobacterium | 848 | Bacteria | Bacteria | 451 | 1.86e-122 | NTclustered | gi|2704983719|gb|CP077132.1| | 851 | g15052 | i0 | 100 | 99.8319672131148 | 244 | 0 | 100 | 0 | 1 | 244 | 1592833 | 1592590 | Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome | blastn | 24359 | 451 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 19313321 | 19313321 | PRJNA1073712_P_NODE_17036_length_241_cov_0.916667_g16953_i0 | PRJNA1073712 | 17036 | 241 | 0.916667 | 2.20916747 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 446 | 8.519999999999999e-121 | NTclustered | gi|1276712381|gb|CP024701.1| | 2663009 | g16953 | i0 | 100 | 99.1244813278008 | 241 | 0 | 100 | 0 | 1 | 241 | 2167477 | 2167237 | Fusobacterium pseudoperiodonticum strain KCOM 1277 chromosome, complete genome | blastn | 23889 | 446 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 21864440 | 21864440 | PRJNA1073712_P_NODE_4858_length_336_cov_1.049430_g4775_i0 | PRJNA1073712 | 4858 | 336 | 1.04943 | 3.5260848 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 621 | 1.9299999999999997e-173 | NTclustered | gi|1276705688|gb|CP024698.1| | 2663009 | g4775 | i0 | 100 | 483.892857142857 | 336 | 0 | 100 | 0 | 1 | 336 | 509842 | 509507 | Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome | blastn | 162588 | 621 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 21864470 | 21864470 | PRJNA1073712_P_NODE_9678_length_265_cov_1.484375_g9595_i0 | PRJNA1073712 | 9678 | 265 | 1.484375 | 3.93359375 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 379 | 9.78e-101 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g9595 | i0 | 92.453 | 1 | 265 | 20 | 100 | 0 | 1 | 265 | 1719670 | 1719406 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 265 | 379 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 22693087 | 22693087 | PRJNA1073712_P_NODE_13958_length_246_cov_0.890173_g13875_i0 | PRJNA1073712 | 13958 | 246 | 0.890173 | 2.18982558 | Fusobacterium | 848 | Bacteria | Bacteria | 292 | 1.2e-74 | NTclustered | gi|958162200|gb|CP013331.1| | 1307442 | g13875 | i0 | 88.525 | 98.1463414634146 | 244 | 24 | 98 | 3 | 1 | 242 | 87914 | 88155 | Fusobacterium hwasookii ChDC F174, complete genome | blastn | 24144 | 292 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium hwasookii | ||
| 22693104 | 22693104 | PRJNA1073712_P_NODE_15778_length_243_cov_0.905882_g15695_i0 | PRJNA1073712 | 15778 | 243 | 0.905882 | 2.20129326 | root | 1 | Root_unresolved | Root_unresolved | 444 | 3.09e-120 | NTclustered | gi|2704944210|gb|CP077182.1| | 851 | g15695 | i0 | 99.588 | 25.7160493827161 | 243 | 1 | 100 | 0 | 1 | 243 | 730197 | 729955 | Fusobacterium nucleatum strain SB032 chromosome, complete genome | blastn | 6249 | 444 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 23968579 | 23968579 | PRJNA1073712_P_NODE_15879_length_243_cov_0.905882_g15796_i0 | PRJNA1073712 | 15879 | 243 | 0.905882 | 2.20129326 | Fusobacterium | 848 | Bacteria | Bacteria | 449 | 6.65e-122 | NTclustered | gi|1208657894|gb|CP021934.1| | 76857 | g15796 | i0 | 100 | 62.9547325102881 | 243 | 0 | 100 | 0 | 1 | 243 | 1386192 | 1386434 | Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome | blastn | 15298 | 449 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 24413492 | 24413492 | PRJNA1073712_P_NODE_14600_length_245_cov_0.895349_g14517_i0 | PRJNA1073712 | 14600 | 245 | 0.895349 | 2.19360505 | Fusobacterium nucleatum | 851 | Bacteria | Bacteria | 185 | 2.09e-42 | NTclustered | gi|1370533788|gb|CP028109.1| | 525283 | g14517 | i0 | 90.141 | 14.5959183673469 | 142 | 14 | 58 | 0 | 104 | 245 | 314179 | 314320 | Fusobacterium nucleatum subsp. nucleatum ATCC 23726 chromosome, complete genome | blastn | 3576 | 185 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum |
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);;