RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA401346", tax_clade = "Sar" 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

  • PRJNA401346 · 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
23366425 23366425 PRJNA401346_P_NODE_8179_length_203_cov_0.901408_g8158_i0 PRJNA401346 8179 203 0.901408 1.82985824 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 139 8.88e-40   NR XP_024584861.1 4781 g8158 i0 97 13.8620689655172 67 2 99 0 3 203 67 133 XP_024584861.1 adp-ribosylation factor [Plasmopara halstedii] diamond 2814 139 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii
31451120 31451120 PRJNA401346_P_NODE_3676_length_273_cov_1.320755_g3655_i0 PRJNA401346 3676 273 1.320755 3.60566115 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 124 1.1000000000000001e-30   NR DAZ95465.1 4803 g3655 i0 65.2 18.0879120879121 92 30 98.9 1 272 3 171 262 DAZ95465.1 TPA: hypothetical protein N0F65_002150, partial [Lagenidium giganteum] diamond 4938 124 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
32115431 32115431 PRJNA401346_P_NODE_4438_length_252_cov_2.680628_g4417_i0 PRJNA401346 4438 252 2.680628 6.75518256 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 67 2.02e-12   NR TMW60409.1 41045 g4417 i0 61 14.2738095238095 59 22 69 1 252 79 22 80 TMW60409.1 hypothetical protein Poli38472_000451 [Pythium oligandrum] diamond 3597 67.4 0.99406528189911 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum

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