contig_metadata
4 rows where bioproject = "PRJNA725806", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27146659 | 27146659 | PRJNA725806_P_NODE_86522_length_208_cov_1.350877_g86221_i0 | PRJNA725806 | 86522 | 208 | 1.350877 | 2.80982416 | Candidatus Saccharibacteria bacterium 49-2 | 1895829 | Bacteria | Bacteria | 130 | 3.65e-33 | NR | OJU87461.1 | 1895829 | g86221 | i0 | 100 | 0.980769230769231 | 68 | 0 | 98.1 | 0 | 3 | 206 | 437 | 504 | OJU87461.1 MAG: ATP-dependent DNA helicase PcrA [Candidatus Saccharibacteria bacterium 49-20] | diamond | 204 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 29736133 | 29736133 | PRJNA725806_P_NODE_103530_length_195_cov_1.303797_g103228_i0 | PRJNA725806 | 103530 | 195 | 1.303797 | 2.54240415 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 46.6 | 8.57e-4 | NR | MBN9398373.1 | 2026720 | g103228 | i0 | 41.1 | 0.861538461538462 | 56 | 29 | 83.1 | 3 | 33 | 194 | 378 | 431 | MBN9398373.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 168 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30052101 | 30052101 | PRJNA725806_P_NODE_18551_length_324_cov_1.177700_g18257_i0 | PRJNA725806 | 18551 | 324 | 1.1777 | 3.815748 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 63.2 | 6.58e-9 | NR | HVX24508.1 | 2973664 | g18257 | i0 | 43.2 | 0.75 | 81 | 45 | 75 | 1 | 279 | 37 | 101 | 180 | HVX24508.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 243 | 63.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30400296 | 30400296 | PRJNA725806_P_NODE_66933_length_226_cov_9.523810_g66633_i0 | PRJNA725806 | 66933 | 226 | 9.52381 | 21.5238106 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 43.5 | 0.0155 | NR | HET6924576.1 | 2973664 | g66633 | i0 | 32.4 | 0.902654867256637 | 68 | 45 | 88.9 | 1 | 214 | 14 | 71 | 138 | HET6924576.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 204 | 43.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);;