contig_metadata
11 rows where bioproject = "PRJNA674050" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3194620 | 3194620 | PRJNA674050_P_NODE_2523_length_434_cov_2.631579_g2320_i0 | PRJNA674050 | 2523 | 434 | 2.631579 | 11.42105286 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 797 | 0 | NTclustered | gi|1708582457|dbj|AP019841.1| | 157687 | g2320 | i0 | 99.77 | 557.896313364055 | 434 | 1 | 100 | 0 | 1 | 434 | 1757212 | 1756779 | Leptotrichia wadei JMUB3936 DNA, complete genome | blastn | 242127 | 797 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 4994561 | 4994561 | PRJNA674050_P_NODE_13104_length_283_cov_2.366667_g12901_i0 | PRJNA674050 | 13104 | 283 | 2.366667 | 6.69766761 | root | 1 | Root_unresolved | Root_unresolved | 507 | 4.64e-139 | NTclustered | gi|285798177|gb|GU408159.1| | 860 | g12901 | i0 | 98.94 | 139.992932862191 | 283 | 3 | 100 | 0 | 1 | 283 | 38 | 320 | Fusobacterium periodonticum clone DP015 16S ribosomal RNA gene, partial sequence | blastn | 39618 | 512 | 0.990234375 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium periodonticum | ||
| 4994583 | 4994583 | PRJNA674050_P_NODE_17544_length_266_cov_2.575130_g17341_i0 | PRJNA674050 | 17544 | 266 | 2.57513 | 6.8498458 | Fusobacterium | 848 | Bacteria | Bacteria | 492 | 1.2099999999999999e-134 | NTclustered | gi|2446175567|gb|CP117964.1| | 851 | g17341 | i0 | 100 | 490.503759398496 | 266 | 0 | 100 | 0 | 1 | 266 | 2087690 | 2087425 | Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome | blastn | 130474 | 492 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 4994592 | 4994592 | PRJNA674050_P_NODE_19364_length_260_cov_2.427807_g19161_i0 | PRJNA674050 | 19364 | 260 | 2.427807 | 6.3122982 | Fusobacterium | 848 | Bacteria | Bacteria | 481 | 2.55e-131 | NTclustered | gi|2573686249|gb|CP133474.1| | 851 | g19161 | i0 | 100 | 481.376923076923 | 260 | 0 | 100 | 0 | 1 | 260 | 322174 | 321915 | Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome | blastn | 125158 | 481 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 7023106 | 7023106 | PRJNA674050_P_NODE_6386_length_331_cov_1.612403_g6183_i0 | PRJNA674050 | 6386 | 331 | 1.612403 | 5.33705393 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 579 | 1.1599999999999996e-160 | NTclustered | gi|1276709865|gb|CP024700.1| | 2663009 | g6183 | i0 | 98.187 | 477.009063444109 | 331 | 6 | 100 | 0 | 1 | 331 | 2344874 | 2345204 | Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome | blastn | 157890 | 579 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 9572191 | 9572191 | PRJNA674050_P_NODE_23488_length_252_cov_0.865922_g23285_i0 | PRJNA674050 | 23488 | 252 | 0.865922 | 2.18212344 | Pseudoleptotrichia goodfellowii | 157692 | Bacteria | Bacteria | 455 | 1.49e-123 | NTclustered | gi|1708563796|dbj|AP019822.1| | 157692 | g23285 | i0 | 99.206 | 4.17857142857143 | 252 | 2 | 100 | 0 | 1 | 252 | 2033372 | 2033623 | Leptotrichia goodfellowii JCM16774 DNA, complete genome | blastn | 1053 | 455 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Pseudoleptotrichia | Pseudoleptotrichia goodfellowii | ||
| 11369859 | 11369859 | PRJNA674050_P_NODE_2269_length_451_cov_2.621693_g2066_i0 | PRJNA674050 | 2269 | 451 | 2.621693 | 11.82383543 | Fusobacterium | 848 | Bacteria | Bacteria | 822 | 0 | NTclustered | gi|15028908|emb|AJ307974.1| | 851 | g2066 | i0 | 99.557 | 422.133037694013 | 451 | 2 | 100 | 0 | 1 | 451 | 473 | 23 | Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482 | blastn | 190382 | 828 | 0.992753623188406 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 12645599 | 12645599 | PRJNA674050_P_NODE_12190_length_287_cov_2.630841_g11987_i0 | PRJNA674050 | 12190 | 287 | 2.630841 | 7.55051367 | Fusobacterium | 848 | Bacteria | Bacteria | 531 | 2.799999999999999e-146 | NTclustered | gi|2706041172|gb|CP056018.1| | 76857 | g11987 | i0 | 100 | 494.020905923345 | 287 | 0 | 100 | 0 | 1 | 287 | 502453 | 502739 | Fusobacterium polymorphum strain SB006 chromosome, complete genome | blastn | 141784 | 531 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 19017950 | 19017950 | PRJNA674050_P_NODE_10955_length_294_cov_1.144796_g10752_i0 | PRJNA674050 | 10955 | 294 | 1.144796 | 3.36570024 | Leptotrichia | 32067 | Bacteria | Bacteria | 538 | 1.7199999999999995e-148 | NTclustered | gi|470484715|ref|NR_076664.1| | 40542 | g10752 | i0 | 99.66 | 163.455782312925 | 294 | 1 | 100 | 0 | 1 | 294 | 167 | 460 | Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence | blastn | 48056 | 538 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia buccalis | ||
| 19771015 | 19771015 | PRJNA674050_P_NODE_3576_length_385_cov_1.548077_g3373_i0 | PRJNA674050 | 3576 | 385 | 1.548077 | 5.96009645 | Leptotrichia wadei | 157687 | Bacteria | Bacteria | 645 | 1.3299999999999995e-180 | NTclustered | gi|1708575239|dbj|AP019834.1| | 157687 | g3373 | i0 | 96.899 | 345.25974025974 | 387 | 8 | 100 | 3 | 1 | 385 | 1695367 | 1694983 | Leptotrichia wadei JMUB3933 DNA, complete genome | blastn | 132925 | 645 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia wadei | ||
| 24870134 | 24870134 | PRJNA674050_P_NODE_30640_length_247_cov_0.890805_g30437_i0 | PRJNA674050 | 30640 | 247 | 0.890805 | 2.20028835 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 457 | 4.05e-124 | NTclustered | gi|1276714546|gb|CP024702.1| | 2663009 | g30437 | i0 | 100 | 52.6761133603239 | 247 | 0 | 100 | 0 | 1 | 247 | 864882 | 864636 | Fusobacterium pseudoperiodonticum strain KCOM 1282 chromosome, complete genome | blastn | 13011 | 457 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum |
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);;