contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1180292" and tax_phylum = "Candidatus Methylomirabilota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26597103 | 26597103 | PRJNA1180292_P_NODE_9621_length_249_cov_0.886364_g9489_i0 | PRJNA1180292 | 9621 | 249 | 0.886364 | 2.20704636 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 85.1 | 1.44e-18 | NR | MCI0371231.1 | 2072417 | g9489 | i0 | 62.2 | 0.891566265060241 | 74 | 26 | 89.2 | 1 | 232 | 11 | 79 | 150 | MCI0371231.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 222 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27514613 | 27514613 | PRJNA1180292_P_NODE_8343_length_252_cov_0.871508_g8211_i0 | PRJNA1180292 | 8343 | 252 | 0.871508 | 2.19620016 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 149 | 3.12e-41 | NR | MEI8189747.1 | 2072417 | g8211 | i0 | 85.7 | 1 | 84 | 12 | 100 | 0 | 1 | 252 | 108 | 191 | MEI8189747.1 trypsin-like peptidase domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 252 | 149 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 28146263 | 28146263 | PRJNA1180292_P_NODE_10505_length_247_cov_0.896552_g10373_i0 | PRJNA1180292 | 10505 | 247 | 0.896552 | 2.21448344 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 132 | 1.08e-33 | NR | HSB79151.1 | 2032687 | g10373 | i0 | 87.7 | 3.93522267206478 | 81 | 10 | 98.4 | 0 | 3 | 245 | 126 | 206 | HSB79151.1 mechanosensitive ion channel domain-containing protein [Candidatus Methylomirabilis sp.] | diamond | 972 | 132 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 29219733 | 29219733 | PRJNA1180292_P_NODE_8249_length_252_cov_0.871508_g8117_i0 | PRJNA1180292 | 8249 | 252 | 0.871508 | 2.19620016 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 45.8 | 0.00291 | NR | HEX7551398.1 | 2032687 | g8117 | i0 | 70.4 | 0.642857142857143 | 27 | 8 | 32.1 | 0 | 2 | 82 | 225 | 251 | HEX7551398.1 N-acyl homoserine lactonase family protein [Candidatus Methylomirabilis sp.] | diamond | 162 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 31399600 | 31399600 | PRJNA1180292_P_NODE_10536_length_247_cov_0.896552_g10404_i0 | PRJNA1180292 | 10536 | 247 | 0.896552 | 2.21448344 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 145 | 3.98e-38 | NR | HSB67906.1 | 2032687 | g10404 | i0 | 81.5 | 6.88663967611336 | 81 | 15 | 98.4 | 0 | 3 | 245 | 138 | 218 | HSB67906.1 CusA/CzcA family heavy metal efflux RND transporter [Candidatus Methylomirabilis sp.] | diamond | 1701 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 31620781 | 31620781 | PRJNA1180292_P_NODE_12896_length_242_cov_0.923077_g12764_i0 | PRJNA1180292 | 12896 | 242 | 0.923077 | 2.23384634 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 72 | 1.18e-12 | NR | HXG46368.1 | 2072417 | g12764 | i0 | 70.2 | 0.582644628099174 | 47 | 13 | 58.3 | 1 | 141 | 1 | 4 | 49 | HXG46368.1 D-2-hydroxyacid dehydrogenase [Candidatus Methylomirabilota bacterium] | diamond | 141 | 72 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31968724 | 31968724 | PRJNA1180292_P_NODE_8438_length_252_cov_0.871508_g8306_i0 | PRJNA1180292 | 8438 | 252 | 0.871508 | 2.19620016 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 66.6 | 1.13e-10 | NR | HWS96445.1 | 2032687 | g8306 | i0 | 53.6 | 1.72619047619048 | 69 | 32 | 82.1 | 0 | 236 | 30 | 75 | 143 | HWS96445.1 hypothetical protein [Candidatus Methylomirabilis sp.] | diamond | 435 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 32443712 | 32443712 | PRJNA1180292_P_NODE_7959_length_253_cov_0.866667_g7827_i0 | PRJNA1180292 | 7959 | 253 | 0.866667 | 2.19266751 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 46.6 | 0.00183 | NR | MCX5734392.1 | 2072417 | g7827 | i0 | 53.7 | 0.486166007905138 | 41 | 19 | 48.6 | 0 | 129 | 251 | 1 | 41 | MCX5734392.1 Helicase associated domain protein [Candidatus Methylomirabilota bacterium] | diamond | 123 | 46.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota 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);;