RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB9859" 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

  • PRJEB9859 · 4 ✖

analysis 1

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
7797478 7797478 PRJEB9859_P_NODE_667_length_442_cov_279.799031_g637_i0 PRJEB9859 667 442 279.799031 1236.71171702 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 257 8.44e-64   NTclustered gi|2187163482|emb|OV788640.1| 658143 g637 i0 82.333 310.927601809955 300 50 68 3 121 419 373769 373472 uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1 blastn 137430 257 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
9072392 9072392 PRJEB9859_P_NODE_4008_length_254_cov_181.626667_g3973_i0 PRJEB9859 4008 254 181.626667 461.33173418 uncultured Ureaplasma sp. 293430 Bacteria Bacteria 211 3.6e-50   NTclustered gi|1899225129|gb|MT967601.1| 293430 g3973 i0 84.234 78.0748031496063 222 29 86 6 13 231 1963 1745 Uncultured Ureaplasma sp. clone asv_100_2225 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 19831 211 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma uncultured Ureaplasma sp.
9072433 9072433 PRJEB9859_P_NODE_668_length_442_cov_278.234867_g637_i1 PRJEB9859 668 442 278.234867 1229.79811214 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 257 8.44e-64   NTclustered gi|2187163482|emb|OV788640.1| 658143 g637 i1 82.333 310.927601809955 300 50 68 3 121 419 373769 373472 uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1 blastn 137430 257 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
15447694 15447694 PRJEB9859_P_NODE_673_length_441_cov_279.334951_g637_i2 PRJEB9859 673 441 279.334951 1231.86713391 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 257 8.42e-64   NTclustered gi|2187163482|emb|OV788640.1| 658143 g637 i2 82.333 311.632653061225 300 50 68 3 120 418 373769 373472 uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1 blastn 137430 257 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota 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);;