RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA753151" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA753151 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
26672703 26672703 PRJNA753151_S_NODE_252361_length_178_cov_2.000000_g250071_i0 PRJNA753151 252361 178 2 3.56 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 98.6 2.16e-22   NR WP_187150741.1 432608 g250071 i0 74.6 1.98876404494382 59 15 99.4 0 177 1 270 328 WP_187150741.1 phage DNA encapsidation protein [Candidatus Mycoplasma haematobovis] diamond 354 98.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
26926343 26926343 PRJNA753151_S_NODE_137402_length_247_cov_2.014706_g135112_i0 PRJNA753151 137402 247 2.014706 4.97632382 Mycoplasma wenyonii 65123 Bacteria Bacteria 53.1 7.6e-6   NR WP_014849900.1 65123 g135112 i0 50 0.631578947368421 52 26 63.2 0 40 195 240 291 WP_014849900.1 hypothetical protein [Mycoplasma wenyonii] diamond 156 53.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27347414 27347414 PRJNA753151_S_NODE_99783_length_283_cov_2.187500_g97493_i0 PRJNA753151 99783 283 2.1875 6.190625 Mycoplasma 2093 Bacteria Bacteria 50.1 1.51e-4   NR WP_146737539.1 65123 g97493 i0 100 0.720848056537102 24 0 25.4 0 73 2 1 24 WP_146737539.1 hypothetical protein [Mycoplasma wenyonii] diamond 204 50.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27685035 27685035 PRJNA753151_S_NODE_283384_length_166_cov_1.308943_g281094_i0 PRJNA753151 283384 166 1.308943 2.17284538 Mycoplasma wenyonii 65123 Bacteria Bacteria 100 3.45e-23   NR WP_112665355.1 65123 g281094 i0 98.1 0.975903614457831 54 1 97.6 0 164 3 38 91 WP_112665355.1 ribosome biogenesis GTPase Der [Mycoplasma wenyonii] diamond 162 100 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27716673 27716673 PRJNA753151_S_NODE_192124_length_209_cov_1.530120_g189834_i0 PRJNA753151 192124 209 1.53012 3.1979508 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 50.4 4.26e-5   NR WP_187149649.1 432608 g189834 i0 44.9 0.990430622009569 69 38 99 0 3 209 59 127 WP_187149649.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 207 50.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27874149 27874149 PRJNA753151_S_NODE_278165_length_168_cov_1.256000_g275875_i0 PRJNA753151 278165 168 1.256 2.11008 Mycoplasma ovis 171632 Bacteria Bacteria 65.9 9.66e-11   NR WP_024070861.1 171632 g275875 i0 68.8 0.857142857142857 48 15 85.7 0 22 165 227 274 WP_024070861.1 hypothetical protein [Mycoplasma ovis] diamond 144 65.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
27937426 27937426 PRJNA753151_S_NODE_196785_length_206_cov_2.208589_g194495_i0 PRJNA753151 196785 206 2.208589 4.54969334 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 85.1 2.74e-17   NR WP_187150752.1 432608 g194495 i0 64.1 1.9368932038835 64 23 93.2 0 205 14 273 336 WP_187150752.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 399 85.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28221317 28221317 PRJNA753151_S_NODE_296806_length_161_cov_1.525424_g294516_i0 PRJNA753151 296806 161 1.525424 2.45593264 Mycoplasma wenyonii 65123 Bacteria Bacteria 87.8 1.01e-18   NR WP_112664929.1 65123 g294516 i0 84.6 0.968944099378882 52 8 96.9 0 4 159 78 129 WP_112664929.1 YitT family protein [Mycoplasma wenyonii] diamond 156 87.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28600477 28600477 PRJNA753151_S_NODE_330527_length_150_cov_1.682243_g328237_i0 PRJNA753151 330527 150 1.682243 2.5233645 Mycoplasma wenyonii 65123 Bacteria Bacteria 89.4 3.88e-19   NR WP_112664949.1 65123 g328237 i0 100 0.98 49 0 98 0 3 149 684 732 WP_112664949.1 ATP-dependent zinc metalloprotease FtsH [Mycoplasma wenyonii] diamond 147 89.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28884449 28884449 PRJNA753151_S_NODE_105308_length_277_cov_1.730769_g103018_i0 PRJNA753151 105308 277 1.730769 4.79423013 Mycoplasma wenyonii 65123 Bacteria Bacteria 48.5 8.69e-5   NR WP_014849827.1 65123 g103018 i0 46 0.682310469314079 63 31 66.1 3 199 17 12 73 WP_014849827.1 hypothetical protein [Mycoplasma wenyonii] diamond 189 48.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28915842 28915842 PRJNA753151_S_NODE_172088_length_221_cov_3.707865_g169798_i0 PRJNA753151 172088 221 3.707865 8.19438165 Mycoplasma wenyonii 65123 Bacteria Bacteria 134 7.08e-36   NR WP_112665152.1 65123 g169798 i0 91.8 0.990950226244344 73 6 99.1 0 219 1 278 350 WP_112665152.1 DUF1967 domain-containing protein [Mycoplasma wenyonii] diamond 219 134 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29294987 29294987 PRJNA753151_S_NODE_321849_length_153_cov_1.227273_g319559_i0 PRJNA753151 321849 153 1.227273 1.87772769 Mycoplasma wenyonii 65123 Bacteria Bacteria 49.3 5.2e-5   NR WP_112664964.1 65123 g319559 i0 68.6 0.686274509803922 35 11 68.6 0 3 107 362 396 WP_112664964.1 ABC transporter [Mycoplasma wenyonii] diamond 105 49.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29494293 29494293 PRJNA753151_S_NODE_304250_length_158_cov_2.739130_g301960_i0 PRJNA753151 304250 158 2.73913 4.3278254 Mycoplasma 2093 Bacteria Bacteria 107 1.22e-26   NR WP_309250883.1 65123 g301960 i0 96.2 1.9746835443038 52 2 98.7 0 1 156 48 99 WP_309250883.1 ATP-binding cassette domain-containing protein [Mycoplasma wenyonii] diamond 312 107 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29768505 29768505 PRJNA753151_S_NODE_302671_length_159_cov_1.551724_g300381_i0 PRJNA753151 302671 159 1.551724 2.46724116 Mycoplasma wenyonii 65123 Bacteria Bacteria 81.3 2.66e-16   NR WP_258393886.1 65123 g300381 i0 100 0.716981132075472 38 0 71.7 0 29 142 328 365 WP_258393886.1 histidine--tRNA ligase [Mycoplasma wenyonii] diamond 114 81.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30084361 30084361 PRJNA753151_S_NODE_324712_length_152_cov_1.238532_g322422_i0 PRJNA753151 324712 152 1.238532 1.88256864 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 97.4 3.94e-24   NR WP_187149860.1 432608 g322422 i0 96 0.986842105263158 50 2 98.7 0 1 150 76 125 WP_187149860.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 150 97.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30094175 30094175 PRJNA753151_S_NODE_125652_length_257_cov_2.102804_g123362_i0 PRJNA753151 125652 257 2.102804 5.40420628 Mycoplasma 2093 Bacteria Bacteria 168 5.479999999999998e-48   NR WP_014849859.1 65123 g123362 i0 96.5 1.98443579766537 85 3 99.2 0 257 3 347 431 WP_014849859.1 preprotein translocase subunit SecY [Mycoplasma wenyonii] diamond 510 168 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30179156 30179156 PRJNA753151_S_NODE_305272_length_158_cov_1.739130_g302982_i0 PRJNA753151 305272 158 1.73913 2.7478254 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 99 7.929999999999999e-23   NR WP_187150033.1 432608 g302982 i0 98 0.968354430379747 51 1 96.8 0 157 5 317 367 WP_187150033.1 serine hydroxymethyltransferase [Candidatus Mycoplasma haematobovis] diamond 153 99 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30400925 30400925 PRJNA753151_S_NODE_226093_length_190_cov_2.755102_g223803_i0 PRJNA753151 226093 190 2.755102 5.2346938 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 129 8.71e-35   NR WP_187149954.1 432608 g223803 i0 100 0.994736842105263 63 0 99.5 0 189 1 80 142 WP_187149954.1 deoxyribonuclease IV [Candidatus Mycoplasma haematobovis] diamond 189 129 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30589934 30589934 PRJNA753151_S_NODE_127873_length_255_cov_2.334906_g125583_i0 PRJNA753151 127873 255 2.334906 5.9540103 Mycoplasma wenyonii 65123 Bacteria Bacteria 134 2.84e-34   NR WP_112665122.1 65123 g125583 i0 98.5 0.776470588235294 66 1 77.6 0 19 216 474 539 WP_112665122.1 DUF3713 domain-containing protein [Mycoplasma wenyonii] diamond 198 134 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30589936 30589936 PRJNA753151_S_NODE_179853_length_216_cov_3.843931_g177563_i0 PRJNA753151 179853 216 3.843931 8.30289096 Mycoplasma wenyonii 65123 Bacteria Bacteria 127 1.4099999999999998e-32   NR WP_181454128.1 65123 g177563 i0 81.7 1.97222222222222 71 13 98.6 0 215 3 286 356 WP_181454128.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase [Mycoplasma wenyonii] diamond 426 127 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30621493 30621493 PRJNA753151_S_NODE_290773_length_163_cov_1.875000_g288483_i0 PRJNA753151 290773 163 1.875 3.05625 Mycoplasma ovis 171632 Bacteria Bacteria 100 4.169999999999999e-23   NR WP_024071516.1 171632 g288483 i0 85.2 0.993865030674847 54 8 99.4 0 162 1 303 356 WP_024071516.1 DNA gyrase/topoisomerase IV subunit B [Mycoplasma ovis] diamond 162 100 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
30842873 30842873 PRJNA753151_S_NODE_232614_length_187_cov_1.902778_g230324_i0 PRJNA753151 232614 187 1.902778 3.55819486 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 127 3.7799999999999996e-34   NR WP_187150208.1 432608 g230324 i0 100 1.98930481283422 62 0 99.5 0 187 2 180 241 WP_187150208.1 50S ribosomal protein L2 [Candidatus Mycoplasma haematobovis] diamond 372 127 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31253549 31253549 PRJNA753151_S_NODE_234675_length_186_cov_1.965035_g232385_i0 PRJNA753151 234675 186 1.965035 3.6549651 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 68.9 9.95e-12   NR WP_187150752.1 432608 g232385 i0 65.5 0.935483870967742 58 19 93.5 1 178 5 282 338 WP_187150752.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 174 68.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31285105 31285105 PRJNA753151_S_NODE_316675_length_154_cov_2.432432_g314385_i0 PRJNA753151 316675 154 2.432432 3.74594528 Mycoplasma wenyonii 65123 Bacteria Bacteria 93.2 8.56e-21   NR WP_112665935.1 65123 g314385 i0 90 0.974025974025974 50 5 97.4 0 2 151 58 107 WP_112665935.1 restriction endonuclease subunit S, partial [Mycoplasma wenyonii] diamond 150 93.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31664632 31664632 PRJNA753151_S_NODE_193057_length_208_cov_3.000000_g190767_i0 PRJNA753151 193057 208 3 6.24 Mycoplasma wenyonii 65123 Bacteria Bacteria 47.4 5.39e-4   NR WP_014850145.1 65123 g190767 i0 55.9 0.490384615384615 34 15 49 0 108 7 150 183 WP_014850145.1 hypothetical protein [Mycoplasma wenyonii] diamond 102 47.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31664633 31664633 PRJNA753151_S_NODE_224357_length_191_cov_2.432432_g222067_i0 PRJNA753151 224357 191 2.432432 4.64594512 Mycoplasma wenyonii 65123 Bacteria Bacteria 106 3.87e-25   NR WP_112665355.1 65123 g222067 i0 92.9 0.879581151832461 56 4 88 0 189 22 283 338 WP_112665355.1 ribosome biogenesis GTPase Der [Mycoplasma wenyonii] diamond 168 106 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31727916 31727916 PRJNA753151_S_NODE_206357_length_201_cov_1.139241_g204067_i0 PRJNA753151 206357 201 1.139241 2.28987441 Mycoplasma wenyonii 65123 Bacteria Bacteria 56.2 1.78e-7   NR WP_112665718.1 65123 g204067 i0 100 0.447761194029851 30 0 44.8 0 90 1 1 30 WP_112665718.1 hypothetical protein [Mycoplasma wenyonii] diamond 90 56.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31759619 31759619 PRJNA753151_S_NODE_231077_length_188_cov_1.427586_g228787_i0 PRJNA753151 231077 188 1.427586 2.68386168 Mycoplasma wenyonii 65123 Bacteria Bacteria 115 1.03e-28   NR WP_112665355.1 65123 g228787 i0 95.2 0.98936170212766 62 3 98.9 0 1 186 84 145 WP_112665355.1 ribosome biogenesis GTPase Der [Mycoplasma wenyonii] diamond 186 115 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31917816 31917816 PRJNA753151_S_NODE_270377_length_171_cov_1.210938_g268087_i0 PRJNA753151 270377 171 1.210938 2.0707039800000002 Mycoplasma wenyonii 65123 Bacteria Bacteria 77.4 2.35e-15   NR WP_112665333.1 65123 g268087 i0 82.6 0.807017543859649 46 7 78.9 1 1 135 212 257 WP_112665333.1 hypothetical protein [Mycoplasma wenyonii] diamond 138 77.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32519257 32519257 PRJNA753151_S_NODE_213139_length_197_cov_2.045455_g210849_i0 PRJNA753151 213139 197 2.045455 4.02954635 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 69.3 2.8e-12   NR WP_187149964.1 432608 g210849 i0 100 0.563451776649746 37 0 56.3 0 197 87 199 235 WP_187149964.1 purine-nucleoside phosphorylase [Candidatus Mycoplasma haematobovis] diamond 111 69.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
32582363 32582363 PRJNA753151_S_NODE_299179_length_160_cov_1.923077_g296889_i0 PRJNA753151 299179 160 1.923077 3.0769232 Mycoplasma wenyonii 65123 Bacteria Bacteria 92 3.01e-20   NR WP_112664946.1 65123 g296889 i0 100 1.6875 45 0 84.4 0 2 136 311 355 WP_112664946.1 YidC/Oxa1 family membrane protein insertase [Mycoplasma wenyonii] diamond 270 92 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);;