RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA980839" 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

bioproject 1

  • PRJNA980839 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
27026230 27026230 PRJNA980839_P_NODE_218102_length_246_cov_0.890173_g214318_i0 PRJNA980839 218102 246 0.890173 2.18982558 Mycoplasmopsis arginini 2094 Bacteria Bacteria 100 1.18e-25   NR WP_369124529.1 2094 g214318 i0 92.5 0.646341463414634 53 4 64.6 0 245 87 45 97 WP_369124529.1 helix-turn-helix domain-containing protein [Mycoplasmopsis arginini] diamond 159 100 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29016135 29016135 PRJNA980839_P_NODE_231448_length_243_cov_0.876471_g227664_i0 PRJNA980839 231448 243 0.876471 2.12982453 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 46.6 0.00164   NR MBR4495755.1 2053494 g227664 i0 79.2 0.296296296296296 24 5 29.6 0 243 172 396 419 MBR4495755.1 hypothetical protein [Acholeplasmatales bacterium] diamond 72 46.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
29363182 29363182 PRJNA980839_P_NODE_198569_length_251_cov_0.865169_g194785_i0 PRJNA980839 198569 251 0.865169 2.17157419 Mycoplasmopsis fermentans 2115 Bacteria Bacteria 122 2.66e-30   NR WP_122530570.1 2115 g194785 i0 100 1.50597609561753 63 0 75.3 0 249 61 510 572 WP_122530570.1 hypothetical protein [Mycoplasmopsis fermentans] diamond 378 122 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
30626402 30626402 PRJNA980839_P_NODE_203173_length_250_cov_0.870056_g199389_i0 PRJNA980839 203173 250 0.870056 2.17514 Spiroplasma monobiae 2136 Bacteria Bacteria 161 3.2899999999999993e-46   NR WP_101780827.1 2136 g199389 i0 100 0.996 83 0 99.6 0 2 250 240 322 WP_101780827.1 DNA cytosine methyltransferase [Spiroplasma monobiae] diamond 249 161 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma monobiae

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