RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA485080" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA485080 · 6 ✖

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
15751790 15751790 PRJNA485080_P_NODE_2473_length_580_cov_2.341223_g2380_i0 PRJNA485080 2473 580 2.341223 13.5790934 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 484 4.769999999999999e-132   NTclustered gi|166041965|emb|CU361047.1| 100861 g2380 i0 82.149 90.5068965517241 577 92 99 9 4 575 652 82 Aphanomyces euteiches cDNA blastn 52494 484 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
19574781 19574781 PRJNA485080_P_NODE_16156_length_285_cov_1.089623_g16062_i0 PRJNA485080 16156 285 1.089623 3.10542555 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 207 5.31e-49   NTclustered gi|813114452|ref|XM_012339991.1| 695850 g16062 i0 80 16.4982456140351 285 53 99 4 3 285 135 417 Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA blastn 4702 207 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
26934163 26934163 PRJNA485080_P_NODE_29402_length_248_cov_0.880000_g29308_i0 PRJNA485080 29402 248 0.88 2.1824 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 53.9 4.57e-6   NR XP_012199487.1 695850 g29308 i0 53.3 1.76612903225806 45 21 54.4 0 88 222 398 442 XP_012199487.1 hypothetical protein SPRG_04959 [Saprolegnia parasitica CBS 223.65] diamond 438 53.9 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
28623968 28623968 PRJNA485080_P_NODE_43367_length_241_cov_0.916667_g43273_i0 PRJNA485080 43367 241 0.916667 2.20916747 Saprolegnia diclina VS2 112098 SAR_Eukaryotes SAR_Eukaryotes 82 4.77e-16   NR XP_008615942.1 1156394 g43273 i0 56.8 1.00829875518672 81 33 98.3 1 240 4 267 347 XP_008615942.1 CAMK/CAMKL protein kinase [Saprolegnia diclina VS20] diamond 243 82 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
28971118 28971118 PRJNA485080_P_NODE_37488_length_244_cov_0.900585_g37394_i0 PRJNA485080 37488 244 0.900585 2.1974274 Phytophthora megakarya 4795 SAR_Eukaryotes SAR_Eukaryotes 47 0.00114   NR OWZ14451.1 4795 g37394 i0 52.3 3.83606557377049 44 20 52.9 1 239 111 182 225 OWZ14451.1 Integrase, catalytic core protein [Phytophthora megakarya] diamond 936 47 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megakarya
31466947 31466947 PRJNA485080_P_NODE_36776_length_244_cov_0.900585_g36682_i0 PRJNA485080 36776 244 0.900585 2.1974274 Pythium oligandrum 41045 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0193   NR TMW56309.1 41045 g36682 i0 34.9 0.774590163934426 63 40 77.5 1 236 48 12 73 TMW56309.1 hypothetical protein Poli38472_008957 [Pythium oligandrum] diamond 189 43.5 1 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);;