contig_metadata
16 rows where bioproject = "PRJEB25789" and tax_phylum = "Oomycota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23258 | 23258 | PRJEB25789_S_NODE_4021_length_438_cov_4.665753_g3942_i0 | PRJEB25789 | 4021 | 438 | 4.665753 | 20.43599814 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 77 | 4.43e-15 | NR | DBA03679.1 | 4803 | g3942 | i0 | 61.3 | 3.8972602739726 | 62 | 24 | 42.5 | 0 | 40 | 225 | 1 | 62 | DBA03679.1 TPA: hypothetical protein N0F65_004096 [Lagenidium giganteum] | diamond | 1707 | 77 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 2573051 | 2573051 | PRJEB25789_S_NODE_1703_length_636_cov_3.676732_g1625_i0 | PRJEB25789 | 1703 | 636 | 3.676732 | 23.38401552 | root | 1 | Root_unresolved | Root_unresolved | 328 | 2.4599999999999992e-107 | NR | KAF1774507.1 | 29920 | g1625 | i0 | 79.6 | 106.63679245283 | 206 | 42 | 97.2 | 0 | 3 | 620 | 322 | 527 | KAF1774507.1 P-loop containing nucleoside triphosphate hydrolase [Phytophthora cactorum] | diamond | 67821 | 331 | 0.990936555891239 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 2573158 | 2573158 | PRJEB25789_S_NODE_4163_length_432_cov_1.495822_g4084_i0 | PRJEB25789 | 4163 | 432 | 1.495822 | 6.46195104 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 2.64e-53 | NR | RHZ16721.1 | 112090 | g4084 | i0 | 66.4 | 9.09027777777778 | 131 | 43 | 90.3 | 1 | 431 | 42 | 147 | 277 | RHZ16721.1 hypothetical protein DYB31_004085 [Aphanomyces astaci] | diamond | 3927 | 187 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 5125523 | 5125523 | PRJEB25789_S_NODE_14745_length_263_cov_1.215789_g14666_i0 | PRJEB25789 | 14745 | 263 | 1.215789 | 3.19752507 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 3.69e-60 | NTclustered | gi|2794921736|ref|XM_067881102.1| | 164328 | g14666 | i0 | 84.553 | 5.77186311787072 | 246 | 38 | 94 | 0 | 17 | 262 | 834 | 589 | Phytophthora ramorum Succinate--CoA ligase [ADP-forming] subunit alpha (KRP23_10630), partial mRNA | blastn | 1518 | 244 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 5125530 | 5125530 | PRJEB25789_S_NODE_15225_length_259_cov_3.166667_g15146_i0 | PRJEB25789 | 15225 | 259 | 3.166667 | 8.20166753 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 9.65e-36 | NR | KAF0743747.1 | 100861 | g15146 | i0 | 70.2 | 6.78764478764479 | 84 | 25 | 97.3 | 0 | 3 | 254 | 2 | 85 | KAF0743747.1 hypothetical protein Ae201684_001401 [Aphanomyces euteiches] | diamond | 1758 | 128 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 14051370 | 14051370 | PRJEB25789_S_NODE_20212_length_239_cov_7.234940_g20133_i0 | PRJEB25789 | 20212 | 239 | 7.23494 | 17.2915066 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 2.5699999999999997e-56 | NTclustered | gi|301098381|ref|XM_002898238.1| | 403677 | g20133 | i0 | 86.047 | 85.9874476987448 | 215 | 30 | 90 | 0 | 20 | 234 | 79 | 293 | Phytophthora infestans T30-4 actin-like protein (PITG_15117), mRNA | blastn | 20551 | 231 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 21700064 | 21700064 | PRJEB25789_S_NODE_9178_length_315_cov_1.561983_g9099_i0 | PRJEB25789 | 9178 | 315 | 1.561983 | 4.92024645 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 1.7700000000000003e-21 | NR | DBA03690.1 | 4803 | g9099 | i0 | 58 | 4.58095238095238 | 88 | 35 | 81.9 | 1 | 56 | 313 | 228 | 315 | DBA03690.1 TPA: hypothetical protein N0F65_004107 [Lagenidium giganteum] | diamond | 1443 | 97.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 25212754 | 25212754 | PRJEB25789_S_NODE_20760_length_218_cov_5.489655_g20681_i0 | PRJEB25789 | 20760 | 218 | 5.489655 | 11.9674479 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 2.96e-60 | NTclustered | gi|164508134|emb|AM412176.1| | 4785 | g20681 | i0 | 87.037 | 99.0871559633027 | 216 | 28 | 99 | 0 | 1 | 216 | 477 | 262 | Phytophthora cinnamomi act2 gene for actin, strain Pr120 | blastn | 21601 | 244 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 29363710 | 29363710 | PRJEB25789_S_NODE_11349_length_291_cov_1.587156_g11270_i0 | PRJEB25789 | 11349 | 291 | 1.587156 | 4.61862396 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 4.88e-29 | NR | XP_024580396.1 | 4781 | g11270 | i0 | 55.3 | 17.4329896907216 | 94 | 42 | 96.9 | 0 | 283 | 2 | 24 | 117 | XP_024580396.1 Actin-binding protein Coronin, contains WD40 repeats [Plasmopara halstedii] | diamond | 5073 | 119 | 0.991596638655462 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 29647358 | 29647358 | PRJEB25789_S_NODE_15430_length_258_cov_1.664865_g15351_i0 | PRJEB25789 | 15430 | 258 | 1.664865 | 4.2953517 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 8.76e-38 | NR | XP_067794467.1 | 4785 | g15351 | i0 | 73.8 | 7.83720930232558 | 84 | 22 | 97.7 | 0 | 253 | 2 | 19 | 102 | XP_067794467.1 60S ribosomal protein L30 [Phytophthora cinnamomi] | diamond | 2022 | 132 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 30033295 | 30033295 | PRJEB25789_S_NODE_6691_length_355_cov_2.393617_g6612_i0 | PRJEB25789 | 6691 | 355 | 2.393617 | 8.49734035 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 3.57e-16 | NR | KAL0592358.1 | 65357 | g6612 | i0 | 42.1 | 2.45915492957746 | 95 | 52 | 80.3 | 1 | 66 | 350 | 23 | 114 | KAL0592358.1 hypothetical protein ABG067_000466 [Albugo candida] | diamond | 873 | 79 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 32208104 | 32208104 | PRJEB25789_S_NODE_5078_length_397_cov_1.901235_g4999_i0 | PRJEB25789 | 5078 | 397 | 1.901235 | 7.54790295 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 155 | 8.679999999999999e-43 | NR | KAF0738261.1 | 100861 | g4999 | i0 | 65.1 | 7.6095717884131 | 126 | 43 | 95.2 | 1 | 384 | 7 | 252 | 376 | KAF0738261.1 hypothetical protein Ae201684_005821 [Aphanomyces euteiches] | diamond | 3021 | 156 | 0.993589743589744 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 32277979 | 32277979 | PRJEB25789_S_NODE_19859_length_241_cov_1.988095_g19780_i0 | PRJEB25789 | 19859 | 241 | 1.988095 | 4.79130895 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 3.75e-27 | NR | OQR99210.1 | 1202772 | g19780 | i0 | 70.9 | 4.56846473029046 | 79 | 20 | 94.6 | 1 | 2 | 229 | 47 | 125 | OQR99210.1 60S ribosomal protein L22 [Achlya hypogyna] | diamond | 1101 | 105 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 32625415 | 32625415 | PRJEB25789_S_NODE_9900_length_306_cov_1.695279_g9821_i0 | PRJEB25789 | 9900 | 306 | 1.695279 | 5.18755374 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 3.37e-36 | NR | XP_008616217.1 | 1156394 | g9821 | i0 | 75 | 0.666666666666667 | 68 | 17 | 66.7 | 0 | 238 | 35 | 10 | 77 | XP_008616217.1 hypothetical protein SDRG_11941 [Saprolegnia diclina VS20] | diamond | 204 | 127 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 32720022 | 32720022 | PRJEB25789_S_NODE_12580_length_280_cov_1.169082_g12501_i0 | PRJEB25789 | 12580 | 280 | 1.169082 | 3.2734296 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 79.7 | 3.89e-16 | NR | OQS01523.1 | 1202772 | g12501 | i0 | 45.1 | 1.75714285714286 | 82 | 45 | 87.9 | 0 | 14 | 259 | 57 | 138 | OQS01523.1 hypothetical protein ACHHYP_00702 [Achlya hypogyna] | diamond | 492 | 79.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 32776459 | 32776459 | PRJEB25789_S_NODE_3300_length_477_cov_2.042079_g3221_i0 | PRJEB25789 | 3300 | 477 | 2.042079 | 9.74071683 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 6.609999999999999e-32 | NR | XP_009521283.1 | 67593 | g3221 | i0 | 50.3 | 2.74213836477987 | 145 | 69 | 90.6 | 3 | 1 | 432 | 539 | 681 | XP_009521283.1 heme peroxidase [Phytophthora sojae] | diamond | 1308 | 130 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae |
Advanced export
JSON shape: default, array, newline-delimited
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);;