contig_metadata
19 rows where bioproject = "PRJNA534016" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1118183 | 1118183 | PRJNA534016_P_NODE_3641_length_429_cov_7.117978_g3551_i0 | PRJNA534016 | 3641 | 429 | 7.117978 | 30.53612562 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 2.37e-34 | NTclustered | gi|2311026826|gb|OP554785.1| | 4798 | g3551 | i0 | 88.722 | 33.3263403263403 | 133 | 11 | 30 | 3 | 301 | 429 | 497 | 365 | Pythium hydnosporum isolate R-28 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 14297 | 159 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium hydnosporum | ||
| 4334345 | 4334345 | PRJNA534016_P_NODE_10364_length_276_cov_1.807882_g10274_i0 | PRJNA534016 | 10364 | 276 | 1.807882 | 4.98975432 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.41e-54 | NTclustered | gi|2794923360|ref|XM_067881981.1| | 164328 | g10274 | i0 | 89.011 | 66.2463768115942 | 182 | 20 | 66 | 0 | 91 | 272 | 1 | 182 | Phytophthora ramorum Calmodulin (KRP23_11430), partial mRNA | blastn | 18284 | 226 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 7496353 | 7496353 | PRJNA534016_P_NODE_12086_length_263_cov_1.100000_g11996_i0 | PRJNA534016 | 12086 | 263 | 1.1 | 2.893 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 8.099999999999998e-47 | NTclustered | gi|195970350|gb|EU880228.1| | 67593 | g11996 | i0 | 80.46 | 79.2167300380228 | 261 | 51 | 99 | 0 | 1 | 261 | 414 | 154 | Phytophthora sojae calmodulin (CAM1) mRNA, complete cds | blastn | 20834 | 200 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 14536312 | 14536312 | PRJNA534016_P_NODE_16212_length_246_cov_0.849711_g16122_i0 | PRJNA534016 | 16212 | 246 | 0.849711 | 2.09028906 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.65e-33 | NTclustered | gi|166038151|emb|CU349819.1| | 100861 | g16122 | i0 | 78.723 | 31.7682926829268 | 235 | 48 | 95 | 2 | 13 | 246 | 796 | 563 | Aphanomyces euteiches cDNA | blastn | 7815 | 156 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 17084931 | 17084931 | PRJNA534016_P_NODE_16334_length_245_cov_1.267442_g16244_i0 | PRJNA534016 | 16334 | 245 | 1.267442 | 3.1052329 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.1e-37 | NTclustered | gi|166035576|emb|CU354455.1| | 100861 | g16244 | i0 | 88.489 | 34.4979591836735 | 139 | 16 | 57 | 0 | 107 | 245 | 842 | 704 | Aphanomyces euteiches cDNA | blastn | 8452 | 169 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 18359047 | 18359047 | PRJNA534016_P_NODE_2635_length_503_cov_2.023256_g2545_i0 | PRJNA534016 | 2635 | 503 | 2.023256 | 10.17697768 | Achlya ambisexualis | 4768 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 5.6e-91 | NTclustered | gi|22086549|gb|AF402100.1| | 4768 | g2545 | i0 | 80.042 | 69.272365805169 | 476 | 90 | 94 | 5 | 19 | 491 | 1424 | 951 | Achlya ambisexualis isolate JS854 heat shock protein Hsp90 mRNA, complete cds | blastn | 34844 | 348 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya ambisexualis | ||
| 18359082 | 18359082 | PRJNA534016_P_NODE_5375_length_358_cov_1.421053_g5285_i0 | PRJNA534016 | 5375 | 358 | 1.421053 | 5.08736974 | Phytophthora cactorum | 29920 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 7.53e-61 | NR | KAG6952591.1 | 29920 | g5285 | i0 | 79.6 | 11.8743016759777 | 113 | 23 | 94.7 | 0 | 348 | 10 | 1 | 113 | KAG6952591.1 hypothetical protein JG687_00012914, partial [Phytophthora cactorum] | diamond | 4251 | 196 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 26776435 | 26776435 | PRJNA534016_P_NODE_9541_length_283_cov_0.961905_g9451_i0 | PRJNA534016 | 9541 | 283 | 0.961905 | 2.72219115 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 5.0799999999999996e-24 | NR | CCA17716.1 | 890382 | g9451 | i0 | 50 | 4.98233215547703 | 94 | 47 | 99.6 | 0 | 2 | 283 | 215 | 308 | CCA17716.1 transcription elongation factor putative [Albugo laibachii Nc14] | diamond | 1410 | 102 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 27014443 | 27014443 | PRJNA534016_P_NODE_10882_length_272_cov_1.437186_g10792_i0 | PRJNA534016 | 10882 | 272 | 1.437186 | 3.90914592 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 6.92e-7 | NR | KAF0715055.1 | 120398 | g10792 | i0 | 45.3 | 0.584558823529412 | 53 | 29 | 58.5 | 0 | 35 | 193 | 373 | 425 | KAF0715055.1 hypothetical protein As57867_003581, partial [Aphanomyces stellatus] | diamond | 159 | 56.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 27345805 | 27345805 | PRJNA534016_P_NODE_9143_length_286_cov_1.197183_g9053_i0 | PRJNA534016 | 9143 | 286 | 1.197183 | 3.42394338 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 8.21e-15 | NR | RQM14163.1 | 112090 | g9053 | i0 | 47.6 | 3.49300699300699 | 82 | 43 | 86 | 0 | 248 | 3 | 233 | 314 | RQM14163.1 hypothetical protein B5M09_009726 [Aphanomyces astaci] | diamond | 999 | 80.1 | 0.990012484394507 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 28025425 | 28025425 | PRJNA534016_P_NODE_8445_length_292_cov_1.853881_g8355_i0 | PRJNA534016 | 8445 | 292 | 1.853881 | 5.41333252 | Phytophthora palmivora | 4796 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 8.14e-4 | NR | POM72966.1 | 4796 | g8355 | i0 | 49 | 0.503424657534247 | 49 | 25 | 50.3 | 0 | 208 | 62 | 112 | 160 | POM72966.1 26S proteasome non-ATPase regulatory subunit [Phytophthora palmivora] | diamond | 147 | 47.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 29840001 | 29840001 | PRJNA534016_P_NODE_4571_length_386_cov_2.099042_g4481_i0 | PRJNA534016 | 4571 | 386 | 2.099042 | 8.10230212 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 256 | 1.45e-80 | NR | DBA03280.1 | 4803 | g4481 | i0 | 98.4 | 50.7124352331606 | 128 | 2 | 99.5 | 0 | 3 | 386 | 4 | 131 | DBA03280.1 TPA: hypothetical protein N0F65_011639 [Lagenidium giganteum] | diamond | 19575 | 256 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 29888418 | 29888418 | PRJNA534016_P_NODE_5091_length_367_cov_1.309524_g5001_i0 | PRJNA534016 | 5091 | 367 | 1.309524 | 4.80595308 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 3.56e-14 | NR | KAG1699552.1 | 4784 | g5001 | i0 | 51.4 | 1.71662125340599 | 74 | 34 | 58.9 | 2 | 6 | 221 | 115 | 188 | KAG1699552.1 hypothetical protein DVH05_012963 [Phytophthora capsici] | diamond | 630 | 75.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 30109358 | 30109358 | PRJNA534016_P_NODE_6132_length_338_cov_1.950943_g6042_i0 | PRJNA534016 | 6132 | 338 | 1.950943 | 6.59418734 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 1.23e-36 | NR | KAG1709295.1 | 4784 | g6042 | i0 | 69.2 | 5.53846153846154 | 104 | 28 | 92.3 | 1 | 1 | 312 | 607 | 706 | KAG1709295.1 hypothetical protein DVH05_019938 [Phytophthora capsici] | diamond | 1872 | 142 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 30471995 | 30471995 | PRJNA534016_P_NODE_12453_length_260_cov_1.320856_g12363_i0 | PRJNA534016 | 12453 | 260 | 1.320856 | 3.4342256 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 6.15e-30 | NR | KAI9998566.1 | 4787 | g12363 | i0 | 69.8 | 5.95384615384615 | 86 | 26 | 99.2 | 0 | 259 | 2 | 36 | 121 | KAI9998566.1 hypothetical protein PInf_003115 [Phytophthora infestans] | diamond | 1548 | 113 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 31009001 | 31009001 | PRJNA534016_P_NODE_18174_length_241_cov_0.916667_g18084_i0 | PRJNA534016 | 18174 | 241 | 0.916667 | 2.20916747 | root | 1 | Root_unresolved | Root_unresolved | 61.6 | 8.16e-10 | NR | OQR90783.1 | 74557 | g18084 | i0 | 54.4 | 1.40663900414938 | 57 | 25 | 69.7 | 1 | 68 | 235 | 5 | 61 | OQR90783.1 hypothetical protein THRCLA_22512 [Thraustotheca clavata] | diamond | 339 | 62 | 0.993548387096774 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 31040859 | 31040859 | PRJNA534016_P_NODE_15435_length_247_cov_1.212644_g15345_i0 | PRJNA534016 | 15435 | 247 | 1.212644 | 2.99523068 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1.1399999999999999e-23 | NR | RHY08398.1 | 112090 | g15345 | i0 | 73.1 | 2.84210526315789 | 78 | 21 | 94.7 | 0 | 235 | 2 | 3 | 80 | RHY08398.1 hypothetical protein DYB25_006691, partial [Aphanomyces astaci] | diamond | 702 | 104 | 0.990384615384615 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 31088826 | 31088826 | PRJNA534016_P_NODE_12995_length_255_cov_2.362637_g12905_i0 | PRJNA534016 | 12995 | 255 | 2.362637 | 6.02472435 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 1.66e-25 | NR | GLD95580.1 | 114742 | g12905 | i0 | 73.9 | 1.62352941176471 | 69 | 18 | 81.2 | 0 | 2 | 208 | 413 | 481 | GLD95580.1 hypothetical protein PINS_up004257 [Pythium insidiosum] | diamond | 414 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 32354376 | 32354376 | PRJNA534016_P_NODE_17259_length_243_cov_1.005882_g17169_i0 | PRJNA534016 | 17259 | 243 | 1.005882 | 2.44429326 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 1.05e-6 | NR | KAH9085172.1 | 100861 | g17169 | i0 | 44.4 | 1 | 81 | 35 | 98.8 | 3 | 3 | 242 | 28 | 99 | KAH9085172.1 hypothetical protein LEN26_020601 [Aphanomyces euteiches] | diamond | 243 | 55.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;