RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA1074408" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1074408 · 21 ✖

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
1465591 1465591 PRJNA1074408_S_NODE_6802_length_179_cov_1.411765_g6672_i0 PRJNA1074408 6802 179 1.411765 2.52705935 Malacoplasma muris 2119 Bacteria Bacteria 279 6.39e-71   NTclustered gi|299851933|gb|HM135461.1| 2119 g6672 i0 94.972 134.888268156425 179 8 100 1 1 179 318 495 Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence blastn 24145 279 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
2741676 2741676 PRJNA1074408_S_NODE_5403_length_199_cov_1.538462_g5273_i0 PRJNA1074408 5403 199 1.538462 3.06153938 Mycoplasma wenyonii 65123 Bacteria Bacteria 335 1.5299999999999996e-87   NTclustered gi|395455868|gb|CP003703.1| 1197325 g5273 i0 96.985 1 199 6 100 0 1 199 36199 36001 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 199 335 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
3567148 3567148 PRJNA1074408_S_NODE_4943_length_208_cov_1.454545_g4813_i0 PRJNA1074408 4943 208 1.454545 3.0254536 Mycoplasmoidales 2790996 Bacteria Bacteria 318 1.63e-82   NTclustered gi|1563789200|emb|LR214962.1| 2115 g4813 i0 94.231 298.096153846154 208 12 100 0 1 208 355660 355867 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 8 blastn 62004 318 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
10394284 10394284 PRJNA1074408_S_NODE_6629_length_181_cov_1.391304_g6499_i0 PRJNA1074408 6629 181 1.391304 2.51826024 Mycoplasma amphoriforme 273136 Bacteria Bacteria 91.6 3.26e-14   NTclustered gi|633894721|emb|HG937516.1| 572419 g6499 i0 96.364 2.33149171270718 55 2 30 0 1 55 824898 824844 Mycoplasma amphoriforme A39 complete genome blastn 422 91.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma amphoriforme
12495330 12495330 PRJNA1074408_S_NODE_3850_length_235_cov_2.744792_g3720_i0 PRJNA1074408 3850 235 2.744792 6.4502612 Mycoplasmoidales 2790996 Bacteria Bacteria 281 2.47e-71   NTclustered gi|1563789200|emb|LR214962.1| 2115 g3720 i0 88.511 116.914893617021 235 24 99 3 1 233 358056 358289 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 8 blastn 27475 283 0.992932862190813 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
12944705 12944705 PRJNA1074408_S_NODE_10171_length_150_cov_0.897196_g10041_i0 PRJNA1074408 10171 150 0.897196 1.345794 Mycoplasma wenyonii 65123 Bacteria Bacteria 83.6 2.63e-17   NR WP_112665764.1 65123 g10041 i0 79.6 0.98 49 10 98 0 149 3 237 285 WP_112665764.1 DnaJ domain-containing protein [Mycoplasma wenyonii] diamond 147 83.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
15493645 15493645 PRJNA1074408_S_NODE_6613_length_181_cov_1.739130_g6483_i0 PRJNA1074408 6613 181 1.73913 3.1478253 Mycoplasma ovis 171632 Bacteria Bacteria 156 1.14e-33   NTclustered gi|566058721|gb|CP006935.1| 1415773 g6483 i0 91.964 3.55801104972376 112 8 62 1 68 179 6078 6188 Mycoplasma ovis str. Michigan, complete genome blastn 644 156 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
24416912 24416912 PRJNA1074408_S_NODE_3820_length_236_cov_2.487047_g3690_i0 PRJNA1074408 3820 236 2.487047 5.86943092 Malacoplasma microti 38746 Bacteria Bacteria 316 6.8e-82   NTclustered gi|299851939|gb|HM135466.1| 38746 g3690 i0 91.102 100.03813559322 236 18 100 3 1 236 1476 1708 Mycoplasma microti strain IL371 23S ribosomal RNA gene, partial sequence blastn 23609 316 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma microti
26718876 26718876 PRJNA1074408_S_NODE_7001_length_177_cov_1.067164_g6871_i0 PRJNA1074408 7001 177 1.067164 1.88888028 [Mycoplasma] mobile 2118 Bacteria Bacteria 75.1 2.62e-14   NR WP_011264716.1 2118 g6871 i0 56.9 0.983050847457627 58 25 98.3 0 176 3 140 197 WP_011264716.1 ABC transporter ATP-binding protein [[Mycoplasma] mobile] diamond 174 75.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma [Mycoplasma] mobile
26814380 26814380 PRJNA1074408_S_NODE_7621_length_170_cov_1.511811_g7491_i0 PRJNA1074408 7621 170 1.511811 2.5700787 Malacoplasma sp. 2791014 Bacteria Bacteria 65.5 9.32e-12   NR MDE7075572.1 2791014 g7491 i0 53.6 1.88823529411765 56 26 98.8 0 1 168 36 91 MDE7075572.1 hypothetical protein [Malacoplasma sp.] diamond 321 65.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
27035821 27035821 PRJNA1074408_S_NODE_3282_length_255_cov_1.584906_g3152_i0 PRJNA1074408 3282 255 1.584906 4.0415103 Malacoplasma muris 2119 Bacteria Bacteria 86.7 3.93e-18   NR WP_412032264.1 2119 g3152 i0 53 3.90588235294118 83 39 97.6 0 254 6 76 158 WP_412032264.1 translation elongation factor Ts [Malacoplasma muris] diamond 996 86.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
27352155 27352155 PRJNA1074408_S_NODE_7823_length_168_cov_1.152000_g7693_i0 PRJNA1074408 7823 168 1.152 1.93536 Mycoplasma wenyonii 65123 Bacteria Bacteria 90.9 1.05e-19   NR WP_112665012.1 65123 g7693 i0 85.2 0.964285714285714 54 8 96.4 0 2 163 138 191 WP_112665012.1 hypothetical protein [Mycoplasma wenyonii] diamond 162 90.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28078060 28078060 PRJNA1074408_S_NODE_5185_length_203_cov_1.500000_g5055_i0 PRJNA1074408 5185 203 1.5 3.045 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 110 2.19e-28   NR WP_187149713.1 432608 g5055 i0 84.8 0.975369458128079 66 10 97.5 0 198 1 10 75 WP_187149713.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 198 110 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28867472 28867472 PRJNA1074408_S_NODE_3488_length_247_cov_1.176471_g3358_i0 PRJNA1074408 3488 247 1.176471 2.90588337 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 136 2.57e-39   NR WP_187150736.1 432608 g3358 i0 98.4 0.777327935222672 64 1 77.7 0 17 208 1 64 WP_187150736.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 192 136 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
29562003 29562003 PRJNA1074408_S_NODE_4870_length_210_cov_1.377246_g4740_i0 PRJNA1074408 4870 210 1.377246 2.8922166 Mycoplasma wenyonii 65123 Bacteria Bacteria 126 8.78e-34   NR WP_112665189.1 65123 g4740 i0 95.7 0.985714285714286 69 3 98.6 0 209 3 1 69 WP_112665189.1 translation elongation factor Ts [Mycoplasma wenyonii] diamond 207 126 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30098901 30098901 PRJNA1074408_S_NODE_1932_length_328_cov_2.635088_g1802_i0 PRJNA1074408 1932 328 2.635088 8.64308864 Mycoplasma sp. 2108 Bacteria Bacteria 44.7 0.0205   NR MBD5445756.1 2108 g1802 i0 48.1 0.475609756097561 52 26 47.6 1 30 185 539 589 MBD5445756.1 hypothetical protein [Mycoplasma sp.] diamond 156 44.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
30509761 30509761 PRJNA1074408_S_NODE_6233_length_186_cov_1.573427_g6103_i0 PRJNA1074408 6233 186 1.573427 2.92657422 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 102 1.73e-23   NR WP_187150740.1 432608 g6103 i0 100 0.790322580645161 49 0 79 0 147 1 80 128 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 147 102 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31679191 31679191 PRJNA1074408_S_NODE_4057_length_230_cov_1.540107_g3927_i0 PRJNA1074408 4057 230 1.540107 3.5422461 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 62.8 2.78e-9   NR WP_187150740.1 432608 g3927 i0 53.3 0.782608695652174 60 27 78.3 1 3 182 969 1027 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 180 62.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31805808 31805808 PRJNA1074408_S_NODE_9357_length_154_cov_1.351351_g9227_i0 PRJNA1074408 9357 154 1.351351 2.08108054 Mycoplasma amphoriforme 273136 Bacteria Bacteria 45.8 4.98e-4   NR WP_343251789.1 273136 g9227 i0 38.8 0.954545454545455 49 30 95.5 0 1 147 93 141 WP_343251789.1 CinA family protein [Mycoplasma amphoriforme] diamond 147 45.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma amphoriforme
32785480 32785480 PRJNA1074408_S_NODE_10080_length_150_cov_1.542056_g9950_i0 PRJNA1074408 10080 150 1.542056 2.313084 Mycoplasma ovis 171632 Bacteria Bacteria 83.6 4.15e-17   NR WP_024071642.1 171632 g9950 i0 81.6 0.98 49 9 98 0 2 148 248 296 WP_024071642.1 type I DNA topoisomerase [Mycoplasma ovis] diamond 147 83.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
32785482 32785482 PRJNA1074408_S_NODE_4460_length_220_cov_1.084746_g4330_i0 PRJNA1074408 4460 220 1.084746 2.3864412 Mycoplasmoides fastidiosum 92758 Bacteria Bacteria 45.1 0.00317   NR WP_256547184.1 92758 g4330 i0 34.4 0.872727272727273 64 42 87.3 0 29 220 108 171 WP_256547184.1 dephospho-CoA kinase [Mycoplasmoides fastidiosum] diamond 192 45.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Mycoplasmoides Mycoplasmoides fastidiosum

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