RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA763718" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA763718 · 3 ✖

analysis 1

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
21146731 21146731 PRJNA763718_S_NODE_6157_length_176_cov_1.366906_g5949_i0 PRJNA763718 6157 176 1.366906 2.40575456 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 95.1 8.189999999999999e-23   NR KAG1707364.1 4784 g5949 i0 81 16.8068181818182 58 11 98.9 0 176 3 86 143 KAG1707364.1 40S ribosomal protein S20 [Phytophthora capsici] diamond 2958 95.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
30599812 30599812 PRJNA763718_S_NODE_6473_length_172_cov_1.081481_g6265_i0 PRJNA763718 6473 172 1.081481 1.86014732 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 80.1 5.93e-17   NR RHX98215.1 112090 g6265 i0 70 8.26744186046512 50 15 87.2 0 3 152 31 80 RHX98215.1 hypothetical protein DYB36_009520, partial [Aphanomyces astaci] diamond 1422 80.9 0.990111248454882 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
31199840 31199840 PRJNA763718_S_NODE_4855_length_199_cov_1.679012_g4647_i0 PRJNA763718 4855 199 1.679012 3.34123388 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 46.6 5.15e-4   NR KAF0727141.1 100861 g4647 i0 42 7.49246231155779 50 28 73.9 1 4 150 116 165 KAF0727141.1 hypothetical protein Ae201684_014778 [Aphanomyces euteiches] diamond 1491 46.6 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches

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