contig_metadata
26 rows where bioproject = "PRJEB7366", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1409843 | 1409843 | PRJEB7366_P_NODE_22202_length_160_cov_1.280000_g21768_i0 | PRJEB7366 | 22202 | 160 | 1.28 | 2.048 | Phytopythium sindhum | 795340 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 2.19e-10 | NTclustered | gi|440919558|gb|JX436356.1| | 795340 | g21768 | i0 | 94.118 | 1.48125 | 51 | 3 | 32 | 0 | 91 | 141 | 438 | 388 | Phytopythium sindhum axoneme central apparatus PF16 gene, partial cds | blastn | 237 | 78.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Phytopythium | Phytopythium sindhum | ||
| 6513348 | 6513348 | PRJEB7366_P_NODE_1866_length_718_cov_12.525622_g1527_i0 | PRJEB7366 | 1866 | 718 | 12.525622 | 89.93396596 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.02 | NTclustered | gi|170285697|emb|CU672270.3| | 123356 | g1527 | i0 | 100 | 0.0403899721448468 | 29 | 0 | 4 | 0 | 683 | 711 | 1789 | 1761 | H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 6513391 | 6513391 | PRJEB7366_P_NODE_6406_length_348_cov_10.821086_g5972_i0 | PRJEB7366 | 6406 | 348 | 10.821086 | 37.65737928 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.009 | NTclustered | gi|170285697|emb|CU672270.3| | 123356 | g5972 | i0 | 100 | 0.0833333333333333 | 29 | 0 | 8 | 0 | 313 | 341 | 1789 | 1761 | H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 7787644 | 7787644 | PRJEB7366_P_NODE_3187_length_531_cov_9.336694_g2780_i0 | PRJEB7366 | 3187 | 531 | 9.336694 | 49.57784514 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 1.34e-57 | NTclustered | gi|695460914|ref|XM_009539807.1| | 67593 | g2780 | i0 | 91.329 | 32.7815442561205 | 173 | 15 | 33 | 0 | 1 | 173 | 182 | 354 | Phytophthora sojae hypothetical protein mRNA | blastn | 17407 | 237 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 8648688 | 8648688 | PRJEB7366_P_NODE_6527_length_345_cov_1.619355_g6093_i0 | PRJEB7366 | 6527 | 345 | 1.619355 | 5.58677475 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 168 | 1.7e-50 | NR | RHY18795.1 | 157072 | g6093 | i0 | 71.3 | 38.7565217391304 | 115 | 33 | 100 | 0 | 1 | 345 | 1 | 115 | RHY18795.1 hypothetical protein DYB32_010329 [Aphanomyces invadans] | diamond | 13371 | 168 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 10338304 | 10338304 | PRJEB7366_P_NODE_22809_length_157_cov_2.295082_g22375_i0 | PRJEB7366 | 22809 | 157 | 2.295082 | 3.60327874 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.013 | NTclustered | gi|813155594|ref|XM_012346002.1| | 695850 | g22375 | i0 | 100 | 0.178343949044586 | 28 | 0 | 18 | 0 | 95 | 122 | 194 | 167 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 10338314 | 10338314 | PRJEB7366_P_NODE_2549_length_605_cov_9.538596_g2160_i0 | PRJEB7366 | 2549 | 605 | 9.538596 | 57.7085058 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.017 | NTclustered | gi|170285697|emb|CU672270.3| | 123356 | g2160 | i0 | 100 | 0.0479338842975207 | 29 | 0 | 5 | 0 | 154 | 182 | 1789 | 1761 | H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 14163674 | 14163674 | PRJEB7366_P_NODE_3832_length_478_cov_1.532731_g3410_i0 | PRJEB7366 | 3832 | 478 | 1.532731 | 7.32645418 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 9.410000000000001e-66 | NR | KAF1328520.1 | 82926 | g3410 | i0 | 72.6 | 2.7489539748954 | 146 | 40 | 91.6 | 0 | 1 | 438 | 186 | 331 | KAF1328520.1 Malate dehydrogenase, nad-dependent, partial [Globisporangium splendens] | diamond | 1314 | 214 | 0.995327102803738 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 21812052 | 21812052 | PRJEB7366_P_NODE_7418_length_318_cov_1.272085_g6984_i0 | PRJEB7366 | 7418 | 318 | 1.272085 | 4.0452303 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 8.469999999999999e-43 | NR | TMW60420.1 | 41045 | g6984 | i0 | 72.5 | 10.311320754717 | 109 | 27 | 100 | 1 | 318 | 1 | 258 | 366 | TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] | diamond | 3279 | 154 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 23948033 | 23948033 | PRJEB7366_P_NODE_11719_length_237_cov_1.747525_g11285_i0 | PRJEB7366 | 11719 | 237 | 1.747525 | 4.14163425 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.21e-39 | NTclustered | gi|2794916836|ref|XM_067893665.1| | 164328 | g11285 | i0 | 84.153 | 5.60337552742616 | 183 | 27 | 77 | 2 | 56 | 237 | 413 | 232 | Phytophthora ramorum Elongator complex protein 3 (KRP23_8248), partial mRNA | blastn | 1328 | 176 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 26622529 | 26622529 | PRJEB7366_P_NODE_7601_length_313_cov_1.582734_g7167_i0 | PRJEB7366 | 7601 | 313 | 1.582734 | 4.95395742 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 95.1 | 3.52e-20 | NR | KAF1330315.1 | 82926 | g7167 | i0 | 48 | 0.939297124600639 | 98 | 50 | 93.9 | 1 | 20 | 313 | 249 | 345 | KAF1330315.1 putative arginine n-methyltransferase, partial [Globisporangium splendens] | diamond | 294 | 95.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 27855397 | 27855397 | PRJEB7366_P_NODE_5705_length_375_cov_1.558824_g5272_i0 | PRJEB7366 | 5705 | 375 | 1.558824 | 5.84559 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 5.82e-6 | NR | DAZ93356.1 | 4803 | g5272 | i0 | 34.3 | 4.896 | 102 | 44 | 81.6 | 3 | 2 | 307 | 97 | 175 | DAZ93356.1 TPA: hypothetical protein N0F65_011882 [Lagenidium giganteum] | diamond | 1836 | 55.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 27879796 | 27879796 | PRJEB7366_P_NODE_12525_length_227_cov_2.078125_g12091_i0 | PRJEB7366 | 12525 | 227 | 2.078125 | 4.71734375 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 1.85e-27 | NR | KAF0736269.1 | 100861 | g12091 | i0 | 69.3 | 6.93832599118943 | 75 | 23 | 99.1 | 0 | 227 | 3 | 35 | 109 | KAF0736269.1 hypothetical protein Ae201684_007291 [Aphanomyces euteiches] | diamond | 1575 | 110 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 27879803 | 27879803 | PRJEB7366_P_NODE_8785_length_285_cov_1.968000_g8351_i0 | PRJEB7366 | 8785 | 285 | 1.968 | 5.6088 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 1.38e-28 | NR | TMW55155.1 | 41045 | g8351 | i0 | 71.1 | 3.15789473684211 | 76 | 22 | 80 | 0 | 285 | 58 | 631 | 706 | TMW55155.1 hypothetical protein Poli38472_013917 [Pythium oligandrum] | diamond | 900 | 119 | 0.991596638655462 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 27886931 | 27886931 | PRJEB7366_P_NODE_18525_length_178_cov_1.118881_g18091_i0 | PRJEB7366 | 18525 | 178 | 1.118881 | 1.99160818 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 8.09e-9 | NR | KAF0683170.1 | 120398 | g18091 | i0 | 67.4 | 2.81460674157303 | 43 | 14 | 72.5 | 0 | 131 | 3 | 36 | 78 | KAF0683170.1 hypothetical protein As57867_024685 [Aphanomyces stellatus] | diamond | 501 | 60.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 29749585 | 29749585 | PRJEB7366_P_NODE_2751_length_577_cov_1.974170_g2351_i0 | PRJEB7366 | 2751 | 577 | 1.97417 | 11.3909609 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 4.41e-72 | NR | DAZ99584.1 | 4803 | g2351 | i0 | 59.6 | 1.02946273830156 | 198 | 72 | 99.8 | 2 | 576 | 1 | 312 | 507 | DAZ99584.1 TPA: hypothetical protein N0F65_001412 [Lagenidium giganteum] | diamond | 594 | 237 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 30160290 | 30160290 | PRJEB7366_P_NODE_18152_length_180_cov_1.379310_g17718_i0 | PRJEB7366 | 18152 | 180 | 1.37931 | 2.482758 | Bremia lactucae | 4779 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 7.2e-10 | NR | XP_067816464.1 | 4779 | g17718 | i0 | 52.5 | 2.95 | 59 | 25 | 98.3 | 1 | 3 | 179 | 93 | 148 | XP_067816464.1 hypothetical protein CCR75_006177 [Bremia lactucae] | diamond | 531 | 63.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 30571042 | 30571042 | PRJEB7366_P_NODE_24773_length_150_cov_1.391304_g24339_i0 | PRJEB7366 | 24773 | 150 | 1.391304 | 2.086956 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.00783 | NR | KAF4041827.1 | 4787 | g24339 | i0 | 65.6 | 0.64 | 32 | 10 | 62 | 1 | 58 | 150 | 10 | 41 | KAF4041827.1 FDF domain-containing protein [Phytophthora infestans] | diamond | 96 | 43.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 31132471 | 31132471 | PRJEB7366_P_NODE_8915_length_283_cov_1.290323_g8481_i0 | PRJEB7366 | 8915 | 283 | 1.290323 | 3.65161409 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 95.5 | 1.12e-20 | NR | KAH9158537.1 | 100861 | g8481 | i0 | 51.8 | 5.46996466431095 | 85 | 41 | 90.1 | 0 | 283 | 29 | 330 | 414 | KAH9158537.1 hypothetical protein LEN26_002910 [Aphanomyces euteiches] | diamond | 1548 | 96.3 | 0.991692627206646 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 31171338 | 31171338 | PRJEB7366_P_NODE_6215_length_355_cov_1.656250_g5782_i0 | PRJEB7366 | 6215 | 355 | 1.65625 | 5.8796875 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 2.29e-37 | NR | XP_008606484.1 | 1156394 | g5782 | i0 | 57.8 | 1.97746478873239 | 116 | 48 | 98 | 1 | 8 | 355 | 348 | 462 | XP_008606484.1 hypothetical protein SDRG_02669 [Saprolegnia diclina VS20] | diamond | 702 | 144 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 31512450 | 31512450 | PRJEB7366_P_NODE_10676_length_252_cov_1.225806_g10242_i0 | PRJEB7366 | 10676 | 252 | 1.225806 | 3.08903112 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 8.190000000000001e-27 | NR | TMW63800.1 | 41045 | g10242 | i0 | 62.7 | 5.92857142857143 | 83 | 31 | 98.8 | 0 | 3 | 251 | 162 | 244 | TMW63800.1 hypothetical protein Poli38472_002741 [Pythium oligandrum] | diamond | 1494 | 110 | 0.990909090909091 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31512456 | 31512456 | PRJEB7366_P_NODE_24656_length_151_cov_0.991379_g24222_i0 | PRJEB7366 | 24656 | 151 | 0.991379 | 1.49698229 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 7.45e-11 | NR | KAH9156009.1 | 100861 | g24222 | i0 | 69 | 3.41721854304636 | 42 | 13 | 83.4 | 0 | 142 | 17 | 587 | 628 | KAH9156009.1 hypothetical protein AeRB84_002073 [Aphanomyces euteiches] | diamond | 516 | 66.2 | 0.995468277945619 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 31733490 | 31733490 | PRJEB7366_P_NODE_22837_length_157_cov_1.926230_g22403_i0 | PRJEB7366 | 22837 | 157 | 1.92623 | 3.0241811 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 1.76e-9 | NR | POM73557.1 | 4796 | g22403 | i0 | 54.2 | 14.6942675159236 | 48 | 22 | 91.7 | 0 | 3 | 146 | 245 | 292 | POM73557.1 Major vault protein [Phytophthora palmivora] | diamond | 2307 | 62 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 31867262 | 31867262 | PRJEB7366_P_NODE_9777_length_266_cov_1.904762_g9343_i0 | PRJEB7366 | 9777 | 266 | 1.904762 | 5.06666692 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 96.3 | 4.03e-21 | NR | XP_008867564.1 | 157072 | g9343 | i0 | 62.6 | 5.68421052631579 | 91 | 30 | 99.2 | 3 | 3 | 266 | 1 | 90 | XP_008867564.1 hypothetical protein H310_04829 [Aphanomyces invadans] | diamond | 1512 | 96.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 32183880 | 32183880 | PRJEB7366_P_NODE_11518_length_240_cov_1.356098_g11084_i0 | PRJEB7366 | 11518 | 240 | 1.356098 | 3.2546352 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 9.49e-20 | NR | XP_024576840.1 | 4781 | g11084 | i0 | 58.8 | 1.8375 | 68 | 28 | 85 | 0 | 240 | 37 | 245 | 312 | XP_024576840.1 mitochondrial carrier family [Plasmopara halstedii] | diamond | 441 | 91.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 32461468 | 32461468 | PRJEB7366_P_NODE_10479_length_255_cov_1.272727_g10045_i0 | PRJEB7366 | 10479 | 255 | 1.272727 | 3.24545385 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 2.8299999999999993e-24 | NR | KAK1943133.1 | 4793 | g10045 | i0 | 56 | 2.94117647058824 | 84 | 33 | 98.8 | 1 | 253 | 2 | 9 | 88 | KAK1943133.1 Diphosphomevalonate decarboxylase [Phytophthora citrophthora] | diamond | 750 | 101 | 0.99009900990099 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora |
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);;