RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where bioproject = "PRJNA1054617" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 34 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1054617 · 34 ✖

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
4002970 4002970 PRJNA1054617_S_NODE_5824_length_228_cov_2.983784_g5736_i0 PRJNA1054617 5824 228 2.983784 6.80302752 Mycoplasma ovis 171632 Bacteria Bacteria 231 2.43e-56   NTclustered gi|566058721|gb|CP006935.1| 1415773 g5736 i0 85.333 24.0175438596491 225 32 98 1 2 225 697133 697357 Mycoplasma ovis str. Michigan, complete genome blastn 5476 231 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
10379829 10379829 PRJNA1054617_S_NODE_8949_length_192_cov_0.926174_g8861_i0 PRJNA1054617 8949 192 0.926174 1.77825408 Mycoplasma wenyonii 65123 Bacteria Bacteria 311 2.47e-80   NTclustered gi|395455868|gb|CP003703.1| 1197325 g8861 i0 95.833 1 192 8 100 0 1 192 124040 123849 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 192 311 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
12930209 12930209 PRJNA1054617_S_NODE_10431_length_180_cov_1.927007_g10343_i0 PRJNA1054617 10431 180 1.927007 3.4686126 Mycoplasma wenyonii 65123 Bacteria Bacteria 309 8.21e-80   NTclustered gi|395455868|gb|CP003703.1| 1197325 g10343 i0 97.765 0.994444444444444 179 4 99 0 2 180 543780 543958 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 179 309 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
16753431 16753431 PRJNA1054617_S_NODE_4694_length_249_cov_1.786408_g4606_i0 PRJNA1054617 4694 249 1.786408 4.44815592 Mycoplasma wenyonii 65123 Bacteria Bacteria 444 3.18e-120   NTclustered gi|395455868|gb|CP003703.1| 1197325 g4606 i0 98.795 1.97590361445783 249 3 100 0 1 249 4219 4467 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 492 444 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
18028328 18028328 PRJNA1054617_S_NODE_5795_length_229_cov_1.236559_g5707_i0 PRJNA1054617 5795 229 1.236559 2.83172011 Mycoplasma wenyonii 65123 Bacteria Bacteria 318 1.82e-82   NTclustered gi|395455868|gb|CP003703.1| 1197325 g5707 i0 91.703 2.00436681222707 229 19 100 0 1 229 196350 196122 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 459 318 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
26845693 26845693 PRJNA1054617_S_NODE_14741_length_156_cov_1.221239_g14653_i0 PRJNA1054617 14741 156 1.221239 1.90513284 Mycoplasma wenyonii 65123 Bacteria Bacteria 107 2.42e-25   NR WP_112664982.1 65123 g14653 i0 98 0.980769230769231 51 1 98.1 0 154 2 544 594 WP_112664982.1 RNB domain-containing ribonuclease [Mycoplasma wenyonii] diamond 153 107 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
26845694 26845694 PRJNA1054617_S_NODE_8121_length_199_cov_2.371795_g8033_i0 PRJNA1054617 8121 199 2.371795 4.71987205 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 70.5 3.01e-12   NR WP_187150734.1 432608 g8033 i0 64.6 1.44723618090452 48 15 72.4 1 2 145 46 91 WP_187150734.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 288 70.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
26940263 26940263 PRJNA1054617_S_NODE_8402_length_197_cov_1.194805_g8314_i0 PRJNA1054617 8402 197 1.194805 2.35376585 Mycoplasma ovis 171632 Bacteria Bacteria 92.8 4.29e-20   NR WP_024071233.1 171632 g8314 i0 70.3 0.974619289340102 64 19 97.5 0 192 1 458 521 WP_024071233.1 type I restriction-modification system subunit M [Mycoplasma ovis] diamond 192 92.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
27035287 27035287 PRJNA1054617_S_NODE_13362_length_162_cov_1.546218_g13274_i0 PRJNA1054617 13362 162 1.546218 2.50487316 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 90.9 1.39e-19   NR WP_187150007.1 432608 g13274 i0 89.8 0.907407407407407 49 5 90.7 0 147 1 902 950 WP_187150007.1 type I restriction endonuclease subunit R [Candidatus Mycoplasma haematobovis] diamond 147 90.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27193250 27193250 PRJNA1054617_S_NODE_14382_length_157_cov_2.421053_g14294_i0 PRJNA1054617 14382 157 2.421053 3.80105321 Mycoplasma wenyonii 65123 Bacteria Bacteria 79 1.91e-15   NR WP_112664982.1 65123 g14294 i0 82.4 0.974522292993631 51 9 97.5 0 155 3 139 189 WP_112664982.1 RNB domain-containing ribonuclease [Mycoplasma wenyonii] diamond 153 79 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27319901 27319901 PRJNA1054617_S_NODE_10903_length_177_cov_1.201493_g10815_i0 PRJNA1054617 10903 177 1.201493 2.12664261 Mycoplasma wenyonii 65123 Bacteria Bacteria 47 2.98e-4   NR WP_146737521.1 65123 g10815 i0 41.7 0.813559322033898 48 28 81.4 0 6 149 5 52 WP_146737521.1 hypothetical protein [Mycoplasma wenyonii] diamond 144 47 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27319902 27319902 PRJNA1054617_S_NODE_7703_length_204_cov_1.142857_g7615_i0 PRJNA1054617 7703 204 1.142857 2.33142828 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 85.1 1.83e-18   NR WP_187150380.1 432608 g7615 i0 93.2 0.647058823529412 44 3 64.7 0 47 178 144 187 WP_187150380.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 132 85.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27540974 27540974 PRJNA1054617_S_NODE_3524_length_279_cov_2.338983_g3436_i0 PRJNA1054617 3524 279 2.338983 6.52576257 Mycoplasma ovis 171632 Bacteria Bacteria 144 2.32e-40   NR WP_024071365.1 171632 g3436 i0 79.3 0.989247311827957 92 19 98.9 0 3 278 48 139 WP_024071365.1 DUF5385 family protein [Mycoplasma ovis] diamond 276 144 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
27572450 27572450 PRJNA1054617_S_NODE_11044_length_176_cov_1.383459_g10956_i0 PRJNA1054617 11044 176 1.383459 2.43488784 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 124 1.69e-33   NR WP_187150596.1 432608 g10956 i0 98.3 0.988636363636364 58 1 98.9 0 3 176 161 218 WP_187150596.1 FoF1 ATP synthase subunit A [Candidatus Mycoplasma haematobovis] diamond 174 124 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27635748 27635748 PRJNA1054617_S_NODE_11624_length_172_cov_1.426357_g11536_i0 PRJNA1054617 11624 172 1.426357 2.45333404 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 108 1.04e-28   NR WP_187149619.1 432608 g11536 i0 100 0.994186046511628 57 0 99.4 0 172 2 9 65 WP_187149619.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 171 108 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27762163 27762163 PRJNA1054617_S_NODE_4944_length_244_cov_1.601990_g4856_i0 PRJNA1054617 4944 244 1.60199 3.9088556 Mycoplasma wenyonii 65123 Bacteria Bacteria 65.9 2.61e-10   NR WP_112665104.1 65123 g4856 i0 83.8 0.897540983606557 37 6 45.5 0 3 113 631 667 WP_112665104.1 NAD-dependent DNA ligase LigA [Mycoplasma wenyonii] diamond 219 65.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28519812 28519812 PRJNA1054617_S_NODE_3327_length_286_cov_1.724280_g3239_i0 PRJNA1054617 3327 286 1.72428 4.9314408 Mycoplasma wenyonii 65123 Bacteria Bacteria 59.7 1.99e-8   NR WP_112665163.1 65123 g3239 i0 57.1 0.440559440559441 42 17 43 1 10 132 146 187 WP_112665163.1 hypothetical protein [Mycoplasma wenyonii] diamond 126 59.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28898410 28898410 PRJNA1054617_S_NODE_5768_length_229_cov_2.505376_g5680_i0 PRJNA1054617 5768 229 2.505376 5.73731104 Mycoplasma wenyonii 65123 Bacteria Bacteria 68.6 2.33e-11   NR WP_112664994.1 65123 g5680 i0 51.4 1.93886462882096 74 27 90.4 2 219 13 153 222 WP_112664994.1 hypothetical protein [Mycoplasma wenyonii] diamond 444 68.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28930182 28930182 PRJNA1054617_S_NODE_9428_length_188_cov_0.951724_g9340_i0 PRJNA1054617 9428 188 0.951724 1.78924112 Mycoplasma wenyonii 65123 Bacteria Bacteria 63.5 3.12e-10   NR WP_258393901.1 65123 g9340 i0 80 0.558510638297872 35 7 55.9 0 2 106 43 77 WP_258393901.1 DUF402 domain-containing protein [Mycoplasma wenyonii] diamond 105 63.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28930183 28930183 PRJNA1054617_S_NODE_9908_length_184_cov_1.553191_g9820_i0 PRJNA1054617 9908 184 1.553191 2.85787144 Mycoplasma wenyonii 65123 Bacteria Bacteria 85.9 2.14e-18   NR WP_112665804.1 65123 g9820 i0 79.2 0.782608695652174 48 10 78.3 0 182 39 59 106 WP_112665804.1 restriction endonuclease subunit S [Mycoplasma wenyonii] diamond 144 85.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29025223 29025223 PRJNA1054617_S_NODE_10148_length_182_cov_2.309353_g10060_i0 PRJNA1054617 10148 182 2.309353 4.20302246 Mycoplasma wenyonii 65123 Bacteria Bacteria 99.4 2.06e-24   NR WP_309250884.1 65123 g10060 i0 88.9 0.89010989010989 54 6 89 0 163 2 2 55 WP_309250884.1 translation initiation factor IF-3 [Mycoplasma wenyonii] diamond 162 99.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29025224 29025224 PRJNA1054617_S_NODE_4948_length_244_cov_1.373134_g4860_i0 PRJNA1054617 4948 244 1.373134 3.35044696 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 53.5 1.97e-6   NR WP_187149648.1 432608 g4860 i0 46.2 0.799180327868853 65 35 79.9 0 28 222 28 92 WP_187149648.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 195 53.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30256882 30256882 PRJNA1054617_S_NODE_14672_length_156_cov_1.628319_g14584_i0 PRJNA1054617 14672 156 1.628319 2.54017764 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 68.9 1.71e-12   NR WP_187150533.1 432608 g14584 i0 100 0.673076923076923 35 0 67.3 0 50 154 147 181 WP_187150533.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 105 68.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30288485 30288485 PRJNA1054617_S_NODE_9612_length_186_cov_2.573427_g9524_i0 PRJNA1054617 9612 186 2.573427 4.78657422 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 49.3 3.35e-5   NR WP_187150311.1 432608 g9524 i0 75 0.516129032258065 32 8 51.6 0 185 90 5 36 WP_187150311.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 96 49.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30698759 30698759 PRJNA1054617_S_NODE_11154_length_175_cov_1.977273_g11066_i0 PRJNA1054617 11154 175 1.977273 3.46022775 Mycoplasma wenyonii 65123 Bacteria Bacteria 77 1.22e-14   NR WP_112665837.1 65123 g11066 i0 72.7 0.942857142857143 55 11 87.4 1 153 1 7 61 WP_112665837.1 MIP family Ig-specific serine endopeptidase [Mycoplasma wenyonii] diamond 165 77 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31014786 31014786 PRJNA1054617_S_NODE_12175_length_168_cov_3.312000_g12087_i0 PRJNA1054617 12175 168 3.312 5.56416 Mycoplasma wenyonii 65123 Bacteria Bacteria 48.5 1.2e-4   NR RAO95173.1 65123 g12087 i0 58.8 1.21428571428571 34 14 60.7 0 65 166 113 146 RAO95173.1 energy-coupling factor transporter transmembrane protein EcfT [Mycoplasma wenyonii] diamond 204 48.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31070061 31070061 PRJNA1054617_S_NODE_12695_length_165_cov_2.245902_g12607_i0 PRJNA1054617 12695 165 2.245902 3.7057383 Mycoplasma 2093 Bacteria Bacteria 67.4 2.76e-12   NR WP_014858609.1 141391 g12607 i0 88.9 2.63636363636364 36 4 65.5 0 164 57 123 158 WP_014858609.1 transcription elongation factor GreA [Candidatus Mycoplasma haematolamae] diamond 435 67.8 0.994100294985251 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematolamae
31386150 31386150 PRJNA1054617_S_NODE_11896_length_170_cov_1.811024_g11808_i0 PRJNA1054617 11896 170 1.811024 3.0787408 Mycoplasma 2093 Bacteria Bacteria 95.1 4.7400000000000006e-21   NR WP_112665146.1 65123 g11808 i0 91.1 1.97647058823529 56 5 98.8 0 1 168 392 447 WP_112665146.1 translation initiation factor IF-2 [Mycoplasma wenyonii] diamond 336 95.9 0.991657977059437 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31425741 31425741 PRJNA1054617_S_NODE_4276_length_259_cov_1.625000_g4188_i0 PRJNA1054617 4276 259 1.625 4.20875 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 155 2.1699999999999992e-43   NR WP_187150753.1 432608 g4188 i0 84.9 0.996138996138996 86 13 99.6 0 2 259 224 309 WP_187150753.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 258 155 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31805281 31805281 PRJNA1054617_S_NODE_12897_length_164_cov_1.900826_g12809_i0 PRJNA1054617 12897 164 1.900826 3.11735464 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 107 5.54e-26   NR WP_187149768.1 432608 g12809 i0 98.1 0.98780487804878 54 1 98.8 0 164 3 254 307 WP_187149768.1 type I restriction endonuclease [Candidatus Mycoplasma haematobovis] diamond 162 107 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31995185 31995185 PRJNA1054617_S_NODE_9398_length_188_cov_1.586207_g9310_i0 PRJNA1054617 9398 188 1.586207 2.98206916 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 116 2.2499999999999993e-31   NR WP_187150030.1 432608 g9310 i0 98.4 0.98936170212766 62 1 98.9 0 188 3 79 140 WP_187150030.1 DNA-directed RNA polymerase subunit delta [Candidatus Mycoplasma haematobovis] diamond 186 116 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
32216711 32216711 PRJNA1054617_S_NODE_13498_length_161_cov_2.720339_g13410_i0 PRJNA1054617 13498 161 2.720339 4.37974579 Mycoplasma wenyonii 65123 Bacteria Bacteria 71.6 4.36e-13   NR WP_112665833.1 65123 g13410 i0 72 0.93167701863354 50 14 93.2 0 4 153 43 92 WP_112665833.1 hypothetical protein [Mycoplasma wenyonii] diamond 150 71.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32501666 32501666 PRJNA1054617_S_NODE_11639_length_172_cov_1.426357_g11551_i0 PRJNA1054617 11639 172 1.426357 2.45333404 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 58.9 2.83e-8   NR WP_187150740.1 432608 g11551 i0 70 0.697674418604651 40 12 69.8 0 50 169 873 912 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 120 58.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
32658878 32658878 PRJNA1054617_S_NODE_6400_length_220_cov_1.350282_g6312_i0 PRJNA1054617 6400 220 1.350282 2.9706204 Mycoplasma wenyonii 65123 Bacteria Bacteria 84.3 6.05e-17   NR WP_112665563.1 65123 g6312 i0 97.5 0.545454545454545 40 1 54.5 0 121 2 29 68 WP_112665563.1 type I restriction-modification system subunit M [Mycoplasma wenyonii] diamond 120 84.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii

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