contig_metadata
8 rows where bioproject = "PRJNA690124" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13423457 | 13423457 | PRJNA690124_P_NODE_48091_length_249_cov_0.886364_g47725_i0 | PRJNA690124 | 48091 | 249 | 0.886364 | 2.20704636 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 66.6 | 7.28e-11 | NR | MBI4841448.1 | 2072417 | g47725 | i0 | 44.6 | 1 | 83 | 45 | 98.8 | 1 | 246 | 1 | 11 | 93 | MBI4841448.1 SCO family protein [Candidatus Methylomirabilota bacterium] | diamond | 249 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27272010 | 27272010 | PRJNA690124_P_NODE_45423_length_251_cov_0.876404_g45057_i0 | PRJNA690124 | 45423 | 251 | 0.876404 | 2.19977404 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 149 | 2.63e-41 | NR | HEY7365765.1 | 2072417 | g45057 | i0 | 88 | 0.99203187250996006 | 83 | 10 | 99.2 | 0 | 3 | 251 | 136 | 218 | HEY7365765.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Methylomirabilota bacterium] | diamond | 249 | 149 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27714589 | 27714589 | PRJNA690124_P_NODE_32744_length_290_cov_1.119816_g32378_i0 | PRJNA690124 | 32744 | 290 | 1.119816 | 3.2474664 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 161 | 2.62e-45 | NR | HSF04805.1 | 2072417 | g32378 | i0 | 88.5 | 1.98620689655172 | 96 | 11 | 99.3 | 0 | 3 | 290 | 332 | 427 | HSF04805.1 efflux transporter outer membrane subunit [Candidatus Methylomirabilota bacterium] | diamond | 576 | 161 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27903393 | 27903393 | PRJNA690124_P_NODE_33225_length_288_cov_1.130233_g32859_i0 | PRJNA690124 | 33225 | 288 | 1.130233 | 3.25507104 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 187 | 1.67e-56 | NR | HXU88552.1 | 2072417 | g32859 | i0 | 91.4 | 1.9375 | 93 | 8 | 96.9 | 0 | 280 | 2 | 28 | 120 | HXU88552.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 558 | 187 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29292834 | 29292834 | PRJNA690124_P_NODE_44209_length_252_cov_0.871508_g43843_i0 | PRJNA690124 | 44209 | 252 | 0.871508 | 2.19620016 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 84.7 | 6.89e-17 | NR | HEX2483149.1 | 2072417 | g43843 | i0 | 78.6 | 1.3452380952381 | 56 | 12 | 66.7 | 0 | 3 | 170 | 774 | 829 | HEX2483149.1 leucine--tRNA ligase [Candidatus Methylomirabilota bacterium] | diamond | 339 | 84.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29893028 | 29893028 | PRJNA690124_P_NODE_50391_length_247_cov_0.896552_g50025_i0 | PRJNA690124 | 50391 | 247 | 0.896552 | 2.21448344 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 89.4 | 1.43e-20 | NR | HEX2482118.1 | 2072417 | g50025 | i0 | 78.2 | 0.668016194331984 | 55 | 9 | 63.2 | 1 | 247 | 92 | 60 | 114 | HEX2482118.1 SRPBCC family protein [Candidatus Methylomirabilota bacterium] | diamond | 165 | 89.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30367166 | 30367166 | PRJNA690124_P_NODE_49372_length_248_cov_0.891429_g49006_i0 | PRJNA690124 | 49372 | 248 | 0.891429 | 2.21074392 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 90.9 | 5.64e-20 | NR | HKB25844.1 | 2072417 | g49006 | i0 | 59.3 | 0.979838709677419 | 81 | 33 | 98 | 0 | 2 | 244 | 115 | 195 | HKB25844.1 methyltransferase domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 243 | 90.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31378075 | 31378075 | PRJNA690124_P_NODE_47876_length_249_cov_0.886364_g47510_i0 | PRJNA690124 | 47876 | 249 | 0.886364 | 2.20704636 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 129 | 3.3499999999999996e-35 | NR | WP_337291261.1 | 2032687 | g47510 | i0 | 87.3 | 2.85542168674699 | 79 | 10 | 95.2 | 0 | 13 | 249 | 7 | 85 | WP_337291261.1 RNA polymerase sigma factor [Candidatus Methylomirabilis sp.] | diamond | 711 | 129 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. |
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);;