contig_metadata
7 rows where bioproject = "PRJNA549880" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1787334 | 1787334 | PRJNA549880_P_NODE_15322_length_242_cov_0.881657_g15229_i0 | PRJNA549880 | 15322 | 242 | 0.881657 | 2.13360994 | Leptotrichia hofstadii | 157688 | Bacteria | Bacteria | 329 | 8.99e-86 | NTclustered | gi|1708566027|dbj|AP019823.1| | 157688 | g15229 | i0 | 91.322 | 8.40495867768595 | 242 | 20 | 100 | 1 | 1 | 242 | 2173006 | 2173246 | Leptotrichia hofstadii JCM16775 DNA, complete genome | blastn | 2034 | 329 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Leptotrichiaceae | Leptotrichia | Leptotrichia hofstadii | ||
| 27014583 | 27014583 | PRJNA549880_P_NODE_942_length_719_cov_1.896285_g860_i0 | PRJNA549880 | 942 | 719 | 1.896285 | 13.63428915 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 178 | 1.1099999999999998e-47 | NR | WP_294095705.1 | 527638 | g860 | i0 | 68.2 | 1.07649513212796 | 129 | 38 | 53.8 | 1 | 393 | 7 | 450 | 575 | WP_294095705.1 glycosyl hydrolase family 18 protein [uncultured Cetobacterium sp.] | diamond | 774 | 178 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 28166711 | 28166711 | PRJNA549880_P_NODE_3685_length_387_cov_1.417197_g3592_i0 | PRJNA549880 | 3685 | 387 | 1.417197 | 5.48455239 | Cetobacterium | 180162 | Bacteria | Bacteria | 118 | 7.01e-28 | NR | WP_240220714.1 | 188913 | g3592 | i0 | 72.9 | 2.24031007751938 | 70 | 19 | 54.3 | 0 | 23 | 232 | 687 | 756 | WP_240220714.1 glycosyl hydrolase family 18 protein [Cetobacterium somerae] | diamond | 867 | 118 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium somerae | ||
| 28261148 | 28261148 | PRJNA549880_P_NODE_5186_length_339_cov_1.131579_g5093_i0 | PRJNA549880 | 5186 | 339 | 1.131579 | 3.83605281 | Cetobacterium | 180162 | Bacteria | Bacteria | 141 | 2.07e-36 | NR | WP_294095705.1 | 527638 | g5093 | i0 | 67 | 1.92035398230089 | 109 | 35 | 96.5 | 1 | 330 | 4 | 506 | 613 | WP_294095705.1 glycosyl hydrolase family 18 protein [uncultured Cetobacterium sp.] | diamond | 651 | 141 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 29067550 | 29067550 | PRJNA549880_P_NODE_1568_length_566_cov_1.864097_g1477_i0 | PRJNA549880 | 1568 | 566 | 1.864097 | 10.55078902 | Propionigenium maris | 45622 | Bacteria | Bacteria | 96.7 | 1.9e-19 | NR | WP_281833196.1 | 45622 | g1477 | i0 | 58.5 | 0.434628975265018 | 82 | 27 | 41.9 | 2 | 241 | 5 | 519 | 596 | WP_281833196.1 glycosyl hydrolase family 18 protein [Propionigenium maris] | diamond | 246 | 96.7 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Propionigenium | Propionigenium maris | ||
| 30551716 | 30551716 | PRJNA549880_P_NODE_1093_length_668_cov_0.984874_g1005_i0 | PRJNA549880 | 1093 | 668 | 0.984874 | 6.57895832 | Candidatus Cetobacterium colombiensis | 3073100 | Bacteria | Bacteria | 194 | 9.859999999999999e-54 | NR | WP_320312577.1 | 3073100 | g1005 | i0 | 45.5 | 3.96107784431138 | 220 | 112 | 98.4 | 4 | 10 | 666 | 451 | 663 | WP_320312577.1 glycosyl hydrolase family 18 protein [Candidatus Cetobacterium colombiensis] | diamond | 2646 | 194 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Candidatus Cetobacterium colombiensis | ||
| 31974506 | 31974506 | PRJNA549880_P_NODE_13498_length_245_cov_0.895349_g13405_i0 | PRJNA549880 | 13498 | 245 | 0.895349 | 2.19360505 | Propionigenium maris | 45622 | Bacteria | Bacteria | 45.1 | 0.00596 | NR | WP_281836990.1 | 45622 | g13405 | i0 | 56.7 | 0.36734693877551 | 30 | 13 | 36.7 | 0 | 3 | 92 | 1122 | 1151 | WP_281836990.1 glycosyl hydrolase family 18 protein [Propionigenium maris] | diamond | 90 | 45.1 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Propionigenium | Propionigenium maris |
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);;