contig_metadata
16 rows where bioproject = "PRJNA939415", tax_clade = "Bacteria candidate phyla" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4744116 | 4744116 | PRJNA939415_P_NODE_56124_length_277_cov_4.328431_g55702_i0 | PRJNA939415 | 56124 | 277 | 4.328431 | 11.98975387 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 164 | 6.95e-45 | NR | HEY7142028.1 | 2072417 | g55702 | i0 | 83.7 | 15.942238267148 | 92 | 15 | 99.6 | 0 | 276 | 1 | 592 | 683 | HEY7142028.1 catalase/peroxidase HPI [Candidatus Methylomirabilota bacterium] | diamond | 4416 | 165 | 0.993939393939394 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 5084976 | 5084976 | PRJNA939415_P_NODE_72804_length_261_cov_2.260638_g72382_i0 | PRJNA939415 | 72804 | 261 | 2.260638 | 5.90026518 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 107 | 3.57e-26 | NR | HEU5191351.1 | 2072417 | g72382 | i0 | 57.6 | 2.05747126436782 | 85 | 36 | 97.7 | 0 | 256 | 2 | 165 | 249 | HEU5191351.1 zf-HC2 domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 537 | 108 | 0.990740740740741 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 17493614 | 17493614 | PRJNA939415_P_NODE_31234_length_310_cov_2.962025_g30812_i0 | PRJNA939415 | 31234 | 310 | 2.962025 | 9.1822775 | uncultured Methylomirabilota bacterium | 991135 | Bacteria | Bacteria | 69.4 | 2.88e-7 | NTclustered | gi|2874253892|emb|OY970067.1| | 991135 | g30812 | i0 | 86.154 | 16.7612903225806 | 65 | 7 | 21 | 2 | 87 | 150 | 903576 | 903513 | MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1 | blastn | 5196 | 69.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | uncultured Methylomirabilota bacterium | ||||||
| 23867214 | 23867214 | PRJNA939415_P_NODE_108059_length_215_cov_4.866197_g107637_i0 | PRJNA939415 | 108059 | 215 | 4.866197 | 10.46232355 | Bacillati | 1783272 | Bacteria | Bacteria | 109 | 6.85e-26 | NR | HXU91467.1 | 2072417 | g107637 | i0 | 79.4 | 4.86976744186047 | 68 | 14 | 94.9 | 0 | 11 | 214 | 501 | 568 | HXU91467.1 response regulator [Candidatus Methylomirabilota bacterium] | diamond | 1047 | 110 | 0.990909090909091 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 26930185 | 26930185 | PRJNA939415_P_NODE_42722_length_291_cov_1.981651_g42300_i0 | PRJNA939415 | 42722 | 291 | 1.981651 | 5.76660441 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 87 | 1.54e-17 | NR | HTO82127.1 | 2072417 | g42300 | i0 | 43.2 | 0.979381443298969 | 95 | 54 | 97.9 | 0 | 3 | 287 | 8 | 102 | HTO82127.1 MBOAT family O-acyltransferase [Candidatus Methylomirabilota bacterium] | diamond | 285 | 87 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27373038 | 27373038 | PRJNA939415_P_NODE_20443_length_345_cov_2.128676_g20023_i0 | PRJNA939415 | 20443 | 345 | 2.128676 | 7.3439322 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 185 | 3.2199999999999993e-52 | NR | HXU89136.1 | 2072417 | g20023 | i0 | 82.3 | 2.9304347826087 | 113 | 20 | 98.3 | 0 | 4 | 342 | 638 | 750 | HXU89136.1 heavy metal translocating P-type ATPase [Candidatus Methylomirabilota bacterium] | diamond | 1011 | 185 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27499126 | 27499126 | PRJNA939415_P_NODE_108443_length_213_cov_5.685714_g108021_i0 | PRJNA939415 | 108443 | 213 | 5.685714 | 12.11057082 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 53.5 | 2.49e-6 | NR | HEY7601463.1 | 2072417 | g108021 | i0 | 42 | 0.971830985915493 | 69 | 40 | 97.2 | 0 | 7 | 213 | 136 | 204 | HEY7601463.1 tetratricopeptide repeat protein [Candidatus Methylomirabilota bacterium] | diamond | 207 | 53.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27530625 | 27530625 | PRJNA939415_P_NODE_39223_length_296_cov_2.174888_g38801_i0 | PRJNA939415 | 39223 | 296 | 2.174888 | 6.43766848 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 53.9 | 3.55e-6 | NR | HTO83580.1 | 2072417 | g38801 | i0 | 54 | 0.506756756756757 | 50 | 23 | 50.7 | 0 | 147 | 296 | 21 | 70 | HTO83580.1 pentapeptide repeat-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 150 | 53.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29266997 | 29266997 | PRJNA939415_P_NODE_35529_length_305_cov_2.504310_g35107_i0 | PRJNA939415 | 35529 | 305 | 2.50431 | 7.6381455 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 53.1 | 1.45e-5 | NR | HEX2440459.1 | 2072417 | g35107 | i0 | 57.1 | 1.72131147540984 | 49 | 21 | 48.2 | 0 | 304 | 158 | 192 | 240 | HEX2440459.1 xanthine dehydrogenase family protein subunit M [Candidatus Methylomirabilota bacterium] | diamond | 525 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29266998 | 29266998 | PRJNA939415_P_NODE_35969_length_302_cov_1.895197_g35547_i0 | PRJNA939415 | 35969 | 302 | 1.895197 | 5.72349494 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 49.7 | 1.24e-4 | NR | MCX5732770.1 | 2072417 | g35547 | i0 | 66.7 | 0.357615894039735 | 36 | 9 | 32.8 | 1 | 117 | 215 | 32 | 67 | MCX5732770.1 ORF6N domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 108 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29961948 | 29961948 | PRJNA939415_P_NODE_76951_length_257_cov_2.184783_g76529_i0 | PRJNA939415 | 76951 | 257 | 2.184783 | 5.61489231 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 47 | 0.00136 | NR | MCI0370051.1 | 2072417 | g76529 | i0 | 44.4 | 2.69649805447471 | 63 | 30 | 67.7 | 2 | 21 | 194 | 80 | 142 | MCI0370051.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 693 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30025257 | 30025257 | PRJNA939415_P_NODE_44231_length_289_cov_2.708333_g43809_i0 | PRJNA939415 | 44231 | 289 | 2.708333 | 7.82708237 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 74.3 | 4.92e-13 | NR | MEK7364642.1 | 2072417 | g43809 | i0 | 44.6 | 0.86159169550173 | 83 | 46 | 86.2 | 0 | 251 | 3 | 391 | 473 | MEK7364642.1 MMPL family transporter [Candidatus Methylomirabilota bacterium] | diamond | 249 | 74.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30467802 | 30467802 | PRJNA939415_P_NODE_91673_length_244_cov_1.941520_g91251_i0 | PRJNA939415 | 91673 | 244 | 1.94152 | 4.7373088 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 68.9 | 2.24e-11 | NR | MBI4571761.1 | 2072417 | g91251 | i0 | 50.6 | 1.04508196721311 | 85 | 36 | 98.4 | 3 | 241 | 2 | 138 | 221 | MBI4571761.1 aldo/keto reductase [Candidatus Methylomirabilota bacterium] | diamond | 255 | 68.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32301680 | 32301680 | PRJNA939415_P_NODE_50659_length_283_cov_1.890476_g50237_i0 | PRJNA939415 | 50659 | 283 | 1.890476 | 5.35004708 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 69.7 | 4.12e-12 | NR | HEX5814174.1 | 2072417 | g50237 | i0 | 37.5 | 7.60070671378092 | 88 | 55 | 93.3 | 0 | 19 | 282 | 81 | 168 | HEX5814174.1 DUF4142 domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 2151 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32648695 | 32648695 | PRJNA939415_P_NODE_99360_length_235_cov_5.851852_g98938_i0 | PRJNA939415 | 99360 | 235 | 5.851852 | 13.7518522 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 77 | 2.87e-14 | NR | HEU4368359.1 | 2072417 | g98938 | i0 | 55.7 | 1.77446808510638 | 70 | 31 | 89.4 | 0 | 25 | 234 | 1 | 70 | HEU4368359.1 ATP-binding protein [Candidatus Methylomirabilota bacterium] | diamond | 417 | 77 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32806376 | 32806376 | PRJNA939415_P_NODE_6380_length_715_cov_5.109034_g5979_i0 | PRJNA939415 | 6380 | 715 | 5.109034 | 36.5295931 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 152 | 4.96e-43 | NR | HKZ08985.1 | 2072417 | g5979 | i0 | 55.3 | 3.12587412587413 | 150 | 59 | 62.9 | 1 | 4 | 453 | 7 | 148 | HKZ08985.1 CopD family protein [Candidatus Methylomirabilota bacterium] | diamond | 2235 | 152 | 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);;