contig_metadata
25 rows where bioproject = "PRJNA857857", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2120869 | 2120869 | PRJNA857857_P_NODE_6122_length_628_cov_3.019820_g5702_i0 | PRJNA857857 | 6122 | 628 | 3.01982 | 18.9644696 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 2.5399999999999996e-32 | NR | KAL0587684.1 | 65357 | g5702 | i0 | 55.7 | 2.75636942675159 | 115 | 44 | 54.9 | 2 | 372 | 28 | 26 | 133 | KAL0587684.1 hypothetical protein ABG067_002703 [Albugo candida] | diamond | 1731 | 125 | 0.992 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 9773105 | 9773105 | PRJNA857857_P_NODE_32728_length_268_cov_3.015385_g32279_i0 | PRJNA857857 | 32728 | 268 | 3.015385 | 8.0812318 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 3.23e-17 | NR | CCI45616.1 | 65357 | g32279 | i0 | 79.2 | 7.89179104477612 | 48 | 10 | 53.7 | 0 | 250 | 107 | 4 | 51 | CCI45616.1 unnamed protein product [Albugo candida] | diamond | 2115 | 78.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 11048285 | 11048285 | PRJNA857857_P_NODE_1209_length_1260_cov_6.088458_g989_i0 | PRJNA857857 | 1209 | 1260 | 6.088458 | 76.7145708 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 1.33e-78 | NR | KAI9989638.1 | 4787 | g989 | i0 | 56.6 | 10.3357142857143 | 249 | 102 | 59.3 | 1 | 1260 | 514 | 28 | 270 | KAI9989638.1 hypothetical protein PInf_019923 [Phytophthora infestans] | diamond | 13023 | 256 | 0.9921875 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 11048402 | 11048402 | PRJNA857857_P_NODE_19349_length_356_cov_1.897527_g18901_i0 | PRJNA857857 | 19349 | 356 | 1.897527 | 6.75519612 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 2.19e-44 | NR | CAH0479183.1 | 622444 | g18901 | i0 | 82 | 17.4859550561798 | 100 | 18 | 84.3 | 0 | 52 | 351 | 1 | 100 | CAH0479183.1 unnamed protein product [Peronospora belbahrii] | diamond | 6225 | 159 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora belbahrii | ||
| 12715334 | 12715334 | PRJNA857857_P_NODE_39650_length_249_cov_0.875000_g39201_i0 | PRJNA857857 | 39650 | 249 | 0.875 | 2.17875 | Nothophytophthora sp. Chile5 | 2483409 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 1.28e-39 | NR | RLN92416.1 | 2483409 | g39201 | i0 | 70.7 | 3.92771084337349 | 82 | 24 | 98.8 | 0 | 3 | 248 | 16 | 97 | RLN92416.1 hypothetical protein BBJ28_00022396 [Nothophytophthora sp. Chile5] | diamond | 978 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Nothophytophthora | Nothophytophthora sp. Chile5 | ||
| 16148236 | 16148236 | PRJNA857857_P_NODE_9233_length_514_cov_1.190476_g8802_i0 | PRJNA857857 | 9233 | 514 | 1.190476 | 6.11904664 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 1.39e-7 | NTclustered | gi|325196873|emb|FR827661.1| | 890382 | g8802 | i0 | 100 | 13.0739299610895 | 38 | 0 | 7 | 0 | 467 | 504 | 65 | 28 | Albugo laibachii Nc14, genomic contig CONTIG_4828_NC14_v4_162_619 | blastn | 6720 | 71.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 25070873 | 25070873 | PRJNA857857_P_NODE_18100_length_369_cov_1.375000_g17652_i0 | PRJNA857857 | 18100 | 369 | 1.375 | 5.07375 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 4.99e-115 | NTclustered | gi|2795021165|ref|XM_067935669.1| | 4785 | g17652 | i0 | 92.617 | 18.6693766937669 | 298 | 21 | 80 | 1 | 1 | 297 | 317 | 20 | Phytophthora cinnamomi ATP synthase subunit beta, mitochondrial (IUM83_11126), partial mRNA | blastn | 6889 | 427 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 27157766 | 27157766 | PRJNA857857_P_NODE_48482_length_243_cov_0.905882_g48033_i0 | PRJNA857857 | 48482 | 243 | 0.905882 | 2.20129326 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 1.74e-27 | NR | KAG1689475.1 | 4784 | g48033 | i0 | 59.3 | 19.9012345679012 | 81 | 33 | 100 | 0 | 243 | 1 | 38 | 118 | KAG1689475.1 Protein MAK16 A [Phytophthora capsici] | diamond | 4836 | 111 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 27442760 | 27442760 | PRJNA857857_P_NODE_45043_length_245_cov_1.191860_g44594_i0 | PRJNA857857 | 45043 | 245 | 1.19186 | 2.920057 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 5.66e-18 | NR | CCI48387.1 | 65357 | g44594 | i0 | 63.9 | 2.98775510204082 | 61 | 20 | 74.7 | 1 | 60 | 242 | 269 | 327 | CCI48387.1 unnamed protein product [Albugo candida] | diamond | 732 | 87 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 28129072 | 28129072 | PRJNA857857_P_NODE_43185_length_247_cov_0.885057_g42736_i0 | PRJNA857857 | 43185 | 247 | 0.885057 | 2.18609079 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 7.26e-9 | NR | XP_009523249.1 | 67593 | g42736 | i0 | 58.2 | 0.959514170040486 | 79 | 32 | 96 | 1 | 245 | 9 | 181 | 258 | XP_009523249.1 hypothetical protein PHYSODRAFT_543878 [Phytophthora sojae] | diamond | 237 | 61.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 28665824 | 28665824 | PRJNA857857_P_NODE_23507_length_322_cov_1.232932_g23058_i0 | PRJNA857857 | 23507 | 322 | 1.232932 | 3.97004104 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 1.2300000000000002e-21 | NR | OQS02943.1 | 74557 | g23058 | i0 | 50.9 | 2.03105590062112 | 110 | 49 | 99.7 | 2 | 322 | 2 | 340 | 447 | OQS02943.1 U3 small nucleolar ribonucleoprotein [Thraustotheca clavata] | diamond | 654 | 99.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 29360384 | 29360384 | PRJNA857857_P_NODE_19869_length_351_cov_1.661871_g19420_i0 | PRJNA857857 | 19869 | 351 | 1.661871 | 5.83316721 | Phytophthora lilii | 2077276 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 4.75e-6 | NR | GMF27689.1 | 2077276 | g19420 | i0 | 43 | 1.64957264957265 | 79 | 44 | 66.7 | 1 | 117 | 350 | 111 | 189 | GMF27689.1 unnamed protein product [Phytophthora lilii] | diamond | 579 | 55.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora lilii | ||
| 30000189 | 30000189 | PRJNA857857_P_NODE_33391_length_265_cov_1.203125_g32942_i0 | PRJNA857857 | 33391 | 265 | 1.203125 | 3.18828125 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 1.14e-11 | NR | KAK1947202.1 | 4793 | g32942 | i0 | 36.9 | 10.2452830188679 | 103 | 47 | 96.2 | 2 | 265 | 11 | 126 | 228 | KAK1947202.1 Actin-fragmin kinase [Phytophthora citrophthora] | diamond | 2715 | 70.5 | 0.994326241134752 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 30560360 | 30560360 | PRJNA857857_P_NODE_12853_length_439_cov_7.032787_g12408_i0 | PRJNA857857 | 12853 | 439 | 7.032787 | 30.87393493 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 2.75e-58 | NR | OQR92500.1 | 1202772 | g12408 | i0 | 63.8 | 9.45102505694761 | 138 | 50 | 94.3 | 0 | 26 | 439 | 36 | 173 | OQR92500.1 ribosomal protein L27 [Achlya hypogyna] | diamond | 4149 | 189 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 30568478 | 30568478 | PRJNA857857_P_NODE_16633_length_385_cov_2.137821_g16186_i0 | PRJNA857857 | 16633 | 385 | 2.137821 | 8.23061085 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 86.7 | 3.71e-19 | NR | XP_067814465.1 | 4779 | g16186 | i0 | 48.5 | 2.37662337662338 | 103 | 51 | 79.5 | 2 | 59 | 364 | 1 | 102 | XP_067814465.1 uncharacterized protein CCR75_006070 [Bremia lactucae] | diamond | 915 | 86.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 30750246 | 30750246 | PRJNA857857_P_NODE_32974_length_267_cov_1.587629_g32525_i0 | PRJNA857857 | 32974 | 267 | 1.587629 | 4.23896943 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 3.19e-26 | NR | TMW56879.1 | 41045 | g32525 | i0 | 59.1 | 1.04494382022472 | 93 | 34 | 100 | 2 | 267 | 1 | 141 | 233 | TMW56879.1 hypothetical protein Poli38472_006889 [Pythium oligandrum] | diamond | 279 | 111 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 30821569 | 30821569 | PRJNA857857_P_NODE_8454_length_535_cov_1.248918_g8025_i0 | PRJNA857857 | 8454 | 535 | 1.248918 | 6.6817113 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 5.22e-24 | NR | TMW62552.1 | 41045 | g8025 | i0 | 37 | 3 | 181 | 100 | 96.4 | 4 | 6 | 521 | 190 | 365 | TMW62552.1 hypothetical protein Poli38472_005170 [Pythium oligandrum] | diamond | 1605 | 109 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31200235 | 31200235 | PRJNA857857_P_NODE_28155_length_291_cov_2.674312_g27706_i0 | PRJNA857857 | 28155 | 291 | 2.674312 | 7.78224792 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 5.8e-36 | NR | DAZ99584.1 | 4803 | g27706 | i0 | 73 | 46.1030927835052 | 89 | 24 | 91.8 | 0 | 272 | 6 | 95 | 183 | DAZ99584.1 TPA: hypothetical protein N0F65_001412 [Lagenidium giganteum] | diamond | 13416 | 139 | 0.992805755395683 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 31477354 | 31477354 | PRJNA857857_P_NODE_43976_length_246_cov_0.890173_g43527_i0 | PRJNA857857 | 43976 | 246 | 0.890173 | 2.18982558 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 1.39e-4 | NR | TMW63286.1 | 41045 | g43527 | i0 | 40 | 0.975609756097561 | 80 | 47 | 97.6 | 1 | 3 | 242 | 378 | 456 | TMW63286.1 hypothetical protein Poli38472_002227 [Pythium oligandrum] | diamond | 240 | 49.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31572226 | 31572226 | PRJNA857857_P_NODE_16216_length_391_cov_0.864780_g15769_i0 | PRJNA857857 | 16216 | 391 | 0.86478 | 3.3812898 | Saprolegnia parasitica CBS 223.65 | 695850 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 1.36e-10 | NR | XP_012197006.1 | 695850 | g15769 | i0 | 32.2 | 0.90537084398977 | 118 | 75 | 87.5 | 3 | 388 | 47 | 534 | 650 | XP_012197006.1 hypothetical protein SPRG_03035 [Saprolegnia parasitica CBS 223.65] | diamond | 354 | 68.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 31611918 | 31611918 | PRJNA857857_P_NODE_31976_length_272_cov_1.160804_g31527_i0 | PRJNA857857 | 31976 | 272 | 1.160804 | 3.15738688 | root | 1 | Root_unresolved | Root_unresolved | 74.3 | 3.98e-13 | NR | XP_008862995.1 | 157072 | g31527 | i0 | 40.7 | 3.9375 | 91 | 53 | 99.3 | 1 | 270 | 1 | 387 | 477 | XP_008862995.1 hypothetical protein H310_01616 [Aphanomyces invadans] | diamond | 1071 | 74.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 31635244 | 31635244 | PRJNA857857_P_NODE_36596_length_251_cov_0.865169_g36147_i0 | PRJNA857857 | 36596 | 251 | 0.865169 | 2.17157419 | Phytophthora palmivora | 4796 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 7.26e-5 | NR | POM60513.1 | 4796 | g36147 | i0 | 47.1 | 2.43824701195219 | 51 | 20 | 56.2 | 2 | 6 | 146 | 169 | 216 | POM60513.1 hypothetical protein PHPALM_30627 [Phytophthora palmivora] | diamond | 612 | 50.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 31698576 | 31698576 | PRJNA857857_P_NODE_13917_length_422_cov_1.323782_g13471_i0 | PRJNA857857 | 13917 | 422 | 1.323782 | 5.58636004 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 9.17e-36 | NR | TMW65555.1 | 41045 | g13471 | i0 | 60.9 | 3.8175355450237 | 133 | 49 | 93.1 | 3 | 6 | 398 | 700 | 831 | TMW65555.1 hypothetical protein Poli38472_008197 [Pythium oligandrum] | diamond | 1611 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 32371330 | 32371330 | PRJNA857857_P_NODE_21499_length_337_cov_1.617424_g21050_i0 | PRJNA857857 | 21499 | 337 | 1.617424 | 5.45071888 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 6.08e-7 | NR | OQR99579.1 | 74557 | g21050 | i0 | 40.6 | 6.31157270029674 | 69 | 41 | 61.4 | 0 | 39 | 245 | 1316 | 1384 | OQR99579.1 hypothetical protein THRCLA_06454 [Thraustotheca clavata] | diamond | 2127 | 57.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 32781276 | 32781276 | PRJNA857857_P_NODE_44540_length_246_cov_0.890173_g44091_i0 | PRJNA857857 | 44540 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 3.22e-6 | NR | KAG9399817.1 | 112091 | g44091 | i0 | 32.3 | 8.13414634146342 | 93 | 50 | 97.6 | 2 | 242 | 3 | 56 | 148 | KAG9399817.1 GATOR complex protein wdr59 [Aphanomyces cochlioides] | diamond | 2001 | 54.7 | 0.992687385740402 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides |
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);;