contig_metadata
14 rows where bioproject = "PRJNA1010662" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6104629 | 6104629 | PRJNA1010662_S_NODE_1245_length_269_cov_6.867257_g1200_i0 | PRJNA1010662 | 1245 | 269 | 6.867257 | 18.47292133 | Cetobacterium | 180162 | Bacteria | Bacteria | 497 | 2.63e-136 | NTclustered | gi|2865368125|gb|CP122294.1| | 188913 | g1200 | i0 | 100 | 523.513011152416 | 269 | 0 | 100 | 0 | 1 | 269 | 280799 | 280531 | Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence | blastn | 140825 | 497 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 6533176 | 6533176 | PRJNA1010662_S_NODE_4606_length_162_cov_2.008403_g4561_i0 | PRJNA1010662 | 4606 | 162 | 2.008403 | 3.25361286 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 233 | 4.49e-57 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g4561 | i0 | 92.593 | 7.41358024691358 | 162 | 12 | 100 | 0 | 1 | 162 | 1472484 | 1472645 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 1201 | 233 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 7807522 | 7807522 | PRJNA1010662_S_NODE_2667_length_203_cov_1.200000_g2622_i0 | PRJNA1010662 | 2667 | 203 | 1.2 | 2.436 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 375 | 9.24e-100 | NTclustered | gi|1276714546|gb|CP024702.1| | 2663009 | g2622 | i0 | 100 | 12 | 203 | 0 | 100 | 0 | 1 | 203 | 2100836 | 2100634 | Fusobacterium pseudoperiodonticum strain KCOM 1282 chromosome, complete genome | blastn | 2436 | 375 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 7807528 | 7807528 | PRJNA1010662_S_NODE_3147_length_190_cov_1.959184_g3102_i0 | PRJNA1010662 | 3147 | 190 | 1.959184 | 3.7224496 | Fusobacterium pseudoperiodonticum | 2663009 | Bacteria | Bacteria | 340 | 3.1099999999999993e-89 | NTclustered | gi|2705022034|gb|CP084128.1| | 2663009 | g3102 | i0 | 98.947 | 100.1 | 190 | 2 | 100 | 0 | 1 | 190 | 1831743 | 1831932 | Fusobacterium pseudoperiodonticum strain KCOM1322 chromosome, complete genome | blastn | 19019 | 340 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium pseudoperiodonticum | ||
| 10358091 | 10358091 | PRJNA1010662_S_NODE_1669_length_241_cov_9.489899_g1624_i0 | PRJNA1010662 | 1669 | 241 | 9.489899 | 22.87065659 | Cetobacterium somerae | 188913 | Bacteria | Bacteria | 442 | 1.0999999999999999e-119 | NTclustered | gi|2666488225|gb|CP143319.1| | 188913 | g1624 | i0 | 100 | 447.381742738589 | 239 | 0 | 99 | 0 | 2 | 240 | 1318987 | 1318749 | Cetobacterium somerae strain ceto chromosome, complete genome | blastn | 107819 | 442 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 10358118 | 10358118 | PRJNA1010662_S_NODE_5469_length_151_cov_0.657407_g5424_i0 | PRJNA1010662 | 5469 | 151 | 0.657407 | 0.99268457 | Sneathia vaginalis | 187101 | Bacteria | Bacteria | 279 | 5.19e-71 | NTclustered | gi|808076794|gb|CP011280.1| | 187101 | g5424 | i0 | 100 | 237.841059602649 | 151 | 0 | 100 | 0 | 1 | 151 | 160724 | 160574 | Sneathia vaginalis strain SN35 chromosome, complete genome | blastn | 35914 | 279 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Sneathia | Sneathia vaginalis | ||
| 12908670 | 12908670 | PRJNA1010662_S_NODE_2811_length_199_cov_1.070513_g2766_i0 | PRJNA1010662 | 2811 | 199 | 1.070513 | 2.13032087 | Leptotrichia sp. oral taxon 212 | 712357 | Bacteria | Bacteria | 315 | 1.99e-81 | NTclustered | gi|922689899|gb|CP012410.1| | 712357 | g2766 | i0 | 96.335 | 28.2311557788945 | 191 | 7 | 96 | 0 | 1 | 191 | 52080 | 51890 | Leptotrichia sp. oral taxon 212 strain W10393, complete genome | blastn | 5618 | 315 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 212 | ||
| 13754882 | 13754882 | PRJNA1010662_S_NODE_3571_length_180_cov_2.065693_g3526_i0 | PRJNA1010662 | 3571 | 180 | 2.065693 | 3.7182474 | Fusobacterium | 848 | Bacteria | Bacteria | 333 | 4.87e-87 | NTclustered | gi|2078816781|gb|CP071094.1| | 76857 | g3526 | i0 | 100 | 476.972222222222 | 180 | 0 | 100 | 0 | 1 | 180 | 963930 | 963751 | Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome | blastn | 85855 | 333 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 16303963 | 16303963 | PRJNA1010662_S_NODE_1153_length_278_cov_2.042553_g1108_i0 | PRJNA1010662 | 1153 | 278 | 2.042553 | 5.67829734 | Fusobacterium | 848 | Bacteria | Bacteria | 514 | 2.7199999999999996e-141 | NTclustered | gi|2705003210|gb|CP084117.1| | 851 | g1108 | i0 | 100 | 99.8309352517986 | 278 | 0 | 100 | 0 | 1 | 278 | 1957910 | 1958187 | Fusobacterium nucleatum strain KCOM3486 chromosome, complete genome | blastn | 27753 | 514 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium nucleatum | ||
| 18006728 | 18006728 | PRJNA1010662_S_NODE_1555_length_248_cov_1.385366_g1510_i0 | PRJNA1010662 | 1555 | 248 | 1.385366 | 3.43570768 | Fusobacteria bacterium ZRK30 | 2970471 | Bacteria | Bacteria | 287 | 5.649999999999999e-73 | NTclustered | gi|2284594148|gb|CP102404.1| | 2970471 | g1510 | i0 | 97.059 | 117.528225806452 | 170 | 5 | 69 | 0 | 79 | 248 | 205544 | 205713 | Fusobacteria bacterium ZRK30 chromosome 1, complete sequence | blastn | 29147 | 287 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteria bacterium ZRK30 | ||||||
| 21403576 | 21403576 | PRJNA1010662_S_NODE_4357_length_166_cov_1.170732_g4312_i0 | PRJNA1010662 | 4357 | 166 | 1.170732 | 1.94341512 | Fusobacterium | 848 | Bacteria | Bacteria | 307 | 2.69e-79 | NTclustered | gi|2704942200|gb|CP077195.1| | 285729 | g4312 | i0 | 100 | 99.6024096385542 | 166 | 0 | 100 | 0 | 1 | 166 | 301367 | 301202 | Fusobacterium canifelinum strain SB044 chromosome, complete genome | blastn | 16534 | 307 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium canifelinum | ||
| 21403587 | 21403587 | PRJNA1010662_S_NODE_5377_length_151_cov_3.703704_g5332_i0 | PRJNA1010662 | 5377 | 151 | 3.703704 | 5.59259304 | Fusobacteriaceae | 203492 | Bacteria | Bacteria | 274 | 2.42e-69 | NTclustered | gi|219878315|ref|NR_025454.1| | 167643 | g5332 | i0 | 99.338 | 261.993377483444 | 151 | 1 | 100 | 0 | 1 | 151 | 1360 | 1510 | Ilyobacter insuetus strain VenChi2 16S ribosomal RNA, partial sequence | blastn | 39561 | 274 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Ilyobacter | Ilyobacter insuetus | ||
| 25227705 | 25227705 | PRJNA1010662_S_NODE_2340_length_214_cov_1.473684_g2295_i0 | PRJNA1010662 | 2340 | 214 | 1.473684 | 3.15368376 | Psychrilyobacter | 623282 | Bacteria | Bacteria | 385 | 1.64e-102 | NTclustered | gi|127315580|gb|EF426680.1| | 271091 | g2295 | i0 | 99.065 | 410.644859813084 | 214 | 2 | 100 | 0 | 1 | 214 | 946 | 733 | Psychrilyobacter atlanticus strain HAW-EB21 23S ribosomal RNA gene, partial sequence | blastn | 87878 | 385 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Psychrilyobacter | Psychrilyobacter atlanticus | ||
| 28202907 | 28202907 | PRJNA1010662_P_NODE_15666_length_164_cov_0.878261_g15607_i0 | PRJNA1010662 | 15666 | 164 | 0.878261 | 1.44034804 | Fusobacteriaceae bacterium | 2053555 | Bacteria | Bacteria | 52.4 | 5.02e-6 | NR | BFO51970.1 | 2053555 | g15607 | i0 | 48.1 | 1.97560975609756 | 54 | 28 | 98.8 | 0 | 163 | 2 | 210 | 263 | BFO51970.1 hypothetical protein F9N8_11830 [Fusobacteriaceae bacterium] | diamond | 324 | 52.4 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacteriaceae bacterium |
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);;