contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1066877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7832880 | 7832880 | PRJNA1066877_S_NODE_10627_length_172_cov_1.081301_g10592_i0 | PRJNA1066877 | 10627 | 172 | 1.081301 | 1.85983772 | Fusobacterium polymorphum | 76857 | Bacteria | Bacteria | 318 | 1.2899999999999999e-82 | NTclustered | gi|2706407748|gb|CP077116.1| | 76857 | g10592 | i0 | 100 | 100.877906976744 | 172 | 0 | 100 | 0 | 1 | 172 | 820074 | 820245 | Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome | blastn | 17351 | 318 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 8666100 | 8666100 | PRJNA1066877_S_NODE_12487_length_163_cov_0.894737_g12452_i0 | PRJNA1066877 | 12487 | 163 | 0.894737 | 1.45842131 | Leptotrichia | 32067 | Bacteria | Bacteria | 185 | 1.28e-42 | NTclustered | gi|2028887161|gb|CP072377.1| | 712361 | g12452 | i0 | 94.215 | 54.2147239263804 | 121 | 7 | 85 | 0 | 1 | 121 | 1819999 | 1820119 | Leptotrichia sp. oral taxon 218 strain F0707 chromosome, complete genome | blastn | 8837 | 185 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 218 | ||
| 12934122 | 12934122 | PRJNA1066877_S_NODE_3611_length_258_cov_1.100478_g3576_i0 | PRJNA1066877 | 3611 | 258 | 1.100478 | 2.83923324 | Fusobacterium polymorphum | 76857 | Bacteria | Bacteria | 477 | 3.2699999999999985e-130 | NTclustered | gi|2706506546|gb|CP084156.1| | 76857 | g3576 | i0 | 100 | 99.7480620155039 | 258 | 0 | 100 | 0 | 1 | 258 | 1506939 | 1506682 | Fusobacterium polymorphum strain KCOM2510 chromosome | blastn | 25735 | 477 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 13766468 | 13766468 | PRJNA1066877_S_NODE_9751_length_178_cov_1.472868_g9716_i0 | PRJNA1066877 | 9751 | 178 | 1.472868 | 2.62170504 | Fusobacterium | 848 | Bacteria | Bacteria | 329 | 6.21e-86 | NTclustered | gi|2706407748|gb|CP077116.1| | 76857 | g9716 | i0 | 100 | 100 | 178 | 0 | 100 | 0 | 1 | 178 | 114022 | 114199 | Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome | blastn | 17800 | 329 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 15040804 | 15040804 | PRJNA1066877_S_NODE_8912_length_185_cov_1.066176_g8877_i0 | PRJNA1066877 | 8912 | 185 | 1.066176 | 1.9724256 | Fusobacterium | 848 | Bacteria | Bacteria | 337 | 3.89e-88 | NTclustered | gi|2705007409|gb|CP084122.1| | 851 | g8877 | i0 | 99.459 | 100 | 185 | 1 | 100 | 0 | 1 | 185 | 402837 | 402653 | Fusobacterium nucleatum strain KCOM3412 chromosome, complete genome | blastn | 18500 | 337 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 18864472 | 18864472 | PRJNA1066877_S_NODE_11955_length_165_cov_0.879310_g11920_i0 | PRJNA1066877 | 11955 | 165 | 0.87931 | 1.4508615 | Fusobacterium | 848 | Bacteria | Bacteria | 300 | 4.46e-77 | NTclustered | gi|2446175567|gb|CP117964.1| | 851 | g11920 | i0 | 99.394 | 97.8909090909091 | 165 | 1 | 100 | 0 | 1 | 165 | 1286643 | 1286807 | Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome | blastn | 16152 | 300 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 25239198 | 25239198 | PRJNA1066877_S_NODE_11580_length_166_cov_1.128205_g11545_i0 | PRJNA1066877 | 11580 | 166 | 1.128205 | 1.8728203 | Fusobacterium | 848 | Bacteria | Bacteria | 307 | 2.69e-79 | NTclustered | gi|2706407748|gb|CP077116.1| | 76857 | g11545 | i0 | 100 | 99.4578313253012 | 166 | 0 | 100 | 0 | 1 | 166 | 778775 | 778940 | Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome | blastn | 16510 | 307 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum |
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);;