contig_metadata
8 rows where bioproject = "PRJNA603943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4404222 | 4404222 | PRJNA603943_P_NODE_15944_length_418_cov_1.211594_g15752_i0 | PRJNA603943 | 15944 | 418 | 1.211594 | 5.06446292 | Fusobacterium hwasookii | 1583098 | Bacteria | Bacteria | 773 | 0 | NTclustered | gi|1890959825|gb|CP060112.1| | 1583098 | g15752 | i0 | 100 | 485.153110047847 | 418 | 0 | 100 | 0 | 1 | 418 | 544946 | 545363 | Fusobacterium hwasookii strain KCOM 1249 chromosome, complete genome | blastn | 202794 | 773 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium hwasookii | ||
| 10782183 | 10782183 | PRJNA603943_P_NODE_63589_length_245_cov_0.895349_g63397_i0 | PRJNA603943 | 63589 | 245 | 0.895349 | 2.19360505 | Leptotrichia sp. oral taxon 221 | 712362 | Bacteria | Bacteria | 414 | 2.45e-111 | NTclustered | gi|2028889048|gb|CP072378.1| | 712362 | g63397 | i0 | 97.143 | 1 | 245 | 7 | 100 | 0 | 1 | 245 | 250296 | 250052 | Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome | blastn | 245 | 414 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia sp. oral taxon 221 | ||
| 15171336 | 15171336 | PRJNA603943_P_NODE_33752_length_314_cov_1.526971_g33560_i0 | PRJNA603943 | 33752 | 314 | 1.526971 | 4.79468894 | Fusobacterium | 848 | Bacteria | Bacteria | 575 | 1.4099999999999994e-159 | NTclustered | gi|1370537877|gb|CP028108.1| | 860 | g33560 | i0 | 99.682 | 488.015923566879 | 314 | 1 | 100 | 0 | 1 | 314 | 463041 | 462728 | Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome | blastn | 153237 | 580 | 0.991379310344828 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium periodonticum | ||
| 20269725 | 20269725 | PRJNA603943_P_NODE_5556_length_645_cov_1.480769_g5372_i0 | PRJNA603943 | 5556 | 645 | 1.480769 | 9.55096005 | Fusobacterium | 848 | Bacteria | Bacteria | 1192 | 0 | NTclustered | gi|2706069597|gb|CP077108.1| | 76857 | g5372 | i0 | 100 | 486.415503875969 | 645 | 0 | 100 | 0 | 1 | 645 | 1185919 | 1185275 | Fusobacterium polymorphum strain KCOM1281 chromosome, complete genome | blastn | 313738 | 1192 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium polymorphum | ||
| 27333022 | 27333022 | PRJNA603943_P_NODE_63443_length_245_cov_0.895349_g63251_i0 | PRJNA603943 | 63443 | 245 | 0.895349 | 2.19360505 | Candidatus Stercorousia faecigallinarum | 2840954 | Bacteria | Bacteria | 143 | 5.2099999999999996e-42 | NR | HIT92483.1 | 2840954 | g63251 | i0 | 93.2 | 1.78775510204082 | 73 | 5 | 89.4 | 0 | 243 | 25 | 56 | 128 | HIT92483.1 DUF2924 domain-containing protein [Candidatus Stercorousia faecigallinarum] | diamond | 438 | 143 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Candidatus Stercorousia | Candidatus Stercorousia faecigallinarum | ||
| 27409504 | 27409504 | PRJNA603943_P_NODE_53863_length_251_cov_0.865169_g53671_i0 | PRJNA603943 | 53863 | 251 | 0.865169 | 2.17157419 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 108 | 4.16e-26 | NR | CDE91856.1 | 1262901 | g53671 | i0 | 100 | 1.29083665338645 | 54 | 0 | 64.5 | 0 | 251 | 90 | 300 | 353 | CDE91856.1 geranylgeranyl reductase [Fusobacterium sp. CAG:815] | diamond | 324 | 108 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium sp. CAG:815 | ||
| 29132763 | 29132763 | PRJNA603943_P_NODE_51849_length_253_cov_1.283333_g51657_i0 | PRJNA603943 | 51849 | 253 | 1.283333 | 3.24683249 | Fusobacterium sp. CAG:815 | 1262901 | Bacteria | Bacteria | 171 | 4.31e-51 | NR | CDE92308.1 | 1262901 | g51657 | i0 | 100 | 0.984189723320158 | 83 | 0 | 98.4 | 0 | 3 | 251 | 183 | 265 | CDE92308.1 unknown [Fusobacterium sp. CAG:815] | diamond | 249 | 171 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Fusobacterium | Fusobacterium sp. CAG:815 | ||
| 30838246 | 30838246 | PRJNA603943_P_NODE_18814_length_392_cov_1.448276_g18622_i0 | PRJNA603943 | 18814 | 392 | 1.448276 | 5.67724192 | Candidatus Stercorousia faecigallinarum | 2840954 | Bacteria | Bacteria | 166 | 1.77e-46 | NR | HIT91674.1 | 2840954 | g18622 | i0 | 62.3 | 0.994897959183674 | 130 | 49 | 99.5 | 0 | 3 | 392 | 72 | 201 | HIT91674.1 phage terminase large subunit [Candidatus Stercorousia faecigallinarum] | diamond | 390 | 166 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Candidatus Stercorousia | Candidatus Stercorousia faecigallinarum |
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);;