RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA577226", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 3 ✖

tax_clade 1

  • delta/epsilon subdivisions · 3 ✖

bioproject 1

  • PRJNA577226 · 3 ✖

analysis 1

tax_phylum 0

tax_kingdom 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
4390094 4390094 PRJNA577226_S_NODE_67584_length_154_cov_1.333333_g66645_i0 PRJNA577226 67584 154 1.333333 2.05333282 Persicimonas caeni 2292766 Bacteria Bacteria 104 3.44e-18   NTclustered gi|1695542189|gb|CP041186.1| 2292766 g66645 i0 95.385 0.844155844155844 65 3 42 0 49 113 500810 500746 Persicimonas caeni strain YN101 chromosome blastn 130 104 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria Bradymonadales Bradymonadaceae Persicimonas Persicimonas caeni
6241293 6241293 PRJNA577226_S_NODE_65985_length_155_cov_24.186441_g65046_i0 PRJNA577226 65985 155 24.186441 37.48898355 Bacteria 2 Bacteria Bacteria 281 1.49e-71   NTclustered gi|58199533|gb|AY689571.1| 34034 g65046 i0 99.355 99.9806451612903 155 1 100 0 1 155 617 771 Uncultured delta proteobacterium clone BDC3SA11 16S ribosomal RNA gene, partial sequence blastn 15497 281 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
10065907 10065907 PRJNA577226_S_NODE_38468_length_200_cov_6.601227_g37529_i0 PRJNA577226 38468 200 6.601227 13.202454 Myxococcota 2818505 Bacteria Bacteria 329 7.17e-86   NTclustered gi|60266538|gb|AY921992.1| 34034 g37529 i0 96.482 101.495 199 7 99 0 2 200 968 770 Uncultured delta proteobacterium clone AKYG1825 16S ribosomal RNA gene, partial sequence blastn 20299 331 0.993957703927492 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium

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