contig_metadata
4 rows where bioproject = "PRJNA1111082", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Saccharimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19341373 | 19341373 | PRJNA1111082_P_NODE_9056_length_270_cov_1.675127_g9011_i0 | PRJNA1111082 | 9056 | 270 | 1.675127 | 4.5228429 | Candidatus Southlakia epibionticum | 3043284 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2516687873|gb|CP124550.1| | 3043284 | g9011 | i0 | 100 | 0.111111111111111 | 30 | 0 | 11 | 0 | 227 | 256 | 454088 | 454059 | Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Southlakia | Candidatus Southlakia epibionticum | ||
| 27004409 | 27004409 | PRJNA1111082_P_NODE_9162_length_269_cov_1.096939_g9117_i0 | PRJNA1111082 | 9162 | 269 | 1.096939 | 2.95076591 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 43.9 | 0.00391 | NR | HEY1646032.1 | 2973664 | g9117 | i0 | 30.6 | 0.691449814126394 | 62 | 43 | 69.1 | 0 | 79 | 264 | 5 | 66 | HEY1646032.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 186 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 29869495 | 29869495 | PRJNA1111082_P_NODE_9951_length_257_cov_2.619565_g9906_i0 | PRJNA1111082 | 9951 | 257 | 2.619565 | 6.73228205 | Candidatus Saccharimonas | 1331051 | Bacteria | Bacteria | 64.3 | 9.78e-10 | NR | HPQ82657.1 | 1917697 | g9906 | i0 | 79.4 | 1.99610894941634 | 34 | 7 | 39.7 | 0 | 156 | 257 | 1 | 34 | HPQ82657.1 glycosyltransferase family 4 protein [Candidatus Saccharimonas sp.] | diamond | 513 | 64.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 32154242 | 32154242 | PRJNA1111082_P_NODE_4358_length_375_cov_1.152318_g4313_i0 | PRJNA1111082 | 4358 | 375 | 1.152318 | 4.3211925 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 112 | 4.41e-26 | NR | MCA9312800.1 | 2026720 | g4313 | i0 | 53.4 | 0.944 | 118 | 53 | 94.4 | 1 | 367 | 14 | 113 | 228 | MCA9312800.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 354 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota 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);;