RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1197996" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA1197996 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
4871784 4871784 PRJNA1197996_S_NODE_364_length_1026_cov_1.997901_g335_i0 PRJNA1197996 364 1026 1.997901 20.49846426 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 1677 0   NTclustered gi|2248512796|ref|NC_063789.1| 272952 g335 i0 96.819 98.0672514619883 1006 28 98 2 1 1002 1028 23 Hyaloperonospora arabidopsidis isolate Noks1 mitochondrion, complete genome blastn 100617 1681 0.997620464009518 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora arabidopsidis
7421453 7421453 PRJNA1197996_S_NODE_10246_length_332_cov_1.509653_g10192_i0 PRJNA1197996 10246 332 1.509653 5.01204796 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 67.6 1.12e-6   NTclustered gi|2795039260|ref|XM_067938436.1| 4785 g10192 i0 88.889 0.487951807228916 54 6 16 0 277 330 1719 1666 Phytophthora cinnamomi Translocation protein SEC63 (IUM83_13740), partial mRNA blastn 162 67.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
11802490 11802490 PRJNA1197996_S_NODE_19190_length_270_cov_3.111675_g19136_i0 PRJNA1197996 19190 270 3.111675 8.4015225 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 285 2.24e-72   NTclustered gi|2795032738|ref|XM_067933181.1| 4785 g19136 i0 87.967 93.1518518518518 241 29 89 0 1 241 751 991 Phytophthora cinnamomi Electron transfer flavoprotein subunit alpha, mitochondrial precursor (IUM83_08787), partial mRNA blastn 25151 285 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
22000618 22000618 PRJNA1197996_S_NODE_15258_length_292_cov_2.310502_g15204_i0 PRJNA1197996 15258 292 2.310502 6.74666584 Peronospora aff. claytoniae 2028483 SAR_Eukaryotes SAR_Eukaryotes 464 2.93e-126   NTclustered gi|1235732001|gb|MF693904.1| 2028483 g15204 i0 98.846 88.8664383561644 260 3 89 0 32 291 1 260 Peronospora aff. claytoniae isolate RC16DM3 large subunit ribosomal RNA gene, partial sequence blastn 25949 464 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora aff. claytoniae

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