RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1011833 · 4 ✖

analysis 1

  • blastn · 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
6533703 6533703 PRJNA1011833_S_NODE_60306_length_150_cov_1.794393_g59886_i0 PRJNA1011833 60306 150 1.794393 2.6915895 Mycoplasma wenyonii 65123 Bacteria Bacteria 267 4.009999999999999e-67   NTclustered gi|395455868|gb|CP003703.1| 1197325 g59886 i0 98.667 1 150 2 100 0 1 150 232348 232199 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 150 267 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
11634069 11634069 PRJNA1011833_S_NODE_45570_length_172_cov_1.116279_g45150_i0 PRJNA1011833 45570 172 1.116279 1.91999988 Mycoplasma wenyonii 65123 Bacteria Bacteria 302 1.3e-77   NTclustered gi|395455868|gb|CP003703.1| 1197325 g45150 i0 98.256 1 172 3 100 0 1 172 149450 149279 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 172 302 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
20556732 20556732 PRJNA1011833_S_NODE_60557_length_150_cov_1.345794_g60137_i0 PRJNA1011833 60557 150 1.345794 2.018691 Mycoplasma wenyonii 65123 Bacteria Bacteria 255 8.680000000000001e-64   NTclustered gi|395455868|gb|CP003703.1| 1197325 g60137 i0 97.333 1 150 4 100 0 1 150 454718 454867 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 150 255 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii
23107808 23107808 PRJNA1011833_S_NODE_48559_length_166_cov_1.560976_g48139_i0 PRJNA1011833 48559 166 1.560976 2.59122016 Mycoplasma wenyonii 65123 Bacteria Bacteria 215 1.68e-51   NTclustered gi|395455868|gb|CP003703.1| 1197325 g48139 i0 93.197 37.5963855421687 147 9 89 1 1 147 52236 52381 Mycoplasma wenyonii str. Massachusetts, complete genome blastn 6241 215 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma wenyonii

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