RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA1011844" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1011844 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
9084066 9084066 PRJNA1011844_P_NODE_171648_length_226_cov_3.307190_g163067_i0 PRJNA1011844 171648 226 3.30719 7.4742494 Anaeroplasmataceae bacterium 2793037 Bacteria Bacteria 92.4 2.73e-20   NR MDE5868351.1 2793037 g163067 i0 58.3 3.71681415929204 72 29 95.6 1 11 226 58 128 MDE5868351.1 asparaginase [Anaeroplasmataceae bacterium] diamond 840 92.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Anaeroplasmatales Anaeroplasmataceae   Anaeroplasmataceae bacterium
28834809 28834809 PRJNA1011844_P_NODE_141668_length_255_cov_3.318681_g133090_i0 PRJNA1011844 141668 255 3.318681 8.46263655 Candidatus Izimaplasma bacterium N/A Bacteria Bacteria 57 3.84e-7   NR MDC0558788.1 2315156 g133090 i0 42.1 2.2 76 34 77.6 1 214 17 233 308 MDC0558788.1 beta-lactamase family protein [Candidatus Izimaplasma bacterium] diamond 561 57 1 Bacteria   Bacillati Mycoplasmatota Candidatus Izimaplasma       Candidatus Izimaplasma bacterium
28993005 28993005 PRJNA1011844_P_NODE_111568_length_299_cov_1.929204_g102992_i0 PRJNA1011844 111568 299 1.929204 5.76831996 Acholeplasma laidlawii 2148 Bacteria Bacteria 73.9 8.27e-13   NR WIF89110.1 2148 g102992 i0 43.2 0.953177257525084 95 53 94.3 1 16 297 1641 1735 WIF89110.1 InlB B-repeat-containing protein [Acholeplasma laidlawii] diamond 285 73.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma laidlawii
29845314 29845314 PRJNA1011844_P_NODE_98931_length_330_cov_2.607004_g90365_i0 PRJNA1011844 98931 330 2.607004 8.6031132 Spiroplasma endosymbiont of Othius punctulatus 3066289 Bacteria Bacteria 43.9 0.0391   NR WP_338982805.1 3066289 g90365 i0 30.4 0.836363636363636 92 51 78.2 2 266 9 546 630 WP_338982805.1 ATP-dependent DNA helicase [Spiroplasma endosymbiont of Othius punctulatus] diamond 276 43.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Othius punctulatus
30856257 30856257 PRJNA1011844_P_NODE_52774_length_595_cov_5.086207_g44471_i0 PRJNA1011844 52774 595 5.086207 30.26293165 Mollicutes bacterium 37628 Bacteria Bacteria 47 0.0285   NR MCI7058655.1 37628 g44471 i0 35.6 0.453781512605042 90 54 44.4 2 185 448 290 377 MCI7058655.1 endopeptidase La [Mollicutes bacterium] diamond 270 47 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
31014139 31014139 PRJNA1011844_P_NODE_108535_length_306_cov_2.510730_g99962_i0 PRJNA1011844 108535 306 2.51073 7.6828338 endosymbiont GvMRE of Glomus versiforme 2039283 Bacteria Bacteria 58.9 7.7e-8   NR WP_147411026.1 2039283 g99962 i0 35.8 0.931372549019608 95 52 85.3 3 41 301 13 106 WP_147411026.1 DUF6940 family protein [endosymbiont GvMRE of Glomus versiforme] diamond 285 58.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     endosymbiont GvMRE of Glomus versiforme
31077564 31077564 PRJNA1011844_P_NODE_23455_length_1137_cov_5.414474_g17765_i0 PRJNA1011844 23455 1137 5.414474 61.56256938 Malacoplasma sp. 2791014 Bacteria Bacteria 49.3 0.0245   NR MCF0227810.1 2791014 g17765 i0 23 0.823218997361478 183 131 46.7 6 195 725 244 422 MCF0227810.1 hypothetical protein [Malacoplasma sp.] diamond 936 49.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
32311278 32311278 PRJNA1011844_P_NODE_136839_length_261_cov_1.723404_g128261_i0 PRJNA1011844 136839 261 1.723404 4.49808444 Candidatus Phytoplasma meliae 1848402 Bacteria Bacteria 42.7 0.0453   NR WP_203551913.1 1848402 g128261 i0 33.3 0.793103448275862 69 43 75.9 2 199 2 119 187 WP_203551913.1 AAA family ATPase [Candidatus Phytoplasma meliae] diamond 207 42.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma meliae

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