contig_metadata
20 rows where bioproject = "PRJNA971676" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2542160 | 2542160 | PRJNA971676_P_NODE_3762_length_411_cov_1.822485_g3673_i0 | PRJNA971676 | 3762 | 411 | 1.822485 | 7.49041335 | root | 1 | Root_unresolved | Root_unresolved | 222 | 9.199999999999999e-69 | NR | TMW60420.1 | 41045 | g3673 | i0 | 79.7 | 8.76642335766423 | 133 | 27 | 97.1 | 0 | 400 | 2 | 1 | 133 | TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] | diamond | 3603 | 223 | 0.995515695067265 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 3495385 | 3495385 | PRJNA971676_P_NODE_2483_length_487_cov_1.857488_g2394_i0 | PRJNA971676 | 2483 | 487 | 1.857488 | 9.04596656 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 3.37e-63 | NTclustered | gi|675207712|ref|XM_008914493.1| | 761204 | g2394 | i0 | 79.515 | 96.3326488706365 | 371 | 66 | 75 | 8 | 47 | 412 | 393 | 28 | Phytophthora parasitica INRA-310 hsp70-like protein partial mRNA | blastn | 46914 | 255 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 3818414 | 3818414 | PRJNA971676_P_NODE_19343_length_245_cov_0.895349_g19254_i0 | PRJNA971676 | 19343 | 245 | 0.895349 | 2.19360505 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 4.62e-24 | NTclustered | gi|2795061008|ref|XM_067940276.1| | 4785 | g19254 | i0 | 80.745 | 28.1102040816327 | 161 | 29 | 65 | 2 | 5 | 164 | 360 | 201 | Phytophthora cinnamomi 60S ribosomal protein L23a (IUM83_15460), partial mRNA | blastn | 6887 | 124 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 11148198 | 11148198 | PRJNA971676_P_NODE_1649_length_586_cov_1.200780_g1562_i0 | PRJNA971676 | 1649 | 586 | 1.20078 | 7.0365708 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 4.989999999999999e-107 | NTclustered | gi|1219685856|gb|KY965925.1| | 1440116 | g1562 | i0 | 80.556 | 80.598976109215 | 540 | 89 | 90 | 15 | 16 | 544 | 203 | 737 | Lagenidium giganteum f. caninum isolate UF15-01 heat shock protein 90 (hsp90) gene, partial cds | blastn | 47231 | 401 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 13698300 | 13698300 | PRJNA971676_P_NODE_19051_length_246_cov_0.890173_g18962_i0 | PRJNA971676 | 19051 | 246 | 0.890173 | 2.18982558 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.2399999999999997e-54 | NTclustered | gi|695448559|ref|XM_009536718.1| | 67593 | g18962 | i0 | 83.74 | 67.6626016260163 | 246 | 32 | 99 | 6 | 1 | 245 | 630 | 868 | Phytophthora sojae ATP synthase beta subunit mRNA | blastn | 16645 | 226 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 17522915 | 17522915 | PRJNA971676_P_NODE_9834_length_288_cov_1.074419_g9745_i0 | PRJNA971676 | 9834 | 288 | 1.074419 | 3.09432672 | Phytophthora hydrogena | 1286608 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 8.93e-52 | NTclustered | gi|1233050041|gb|KX252277.1| | 1286608 | g9745 | i0 | 85.167 | 72.6354166666667 | 209 | 31 | 73 | 0 | 23 | 231 | 222 | 14 | Phytophthora hydrogena isolate 44G8(authentic) heat shock protein 90 gene, partial cds | blastn | 20919 | 217 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora hydrogena | ||
| 27221635 | 27221635 | PRJNA971676_P_NODE_21082_length_243_cov_1.358824_g20993_i0 | PRJNA971676 | 21082 | 243 | 1.358824 | 3.30194232 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 2.66e-30 | NR | KAF1793757.1 | 29920 | g20993 | i0 | 71.3 | 4.9382716049382704 | 80 | 23 | 98.8 | 0 | 2 | 241 | 95 | 174 | KAF1793757.1 Alpha-D-phosphohexomutase, conserved site [Phytophthora cactorum] | diamond | 1200 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 27664277 | 27664277 | PRJNA971676_P_NODE_23584_length_241_cov_0.916667_g23495_i0 | PRJNA971676 | 23584 | 241 | 0.916667 | 2.20916747 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 4.82e-30 | NR | KAL4144394.1 | 164328 | g23495 | i0 | 67.5 | 12.9460580912863 | 80 | 26 | 99.6 | 0 | 241 | 2 | 627 | 706 | KAL4144394.1 hypothetical protein PRNP1_013527 [Phytophthora ramorum] | diamond | 3120 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 27815896 | 27815896 | PRJNA971676_P_NODE_12804_length_260_cov_1.016043_g12715_i0 | PRJNA971676 | 12804 | 260 | 1.016043 | 2.6417118 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 7.34e-31 | NR | KAH9108398.1 | 100861 | g12715 | i0 | 82.6 | 0.796153846153846 | 69 | 12 | 79.6 | 0 | 258 | 52 | 412 | 480 | KAH9108398.1 hypothetical protein AeMF1_016428 [Aphanomyces euteiches] | diamond | 207 | 123 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 28194388 | 28194388 | PRJNA971676_P_NODE_21586_length_243_cov_0.905882_g21497_i0 | PRJNA971676 | 21586 | 243 | 0.905882 | 2.20129326 | Phytophthora nicotianae P1569 | 1317065 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0367 | NR | ETI45668.1 | 1317065 | g21497 | i0 | 35.2 | 0.666666666666667 | 54 | 30 | 60.5 | 1 | 90 | 236 | 479 | 532 | ETI45668.1 hypothetical protein F443_09813 [Phytophthora nicotianae P1569] | diamond | 162 | 42.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 28358591 | 28358591 | PRJNA971676_P_NODE_22286_length_242_cov_0.911243_g22197_i0 | PRJNA971676 | 22286 | 242 | 0.911243 | 2.20520806 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.07e-29 | NR | KAJ8578052.1 | 4785 | g22197 | i0 | 66.7 | 6.44628099173554 | 75 | 25 | 93 | 0 | 225 | 1 | 117 | 191 | KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] | diamond | 1560 | 115 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 29558426 | 29558426 | PRJNA971676_P_NODE_23550_length_241_cov_0.916667_g23461_i0 | PRJNA971676 | 23550 | 241 | 0.916667 | 2.20916747 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 1.49e-5 | NR | POM57982.1 | 4796 | g23461 | i0 | 38.5 | 11.3153526970954 | 78 | 44 | 94.6 | 2 | 13 | 240 | 722 | 797 | POM57982.1 ATP-binding cassette (ABC) Superfamily, partial [Phytophthora palmivora] | diamond | 2727 | 52.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 29621223 | 29621223 | PRJNA971676_P_NODE_6090_length_344_cov_1.431734_g6001_i0 | PRJNA971676 | 6090 | 344 | 1.431734 | 4.92516496 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.66e-47 | NR | RHY06028.1 | 112090 | g6001 | i0 | 75.5 | 9.29651162790698 | 106 | 25 | 92.4 | 1 | 27 | 344 | 18 | 122 | RHY06028.1 hypothetical protein DYB25_001794 [Aphanomyces astaci] | diamond | 3198 | 159 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 30000793 | 30000793 | PRJNA971676_P_NODE_10131_length_285_cov_1.452830_g10042_i0 | PRJNA971676 | 10131 | 285 | 1.45283 | 4.1405655 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.04e-31 | NR | KAF0727574.1 | 100861 | g10042 | i0 | 56.4 | 27.0842105263158 | 101 | 35 | 96.8 | 1 | 277 | 2 | 22 | 122 | KAF0727574.1 hypothetical protein Ae201684_014402 [Aphanomyces euteiches] | diamond | 7719 | 120 | 0.991666666666667 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 30506249 | 30506249 | PRJNA971676_P_NODE_9593_length_290_cov_1.419355_g9504_i0 | PRJNA971676 | 9593 | 290 | 1.419355 | 4.1161295 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 3.3e-7 | NR | KAG7399116.1 | 109152 | g9504 | i0 | 51.4 | 3.32068965517241 | 72 | 33 | 72.4 | 1 | 212 | 3 | 17 | 88 | KAG7399116.1 Nucleoside diphosphate kinase III, chloroplastic/mitochondrial [Phytophthora boehmeriae] | diamond | 963 | 57 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora boehmeriae | ||
| 30917104 | 30917104 | PRJNA971676_P_NODE_18514_length_246_cov_0.890173_g18425_i0 | PRJNA971676 | 18514 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 5.68e-9 | NR | KAF1334756.1 | 82926 | g18425 | i0 | 50 | 6.67073170731707 | 58 | 29 | 70.7 | 0 | 48 | 221 | 75 | 132 | KAF1334756.1 Rpsu-divergently transcribed protein, partial [Globisporangium splendens] | diamond | 1641 | 62.4 | 0.993589743589744 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 31637710 | 31637710 | PRJNA971676_P_NODE_19376_length_245_cov_0.895349_g19287_i0 | PRJNA971676 | 19376 | 245 | 0.895349 | 2.19360505 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 9.42e-7 | NR | OQR99310.1 | 74557 | g19287 | i0 | 41.1 | 1.44489795918367 | 56 | 29 | 68.6 | 1 | 238 | 71 | 123 | 174 | OQR99310.1 hypothetical protein THRCLA_06565 [Thraustotheca clavata] | diamond | 354 | 55.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 31992005 | 31992005 | PRJNA971676_P_NODE_20258_length_244_cov_0.900585_g20169_i0 | PRJNA971676 | 20258 | 244 | 0.900585 | 2.1974274 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00781 | NR | KAG1692675.1 | 4784 | g20169 | i0 | 38.2 | 1.45081967213115 | 68 | 34 | 83.6 | 1 | 206 | 3 | 278 | 337 | KAG1692675.1 hypothetical protein DVH05_025153 [Phytophthora capsici] | diamond | 354 | 44.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 32403471 | 32403471 | PRJNA971676_P_NODE_9879_length_287_cov_1.827103_g9790_i0 | PRJNA971676 | 9879 | 287 | 1.827103 | 5.24378561 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.32e-23 | NR | DAZ94307.1 | 4803 | g9790 | i0 | 63.6 | 5.38327526132404 | 77 | 28 | 80.5 | 0 | 232 | 2 | 92 | 168 | DAZ94307.1 TPA: hypothetical protein N0F65_012076 [Lagenidium giganteum] | diamond | 1545 | 102 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 32744420 | 32744420 | PRJNA971676_P_NODE_11480_length_272_cov_1.547739_g11391_i0 | PRJNA971676 | 11480 | 272 | 1.547739 | 4.20985008 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 1.1099999999999999e-23 | NR | XP_009840131.1 | 112090 | g11391 | i0 | 48.3 | 0.981617647058823 | 89 | 46 | 98.2 | 0 | 268 | 2 | 47 | 135 | XP_009840131.1 hypothetical protein, variant [Aphanomyces astaci] | diamond | 267 | 99.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci |
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);;