contig_metadata
26 rows where bioproject = "PRJNA788929", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 769006 | 769006 | PRJNA788929_P_NODE_10821_length_537_cov_18.424569_g10168_i0 | PRJNA788929 | 10821 | 537 | 18.424569 | 98.93993553 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 789 | 0 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g10168 | i0 | 98.441 | 92.4320297951583 | 449 | 6 | 84 | 1 | 1 | 449 | 448 | 1 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 49636 | 789 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 2045535 | 2045535 | PRJNA788929_P_NODE_45742_length_225_cov_11.322368_g45081_i0 | PRJNA788929 | 45742 | 225 | 11.322368 | 25.475328 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 359 | 1.0499999999999999e-94 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g45081 | i0 | 98.522 | 97.8488888888889 | 203 | 3 | 90 | 0 | 2 | 204 | 3844 | 3642 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 22016 | 359 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 4597853 | 4597853 | PRJNA788929_P_NODE_46444_length_221_cov_5.621622_g45783_i0 | PRJNA788929 | 46444 | 221 | 5.621622 | 12.42378462 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.16e-25 | NTclustered | gi|533310373|ref|NC_022179.1| | 74557 | g45783 | i0 | 84.211 | 12.420814479638 | 133 | 19 | 60 | 2 | 60 | 191 | 4965 | 5096 | Thraustotheca clavata mitochondrion, complete genome | blastn | 2745 | 128 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 7147837 | 7147837 | PRJNA788929_P_NODE_2926_length_1222_cov_47.370757_g2551_i0 | PRJNA788929 | 2926 | 1222 | 47.370757 | 578.87065054 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 1938 | 0 | NTclustered | gi|937408816|ref|NC_027966.1| | 114742 | g2551 | i0 | 95.775 | 102.805237315876 | 1207 | 42 | 98 | 5 | 25 | 1222 | 11635 | 10429 | Pythium insidiosum mitochondrial DNA, complete genome | blastn | 125628 | 1938 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 8422807 | 8422807 | PRJNA788929_P_NODE_50087_length_198_cov_4.024000_g49426_i0 | PRJNA788929 | 50087 | 198 | 4.024 | 7.96752 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 3.850000000000001e-21 | NR | TMW61843.1 | 41045 | g49426 | i0 | 83.3 | 2.21212121212121 | 48 | 8 | 72.7 | 0 | 24 | 167 | 153 | 200 | TMW61843.1 hypothetical protein Poli38472_010906 [Pythium oligandrum] | diamond | 438 | 91.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 9697741 | 9697741 | PRJNA788929_P_NODE_34908_length_263_cov_7.463158_g34247_i0 | PRJNA788929 | 34908 | 263 | 7.463158 | 19.62810554 | Saprolegnia ferax | 4770 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 3.41e-115 | NTclustered | gi|50261276|ref|NC_005984.1| | 4770 | g34247 | i0 | 98.361 | 98.4828897338403 | 244 | 2 | 92 | 1 | 22 | 263 | 9338 | 9581 | Saprolegnia ferax mitochondrion, complete genome | blastn | 25901 | 427 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia ferax | ||
| 10973616 | 10973616 | PRJNA788929_P_NODE_4509_length_950_cov_83.014823_g3981_i0 | PRJNA788929 | 4509 | 950 | 83.014823 | 788.6408185 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 297 | 3.75e-97 | NR | XP_008871544.1 | 157072 | g3981 | i0 | 65.9 | 1.48736842105263 | 217 | 74 | 68.5 | 0 | 186 | 836 | 39 | 255 | XP_008871544.1 40S ribosomal protein S2 [Aphanomyces invadans] | diamond | 1413 | 297 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 10973701 | 10973701 | PRJNA788929_P_NODE_5949_length_793_cov_57.219444_g5345_i0 | PRJNA788929 | 5949 | 793 | 57.219444 | 453.75019092 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 6.200000000000001e-28 | NR | XP_024584662.1 | 4781 | g5345 | i0 | 48 | 0.575031525851198 | 152 | 62 | 54.1 | 4 | 59 | 487 | 10 | 153 | XP_024584662.1 rna binding [Plasmopara halstedii] | diamond | 456 | 117 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 12249292 | 12249292 | PRJNA788929_P_NODE_9090_length_603_cov_82.871698_g8439_i0 | PRJNA788929 | 9090 | 603 | 82.871698 | 499.71633894 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 221 | 3.31e-70 | NR | KAI9994045.1 | 4787 | g8439 | i0 | 74 | 11.6716417910448 | 131 | 34 | 65.2 | 0 | 536 | 144 | 56 | 186 | KAI9994045.1 hypothetical protein PInf_016604 [Phytophthora infestans] | diamond | 7038 | 223 | 0.991031390134529 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 12693844 | 12693844 | PRJNA788929_P_NODE_20570_length_360_cov_6.797909_g19910_i0 | PRJNA788929 | 20570 | 360 | 6.797909 | 24.4724724 | Hyaloperonospora | 184462 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 1.14e-51 | NTclustered | gi|33520224|gb|AY273969.1| | 123356 | g19910 | i0 | 94.928 | 39.7361111111111 | 138 | 7 | 38 | 0 | 26 | 163 | 404 | 541 | Hyaloperonospora parasitica large subunit ribosomal RNA gene, partial sequence | blastn | 14305 | 219 | 0.990867579908676 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 14798360 | 14798360 | PRJNA788929_P_NODE_8092_length_651_cov_60.826990_g7446_i0 | PRJNA788929 | 8092 | 651 | 60.82699 | 395.9837049 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 221 | 6.02e-70 | NR | KAI9994045.1 | 4787 | g7446 | i0 | 74 | 10.8110599078341 | 131 | 34 | 60.4 | 0 | 584 | 192 | 56 | 186 | KAI9994045.1 hypothetical protein PInf_016604 [Phytophthora infestans] | diamond | 7038 | 223 | 0.991031390134529 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 16517008 | 16517008 | PRJNA788929_P_NODE_12173_length_498_cov_11.847059_g11516_i0 | PRJNA788929 | 12173 | 498 | 11.847059 | 58.99835382 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 584 | 3.879999999999999e-162 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g11516 | i0 | 90.044 | 52.8895582329317 | 452 | 43 | 91 | 2 | 48 | 498 | 41411 | 41861 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 26339 | 584 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 18620572 | 18620572 | PRJNA788929_P_NODE_12395_length_492_cov_1.847255_g11738_i0 | PRJNA788929 | 12395 | 492 | 1.847255 | 9.0884946 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 151 | 6.489999999999999e-43 | NR | YP_009167024.1 | 114742 | g11738 | i0 | 82.5 | 1.18292682926829 | 97 | 17 | 59.1 | 0 | 180 | 470 | 100 | 196 | YP_009167024.1 ribosomal protein S2 [Pythium insidiosum] | diamond | 582 | 151 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 19896178 | 19896178 | PRJNA788929_P_NODE_29576_length_290_cov_19.281106_g28915_i0 | PRJNA788929 | 29576 | 290 | 19.281106 | 55.9152074 | Aphanomyces laevis | 112092 | SAR_Eukaryotes | SAR_Eukaryotes | 496 | 1.03e-135 | NTclustered | gi|17224981|gb|AF320584.1| | 112092 | g28915 | i0 | 100 | 92.8275862068966 | 268 | 0 | 92 | 0 | 1 | 268 | 990 | 723 | Aphanomyces laevis 28S ribosomal RNA gene, partial sequence | blastn | 26920 | 496 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces laevis | ||
| 19896573 | 19896573 | PRJNA788929_P_NODE_8456_length_632_cov_24.334526_g7808_i0 | PRJNA788929 | 8456 | 632 | 24.334526 | 153.79420432 | Phytophthora andina | 283009 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 4.419999999999999e-68 | NTclustered | gi|334701739|ref|NC_015619.1| | 283009 | g7808 | i0 | 77.874 | 72.9382911392405 | 461 | 86 | 72 | 13 | 118 | 570 | 21819 | 22271 | Phytophthora andina mitochondrion, complete genome | blastn | 46097 | 272 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora andina | ||
| 26800480 | 26800480 | PRJNA788929_P_NODE_6081_length_784_cov_26.651195_g5472_i0 | PRJNA788929 | 6081 | 784 | 26.651195 | 208.9453688 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 376 | 8.439999999999998e-125 | NR | KAF0692573.1 | 120398 | g5472 | i0 | 71.4 | 0.895408163265306 | 234 | 67 | 89.5 | 0 | 762 | 61 | 338 | 571 | KAF0692573.1 hypothetical protein As57867_016328 [Aphanomyces stellatus] | diamond | 702 | 376 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 27401481 | 27401481 | PRJNA788929_P_NODE_23863_length_329_cov_12.289062_g23202_i0 | PRJNA788929 | 23863 | 329 | 12.289062 | 40.43101398 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 6.64e-4 | NR | KAF0719325.1 | 120398 | g23202 | i0 | 38.7 | 1.08510638297872 | 119 | 48 | 85.7 | 7 | 308 | 27 | 383 | 501 | KAF0719325.1 hypothetical protein As57867_001108, partial [Aphanomyces stellatus] | diamond | 357 | 48.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 28096007 | 28096007 | PRJNA788929_P_NODE_9585_length_582_cov_52.844794_g8933_i0 | PRJNA788929 | 9585 | 582 | 52.844794 | 307.55670108 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 3.66e-8 | NR | OQS05425.1 | 74557 | g8933 | i0 | 33.6 | 0.597938144329897 | 116 | 73 | 58.2 | 2 | 19 | 357 | 277 | 391 | OQS05425.1 CDP-alcohol phosphatidyltransferase [Thraustotheca clavata] | diamond | 348 | 63.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 29336654 | 29336654 | PRJNA788929_P_NODE_5149_length_876_cov_45.499377_g4571_i0 | PRJNA788929 | 5149 | 876 | 45.499377 | 398.57454252 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 2.03e-36 | NR | KAF0682950.1 | 120398 | g4571 | i0 | 39.8 | 4.32534246575342 | 201 | 120 | 68.8 | 1 | 777 | 175 | 14 | 213 | KAF0682950.1 hypothetical protein As57867_024885 [Aphanomyces stellatus] | diamond | 3789 | 146 | 0.993150684931507 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 30758119 | 30758119 | PRJNA788929_P_NODE_6494_length_750_cov_43.782866_g5874_i0 | PRJNA788929 | 6494 | 750 | 43.782866 | 328.371495 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 7.27e-22 | NR | KAG3097867.1 | 53986 | g5874 | i0 | 36.2 | 4.852 | 149 | 92 | 59.2 | 3 | 617 | 174 | 100 | 246 | KAG3097867.1 hypothetical protein PI125_g15513 [Phytophthora idaei] | diamond | 3639 | 101 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora idaei | ||
| 31769637 | 31769637 | PRJNA788929_P_NODE_28577_length_296_cov_10.224215_g27916_i0 | PRJNA788929 | 28577 | 296 | 10.224215 | 30.2636764 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 7.42e-9 | NR | KAI9989638.1 | 4787 | g27916 | i0 | 81 | 1.7027027027027 | 42 | 8 | 42.6 | 0 | 269 | 144 | 230 | 271 | KAI9989638.1 hypothetical protein PInf_019923 [Phytophthora infestans] | diamond | 504 | 62 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 31927831 | 31927831 | PRJNA788929_P_NODE_25117_length_319_cov_21.373984_g24456_i0 | PRJNA788929 | 25117 | 319 | 21.373984 | 68.18300896 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 4.54e-4 | NR | KAK1946366.1 | 4793 | g24456 | i0 | 57.9 | 1.06269592476489 | 38 | 16 | 35.7 | 0 | 302 | 189 | 200 | 237 | KAK1946366.1 Ubiquitin carboxyl-terminal hydrolase 3 [Phytophthora citrophthora] | diamond | 339 | 49.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 32045260 | 32045260 | PRJNA788929_P_NODE_38538_length_249_cov_11.732955_g37877_i0 | PRJNA788929 | 38538 | 249 | 11.732955 | 29.21505795 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 1.08e-5 | NR | OQR81488.1 | 74557 | g37877 | i0 | 56.4 | 0.469879518072289 | 39 | 17 | 47 | 0 | 206 | 90 | 78 | 116 | OQR81488.1 hypothetical protein THRCLA_23360, partial [Thraustotheca clavata] | diamond | 117 | 50.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 32108458 | 32108458 | PRJNA788929_P_NODE_23178_length_335_cov_21.541985_g22517_i0 | PRJNA788929 | 23178 | 335 | 21.541985 | 72.16564975 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 9.12e-38 | NR | KAH9110449.1 | 100861 | g22517 | i0 | 83.8 | 0.662686567164179 | 74 | 12 | 66.3 | 0 | 285 | 64 | 1 | 74 | KAH9110449.1 hypothetical protein AeMF1_014743 [Aphanomyces euteiches] | diamond | 222 | 132 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 32149460 | 32149460 | PRJNA788929_P_NODE_7998_length_656_cov_91.222985_g7353_i0 | PRJNA788929 | 7998 | 656 | 91.222985 | 598.4227816 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 0.0216 | NR | XP_008862755.1 | 157072 | g7353 | i0 | 42.6 | 1.24390243902439 | 54 | 31 | 24.7 | 0 | 333 | 172 | 575 | 628 | XP_008862755.1 hypothetical protein H310_01430 [Aphanomyces invadans] | diamond | 816 | 48.1 | 0.993762993762994 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 32866310 | 32866310 | PRJNA788929_P_NODE_22140_length_345_cov_12.779412_g21479_i0 | PRJNA788929 | 22140 | 345 | 12.779412 | 44.0889714 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 1.02e-10 | NR | TMW69339.1 | 41045 | g21479 | i0 | 52.3 | 2.07826086956522 | 86 | 32 | 67.8 | 3 | 24 | 257 | 366 | 450 | TMW69339.1 hypothetical protein Poli38472_001495 [Pythium oligandrum] | diamond | 717 | 68.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum |
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);;