RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA382357" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA382357 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
26885459 26885459 PRJNA382357_P_NODE_76401_length_272_cov_7.616114_g75662_i0 PRJNA382357 76401 272 7.616114 20.71583008 Peronospora farinosa 134698 SAR_Eukaryotes SAR_Eukaryotes 59.3 7.51e-8   NR CAH0492909.1 134698 g75662 i0 72.2 0.882352941176471 36 10 39.7 0 170 63 403 438 CAH0492909.1 unnamed protein product [Peronospora farinosa] diamond 240 59.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora farinosa
26902381 26902381 PRJNA382357_P_NODE_108641_length_233_cov_4.087209_g107902_i0 PRJNA382357 108641 233 4.087209 9.52319697 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0018600000000000001   NR KAE9290760.1 53985 g107902 i0 50 1.6480686695279 32 16 41.2 0 232 137 7 38 KAE9290760.1 hypothetical protein PF008_g25506 [Phytophthora fragariae] diamond 384 44.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariae
27043499 27043499 PRJNA382357_P_NODE_77102_length_271_cov_2.847619_g76363_i0 PRJNA382357 77102 271 2.847619 7.71704749 Hyaloperonospora brassicae 162125 SAR_Eukaryotes SAR_Eukaryotes 84.3 1.15e-16   NR CAI5729537.1 162125 g76363 i0 91.3 0.509225092250922 46 4 50.9 0 245 108 1 46 CAI5729537.1 unnamed protein product [Hyaloperonospora brassicae] diamond 138 84.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora brassicae
27580480 27580480 PRJNA382357_P_NODE_100224_length_242_cov_1.281768_g99485_i0 PRJNA382357 100224 242 1.281768 3.10187856 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0362   NR GLE08441.1 114742 g99485 i0 49 1.26446280991736 51 25 63.2 1 169 17 95 144 GLE08441.1 hypothetical protein PINS_up019624 [Pythium insidiosum] diamond 306 42.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
28149068 28149068 PRJNA382357_P_NODE_29185_length_417_cov_3.382022_g28447_i0 PRJNA382357 29185 417 3.382022 14.10303174 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 48.9 0.00157   NR KAH9135198.1 100861 g28447 i0 54 2.70503597122302 50 15 35.3 3 269 415 371 413 KAH9135198.1 hypothetical protein AeRB84_019288, partial [Aphanomyces euteiches] diamond 1128 48.9 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
28323645 28323645 PRJNA382357_P_NODE_170186_length_171_cov_10.945455_g169447_i0 PRJNA382357 170186 171 10.945455 18.71672805 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 51.6 1.01e-5   NR CAI5725615.1 86335 g169447 i0 75 21.859649122807 32 8 56.1 0 76 171 12 43 CAI5725615.1 unnamed protein product [Peronospora destructor] diamond 3738 52 0.992307692307692 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
28323654 28323654 PRJNA382357_P_NODE_73906_length_276_cov_5.567442_g73167_i0 PRJNA382357 73906 276 5.567442 15.36613992 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 52.4 1.45e-5   NR KAE8895929.1 53985 g73167 i0 29.1 3.98913043478261 86 60 92.4 1 261 7 90 175 KAE8895929.1 hypothetical protein PF003_g20301 [Phytophthora fragariae] diamond 1101 52.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariae
28717378 28717378 PRJNA382357_P_NODE_62107_length_298_cov_1.814346_g61368_i0 PRJNA382357 62107 298 1.814346 5.40675108 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.0052   NR XP_009517659.1 67593 g61368 i0 37.2 0.865771812080537 86 46 82.6 2 297 52 104 185 XP_009517659.1 hypothetical protein PHYSODRAFT_295194 [Phytophthora sojae] diamond 258 45.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
30991501 30991501 PRJNA382357_P_NODE_81534_length_265_cov_0.955882_g80795_i0 PRJNA382357 81534 265 0.955882 2.5330873 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 70.9 2.66e-12   NR KAH9130186.1 100861 g80795 i0 37.9 0.984905660377358 87 54 98.5 0 3 263 67 153 KAH9130186.1 hypothetical protein LEN26_008771 [Aphanomyces euteiches] diamond 261 70.9 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
32083535 32083535 PRJNA382357_P_NODE_15558_length_548_cov_2.357290_g14832_i0 PRJNA382357 15558 548 2.35729 12.9179492 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 68.2 1.05e-9   NR TMW56144.1 41045 g14832 i0 36.4 2.02007299270073 77 48 41.6 1 2 229 350 426 TMW56144.1 hypothetical protein Poli38472_008792 [Pythium oligandrum] diamond 1107 68.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
32193268 32193268 PRJNA382357_P_NODE_75058_length_275_cov_0.836449_g74319_i0 PRJNA382357 75058 275 0.836449 2.30023475 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 90.1 1.23e-18   NR KAF0764089.1 112090 g74319 i0 46.7 12.5454545454545 90 48 98.2 0 5 274 468 557 KAF0764089.1 hypothetical protein AaE_003119 [Aphanomyces astaci] diamond 3450 90.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
32446509 32446509 PRJNA382357_P_NODE_16719_length_532_cov_3.452229_g15991_i0 PRJNA382357 16719 532 3.452229 18.36585828 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 87.4 1.89e-16   NR KAF0716977.1 120398 g15991 i0 52.5 2.2612781954887202 80 38 45.1 0 290 529 132 211 KAF0716977.1 hypothetical protein As57867_002556 [Aphanomyces stellatus] diamond 1203 87.4 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
32635499 32635499 PRJNA382357_P_NODE_125280_length_218_cov_2.961783_g124541_i0 PRJNA382357 125280 218 2.961783 6.45668694 Phytophthora fragariaefolia 1490495 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0202   NR GMF21590.1 1490495 g124541 i0 50 0.55045871559633 40 17 50.9 1 4 114 96 135 GMF21590.1 unnamed protein product [Phytophthora fragariaefolia] diamond 120 43.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariaefolia
32761677 32761677 PRJNA382357_P_NODE_120720_length_222_cov_6.055901_g119981_i0 PRJNA382357 120720 222 6.055901 13.44410022 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 47.4 6.26e-4   NR KAH9110027.1 100861 g119981 i0 54.8 1.37837837837838 31 14 41.9 0 74 166 273 303 KAH9110027.1 hypothetical protein AeMF1_015055, partial [Aphanomyces euteiches] diamond 306 47.4 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
32887533 32887533 PRJNA382357_P_NODE_30700_length_408_cov_1.377522_g29961_i0 PRJNA382357 30700 408 1.377522 5.62028976 Phytophthora citrophthora 4793 SAR_Eukaryotes SAR_Eukaryotes 61.2 7.98e-8   NR KAK1945575.1 4793 g29961 i0 38.8 0.588235294117647 80 43 54.4 2 168 389 339 418 KAK1945575.1 putative E3 ubiquitin-protein ligase HERC2 [Phytophthora citrophthora] diamond 240 61.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora citrophthora

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