RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA600413" and tax_phylum = "Chytridiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chytridiomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA600413 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
29321923 29321923 PRJNA600413_P_NODE_130389_length_163_cov_1.640351_g129688_i0 PRJNA600413 130389 163 1.640351 2.67377213 Spizellomyces sp. 'palustris' 117820 Fungi Fungi 58.5 3.32e-9   NR TPX69783.1 117820 g129688 i0 87.1 1.08588957055215 31 4 57.1 0 163 71 4 34 TPX69783.1 hypothetical protein SpCBS45565_g02137 [Spizellomyces sp. 'palustris'] diamond 177 58.5 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Spizellomycetales Spizellomycetaceae Spizellomyces Spizellomyces sp. 'palustris'
30535534 30535534 PRJNA600413_P_NODE_110593_length_166_cov_0.871795_g109892_i0 PRJNA600413 110593 166 0.871795 1.4471797 Eukaryota 2759 Fungi Fungi 49.3 6.46e-5   NR KAH9249674.1 1357716 g109892 i0 50 1.62650602409639 44 22 79.5 0 136 5 42 85 KAH9249674.1 hypothetical protein BASA81_012643 [Batrachochytrium salamandrivorans] diamond 270 49.7 0.991951710261569 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Rhizophydiales   Batrachochytrium Batrachochytrium salamandrivorans
30933077 30933077 PRJNA600413_P_NODE_141014_length_162_cov_0.902655_g140313_i0 PRJNA600413 141014 162 0.902655 1.4623011 Chytriomyces sp. MP71 1882861 Fungi Fungi 49.7 4.29e-5   NR KAI8616402.1 1882861 g140313 i0 47.9 0.888888888888889 48 25 88.9 0 160 17 160 207 KAI8616402.1 hypothetical protein BC830DRAFT_1118160 [Chytriomyces sp. MP71] diamond 144 49.7 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Chytridiales Chytriomycetaceae Chytriomyces Chytriomyces sp. MP71

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