RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA999043" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 2 ✖

tax_kingdom 1

bioproject 1

  • PRJNA999043 · 2 ✖

analysis 1

  • diamond · 2 ✖

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
29047754 29047754 PRJNA999043_P_NODE_19828_length_272_cov_1.170854_g19733_i0 PRJNA999043 19828 272 1.170854 3.18472288 Pseudonocardia nantongensis 1181885 Bacteria Bacteria 84.3 7.4e-18   NR WP_410950542.1 1181885 g19733 i0 100 0.485294117647059 44 0 48.5 0 271 140 158 201 WP_410950542.1 DedA family protein [Pseudonocardia nantongensis] diamond 132 84.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia Pseudonocardia nantongensis
31575295 31575295 PRJNA999043_P_NODE_8396_length_590_cov_1.232108_g8304_i0 PRJNA999043 8396 590 1.232108 7.2694372 Corynebacterium striatum 43770 Bacteria Bacteria 69.7 8.01e-12   NR VFB06438.1 43770 g8304 i0 58 0.254237288135593 50 21 25.4 0 277 128 50 99 VFB06438.1 Tetracycline resistance protein, class C [Corynebacterium striatum] diamond 150 69.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium striatum

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