contig_metadata
9 rows where bioproject = "PRJNA911178" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1250673 | 1250673 | PRJNA911178_P_NODE_59241_length_454_cov_1.052493_g56795_i0 | PRJNA911178 | 59241 | 454 | 1.052493 | 4.77831822 | Candidatus Methylomirabilis | 1170227 | Bacteria | Bacteria | 351 | 3.87e-92 | NTclustered | gi|507148395|ref|NR_103198.1| | 671143 | g56795 | i0 | 82.423 | 317.671806167401 | 421 | 57 | 91 | 12 | 33 | 443 | 1510 | 1097 | Candidatus Methylomirabilis oxyfera 23S ribosomal RNA gene, complete sequence | blastn | 144223 | 351 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis oxygeniifera | ||
| 2168239 | 2168239 | PRJNA911178_P_NODE_288362_length_242_cov_0.911243_g285888_i0 | PRJNA911178 | 288362 | 242 | 0.911243 | 2.20520806 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 109 | 1.8700000000000003e-27 | NR | HEV8441008.1 | 2072417 | g285888 | i0 | 81.4 | 0.867768595041322 | 70 | 13 | 86.8 | 0 | 219 | 10 | 142 | 211 | HEV8441008.1 ATP-binding cassette domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 210 | 109 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 8545637 | 8545637 | PRJNA911178_P_NODE_271287_length_245_cov_0.895349_g268813_i0 | PRJNA911178 | 271287 | 245 | 0.895349 | 2.19360505 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 114 | 1.86e-28 | NR | HZS32352.1 | 2072417 | g268813 | i0 | 93.5 | 1.51836734693878 | 62 | 4 | 75.9 | 0 | 214 | 29 | 273 | 334 | HZS32352.1 ABC transporter permease [Candidatus Methylomirabilota bacterium] | diamond | 372 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 22570715 | 22570715 | PRJNA911178_P_NODE_96118_length_367_cov_2.071429_g93648_i0 | PRJNA911178 | 96118 | 367 | 2.071429 | 7.60214443 | Candidatus Methylomirabilis oxygeniifera | 671143 | Bacteria | Bacteria | 71.3 | 9.62e-8 | NTclustered | gi|258590833|emb|FP565575.1| | 671143 | g93648 | i0 | 92.157 | 21.6130790190736 | 51 | 2 | 16 | 2 | 30 | 79 | 1646719 | 1646768 | Candidatus Methylomirabilis oxyfera complete genome | blastn | 7932 | 71.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis oxygeniifera | ||
| 26802816 | 26802816 | PRJNA911178_P_NODE_183021_length_281_cov_1.673077_g180548_i0 | PRJNA911178 | 183021 | 281 | 1.673077 | 4.70134637 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 45.4 | 0.00661 | NR | HTO82047.1 | 2072417 | g180548 | i0 | 40 | 0.640569395017794 | 60 | 31 | 58.7 | 1 | 54 | 218 | 386 | 445 | HTO82047.1 protein-disulfide reductase DsbD domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 180 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27403894 | 27403894 | PRJNA911178_P_NODE_282643_length_243_cov_0.905882_g280169_i0 | PRJNA911178 | 282643 | 243 | 0.905882 | 2.20129326 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 68.9 | 2.15e-11 | NR | MBM2836702.1 | 2072417 | g280169 | i0 | 47.4 | 0.962962962962963 | 78 | 38 | 96.3 | 2 | 5 | 238 | 411 | 485 | MBM2836702.1 peptidase [Candidatus Methylomirabilota bacterium] | diamond | 234 | 68.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30719546 | 30719546 | PRJNA911178_P_NODE_288054_length_242_cov_0.911243_g285580_i0 | PRJNA911178 | 288054 | 242 | 0.911243 | 2.20520806 | Candidatus Methylomirabilis sp. | 2032687 | Bacteria | Bacteria | 42.7 | 0.0379 | NR | HTW97013.1 | 2032687 | g285580 | i0 | 50 | 0.421487603305785 | 34 | 17 | 42.1 | 0 | 123 | 224 | 1084 | 1117 | HTW97013.1 IPT/TIG domain-containing protein [Candidatus Methylomirabilis sp.] | diamond | 102 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilaceae | Candidatus Methylomirabilis | Candidatus Methylomirabilis sp. | ||
| 30972483 | 30972483 | PRJNA911178_P_NODE_269954_length_245_cov_1.465116_g267480_i0 | PRJNA911178 | 269954 | 245 | 1.465116 | 3.5895342 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 48.5 | 3.49e-4 | NR | HTO82047.1 | 2072417 | g267480 | i0 | 41.7 | 0.73469387755102 | 60 | 30 | 67.3 | 1 | 62 | 226 | 386 | 445 | HTO82047.1 protein-disulfide reductase DsbD domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 180 | 48.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31984223 | 31984223 | PRJNA911178_P_NODE_67718_length_427_cov_2.855932_g65258_i0 | PRJNA911178 | 67718 | 427 | 2.855932 | 12.19482964 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 47 | 0.00865 | NR | HSF05929.1 | 2072417 | g65258 | i0 | 35.4 | 0.674473067915691 | 96 | 53 | 66.7 | 4 | 371 | 87 | 210 | 297 | HSF05929.1 GAF domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 288 | 47 | 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);;