contig_metadata
8 rows where bioproject = "PRJNA781196" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26864022 | 26864022 | PRJNA781196_P_NODE_58681_length_247_cov_1.304598_g58304_i0 | PRJNA781196 | 58681 | 247 | 1.304598 | 3.22235706 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 43.5 | 0.0218 | NR | HVA85453.1 | 2973664 | g58304 | i0 | 38.3 | 0.728744939271255 | 60 | 37 | 72.9 | 0 | 190 | 11 | 1127 | 1186 | HVA85453.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 180 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 27590853 | 27590853 | PRJNA781196_P_NODE_57684_length_248_cov_0.891429_g57307_i0 | PRJNA781196 | 57684 | 248 | 0.891429 | 2.21074392 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 61.2 | 1e-8 | NR | MBP1769602.1 | 2052149 | g57307 | i0 | 47.1 | 0.846774193548387 | 70 | 36 | 83.5 | 1 | 35 | 241 | 209 | 278 | MBP1769602.1 alcohol dehydrogenase [Candidatus Aminicenantes bacterium] | diamond | 210 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 29011795 | 29011795 | PRJNA781196_P_NODE_46208_length_263_cov_1.715789_g45831_i0 | PRJNA781196 | 46208 | 263 | 1.715789 | 4.51252507 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 43.1 | 0.0161 | NR | MFA5953941.1 | 2052139 | g45831 | i0 | 32.6 | 1.01520912547529 | 89 | 51 | 94.7 | 2 | 252 | 4 | 11 | 96 | MFA5953941.1 30S ribosomal protein S8 [Patescibacteria group bacterium] | diamond | 267 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 29011801 | 29011801 | PRJNA781196_P_NODE_53808_length_251_cov_0.876404_g53431_i0 | PRJNA781196 | 53808 | 251 | 0.876404 | 2.19977404 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 114 | 2.8499999999999993e-28 | NR | MDB5165335.1 | 2026720 | g53431 | i0 | 77.1 | 0.99203187250996006 | 83 | 19 | 99.2 | 0 | 251 | 3 | 65 | 147 | MDB5165335.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 249 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29484797 | 29484797 | PRJNA781196_P_NODE_55910_length_249_cov_0.886364_g55533_i0 | PRJNA781196 | 55910 | 249 | 0.886364 | 2.20704636 | candidate division TM6 bacterium GW2 | 95901 | Bacteria | Bacteria | 97.8 | 6.649999999999999e-23 | NR | KKP26315.1 | 1619073 | g55533 | i0 | 62.3 | 4.51807228915663 | 69 | 25 | 81.9 | 1 | 44 | 247 | 97 | 165 | KKP26315.1 MAG: Mn Superoxide dismutase [candidate division TM6 bacterium GW2011_GWE2_31_21] | diamond | 1125 | 97.8 | 1 | Bacteria | Bacteria candidate phyla | candidate division TM6 bacterium GW2011_GWE2_31_21 | |||||||
| 30401539 | 30401539 | PRJNA781196_P_NODE_46473_length_263_cov_0.731579_g46096_i0 | PRJNA781196 | 46473 | 263 | 0.731579 | 1.92405277 | Candidatus Magasanikiibacteriota bacterium | 2026717 | Bacteria | Bacteria | 42.7 | 0.046 | NR | MBT4121096.1 | 2026717 | g46096 | i0 | 31.3 | 0.76425855513308 | 67 | 44 | 74.1 | 1 | 16 | 210 | 123 | 189 | MBT4121096.1 hypothetical protein [Candidatus Magasanikiibacteriota bacterium] | diamond | 201 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikiibacteriota bacterium | ||||||
| 31064842 | 31064842 | PRJNA781196_P_NODE_65755_length_243_cov_0.917647_g65378_i0 | PRJNA781196 | 65755 | 243 | 0.917647 | 2.22988221 | Candidatus Woesebacteria bacterium RIFCSPLOWO2_ | 2026804 | Bacteria | Bacteria | 79.7 | 3.75e-15 | NR | OGM70984.1 | 1802526 | g65378 | i0 | 63.3 | 0.740740740740741 | 60 | 22 | 74.1 | 0 | 204 | 25 | 1 | 60 | OGM70984.1 MAG: hypothetical protein A2897_00370, partial [Candidatus Woesebacteria bacterium RIFCSPLOWO2_01_FULL_44_24b] | diamond | 180 | 79.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium RIFCSPLOWO2_01_FULL_44_24b | ||||||
| 31222341 | 31222341 | PRJNA781196_P_NODE_40595_length_281_cov_1.500000_g40218_i0 | PRJNA781196 | 40595 | 281 | 1.5 | 4.215 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 55.5 | 3.37e-7 | NR | MCA9332768.1 | 2026720 | g40218 | i0 | 36.9 | 0.693950177935943 | 65 | 40 | 69.4 | 1 | 195 | 1 | 27 | 90 | MCA9332768.1 peptide-methionine (R)-S-oxide reductase MsrB [Candidatus Saccharibacteria bacterium] | diamond | 195 | 55.5 | 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);;