RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA473824" 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

  • PRJNA473824 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
27265953 27265953 PRJNA473824_P_NODE_163063_length_150_cov_5.902655_g162425_i0 PRJNA473824 163063 150 5.902655 8.8539825 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 68.6 8e-12   NR RMX68316.1 542832 g162425 i0 77.1 0.96 48 8 90 1 149 15 632 679 RMX68316.1 hypothetical protein DD238_005319 [Peronospora effusa] diamond 144 68.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa
28339552 28339552 PRJNA473824_P_NODE_40166_length_192_cov_1.006452_g39528_i0 PRJNA473824 40166 192 1.006452 1.93238784 Phytophthora oleae 2107226 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0485   NR KAL3662092.1 2107226 g39528 i0 45.1 1.59375 51 24 79.7 1 181 29 156 202 KAL3662092.1 hypothetical protein V7S43_012896 [Phytophthora oleae] diamond 306 41.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora oleae
32352779 32352779 PRJNA473824_P_NODE_159359_length_151_cov_2.964912_g158721_i0 PRJNA473824 159359 151 2.964912 4.47701712 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 96.7 1.09e-21   NR XP_067786121.1 4785 g158721 i0 88.9 3.21854304635762 54 2 99.3 1 151 2 652 705 XP_067786121.1 Ribonucleoside-diphosphate reductase large subunit [Phytophthora cinnamomi] diamond 486 96.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi

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