RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 3 ✖

tax_phylum 1

  • Mycoplasmatota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA631119 · 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
4980096 4980096 PRJNA631119_P_NODE_30024_length_253_cov_2.977778_g29906_i0 PRJNA631119 30024 253 2.977778 7.53377834 Spiroplasma 2132 Bacteria Bacteria 52.8 0.023   NTclustered gi|2721114795|dbj|AP028955.1| 2141 g29906 i0 100 0.99604743083004 28 0 11 0 126 153 1176179 1176206 Spiroplasma ixodetis sAp269 DNA, complete genome blastn 252 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma ixodetis
12082574 12082574 PRJNA631119_P_NODE_10030_length_382_cov_2.349515_g9912_i0 PRJNA631119 10030 382 2.349515 8.9751473 Spiroplasma corruscae 216934 Bacteria Bacteria 52.8 0.036   NTclustered gi|1226105578|gb|CP022535.1| 216934 g9912 i0 100 0.0732984293193717 28 0 7 0 79 106 663438 663465 Spiroplasma corruscae strain EC-1 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma corruscae
31736815 31736815 PRJNA631119_P_NODE_20217_length_295_cov_4.189189_g20099_i0 PRJNA631119 20217 295 4.189189 12.35810755 FCB group 1783270 Bacteria Bacteria 90.1 7.34e-20   NR WP_016340484.1 216945 g20099 i0 48.1 3.92542372881356 77 40 78.3 0 238 8 1 77 WP_016340484.1 adenylate kinase [Spiroplasma syrphidicola] diamond 1158 90.5 0.995580110497237 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma syrphidicola

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