RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA782235" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA782235 · 14 ✖

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
2487798 2487798 PRJNA782235_P_NODE_25162_length_243_cov_1.811765_g24973_i0 PRJNA782235 25162 243 1.811765 4.40258895 Mycoplasma 2093 Bacteria Bacteria 444 3.09e-120   NTclustered gi|2294785939|gb|CP103424.1| 51364 g24973 i0 99.588 195.720164609054 243 1 100 0 1 243 270163 269921 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 47560 444 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
3314828 3314828 PRJNA782235_P_NODE_9983_length_289_cov_2.263889_g9794_i0 PRJNA782235 9983 289 2.263889 6.54263921 Mycoplasma yeatsii 51365 Bacteria Bacteria 518 2.19e-142   NTclustered gi|756767228|gb|CP007520.1| 743967 g9794 i0 98.962 146.993079584775 289 3 100 0 1 289 809617 809905 Mycoplasma yeatsii GM274B blastn 42481 518 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
4591522 4591522 PRJNA782235_P_NODE_12704_length_272_cov_1.547739_g12515_i0 PRJNA782235 12704 272 1.547739 4.20985008 Malacoplasma sp. 2791014 Bacteria Bacteria 86.3 1.65e-17   NR MCF0217664.1 2791014 g12515 i0 47.7 0.970588235294118 88 46 97.1 0 1 264 302 389 MCF0217664.1 molecular chaperone DnaJ [Malacoplasma sp.] diamond 264 86.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
9691938 9691938 PRJNA782235_P_NODE_7308_length_330_cov_1.684825_g7119_i0 PRJNA782235 7308 330 1.684825 5.5599225 Malacoplasma muris 2119 Bacteria Bacteria 525 1.5199999999999995e-144   NTclustered gi|299851933|gb|HM135461.1| 2119 g7119 i0 95.455 146.572727272727 330 14 100 1 1 330 335 663 Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence blastn 48369 525 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
13966213 13966213 PRJNA782235_P_NODE_15051_length_258_cov_1.156757_g14862_i0 PRJNA782235 15051 258 1.156757 2.98443306 FCB group 1783270 Bacteria Bacteria 472 1.52e-128   NTclustered gi|1720621726|gb|CP035041.1| 2100 g14862 i0 99.612 99.9069767441861 258 1 100 0 1 258 428787 429044 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 25776 472 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
19890322 19890322 PRJNA782235_P_NODE_5936_length_362_cov_1.065744_g5747_i0 PRJNA782235 5936 362 1.065744 3.85799328 Mycoplasma corogypsi 2106 Bacteria Bacteria 54.7 0.01   NTclustered gi|2860285583|gb|CP174163.1| 2106 g5747 i0 100 0.0801104972375691 29 0 8 0 330 358 335177 335149 Mycoplasma corogypsi strain BV1 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma corogypsi
24989834 24989834 PRJNA782235_P_NODE_23320_length_245_cov_0.895349_g23131_i0 PRJNA782235 23320 245 0.895349 2.19360505 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 79.7 1.87e-16   NR MDV3143250.1 101513 g23131 i0 58.7 0.771428571428571 63 26 77.1 0 243 55 113 175 MDV3143250.1 DUF3277 family protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 189 79.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
27821209 27821209 PRJNA782235_P_NODE_5244_length_382_cov_1.245955_g5055_i0 PRJNA782235 5244 382 1.245955 4.7595481 Mollicutes 31969 Bacteria Bacteria 82.4 1.07e-15   NR MBD5445981.1 2108 g5055 i0 53.5 1.31937172774869 99 30 76.2 2 381 91 78 162 MBD5445981.1 50S ribosomal protein L22 [Mycoplasma sp.] diamond 504 82.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
28010715 28010715 PRJNA782235_P_NODE_21745_length_246_cov_2.375723_g21556_i0 PRJNA782235 21745 246 2.375723 5.84427858 Malacoplasma 2791001 Bacteria Bacteria 99 5.33e-25   NR WP_004024888.1 2116 g21556 i0 65.4 1.97560975609756 81 28 98.8 0 246 4 1 81 WP_004024888.1 HPr family phosphocarrier protein [Malacoplasma iowae] diamond 486 100 0.99 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma iowae
28064273 28064273 PRJNA782235_P_NODE_22265_length_246_cov_0.890173_g22076_i0 PRJNA782235 22265 246 0.890173 2.18982558 Malacoplasma iowae 2116 Bacteria Bacteria 59.7 3.05e-8   NR WP_004024701.1 2116 g22076 i0 69.8 1.04878048780488 43 13 52.4 0 129 1 1 43 WP_004024701.1 50S ribosomal protein L2 [Malacoplasma iowae] diamond 258 59.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma iowae
29043284 29043284 PRJNA782235_P_NODE_20108_length_248_cov_0.880000_g19919_i0 PRJNA782235 20108 248 0.88 2.1824 Mycoplasmataceae bacterium RC_NB112A 1524337 Bacteria Bacteria 53.1 8.2e-6   NR KLL02564.1 1524337 g19919 i0 50 0.798387096774194 66 24 69 2 171 1 231 296 KLL02564.1 MAG: hypothetical protein MRERC_1c183 [Mycoplasmataceae bacterium RC_NB112A] diamond 198 53.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium RC_NB112A
31539095 31539095 PRJNA782235_P_NODE_3216_length_507_cov_0.974654_g3029_i0 PRJNA782235 3216 507 0.974654 4.94149578 Mycoplasma sp. 2108 Bacteria Bacteria 166 6.21e-50   NR MBD5445970.1 2108 g3029 i0 73.9 1.40828402366864 119 31 70.4 0 66 422 1 119 MBD5445970.1 50S ribosomal protein L18 [Mycoplasma sp.] diamond 714 166 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
31570785 31570785 PRJNA782235_P_NODE_23456_length_245_cov_0.895349_g23267_i0 PRJNA782235 23456 245 0.895349 2.19360505 Malacoplasma sp. 2791014 Bacteria Bacteria 55.1 1.1e-6   NR MEF9985211.1 2791014 g23267 i0 47.1 0.624489795918367 51 27 62.4 0 154 2 12 62 MEF9985211.1 alpha/beta fold hydrolase [Malacoplasma sp.] diamond 153 55.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
32298585 32298585 PRJNA782235_P_NODE_27179_length_242_cov_0.911243_g26990_i0 PRJNA782235 27179 242 0.911243 2.20520806 Malacoplasma muris 2119 Bacteria Bacteria 61.6 4.74e-9   NR WP_412031963.1 2119 g26990 i0 40.3 0.830578512396694 67 39 81.8 1 231 34 181 247 WP_412031963.1 protein phosphatase 2C domain-containing protein [Malacoplasma muris] diamond 201 61.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris

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