RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA789095", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 3 ✖

tax_phylum 1

  • Mycoplasmatota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA789095 · 3 ✖

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
26999493 26999493 PRJNA789095_P_NODE_50842_length_284_cov_0.957346_g49508_i0 PRJNA789095 50842 284 0.957346 2.71886264 root 1 Root_unresolved Root_unresolved 135 4.11e-35   NR WP_206602619.1 2094 g49508 i0 77.9 324.285211267606 86 19 90.8 0 11 268 269 354 WP_206602619.1 cbb3-type cytochrome c oxidase subunit I [Mycoplasmopsis arginini] diamond 92097 136 0.992647058823529 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32708888 32708888 PRJNA789095_P_NODE_22380_length_493_cov_1.490476_g21051_i0 PRJNA789095 22380 493 1.490476 7.34804668 Mycoplasma sp. 2108 Bacteria Bacteria 95.9 1.54e-19   NR MCP4337106.1 2108 g21051 i0 35.3 0.845841784989858 139 90 84.6 0 72 488 138 276 MCP4337106.1 hypothetical protein [Mycoplasma sp.] diamond 417 95.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp.
32875536 32875536 PRJNA789095_P_NODE_50000_length_285_cov_5.853774_g48666_i0 PRJNA789095 50000 285 5.853774 16.6832559 root 1 Root_unresolved Root_unresolved 143 5.84e-38   NR WP_206602619.1 2094 g48666 i0 95 992.705263157895 80 4 84.2 0 3 242 188 267 WP_206602619.1 cbb3-type cytochrome c oxidase subunit I [Mycoplasmopsis arginini] diamond 282921 144 0.993055555555556 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini

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