contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA473201" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 444034 | 444034 | PRJNA473201_P_NODE_52441_length_286_cov_1.215962_g51699_i0 | PRJNA473201 | 52441 | 286 | 1.215962 | 3.47765132 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 3.79e-43 | NR | GLD98305.1 | 114742 | g51699 | i0 | 82.1 | 1.99300699300699 | 95 | 16 | 99.7 | 1 | 286 | 2 | 3 | 96 | GLD98305.1 hypothetical protein PINS_up007002 [Pythium insidiosum] | diamond | 570 | 156 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 13197357 | 13197357 | PRJNA473201_P_NODE_36751_length_329_cov_1.203125_g36009_i0 | PRJNA473201 | 36751 | 329 | 1.203125 | 3.95828125 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 168 | 6.53e-49 | NR | DBA03690.1 | 4803 | g36009 | i0 | 75.2 | 5.86322188449848 | 109 | 27 | 99.4 | 0 | 2 | 328 | 227 | 335 | DBA03690.1 TPA: hypothetical protein N0F65_004107 [Lagenidium giganteum] | diamond | 1929 | 169 | 0.994082840236686 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 18294900 | 18294900 | PRJNA473201_P_NODE_11875_length_585_cov_1.353516_g11138_i0 | PRJNA473201 | 11875 | 585 | 1.353516 | 7.9180686 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 3.46e-36 | NR | DBA03690.1 | 4803 | g11138 | i0 | 62.6 | 8.24102564102564 | 115 | 43 | 59 | 0 | 34 | 378 | 223 | 337 | DBA03690.1 TPA: hypothetical protein N0F65_004107 [Lagenidium giganteum] | diamond | 4821 | 140 | 0.992857142857143 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 19569779 | 19569779 | PRJNA473201_P_NODE_53916_length_282_cov_1.473684_g53174_i0 | PRJNA473201 | 53916 | 282 | 1.473684 | 4.15578888 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 4.22e-41 | NR | TMW60420.1 | 41045 | g53174 | i0 | 74.2 | 6.92553191489362 | 93 | 24 | 98.9 | 0 | 2 | 280 | 154 | 246 | TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] | diamond | 1953 | 149 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 26617533 | 26617533 | PRJNA473201_P_NODE_73261_length_247_cov_0.885057_g72519_i0 | PRJNA473201 | 73261 | 247 | 0.885057 | 2.18609079 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.69e-23 | NR | TMW61237.1 | 41045 | g72519 | i0 | 61.5 | 3.80161943319838 | 78 | 30 | 94.7 | 0 | 237 | 4 | 336 | 413 | TMW61237.1 hypothetical protein Poli38472_013700 [Pythium oligandrum] | diamond | 939 | 102 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 26949516 | 26949516 | PRJNA473201_P_NODE_70362_length_249_cov_0.875000_g69620_i0 | PRJNA473201 | 70362 | 249 | 0.875 | 2.17875 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 9.3e-37 | NR | GLE00417.1 | 114742 | g69620 | i0 | 87.8 | 3.95180722891566 | 82 | 10 | 98.8 | 0 | 248 | 3 | 723 | 804 | GLE00417.1 hypothetical protein PINS_up009174 [Pythium insidiosum] | diamond | 984 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 28355550 | 28355550 | PRJNA473201_P_NODE_85366_length_241_cov_0.916667_g84624_i0 | PRJNA473201 | 85366 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 5.57e-16 | NR | KUF83263.1 | 4792 | g84624 | i0 | 94.7 | 9.56016597510373 | 38 | 2 | 47.3 | 0 | 6 | 119 | 57 | 94 | KUF83263.1 Peptidyl-prolyl cis-trans isomerase Pin1 [Phytophthora nicotianae] | diamond | 2304 | 76.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 28387171 | 28387171 | PRJNA473201_P_NODE_74226_length_247_cov_0.885057_g73484_i0 | PRJNA473201 | 74226 | 247 | 0.885057 | 2.18609079 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 3.86e-8 | NR | KAH9072505.1 | 100861 | g73484 | i0 | 50 | 2.01619433198381 | 52 | 26 | 63.2 | 0 | 78 | 233 | 2 | 53 | KAH9072505.1 hypothetical protein Ae201684P_022082 [Aphanomyces euteiches] | diamond | 498 | 56.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 28481985 | 28481985 | PRJNA473201_P_NODE_33706_length_342_cov_0.977695_g32964_i0 | PRJNA473201 | 33706 | 342 | 0.977695 | 3.3437169 | root | 1 | Root_unresolved | Root_unresolved | 116 | 1.17e-27 | NR | TYZ66672.1 | 1485010 | g32964 | i0 | 67.1 | 18.9298245614035 | 79 | 26 | 69.3 | 0 | 1 | 237 | 453 | 531 | TYZ66672.1 hypothetical protein PybrP1_000579 [[Pythium] brassicae (nom. inval.)] | diamond | 6474 | 116 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 28608255 | 28608255 | PRJNA473201_P_NODE_47287_length_298_cov_1.333333_g46545_i0 | PRJNA473201 | 47287 | 298 | 1.333333 | 3.97333234 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.97e-34 | NR | DAZ98414.1 | 4803 | g46545 | i0 | 70.1 | 5.39597315436242 | 87 | 26 | 87.6 | 0 | 287 | 27 | 595 | 681 | DAZ98414.1 TPA: hypothetical protein N0F65_000128 [Lagenidium giganteum] | diamond | 1608 | 135 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 29239774 | 29239774 | PRJNA473201_P_NODE_37609_length_325_cov_3.047619_g36867_i0 | PRJNA473201 | 37609 | 325 | 3.047619 | 9.90476175 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.3e-34 | NR | KAJ8578052.1 | 4785 | g36867 | i0 | 67.4 | 9.60923076923077 | 95 | 31 | 87.7 | 0 | 294 | 10 | 116 | 210 | KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] | diamond | 3123 | 130 | 0.992307692307692 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 30170850 | 30170850 | PRJNA473201_P_NODE_66172_length_251_cov_0.865169_g65430_i0 | PRJNA473201 | 66172 | 251 | 0.865169 | 2.17157419 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 2.55e-29 | NR | KAJ0407939.1 | 114742 | g65430 | i0 | 69.9 | 0.99203187250996006 | 83 | 25 | 99.2 | 0 | 250 | 2 | 556 | 638 | KAJ0407939.1 hypothetical protein ATCC90586_006311 [Pythium insidiosum] | diamond | 249 | 120 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 30377125 | 30377125 | PRJNA473201_P_NODE_76872_length_245_cov_1.290698_g76130_i0 | PRJNA473201 | 76872 | 245 | 1.290698 | 3.1622101 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 3.8e-21 | NR | XP_008877611.1 | 157072 | g76130 | i0 | 76.7 | 3.77142857142857 | 60 | 13 | 73.5 | 1 | 64 | 243 | 1 | 59 | XP_008877611.1 hypothetical protein H310_12365 [Aphanomyces invadans] | diamond | 924 | 90.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 30534647 | 30534647 | PRJNA473201_P_NODE_41913_length_311_cov_2.546218_g41171_i0 | PRJNA473201 | 41913 | 311 | 2.546218 | 7.91873798 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 1.73e-33 | NR | TMW56563.1 | 41045 | g41171 | i0 | 74.2 | 6.23151125401929 | 93 | 24 | 89.7 | 0 | 279 | 1 | 567 | 659 | TMW56563.1 hypothetical protein Poli38472_006573 [Pythium oligandrum] | diamond | 1938 | 132 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 30550021 | 30550021 | PRJNA473201_P_NODE_68853_length_250_cov_0.870056_g68111_i0 | PRJNA473201 | 68853 | 250 | 0.870056 | 2.17514 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 9.37e-23 | NR | TMW64773.1 | 41045 | g68111 | i0 | 64.6 | 0.984 | 82 | 29 | 98.4 | 0 | 3 | 248 | 340 | 421 | TMW64773.1 hypothetical protein Poli38472_011653 [Pythium oligandrum] | diamond | 246 | 101 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 30565945 | 30565945 | PRJNA473201_P_NODE_66173_length_251_cov_0.865169_g65431_i0 | PRJNA473201 | 66173 | 251 | 0.865169 | 2.17157419 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 3.28e-27 | NR | DBA02606.1 | 4803 | g65431 | i0 | 73.8 | 2.00796812749004 | 84 | 21 | 99.2 | 1 | 250 | 2 | 142 | 225 | DBA02606.1 TPA: hypothetical protein N0F65_011978 [Lagenidium giganteum] | diamond | 504 | 111 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 30581490 | 30581490 | PRJNA473201_P_NODE_84873_length_241_cov_0.916667_g84131_i0 | PRJNA473201 | 84873 | 241 | 0.916667 | 2.20916747 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 6.44e-29 | NR | TYZ59289.1 | 1485010 | g84131 | i0 | 73.8 | 1.95435684647303 | 80 | 21 | 99.6 | 0 | 1 | 240 | 166 | 245 | TYZ59289.1 hypothetical protein PybrP1_006565 [[Pythium] brassicae (nom. inval.)] | diamond | 471 | 115 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 30692593 | 30692593 | PRJNA473201_P_NODE_83733_length_242_cov_0.911243_g82991_i0 | PRJNA473201 | 83733 | 242 | 0.911243 | 2.20520806 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 1.37e-10 | NR | TMW66751.1 | 41045 | g82991 | i0 | 65.9 | 2.49173553719008 | 41 | 14 | 50.8 | 0 | 3 | 125 | 173 | 213 | TMW66751.1 hypothetical protein Poli38472_014063 [Pythium oligandrum] | diamond | 603 | 67 | 0.994029850746269 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31103275 | 31103275 | PRJNA473201_P_NODE_50715_length_290_cov_1.419355_g49973_i0 | PRJNA473201 | 50715 | 290 | 1.419355 | 4.1161295 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.26e-30 | NR | KAJ8578052.1 | 4785 | g49973 | i0 | 62.1 | 8.81379310344828 | 87 | 33 | 90 | 0 | 25 | 285 | 116 | 202 | KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] | diamond | 2556 | 119 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 31118566 | 31118566 | PRJNA473201_P_NODE_46735_length_299_cov_1.831858_g45993_i0 | PRJNA473201 | 46735 | 299 | 1.831858 | 5.47725542 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 1.14e-4 | NR | OQR97336.1 | 1202772 | g45993 | i0 | 44.4 | 0.812709030100334 | 81 | 45 | 81.3 | 0 | 243 | 1 | 28 | 108 | OQR97336.1 60S ribosomal protein L7 [Achlya hypogyna] | diamond | 243 | 50.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 31498439 | 31498439 | PRJNA473201_P_NODE_21876_length_422_cov_1.297994_g21134_i0 | PRJNA473201 | 21876 | 422 | 1.297994 | 5.47753468 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 6.14e-17 | NR | XP_009825362.1 | 112090 | g21134 | i0 | 47.9 | 1.33649289099526 | 94 | 43 | 66.1 | 3 | 422 | 144 | 331 | 419 | XP_009825362.1 hypothetical protein H257_03107 [Aphanomyces astaci] | diamond | 564 | 87 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 31830560 | 31830560 | PRJNA473201_P_NODE_34437_length_338_cov_2.320755_g33695_i0 | PRJNA473201 | 34437 | 338 | 2.320755 | 7.8441519 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 1.3899999999999996e-43 | NR | TMW56563.1 | 41045 | g33695 | i0 | 79.8 | 3.71005917159763 | 104 | 21 | 92.3 | 0 | 313 | 2 | 567 | 670 | TMW56563.1 hypothetical protein Poli38472_006573 [Pythium oligandrum] | diamond | 1254 | 161 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 32794092 | 32794092 | PRJNA473201_P_NODE_81280_length_243_cov_0.905882_g80538_i0 | PRJNA473201 | 81280 | 243 | 0.905882 | 2.20129326 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.0017 | NR | KAJ0399628.1 | 114742 | g80538 | i0 | 87.5 | 0.592592592592593 | 24 | 3 | 29.6 | 0 | 243 | 172 | 1203 | 1226 | KAJ0399628.1 hypothetical protein P43SY_008825 [Pythium insidiosum] | diamond | 144 | 46.6 | 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);;