contig_metadata
19 rows where bioproject = "PRJNA615175" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1149875 | 1149875 | PRJNA615175_P_NODE_6581_length_593_cov_4.526923_g6416_i0 | PRJNA615175 | 6581 | 593 | 4.526923 | 26.84465339 | Hyaloperonospora | 184462 | SAR_Eukaryotes | SAR_Eukaryotes | 1046 | 0 | NTclustered | gi|33520229|gb|AY273974.1| | 162125 | g6416 | i0 | 98.482 | 97.7537942664418 | 593 | 9 | 100 | 0 | 1 | 593 | 657 | 65 | Hyaloperonospora brassicae large subunit ribosomal RNA gene, partial sequence | blastn | 57968 | 1051 | 0.995242626070409 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 4422788 | 4422788 | PRJNA615175_P_NODE_9304_length_485_cov_3.589806_g9136_i0 | PRJNA615175 | 9304 | 485 | 3.589806 | 17.4105591 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 8.18e-38 | NR | KAG9416599.1 | 112091 | g9136 | i0 | 61.7 | 7.83711340206186 | 107 | 41 | 66.2 | 0 | 9 | 329 | 18 | 124 | KAG9416599.1 60S ribosomal protein L22 [Aphanomyces cochlioides] | diamond | 3801 | 136 | 0.992647058823529 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 12628798 | 12628798 | PRJNA615175_P_NODE_15510_length_358_cov_1.410526_g15342_i0 | PRJNA615175 | 15510 | 358 | 1.410526 | 5.04968308 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 2.86e-35 | NR | CCI49799.1 | 65357 | g15342 | i0 | 61.3 | 8.93296089385475 | 106 | 38 | 88.8 | 1 | 352 | 35 | 2 | 104 | CCI49799.1 unnamed protein product [Albugo candida] | diamond | 3198 | 128 | 0.9921875 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 15178151 | 15178151 | PRJNA615175_P_NODE_11792_length_420_cov_3.556196_g11624_i0 | PRJNA615175 | 11792 | 420 | 3.556196 | 14.9360232 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 1.49e-76 | NR | GLE07478.1 | 114742 | g11624 | i0 | 80.7 | 55.1428571428571 | 140 | 27 | 100 | 0 | 1 | 420 | 99 | 238 | GLE07478.1 hypothetical protein PINS_up017838 [Pythium insidiosum] | diamond | 23160 | 239 | 0.99163179916318 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 19001292 | 19001292 | PRJNA615175_P_NODE_7995_length_530_cov_5.520788_g7829_i0 | PRJNA615175 | 7995 | 530 | 5.520788 | 29.2601764 | Hyaloperonospora | 184462 | SAR_Eukaryotes | SAR_Eukaryotes | 881 | 0 | NTclustered | gi|33520229|gb|AY273974.1| | 162125 | g7829 | i0 | 96.958 | 97.9584905660377 | 526 | 15 | 99 | 1 | 1 | 526 | 657 | 133 | Hyaloperonospora brassicae large subunit ribosomal RNA gene, partial sequence | blastn | 51918 | 881 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 20997429 | 20997429 | PRJNA615175_P_NODE_35897_length_235_cov_2.302469_g35729_i0 | PRJNA615175 | 35897 | 235 | 2.302469 | 5.41080215 | Saprolegnia ferax | 4770 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 7.26e-32 | NTclustered | gi|50261276|ref|NC_005984.1| | 4770 | g35729 | i0 | 89.744 | 48.8297872340426 | 117 | 12 | 50 | 0 | 99 | 215 | 31484 | 31368 | Saprolegnia ferax mitochondrion, complete genome | blastn | 11475 | 150 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia ferax | ||
| 24821451 | 24821451 | PRJNA615175_P_NODE_9080_length_492_cov_3.169451_g8912_i0 | PRJNA615175 | 9080 | 492 | 3.169451 | 15.59369892 | Phytophthora quercina | 78236 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 1.59e-61 | NTclustered | gi|2248513480|ref|NC_063806.1| | 78236 | g8912 | i0 | 80.059 | 68.5670731707317 | 341 | 64 | 69 | 4 | 29 | 367 | 21884 | 22222 | Phytophthora quercina isolate ST_201908082014 mitochondrion, complete genome | blastn | 33735 | 250 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora quercina | ||
| 27269899 | 27269899 | PRJNA615175_P_NODE_2963_length_904_cov_4.596871_g2828_i0 | PRJNA615175 | 2963 | 904 | 4.596871 | 41.55571384 | Peronospora destructor | 86335 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 3.39e-14 | NR | CAI5738485.1 | 86335 | g2828 | i0 | 26.5 | 2.03097345132743 | 204 | 143 | 67.4 | 3 | 40 | 648 | 3 | 200 | CAI5738485.1 unnamed protein product [Peronospora destructor] | diamond | 1836 | 83.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora destructor | ||
| 28217051 | 28217051 | PRJNA615175_P_NODE_5866_length_631_cov_5.231183_g5701_i0 | PRJNA615175 | 5866 | 631 | 5.231183 | 33.00876473 | Bremia lactucae | 4779 | SAR_Eukaryotes | SAR_Eukaryotes | 85.5 | 3.11e-15 | NR | XP_067814559.1 | 4779 | g5701 | i0 | 44.5 | 1.13153724247227 | 119 | 62 | 55.2 | 3 | 284 | 631 | 489 | 606 | XP_067814559.1 uncharacterized protein CCR75_002142 [Bremia lactucae] | diamond | 714 | 85.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 28280254 | 28280254 | PRJNA615175_P_NODE_9526_length_477_cov_5.358911_g9358_i0 | PRJNA615175 | 9526 | 477 | 5.358911 | 25.56200547 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.0114 | NR | KAJ8552260.1 | 4785 | g9358 | i0 | 32.2 | 0.742138364779874 | 59 | 40 | 37.1 | 0 | 51 | 227 | 44 | 102 | KAJ8552260.1 hypothetical protein ON010_g10286 [Phytophthora cinnamomi] | diamond | 354 | 45.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 28577634 | 28577634 | PRJNA615175_P_NODE_6867_length_578_cov_7.376238_g6702_i0 | PRJNA615175 | 6867 | 578 | 7.376238 | 42.63465564 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 5.5899999999999995e-30 | NR | OQS06784.1 | 74557 | g6702 | i0 | 49.6 | 3.89792387543253 | 127 | 62 | 65.4 | 2 | 1 | 378 | 66 | 191 | OQS06784.1 hypothetical protein THRCLA_01211 [Thraustotheca clavata] | diamond | 2253 | 122 | 0.991803278688525 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 28911651 | 28911651 | PRJNA615175_P_NODE_448_length_1807_cov_4.688581_g409_i0 | PRJNA615175 | 448 | 1807 | 4.688581 | 84.72265867 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 3.74e-40 | NR | TMW57421.1 | 41045 | g409 | i0 | 51.7 | 0.522966242390703 | 315 | 148 | 51.6 | 2 | 1 | 933 | 182 | 496 | TMW57421.1 hypothetical protein Poli38472_003346 [Pythium oligandrum] | diamond | 945 | 165 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 29082905 | 29082905 | PRJNA615175_P_NODE_6768_length_583_cov_4.454902_g6603_i0 | PRJNA615175 | 6768 | 583 | 4.454902 | 25.97207866 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 2.72e-19 | NR | KAF0712969.1 | 120398 | g6603 | i0 | 50 | 2.41852487135506 | 94 | 46 | 48.4 | 1 | 578 | 297 | 19 | 111 | KAF0712969.1 hypothetical protein As57867_004565, partial [Aphanomyces stellatus] | diamond | 1410 | 90.1 | 0.992230854605993 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 30712153 | 30712153 | PRJNA615175_P_NODE_15954_length_352_cov_4.154122_g15786_i0 | PRJNA615175 | 15954 | 352 | 4.154122 | 14.62250944 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 64.3 | 3.78e-9 | NR | KAG9402873.1 | 112091 | g15786 | i0 | 46.3 | 0.681818181818182 | 80 | 38 | 63.9 | 3 | 309 | 85 | 931 | 1010 | KAG9402873.1 von Willebrand factor A domain-containing protein 8 [Aphanomyces cochlioides] | diamond | 240 | 64.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 30820052 | 30820052 | PRJNA615175_P_NODE_15554_length_357_cov_2.693662_g15386_i0 | PRJNA615175 | 15554 | 357 | 2.693662 | 9.61637334 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 3.12e-29 | NR | KAJ8519167.1 | 4785 | g15386 | i0 | 58.9 | 21.453781512605 | 95 | 39 | 79.8 | 0 | 70 | 354 | 130 | 224 | KAJ8519167.1 hypothetical protein ON010_g18107 [Phytophthora cinnamomi] | diamond | 7659 | 121 | 0.991735537190083 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 31958209 | 31958209 | PRJNA615175_P_NODE_7417_length_554_cov_2.804574_g7252_i0 | PRJNA615175 | 7417 | 554 | 2.804574 | 15.53733996 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 6.3e-4 | NR | KAI9987183.1 | 4787 | g7252 | i0 | 45.9 | 4.79783393501805 | 61 | 31 | 31.9 | 1 | 301 | 125 | 24 | 84 | KAI9987183.1 hypothetical protein PInf_023151 [Phytophthora infestans] | diamond | 2658 | 49.3 | 0.991886409736308 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 32230237 | 32230237 | PRJNA615175_P_NODE_3898_length_788_cov_5.717483_g3747_i0 | PRJNA615175 | 3898 | 788 | 5.717483 | 45.05376604 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.2799999999999997e-31 | NR | TYZ62746.1 | 1485010 | g3747 | i0 | 41.1 | 0.704314720812183 | 185 | 101 | 70.1 | 3 | 219 | 770 | 136 | 313 | TYZ62746.1 hypothetical protein PybrP1_000187 [[Pythium] brassicae (nom. inval.)] | diamond | 555 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 32842765 | 32842765 | PRJNA615175_P_NODE_11620_length_424_cov_2.330484_g11452_i0 | PRJNA615175 | 11620 | 424 | 2.3304840000000002 | 9.88125216 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 1.54e-8 | NR | KAG6972716.1 | 29920 | g11452 | i0 | 37.7 | 5.85849056603774 | 69 | 43 | 48.8 | 0 | 63 | 269 | 46 | 114 | KAG6972716.1 hypothetical protein JG687_00001280 [Phytophthora cactorum] | diamond | 2484 | 63.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 32874335 | 32874335 | PRJNA615175_P_NODE_7200_length_563_cov_3.655102_g7035_i0 | PRJNA615175 | 7200 | 563 | 3.655102 | 20.57822426 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 0.0112 | NR | KAG1713072.1 | 4784 | g7035 | i0 | 31.3 | 2.73889875666075 | 83 | 56 | 44.2 | 1 | 520 | 272 | 106 | 187 | KAG1713072.1 hypothetical protein DVH05_000799 [Phytophthora capsici] | diamond | 1542 | 48.1 | 0.993762993762994 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici |
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);;