contig_metadata
11 rows where bioproject = "PRJNA400391" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 414051 | 414051 | PRJNA400391_S_NODE_4661_length_185_cov_1.620000_g4600_i0 | PRJNA400391 | 4661 | 185 | 1.62 | 2.997 | Leptotrichia sp. oral taxon 221 | 712362 | Bacteria | Bacteria | 315 | 1.8199999999999998e-81 | NTclustered | gi|2028889048|gb|CP072378.1| | 712362 | g4600 | i0 | 97.802 | 63.8216216216216 | 182 | 4 | 98 | 0 | 4 | 185 | 25811 | 25630 | Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome | blastn | 11807 | 315 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 221 | ||
| 4241195 | 4241195 | PRJNA400391_S_NODE_5184_length_173_cov_437.528986_g5123_i0 | PRJNA400391 | 5184 | 173 | 437.528986 | 756.92514578 | Leptotrichia hongkongensis | 554406 | Bacteria | Bacteria | 309 | 7.81e-80 | NTclustered | gi|1708587163|dbj|AP019846.1| | 554406 | g5123 | i0 | 98.844 | 449.387283236994 | 173 | 2 | 100 | 0 | 1 | 173 | 1622612 | 1622440 | Leptotrichia hongkongensis JMUB5056 DNA, complete genome | blastn | 77744 | 309 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia hongkongensis | ||
| 6184117 | 6184117 | PRJNA400391_S_NODE_25_length_920_cov_83.616949_g16_i0 | PRJNA400391 | 25 | 920 | 83.616949 | 769.2759308 | Cetobacterium | 180162 | Bacteria | Bacteria | 1345 | 0 | NTclustered | gi|2865368125|gb|CP122294.1| | 188913 | g16 | i0 | 99.593 | 431.495652173913 | 737 | 3 | 80 | 0 | 119 | 855 | 279617 | 278881 | Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence | blastn | 396976 | 1345 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 8067392 | 8067392 | PRJNA400391_S_NODE_3367_length_219_cov_3.413043_g3306_i0 | PRJNA400391 | 3367 | 219 | 3.413043 | 7.47456417 | Leptotrichia sp. oral taxon 221 | 712362 | Bacteria | Bacteria | 313 | 8.05e-81 | NTclustered | gi|2028889048|gb|CP072378.1| | 712362 | g3306 | i0 | 98.857 | 89.296803652968 | 175 | 2 | 81 | 0 | 8 | 182 | 23496 | 23670 | Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome | blastn | 19556 | 313 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 221 | ||
| 8733850 | 8733850 | PRJNA400391_S_NODE_3187_length_225_cov_5.805263_g3126_i0 | PRJNA400391 | 3187 | 225 | 5.805263 | 13.06184175 | Fusobacterium | 848 | Bacteria | Bacteria | 361 | 2.9299999999999993e-95 | NTclustered | gi|2705042081|gb|CP085192.1| | 856 | g3126 | i0 | 95.556 | 523.444444444444 | 225 | 10 | 100 | 0 | 1 | 225 | 3422442 | 3422666 | Fusobacterium varium strain SB069 chromosome | blastn | 117775 | 361 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium varium | ||
| 9342249 | 9342249 | PRJNA400391_S_NODE_3948_length_203_cov_1.255952_g3887_i0 | PRJNA400391 | 3948 | 203 | 1.255952 | 2.54958256 | Leptotrichia sp. oral taxon 221 | 712362 | Bacteria | Bacteria | 342 | 9.369999999999999e-90 | NTclustered | gi|2028889048|gb|CP072378.1| | 712362 | g3887 | i0 | 98.953 | 54.3103448275862 | 191 | 2 | 94 | 0 | 1 | 191 | 25665 | 25475 | Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome | blastn | 11025 | 342 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 221 | ||
| 15716759 | 15716759 | PRJNA400391_S_NODE_3033_length_231_cov_2.556122_g2972_i0 | PRJNA400391 | 3033 | 231 | 2.556122 | 5.90464182 | Leptotrichia sp. oral taxon 221 | 712362 | Bacteria | Bacteria | 427 | 2.9399999999999998e-115 | NTclustered | gi|2028889048|gb|CP072378.1| | 712362 | g2972 | i0 | 100 | 484.463203463203 | 231 | 0 | 100 | 0 | 1 | 231 | 26495 | 26725 | Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome | blastn | 111911 | 427 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 221 | ||
| 17658588 | 17658588 | PRJNA400391_S_NODE_34_length_888_cov_86.058617_g16_i1 | PRJNA400391 | 34 | 888 | 86.058617 | 764.20051896 | Cetobacterium | 180162 | Bacteria | Bacteria | 1476 | 0 | NTclustered | gi|2865368125|gb|CP122294.1| | 188913 | g16 | i1 | 99.028 | 485.826576576577 | 823 | 8 | 93 | 0 | 1 | 823 | 279703 | 278881 | Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence | blastn | 431414 | 1476 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 20207209 | 20207209 | PRJNA400391_S_NODE_2216_length_268_cov_3.948498_g2155_i0 | PRJNA400391 | 2216 | 268 | 3.948498 | 10.58197464 | Sebaldella | 32068 | Bacteria | Bacteria | 235 | 2.27e-57 | NTclustered | gi|470485033|ref|NR_076681.1| | 826 | g2155 | i0 | 82.721 | 485.410447761194 | 272 | 39 | 100 | 8 | 1 | 268 | 1654 | 1921 | Sebaldella termitidis strain ATCC 33386 23S ribosomal RNA gene, complete sequence | blastn | 130090 | 235 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Sebaldella | Sebaldella termitidis | ||
| 20815711 | 20815711 | PRJNA400391_S_NODE_3077_length_229_cov_9.010309_g3016_i0 | PRJNA400391 | 3077 | 229 | 9.010309 | 20.63360761 | Cetobacterium somerae | 188913 | Bacteria | Bacteria | 418 | 1.7499999999999995e-112 | NTclustered | gi|2850954511|gb|CP173065.1| | 1319815 | g3016 | i0 | 99.563 | 500.633187772926 | 229 | 1 | 100 | 0 | 1 | 229 | 941118 | 941346 | Cetobacterium somerae ATCC BAA-474 chromosome | blastn | 114645 | 418 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 21482766 | 21482766 | PRJNA400391_S_NODE_5657_length_165_cov_493.607692_g5596_i0 | PRJNA400391 | 5657 | 165 | 493.607692 | 814.4526918 | Cetobacterium | 180162 | Bacteria | Bacteria | 305 | 9.59e-79 | NTclustered | gi|2865368125|gb|CP122294.1| | 188913 | g5596 | i0 | 100 | 510 | 165 | 0 | 100 | 0 | 1 | 165 | 279821 | 279985 | Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence | blastn | 84150 | 305 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae |
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);;