RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA798905" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA798905 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
7170622 7170622 PRJNA798905_S_NODE_37986_length_245_cov_4.587209_g37537_i0 PRJNA798905 37986 245 4.587209 11.23866205 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 169 3.78e-49   NR WP_187150031.1 432608 g37537 i0 100 0.991836734693878 81 0 99.2 0 2 244 60 140 WP_187150031.1 HD domain-containing protein [Candidatus Mycoplasma haematobovis] diamond 243 169 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
10996035 10996035 PRJNA798905_S_NODE_28029_length_285_cov_6.665094_g27580_i0 PRJNA798905 28029 285 6.665094 18.9955179 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 172 4.42e-51   NR WP_187150162.1 432608 g27580 i0 88.4 1 95 11 100 0 1 285 149 243 WP_187150162.1 class II fructose-1,6-bisphosphate aldolase [Candidatus Mycoplasma haematobovis] diamond 285 172 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
26610598 26610598 PRJNA798905_S_NODE_15621_length_368_cov_3.132203_g15172_i0 PRJNA798905 15621 368 3.132203 11.52650704 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 182 5.919999999999999e-53   NR WP_187150753.1 432608 g15172 i0 85.4 0.839673913043478 103 15 84 0 3 311 81 183 WP_187150753.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 309 182 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
26642368 26642368 PRJNA798905_S_NODE_12061_length_406_cov_3.534535_g11612_i0 PRJNA798905 12061 406 3.534535 14.3502121 Mycoplasma wenyonii 65123 Bacteria Bacteria 58.2 7.95e-7   NR WP_112665897.1 65123 g11612 i0 69.4 0.532019704433498 36 11 26.6 0 297 404 199 234 WP_112665897.1 restriction endonuclease subunit S [Mycoplasma wenyonii] diamond 216 58.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27180152 27180152 PRJNA798905_S_NODE_18042_length_347_cov_4.587591_g17593_i0 PRJNA798905 18042 347 4.587591 15.91894077 Mycoplasma wenyonii 65123 Bacteria Bacteria 206 1.8299999999999999e-62   NR WP_112665355.1 65123 g17593 i0 93.9 0.985590778097983 114 7 98.6 0 342 1 55 168 WP_112665355.1 ribosome biogenesis GTPase Der [Mycoplasma wenyonii] diamond 342 206 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27306979 27306979 PRJNA798905_S_NODE_5943_length_548_cov_6.911579_g5495_i0 PRJNA798905 5943 548 6.911579 37.87545292 Mycoplasma wenyonii 65123 Bacteria Bacteria 92.8 7.71e-20   NR WP_112665921.1 65123 g5495 i0 78.5 0.355839416058394 65 14 35.6 0 171 365 1 65 WP_112665921.1 hypothetical protein [Mycoplasma wenyonii] diamond 195 92.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27433442 27433442 PRJNA798905_S_NODE_37963_length_245_cov_5.959302_g37514_i0 PRJNA798905 37963 245 5.959302 14.6002899 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 108 4.85e-29   NR WP_187149636.1 432608 g37514 i0 92.5 0.648979591836735 53 4 64.9 0 45 203 11 63 WP_187149636.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 159 108 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27622830 27622830 PRJNA798905_S_NODE_10344_length_431_cov_3.385475_g9895_i0 PRJNA798905 10344 431 3.385475 14.59139725 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 188 8.989999999999996e-55   NR WP_187150548.1 432608 g9895 i0 98 0.682134570765661 98 2 68.2 0 137 430 114 211 WP_187150548.1 phosphate ABC transporter permease [Candidatus Mycoplasma haematobovis] diamond 294 188 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
27686138 27686138 PRJNA798905_S_NODE_19764_length_334_cov_2.977011_g19315_i0 PRJNA798905 19764 334 2.977011 9.94321674 Mycoplasma wenyonii 65123 Bacteria Bacteria 105 7.53e-24   NR WP_112665597.1 65123 g19315 i0 87.3 0.565868263473054 63 8 56.6 0 293 105 26 88 WP_112665597.1 iron-containing alcohol dehydrogenase [Mycoplasma wenyonii] diamond 189 105 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27780666 27780666 PRJNA798905_S_NODE_34944_length_254_cov_1.812155_g34495_i0 PRJNA798905 34944 254 1.812155 4.6028737 Mycoplasma wenyonii 65123 Bacteria Bacteria 123 8.619999999999999e-31   NR WP_112665837.1 65123 g34495 i0 89.2 0.767716535433071 65 7 76.8 0 196 2 367 431 WP_112665837.1 MIP family Ig-specific serine endopeptidase [Mycoplasma wenyonii] diamond 195 123 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28033261 28033261 PRJNA798905_S_NODE_22745_length_315_cov_1.272727_g22296_i0 PRJNA798905 22745 315 1.272727 4.00909005 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 98.6 7.700000000000001e-23   NR WP_187149938.1 432608 g22296 i0 72.3 0.619047619047619 65 18 61.9 0 315 121 100 164 WP_187149938.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 195 98.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28096265 28096265 PRJNA798905_S_NODE_39245_length_242_cov_4.757396_g38796_i0 PRJNA798905 39245 242 4.757396 11.51289832 Mycoplasmopsis arginini 2094 Bacteria Bacteria 124 5.47e-31   NR WP_206602619.1 2094 g38796 i0 87.5 1.78512396694215 72 9 89.3 0 229 14 483 554 WP_206602619.1 cbb3-type cytochrome c oxidase subunit I [Mycoplasmopsis arginini] diamond 432 124 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28538528 28538528 PRJNA798905_S_NODE_22887_length_314_cov_1.788382_g22438_i0 PRJNA798905 22887 314 1.788382 5.61551948 Mycoplasma wenyonii 65123 Bacteria Bacteria 42.4 0.0342   NR WP_112665829.1 65123 g22438 i0 47.2 0.506369426751592 53 28 50.6 0 5 163 60 112 WP_112665829.1 hypothetical protein [Mycoplasma wenyonii] diamond 159 42.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29296065 29296065 PRJNA798905_S_NODE_36409_length_249_cov_3.312500_g35960_i0 PRJNA798905 36409 249 3.3125 8.248125 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 144 1.37e-38   NR WP_187150607.1 432608 g35960 i0 98.6 0.867469879518072 72 1 86.7 0 1 216 407 478 WP_187150607.1 arginine--tRNA ligase [Candidatus Mycoplasma haematobovis] diamond 216 144 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
29485261 29485261 PRJNA798905_S_NODE_34490_length_256_cov_1.262295_g34041_i0 PRJNA798905 34490 256 1.262295 3.2314752 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 116 1.94e-28   NR WP_187150741.1 432608 g34041 i0 66.3 1.93359375 83 27 96.1 1 1 246 68 150 WP_187150741.1 phage DNA encapsidation protein [Candidatus Mycoplasma haematobovis] diamond 495 116 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
29548488 29548488 PRJNA798905_S_NODE_28870_length_281_cov_3.500000_g28421_i0 PRJNA798905 28870 281 3.5 9.835 Haloplasmataceae bacterium 2862752 Bacteria Bacteria 54.7 3.59e-6   NR MDF2700953.1 2862752 g28421 i0 40.8 0.758007117437722 71 36 75.8 2 243 31 330 394 MDF2700953.1 hypothetical protein [Haloplasmataceae bacterium] diamond 213 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Haloplasmatales Haloplasmataceae   Haloplasmataceae bacterium
30053806 30053806 PRJNA798905_S_NODE_19551_length_335_cov_6.041985_g19102_i0 PRJNA798905 19551 335 6.041985 20.24064975 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 74.7 1.32e-14   NR WP_187149771.1 432608 g19102 i0 82.9 0.367164179104478 41 7 36.7 0 281 159 5 45 WP_187149771.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 123 74.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30085455 30085455 PRJNA798905_S_NODE_29092_length_280_cov_3.536232_g28643_i0 PRJNA798905 29092 280 3.536232 9.9014496 Mycoplasma wenyonii 65123 Bacteria Bacteria 182 2.6899999999999995e-57   NR RAO95375.1 65123 g28643 i0 98.9 0.996428571428571 93 1 99.6 0 279 1 11 103 RAO95375.1 30S ribosomal protein S6 [Mycoplasma wenyonii] diamond 279 182 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30749073 30749073 PRJNA798905_S_NODE_25654_length_298_cov_2.808889_g25205_i0 PRJNA798905 25654 298 2.808889 8.37048922 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 133 1.24e-33   NR WP_187150740.1 432608 g25205 i0 68.7 1.91275167785235 99 30 98.7 1 296 3 101 199 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 570 133 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30812198 30812198 PRJNA798905_S_NODE_10114_length_434_cov_8.720222_g9665_i0 PRJNA798905 10114 434 8.720222 37.84576348 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 124 1.42e-32   NR WP_187149766.1 432608 g9665 i0 50 0.926267281105991 134 56 85 1 50 418 8 141 WP_187149766.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 402 124 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31286147 31286147 PRJNA798905_S_NODE_13335_length_390_cov_6.063091_g12886_i0 PRJNA798905 13335 390 6.063091 23.6460549 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 78.6 5.23e-14   NR WP_187150739.1 432608 g12886 i0 43.2 0.730769230769231 95 51 73.1 1 101 385 229 320 WP_187150739.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 285 78.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31349678 31349678 PRJNA798905_S_NODE_7316_length_496_cov_5.068558_g6867_i0 PRJNA798905 7316 496 5.068558 25.14004768 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 58.5 6.99e-7   NR WP_187149904.1 432608 g6867 i0 55.3 0.284274193548387 47 21 28.4 0 107 247 91 137 WP_187149904.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 141 58.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31476194 31476194 PRJNA798905_S_NODE_42416_length_228_cov_4.451613_g41967_i0 PRJNA798905 42416 228 4.451613 10.14967764 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 93.2 3.79e-20   NR WP_187150753.1 432608 g41967 i0 64.2 0.881578947368421 67 23 88.2 1 3 203 360 425 WP_187150753.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 201 93.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31982077 31982077 PRJNA798905_S_NODE_12918_length_395_cov_6.590062_g12469_i0 PRJNA798905 12918 395 6.590062 26.0307449 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 114 1.87e-26   NR WP_187150740.1 432608 g12469 i0 75.7 0.531645569620253 70 17 53.2 0 268 59 1152 1221 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 210 114 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
32013836 32013836 PRJNA798905_S_NODE_14458_length_379_cov_5.307190_g14009_i0 PRJNA798905 14458 379 5.30719 20.1142501 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 170 3.87e-48   NR WP_187150088.1 432608 g14009 i0 75.4 1.99472295514512 126 24 99.7 1 2 379 35 153 WP_187150088.1 spermidine/putrescine ABC transporter substrate-binding protein [Candidatus Mycoplasma haematobovis] diamond 756 170 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
32235652 32235652 PRJNA798905_S_NODE_23398_length_310_cov_7.147679_g22949_i0 PRJNA798905 23398 310 7.147679 22.1578049 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 68.9 1.69e-12   NR WP_187149767.1 432608 g22949 i0 89.5 0.367741935483871 38 4 36.8 0 115 2 40 77 WP_187149767.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 114 68.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
32267134 32267134 PRJNA798905_S_NODE_25818_length_297_cov_3.455357_g25369_i0 PRJNA798905 25818 297 3.455357 10.26241029 Mycoplasma wenyonii 65123 Bacteria Bacteria 171 3.98e-51   NR WP_258393900.1 65123 g25369 i0 91.6 0.95959595959596 95 8 96 0 5 289 23 117 WP_258393900.1 F0F1 ATP synthase subunit A [Mycoplasma wenyonii] diamond 285 171 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32488622 32488622 PRJNA798905_S_NODE_26759_length_292_cov_3.009132_g26310_i0 PRJNA798905 26759 292 3.009132 8.78666544 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 166 2.54e-47   NR WP_187150753.1 432608 g26310 i0 82.3 1.97260273972603 96 17 98.6 0 288 1 143 238 WP_187150753.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 576 166 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis

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