contig_metadata
16 rows where bioproject = "PRJNA951810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8590489 | 8590489 | PRJNA951810_P_NODE_46907_length_310_cov_6.518987_g46564_i0 | PRJNA951810 | 46907 | 310 | 6.518987 | 20.2088597 | Bacteria | 2 | Bacteria | Bacteria | 92.8 | 1.75e-20 | NR | HEX9418464.1 | 2072417 | g46564 | i0 | 87.8 | 4.74193548387097 | 49 | 6 | 47.4 | 0 | 2 | 148 | 43 | 91 | HEX9418464.1 acyl-CoA dehydrogenase family protein [Candidatus Methylomirabilota bacterium] | diamond | 1470 | 92.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 14017677 | 14017677 | PRJNA951810_P_NODE_42631_length_310_cov_8.966245_g42288_i0 | PRJNA951810 | 42631 | 310 | 8.966245 | 27.7953595 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 92.8 | 1.07e-21 | NR | HEU5322385.1 | 2072417 | g42288 | i0 | 92 | 5.32258064516129 | 50 | 4 | 48.4 | 0 | 309 | 160 | 34 | 83 | HEU5322385.1 hotdog domain-containing protein [Candidatus Methylomirabilota bacterium] | diamond | 1650 | 93.6 | 0.991452991452991 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 17841252 | 17841252 | PRJNA951810_P_NODE_35454_length_331_cov_10.724806_g35111_i0 | PRJNA951810 | 35454 | 331 | 10.724806 | 35.49910786 | Bacteria | 2 | Bacteria | Bacteria | 173 | 3.69e-49 | NR | HTN73369.1 | 2072417 | g35111 | i0 | 72.7 | 5.97280966767372 | 110 | 30 | 99.7 | 0 | 2 | 331 | 123 | 232 | HTN73369.1 MFS transporter [Candidatus Methylomirabilota bacterium] | diamond | 1977 | 174 | 0.994252873563218 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 23888903 | 23888903 | PRJNA951810_P_NODE_170059_length_242_cov_4.011834_g169714_i0 | PRJNA951810 | 170059 | 242 | 4.011834 | 9.70863828 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 99.4 | 3.61e-23 | NR | HME93788.1 | 2072417 | g169714 | i0 | 72.7 | 6.80578512396694 | 77 | 21 | 95.5 | 0 | 12 | 242 | 4 | 80 | HME93788.1 SDR family oxidoreductase [Candidatus Methylomirabilota bacterium] | diamond | 1647 | 99.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27246987 | 27246987 | PRJNA951810_P_NODE_56083_length_310_cov_4.215190_g55740_i0 | PRJNA951810 | 56083 | 310 | 4.21519 | 13.067089 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 72.8 | 2.34e-12 | NR | HEV8676355.1 | 2072417 | g55740 | i0 | 66 | 0.967741935483871 | 50 | 17 | 48.4 | 0 | 2 | 151 | 44 | 93 | HEV8676355.1 FtsX-like permease family protein [Candidatus Methylomirabilota bacterium] | diamond | 300 | 72.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 27468195 | 27468195 | PRJNA951810_P_NODE_14723_length_503_cov_5.004651_g14390_i0 | PRJNA951810 | 14723 | 503 | 5.004651 | 25.17339453 | Candidatus Methylomirabilales bacterium | 3159508 | Bacteria | Bacteria | 48.1 | 0.00647 | NR | MFI5340186.1 | 3159508 | g14390 | i0 | 38.1 | 0.62624254473161 | 105 | 54 | 59 | 5 | 1 | 297 | 32 | 131 | MFI5340186.1 DUF2341 domain-containing protein [Candidatus Methylomirabilales bacterium] | diamond | 315 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilales bacterium | ||||
| 28573107 | 28573107 | PRJNA951810_P_NODE_156067_length_253_cov_2.883333_g155722_i0 | PRJNA951810 | 156067 | 253 | 2.883333 | 7.29483249 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 116 | 6.44e-30 | NR | HTO81842.1 | 2072417 | g155722 | i0 | 74.4 | 0.972332015810277 | 82 | 20 | 96 | 1 | 250 | 8 | 19 | 100 | HTO81842.1 pyridoxamine 5'-phosphate oxidase family protein [Candidatus Methylomirabilota bacterium] | diamond | 246 | 116 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29141808 | 29141808 | PRJNA951810_P_NODE_66329_length_310_cov_2.654008_g65986_i0 | PRJNA951810 | 66329 | 310 | 2.654008 | 8.2274248 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 70.9 | 1.11e-11 | NR | HET9491779.1 | 2072417 | g65986 | i0 | 60.4 | 0.929032258064516 | 48 | 19 | 46.5 | 0 | 163 | 306 | 741 | 788 | HET9491779.1 M1 family metallopeptidase [Candidatus Methylomirabilota bacterium] | diamond | 288 | 70.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 29899487 | 29899487 | PRJNA951810_P_NODE_191531_length_212_cov_8.316547_g191186_i0 | PRJNA951810 | 191531 | 212 | 8.316547 | 17.63107964 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 55.1 | 1.1e-6 | NR | HEY3100278.1 | 2072417 | g191186 | i0 | 41 | 4.66981132075472 | 61 | 36 | 86.3 | 0 | 30 | 212 | 293 | 353 | HEY3100278.1 tetratricopeptide repeat protein [Candidatus Methylomirabilota bacterium] | diamond | 990 | 55.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30625883 | 30625883 | PRJNA951810_P_NODE_47273_length_310_cov_6.379747_g46930_i0 | PRJNA951810 | 47273 | 310 | 6.379747 | 19.7772157 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 49.3 | 1.08e-4 | NR | HYB62079.1 | 2072417 | g46930 | i0 | 28.3 | 0.890322580645161 | 92 | 52 | 75.5 | 1 | 40 | 273 | 5 | 96 | HYB62079.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 276 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30847219 | 30847219 | PRJNA951810_P_NODE_45074_length_310_cov_7.278481_g44731_i0 | PRJNA951810 | 45074 | 310 | 7.278481 | 22.5632911 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 43.5 | 0.0387 | NR | HSB42657.1 | 2072417 | g44731 | i0 | 29.8 | 1.00645161290323 | 104 | 67 | 94.8 | 1 | 297 | 4 | 47 | 150 | HSB42657.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 312 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31454369 | 31454369 | PRJNA951810_P_NODE_156016_length_253_cov_3.127778_g155671_i0 | PRJNA951810 | 156016 | 253 | 3.127778 | 7.91327834 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 98.6 | 9.81e-22 | NR | HTZ32350.1 | 2072417 | g155671 | i0 | 56.4 | 1.76679841897233 | 78 | 34 | 92.5 | 0 | 1 | 234 | 611 | 688 | HTZ32350.1 response regulator [Candidatus Methylomirabilota bacterium] | diamond | 447 | 98.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31605876 | 31605876 | PRJNA951810_P_NODE_102616_length_291_cov_5.738532_g102272_i0 | PRJNA951810 | 102616 | 291 | 5.738532 | 16.69912812 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 137 | 2.33e-35 | NR | HKW93538.1 | 2072417 | g102272 | i0 | 62.6 | 9.03092783505155 | 99 | 33 | 97.9 | 2 | 290 | 6 | 440 | 538 | HKW93538.1 class I tRNA ligase family protein [Candidatus Methylomirabilota bacterium] | diamond | 2628 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31612382 | 31612382 | PRJNA951810_P_NODE_104416_length_290_cov_4.271889_g104072_i0 | PRJNA951810 | 104416 | 290 | 4.271889 | 12.3884781 | Bacteria candidate phyla | 1783234 | Bacteria | Bacteria | 129 | 4.51e-33 | NR | HTG27384.1 | 2072417 | g104072 | i0 | 69.5 | 3.94137931034483 | 95 | 29 | 98.3 | 0 | 6 | 290 | 197 | 291 | HTG27384.1 MFS transporter [Candidatus Methylomirabilota bacterium] | diamond | 1143 | 130 | 0.992307692307692 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 31637450 | 31637450 | PRJNA951810_P_NODE_44196_length_310_cov_7.763713_g43853_i0 | PRJNA951810 | 44196 | 310 | 7.763713 | 24.0675103 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 125 | 2.12e-32 | NR | MBP2671919.1 | 2072417 | g43853 | i0 | 47.2 | 1.22903225806452 | 127 | 41 | 97.7 | 1 | 4 | 306 | 127 | 253 | MBP2671919.1 hypothetical protein [Candidatus Methylomirabilota bacterium] | diamond | 381 | 125 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32428661 | 32428661 | PRJNA951810_P_NODE_97159_length_294_cov_4.547511_g96815_i0 | PRJNA951810 | 97159 | 294 | 4.547511 | 13.36968234 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 147 | 1.26e-38 | NR | MBI3989588.1 | 2072417 | g96815 | i0 | 70.4 | 2 | 98 | 29 | 100 | 0 | 294 | 1 | 871 | 968 | MBI3989588.1 NgoFVII family restriction endonuclease [Candidatus Methylomirabilota bacterium] | diamond | 588 | 147 | 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);;