RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1240804 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
26852231 26852231 PRJNA1240804_P_NODE_149021_length_162_cov_0.920354_g148655_i0 PRJNA1240804 149021 162 0.920354 1.49097348 Mycoplasmopsis arginini 2094 Bacteria Bacteria 55.5 1.58e-8   NR WP_282459101.1 2094 g148655 i0 63.2 0.703703703703704 38 14 70.4 0 147 34 28 65 WP_282459101.1 hypothetical protein [Mycoplasmopsis arginini] diamond 114 55.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27294695 27294695 PRJNA1240804_P_NODE_109863_length_169_cov_0.866667_g109497_i0 PRJNA1240804 109863 169 0.866667 1.46466723 Mycoplasma wenyonii 65123 Bacteria Bacteria 44.3 0.00397   NR WP_146737515.1 65123 g109497 i0 40.4 0.923076923076923 52 31 92.3 0 14 169 21 72 WP_146737515.1 hypothetical protein [Mycoplasma wenyonii] diamond 156 44.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
30863368 30863368 PRJNA1240804_P_NODE_86394_length_182_cov_1.458647_g86028_i0 PRJNA1240804 86394 182 1.458647 2.65473754 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 41.2 0.0111   NR MCK9236229.1 1898209 g86028 i0 73.9 1.73076923076923 23 6 37.9 0 3 71 56 78 MCK9236229.1 30S ribosomal protein S18 [Acholeplasmataceae bacterium] diamond 315 41.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium

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