RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA690592" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA690592 · 17 ✖

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
8831904 8831904 PRJNA690592_S_NODE_152687_length_275_cov_1.143564_g151673_i0 PRJNA690592 152687 275 1.143564 3.144801 root 1 Root_unresolved Root_unresolved 60.2 1.51e-4   NTclustered gi|2040369058|gb|CP065588.1| 40477 g151673 i0 97.222 4.71272727272727 36 0 13 1 7 41 314726 314761 Mycoplasma mycoides subsp. capri strain M-5 chromosome, complete genome blastn 1296 60.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma mycoides
14700395 14700395 PRJNA690592_S_NODE_207732_length_243_cov_4.623529_g206718_i0 PRJNA690592 207732 243 4.6235290000000004 11.23517547 Candidatus Xianfuyuplasma coldseepsis 2782163 Bacteria Bacteria 58.4 4.71e-4   NTclustered gi|1883609011|gb|CP048914.1| 2782163 g206718 i0 90.909 0.181069958847737 44 3 18 1 120 163 1397638 1397596 Candidatus Xianfuyuplasma coldseepsis strain zrk13 chromosome, complete genome blastn 44 58.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae Candidatus Xianfuyuplasma Candidatus Xianfuyuplasma coldseepsis
15974472 15974472 PRJNA690592_S_NODE_42813_length_470_cov_2.327456_g41799_i0 PRJNA690592 42813 470 2.327456 10.9390432 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 91.7 3.86e-19   NR HXN54415.1 2023991 g41799 i0 36.8 0.98936170212766 155 95 97 1 13 468 14 168 HXN54415.1 50S ribosomal protein L2 [Mycoplasmatales bacterium] diamond 465 91.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
26733992 26733992 PRJNA690592_S_NODE_99141_length_329_cov_0.902344_g98127_i0 PRJNA690592 99141 329 0.902344 2.96871176 Candidatus Moeniiplasma glomeromycotorum 1822367 Bacteria Bacteria 54.7 2.39e-6   NR MCE8162780.1 1822367 g98127 i0 36.2 2.48024316109422 58 37 52.9 0 294 121 82 139 MCE8162780.1 hypothetical protein [Candidatus Moeniiplasma glomeromycotorum] diamond 816 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Candidatus Moeniiplasma Candidatus Moeniiplasma glomeromycotorum
26765981 26765981 PRJNA690592_S_NODE_158941_length_270_cov_1.172589_g157927_i0 PRJNA690592 158941 270 1.172589 3.1659903 Spiroplasma endosymbiont of Lariophagus distinguendus 2935082 Bacteria Bacteria 54.3 1.58e-6   NR WP_252320172.1 2935082 g157927 i0 41.9 0.688888888888889 62 36 68.9 0 6 191 21 82 WP_252320172.1 ankyrin repeat domain-containing protein, partial [Spiroplasma endosymbiont of Lariophagus distinguendus] diamond 186 54.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Lariophagus distinguendus
27093832 27093832 PRJNA690592_S_NODE_4202_length_1281_cov_2.812914_g3760_i0 PRJNA690592 4202 1281 2.812914 36.03342834 Bacillati 1783272 Bacteria Bacteria 65.5 9.12e-8   NR WP_026660685.1 38986 g3760 i0 24.9 1.49180327868852 285 161 66.7 10 318 1172 46 277 WP_026660685.1 phosphatase PAP2 family protein [Alteracholeplasma palmae] diamond 1911 65.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma palmae
27777652 27777652 PRJNA690592_S_NODE_77404_length_364_cov_1.587629_g76390_i0 PRJNA690592 77404 364 1.587629 5.77896956 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 42.4 0.0406   NR MBP5444981.1 2053494 g76390 i0 30.4 0.568681318681319 69 44 56.9 1 254 48 10 74 MBP5444981.1 hypothetical protein [Acholeplasmatales bacterium] diamond 207 42.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
28314246 28314246 PRJNA690592_S_NODE_179886_length_255_cov_1.269231_g178872_i0 PRJNA690592 179886 255 1.269231 3.23653905 Acholeplasma equirhinis 555393 Bacteria Bacteria 97.4 8.94e-22   NR WP_205734636.1 555393 g178872 i0 52.3 3.03529411764706 86 40 100 1 255 1 196 281 WP_205734636.1 molecular chaperone DnaJ [Acholeplasma equirhinis] diamond 774 97.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma equirhinis
29324471 29324471 PRJNA690592_S_NODE_206169_length_244_cov_1.146199_g205155_i0 PRJNA690592 206169 244 1.146199 2.79672556 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 57 3.41e-7   NR MDR0739416.1 2685873 g205155 i0 38.7 0.762295081967213 62 38 76.2 0 6 191 313 374 MDR0739416.1 leucine-rich repeat domain-containing protein [Mycoplasmataceae bacterium] diamond 186 57 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
29608350 29608350 PRJNA690592_S_NODE_186890_length_251_cov_0.865169_g185876_i0 PRJNA690592 186890 251 0.865169 2.17157419 Spiroplasmataceae bacterium 2872178 Bacteria Bacteria 50.4 3.37e-5   NR MDR1670719.1 2872178 g185876 i0 39.3 0.729083665338645 61 32 71.7 2 13 192 62 118 MDR1670719.1 hypothetical protein [Spiroplasmataceae bacterium] diamond 183 50.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae   Spiroplasmataceae bacterium
29734666 29734666 PRJNA690592_S_NODE_143070_length_283_cov_1.004762_g142056_i0 PRJNA690592 143070 283 1.004762 2.84347646 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 66.6 4.67e-11   NR RKX65638.1 2231116 g142056 i0 44.7 3.75265017667845 85 42 89 3 3 254 107 187 RKX65638.1 MAG: hypothetical protein DRP42_04405 [Mycoplasmatota bacterium] diamond 1062 66.6 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
29987784 29987784 PRJNA690592_S_NODE_38371_length_494_cov_1.047506_g37360_i0 PRJNA690592 38371 494 1.047506 5.17467964 Alteracholeplasma palmae 38986 Bacteria Bacteria 56.2 8.92e-6   NR WP_026653807.1 38986 g37360 i0 25.8 1.71862348178138 132 94 77.7 3 407 24 28 159 WP_026653807.1 ankyrin repeat domain-containing protein [Alteracholeplasma palmae] diamond 849 56.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma palmae
30177163 30177163 PRJNA690592_S_NODE_206532_length_244_cov_0.900585_g205518_i0 PRJNA690592 206532 244 0.900585 2.1974274 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 49.3 1.37e-5   NR NQZ66135.1 2023991 g205518 i0 44.2 1.80737704918033 52 29 63.9 0 237 82 15 66 NQZ66135.1 acyl carrier protein [Mycoplasmatales bacterium] diamond 441 49.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
30840888 30840888 PRJNA690592_S_NODE_64774_length_393_cov_1.525000_g63760_i0 PRJNA690592 64774 393 1.525 5.99325 Mycoplasma sp. 2108 Bacteria Bacteria 68.6 1.7e-10   NR MCR8613206.1 2108 g63760 i0 42 0.67175572519084 88 47 67.2 2 124 387 157 240 MCR8613206.1 histidine--tRNA ligase [Mycoplasma sp.] diamond 264 68.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
31441242 31441242 PRJNA690592_S_NODE_169776_length_262_cov_1.222222_g168762_i0 PRJNA690592 169776 262 1.222222 3.20222164 Spiroplasma endosymbiont of Lariophagus distinguendus 2935082 Bacteria Bacteria 54.7 1.05e-6   NR WP_252320172.1 2935082 g168762 i0 34.6 4.30534351145038 81 48 92.7 1 14 256 24 99 WP_252320172.1 ankyrin repeat domain-containing protein, partial [Spiroplasma endosymbiont of Lariophagus distinguendus] diamond 1128 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Lariophagus distinguendus
31757623 31757623 PRJNA690592_S_NODE_22137_length_636_cov_3.225577_g21159_i0 PRJNA690592 22137 636 3.225577 20.51466972 Candidatus Phytoplasma australiense 59748 Bacteria Bacteria 113 6.07e-25   NR WP_015637812.1 59748 g21159 i0 47.3 1.97641509433962 131 67 61.8 1 394 2 123 251 WP_015637812.1 ATP-dependent zinc metalloprotease FtsH [Candidatus Phytoplasma australiense] diamond 1257 113 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australiense
31979050 31979050 PRJNA690592_S_NODE_66998_length_387_cov_1.764331_g65984_i0 PRJNA690592 66998 387 1.764331 6.82796097 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 174 2.23e-53   NR HXN54586.1 2023991 g65984 i0 71.1 0.883720930232558 114 33 88.4 0 22 363 11 124 HXN54586.1 30S ribosomal protein S12 [Mycoplasmatales bacterium] diamond 342 174 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium

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