contig_metadata
11 rows where bioproject = "PRJNA944406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9852171 | 9852171 | PRJNA944406_P_NODE_110028_length_241_cov_0.916667_g109069_i0 | PRJNA944406 | 110028 | 241 | 0.916667 | 2.20916747 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 119 | 1.99e-29 | NR | HWT82196.1 | 2032687 | g109069 | i0 | 91.8 | 0.759336099585062 | 61 | 5 | 75.9 | 0 | 183 | 1 | 1 | 61 | HWT82196.1 type I glutamate--ammonia ligase [Candidatus Methylomirabilis sp.] | diamond | 183 | 119 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 17502857 | 17502857 | PRJNA944406_P_NODE_50554_length_262_cov_2.661376_g49595_i0 | PRJNA944406 | 50554 | 262 | 2.661376 | 6.97280512 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 86.7 | 1.74e-17 | NR | HEX6209243.1 | 2072417 | g49595 | i0 | 91.3 | 2.90839694656489 | 46 | 4 | 52.7 | 0 | 261 | 124 | 1259 | 1304 | HEX6209243.1 ATP-binding protein [Candidatus Methylomirabilota bacterium] | diamond | 762 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 22601877 | 22601877 | PRJNA944406_P_NODE_65838_length_251_cov_0.865169_g64879_i0 | PRJNA944406 | 65838 | 251 | 0.865169 | 2.17157419 | uncultured Methylomirabilota bacterium | 991135 | Bacteria | Bacteria | 78.7 | 3.75e-10 | NTclustered | gi|2874253892|emb|OY970067.1| | 991135 | g64879 | i0 | 87.143 | 1.9800796812749 | 70 | 8 | 28 | 1 | 1 | 70 | 4745428 | 4745496 | MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1 | blastn | 497 | 78.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | uncultured Methylomirabilota bacterium | ||||||
| 27625782 | 27625782 | PRJNA944406_P_NODE_78084_length_248_cov_0.880000_g77125_i0 | PRJNA944406 | 78084 | 248 | 0.88 | 2.1824 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 104 | 1.09e-24 | NR | HUP54543.1 | 2072417 | g77125 | i0 | 63 | 0.979838709677419 | 81 | 30 | 98 | 0 | 246 | 4 | 114 | 194 | HUP54543.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 243 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 28825135 | 28825135 | PRJNA944406_P_NODE_111928_length_232_cov_3.383648_g110969_i0 | PRJNA944406 | 111928 | 232 | 3.383648 | 7.85006336 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 97.1 | 2.5200000000000004e-21 | NR | HEV8675654.1 | 2072417 | g110969 | i0 | 67.1 | 1.96551724137931 | 76 | 22 | 98.3 | 2 | 228 | 1 | 335 | 407 | HEV8675654.1 fused MFS/spermidine synthase [Candidatus Methylomirabilota bacterium] | diamond | 456 | 97.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29046544 | 29046544 | PRJNA944406_P_NODE_41508_length_271_cov_1.535354_g40549_i0 | PRJNA944406 | 41508 | 271 | 1.535354 | 4.16080934 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 145 | 3.06e-38 | NR | HWN96203.1 | 2072417 | g40549 | i0 | 79.8 | 0.985239852398524 | 89 | 18 | 98.5 | 0 | 2 | 268 | 780 | 868 | HWN96203.1 RHS repeat-associated core domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 267 | 145 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29274046 | 29274046 | PRJNA944406_P_NODE_108789_length_241_cov_0.916667_g107830_i0 | PRJNA944406 | 108789 | 241 | 0.916667 | 2.20916747 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 108 | 1.85e-25 | NR | HET9855996.1 | 2072417 | g107830 | i0 | 67.1 | 1.9792531120332 | 79 | 25 | 98.3 | 1 | 237 | 1 | 211 | 288 | HET9855996.1 S8 family peptidase [Candidatus Methylomirabilota bacterium] | diamond | 477 | 108 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30341846 | 30341846 | PRJNA944406_P_NODE_76252_length_248_cov_1.485714_g75293_i0 | PRJNA944406 | 76252 | 248 | 1.485714 | 3.68457072 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 68.9 | 7.25e-12 | NR | HSB82293.1 | 2032687 | g75293 | i0 | 51.9 | 1.27016129032258 | 54 | 26 | 65.3 | 0 | 2 | 163 | 171 | 224 | HSB82293.1 thiaminase II [Candidatus Methylomirabilis sp.] | diamond | 315 | 68.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 30758855 | 30758855 | PRJNA944406_P_NODE_76154_length_248_cov_1.565714_g75195_i0 | PRJNA944406 | 76154 | 248 | 1.565714 | 3.88297072 | Bacillati | 1783272 | Bacteria | Bacteria | 138 | 4.6599999999999995e-37 | NR | HUH17412.1 | 2072417 | g75195 | i0 | 81.5 | 4.8991935483871 | 81 | 15 | 98 | 0 | 6 | 248 | 141 | 221 | HUH17412.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 1215 | 138 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32206695 | 32206695 | PRJNA944406_P_NODE_66658_length_250_cov_3.016949_g65699_i0 | PRJNA944406 | 66658 | 250 | 3.016949 | 7.5423725 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 48.1 | 4.94e-4 | NR | HEY7542953.1 | 2072417 | g65699 | i0 | 36.5 | 0.756 | 63 | 39 | 75.6 | 1 | 1 | 189 | 26 | 87 | HEY7542953.1 ABC transporter substrate-binding protein [Candidatus Methylomirabilota bacterium] | diamond | 189 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32838001 | 32838001 | PRJNA944406_P_NODE_112960_length_227_cov_2.305195_g112001_i0 | PRJNA944406 | 112960 | 227 | 2.305195 | 5.23279265 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 79.3 | 2.98e-15 | NR | HXU75777.1 | 2072417 | g112001 | i0 | 55.3 | 1.99559471365639 | 76 | 33 | 99.1 | 1 | 225 | 1 | 269 | 344 | HXU75777.1 ATP-binding protein [Candidatus Methylomirabilota bacterium] | diamond | 453 | 79.3 | 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);;