RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA674050", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 4 ✖

tax_kingdom 1

  • Bacillati · 4 ✖

bioproject 1

  • PRJNA674050 · 4 ✖

analysis 1

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
27461115 27461115 PRJNA674050_P_NODE_34003_length_245_cov_0.901163_g33800_i0 PRJNA674050 34003 245 0.901163 2.20784935 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 41.6 0.0207   NR MDV3194028.1 101513 g33800 i0 61.3 0.379591836734694 31 11 36.7 1 52 141 14 44 MDV3194028.1 hypothetical protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 93 41.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
29986989 29986989 PRJNA674050_P_NODE_17511_length_267_cov_0.886598_g17308_i0 PRJNA674050 17511 267 0.886598 2.36721666 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 107 8.100000000000001e-28   NR MDV3193918.1 101513 g17308 i0 63.6 0.98876404494382 88 28 94.4 1 258 7 14 101 MDV3193918.1 hypothetical protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 264 107 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
30998118 30998118 PRJNA674050_P_NODE_27914_length_249_cov_0.869318_g27711_i0 PRJNA674050 27914 249 0.869318 2.16460182 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 47 4.35e-4   NR MFA5068271.1 3018265 g27711 i0 46.5 0.518072289156627 43 23 51.8 0 119 247 7 49 MFA5068271.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] diamond 129 47 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
31092832 31092832 PRJNA674050_P_NODE_16835_length_269_cov_1.372449_g16632_i0 PRJNA674050 16835 269 1.372449 3.69188781 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 164 1.94e-50   NR MDV3183839.1 101513 g16632 i0 89.9 0.992565055762082 89 9 99.3 0 3 269 37 125 MDV3183839.1 ribonuclease H family protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 267 164 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum

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