RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA1168532" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1168532 · 13 ✖

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
7968502 7968502 PRJNA1168532_S_NODE_318607_length_162_cov_1.579832_g315664_i0 PRJNA1168532 318607 162 1.579832 2.55932784 Mycoplasma wenyonii 65123 Bacteria Bacteria 300 4.36e-77   NTclustered gi|395455868|gb|CP003703.1| 1197325 g315664 i0 100 1 162 0 100 0 1 162 447386 447225 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 162 300 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
20716532 20716532 PRJNA1168532_S_NODE_254117_length_188_cov_1.620690_g251174_i0 PRJNA1168532 254117 188 1.62069 3.0468972 Mycoplasma ovis 171632 Bacteria Bacteria 187 4.2299999999999985e-43   NTclustered gi|566058721|gb|CP006935.1| 1415773 g251174 i0 84.574 1 188 29 100 0 1 188 59113 59300 Mycoplasma ovis str. Michigan, complete genome blastn 188 187 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
26597009 26597009 PRJNA1168532_S_NODE_264961_length_183_cov_1.307143_g262018_i0 PRJNA1168532 264961 183 1.307143 2.39207169 Mycoplasma wenyonii 65123 Bacteria Bacteria 51.2 6.9e-6   NR WP_112665915.1 65123 g262018 i0 47.9 0.786885245901639 48 9 78.7 1 3 146 58 89 WP_112665915.1 hypothetical protein [Mycoplasma wenyonii] diamond 144 51.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28146171 28146171 PRJNA1168532_S_NODE_348325_length_153_cov_1.281818_g345382_i0 PRJNA1168532 348325 153 1.281818 1.96118154 Mycoplasma wenyonii 65123 Bacteria Bacteria 63.5 5.07e-10   NR WP_112665000.1 65123 g345382 i0 100 0.647058823529412 33 0 64.7 0 99 1 529 561 WP_112665000.1 CHC2 zinc finger domain-containing protein [Mycoplasma wenyonii] diamond 99 63.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
28682903 28682903 PRJNA1168532_S_NODE_230747_length_201_cov_0.892405_g227804_i0 PRJNA1168532 230747 201 0.892405 1.79373405 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 105 1.24e-26   NR WP_187149852.1 432608 g227804 i0 100 0.82089552238806 55 0 82.1 0 192 28 1 55 WP_187149852.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 165 105 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
29377334 29377334 PRJNA1168532_S_NODE_275489_length_178_cov_1.740741_g272546_i0 PRJNA1168532 275489 178 1.740741 3.09851898 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 44.7 0.00316   NR WP_187150753.1 432608 g272546 i0 58.1 0.72471910112359506 43 18 72.5 0 48 176 4 46 WP_187150753.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 129 44.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30040527 30040527 PRJNA1168532_S_NODE_243411_length_194_cov_1.205298_g240468_i0 PRJNA1168532 243411 194 1.205298 2.33827812 Mycoplasma ovis 171632 Bacteria Bacteria 88.6 1.3e-18   NR WP_327084515.1 171632 g240468 i0 81.8 2.55154639175258 55 10 85.1 0 3 167 271 325 WP_327084515.1 methionine--tRNA ligase [Mycoplasma ovis] diamond 495 88.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma ovis
30166730 30166730 PRJNA1168532_S_NODE_337692_length_156_cov_1.415929_g334749_i0 PRJNA1168532 337692 156 1.415929 2.20884924 Mycoplasma wenyonii 65123 Bacteria Bacteria 92 4.49e-20   NR WP_112665841.1 65123 g334749 i0 81.8 1.05769230769231 55 7 100 1 156 1 223 277 WP_112665841.1 MIP family Ig-specific serine endopeptidase [Mycoplasma wenyonii] diamond 165 92 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30293670 30293670 PRJNA1168532_S_NODE_232152_length_200_cov_1.331210_g229209_i0 PRJNA1168532 232152 200 1.33121 2.66242 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 44.7 0.00434   NR WP_187150745.1 432608 g229209 i0 71.4 0.9 28 7 40.5 1 14 94 332 359 WP_187150745.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 180 44.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
30735561 30735561 PRJNA1168532_S_NODE_174514_length_238_cov_1.266667_g171571_i0 PRJNA1168532 174514 238 1.266667 3.01466746 Mycoplasma wenyonii 65123 Bacteria Bacteria 146 4.22e-44   NR WP_110555200.1 65123 g171571 i0 97.3 0.920168067226891 73 2 92 0 237 19 4 76 WP_110555200.1 50S ribosomal protein L31 [Mycoplasma wenyonii] diamond 219 146 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
31494359 31494359 PRJNA1168532_S_NODE_208496_length_214_cov_1.099415_g205553_i0 PRJNA1168532 208496 214 1.099415 2.3527481 Candidatus Mycoplasma haematobovis 432608 Bacteria Bacteria 120 5.1e-32   NR WP_187149669.1 432608 g205553 i0 100 0.883177570093458 63 0 88.3 0 191 3 133 195 WP_187149669.1 hypothetical protein [Candidatus Mycoplasma haematobovis] diamond 189 120 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma haematobovis
31652180 31652180 PRJNA1168532_S_NODE_311017_length_165_cov_1.155738_g308074_i0 PRJNA1168532 311017 165 1.155738 1.9069677 Mycoplasma wenyonii 65123 Bacteria Bacteria 72.4 4.56e-13   NR WP_014849924.1 65123 g308074 i0 80.5 0.745454545454545 41 8 74.5 0 123 1 361 401 WP_014849924.1 glutamine-hydrolyzing GMP synthase [Mycoplasma wenyonii] diamond 123 72.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
32884596 32884596 PRJNA1168532_S_NODE_360480_length_150_cov_1.317757_g357537_i0 PRJNA1168532 360480 150 1.317757 1.9766355 Mycoplasma wenyonii 65123 Bacteria Bacteria 71.6 5.29e-13   NR WP_112665748.1 65123 g357537 i0 75.6 0.82 41 10 82 0 3 125 1 41 WP_112665748.1 hypothetical protein [Mycoplasma wenyonii] diamond 123 71.6 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);;