contig_metadata
25 rows where bioproject = "PRJNA429937", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2976331 | 2976331 | PRJNA429937_P_NODE_11283_length_1084_cov_4.824645_g6277_i1 | PRJNA429937 | 11283 | 1084 | 4.824645 | 52.2991518 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 2.1199999999999993e-90 | NR | KAG1693818.1 | 4784 | g6277 | i1 | 72.7 | 13.190036900369 | 216 | 10 | 59.8 | 2 | 981 | 334 | 270 | 436 | KAG1693818.1 hypothetical protein DVH05_022920 [Phytophthora capsici] | diamond | 14298 | 302 | 0.993377483443709 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 6190849 | 6190849 | PRJNA429937_P_NODE_78765_length_370_cov_3.557185_g56437_i0 | PRJNA429937 | 78765 | 370 | 3.557185 | 13.1615845 | Verrucalvaceae | 120409 | SAR_Eukaryotes | SAR_Eukaryotes | 665 | 0 | NTclustered | gi|698793877|ref|XR_717099.1| | 112090 | g56437 | i0 | 99.189 | 99.7108108108108 | 370 | 2 | 100 | 1 | 1 | 370 | 609 | 977 | Aphanomyces astaci 18S ribosomal RNA rRNA | blastn | 36893 | 671 | 0.991058122205663 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 8079255 | 8079255 | PRJNA429937_P_NODE_144867_length_197_cov_3.797619_g122240_i0 | PRJNA429937 | 144867 | 197 | 3.797619 | 7.48130943 | Phytophthora megasperma | 4788 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 1.1899999999999998e-73 | NTclustered | gi|2440150|emb|X75631.1| | 4788 | g122240 | i0 | 95.604 | 86.6192893401015 | 182 | 4 | 91 | 2 | 18 | 197 | 2855 | 2676 | P.megasperma gene for 28S ribosomal RNA | blastn | 17064 | 289 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 10629446 | 10629446 | PRJNA429937_P_NODE_10689_length_1111_cov_4.596118_g6277_i0 | PRJNA429937 | 10689 | 1111 | 4.596118 | 51.06287098 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.32e-70 | NTclustered | gi|2794924106|ref|XM_067882382.1| | 164328 | g6277 | i0 | 85.294 | 1.13951395139514 | 272 | 40 | 43 | 0 | 1 | 272 | 1735 | 1464 | Phytophthora ramorum Cyclin-dependent kinase 3 (KRP23_11803), partial mRNA | blastn | 1266 | 281 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 10629465 | 10629465 | PRJNA429937_P_NODE_108389_length_278_cov_7343.935743_g85768_i0 | PRJNA429937 | 108389 | 278 | 7343.935743 | 20416.14136554 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 418 | 2.189999999999999e-112 | NTclustered | gi|325194343|emb|FR825184.1| | 890382 | g85768 | i0 | 93.617 | 101.809352517986 | 282 | 14 | 100 | 2 | 1 | 278 | 85 | 366 | Albugo laibachii Nc14, genomic contig CONTIG_1822_NC14_v4_1483_32232 | blastn | 28303 | 418 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 13179505 | 13179505 | PRJNA429937_P_NODE_12991_length_1013_cov_4.948171_g6277_i2 | PRJNA429937 | 12991 | 1013 | 4.948171 | 50.12497223 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 1.8799999999999998e-118 | NTclustered | gi|675195502|ref|XM_008908388.1| | 761204 | g6277 | i2 | 85.116 | 3.67620927936821 | 430 | 64 | 42 | 0 | 584 | 1013 | 1595 | 2024 | Phytophthora parasitica INRA-310 CMGC/CDK/CDC2 protein kinase, variant 1 mRNA | blastn | 3724 | 440 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 14454805 | 14454805 | PRJNA429937_P_NODE_137552_length_209_cov_10.488889_g114925_i0 | PRJNA429937 | 137552 | 209 | 10.488889 | 21.92177801 | Globisporangium rostratifingens | 2711122 | SAR_Eukaryotes | SAR_Eukaryotes | 383 | 5.72e-102 | NTclustered | gi|573007537|gb|HQ643761.2| | 2711122 | g114925 | i0 | 100 | 99.0526315789474 | 207 | 0 | 99 | 0 | 3 | 209 | 3813 | 3607 | Pythium rostratifingens voucher CBS115464 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 20702 | 383 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium rostratifingens | ||
| 15728689 | 15728689 | PRJNA429937_P_NODE_154373_length_165_cov_6.610294_g131746_i0 | PRJNA429937 | 154373 | 165 | 6.610294 | 10.9069851 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.46e-77 | NTclustered | gi|325194423|emb|FR825253.1| | 890382 | g131746 | i0 | 99.398 | 100.575757575758 | 166 | 0 | 100 | 1 | 1 | 165 | 235 | 400 | Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 | blastn | 16595 | 300 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 16390015 | 16390015 | PRJNA429937_P_NODE_32033_length_642_cov_2.838499_g19609_i0 | PRJNA429937 | 32033 | 642 | 2.838499 | 18.22316358 | Phytophthora oleae | 2107226 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 3.01e-12 | NR | KAL3673387.1 | 2107226 | g19609 | i0 | 48.9 | 0.429906542056075 | 92 | 41 | 40.2 | 2 | 186 | 443 | 509 | 600 | KAL3673387.1 hypothetical protein V7S43_001100 [Phytophthora oleae] | diamond | 276 | 76.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora oleae | ||
| 17003715 | 17003715 | PRJNA429937_P_NODE_29454_length_672_cov_6.611198_g17844_i0 | PRJNA429937 | 29454 | 672 | 6.611198 | 44.42725056 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 6.65e-7 | NTclustered | gi|166997812|emb|CU469389.7| | 123356 | g17844 | i0 | 83.784 | 0.327380952380952 | 74 | 11 | 11 | 1 | 50 | 122 | 103503 | 103430 | H.parasitica DNA sequence from clone HpEmoy2-12J23, complete sequence | blastn | 220 | 69.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 19553481 | 19553481 | PRJNA429937_P_NODE_8876_length_1203_cov_11.770017_g5224_i0 | PRJNA429937 | 8876 | 1203 | 11.770017 | 141.59330451 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 689 | 0 | NTclustered | gi|669172050|ref|XM_008623152.1| | 1156394 | g5224 | i0 | 79.753 | 4.25436408977556 | 973 | 180 | 80 | 14 | 215 | 1179 | 1406 | 443 | Saprolegnia diclina VS20 ketol-acid reductoisomerase partial mRNA | blastn | 5118 | 689 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 22104265 | 22104265 | PRJNA429937_P_NODE_97838_length_308_cov_663.028674_g75232_i0 | PRJNA429937 | 97838 | 308 | 663.028674 | 2042.12831592 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 545 | 1.0799999999999999e-150 | NTclustered | gi|325194423|emb|FR825253.1| | 890382 | g75232 | i0 | 99.016 | 98.6558441558442 | 305 | 1 | 99 | 2 | 5 | 308 | 844 | 541 | Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 | blastn | 30386 | 545 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 23378964 | 23378964 | PRJNA429937_P_NODE_47599_length_515_cov_103.670782_g30896_i0 | PRJNA429937 | 47599 | 515 | 103.670782 | 533.9045273 | Globisporangium rostratifingens | 2711122 | SAR_Eukaryotes | SAR_Eukaryotes | 911 | 0 | NTclustered | gi|573007537|gb|HQ643761.2| | 2711122 | g30896 | i0 | 98.459 | 99.7145631067961 | 519 | 4 | 100 | 1 | 1 | 515 | 3102 | 3620 | Pythium rostratifingens voucher CBS115464 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 51353 | 911 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium rostratifingens | ||
| 24039484 | 24039484 | PRJNA429937_P_NODE_67119_length_414_cov_716.877922_g46052_i0 | PRJNA429937 | 67119 | 414 | 716.877922 | 2967.87459708 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 521 | 2.5199999999999992e-143 | NTclustered | gi|33520249|gb|AY273994.1| | 127444 | g46052 | i0 | 89.951 | 98.3115942028985 | 408 | 36 | 98 | 5 | 5 | 408 | 413 | 7 | Pythium undulatum large subunit ribosomal RNA gene, partial sequence | blastn | 40701 | 521 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Elongisporangium | Elongisporangium undulatum | ||
| 24039510 | 24039510 | PRJNA429937_P_NODE_71839_length_395_cov_541.628415_g50082_i0 | PRJNA429937 | 71839 | 395 | 541.628415 | 2139.43223925 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 601 | 2.9899999999999996e-167 | NTclustered | gi|90655131|gb|DQ361252.1| | 4794 | g50082 | i0 | 94.602 | 98.2455696202532 | 389 | 20 | 98 | 1 | 4 | 391 | 75 | 463 | Phytophthora drechsleri large subunit ribosomal RNA gene, partial sequence | blastn | 38807 | 606 | 0.991749174917492 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora drechsleri | ||
| 27377001 | 27377001 | PRJNA429937_P_NODE_133523_length_217_cov_3.005319_g110896_i0 | PRJNA429937 | 133523 | 217 | 3.005319 | 6.52154223 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.34e-4 | NR | OWZ09397.1 | 4795 | g110896 | i0 | 58.6 | 4.36866359447005 | 29 | 12 | 40.1 | 0 | 88 | 2 | 247 | 275 | OWZ09397.1 polyprotein [Phytophthora megakarya] | diamond | 948 | 49.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 27612973 | 27612973 | PRJNA429937_P_NODE_73724_length_388_cov_4.116992_g31558_i1 | PRJNA429937 | 73724 | 388 | 4.116992 | 15.97392896 | Peronospora farinosa | 134698 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 9.68e-50 | NR | CAH0485653.1 | 134698 | g31558 | i1 | 71.8 | 0.79639175257732 | 103 | 29 | 79.6 | 0 | 16 | 324 | 45 | 147 | CAH0485653.1 unnamed protein product [Peronospora farinosa] | diamond | 309 | 165 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 28275758 | 28275758 | PRJNA429937_P_NODE_48486_length_510_cov_3.754678_g31558_i0 | PRJNA429937 | 48486 | 510 | 3.754678 | 19.1488578 | Peronospora farinosa | 134698 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 6.47e-30 | NR | CAH0485470.1 | 134698 | g31558 | i0 | 77.6 | 0.788235294117647 | 67 | 15 | 39.4 | 0 | 315 | 115 | 75 | 141 | CAH0485470.1 unnamed protein product [Peronospora farinosa] | diamond | 402 | 117 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 28528643 | 28528643 | PRJNA429937_P_NODE_25327_length_729_cov_2.854286_g15137_i0 | PRJNA429937 | 25327 | 729 | 2.854286 | 20.80774494 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 232 | 7.269999999999999e-72 | NR | TYZ62095.1 | 1485010 | g15137 | i0 | 80.4 | 0.588477366255144 | 143 | 28 | 58.8 | 0 | 5 | 433 | 129 | 271 | TYZ62095.1 hypothetical protein PybrP1_000907 [[Pythium] brassicae (nom. inval.)] | diamond | 429 | 232 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 30612728 | 30612728 | PRJNA429937_P_NODE_76153_length_379_cov_4.177143_g31558_i2 | PRJNA429937 | 76153 | 379 | 4.177143 | 15.83137197 | Peronospora farinosa | 134698 | SAR_Eukaryotes | SAR_Eukaryotes | 166 | 4.27e-50 | NR | CAH0485653.1 | 134698 | g31558 | i2 | 71.8 | 0.815303430079156 | 103 | 29 | 81.5 | 0 | 16 | 324 | 45 | 147 | CAH0485653.1 unnamed protein product [Peronospora farinosa] | diamond | 309 | 166 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 30770976 | 30770976 | PRJNA429937_P_NODE_32574_length_636_cov_3.113674_g15137_i1 | PRJNA429937 | 32574 | 636 | 3.113674 | 19.80296664 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 232 | 2.3099999999999997e-72 | NR | TYZ62095.1 | 1485010 | g15137 | i1 | 80.4 | 0.674528301886792 | 143 | 28 | 67.5 | 0 | 632 | 204 | 129 | 271 | TYZ62095.1 hypothetical protein PybrP1_000907 [[Pythium] brassicae (nom. inval.)] | diamond | 429 | 232 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 31514616 | 31514616 | PRJNA429937_P_NODE_46936_length_520_cov_2.861507_g30382_i0 | PRJNA429937 | 46936 | 520 | 2.861507 | 14.8798364 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 3.77e-10 | NR | OQS01886.1 | 74557 | g30382 | i0 | 36.3 | 0.934615384615385 | 80 | 51 | 46.2 | 0 | 28 | 267 | 62 | 141 | OQS01886.1 hypothetical protein THRCLA_21579 [Thraustotheca clavata] | diamond | 486 | 65.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 32604943 | 32604943 | PRJNA429937_P_NODE_126480_length_233_cov_1.808824_g103853_i0 | PRJNA429937 | 126480 | 233 | 1.808824 | 4.21455992 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 7.34e-5 | NR | CCA16746.1 | 890382 | g103853 | i0 | 71.9 | 0.412017167381974 | 32 | 9 | 41.2 | 0 | 131 | 226 | 187 | 218 | CCA16746.1 putative polyprotein [Albugo laibachii Nc14] | diamond | 96 | 50.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 32730948 | 32730948 | PRJNA429937_P_NODE_129800_length_225_cov_3.897959_g107173_i0 | PRJNA429937 | 129800 | 225 | 3.897959 | 8.77040775 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 1.92e-4 | NR | TYZ62095.1 | 1485010 | g107173 | i0 | 85.2 | 0.36 | 27 | 4 | 36 | 0 | 1 | 81 | 298 | 324 | TYZ62095.1 hypothetical protein PybrP1_000907 [[Pythium] brassicae (nom. inval.)] | diamond | 81 | 48.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 32730950 | 32730950 | PRJNA429937_P_NODE_133120_length_218_cov_2.417989_g110493_i0 | PRJNA429937 | 133120 | 218 | 2.417989 | 5.27121602 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00786 | NR | GLE01126.1 | 114742 | g110493 | i0 | 58.1 | 0.591743119266055 | 43 | 18 | 59.2 | 0 | 1 | 129 | 1106 | 1148 | GLE01126.1 hypothetical protein PINS_up009956 [Pythium insidiosum] | diamond | 129 | 44.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum |
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);;