RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where bioproject = "PRJNA557436", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 29 ✖

tax_kingdom 1

  • Bacillati · 29 ✖

bioproject 1

  • PRJNA557436 · 29 ✖

analysis 1

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
26730252 26730252 PRJNA557436_S_NODE_8821_length_153_cov_1.771186_g8773_i0 PRJNA557436 8821 153 1.771186 2.70991458 Mycoplasmopsis arginini 2094 Bacteria Bacteria 86.7 7.61e-20   NR WP_282460027.1 2094 g8773 i0 94 0.980392156862745 50 3 98 0 2 151 58 107 WP_282460027.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 150 86.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27205030 27205030 PRJNA557436_S_NODE_6522_length_168_cov_1.631579_g6474_i0 PRJNA557436 6522 168 1.631579 2.74105272 Mycoplasmopsis arginini 2094 Bacteria Bacteria 72.4 4.7e-13   NR WP_282460145.1 2094 g6474 i0 66.7 0.857142857142857 48 16 85.7 0 1 144 361 408 WP_282460145.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 144 72.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27584315 27584315 PRJNA557436_S_NODE_5244_length_181_cov_2.136986_g5196_i0 PRJNA557436 5244 181 2.136986 3.86794466 Mycoplasmopsis arginini 2094 Bacteria Bacteria 78.2 4.52e-15   NR WP_282460143.1 2094 g5196 i0 60.3 0.961325966850829 58 23 96.1 0 180 7 156 213 WP_282460143.1 glycosyltransferase family 9 protein, partial [Mycoplasmopsis arginini] diamond 174 78.2 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27584320 27584320 PRJNA557436_S_NODE_9284_length_151_cov_1.758621_g9236_i0 PRJNA557436 9284 151 1.758621 2.65551771 Mycoplasmopsis arginini 2094 Bacteria Bacteria 85.9 1.11e-19   NR WP_282459942.1 2094 g9236 i0 98 1.96688741721854 50 1 99.3 0 151 2 93 142 WP_282459942.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 297 85.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27711083 27711083 PRJNA557436_S_NODE_1284_length_322_cov_2.501742_g1236_i0 PRJNA557436 1284 322 2.501742 8.05560924 Mycoplasmopsis arginini 2094 Bacteria Bacteria 120 3.47e-32   NR WP_282460024.1 2094 g1236 i0 77.5 0.661490683229814 71 16 66.1 0 110 322 1 71 WP_282460024.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 213 120 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28089460 28089460 PRJNA557436_S_NODE_7345_length_162_cov_1.291339_g7297_i0 PRJNA557436 7345 162 1.291339 2.09196918 Mycoplasmopsis arginini 2094 Bacteria Bacteria 43.9 0.00276   NR WP_282460024.1 2094 g7297 i0 83.3 0.444444444444444 24 4 44.4 0 77 6 1 24 WP_282460024.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 72 43.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28278778 28278778 PRJNA557436_S_NODE_8366_length_155_cov_2.308333_g8318_i0 PRJNA557436 8366 155 2.308333 3.57791615 Mycoplasmopsis arginini 2094 Bacteria Bacteria 95.9 1.88e-23   NR WP_282460027.1 2094 g8318 i0 92.2 0.987096774193548 51 4 98.7 0 154 2 15 65 WP_282460027.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 153 95.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28783988 28783988 PRJNA557436_S_NODE_67_length_1296_cov_2.949247_g54_i0 PRJNA557436 67 1296 2.949247 38.22224112 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 106 1.63e-20   NR MDD5293621.1 3018265 g54 i0 28.7 0.581018518518518 251 167 55.3 4 512 1228 74 324 MDD5293621.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] diamond 753 106 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
28973742 28973742 PRJNA557436_S_NODE_1368_length_314_cov_1.946237_g1320_i0 PRJNA557436 1368 314 1.946237 6.11118418 Mycoplasmopsis arginini 2094 Bacteria Bacteria 176 2.91e-51   NR WP_282460143.1 2094 g1320 i0 76.2 1.0031847133758 105 24 99.4 1 2 313 284 388 WP_282460143.1 glycosyltransferase family 9 protein, partial [Mycoplasmopsis arginini] diamond 315 176 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28973750 28973750 PRJNA557436_S_NODE_4568_length_190_cov_1.593548_g4520_i0 PRJNA557436 4568 190 1.593548 3.0277412 Mycoplasmopsis arginini 2094 Bacteria Bacteria 106 3.26e-25   NR WP_282460145.1 2094 g4520 i0 79.4 0.994736842105263 63 13 99.5 0 190 2 138 200 WP_282460145.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 189 106 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29005597 29005597 PRJNA557436_S_NODE_2408_length_245_cov_1.271429_g2360_i0 PRJNA557436 2408 245 1.271429 3.11500105 Mycoplasmopsis arginini 2094 Bacteria Bacteria 144 7.07e-40   NR MDI3348981.1 2094 g2360 i0 82.7 1.98367346938776 81 14 99.2 0 1 243 57 137 MDI3348981.1 hypothetical protein [Mycoplasmopsis arginini] diamond 486 144 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29036975 29036975 PRJNA557436_S_NODE_2428_length_243_cov_2.990385_g2380_i0 PRJNA557436 2428 243 2.990385 7.26663555 Mycoplasmopsis arginini 2094 Bacteria Bacteria 155 2.58e-46   NR WP_282460024.1 2094 g2380 i0 93.8 1 81 5 100 0 1 243 52 132 WP_282460024.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 243 155 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29082521 29082521 PRJNA557436_S_NODE_2228_length_253_cov_1.555046_g2180_i0 PRJNA557436 2228 253 1.555046 3.93426638 Bacteria 2 Bacteria Bacteria 97.1 7.74e-22   NR MDI3348981.1 2094 g2180 i0 49.5 4.57707509881423 107 30 98.4 1 2 250 174 280 MDI3348981.1 hypothetical protein [Mycoplasmopsis arginini] diamond 1158 97.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29100001 29100001 PRJNA557436_S_NODE_9228_length_151_cov_3.982759_g9180_i0 PRJNA557436 9228 151 3.982759 6.01396609 Mycoplasmopsis arginini 2094 Bacteria Bacteria 105 2.39e-27   NR WP_282460021.1 2094 g9180 i0 100 0.993377483443709 50 0 99.3 0 151 2 63 112 WP_282460021.1 portal protein, partial [Mycoplasmopsis arginini] diamond 150 105 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29398157 29398157 PRJNA557436_S_NODE_9409_length_151_cov_1.051724_g9361_i0 PRJNA557436 9409 151 1.051724 1.58810324 Bacteria 2 Bacteria Bacteria 65.1 1.19e-10   NR MDI3348981.1 2094 g9361 i0 65.2 5.50331125827815 46 16 91.4 0 7 144 140 185 MDI3348981.1 hypothetical protein [Mycoplasmopsis arginini] diamond 831 65.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29604744 29604744 PRJNA557436_S_NODE_7670_length_160_cov_1.160000_g7622_i0 PRJNA557436 7670 160 1.16 1.856 Mycoplasmopsis arginini 2094 Bacteria Bacteria 107 9.17e-28   NR WP_282460021.1 2094 g7622 i0 94.2 0.975 52 3 97.5 0 158 3 20 71 WP_282460021.1 portal protein, partial [Mycoplasmopsis arginini] diamond 156 107 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29952472 29952472 PRJNA557436_S_NODE_6251_length_170_cov_2.192593_g6203_i0 PRJNA557436 6251 170 2.192593 3.7274081 Mycoplasmopsis arginini 2094 Bacteria Bacteria 78.6 3.11e-15   NR WP_282460145.1 2094 g6203 i0 66.1 0.988235294117647 56 19 98.8 0 170 3 345 400 WP_282460145.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 168 78.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30047048 30047048 PRJNA557436_S_NODE_2471_length_241_cov_2.849515_g2423_i0 PRJNA557436 2471 241 2.849515 6.86733115 Mycoplasmopsis arginini 2094 Bacteria Bacteria 114 1.76e-28   NR MDI3348981.1 2094 g2423 i0 68.4 1.89211618257261 76 24 94.6 0 240 13 27 102 MDI3348981.1 hypothetical protein [Mycoplasmopsis arginini] diamond 456 114 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30300441 30300441 PRJNA557436_S_NODE_8052_length_157_cov_1.950820_g8004_i0 PRJNA557436 8052 157 1.95082 3.0627874 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 51.2 6.45e-6   NR MFA5037162.1 3018265 g8004 i0 60 0.668789808917197 35 13 65 1 41 142 140 174 MFA5037162.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] diamond 105 51.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
30363606 30363606 PRJNA557436_S_NODE_2012_length_263_cov_4.508772_g1964_i0 PRJNA557436 2012 263 4.508772 11.85807036 Mycoplasmopsis arginini 2094 Bacteria Bacteria 76.6 1.05e-15   NR WP_282460067.1 2094 g1964 i0 100 0.422053231939163 37 0 42.2 0 152 262 2 38 WP_282460067.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 111 76.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30458376 30458376 PRJNA557436_S_NODE_1533_length_298_cov_1.600760_g1485_i0 PRJNA557436 1533 298 1.60076 4.7702648 Mycoplasmopsis arginini 2094 Bacteria Bacteria 46.2 0.00406   NR WP_282460145.1 2094 g1485 i0 44.2 0.76510067114094 52 23 46.3 1 296 159 393 444 WP_282460145.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 228 46.2 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30774087 30774087 PRJNA557436_S_NODE_1474_length_304_cov_1.713755_g1426_i0 PRJNA557436 1474 304 1.713755 5.2098152 Mycoplasmopsis arginini 2094 Bacteria Bacteria 153 4.19e-42   NR WP_282460145.1 2094 g1426 i0 75.5 0.967105263157895 98 24 96.7 0 296 3 227 324 WP_282460145.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 294 153 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31609985 31609985 PRJNA557436_S_NODE_8776_length_153_cov_2.398305_g8728_i0 PRJNA557436 8776 153 2.398305 3.66940665 Bacillati 1783272 Bacteria Bacteria 43.9 0.00439   NR WP_282460145.1 2094 g8728 i0 81.8 2.03921568627451 22 4 43.1 0 153 88 401 422 WP_282460145.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 312 44.3 0.99097065462754 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31690629 31690629 PRJNA557436_S_NODE_3777_length_204_cov_1.378698_g3729_i0 PRJNA557436 3777 204 1.378698 2.81254392 Mycoplasmopsis arginini 2094 Bacteria Bacteria 113 5.559999999999999e-31   NR MDI3349794.1 2094 g3729 i0 98.2 2.47058823529412 56 1 82.4 0 3 170 6 61 MDI3349794.1 hypothetical protein [Mycoplasmopsis arginini] diamond 504 113 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31785407 31785407 PRJNA557436_S_NODE_477_length_511_cov_2.359244_g430_i0 PRJNA557436 477 511 2.359244 12.05573684 Mycoplasmopsis arginini 2094 Bacteria Bacteria 115 4e-30   NR WP_282460103.1 2094 g430 i0 63.5 0.499021526418787 85 31 49.9 0 18 272 1 85 WP_282460103.1 hypothetical protein [Mycoplasmopsis arginini] diamond 255 115 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31848827 31848827 PRJNA557436_S_NODE_1977_length_266_cov_1.922078_g1929_i0 PRJNA557436 1977 266 1.922078 5.11272748 Mycoplasmopsis arginini 2094 Bacteria Bacteria 135 1.3799999999999999e-38   NR WP_282460024.1 2094 g1929 i0 98.5 0.755639097744361 67 1 75.6 0 61 261 1 67 WP_282460024.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 201 135 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31943617 31943617 PRJNA557436_S_NODE_8237_length_156_cov_1.669421_g8189_i0 PRJNA557436 8237 156 1.669421 2.60429676 Mycoplasmopsis arginini 2094 Bacteria Bacteria 72 1.43e-13   NR WP_282460199.1 2094 g8189 i0 74 0.961538461538462 50 12 96.2 1 153 4 40 88 WP_282460199.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 150 72 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32639247 32639247 PRJNA557436_S_NODE_4920_length_185_cov_1.826667_g4872_i0 PRJNA557436 4920 185 1.826667 3.37933395 Mycoplasmopsis arginini 2094 Bacteria Bacteria 124 1.9199999999999999e-34   NR WP_282457363.1 2094 g4872 i0 100 0.989189189189189 61 0 98.9 0 3 185 74 134 WP_282457363.1 P22 phage major capsid protein family protein, partial [Mycoplasmopsis arginini] diamond 183 124 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32828517 32828517 PRJNA557436_S_NODE_2060_length_261_cov_1.893805_g2012_i0 PRJNA557436 2060 261 1.893805 4.94283105 Mycoplasmopsis arginini 2094 Bacteria Bacteria 137 4.14e-40   NR WP_282460117.1 2094 g2012 i0 95.7 0.793103448275862 69 3 79.3 0 260 54 12 80 WP_282460117.1 ssDNA-binding protein, partial [Mycoplasmopsis arginini] diamond 207 137 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini

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