contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1233465" and tax_phylum = "Candidatus Levyibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32931790 | 32931790 | PRJNA1233465a_S_NODE_37985_length_325_cov_1.134058_g36711_i0 | PRJNA1233465 | 37985 | 325 | 1.134058 | 3.6856885 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 129 | 8.8e-34 | NR | MFH1832971.1 | 2052151 | g36711 | i0 | 54.6 | 1.99384615384615 | 108 | 49 | 99.7 | 0 | 324 | 1 | 44 | 151 | MFH1832971.1 glycosyltransferase family 2 protein [Candidatus Levyibacteriota bacterium] | diamond | 648 | 129 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 33000392 | 33000392 | PRJNA1233465b_S_NODE_139011_length_243_cov_1.386598_g137326_i0 | PRJNA1233465 | 139011 | 243 | 1.386598 | 3.36943314 | Candidatus Levybacteria bacterium GW2 | 2052151 | Bacteria | Bacteria | 117 | 6.53e-30 | NR | KKQ38505.1 | 1618467 | g137326 | i0 | 64.2 | 2 | 81 | 29 | 100 | 0 | 1 | 243 | 67 | 147 | KKQ38505.1 MAG: Glycosyl transferase, family 2 [Candidatus Levybacteria bacterium GW2011_GWC2_37_7] | diamond | 486 | 117 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levybacteria bacterium GW2011_GWC2_37_7 | ||||||
| 33068828 | 33068828 | PRJNA1233465b_S_NODE_278421_length_181_cov_1.507576_g276736_i0 | PRJNA1233465 | 278421 | 181 | 1.507576 | 2.72871256 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 99.8 | 1.15e-22 | NR | MDO8269548.1 | 2052151 | g276736 | i0 | 86.4 | 1.95580110497238 | 59 | 8 | 97.8 | 0 | 178 | 2 | 1 | 59 | MDO8269548.1 DNA polymerase III subunit gamma/tau [Candidatus Levyibacteriota bacterium] | diamond | 354 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota bacterium | ||||||
| 33077159 | 33077159 | PRJNA1233465b_S_NODE_156837_length_231_cov_3.923077_g155152_i0 | PRJNA1233465 | 156837 | 231 | 3.923077 | 9.06230787 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 120 | 1.2e-30 | NR | OGH11585.1 | 1798587 | g155152 | i0 | 68.4 | 4.93506493506494 | 76 | 24 | 98.7 | 0 | 230 | 3 | 12 | 87 | OGH11585.1 MAG: hypothetical protein A2684_03360 [Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_36_15b] | diamond | 1140 | 120 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_36_15b | ||||||
| 33086655 | 33086655 | PRJNA1233465d_S_NODE_59246_length_226_cov_3.401130_g58135_i0 | PRJNA1233465 | 59246 | 226 | 3.40113 | 7.6865538 | Candidatus Levybacteria bacterium RIFCSPHIGHO2_ | 2052151 | Bacteria | Bacteria | 85.1 | 1.82e-18 | NR | OGH14898.1 | 1798591 | g58135 | i0 | 78.8 | 1.36725663716814 | 52 | 11 | 69 | 0 | 156 | 1 | 82 | 133 | OGH14898.1 MAG: bacteriocin-protection protein, YdeI/OmpD-associated family [Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_38_26] | diamond | 309 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_38_26 | ||||||
| 33145527 | 33145527 | PRJNA1233465b_S_NODE_202383_length_208_cov_1.723270_g200698_i0 | PRJNA1233465 | 202383 | 208 | 1.72327 | 3.5844016 | Bacteria | 2 | Bacteria | Bacteria | 103 | 1.2399999999999999e-23 | NR | OGH11768.1 | 1798586 | g200698 | i0 | 73.4 | 4.83173076923077 | 64 | 17 | 92.3 | 0 | 208 | 17 | 202 | 265 | OGH11768.1 MAG: hypothetical protein A2857_04720 [Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_36_15] | diamond | 1005 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_36_15 | ||||||
| 33153337 | 33153337 | PRJNA1233465a_S_NODE_138104_length_202_cov_1.241830_g136830_i0 | PRJNA1233465 | 138104 | 202 | 1.24183 | 2.5084966 | Candidatus Levyibacteriota bacterium | 2052151 | Bacteria | Bacteria | 104 | 3.38e-24 | NR | MDO8269548.1 | 2052151 | g136830 | i0 | 86.9 | 1.81188118811881 | 61 | 8 | 90.6 | 0 | 184 | 2 | 1 | 61 | MDO8269548.1 DNA polymerase III subunit gamma/tau [Candidatus Levyibacteriota bacterium] | diamond | 366 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Levyibacteriota | Candidatus Levyibacteriota 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);;