contig_metadata
8 rows where bioproject = "PRJNA980839", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9885851 | 9885851 | PRJNA980839_P_NODE_167768_length_272_cov_1.547739_g163984_i0 | PRJNA980839 | 167768 | 272 | 1.547739 | 4.20985008 | TM7 phylum sp. oral taxon 349 | 713051 | Bacteria | Bacteria | 503 | 5.729999999999998e-138 | NTclustered | gi|2028829559|gb|CP072328.1| | 713051 | g163984 | i0 | 100 | 1 | 272 | 0 | 100 | 0 | 1 | 272 | 917849 | 918120 | TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome | blastn | 272 | 503 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | TM7 phylum sp. oral taxon 349 | ||||||
| 26962766 | 26962766 | PRJNA980839_P_NODE_173422_length_268_cov_1.046154_g169638_i0 | PRJNA980839 | 173422 | 268 | 1.046154 | 2.80369272 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 113 | 3.48e-27 | NR | HMI52810.1 | 2973664 | g169638 | i0 | 88.1 | 0.66044776119403 | 59 | 7 | 66 | 0 | 90 | 266 | 1 | 59 | HMI52810.1 MBL fold metallo-hydrolase [Candidatus Saccharimonadales bacterium] | diamond | 177 | 113 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 27348592 | 27348592 | PRJNA980839_P_NODE_202823_length_250_cov_0.870056_g199039_i0 | PRJNA980839 | 202823 | 250 | 0.870056 | 2.17514 | Candidatus Saccharimonadia | 2093818 | Bacteria | Bacteria | 169 | 1.3899999999999998e-48 | NR | RKV93826.1 | 1917697 | g199039 | i0 | 96.4 | 1.992 | 83 | 3 | 99.6 | 0 | 250 | 2 | 283 | 365 | RKV93826.1 MAG: hypothetical protein D8G53_12320, partial [Candidatus Saccharimonas sp.] | diamond | 498 | 170 | 0.994117647058824 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 29268213 | 29268213 | PRJNA980839_P_NODE_197769_length_251_cov_0.865169_g193985_i0 | PRJNA980839 | 197769 | 251 | 0.865169 | 2.17157419 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 139 | 1.4899999999999998e-37 | NR | HMI53720.1 | 2973664 | g193985 | i0 | 80.7 | 0.99203187250996006 | 83 | 16 | 99.2 | 0 | 2 | 250 | 237 | 319 | HMI53720.1 lactonase family protein [Candidatus Saccharimonadales bacterium] | diamond | 249 | 139 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 29489236 | 29489236 | PRJNA980839_P_NODE_195390_length_252_cov_1.480447_g191606_i0 | PRJNA980839 | 195390 | 252 | 1.480447 | 3.73072644 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 137 | 3.54e-36 | NR | MBN9398329.1 | 2026720 | g191606 | i0 | 80.7 | 0.988095238095238 | 83 | 16 | 98.8 | 0 | 250 | 2 | 305 | 387 | MBN9398329.1 DUF11 domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 249 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30026378 | 30026378 | PRJNA980839_P_NODE_151931_length_285_cov_1.882075_g148147_i0 | PRJNA980839 | 151931 | 285 | 1.882075 | 5.36391375 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 191 | 2.3e-60 | NR | MBR2544116.1 | 2026720 | g148147 | i0 | 98.9 | 0.989473684210526 | 94 | 1 | 98.9 | 0 | 284 | 3 | 18 | 111 | MBR2544116.1 single-stranded DNA-binding protein [Candidatus Saccharibacteria bacterium] | diamond | 282 | 191 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30057732 | 30057732 | PRJNA980839_P_NODE_206431_length_249_cov_0.875000_g202647_i0 | PRJNA980839 | 206431 | 249 | 0.875 | 2.17875 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 99.8 | 1.8899999999999998e-24 | NR | MDO5344109.1 | 2026720 | g202647 | i0 | 70 | 0.843373493975904 | 70 | 19 | 84.3 | 1 | 211 | 2 | 3 | 70 | MDO5344109.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 210 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32365986 | 32365986 | PRJNA980839_P_NODE_241679_length_236_cov_3.202454_g237895_i0 | PRJNA980839 | 241679 | 236 | 3.202454 | 7.55779144 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 85.5 | 4.9e-18 | NR | HMI50062.1 | 2973664 | g237895 | i0 | 59.1 | 0.838983050847458 | 66 | 27 | 83.9 | 0 | 198 | 1 | 8 | 73 | HMI50062.1 class I SAM-dependent methyltransferase [Candidatus Saccharimonadales bacterium] | diamond | 198 | 85.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales 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);;