RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA782235" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA782235 · 9 ✖

analysis 1

  • diamond · 9 ✖

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