RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA853194", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 20 ✖

tax_phylum 1

  • Mycoplasmatota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA853194 · 20 ✖

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
3786432 3786432 PRJNA853194_S_NODE_49703_length_308_cov_1.800000_g48612_i0 PRJNA853194 49703 308 1.8 5.544 Spiroplasma 2132 Bacteria Bacteria 52.8 0.029   NTclustered gi|2802839268|emb|OZ181653.1| 3066280 g48612 i0 100 0.282467532467532 28 0 9 0 147 174 956580 956607 Spiroplasma endosymbiont of Rhagonycha fulva isolate 54749 genome assembly, chromosome: 1 blastn 87 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Rhagonycha fulva
5943800 5943800 PRJNA853194_S_NODE_52185_length_301_cov_2.359649_g51094_i0 PRJNA853194 52185 301 2.359649 7.10254349 Spiroplasma endosymbiont of Anurida maritima 2967972 Bacteria Bacteria 56.5 0.002   NTclustered gi|2812212550|gb|CP102059.1| 2967972 g51094 i0 92.5 0.132890365448505 40 2 13 1 67 105 375099 375138 Spiroplasma endosymbiont of Anurida maritima isolate Wells-next-the-Sea chromosome, complete genome blastn 40 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Anurida maritima
5943897 5943897 PRJNA853194_S_NODE_56445_length_291_cov_1.036697_g55354_i0 PRJNA853194 56445 291 1.036697 3.01678827 Mycoplasma wenyonii 65123 Bacteria Bacteria 276 1.47e-69   NTclustered gi|395455868|gb|CP003703.1| 1197325 g55354 i0 83.959 1.00687285223368 293 41 99 4 1 290 247862 247573 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 293 276 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
8493975 8493975 PRJNA853194_S_NODE_76407_length_251_cov_1.376404_g75316_i0 PRJNA853194 76407 251 1.376404 3.45477404 Spiroplasma phoeniceum 47835 Bacteria Bacteria 58.4 4.89e-4   NTclustered gi|1434284537|gb|CP031088.1| 1276259 g75316 i0 97.143 0.139442231075697 35 0 14 1 94 127 1709910 1709944 Spiroplasma phoeniceum P40 chromosome, complete genome blastn 35 58.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma phoeniceum
9767914 9767914 PRJNA853194_S_NODE_17508_length_472_cov_3.746867_g16419_i0 PRJNA853194 17508 472 3.746867 17.68521224 Candidatus Phytoplasma fraxini 35780 Bacteria Bacteria 52.8 0.046   NTclustered gi|2714275034|gb|CP146843.1| 35780 g16419 i0 100 0.0593220338983051 28 0 6 0 412 439 530093 530066 Candidatus Phytoplasma fraxini isolate AshY1 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma fraxini
12320483 12320483 PRJNA853194_S_NODE_87050_length_232_cov_2.421384_g85959_i0 PRJNA853194 87050 232 2.421384 5.61761088 Mycoplasma wenyonii 65123 Bacteria Bacteria 412 8.26e-111   NTclustered gi|395455868|gb|CP003703.1| 1197325 g85959 i0 98.707 1.99568965517241 232 3 100 0 1 232 540265 540496 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 463 412 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
16143250 16143250 PRJNA853194_S_NODE_45613_length_320_cov_1.858300_g44522_i0 PRJNA853194 45613 320 1.8583 5.94656 Mycoplasma wenyonii 65123 Bacteria Bacteria 449 9.11e-122   NTclustered gi|395455868|gb|CP003703.1| 1197325 g44522 i0 91.95 1.009375 323 22 100 4 1 320 581456 581777 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 323 449 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
16143505 16143505 PRJNA853194_S_NODE_58473_length_286_cov_1.446009_g57382_i0 PRJNA853194 58473 286 1.446009 4.13558574 Mycoplasma wenyonii 65123 Bacteria Bacteria 303 6.61e-78   NTclustered gi|395455868|gb|CP003703.1| 1197325 g57382 i0 86.316 0.996503496503496 285 32 97 5 1 278 163601 163317 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 285 303 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
17418721 17418721 PRJNA853194_S_NODE_47414_length_315_cov_1.297521_g46323_i0 PRJNA853194 47414 315 1.297521 4.08719115 Spiroplasma ixodetis 2141 Bacteria Bacteria 52.8 0.029   NTclustered gi|2522717419|gb|CP127039.1| 1276219 g46323 i0 100 0.0888888888888889 28 0 9 0 96 123 1156347 1156320 Spiroplasma ixodetis Y32 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma ixodetis
22517017 22517017 PRJNA853194_S_NODE_36918_length_350_cov_2.368231_g35827_i0 PRJNA853194 36918 350 2.368231 8.2888085 Mycoplasmopsis bovis 28903 Bacteria Bacteria 52.8 0.033   NTclustered gi|1951464263|gb|CP058416.1| 28903 g35827 i0 100 0.08 28 0 8 0 163 190 204913 204940 Mycoplasmopsis bovis strain Mb200 chromosome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
27276375 27276375 PRJNA853194_S_NODE_54683_length_295_cov_1.364865_g53592_i0 PRJNA853194 54683 295 1.364865 4.02635175 Mycoplasma wenyonii 65123 Bacteria Bacteria 113 3.4600000000000003e-29   NR WP_112665591.1 65123 g53592 i0 68.3 0.833898305084746 82 25 82.4 1 265 23 61 142 WP_112665591.1 hypothetical protein [Mycoplasma wenyonii] diamond 246 113 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27339631 27339631 PRJNA853194_S_NODE_48043_length_313_cov_1.283333_g46952_i0 PRJNA853194 48043 313 1.283333 4.01683229 Mycoplasma wenyonii 65123 Bacteria Bacteria 204 1.28e-63   NR WP_112665762.1 65123 g46952 i0 98.1 0.996805111821086 104 2 99.7 0 313 2 113 216 WP_112665762.1 class II fructose-1,6-bisphosphate aldolase [Mycoplasma wenyonii] diamond 312 204 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27687214 27687214 PRJNA853194_S_NODE_56344_length_291_cov_1.385321_g55253_i0 PRJNA853194 56344 291 1.385321 4.03128411 Mycoplasma wenyonii 65123 Bacteria Bacteria 65.5 1.35e-10   NR WP_112664965.1 65123 g55253 i0 88.6 0.360824742268041 35 4 36.1 0 72 176 1 35 WP_112664965.1 restriction endonuclease PLD domain-containing protein [Mycoplasma wenyonii] diamond 105 65.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
27750218 27750218 PRJNA853194_S_NODE_47364_length_315_cov_1.549587_g46273_i0 PRJNA853194 47364 315 1.549587 4.88119905 Mycoplasma wenyonii 65123 Bacteria Bacteria 188 4.55e-58   NR WP_112665247.1 65123 g46273 i0 97.1 0.990476190476191 104 3 99 0 313 2 32 135 WP_112665247.1 RluA family pseudouridine synthase [Mycoplasma wenyonii] diamond 312 188 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28255050 28255050 PRJNA853194_S_NODE_53506_length_298_cov_1.315556_g52415_i0 PRJNA853194 53506 298 1.315556 3.92035688 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 142 4.78e-38   NR WP_187150753.1 432608 g52415 i0 72.5 1.83221476510067 91 25 91.6 0 3 275 25 115 WP_187150753.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 546 142 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
28981571 28981571 PRJNA853194_S_NODE_67268_length_268_cov_1.051282_g66177_i0 PRJNA853194 67268 268 1.051282 2.81743576 Mycoplasma ovis 171632 Bacteria Bacteria 129 2.26e-32   NR WP_024071642.1 171632 g66177 i0 76.2 0.940298507462687 84 20 94 0 254 3 54 137 WP_024071642.1 type I DNA topoisomerase [Mycoplasma ovis] diamond 252 129 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
29265344 29265344 PRJNA853194_S_NODE_59789_length_283_cov_1.804762_g58698_i0 PRJNA853194 59789 283 1.804762 5.10747646 Mycoplasma wenyonii 65123 Bacteria Bacteria 166 5.61e-48   NR WP_112665229.1 65123 g58698 i0 88.3 0.996466431095406 94 11 99.6 0 1 282 113 206 WP_112665229.1 methionine adenosyltransferase domain-containing protein [Mycoplasma wenyonii] diamond 282 166 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
29707141 29707141 PRJNA853194_S_NODE_69030_length_264_cov_2.015707_g67939_i0 PRJNA853194 69030 264 2.015707 5.32146648 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 131 1.02e-36   NR WP_187150369.1 432608 g67939 i0 86.4 0.920454545454545 81 11 92 0 245 3 1 81 WP_187150369.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 243 131 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30781670 30781670 PRJNA853194_S_NODE_51814_length_302_cov_2.353712_g50723_i0 PRJNA853194 51814 302 2.353712 7.10821024 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 184 1.09e-51   NR WP_245633501.1 432608 g50723 i0 100 0.993377483443709 100 0 99.3 0 300 1 352 451 WP_245633501.1 DNA gyrase/topoisomerase IV subunit A [Candidatus Mycoplasma haematobovis] diamond 300 184 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31318887 31318887 PRJNA853194_S_NODE_48975_length_310_cov_1.974684_g47884_i0 PRJNA853194 48975 310 1.974684 6.1215204 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 61.2 2.75e-8   NR WP_187150740.1 432608 g47884 i0 59.6 0.503225806451613 52 21 50.3 0 160 5 1073 1124 WP_187150740.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 156 61.2 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);;