contig_metadata
10 rows where bioproject = "PRJNA429937", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4253413 | 4253413 | PRJNA429937_P_NODE_29264_length_674_cov_5.079070_g10580_i3 | PRJNA429937 | 29264 | 674 | 5.07907 | 34.2329318 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 133 | 1.79e-35 | NR | MBI3889732.1 | 2026720 | g10580 | i3 | 53.1 | 1.17952522255193 | 130 | 60 | 57.4 | 1 | 185 | 571 | 23 | 152 | MBI3889732.1 GtrA family protein [Candidatus Saccharibacteria bacterium] | diamond | 795 | 133 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 11291057 | 11291057 | PRJNA429937_P_NODE_97249_length_310_cov_5.135231_g74644_i0 | PRJNA429937 | 97249 | 310 | 5.135231 | 15.9192161 | Candidatus Nanosynbacter | 2093823 | Bacteria | Bacteria | 568 | 2.3299999999999995e-157 | NTclustered | gi|1842065531|gb|CP040002.1| | 713059 | g74644 | i0 | 99.677 | 123.41935483871 | 310 | 1 | 100 | 0 | 1 | 310 | 151894 | 152203 | Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome | blastn | 38260 | 568 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium oral taxon 488 | ||||||
| 11904900 | 11904900 | PRJNA429937_P_NODE_17870_length_870_cov_5.034483_g10580_i0 | PRJNA429937 | 17870 | 870 | 5.034483 | 43.8000021 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 133 | 1.1699999999999999e-34 | NR | MBI3889732.1 | 2026720 | g10580 | i0 | 53.1 | 0.913793103448276 | 130 | 60 | 44.5 | 1 | 185 | 571 | 23 | 152 | MBI3889732.1 GtrA family protein [Candidatus Saccharibacteria bacterium] | diamond | 795 | 133 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 13179984 | 13179984 | PRJNA429937_P_NODE_24591_length_740_cov_4.758087_g10580_i1 | PRJNA429937 | 24591 | 740 | 4.758087 | 35.2098438 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 133 | 3.5e-35 | NR | MBI3889732.1 | 2026720 | g10580 | i1 | 53.1 | 1.07432432432432 | 130 | 60 | 52.3 | 1 | 445 | 59 | 23 | 152 | MBI3889732.1 GtrA family protein [Candidatus Saccharibacteria bacterium] | diamond | 795 | 133 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 22764165 | 22764165 | PRJNA429937_P_NODE_101318_length_298_cov_3.721190_g78706_i0 | PRJNA429937 | 101318 | 298 | 3.72119 | 11.0891462 | Bacteria | 2 | Bacteria | Bacteria | 106 | 2.1e-18 | NTclustered | gi|499052612|gb|CP005957.1| | 1332188 | g78706 | i0 | 100 | 3.51677852348993 | 57 | 0 | 19 | 0 | 1 | 57 | 327034 | 327090 | Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome | blastn | 1048 | 106 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas aalborgensis | ||
| 23378521 | 23378521 | PRJNA429937_P_NODE_28819_length_679_cov_5.047692_g10580_i2 | PRJNA429937 | 28819 | 679 | 5.047692 | 34.27382868 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 133 | 1.91e-35 | NR | MBI3889732.1 | 2026720 | g10580 | i2 | 53.1 | 1.17083946980854 | 130 | 60 | 57 | 1 | 445 | 59 | 23 | 152 | MBI3889732.1 GtrA family protein [Candidatus Saccharibacteria bacterium] | diamond | 795 | 133 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27075675 | 27075675 | PRJNA429937_P_NODE_103302_length_293_cov_1.511364_g80687_i0 | PRJNA429937 | 103302 | 293 | 1.511364 | 4.42829652 | Candidatus Mycosynbacter amalyticus | 2665156 | Bacteria | Bacteria | 138 | 1.95e-36 | NR | WP_260763447.1 | 2665156 | g80687 | i0 | 94 | 0.686006825938567 | 67 | 4 | 68.6 | 0 | 3 | 203 | 149 | 215 | WP_260763447.1 phage tail tip lysozyme [Candidatus Mycosynbacter amalyticus] | diamond | 201 | 138 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Mycosynbacter | Candidatus Mycosynbacter amalyticus | |||||
| 29349471 | 29349471 | PRJNA429937_P_NODE_54749_length_474_cov_4.071910_g36269_i0 | PRJNA429937 | 54749 | 474 | 4.07191 | 19.3008534 | Candidatus Saccharibacteria bacterium 32-5 | 1970481 | Bacteria | Bacteria | 239 | 3.42e-71 | NR | OYX53625.1 | 1970481 | g36269 | i0 | 79.1 | 0.936708860759494 | 148 | 29 | 92.4 | 1 | 16 | 453 | 238 | 385 | OYX53625.1 MAG: hypothetical protein B7Y92_02140 [Candidatus Saccharibacteria bacterium 32-50-13] | diamond | 444 | 239 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-50-13 | ||||||
| 31118113 | 31118113 | PRJNA429937_P_NODE_77455_length_375_cov_1.528902_g55208_i0 | PRJNA429937 | 77455 | 375 | 1.528902 | 5.7333825 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 60.8 | 6.52e-8 | NR | MDN5275526.1 | 2026720 | g55208 | i0 | 69.4 | 1.032 | 36 | 11 | 28.8 | 0 | 177 | 70 | 277 | 312 | MDN5275526.1 Small ribosomal subunit biosis GTPase RsgA [Candidatus Saccharibacteria bacterium] | diamond | 387 | 60.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31339615 | 31339615 | PRJNA429937_P_NODE_73196_length_390_cov_4.196676_g51296_i0 | PRJNA429937 | 73196 | 390 | 4.196676 | 16.3670364 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 95.1 | 1.02e-20 | NR | HJQ08091.1 | 2973664 | g51296 | i0 | 57.6 | 1.52307692307692 | 66 | 28 | 50.8 | 0 | 204 | 7 | 1 | 66 | HJQ08091.1 IS1595 family transposase [Candidatus Saccharimonadales bacterium] | diamond | 594 | 95.1 | 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);;