RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1204310" 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

bioproject 1

  • PRJNA1204310 · 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
7422968 7422968 PRJNA1204310_P_NODE_54126_length_250_cov_0.881356_g53829_i0 PRJNA1204310 54126 250 0.881356 2.20339 Mycoplasmopsis 2767358 Bacteria Bacteria 451 1.91e-122   NTclustered gi|2111402438|gb|CP068733.1| 28903 g53829 i0 99.2 101.988 250 2 100 0 1 250 981444 981693 Mycoplasmopsis bovis strain J81 chromosome, complete genome blastn 25497 451 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
16347473 16347473 PRJNA1204310_P_NODE_26733_length_357_cov_1.496479_g26436_i0 PRJNA1204310 26733 357 1.496479 5.34243003 Bacteria 2 Bacteria Bacteria 109 3.3500000000000006e-27   NR HHX16734.1 37628 g26436 i0 74.3 4.97478991596639 74 19 62.2 0 136 357 3 76 HHX16734.1 GTP-binding protein [Mollicutes bacterium] diamond 1776 109 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
29093859 29093859 PRJNA1204310_P_NODE_62748_length_242_cov_0.923077_g62451_i0 PRJNA1204310 62748 242 0.923077 2.23384634 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 57.4 1.46e-7   NR MFA7422197.1 1898209 g62451 i0 41.3 0.991735537190083 80 37 99.2 2 2 241 131 200 MFA7422197.1 DsbA family oxidoreductase [Acholeplasmataceae bacterium] diamond 240 57.4 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);;