RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA929922 · 3 ✖

analysis 1

  • blastn · 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
2182029 2182029 PRJNA929922_P_NODE_162902_length_241_cov_0.916667_g162362_i0 PRJNA929922 162902 241 0.916667 2.20916747 Bremia lactucae 4779 SAR_Eukaryotes SAR_Eukaryotes 379 8.759999999999998e-101   NTclustered gi|2794721556|ref|XM_067967754.1| 4779 g162362 i0 95.021 1.44398340248963 241 12 100 0 1 241 799 1039 Bremia lactucae uncharacterized protein (CCR75_009715), partial mRNA blastn 348 379 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae
23861030 23861030 PRJNA929922_S_NODE_68099_length_243_cov_0.905882_g67875_i0 PRJNA929922 68099 243 0.905882 2.20129326 Peronospora aestivalis 162107 SAR_Eukaryotes SAR_Eukaryotes 444 3.09e-120   NTclustered gi|145209007|gb|AY035482.2| 162107 g67875 i0 99.588 100 243 1 100 0 1 243 259 17 Peronospora aestivalis isolate HV 167 large subunit ribosomal RNA gene, partial sequence blastn 24300 444 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora aestivalis
25133324 25133324 PRJNA929922_P_NODE_53060_length_318_cov_1.257143_g52520_i0 PRJNA929922 53060 318 1.257143 3.99771474 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 206 2.16e-48   NTclustered gi|673036523|ref|XM_008874001.1| 157072 g52520 i0 78.638 9.47169811320755 323 59 100 8 1 318 1180 863 Aphanomyces invadans hypothetical protein mRNA blastn 3012 206 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans

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