RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA495391", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 3 ✖

tax_kingdom 1

  • Bacillati · 3 ✖

bioproject 1

  • PRJNA495391 · 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
6853833 6853833 PRJNA495391_S_NODE_29826_length_222_cov_0.957219_g28774_i0 PRJNA495391 29826 222 0.957219 2.12502618 Mycoplasma struthionis 538220 Bacteria Bacteria 54.7 0.005   NTclustered gi|1526087405|gb|CP034044.1| 538220 g28774 i0 92.308 0.175675675675676 39 2 18 1 98 136 244057 244094 Mycoplasma struthionis strain 237IA chromosome, complete genome blastn 39 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma struthionis
15135309 15135309 PRJNA495391_S_NODE_29632_length_222_cov_2.411765_g28580_i0 PRJNA495391 29632 222 2.411765 5.3541183 Mesomycoplasma 2923352 Bacteria Bacteria 411 2.8199999999999996e-110   NTclustered gi|1958638505|gb|MW498314.1| 2100 g28580 i0 100 99.7747747747748 222 0 100 0 1 222 1465 1686 Mesomycoplasma hyorhinis strain MycSu128 23S ribosomal RNA gene, partial sequence blastn 22150 411 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
27218702 27218702 PRJNA495391_S_NODE_50962_length_173_cov_2.137681_g49910_i0 PRJNA495391 50962 173 2.137681 3.69818813 Bacteria 2 Bacteria Bacteria 52 4.2e-6   NR SYV90531.1 45363 g49910 i0 56.3 14.7919075144509 48 21 83.2 0 4 147 67 114 SYV90531.1 ATP-dependent DNA helicase pcrA [Metamycoplasma alkalescens] diamond 2559 52 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma alkalescens

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