RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA611476" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA611476 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
26700158 26700158 PRJNA611476_P_NODE_39841_length_337_cov_1.571970_g39050_i0 PRJNA611476 39841 337 1.57197 5.2975389 Aster yellows phytoplasma 35779 Bacteria Bacteria 53.1 8.52e-7   NR AAO61994.1 35779 g39050 i0 51.9 0.961424332344214 52 25 46.3 0 165 10 1 52 AAO61994.1 conserved hypothetical protein, partial [Aster yellows phytoplasma] diamond 324 53.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Aster yellows phytoplasma
29859043 29859043 PRJNA611476_P_NODE_98111_length_246_cov_0.890173_g97320_i0 PRJNA611476 98111 246 0.890173 2.18982558 Haploplasma axanthum 29552 Bacteria Bacteria 72.8 9.98e-13   NR WP_129747553.1 29552 g97320 i0 43.2 0.98780487804878 81 46 98.8 0 3 245 51 131 WP_129747553.1 lectin-like domain-containing protein [Haploplasma axanthum] diamond 243 72.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Haploplasma Haploplasma axanthum
31122444 31122444 PRJNA611476_P_NODE_116075_length_241_cov_0.916667_g115284_i0 PRJNA611476 116075 241 0.916667 2.20916747 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 90.9 4.07e-19   NR MDY0294809.1 1898209 g115284 i0 60.5 0.946058091286307 76 30 94.6 0 233 6 958 1033 MDY0294809.1 DNRLRE domain-containing protein [Acholeplasmataceae bacterium] diamond 228 90.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
31913464 31913464 PRJNA611476_P_NODE_105757_length_244_cov_0.900585_g104966_i0 PRJNA611476 105757 244 0.900585 2.1974274 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 99 4e-23   NR HHX00860.1 1898209 g104966 i0 100 0.590163934426229 48 0 59 0 244 101 216 263 HHX00860.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 144 99 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
32829857 32829857 PRJNA611476_P_NODE_116380_length_241_cov_0.916667_g115589_i0 PRJNA611476 116380 241 0.916667 2.20916747 Haploplasma sp. 2903113 Bacteria Bacteria 150 1.1399999999999997e-42   NR HKL95362.1 2903113 g115589 i0 97.5 0.995850622406639 80 2 99.6 0 2 241 202 281 HKL95362.1 DNA-binding protein WhiA [Haploplasma sp.] diamond 240 150 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Haploplasma Haploplasma sp.
32842748 32842748 PRJNA611476_P_NODE_60560_length_284_cov_1.199052_g59769_i0 PRJNA611476 60560 284 1.199052 3.40530768 Bacillati 1783272 Bacteria Bacteria 43.1 0.00821   NR OPZ33206.1 1852921 g59769 i0 50 1.51056338028169 52 24 53.9 2 193 41 30 80 OPZ33206.1 MAG: Double zinc ribbon [Tenericutes bacterium ADurb.BinA124] diamond 429 43.1 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium ADurb.BinA124

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