RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJEB28589" 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

  • PRJEB28589 · 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
2263314 2263314 PRJEB28589_S_NODE_12082_length_220_cov_0.884393_g11974_i0 PRJEB28589 12082 220 0.884393 1.9456646 Mycoplasma wenyonii 65123 Bacteria Bacteria 140 3.31e-40   NR WP_112664966.1 65123 g11974 i0 98.6 0.981818181818182 72 1 98.2 0 3 218 1 72 WP_112664966.1 restriction endonuclease PLD domain-containing protein [Mycoplasma wenyonii] diamond 216 140 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
5128344 5128344 PRJEB28589_S_NODE_15745_length_181_cov_1.500000_g15637_i0 PRJEB28589 15745 181 1.5 2.715 Mycoplasma wenyonii 65123 Bacteria Bacteria 106 4.93e-25   NR WP_112664926.1 65123 g15637 i0 100 0.845303867403315 51 0 84.5 0 155 3 56 106 WP_112664926.1 DNA gyrase/topoisomerase IV subunit A [Mycoplasma wenyonii] diamond 153 106 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
19151486 19151486 PRJEB28589_S_NODE_15496_length_183_cov_1.125000_g15388_i0 PRJEB28589 15496 183 1.125 2.05875 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 98.2 2.44e-22   NR WP_187149828.1 432608 g15388 i0 98.1 0.852459016393443 52 1 85.2 0 26 181 337 388 WP_187149828.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 156 98.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
19151510 19151510 PRJEB28589_S_NODE_3116_length_366_cov_2.780564_g3008_i0 PRJEB28589 3116 366 2.780564 10.17686424 Mycoplasma wenyonii 65123 Bacteria Bacteria 178 1.29e-50   NR WP_112665563.1 65123 g3008 i0 82.4 0.885245901639344 108 19 88.5 0 365 42 137 244 WP_112665563.1 type I restriction-modification system subunit M [Mycoplasma wenyonii] diamond 324 178 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
26906679 26906679 PRJEB28589_S_NODE_13982_length_198_cov_1.013245_g13874_i0 PRJEB28589 13982 198 1.013245 2.0062251 Mycoplasma wenyonii 65123 Bacteria Bacteria 68.2 1.53e-11   NR WP_014849900.1 65123 g13874 i0 56.1 0.863636363636364 57 25 86.4 0 28 198 239 295 WP_014849900.1 hypothetical protein [Mycoplasma wenyonii] diamond 171 68.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27033190 27033190 PRJEB28589_S_NODE_7382_length_287_cov_1.275000_g7274_i0 PRJEB28589 7382 287 1.275 3.65925 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 85.9 9.17e-18   NR WP_187150242.1 432608 g7274 i0 100 0.439024390243902 42 0 43.9 0 41 166 232 273 WP_187150242.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 126 85.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27381093 27381093 PRJEB28589_S_NODE_6963_length_293_cov_5.479675_g6855_i0 PRJEB28589 6963 293 5.479675 16.05544775 Mycoplasma wenyonii 65123 Bacteria Bacteria 126 1.82e-32   NR WP_112665897.1 65123 g6855 i0 64.9 0.962457337883959 94 33 96.2 0 293 12 227 320 WP_112665897.1 restriction endonuclease subunit S [Mycoplasma wenyonii] diamond 282 126 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27570316 27570316 PRJEB28589_S_NODE_5384_length_318_cov_2.881919_g5276_i0 PRJEB28589 5384 318 2.881919 9.16450242 Mycoplasma wenyonii 65123 Bacteria Bacteria 167 6.619999999999999e-47   NR WP_014849923.1 65123 g5276 i0 80.2 1 106 21 100 0 1 318 138 243 WP_014849923.1 potassium transporter TrkG [Mycoplasma wenyonii] diamond 318 167 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27917571 27917571 PRJEB28589_S_NODE_2805_length_375_cov_15.408537_g2697_i0 PRJEB28589 2805 375 15.408537 57.78201375 Mycoplasma wenyonii 65123 Bacteria Bacteria 58.2 3.52e-7   NR WP_112664969.1 65123 g2697 i0 60 1.168 50 19 40 1 83 232 4 52 WP_112664969.1 hypothetical protein [Mycoplasma wenyonii] diamond 438 58.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28296456 28296456 PRJEB28589_S_NODE_16586_length_173_cov_1.619048_g16478_i0 PRJEB28589 16586 173 1.619048 2.80095304 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 68.6 1.16e-12   NR WP_187150597.1 432608 g16478 i0 100 0.554913294797688 32 0 55.5 0 171 76 130 161 WP_187150597.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 96 68.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28359574 28359574 PRJEB28589_S_NODE_1906_length_419_cov_5.879032_g1798_i0 PRJEB28589 1906 419 5.879032 24.63314408 Mycoplasma ovis 171632 Bacteria Bacteria 45.8 0.0169   NR WP_084289611.1 171632 g1798 i0 42.5 0.522673031026253 73 39 51.6 2 87 302 31 101 WP_084289611.1 CPBP family intramembrane glutamic endopeptidase [Mycoplasma ovis] diamond 219 45.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
28454638 28454638 PRJEB28589_S_NODE_4586_length_334_cov_2.149826_g4478_i0 PRJEB28589 4586 334 2.149826 7.18041884 Mycoplasma wenyonii 65123 Bacteria Bacteria 151 1.1999999999999999e-41   NR WP_112665897.1 65123 g4478 i0 71.8 1.84131736526946 103 29 92.5 0 310 2 197 299 WP_112665897.1 restriction endonuclease subunit S [Mycoplasma wenyonii] diamond 615 151 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28517669 28517669 PRJEB28589_S_NODE_6387_length_302_cov_5.039216_g6279_i0 PRJEB28589 6387 302 5.039216 15.21843232 Mycoplasma wenyonii 65123 Bacteria Bacteria 112 1.73e-26   NR WP_112664927.1 65123 g6279 i0 100 0.536423841059603 54 0 53.6 0 202 41 179 232 WP_112664927.1 DNA gyrase/topoisomerase IV subunit B [Mycoplasma wenyonii] diamond 162 112 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28580858 28580858 PRJEB28589_S_NODE_9007_length_262_cov_2.134884_g8899_i0 PRJEB28589 9007 262 2.134884 5.59339608 Mycoplasma wenyonii 65123 Bacteria Bacteria 126 2.1e-31   NR WP_112665086.1 65123 g8899 i0 98.5 0.744274809160305 65 1 74.4 0 261 67 751 815 WP_112665086.1 hypothetical protein [Mycoplasma wenyonii] diamond 195 126 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28896369 28896369 PRJEB28589_S_NODE_8848_length_264_cov_5.497696_g8740_i0 PRJEB28589 8848 264 5.497696 14.51391744 Mycoplasma wenyonii 65123 Bacteria Bacteria 131 1.7e-34   NR WP_112665935.1 65123 g8740 i0 73.8 0.954545454545455 84 22 95.5 0 10 261 227 310 WP_112665935.1 restriction endonuclease subunit S, partial [Mycoplasma wenyonii] diamond 252 131 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29023135 29023135 PRJEB28589_S_NODE_7288_length_288_cov_4.979253_g7180_i0 PRJEB28589 7288 288 4.979253 14.34024864 Mycoplasma wenyonii 65123 Bacteria Bacteria 129 2e-35   NR WP_112665639.1 65123 g7180 i0 100 0.666666666666667 64 0 66.7 0 288 97 93 156 WP_112665639.1 hypothetical protein [Mycoplasma wenyonii] diamond 192 129 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29559415 29559415 PRJEB28589_S_NODE_14030_length_197_cov_2.220000_g13922_i0 PRJEB28589 14030 197 2.22 4.3734 Mycoplasma wenyonii 65123 Bacteria Bacteria 122 1.73e-32   NR WP_112665004.1 65123 g13922 i0 96.6 0.898477157360406 59 2 89.8 0 19 195 58 116 WP_112665004.1 hypothetical protein [Mycoplasma wenyonii] diamond 177 122 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29748696 29748696 PRJEB28589_S_NODE_14411_length_193_cov_2.095890_g14303_i0 PRJEB28589 14411 193 2.09589 4.0450677 Mycoplasma wenyonii 65123 Bacteria Bacteria 46.2 0.00118   NR WP_014850159.1 65123 g14303 i0 54.1 0.575129533678757 37 17 57.5 0 83 193 343 379 WP_014850159.1 DUF3713 domain-containing protein [Mycoplasma wenyonii] diamond 111 46.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29875376 29875376 PRJEB28589_S_NODE_5811_length_311_cov_2.109848_g5703_i0 PRJEB28589 5811 311 2.109848 6.56162728 Mycoplasma wenyonii 65123 Bacteria Bacteria 173 6.06e-49   NR WP_258393903.1 65123 g5703 i0 96.8 0.906752411575563 94 3 90.7 0 285 4 396 489 WP_258393903.1 glutamyl-tRNA amidotransferase [Mycoplasma wenyonii] diamond 282 173 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29938570 29938570 PRJEB28589_S_NODE_9411_length_256_cov_5.598086_g9303_i0 PRJEB28589 9411 256 5.598086 14.33110016 Mycoplasma wenyonii 65123 Bacteria Bacteria 162 6.799999999999998e-48   NR WP_112665235.1 65123 g9303 i0 100 0.99609375 85 0 99.6 0 1 255 150 234 WP_112665235.1 PhoU domain-containing protein [Mycoplasma wenyonii] diamond 255 162 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29970016 29970016 PRJEB28589_S_NODE_3931_length_346_cov_4.588629_g3823_i0 PRJEB28589 3931 346 4.588629 15.87665634 Mycoplasma wenyonii 65123 Bacteria Bacteria 71.6 5.18e-12   NR WP_112665015.1 65123 g3823 i0 78.7 0.407514450867052 47 10 40.8 0 236 96 44 90 WP_112665015.1 hypothetical protein [Mycoplasma wenyonii] diamond 141 71.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30791520 30791520 PRJEB28589_S_NODE_16834_length_171_cov_1.645161_g16726_i0 PRJEB28589 16834 171 1.645161 2.81322531 Mycoplasma wenyonii 65123 Bacteria Bacteria 115 2.79e-28   NR WP_258393864.1 65123 g16726 i0 100 0.982456140350877 56 0 98.2 0 3 170 404 459 WP_258393864.1 phosphoglucomutase [Mycoplasma wenyonii] diamond 168 115 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31233719 31233719 PRJEB28589_S_NODE_18015_length_163_cov_1.318966_g17907_i0 PRJEB28589 18015 163 1.318966 2.14991458 Mycoplasma wenyonii 65123 Bacteria Bacteria 99.8 3.519999999999999e-23   NR RAO95282.1 65123 g17907 i0 98.1 0.975460122699387 53 1 97.5 0 3 161 27 79 RAO95282.1 helicase DnaB [Mycoplasma wenyonii] diamond 159 99.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31898132 31898132 PRJEB28589_S_NODE_13137_length_207_cov_1.450000_g13029_i0 PRJEB28589 13137 207 1.45 3.0015 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 149 5.3e-42   NR WP_187150160.1 432608 g13029 i0 100 1 69 0 100 0 207 1 110 178 WP_187150160.1 DnaJ domain-containing protein [Candidatus Mycoplasma haematobovis] diamond 207 149 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
32024755 32024755 PRJEB28589_S_NODE_17438_length_166_cov_2.352941_g17330_i0 PRJEB28589 17438 166 2.352941 3.90588206 Mycoplasma wenyonii 65123 Bacteria Bacteria 68.6 8.83e-12   NR WP_014850008.1 65123 g17330 i0 64.2 0.957831325301205 53 19 95.8 0 3 161 204 256 WP_014850008.1 hypothetical protein [Mycoplasma wenyonii] diamond 159 68.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32024757 32024757 PRJEB28589_S_NODE_4918_length_327_cov_2.528571_g4810_i0 PRJEB28589 4918 327 2.528571 8.26842717 Mycoplasma wenyonii 65123 Bacteria Bacteria 144 8.91e-39   NR WP_112664912.1 65123 g4810 i0 98.6 0.678899082568807 74 1 67.9 0 223 2 331 404 WP_112664912.1 hypothetical protein [Mycoplasma wenyonii] diamond 222 144 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32087978 32087978 PRJEB28589_S_NODE_11478_length_228_cov_1.784530_g11370_i0 PRJEB28589 11478 228 1.78453 4.0687284 Mycoplasma wenyonii 65123 Bacteria Bacteria 112 1.3600000000000002e-27   NR WP_112665764.1 65123 g11370 i0 100 0.763157894736842 58 0 76.3 0 226 53 303 360 WP_112665764.1 DnaJ domain-containing protein [Mycoplasma wenyonii] diamond 174 112 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32183022 32183022 PRJEB28589_S_NODE_16978_length_170_cov_1.243902_g16870_i0 PRJEB28589 16978 170 1.243902 2.1146334 Mycoplasma wenyonii 65123 Bacteria Bacteria 50.8 1.32e-5   NR WP_014849925.1 65123 g16870 i0 57.1 0.864705882352941 49 20 86.5 1 18 164 113 160 WP_014849925.1 hypothetical protein [Mycoplasma wenyonii] diamond 147 50.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32436308 32436308 PRJEB28589_S_NODE_3159_length_364_cov_12.148265_g3051_i0 PRJEB28589 3159 364 12.148265 44.2196846 Mycoplasma wenyonii 65123 Bacteria Bacteria 74.3 7.39e-14   NR WP_148268015.1 65123 g3051 i0 84.1 0.362637362637363 44 7 36.3 0 288 157 55 98 WP_148268015.1 hypothetical protein [Mycoplasma wenyonii] diamond 132 74.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32782864 32782864 PRJEB28589_S_NODE_8580_length_268_cov_3.230769_g8472_i0 PRJEB28589 8580 268 3.230769 8.65846092 Mycoplasma wenyonii 65123 Bacteria Bacteria 65.5 3.88e-10   NR WP_014849787.1 65123 g8472 i0 54.5 2.14925373134328 66 30 73.9 0 12 209 4 69 WP_014849787.1 hypothetical protein [Mycoplasma wenyonii] diamond 576 65.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32814468 32814468 PRJEB28589_S_NODE_4220_length_341_cov_3.404762_g4112_i0 PRJEB28589 4220 341 3.404762 11.61023842 Mycoplasma wenyonii 65123 Bacteria Bacteria 202 5.5e-61   NR WP_258393866.1 65123 g4112 i0 100 0.932551319648094 106 0 93.3 0 340 23 270 375 WP_258393866.1 signal recognition particle receptor subunit alpha [Mycoplasma wenyonii] diamond 318 202 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);;