RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA1069776" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

bioproject 1

  • PRJNA1069776 · 2 ✖

analysis 1

  • diamond · 2 ✖

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
27320304 27320304 PRJNA1069776_S_NODE_3603_length_408_cov_5.008219_g3289_i0 PRJNA1069776 3603 408 5.008219 20.43353352 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 60.5 1.47e-7   NR KAL3929702.1 3061772 g3289 i0 46.8 0.455882352941176 62 33 45.6 0 403 218 832 893 KAL3929702.1 MAG: hypothetical protein SGBAC_012098 [Bacillariaceae sp.] diamond 186 60.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30415258 30415258 PRJNA1069776_S_NODE_15793_length_259_cov_5.648148_g15479_i0 PRJNA1069776 15793 259 5.648148 14.62870332 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0175   NR OLQ07492.1 2951 g15479 i0 37.5 0.833976833976834 72 43 82.2 2 10 222 203 273 OLQ07492.1 hypothetical protein AK812_SmicGene9090 [Symbiodinium microadriaticum] diamond 216 43.9 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum

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