contig_metadata
7 rows where bioproject = "PRJNA615175", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6973313 | 6973313 | PRJNA615175_P_NODE_20926_length_302_cov_5.427948_g20758_i0 | PRJNA615175 | 20926 | 302 | 5.427948 | 16.39240296 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 147 | 1.25e-30 | NTclustered | gi|1950821269|gb|CP066696.1| | 2026720 | g20758 | i0 | 96.591 | 27.1953642384106 | 88 | 3 | 29 | 0 | 206 | 293 | 658956 | 659043 | Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome | blastn | 8213 | 147 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 15897789 | 15897789 | PRJNA615175_P_NODE_21533_length_297_cov_2.669643_g21365_i0 | PRJNA615175 | 21533 | 297 | 2.669643 | 7.92883971 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 179 | 5.939999999999999e-55 | NR | MBI3889290.1 | 2026720 | g21365 | i0 | 90.6 | 0.96969696969697 | 96 | 9 | 97 | 0 | 288 | 1 | 1 | 96 | MBI3889290.1 50S ribosomal protein L4 [Candidatus Saccharibacteria bacterium] | diamond | 288 | 179 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 22827189 | 22827189 | PRJNA615175_P_NODE_26458_length_260_cov_1.647059_g26290_i0 | PRJNA615175 | 26458 | 260 | 1.647059 | 4.2823534 | Bacteria | 2 | Bacteria | Bacteria | 414 | 2.62e-111 | NTclustered | gi|1958075319|gb|CP064995.1| | 2026720 | g26290 | i0 | 95.385 | 284.646153846154 | 260 | 12 | 100 | 0 | 1 | 260 | 692980 | 692721 | Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome | blastn | 74008 | 414 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 23547373 | 23547373 | PRJNA615175_P_NODE_18919_length_320_cov_4.020243_g18751_i0 | PRJNA615175 | 18919 | 320 | 4.020243 | 12.8647776 | Candidatus Saccharibacteria bacterium 32-5 | 1970481 | Bacteria | Bacteria | 198 | 8.82e-59 | NR | OYX53424.1 | 1970481 | g18751 | i0 | 98.1 | 5.9625 | 106 | 2 | 99.4 | 0 | 320 | 3 | 315 | 420 | OYX53424.1 MAG: F0F1 ATP synthase subunit alpha [Candidatus Saccharibacteria bacterium 32-50-13] | diamond | 1908 | 198 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-50-13 | ||||||
| 27396557 | 27396557 | PRJNA615175_P_NODE_3103_length_883_cov_2.201235_g2966_i0 | PRJNA615175 | 3103 | 883 | 2.201235 | 19.43690505 | Candidatus Saccharibacteria bacterium 32-5 | 1970481 | Bacteria | Bacteria | 437 | 2.709999999999999e-150 | NR | OYX53317.1 | 1970481 | g2966 | i0 | 86.3 | 0.845979614949037 | 249 | 34 | 84.6 | 0 | 136 | 882 | 33 | 281 | OYX53317.1 MAG: UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [Candidatus Saccharibacteria bacterium 32-50-13] | diamond | 747 | 437 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 32-50-13 | ||||||
| 29133119 | 29133119 | PRJNA615175_P_NODE_12169_length_412_cov_1.539823_g12001_i0 | PRJNA615175 | 12169 | 412 | 1.539823 | 6.34407076 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 208 | 7.099999999999999e-62 | NR | NCU37721.1 | 2026720 | g12001 | i0 | 70.6 | 0.990291262135922 | 136 | 39 | 99 | 1 | 3 | 410 | 220 | 354 | NCU37721.1 DUF3459 domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 408 | 208 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 30965131 | 30965131 | PRJNA615175_P_NODE_19154_length_318_cov_2.889796_g18986_i0 | PRJNA615175 | 19154 | 318 | 2.889796 | 9.18955128 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 85.1 | 1.24e-17 | NR | MFO0882336.1 | 2973664 | g18986 | i0 | 54.4 | 0.641509433962264 | 68 | 31 | 64.2 | 0 | 209 | 6 | 54 | 121 | MFO0882336.1 NUDIX domain-containing protein [Candidatus Saccharimonadales bacterium] | diamond | 204 | 85.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);;