RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 26 ✖

tax_kingdom 1

bioproject 1

  • PRJNA556992 · 26 ✖

analysis 1

  • diamond · 26 ✖

tax_clade 0

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
17111697 17111697 PRJNA556992_P_NODE_859294_length_243_cov_0.905882_g857104_i0 PRJNA556992 859294 243 0.905882 2.20129326 Bacillati 1783272 Bacteria Bacteria 127 1.3e-32   NR MCM1514382.1 2088 g857104 i0 69.2 11.7283950617284 78 24 96.3 0 235 2 309 386 MCM1514382.1 lysine--tRNA ligase [Anaeroplasma bactoclasticum] diamond 2850 127 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Anaeroplasmatales Anaeroplasmataceae Anaeroplasma Anaeroplasma bactoclasticum
26635018 26635018 PRJNA556992_P_NODE_1017221_length_228_cov_8.316129_g1015031_i0 PRJNA556992 1017221 228 8.316129 18.96077412 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 110 1.5600000000000002e-26   NR HHW79667.1 1898209 g1015031 i0 84.1 0.828947368421053 63 10 82.9 0 9 197 339 401 HHW79667.1 HD domain-containing protein [Acholeplasmataceae bacterium] diamond 189 110 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
26920176 26920176 PRJNA556992_P_NODE_1133022_length_205_cov_5.500000_g1130831_i0 PRJNA556992 1133022 205 5.5 11.275 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 75.1 7.32e-16   NR MDV3191329.1 2754999 g1130831 i0 73.3 0.658536585365854 45 12 65.9 0 201 67 38 82 MDV3191329.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 135 75.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
27078476 27078476 PRJNA556992_P_NODE_339062_length_283_cov_2.995238_g336873_i0 PRJNA556992 339062 283 2.995238 8.47652354 Tenericutes bacterium ADurb.BinA124 1852921 Bacteria Bacteria 151 6.799999999999998e-44   NR OPZ32321.1 1852921 g336873 i0 81.7 1.97173144876325 93 17 98.6 0 281 3 35 127 OPZ32321.1 MAG: hypothetical protein BWY97_01571 [Tenericutes bacterium ADurb.BinA124] diamond 558 151 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium ADurb.BinA124
27267916 27267916 PRJNA556992_P_NODE_109143_length_394_cov_4.866044_g106959_i0 PRJNA556992 109143 394 4.866044 19.17221336 Malacoplasma sp. 2791014 Bacteria Bacteria 44.3 0.0222   NR MCF0217647.1 2791014 g106959 i0 36.4 0.418781725888325 55 35 41.9 0 394 230 76 130 MCF0217647.1 low molecular weight phosphotyrosine protein phosphatase [Malacoplasma sp.] diamond 165 44.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
27363339 27363339 PRJNA556992_P_NODE_542483_length_263_cov_4.342105_g540294_i0 PRJNA556992 542483 263 4.342105 11.41973615 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 111 3.86e-29   NR MDV3180564.1 2754999 g540294 i0 65.7 0.798479087452472 70 24 79.8 0 261 52 62 131 MDV3180564.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 210 111 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
28120826 28120826 PRJNA556992_P_NODE_520165_length_265_cov_3.265625_g517976_i0 PRJNA556992 520165 265 3.265625 8.65390625 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 80.5 3.61e-17   NR MDV3192348.1 2754999 g517976 i0 52.4 0.928301886792453 82 38 91.7 1 23 265 21 102 MDV3192348.1 retrotransposon gag domain-containing protein [Candidatus Phytoplasma australasiaticum] diamond 246 80.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
28563206 28563206 PRJNA556992_P_NODE_941127_length_236_cov_5.386503_g938937_i0 PRJNA556992 941127 236 5.386503 12.71214708 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 129 8.819999999999999e-37   NR MDV3180609.1 2754999 g938937 i0 82.9 0.889830508474576 70 12 89 0 210 1 2 71 MDV3180609.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 210 129 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
28594411 28594411 PRJNA556992_P_NODE_221587_length_316_cov_1.341564_g219399_i0 PRJNA556992 221587 316 1.341564 4.23934224 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 115 5.16e-28   NR MCK9234807.1 1898209 g219399 i0 52.8 1.00632911392405 106 45 95.9 1 14 316 115 220 MCK9234807.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 318 115 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
29952135 29952135 PRJNA556992_P_NODE_4291_length_1530_cov_9.332189_g3497_i0 PRJNA556992 4291 1530 9.332189 142.7824917 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 199 3.05e-51   NR MCK9234969.1 1898209 g3497 i0 37.5 0.527450980392157 269 166 52.5 2 5 808 706 973 MCK9234969.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 807 199 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
30015729 30015729 PRJNA556992_P_NODE_960111_length_234_cov_6.018634_g957921_i0 PRJNA556992 960111 234 6.018634 14.08360356 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 60.8 6.01e-10   NR MDV3205140.1 101513 g957921 i0 49.2 0.756410256410256 59 26 75.6 1 42 218 1 55 MDV3205140.1 hypothetical protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 177 60.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
30109904 30109904 PRJNA556992_P_NODE_1158352_length_199_cov_10.690476_g1156161_i0 PRJNA556992 1158352 199 10.690476 21.27404724 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 73.2 2.06e-14   NR MDV3180564.1 2754999 g1156161 i0 71.7 0.693467336683417 46 13 69.3 0 197 60 92 137 MDV3180564.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 138 73.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
30552445 30552445 PRJNA556992_P_NODE_710253_length_250_cov_5.022599_g708064_i0 PRJNA556992 710253 250 5.022599 12.5564975 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 142 2.84e-41   NR MDV3191327.1 2754999 g708064 i0 86.7 0.996 83 11 99.6 0 1 249 43 125 MDV3191327.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 249 142 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
30678870 30678870 PRJNA556992_P_NODE_844733_length_243_cov_4.870588_g842543_i0 PRJNA556992 844733 243 4.870588 11.83552884 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 64.7 1.49e-11   NR MDV3191329.1 2754999 g842543 i0 74.4 0.481481481481481 39 10 48.1 0 123 239 33 71 MDV3191329.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 117 64.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
30710219 30710219 PRJNA556992_P_NODE_126074_length_377_cov_13.638158_g123887_i0 PRJNA556992 126074 377 13.638158 51.41585566 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 55.1 9.35e-7   NR MDD3477916.1 3018265 g123887 i0 33.6 0.89920424403183 113 68 84.4 3 5 322 7 119 MDD3477916.1 DUF2591 family protein [Candidatus Izemoplasmatales bacterium] diamond 339 55.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
30773552 30773552 PRJNA556992_P_NODE_1114214_length_209_cov_6.647059_g1112023_i0 PRJNA556992 1114214 209 6.647059 13.89235331 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 95.9 7.28e-24   NR MDV3180616.1 2754999 g1112023 i0 78.3 0.990430622009569 69 15 99 0 3 209 28 96 MDV3180616.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 207 95.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
30899957 30899957 PRJNA556992_P_NODE_113174_length_390_cov_2.309148_g110988_i0 PRJNA556992 113174 390 2.309148 9.0056772 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 78.2 8.64e-15   NR MCK9234676.1 1898209 g110988 i0 39.4 0.761538461538461 99 60 76.2 0 29 325 105 203 MCK9234676.1 DUF4376 domain-containing protein [Acholeplasmataceae bacterium] diamond 297 78.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
31026612 31026612 PRJNA556992_P_NODE_614795_length_257_cov_6.434783_g612606_i0 PRJNA556992 614795 257 6.434783 16.53739231 Tenericutes bacterium HGW-Tenericutes-6 2013849 Bacteria Bacteria 157 1.3499999999999997e-42   NR PKK93891.1 2013849 g612606 i0 85.9 0.992217898832685 85 12 99.2 0 255 1 709 793 PKK93891.1 MAG: hypothetical protein CVV61_02330 [Tenericutes bacterium HGW-Tenericutes-6] diamond 255 157 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium HGW-Tenericutes-6
31089827 31089827 PRJNA556992_P_NODE_929715_length_238_cov_2.066667_g927525_i0 PRJNA556992 929715 238 2.066667 4.91866746 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 56.6 2.59e-8   NR MBR2022310.1 2685873 g927525 i0 86.2 0.365546218487395 29 4 36.6 0 137 223 61 89 MBR2022310.1 hypothetical protein [Mycoplasmataceae bacterium] diamond 87 56.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
31184074 31184074 PRJNA556992_P_NODE_402395_length_276_cov_2.507389_g400206_i0 PRJNA556992 402395 276 2.507389 6.92039364 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 58.9 2.92e-9   NR MDV3191285.1 2754999 g400206 i0 70 0.434782608695652 40 12 43.5 0 123 4 1 40 MDV3191285.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 120 58.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
31468998 31468998 PRJNA556992_P_NODE_1132456_length_205_cov_6.151515_g1130265_i0 PRJNA556992 1132456 205 6.151515 12.61060575 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 42 0.0426   NR MCK9234800.1 1898209 g1130265 i0 35.7 0.819512195121951 56 34 82 1 2 169 54 107 MCK9234800.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 168 42 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
31799480 31799480 PRJNA556992_P_NODE_387417_length_278_cov_1.409756_g385228_i0 PRJNA556992 387417 278 1.409756 3.91912168 Bacillati 1783272 Bacteria Bacteria 45.8 0.00279   NR MCE8162780.1 1822367 g385228 i0 30.5 1.34892086330935 59 40 63.7 1 85 261 82 139 MCE8162780.1 hypothetical protein [Candidatus Moeniiplasma glomeromycotorum] diamond 375 46.2 0.991341991341991 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Candidatus Moeniiplasma Candidatus Moeniiplasma glomeromycotorum
32133271 32133271 PRJNA556992_P_NODE_1138918_length_204_cov_4.389313_g1136727_i0 PRJNA556992 1138918 204 4.389313 8.95419852 Haloplasmataceae bacterium 2862752 Bacteria Bacteria 115 2.88e-29   NR MDF2699842.1 2862752 g1136727 i0 89.6 0.985294117647059 67 7 98.5 0 202 2 184 250 MDF2699842.1 hypothetical protein [Haloplasmataceae bacterium] diamond 201 115 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Haloplasmatales Haloplasmataceae   Haloplasmataceae bacterium
32196453 32196453 PRJNA556992_P_NODE_1059058_length_222_cov_7.234899_g1056868_i0 PRJNA556992 1059058 222 7.234899 16.06147578 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 113 1.04e-30   NR MDV3180603.1 2754999 g1056868 i0 86 0.77027027027027 57 8 77 0 51 221 1 57 MDV3180603.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 171 113 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
32386280 32386280 PRJNA556992_P_NODE_1113699_length_209_cov_7.801471_g1111508_i0 PRJNA556992 1113699 209 7.801471 16.30507439 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 62.8 5.61e-11   NR MDV3191329.1 2754999 g1111508 i0 79.4 0.488038277511962 34 7 48.8 0 208 107 41 74 MDV3191329.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 102 62.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
32545132 32545132 PRJNA556992_P_NODE_907979_length_240_cov_2.586826_g905789_i0 PRJNA556992 907979 240 2.586826 6.2083824 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 130 4.159999999999999e-37   NR MDV3191300.1 2754999 g905789 i0 100 0.8 64 0 80 0 3 194 70 133 MDV3191300.1 hypothetical protein [Candidatus Phytoplasma australasiaticum] diamond 192 130 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;