contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA753704" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5834644 | 5834644 | PRJNA753704_P_NODE_21785_length_261_cov_5.723404_g21424_i0 | PRJNA753704 | 21785 | 261 | 5.723404 | 14.93808444 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 2.0099999999999994e-23 | NR | XP_024584861.1 | 4781 | g21424 | i0 | 97.7 | 6.50574712643678 | 44 | 1 | 50.6 | 0 | 261 | 130 | 137 | 180 | XP_024584861.1 adp-ribosylation factor [Plasmopara halstedii] | diamond | 1698 | 99 | 0.995959595959596 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 17309336 | 17309336 | PRJNA753704_P_NODE_7914_length_414_cov_1.607038_g7553_i0 | PRJNA753704 | 7914 | 414 | 1.607038 | 6.65313732 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 5.72e-26 | NR | KAF0685444.1 | 120398 | g7553 | i0 | 68 | 0.884057971014493 | 122 | 39 | 88.4 | 0 | 45 | 410 | 297 | 418 | KAF0685444.1 hypothetical protein As57867_022588 [Aphanomyces stellatus] | diamond | 366 | 113 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 27147284 | 27147284 | PRJNA753704_P_NODE_25662_length_248_cov_0.891429_g25301_i0 | PRJNA753704 | 25662 | 248 | 0.891429 | 2.21074392 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00589 | NR | KAG1692085.1 | 4784 | g25301 | i0 | 47.1 | 2.46774193548387 | 51 | 21 | 61.7 | 2 | 242 | 90 | 57 | 101 | KAG1692085.1 hypothetical protein DVH05_025893 [Phytophthora capsici] | diamond | 612 | 45.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 27748118 | 27748118 | PRJNA753704_P_NODE_27384_length_244_cov_0.912281_g27023_i0 | PRJNA753704 | 27384 | 244 | 0.912281 | 2.22596564 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 6.57e-10 | NR | KAF0708737.1 | 112090 | g27023 | i0 | 42.9 | 0.94672131147541 | 77 | 39 | 89.8 | 3 | 236 | 18 | 143 | 218 | KAF0708737.1 hypothetical protein AaE_013105 [Aphanomyces astaci] | diamond | 231 | 64.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 28032140 | 28032140 | PRJNA753704_P_NODE_12605_length_335_cov_0.996183_g12244_i0 | PRJNA753704 | 12605 | 335 | 0.996183 | 3.33721305 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 9.44e-6 | NR | TMW58223.1 | 41045 | g12244 | i0 | 33.3 | 0.752238805970149 | 84 | 56 | 75.2 | 0 | 57 | 308 | 531 | 614 | TMW58223.1 hypothetical protein Poli38472_011811 [Pythium oligandrum] | diamond | 252 | 54.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 28032141 | 28032141 | PRJNA753704_P_NODE_13105_length_329_cov_1.085938_g12744_i0 | PRJNA753704 | 13105 | 329 | 1.085938 | 3.57273602 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 4.45e-34 | NR | DBA04764.1 | 4803 | g12744 | i0 | 63.1 | 5.65349544072948 | 103 | 38 | 93.9 | 0 | 19 | 327 | 50 | 152 | DBA04764.1 TPA: hypothetical protein N0F65_004401 [Lagenidium giganteum] | diamond | 1860 | 133 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 29105741 | 29105741 | PRJNA753704_P_NODE_28028_length_243_cov_0.917647_g27667_i0 | PRJNA753704 | 28028 | 243 | 0.917647 | 2.22988221 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 7.82e-6 | NR | OQS03262.1 | 74557 | g27667 | i0 | 32.5 | 0.987654320987654 | 80 | 53 | 98.8 | 1 | 241 | 2 | 74 | 152 | OQS03262.1 ATP-binding Cassette (ABC) Superfamily, partial [Thraustotheca clavata] | diamond | 240 | 53.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 29421116 | 29421116 | PRJNA753704_P_NODE_25429_length_248_cov_2.674286_g25068_i0 | PRJNA753704 | 25429 | 248 | 2.674286 | 6.63222928 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1.1699999999999997e-23 | NR | DBA01320.1 | 4803 | g25068 | i0 | 61 | 1.86290322580645 | 77 | 29 | 91.9 | 1 | 230 | 3 | 149 | 225 | DBA01320.1 TPA: hypothetical protein N0F65_001825, partial [Lagenidium giganteum] | diamond | 462 | 103 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 29588688 | 29588688 | PRJNA753704_P_NODE_27030_length_245_cov_0.906977_g26669_i0 | PRJNA753704 | 27030 | 245 | 0.906977 | 2.22209365 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 1.42e-15 | NR | TMW57632.1 | 41045 | g26669 | i0 | 59.7 | 7.62857142857143 | 67 | 27 | 82 | 0 | 231 | 31 | 394 | 460 | TMW57632.1 hypothetical protein Poli38472_003557 [Pythium oligandrum] | diamond | 1869 | 80.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 29683411 | 29683411 | PRJNA753704_P_NODE_17830_length_286_cov_1.464789_g17469_i0 | PRJNA753704 | 17830 | 286 | 1.464789 | 4.18929654 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0223 | NR | XP_009839372.1 | 112090 | g17469 | i0 | 32.9 | 1.6993006993007 | 79 | 53 | 82.9 | 0 | 284 | 48 | 208 | 286 | XP_009839372.1 hypothetical protein H257_13524, partial [Aphanomyces astaci] | diamond | 486 | 43.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 30716291 | 30716291 | PRJNA753704_P_NODE_11514_length_349_cov_1.550725_g11153_i0 | PRJNA753704 | 11514 | 349 | 1.550725 | 5.41203025 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 1.72e-22 | NR | XP_008619925.1 | 1156394 | g11153 | i0 | 42.2 | 0.997134670487106 | 116 | 61 | 98.9 | 3 | 349 | 5 | 9 | 119 | XP_008619925.1 hypothetical protein SDRG_15527 [Saprolegnia diclina VS20] | diamond | 348 | 99.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 30916010 | 30916010 | PRJNA753704_P_NODE_15954_length_301_cov_1.315789_g15593_i0 | PRJNA753704 | 15954 | 301 | 1.315789 | 3.96052489 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 1.79e-18 | NR | GLE03447.1 | 114742 | g15593 | i0 | 51 | 2.00332225913621 | 102 | 46 | 97.7 | 3 | 301 | 8 | 320 | 421 | GLE03447.1 hypothetical protein PINS_up012349 [Pythium insidiosum] | diamond | 603 | 90.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31136695 | 31136695 | PRJNA753704_P_NODE_20515_length_269_cov_1.183673_g20154_i0 | PRJNA753704 | 20515 | 269 | 1.183673 | 3.18408037 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 6.07e-28 | NR | DAZ97987.1 | 4803 | g20154 | i0 | 59.6 | 14.8884758364312 | 89 | 36 | 99.3 | 0 | 267 | 1 | 23 | 111 | DAZ97987.1 TPA: hypothetical protein N0F65_005145 [Lagenidium giganteum] | diamond | 4005 | 111 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 31316836 | 31316836 | PRJNA753704_P_NODE_12515_length_336_cov_1.315589_g12154_i0 | PRJNA753704 | 12515 | 336 | 1.315589 | 4.42037904 | Phytophthora kernoviae | 325452 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 6.57e-10 | NR | KAG2506600.1 | 325452 | g12154 | i0 | 48 | 1.9375 | 75 | 36 | 66.1 | 2 | 225 | 4 | 158 | 230 | KAG2506600.1 hypothetical protein JM16_008512 [Phytophthora kernoviae] | diamond | 651 | 66.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 31411786 | 31411786 | PRJNA753704_P_NODE_25216_length_249_cov_0.886364_g24855_i0 | PRJNA753704 | 25216 | 249 | 0.886364 | 2.20704636 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 77.4 | 6.64e-15 | NR | TYZ53195.1 | 1485010 | g24855 | i0 | 51.9 | 2.93975903614458 | 81 | 39 | 97.6 | 0 | 5 | 247 | 112 | 192 | TYZ53195.1 hypothetical protein PybrP1_011763 [[Pythium] brassicae (nom. inval.)] | diamond | 732 | 77.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 31516685 | 31516685 | PRJNA753704_P_NODE_16756_length_294_cov_1.705882_g16395_i0 | PRJNA753704 | 16756 | 294 | 1.705882 | 5.01529308 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 2.21e-27 | NR | KAH9182709.1 | 100861 | g16395 | i0 | 52.1 | 3.91836734693878 | 96 | 44 | 98 | 1 | 292 | 5 | 129 | 222 | KAH9182709.1 hypothetical protein AeNC1_015312, partial [Aphanomyces euteiches] | diamond | 1152 | 111 | 0.990990990990991 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 31601670 | 31601670 | PRJNA753704_P_NODE_16856_length_293_cov_2.086364_g16495_i0 | PRJNA753704 | 16856 | 293 | 2.086364 | 6.11304652 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 1.51e-33 | NR | KAH9124623.1 | 100861 | g16495 | i0 | 75 | 1.95563139931741 | 96 | 24 | 98.3 | 0 | 2 | 289 | 444 | 539 | KAH9124623.1 hypothetical protein AeMF1_004641 [Aphanomyces euteiches] | diamond | 573 | 132 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 32117642 | 32117642 | PRJNA753704_P_NODE_17918_length_285_cov_2.518868_g17557_i0 | PRJNA753704 | 17918 | 285 | 2.518868 | 7.1787738 | root | 1 | Root_unresolved | Root_unresolved | 50.8 | 9.18e-5 | NR | KAL4132926.1 | 164328 | g17557 | i0 | 40.2 | 3.46315789473684 | 97 | 52 | 95.8 | 1 | 12 | 284 | 842 | 938 | KAL4132926.1 hypothetical protein PRIC2_003255 [Phytophthora ramorum] | diamond | 987 | 51.2 | 0.9921875 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 32718006 | 32718006 | PRJNA753704_P_NODE_20180_length_271_cov_1.181818_g19819_i0 | PRJNA753704 | 20180 | 271 | 1.181818 | 3.20272678 | root | 1 | Root_unresolved | Root_unresolved | 103 | 4.46e-25 | NR | GLD98138.1 | 114742 | g19819 | i0 | 59.7 | 3.44280442804428 | 77 | 31 | 85.2 | 0 | 270 | 40 | 36 | 112 | GLD98138.1 hypothetical protein PINS_up006835 [Pythium insidiosum] | diamond | 933 | 104 | 0.990384615384615 | 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);;