contig_metadata
40 rows where bioproject = "PRJNA529241", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4943249 | 4943249 | PRJNA529241_P_NODE_192224_length_173_cov_6.808824_g189902_i0 | PRJNA529241 | 192224 | 173 | 6.808824 | 11.77926552 | Spiroplasmataceae | 2131 | Bacteria | Bacteria | 73.1 | 1.12e-8 | NTclustered | gi|28565759|gb|AY196995.1| | 214888 | g189902 | i0 | 97.619 | 1.80924855491329 | 42 | 1 | 24 | 0 | 35 | 76 | 261 | 302 | Entomoplasma luminosum DNA gyrase subunit B (gyrB) gene, partial cds | blastn | 313 | 73.1 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Entomoplasmatales | Williamsoniiplasma | Williamsoniiplasma luminosum | |||
| 9429653 | 9429653 | PRJNA529241_P_NODE_474788_length_151_cov_8.052632_g472466_i0 | PRJNA529241 | 474788 | 151 | 8.052632 | 12.15947432 | Williamsoniiplasma luminosum | 214888 | Bacteria | Bacteria | 115 | 1.55e-21 | NTclustered | gi|1285333622|gb|CP024963.1| | 214888 | g472466 | i0 | 94.595 | 41.4105960264901 | 74 | 4 | 49 | 0 | 78 | 151 | 210894 | 210967 | Williamsoniiplasma luminosum strain PIMN-1 chromosome, complete genome | blastn | 6253 | 115 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Entomoplasmatales | Williamsoniiplasma | Williamsoniiplasma luminosum | |||
| 11979950 | 11979950 | PRJNA529241_P_NODE_454950_length_155_cov_1.110169_g452628_i0 | PRJNA529241 | 454950 | 155 | 1.110169 | 1.72076195 | Spiroplasma cantharicola | 362837 | Bacteria | Bacteria | 54.7 | 0.004 | NTclustered | gi|927034336|gb|CP012622.1| | 362837 | g452628 | i0 | 100 | 0.187096774193548 | 29 | 0 | 19 | 0 | 97 | 125 | 703421 | 703393 | Spiroplasma cantharicola strain CC-1, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Entomoplasmatales | Spiroplasmataceae | Spiroplasma | Spiroplasma cantharicola | ||
| 18351189 | 18351189 | PRJNA529241_P_NODE_27235_length_399_cov_7.784530_g24934_i0 | PRJNA529241 | 27235 | 399 | 7.78453 | 31.0602747 | Mycoplasmopsis arginini | 2094 | Bacteria | Bacteria | 58.2 | 2.9e-7 | NR | WP_282459043.1 | 2094 | g24934 | i0 | 59.2 | 0.368421052631579 | 49 | 20 | 36.8 | 0 | 45 | 191 | 82 | 130 | WP_282459043.1 hypothetical protein, partial [Mycoplasmopsis arginini] | diamond | 147 | 58.2 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 18967491 | 18967491 | PRJNA529241_P_NODE_420155_length_168_cov_1.190840_g417833_i0 | PRJNA529241 | 420155 | 168 | 1.19084 | 2.0006112 | Mycoplasmoides | 2995234 | Bacteria | Bacteria | 300 | 4.56e-77 | NTclustered | gi|1409670345|gb|MH540253.1| | 2096 | g417833 | i0 | 98.81 | 115.529761904762 | 168 | 2 | 100 | 0 | 1 | 168 | 1350 | 1183 | Mycoplasmoides gallisepticum strain B943-06-2 23S ribosomal RNA gene, partial sequence | blastn | 19409 | 300 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Mycoplasmoidaceae | Mycoplasmoides | Mycoplasmoides gallisepticum | |||
| 20902585 | 20902585 | PRJNA529241_P_NODE_371917_length_173_cov_2.654412_g369595_i0 | PRJNA529241 | 371917 | 173 | 2.654412 | 4.59213276 | Candidatus Izimoplasma sp. HR1 | 1541959 | Bacteria | Bacteria | 62.1 | 2.41e-5 | NTclustered | gi|685629397|gb|CP009415.1| | 1541959 | g369595 | i0 | 94.872 | 0.225433526011561 | 39 | 2 | 23 | 0 | 133 | 171 | 1194075 | 1194113 | Candidatus Izimaplasma bacterium HR1 chromosome, complete genome | blastn | 39 | 62.1 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Candidatus Izemoplasmatales | Candidatus Izemoplasmataceae | Candidatus Izemoplasma | Candidatus Izimoplasma sp. HR1 | ||
| 27172067 | 27172067 | PRJNA529241_P_NODE_34182_length_351_cov_6.942675_g31864_i0 | PRJNA529241 | 34182 | 351 | 6.942675 | 24.36878925 | Candidatus Izemoplasmatales bacterium | 3018265 | Bacteria | Bacteria | 49.3 | 3.82e-5 | NR | MFO7970034.1 | 3018265 | g31864 | i0 | 73.1 | 0.222222222222222 | 26 | 7 | 22.2 | 0 | 5 | 82 | 37 | 62 | MFO7970034.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] | diamond | 78 | 49.3 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Candidatus Izemoplasmatales | Candidatus Izemoplasmatales bacterium | ||||
| 27298766 | 27298766 | PRJNA529241_P_NODE_31283_length_368_cov_8.912387_g28971_i0 | PRJNA529241 | 31283 | 368 | 8.912387 | 32.79758416 | Candidatus Izimaplasma bacterium HR2 | 1541960 | Bacteria | Bacteria | 54.3 | 4.07e-6 | NR | KFZ25814.1 | 1541960 | g28971 | i0 | 59 | 0.635869565217391 | 39 | 16 | 31.8 | 0 | 249 | 365 | 45 | 83 | KFZ25814.1 MAG: hypothetical protein KQ78_01770 [Candidatus Izimaplasma bacterium HR2] | diamond | 234 | 54.3 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Candidatus Izemoplasmatales | Candidatus Izemoplasmataceae | Candidatus Izemoplasma | Candidatus Izimoplasma sp. HR2 | ||
| 27772720 | 27772720 | PRJNA529241_P_NODE_71924_length_249_cov_6.745283_g69602_i0 | PRJNA529241 | 71924 | 249 | 6.745283 | 16.79575467 | Candidatus Izemoplasmatales bacterium | 3018265 | Bacteria | Bacteria | 53.9 | 4.43e-7 | NR | MFA5068056.1 | 3018265 | g69602 | i0 | 65.8 | 0.891566265060241 | 38 | 13 | 45.8 | 0 | 248 | 135 | 64 | 101 | MFA5068056.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] | diamond | 222 | 53.9 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Candidatus Izemoplasmatales | Candidatus Izemoplasmatales bacterium | ||||
| 27787743 | 27787743 | PRJNA529241_P_NODE_379224_length_173_cov_2.588235_g376902_i0 | PRJNA529241 | 379224 | 173 | 2.588235 | 4.47764655 | Bacillati | 1783272 | Bacteria | Bacteria | 55.1 | 4.59e-7 | NR | MCK9492838.1 | 1898209 | g376902 | i0 | 36.5 | 2.91329479768786 | 85 | 26 | 98.8 | 1 | 2 | 172 | 25 | 109 | MCK9492838.1 phage recombination protein Bet [Acholeplasmataceae bacterium] | diamond | 504 | 55.5 | 0.992792792792793 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Acholeplasmataceae bacterium | |||
| 27993656 | 27993656 | PRJNA529241_P_NODE_63025_length_263_cov_1.314159_g60703_i0 | PRJNA529241 | 63025 | 263 | 1.314159 | 3.45623817 | Mycoplasmataceae bacterium | 2685873 | Bacteria | Bacteria | 45.8 | 0.0039 | NR | MBQ5500903.1 | 2685873 | g60703 | i0 | 40.7 | 0.615969581749049 | 54 | 32 | 61.6 | 0 | 89 | 250 | 396 | 449 | MBQ5500903.1 ribonucleoside-diphosphate reductase subunit alpha [Mycoplasmataceae bacterium] | diamond | 162 | 45.8 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Mycoplasmatales | Mycoplasmataceae | Mycoplasmataceae bacterium | |||
| 28088030 | 28088030 | PRJNA529241_P_NODE_372705_length_173_cov_2.647059_g370383_i0 | PRJNA529241 | 372705 | 173 | 2.647059 | 4.57941207 | Aster yellows phytoplasma | 35779 | Bacteria | Bacteria | 39.7 | 0.0306 | NR | AAO61995.1 | 35779 | g370383 | i0 | 43.2 | 0.763005780346821 | 44 | 23 | 76.3 | 1 | 163 | 32 | 10 | 51 | AAO61995.1 nef attachable protein [Aster yellows phytoplasma] | diamond | 132 | 39.7 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Candidatus Phytoplasma | Aster yellows phytoplasma | ||
| 28151483 | 28151483 | PRJNA529241_P_NODE_200125_length_173_cov_6.264706_g197803_i0 | PRJNA529241 | 200125 | 173 | 6.264706 | 10.83794138 | Mollicutes bacterium | 37628 | Bacteria | Bacteria | 47.8 | 2.33e-4 | NR | MCI7332604.1 | 37628 | g197803 | i0 | 79.2 | 1.2485549132948 | 24 | 5 | 41.6 | 0 | 100 | 171 | 185 | 208 | MCI7332604.1 tRNA 2-thiocytidine biosynthesis protein TtcA [Mollicutes bacterium] | diamond | 216 | 47.8 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Mollicutes bacterium | |||||
| 28277499 | 28277499 | PRJNA529241_P_NODE_58246_length_271_cov_4.247863_g55924_i0 | PRJNA529241 | 58246 | 271 | 4.247863 | 11.51170873 | Mycoplasmopsis arginini | 2094 | Bacteria | Bacteria | 45.8 | 0.00192 | NR | MDI3349615.1 | 2094 | g55924 | i0 | 62.9 | 0.387453874538745 | 35 | 11 | 36.5 | 1 | 87 | 185 | 118 | 152 | MDI3349615.1 CCA-adding enzyme [Mycoplasmopsis arginini] | diamond | 105 | 45.8 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 28309317 | 28309317 | PRJNA529241_P_NODE_554906_length_150_cov_8.725664_g552584_i0 | PRJNA529241 | 554906 | 150 | 8.725664 | 13.088496 | Mycoplasmatales bacterium | 2023991 | Bacteria | Bacteria | 65.5 | 9.65e-11 | NR | MFV0247120.1 | 2023991 | g552584 | i0 | 44.6 | 1.84 | 92 | 8 | 98 | 1 | 2 | 148 | 317 | 408 | MFV0247120.1 PTS sugar transporter subunit IIC [Mycoplasmatales bacterium] | diamond | 276 | 65.5 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Mycoplasmatales | Mycoplasmatales bacterium | ||||
| 28498834 | 28498834 | PRJNA529241_P_NODE_473307_length_151_cov_8.491228_g470985_i0 | PRJNA529241 | 473307 | 151 | 8.491228 | 12.82175428 | Candidatus Phytoplasma australasiaticum | 2754999 | Bacteria | Bacteria | 58.2 | 2.6e-9 | NR | MDV3180609.1 | 2754999 | g470985 | i0 | 55.1 | 0.973509933774834 | 49 | 22 | 97.4 | 0 | 3 | 149 | 32 | 80 | MDV3180609.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] | diamond | 147 | 58.2 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Candidatus Phytoplasma | Candidatus Phytoplasma australasiaticum | ||
| 28877381 | 28877381 | PRJNA529241_P_NODE_103248_length_215_cov_3.432584_g100926_i0 | PRJNA529241 | 103248 | 215 | 3.432584 | 7.3800556 | Mycoplasmopsis arginini | 2094 | Bacteria | Bacteria | 85.9 | 2.07e-20 | NR | WP_371831194.1 | 2094 | g100926 | i0 | 89.7 | 0.544186046511628 | 39 | 4 | 54.4 | 0 | 98 | 214 | 12 | 50 | WP_371831194.1 RepB family protein [Mycoplasmopsis arginini] | diamond | 117 | 85.9 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 28877416 | 28877416 | PRJNA529241_P_NODE_205548_length_173_cov_5.955882_g203226_i0 | PRJNA529241 | 205548 | 173 | 5.955882 | 10.30367586 | Candidatus Phytoplasma australasiaticum | 2754999 | Bacteria | Bacteria | 45.1 | 2.56e-4 | NR | MDV3143395.1 | 101513 | g203226 | i0 | 68 | 0.433526011560694 | 25 | 8 | 43.4 | 0 | 75 | 1 | 27 | 51 | MDV3143395.1 hypothetical protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] | diamond | 75 | 45.1 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Candidatus Phytoplasma | Candidatus Phytoplasma australasiaticum | ||
| 29477212 | 29477212 | PRJNA529241_P_NODE_584450_length_150_cov_3.150442_g582128_i0 | PRJNA529241 | 584450 | 150 | 3.150442 | 4.725663 | Candidatus Phytoplasma australasiaticum | 2754999 | Bacteria | Bacteria | 49.3 | 5.1e-5 | NR | MDV3146701.1 | 101513 | g582128 | i0 | 88 | 0.5 | 25 | 3 | 50 | 0 | 76 | 150 | 76 | 100 | MDV3146701.1 retrotransposon gag domain-containing protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] | diamond | 75 | 49.3 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Candidatus Phytoplasma | Candidatus Phytoplasma australasiaticum | ||
| 29603455 | 29603455 | PRJNA529241_P_NODE_61650_length_265_cov_4.206140_g59328_i0 | PRJNA529241 | 61650 | 265 | 4.20614 | 11.146271 | Mycoplasmopsis arginini | 2094 | Bacteria | Bacteria | 78.6 | 9.88e-15 | NR | WP_282459164.1 | 2094 | g59328 | i0 | 52.5 | 0.905660377358491 | 80 | 14 | 63.4 | 1 | 2 | 169 | 11 | 90 | WP_282459164.1 glycosyltransferase, partial [Mycoplasmopsis arginini] | diamond | 240 | 78.6 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 29634988 | 29634988 | PRJNA529241_P_NODE_57570_length_272_cov_5.510638_g55248_i0 | PRJNA529241 | 57570 | 272 | 5.510638 | 14.98893536 | Mycoplasmopsis arginini | 2094 | Bacteria | Bacteria | 68.2 | 1.48e-11 | NR | WP_282459166.1 | 2094 | g55248 | i0 | 85.7 | 0.386029411764706 | 35 | 5 | 38.6 | 0 | 105 | 1 | 13 | 47 | WP_282459166.1 hypothetical protein, partial [Mycoplasmopsis arginini] | diamond | 105 | 68.2 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 29888064 | 29888064 | PRJNA529241_P_NODE_346651_length_173_cov_2.904412_g344329_i0 | PRJNA529241 | 346651 | 173 | 2.904412 | 5.02463276 | Tenericutes bacterium ADurb.Bin239 | 1852920 | Bacteria | Bacteria | 43.9 | 0.00519 | NR | OQA78731.1 | 1852920 | g344329 | i0 | 76 | 0.433526011560694 | 25 | 6 | 43.4 | 0 | 2 | 76 | 137 | 161 | OQA78731.1 MAG: Isoprenyl transferase [Tenericutes bacterium ADurb.Bin239] | diamond | 75 | 43.9 | 1 | Bacteria | Bacillati | Mycoplasmatota | Tenericutes bacterium ADurb.Bin239 | ||||||
| 29919599 | 29919599 | PRJNA529241_P_NODE_185711_length_173_cov_7.477941_g183389_i0 | PRJNA529241 | 185711 | 173 | 7.477941 | 12.93683793 | Candidatus Phytoplasma australasiaticum | 2754999 | Bacteria | Bacteria | 53.5 | 2.37e-7 | NR | MDV3180609.1 | 2754999 | g183389 | i0 | 84 | 0.433526011560694 | 25 | 4 | 43.4 | 0 | 75 | 1 | 26 | 50 | MDV3180609.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] | diamond | 75 | 53.5 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Candidatus Phytoplasma | Candidatus Phytoplasma australasiaticum | ||
| 30155556 | 30155556 | PRJNA529241_P_NODE_199312_length_173_cov_6.316176_g196990_i0 | PRJNA529241 | 199312 | 173 | 6.316176 | 10.92698448 | Mollicutes | 31969 | Bacteria | Bacteria | 52.4 | 5.76e-6 | NR | HHT39681.1 | 1898209 | g196990 | i0 | 50 | 5.39306358381503 | 46 | 23 | 79.8 | 0 | 27 | 164 | 49 | 94 | HHT39681.1 hypothetical protein [Acholeplasmataceae bacterium] | diamond | 933 | 52.4 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Acholeplasmataceae bacterium | |||
| 30203553 | 30203553 | PRJNA529241_P_NODE_205812_length_173_cov_5.948529_g203490_i0 | PRJNA529241 | 205812 | 173 | 5.948529 | 10.29095517 | Mycoplasma sp. CAG:956 | 1262908 | Bacteria | Bacteria | 55.8 | 3.43e-7 | NR | CCY87788.1 | 1262908 | g203490 | i0 | 100 | 0.867052023121387 | 25 | 0 | 43.4 | 0 | 76 | 2 | 391 | 415 | CCY87788.1 dNA topoisomerase [Mycoplasma sp. CAG:956] | diamond | 150 | 55.8 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Mycoplasmatales | Mycoplasmataceae | Mycoplasma | Mycoplasma sp. CAG:956 | ||
| 30740971 | 30740971 | PRJNA529241_P_NODE_474334_length_151_cov_8.175439_g472012_i0 | PRJNA529241 | 474334 | 151 | 8.175439 | 12.34491289 | Candidatus Phytoplasma australasiaticum | 2754999 | Bacteria | Bacteria | 47.8 | 1.83e-4 | NR | MDV3146689.1 | 101513 | g472012 | i0 | 79.2 | 0.47682119205298 | 24 | 5 | 47.7 | 0 | 82 | 11 | 574 | 597 | MDV3146689.1 reverse transcriptase domain-containing protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] | diamond | 72 | 47.8 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Candidatus Phytoplasma | Candidatus Phytoplasma australasiaticum | ||
| 30756206 | 30756206 | PRJNA529241_P_NODE_163754_length_179_cov_4.014085_g161432_i0 | PRJNA529241 | 163754 | 179 | 4.014085 | 7.18521215 | FCB group | 1783270 | Bacteria | Bacteria | 60.1 | 7.92e-10 | NR | WP_282459172.1 | 2094 | g161432 | i0 | 69.4 | 1.18994413407821 | 36 | 11 | 60.3 | 0 | 179 | 72 | 72 | 107 | WP_282459172.1 hypothetical protein [Mycoplasmopsis arginini] | diamond | 213 | 60.1 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 30945862 | 30945862 | PRJNA529241_P_NODE_182694_length_173_cov_8.000000_g180372_i0 | PRJNA529241 | 182694 | 173 | 8 | 13.84 | Bacillati | 1783272 | Bacteria | Bacteria | 43.9 | 0.00259 | NR | WP_119016607.1 | 2088 | g180372 | i0 | 100 | 2.1849710982659 | 21 | 0 | 36.4 | 0 | 172 | 110 | 120 | 140 | WP_119016607.1 30S ribosomal protein S12 [Anaeroplasma bactoclasticum] | diamond | 378 | 43.9 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Anaeroplasmatales | Anaeroplasmataceae | Anaeroplasma | Anaeroplasma bactoclasticum | ||
| 31404905 | 31404905 | PRJNA529241_P_NODE_67956_length_255_cov_5.500000_g65634_i0 | PRJNA529241 | 67956 | 255 | 5.5 | 14.025 | Mycoplasmopsis arginini | 2094 | Bacteria | Bacteria | 50.8 | 2.04e-5 | NR | WP_282459154.1 | 2094 | g65634 | i0 | 84 | 0.294117647058824 | 25 | 4 | 29.4 | 0 | 76 | 2 | 28 | 52 | WP_282459154.1 hypothetical protein, partial [Mycoplasmopsis arginini] | diamond | 75 | 50.8 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 31468140 | 31468140 | PRJNA529241_P_NODE_325496_length_173_cov_3.191176_g323174_i0 | PRJNA529241 | 325496 | 173 | 3.191176 | 5.52073448 | Candidatus Phytoplasma australasiaticum | 2754999 | Bacteria | Bacteria | 48.1 | 3.06e-5 | NR | MDV3194110.1 | 101513 | g323174 | i0 | 87.5 | 0.416184971098266 | 24 | 3 | 41.6 | 0 | 100 | 171 | 60 | 83 | MDV3194110.1 retropepsin-like aspartic protease [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] | diamond | 72 | 48.1 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Candidatus Phytoplasma | Candidatus Phytoplasma australasiaticum | ||
| 31499703 | 31499703 | PRJNA529241_P_NODE_294736_length_173_cov_3.625000_g292414_i0 | PRJNA529241 | 294736 | 173 | 3.625 | 6.27125 | Aster yellows phytoplasma | 35779 | Bacteria | Bacteria | 41.6 | 0.00533 | NR | AAO61995.1 | 35779 | g292414 | i0 | 71.4 | 0.364161849710983 | 21 | 6 | 36.4 | 0 | 100 | 162 | 45 | 65 | AAO61995.1 nef attachable protein [Aster yellows phytoplasma] | diamond | 63 | 41.6 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Candidatus Phytoplasma | Aster yellows phytoplasma | ||
| 31531411 | 31531411 | PRJNA529241_P_NODE_39776_length_323_cov_5.923077_g37457_i0 | PRJNA529241 | 39776 | 323 | 5.923077 | 19.13153871 | Mycoplasmopsis arginini | 2094 | Bacteria | Bacteria | 91.3 | 5.06e-19 | NR | WP_282459164.1 | 2094 | g37457 | i0 | 57.8 | 0.770897832817337 | 83 | 34 | 76.2 | 1 | 251 | 6 | 320 | 402 | WP_282459164.1 glycosyltransferase, partial [Mycoplasmopsis arginini] | diamond | 249 | 91.3 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 31563062 | 31563062 | PRJNA529241_P_NODE_209576_length_173_cov_5.772059_g207254_i0 | PRJNA529241 | 209576 | 173 | 5.772059 | 9.98566207 | Mycoplasmopsis arginini | 2094 | Bacteria | Bacteria | 54.3 | 7.29e-7 | NR | WP_334304941.1 | 2094 | g207254 | i0 | 88 | 0.84971098265896 | 25 | 3 | 43.4 | 0 | 173 | 99 | 94 | 118 | WP_334304941.1 metallophosphoesterase [Mycoplasmopsis arginini] | diamond | 147 | 54.3 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 31720975 | 31720975 | PRJNA529241_P_NODE_35317_length_345_cov_5.461039_g32998_i0 | PRJNA529241 | 35317 | 345 | 5.461039 | 18.84058455 | Mycoplasmopsis arginini | 2094 | Bacteria | Bacteria | 112 | 1.34e-26 | NR | WP_282459164.1 | 2094 | g32998 | i0 | 45.4 | 1.32173913043478 | 152 | 44 | 98.3 | 2 | 344 | 6 | 251 | 402 | WP_282459164.1 glycosyltransferase, partial [Mycoplasmopsis arginini] | diamond | 456 | 112 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 31721064 | 31721064 | PRJNA529241_P_NODE_78177_length_241_cov_5.348039_g75855_i0 | PRJNA529241 | 78177 | 241 | 5.348039 | 12.88877399 | Acholeplasmataceae bacterium | 1898209 | Bacteria | Bacteria | 62 | 5.8e-9 | NR | HHU56624.1 | 1898209 | g75855 | i0 | 56.1 | 0.821576763485477 | 66 | 25 | 82.2 | 1 | 198 | 1 | 8 | 69 | HHU56624.1 hypothetical protein [Acholeplasmataceae bacterium] | diamond | 198 | 62 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Acholeplasmataceae bacterium | |||
| 31878973 | 31878973 | PRJNA529241_P_NODE_37457_length_334_cov_6.121212_g35138_i0 | PRJNA529241 | 37457 | 334 | 6.121212 | 20.44484808 | Mycoplasmopsis arginini | 2094 | Bacteria | Bacteria | 90.5 | 1.08e-18 | NR | WP_282459164.1 | 2094 | g35138 | i0 | 58.8 | 0.718562874251497 | 80 | 32 | 71 | 1 | 242 | 6 | 323 | 402 | WP_282459164.1 glycosyltransferase, partial [Mycoplasmopsis arginini] | diamond | 240 | 90.5 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 32147548 | 32147548 | PRJNA529241_P_NODE_487378_length_151_cov_6.017544_g485056_i0 | PRJNA529241 | 487378 | 151 | 6.017544 | 9.08649144 | Bacillati | 1783272 | Bacteria | Bacteria | 50.4 | 1.94e-5 | NR | OHE30800.1 | 1802347 | g485056 | i0 | 83.3 | 5.72185430463576 | 24 | 4 | 47.7 | 0 | 3 | 74 | 593 | 616 | OHE30800.1 MAG: hypothetical protein A2084_03435 [Tenericutes bacterium GWC2_39_45] | diamond | 864 | 50.4 | 1 | Bacteria | Bacillati | Mycoplasmatota | Tenericutes bacterium GWC2_39_45 | ||||||
| 32290855 | 32290855 | PRJNA529241_P_NODE_261379_length_173_cov_4.191176_g259057_i0 | PRJNA529241 | 261379 | 173 | 4.191176 | 7.25073448 | Anaeroplasma bactoclasticum | 2088 | Bacteria | Bacteria | 53.1 | 2.44e-6 | NR | MCM1514466.1 | 2088 | g259057 | i0 | 100 | 0.433526011560694 | 25 | 0 | 43.4 | 0 | 173 | 99 | 217 | 241 | MCM1514466.1 AAA family ATPase [Anaeroplasma bactoclasticum] | diamond | 75 | 53.1 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Anaeroplasmatales | Anaeroplasmataceae | Anaeroplasma | Anaeroplasma bactoclasticum | ||
| 32290923 | 32290923 | PRJNA529241_P_NODE_450999_length_156_cov_3.386555_g448677_i0 | PRJNA529241 | 450999 | 156 | 3.386555 | 5.2830258 | Mycoplasmopsis arginini | 2094 | Bacteria | Bacteria | 78.2 | 3.43e-17 | NR | WP_282459168.1 | 2094 | g448677 | i0 | 76.5 | 1.96153846153846 | 51 | 12 | 98.1 | 0 | 155 | 3 | 46 | 96 | WP_282459168.1 hypothetical protein, partial [Mycoplasmopsis arginini] | diamond | 306 | 78.2 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 32512312 | 32512312 | PRJNA529241_P_NODE_38499_length_329_cov_6.243151_g36180_i0 | PRJNA529241 | 38499 | 329 | 6.243151 | 20.53996679 | Candidatus Izemoplasmatales bacterium | 3018265 | Bacteria | Bacteria | 48.9 | 6.72e-4 | NR | MFA5068070.1 | 3018265 | g36180 | i0 | 44.7 | 0.428571428571429 | 47 | 25 | 42.9 | 1 | 188 | 328 | 233 | 278 | MFA5068070.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] | diamond | 141 | 48.9 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Candidatus Izemoplasmatales | Candidatus Izemoplasmatales 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);;