contig_metadata
25 rows where bioproject = "PRJNA454503", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2992923 | 2992923 | PRJNA454503_P_NODE_2903_length_704_cov_4.617418_g2609_i0 | PRJNA454503 | 2903 | 704 | 4.617418 | 32.50662272 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 1205 | 0 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g2609 | i0 | 97.589 | 100.026988636364 | 705 | 13 | 100 | 4 | 1 | 704 | 716 | 15 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 70419 | 1205 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 4269855 | 4269855 | PRJNA454503_P_NODE_78364_length_204_cov_0.909091_g78035_i0 | PRJNA454503 | 78364 | 204 | 0.909091 | 1.85454564 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 3.69e-29 | NTclustered | gi|675204844|ref|XM_008913059.1| | 761204 | g78035 | i0 | 84.932 | 1.40686274509804 | 146 | 15 | 72 | 4 | 2 | 147 | 537 | 675 | Phytophthora parasitica INRA-310 ribosomal protein S4 mRNA | blastn | 287 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 8095358 | 8095358 | PRJNA454503_P_NODE_26747_length_244_cov_2.114754_g26418_i0 | PRJNA454503 | 26747 | 244 | 2.114754 | 5.15999976 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 7.6900000000000005e-22 | NTclustered | gi|189084883|gb|BT032414.1| | 4784 | g26418 | i0 | 83.594 | 0.524590163934426 | 128 | 17 | 51 | 2 | 3 | 127 | 671 | 797 | Phytophthora capsici clone CBOU93-B03 mRNA sequence | blastn | 128 | 117 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 8095933 | 8095933 | PRJNA454503_P_NODE_7247_length_418_cov_1.792717_g6918_i0 | PRJNA454503 | 7247 | 418 | 1.792717 | 7.49355706 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 181 | 1.4599999999999997e-52 | NR | XP_067822856.1 | 4779 | g6918 | i0 | 72.9 | 16.9377990430622 | 140 | 37 | 99.8 | 1 | 2 | 418 | 2 | 141 | XP_067822856.1 hypothetical protein CCR75_007112 [Bremia lactucae] | diamond | 7080 | 182 | 0.994505494505495 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 8746597 | 8746597 | PRJNA454503_P_NODE_26467_length_245_cov_1.413043_g26138_i0 | PRJNA454503 | 26467 | 245 | 1.413043 | 3.46195535 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 3.35e-70 | NTclustered | gi|695412177|ref|XM_009527379.1| | 67593 | g26138 | i0 | 87.243 | 7.08163265306122 | 243 | 31 | 99 | 0 | 1 | 243 | 260 | 18 | Phytophthora sojae hypothetical protein mRNA | blastn | 1735 | 278 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 10021834 | 10021834 | PRJNA454503_P_NODE_26028_length_246_cov_3.178378_g25699_i0 | PRJNA454503 | 26028 | 246 | 3.178378 | 7.81880988 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 5.76e-53 | NTclustered | gi|813144478|ref|XM_012344373.1| | 695850 | g25699 | i0 | 87.435 | 10.1260162601626 | 191 | 24 | 78 | 0 | 1 | 191 | 489 | 679 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein mRNA | blastn | 2491 | 220 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 14470664 | 14470664 | PRJNA454503_P_NODE_12752_length_318_cov_1.494163_g12423_i0 | PRJNA454503 | 12752 | 318 | 1.494163 | 4.75143834 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 1.02e-36 | NTclustered | gi|813118806|ref|XM_012340678.1| | 695850 | g12423 | i0 | 90.476 | 1.16037735849057 | 126 | 12 | 40 | 0 | 193 | 318 | 354 | 229 | Saprolegnia parasitica CBS 223.65 50S ribosomal protein L36e mRNA | blastn | 369 | 167 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 17019385 | 17019385 | PRJNA454503_P_NODE_16374_length_288_cov_2.035242_g16045_i0 | PRJNA454503 | 16374 | 288 | 2.035242 | 5.86149696 | Pythium sp. AP | 378252 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 1.3499999999999993e-119 | NTclustered | gi|90855438|dbj|AB254193.1| | 378252 | g16045 | i0 | 95.956 | 71.6666666666667 | 272 | 11 | 94 | 0 | 17 | 288 | 1 | 272 | Pythium sp. AP genes for 28S rRNA, IGS, 5S rRNA, partial and complete sequence, strain: AP-1, AP-2 and AP-3 | blastn | 20640 | 442 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium sp. AP | ||
| 17019963 | 17019963 | PRJNA454503_P_NODE_54794_length_211_cov_0.866667_g54465_i0 | PRJNA454503 | 54794 | 211 | 0.866667 | 1.82866737 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 1.01e-14 | NR | KAG3138711.1 | 53986 | g54465 | i0 | 67.3 | 5.23222748815166 | 52 | 16 | 73.9 | 1 | 159 | 4 | 5 | 55 | KAG3138711.1 hypothetical protein PI126_g16794 [Phytophthora idaei] | diamond | 1104 | 73.2 | 0.994535519125683 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora idaei | ||
| 19568656 | 19568656 | PRJNA454503_P_NODE_796_length_1287_cov_15.225122_g605_i0 | PRJNA454503 | 796 | 1287 | 15.225122 | 195.94732014 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 2244 | 0 | NTclustered | gi|937408816|ref|NC_027966.1| | 114742 | g605 | i0 | 98.135 | 103.869463869464 | 1287 | 24 | 100 | 0 | 1 | 1287 | 11293 | 10007 | Pythium insidiosum mitochondrial DNA, complete genome | blastn | 133680 | 2244 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 20844347 | 20844347 | PRJNA454503_P_NODE_59477_length_210_cov_0.872483_g59148_i0 | PRJNA454503 | 59477 | 210 | 0.872483 | 1.8322143 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 6.39e-27 | NR | KAF0741867.1 | 100861 | g59148 | i0 | 77.9 | 6.8 | 68 | 15 | 97.1 | 0 | 209 | 6 | 331 | 398 | KAF0741867.1 hypothetical protein Ae201684_003058 [Aphanomyces euteiches] | diamond | 1428 | 112 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 20844574 | 20844574 | PRJNA454503_P_NODE_81317_length_203_cov_0.915493_g80988_i0 | PRJNA454503 | 81317 | 203 | 0.915493 | 1.85845079 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 1.25e-68 | NTclustered | gi|695405971|ref|XM_009525682.1| | 67593 | g80988 | i0 | 92.593 | 78.7241379310345 | 189 | 14 | 93 | 0 | 13 | 201 | 446 | 258 | Phytophthora sojae hypothetical protein mRNA | blastn | 15981 | 272 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 20844667 | 20844667 | PRJNA454503_P_NODE_89477_length_190_cov_3.023256_g89148_i0 | PRJNA454503 | 89477 | 190 | 3.023256 | 5.7441864 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.4399999999999997e-92 | NTclustered | gi|338798212|gb|HQ665273.1| | 114742 | g89148 | i0 | 100 | 100.147368421053 | 190 | 0 | 100 | 0 | 1 | 190 | 801 | 990 | Pythium insidiosum isolate CBS 574.85 28S large subunit ribosomal RNA gene, partial sequence | blastn | 19028 | 351 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 23395076 | 23395076 | PRJNA454503_P_NODE_7759_length_404_cov_1.137026_g7430_i0 | PRJNA454503 | 7759 | 404 | 1.137026 | 4.59358504 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 4.7e-46 | NTclustered | gi|695460914|ref|XM_009539807.1| | 67593 | g7430 | i0 | 91.608 | 35.7772277227723 | 143 | 12 | 35 | 0 | 1 | 143 | 212 | 354 | Phytophthora sojae hypothetical protein mRNA | blastn | 14454 | 198 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 27138958 | 27138958 | PRJNA454503_P_NODE_23482_length_255_cov_1.335052_g23153_i0 | PRJNA454503 | 23482 | 255 | 1.335052 | 3.4043826 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 2.14e-18 | NR | RLO03635.1 | 112090 | g23153 | i0 | 59.3 | 6.07058823529412 | 86 | 31 | 98.8 | 2 | 254 | 3 | 405 | 488 | RLO03635.1 hypothetical protein DYB28_007879, partial [Aphanomyces astaci] | diamond | 1548 | 89 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 28055137 | 28055137 | PRJNA454503_P_NODE_62325_length_209_cov_0.878378_g61996_i0 | PRJNA454503 | 62325 | 209 | 0.878378 | 1.83581002 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 8.19e-13 | NR | OQR90288.1 | 1202772 | g61996 | i0 | 66.7 | 0.688995215311005 | 48 | 16 | 68.9 | 0 | 59 | 202 | 378 | 425 | OQR90288.1 cyclin-dependent kinase [Achlya hypogyna] | diamond | 144 | 72.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 28513505 | 28513505 | PRJNA454503_P_NODE_79127_length_204_cov_0.909091_g78798_i0 | PRJNA454503 | 79127 | 204 | 0.909091 | 1.85454564 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 2.25e-7 | NR | KAH9101306.1 | 100861 | g78798 | i0 | 50 | 2 | 68 | 31 | 95.6 | 3 | 203 | 9 | 40 | 107 | KAH9101306.1 hypothetical protein LEN26_015734 [Aphanomyces euteiches] | diamond | 408 | 57 | 0.992982456140351 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 29492255 | 29492255 | PRJNA454503_P_NODE_74730_length_205_cov_0.902778_g74401_i0 | PRJNA454503 | 74730 | 205 | 0.902778 | 1.8506949 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 3.42e-6 | NR | KAF1773501.1 | 29920 | g74401 | i0 | 39.4 | 5.76585365853659 | 66 | 40 | 96.6 | 0 | 3 | 200 | 172 | 237 | KAF1773501.1 Eukaryotic porin/Tom40 [Phytophthora cactorum] | diamond | 1182 | 53.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 29918329 | 29918329 | PRJNA454503_P_NODE_56571_length_211_cov_0.866667_g56242_i0 | PRJNA454503 | 56571 | 211 | 0.866667 | 1.82866737 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 4.28e-25 | NR | KAJ0407353.1 | 114742 | g56242 | i0 | 100 | 0.725118483412322 | 51 | 0 | 72.5 | 0 | 211 | 59 | 1802 | 1852 | KAJ0407353.1 hypothetical protein P43SY_004781 [Pythium insidiosum] | diamond | 153 | 107 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 30076025 | 30076025 | PRJNA454503_P_NODE_15412_length_295_cov_1.666667_g15083_i0 | PRJNA454503 | 15412 | 295 | 1.666667 | 4.91666765 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 3.96e-8 | NR | KAG1709295.1 | 4784 | g15083 | i0 | 61.5 | 2.11525423728814 | 52 | 16 | 52.9 | 1 | 3 | 158 | 659 | 706 | KAG1709295.1 hypothetical protein DVH05_019938 [Phytophthora capsici] | diamond | 624 | 60.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 30865953 | 30865953 | PRJNA454503_P_NODE_68014_length_207_cov_0.890411_g67685_i0 | PRJNA454503 | 68014 | 207 | 0.890411 | 1.84315077 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 2.48e-8 | NR | XP_008618430.1 | 1156394 | g67685 | i0 | 42 | 1 | 69 | 40 | 100 | 0 | 207 | 1 | 566 | 634 | XP_008618430.1 hypothetical protein SDRG_14101 [Saprolegnia diclina VS20] | diamond | 207 | 59.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 31909462 | 31909462 | PRJNA454503_P_NODE_56537_length_211_cov_0.866667_g56208_i0 | PRJNA454503 | 56537 | 211 | 0.866667 | 1.82866737 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 2.64e-36 | NR | KAJ0409454.1 | 114742 | g56208 | i0 | 100 | 1.99052132701422 | 70 | 0 | 99.5 | 0 | 1 | 210 | 1090 | 1159 | KAJ0409454.1 hypothetical protein P43SY_002344 [Pythium insidiosum] | diamond | 420 | 139 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 32004418 | 32004418 | PRJNA454503_P_NODE_35978_length_232_cov_1.081871_g35649_i0 | PRJNA454503 | 35978 | 232 | 1.081871 | 2.50994072 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 7.62e-12 | NR | OQS03481.1 | 74557 | g35649 | i0 | 45.5 | 1.99137931034483 | 77 | 38 | 99.6 | 2 | 231 | 1 | 444 | 516 | OQS03481.1 urease, partial [Thraustotheca clavata] | diamond | 462 | 70.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 32479194 | 32479194 | PRJNA454503_P_NODE_19959_length_269_cov_0.937500_g19630_i0 | PRJNA454503 | 19959 | 269 | 0.9375 | 2.521875 | Peronosclerospora sorghi | 230839 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 2.69e-13 | NR | KAI9908711.1 | 230839 | g19630 | i0 | 51.6 | 0.713754646840149 | 64 | 31 | 71.4 | 0 | 231 | 40 | 3 | 66 | KAI9908711.1 hypothetical protein PsorP6_004016 [Peronosclerospora sorghi] | diamond | 192 | 69.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 32542507 | 32542507 | PRJNA454503_P_NODE_13199_length_314_cov_1.023715_g12870_i0 | PRJNA454503 | 13199 | 314 | 1.023715 | 3.2144651 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 5.56e-7 | NR | TYZ62469.1 | 1485010 | g12870 | i0 | 41.1 | 0.697452229299363 | 73 | 34 | 69.7 | 2 | 252 | 34 | 44 | 107 | TYZ62469.1 hypothetical protein PybrP1_005590 [[Pythium] brassicae (nom. inval.)] | diamond | 219 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) |
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);;