RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA565778" 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

  • PRJNA565778 · 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
26699452 26699452 PRJNA565778_S_NODE_30181_length_200_cov_2.926380_g29885_i0 PRJNA565778 30181 200 2.92638 5.85276 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 121 3.5699999999999996e-31   NR NLH44891.1 1898209 g29885 i0 93.8 0.975 65 4 97.5 0 3 197 117 181 NLH44891.1 IS3 family transposase [Acholeplasmataceae bacterium] diamond 195 121 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
27680054 27680054 PRJNA565778_S_NODE_21644_length_238_cov_4.577114_g21348_i0 PRJNA565778 21644 238 4.577114 10.89353132 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 72.4 9.96e-13   NR NLH44891.1 1898209 g21348 i0 84.8 0.579831932773109 46 7 58 0 100 237 79 124 NLH44891.1 IS3 family transposase [Acholeplasmataceae bacterium] diamond 138 72.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
28135495 28135495 PRJNA565778_S_NODE_37705_length_176_cov_1.755396_g37409_i0 PRJNA565778 37705 176 1.755396 3.08949696 root 1 Root_unresolved Root_unresolved 59.3 2e-9   NR MBR4495970.1 2053494 g37409 i0 60 2.40340909090909 45 18 76.7 0 140 6 55 99 MBR4495970.1 hypothetical protein [Acholeplasmatales bacterium] diamond 423 59.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
28261488 28261488 PRJNA565778_S_NODE_20866_length_242_cov_7.258537_g20570_i0 PRJNA565778 20866 242 7.258537 17.56565954 Bacteria 2 Bacteria Bacteria 80.9 1.36e-15   NR WP_002557589.1 2128 g20570 i0 57.1 5.90082644628099 70 28 86.8 1 33 242 571 638 WP_002557589.1 DNA gyrase subunit B [Mesomycoplasma flocculare] diamond 1428 80.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma flocculare
28690331 28690331 PRJNA565778_S_NODE_27447_length_210_cov_268.306358_g27151_i0 PRJNA565778 27447 210 268.306358 563.4433518 endosymbiont GvMRE of Glomus versiforme 2039283 Bacteria Bacteria 53.9 2.65e-6   NR WP_147409457.1 2039283 g27151 i0 76.5 0.485714285714286 34 8 48.6 0 172 71 323 356 WP_147409457.1 protein kinase domain-containing protein [endosymbiont GvMRE of Glomus versiforme] diamond 102 53.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     endosymbiont GvMRE of Glomus versiforme
29953119 29953119 PRJNA565778_S_NODE_18531_length_257_cov_8.127273_g18235_i0 PRJNA565778 18531 257 8.127273 20.88709161 Mollicutes bacterium 37628 Bacteria Bacteria 47.8 7.31e-4   NR MCI5543655.1 37628 g18235 i0 100 0.256809338521401 22 0 25.7 0 224 159 139 160 MCI5543655.1 hypothetical protein [Mollicutes bacterium] diamond 66 47.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
30977907 30977907 PRJNA565778_S_NODE_41594_length_157_cov_1.300000_g41298_i0 PRJNA565778 41594 157 1.3 2.041 Bacillati 1783272 Bacteria Bacteria 46.2 6.95e-4   NR KFZ25617.1 1541960 g41298 i0 53.3 1.5859872611465 45 20 84.1 1 144 13 352 396 KFZ25617.1 MAG: putative transposase [Candidatus Izimaplasma bacterium HR2] diamond 249 46.6 0.991416309012876 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae Candidatus Izemoplasma Candidatus Izimoplasma sp. HR2
31565082 31565082 PRJNA565778_S_NODE_21376_length_239_cov_172.599010_g21080_i0 PRJNA565778 21376 239 172.59901 412.5116339 Phytoplasma sp. 2155 Bacteria Bacteria 113 3.9e-27   NR NLK12180.1 2155 g21080 i0 79.7 0.866108786610879 69 14 86.6 0 219 13 356 424 NLK12180.1 threonine--tRNA ligase [Phytoplasma sp.] diamond 207 113 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Phytoplasma sp.

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