RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA698538" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA698538 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
3232526 3232526 PRJNA698538_S_NODE_5403_length_404_cov_3.939577_g5237_i0 PRJNA698538 5403 404 3.939577 15.91589108 Malacoplasma muris 2119 Bacteria Bacteria 103 1.17e-22   NR WP_412032020.1 2119 g5237 i0 39.5 1.9009900990099 129 78 95.8 0 3 389 636 764 WP_412032020.1 DNA polymerase III subunit gamma/tau [Malacoplasma muris] diamond 768 103 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
6288141 6288141 PRJNA698538_S_NODE_9945_length_350_cov_1.938628_g9779_i0 PRJNA698538 9945 350 1.938628 6.785198 Acholeplasma 2147 Bacteria Bacteria 206 5.77e-62   NR WIF88647.1 2148 g9779 i0 84.5 6.96 116 18 99.4 0 348 1 82 197 WIF88647.1 iron-containing alcohol dehydrogenase [Acholeplasma laidlawii] diamond 2436 208 0.990384615384615 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma laidlawii
9609645 9609645 PRJNA698538_S_NODE_10108_length_348_cov_4.930909_g9942_i0 PRJNA698538 10108 348 4.930909 17.15956332 Malacoplasma sp. 2791014 Bacteria Bacteria 148 9.76e-39   NR MDE5553352.1 2791014 g9942 i0 69.9 5.93965517241379 103 31 88.8 0 3 311 884 986 MDE5553352.1 AAA family ATPase [Malacoplasma sp.] diamond 2067 148 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
14710566 14710566 PRJNA698538_S_NODE_8752_length_361_cov_3.159722_g8586_i0 PRJNA698538 8752 361 3.159722 11.40659642 Mycoplasma wenyonii 65123 Bacteria Bacteria 184 2.6e-53   NR WP_376764431.1 65123 g8586 i0 99 0.797783933518006 96 1 79.8 0 359 72 220 315 WP_376764431.1 amidase family protein [Mycoplasma wenyonii] diamond 288 184 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
15984096 15984096 PRJNA698538_S_NODE_23613_length_265_cov_1.604167_g23447_i0 PRJNA698538 23613 265 1.604167 4.25104255 Malacoplasma muris 2119 Bacteria Bacteria 121 2.13e-30   NR WP_412032298.1 2119 g23447 i0 69.3 2.96603773584906 88 27 99.6 0 265 2 192 279 WP_412032298.1 chromosomal replication initiator protein DnaA [Malacoplasma muris] diamond 786 121 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
19808160 19808160 PRJNA698538_S_NODE_13976_length_319_cov_2.682927_g13810_i0 PRJNA698538 13976 319 2.682927 8.55853713 Mycoplasmoidaceae bacterium 2854035 Bacteria Bacteria 157 1.08e-43   NR MDE6477197.1 2854035 g13810 i0 76.2 5.89655172413793 105 25 98.7 0 3 317 335 439 MDE6477197.1 ATP-dependent zinc metalloprotease FtsH [Mycoplasmoidaceae bacterium] diamond 1881 157 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae   Mycoplasmoidaceae bacterium
26650562 26650562 PRJNA698538_S_NODE_9921_length_350_cov_2.797834_g9755_i0 PRJNA698538 9921 350 2.797834 9.792419 Malacoplasma 2791001 Bacteria Bacteria 92 2.06e-20   NR WP_004025426.1 2116 g9755 i0 39.3 1.90285714285714 112 65 96 1 338 3 45 153 WP_004025426.1 hypothetical protein [Malacoplasma iowae] diamond 666 92 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma iowae
27240694 27240694 PRJNA698538_S_NODE_29283_length_243_cov_1.564706_g29117_i0 PRJNA698538 29283 243 1.564706 3.80223558 Mycoplasma bradburyae 2963128 Bacteria Bacteria 50.1 9.71e-5   NR WP_255034290.1 2963128 g29117 i0 38 1.83950617283951 71 43 86.4 1 231 22 90 160 WP_255034290.1 trigger factor [Mycoplasma bradburyae] diamond 447 50.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma bradburyae
27683299 27683299 PRJNA698538_S_NODE_5584_length_401_cov_1.859756_g5418_i0 PRJNA698538 5584 401 1.859756 7.45762156 Mycoplasma wenyonii 65123 Bacteria Bacteria 230 3.88e-72   NR WP_112665181.1 65123 g5418 i0 97.6 0.942643391521197 126 3 94.3 0 380 3 186 311 WP_112665181.1 iron chelate uptake ABC transporter family permease subunit [Mycoplasma wenyonii] diamond 378 230 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27820606 27820606 PRJNA698538_S_NODE_29224_length_243_cov_2.394118_g29058_i0 PRJNA698538 29224 243 2.394118 5.81770674 Malacoplasma 2791001 Bacteria Bacteria 55.5 1.22e-6   NR WP_011077564.1 28227 g29058 i0 53.3 1.64197530864198 45 21 55.6 0 225 91 1 45 WP_011077564.1 Fe-S cluster assembly protein SufB [Malacoplasma penetrans] diamond 399 55.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma penetrans
28093405 28093405 PRJNA698538_S_NODE_9505_length_354_cov_2.206406_g9339_i0 PRJNA698538 9505 354 2.206406 7.81067724 Malacoplasma penetrans 28227 Bacteria Bacteria 129 8.4e-32   NR WP_011076906.1 28227 g9339 i0 58.9 7.21186440677966 124 42 100 4 354 1 135 255 WP_011076906.1 DNA-directed RNA polymerase subunit beta' [Malacoplasma penetrans] diamond 2553 129 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma penetrans
28156785 28156785 PRJNA698538_S_NODE_10585_length_344_cov_4.188192_g10419_i0 PRJNA698538 10585 344 4.188192 14.40738048 Ureaplasma sp. 1965234 Bacteria Bacteria 130 4.36e-33   NR MDE6472837.1 1965234 g10419 i0 53.6 3.8546511627907 112 52 97.7 0 344 9 172 283 MDE6472837.1 trigger factor [Ureaplasma sp.] diamond 1326 130 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma sp.
28187896 28187896 PRJNA698538_S_NODE_22506_length_270_cov_3.000000_g22340_i0 PRJNA698538 22506 270 3 8.1 Malacoplasma iowae 2116 Bacteria Bacteria 81.6 5.61e-17   NR WP_320167597.1 2116 g22340 i0 44.4 1 90 50 100 0 1 270 20 109 WP_320167597.1 ATP synthase F1 subunit delta [Malacoplasma iowae] diamond 270 81.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma iowae
28515152 28515152 PRJNA698538_S_NODE_22347_length_271_cov_2.691919_g22181_i0 PRJNA698538 22347 271 2.691919 7.29510049 Bacillati 1783272 Bacteria Bacteria 94 3.76e-21   NR HHZ17916.1 1898209 g22181 i0 58.7 7.37269372693727 75 31 83 0 47 271 11 85 HHZ17916.1 50S ribosomal protein L9 [Acholeplasmataceae bacterium] diamond 1998 94.4 0.995762711864407 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
28566950 28566950 PRJNA698538_S_NODE_13367_length_323_cov_2.312000_g13201_i0 PRJNA698538 13367 323 2.312 7.46776 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 70.1 1.25e-11   NR MDK2819821.1 2685873 g13201 i0 46.8 0.715170278637771 77 37 69.7 3 228 4 7 81 MDK2819821.1 HAD-IIB family hydrolase [Mycoplasmataceae bacterium] diamond 231 70.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
28724910 28724910 PRJNA698538_S_NODE_22927_length_268_cov_3.112821_g22761_i0 PRJNA698538 22927 268 3.112821 8.34236028 Malacoplasma iowae 2116 Bacteria Bacteria 130 2.62e-34   NR WP_406646227.1 2116 g22761 i0 72.7 3.94029850746269 88 24 98.5 0 2 265 49 136 WP_406646227.1 hypothetical protein [Malacoplasma iowae] diamond 1056 130 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma iowae
28925438 28925438 PRJNA698538_S_NODE_20428_length_281_cov_2.293269_g20262_i0 PRJNA698538 20428 281 2.293269 6.44408589 Malacoplasma 2791001 Bacteria Bacteria 125 2.26e-34   NR WP_320168761.1 2116 g20262 i0 63 5.82918149466192 92 34 98.2 0 279 4 69 160 WP_320168761.1 50S ribosomal protein L10 [Malacoplasma iowae] diamond 1638 125 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma iowae
29198651 29198651 PRJNA698538_S_NODE_15189_length_311_cov_3.525210_g15023_i0 PRJNA698538 15189 311 3.52521 10.9634031 Malacoplasma sp. 2791014 Bacteria Bacteria 45.8 0.00649   NR MEG0879338.1 2791014 g15023 i0 32.8 0.646302250803859 67 45 64.6 0 95 295 5 71 MEG0879338.1 phospholipase D-like domain-containing protein [Malacoplasma sp.] diamond 201 45.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
29388106 29388106 PRJNA698538_S_NODE_9309_length_356_cov_1.003534_g9143_i0 PRJNA698538 9309 356 1.003534 3.57258104 Haloplasma contractile 471825 Bacteria Bacteria 82 1.13e-16   NR WP_051316909.1 471825 g9143 i0 56.3 2.04775280898876 71 31 59.8 0 213 1 1 71 WP_051316909.1 translation initiation factor IF-3 [Haloplasma contractile] diamond 729 82 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Haloplasmatales Haloplasmataceae Haloplasma Haloplasma contractile
29798297 29798297 PRJNA698538_S_NODE_15531_length_309_cov_3.093220_g15365_i0 PRJNA698538 15531 309 3.09322 9.5580498 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 138 4.79e-39   NR MDO9629773.1 1898209 g15365 i0 71.6 1.98058252427184 102 29 99 0 308 3 73 174 MDO9629773.1 SIS domain-containing protein [Acholeplasmataceae bacterium] diamond 612 138 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
30050985 30050985 PRJNA698538_S_NODE_18271_length_293_cov_1.750000_g18105_i0 PRJNA698538 18271 293 1.75 5.1275 Mycoplasma sp. 2108 Bacteria Bacteria 59.3 9.92e-8   NR MBD5445994.1 2108 g18105 i0 43 0.808873720136519 79 45 80.9 0 275 39 124 202 MBD5445994.1 ATP-binding cassette domain-containing protein [Mycoplasma sp.] diamond 237 59.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
31219835 31219835 PRJNA698538_S_NODE_30955_length_233_cov_3.131250_g30789_i0 PRJNA698538 30955 233 3.13125 7.2958125 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 65.9 9.79e-12   NR MDK2819536.1 2685873 g30789 i0 58.6 0.901287553648069 70 28 88.8 1 3 209 1 70 MDK2819536.1 PTS lactose/cellobiose transporter subunit IIA [Mycoplasmataceae bacterium] diamond 210 65.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
31916007 31916007 PRJNA698538_S_NODE_2657_length_484_cov_1.569343_g2491_i0 PRJNA698538 2657 484 1.569343 7.59562012 Malacoplasma muris 2119 Bacteria Bacteria 120 6.41e-31   NR WP_412031875.1 2119 g2491 i0 67.5 0.495867768595041 80 26 49.6 0 3 242 100 179 WP_412031875.1 inorganic diphosphatase [Malacoplasma muris] diamond 240 120 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
32307286 32307286 PRJNA698538_S_NODE_22479_length_270_cov_4.299492_g22313_i0 PRJNA698538 22479 270 4.299492 11.6086284 Malacoplasma 2791001 Bacteria Bacteria 110 1.1e-26   NR WP_412032156.1 2119 g22313 i0 62.1 2.88888888888889 87 33 96.7 0 270 10 250 336 WP_412032156.1 type I glyceraldehyde-3-phosphate dehydrogenase [Malacoplasma muris] diamond 780 111 0.990990990990991 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
32422312 32422312 PRJNA698538_S_NODE_18379_length_292_cov_3.337900_g18213_i0 PRJNA698538 18379 292 3.3379 9.746668 Malacoplasma sp. 2791014 Bacteria Bacteria 92 1.76e-21   NR MDE7075572.1 2791014 g18213 i0 51.1 0.904109589041096 88 43 90.4 0 286 23 27 114 MDE7075572.1 hypothetical protein [Malacoplasma sp.] diamond 264 92 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
32454190 32454190 PRJNA698538_S_NODE_25679_length_255_cov_3.148352_g25513_i0 PRJNA698538 25679 255 3.148352 8.0282976 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 99.8 2.29e-22   NR WP_187150753.1 432608 g25513 i0 64.8 0.835294117647059 71 24 83.5 1 2 214 356 425 WP_187150753.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 213 99.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
32611930 32611930 PRJNA698538_S_NODE_19260_length_287_cov_2.892523_g19094_i0 PRJNA698538 19260 287 2.892523 8.30154101 Mycoplasma ovis 171632 Bacteria Bacteria 92.8 5.32e-20   NR WP_024071157.1 171632 g19094 i0 59.8 0.909407665505226 87 35 90.9 0 22 282 208 294 WP_024071157.1 hypothetical protein [Mycoplasma ovis] diamond 261 92.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
32738040 32738040 PRJNA698538_S_NODE_26380_length_252_cov_1.731844_g26214_i0 PRJNA698538 26380 252 1.731844 4.36424688 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 97.8 1.4500000000000002e-21   NR MDK2819538.1 2685873 g26214 i0 68.1 0.821428571428571 69 22 82.1 0 46 252 116 184 MDK2819538.1 PTS sugar transporter subunit IIC [Mycoplasmataceae bacterium] diamond 207 97.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae 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);;