contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA493244" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8110661 | 8110661 | PRJNA493244_P_NODE_791287_length_512_cov_1.926829_g768634_i0 | PRJNA493244 | 791287 | 512 | 1.926829 | 9.86536448 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 3.94e-26 | NR | KAJ0394519.1 | 114742 | g768634 | i0 | 39.2 | 7.822265625 | 166 | 85 | 97.3 | 4 | 14 | 511 | 148 | 297 | KAJ0394519.1 hypothetical protein P43SY_008098 [Pythium insidiosum] | diamond | 4005 | 115 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 14485877 | 14485877 | PRJNA493244_P_NODE_526052_length_704_cov_4.331260_g505511_i0 | PRJNA493244 | 526052 | 704 | 4.33126 | 30.4920704 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 2.7099999999999997e-32 | NR | KAL0587684.1 | 65357 | g505511 | i0 | 52.9 | 3.69886363636364 | 119 | 50 | 50.7 | 2 | 297 | 653 | 21 | 133 | KAL0587684.1 hypothetical protein ABG067_002703 [Albugo candida] | diamond | 2604 | 124 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 18308809 | 18308809 | PRJNA493244_P_NODE_552335_length_681_cov_1.809677_g531390_i0 | PRJNA493244 | 552335 | 681 | 1.809677 | 12.32390037 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 290 | 1.99e-93 | NR | GLD98125.1 | 114742 | g531390 | i0 | 63.5 | 5.65198237885463 | 219 | 75 | 94.3 | 3 | 38 | 679 | 110 | 328 | GLD98125.1 hypothetical protein PINS_up006822 [Pythium insidiosum] | diamond | 3849 | 290 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 23409982 | 23409982 | PRJNA493244_P_NODE_845779_length_481_cov_9.176190_g822951_i0 | PRJNA493244 | 845779 | 481 | 9.17619 | 44.1374739 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 199 | 3.73e-62 | NR | OQR92500.1 | 1202772 | g822951 | i0 | 64.4 | 2.76923076923077 | 149 | 52 | 92.3 | 1 | 31 | 474 | 31 | 179 | OQR92500.1 ribosomal protein L27 [Achlya hypogyna] | diamond | 1332 | 199 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 27171072 | 27171072 | PRJNA493244_P_NODE_1030702_length_393_cov_7.009036_g1007594_i0 | PRJNA493244 | 1030702 | 393 | 7.009036 | 27.54551148 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 1.79e-30 | NR | CCA28267.1 | 890382 | g1007594 | i0 | 52 | 0.954198473282443 | 125 | 54 | 93.1 | 2 | 366 | 1 | 61 | 182 | CCA28267.1 predicted protein putative [Albugo laibachii Nc14] | diamond | 375 | 120 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 27613730 | 27613730 | PRJNA493244_P_NODE_621664_length_624_cov_3.632327_g599930_i0 | PRJNA493244 | 621664 | 624 | 3.632327 | 22.66572048 | Phytophthora boehmeriae | 109152 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 5.97e-13 | NR | KAG7387716.1 | 109152 | g599930 | i0 | 100 | 0.206730769230769 | 43 | 0 | 20.7 | 0 | 2 | 130 | 379 | 421 | KAG7387716.1 hypothetical protein PHYBOEH_008155 [Phytophthora boehmeriae] | diamond | 129 | 78.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora boehmeriae | ||
| 27960854 | 27960854 | PRJNA493244_P_NODE_1391965_length_270_cov_3.377990_g1368840_i0 | PRJNA493244 | 1391965 | 270 | 3.37799 | 9.120573 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 7.83e-7 | NR | KAF1324798.1 | 82926 | g1368840 | i0 | 40 | 1.66666666666667 | 75 | 36 | 83.3 | 1 | 20 | 244 | 110 | 175 | KAF1324798.1 60s ribosomal protein l18a, partial [Globisporangium splendens] | diamond | 450 | 55.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 28197684 | 28197684 | PRJNA493244_P_NODE_478766_length_750_cov_2.092888_g458997_i0 | PRJNA493244 | 478766 | 750 | 2.092888 | 15.69666 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 212 | 1.11e-60 | NR | XP_067796231.1 | 4785 | g458997 | i0 | 49.5 | 9.696 | 202 | 99 | 80.8 | 2 | 743 | 138 | 454 | 652 | XP_067796231.1 Long-chain fatty acid transporter [Phytophthora cinnamomi] | diamond | 7272 | 214 | 0.990654205607477 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 28434531 | 28434531 | PRJNA493244_P_NODE_572646_length_663_cov_5.091362_g551419_i0 | PRJNA493244 | 572646 | 663 | 5.091362 | 33.75573006 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 1.8e-11 | NR | DAZ95982.1 | 4803 | g551419 | i0 | 34.2 | 0.529411764705882 | 117 | 68 | 51.6 | 3 | 638 | 297 | 133 | 243 | DAZ95982.1 TPA: hypothetical protein N0F65_009283 [Lagenidium giganteum] | diamond | 351 | 72.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 29019066 | 29019066 | PRJNA493244_P_NODE_1252948_length_311_cov_3.072000_g1229824_i0 | PRJNA493244 | 1252948 | 311 | 3.072 | 9.55392 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00957 | NR | KAJ0408371.1 | 114742 | g1229824 | i0 | 60 | 2.27652733118971 | 35 | 14 | 33.8 | 0 | 1 | 105 | 1173 | 1207 | KAJ0408371.1 hypothetical protein P43SY_003097 [Pythium insidiosum] | diamond | 708 | 45.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 29413154 | 29413154 | PRJNA493244_P_NODE_1342189_length_284_cov_3.385650_g1319065_i0 | PRJNA493244 | 1342189 | 284 | 3.38565 | 9.615246 | Phytophthora aleatoria | 2496075 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0178 | NR | KAG6966395.1 | 2496075 | g1319065 | i0 | 43.8 | 0.676056338028169 | 64 | 33 | 66.5 | 2 | 229 | 41 | 547 | 608 | KAG6966395.1 hypothetical protein JG688_00006792 [Phytophthora aleatoria] | diamond | 192 | 44.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora aleatoria | ||
| 29523990 | 29523990 | PRJNA493244_P_NODE_973110_length_419_cov_1.648045_g950045_i0 | PRJNA493244 | 973110 | 419 | 1.648045 | 6.90530855 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 92 | 1.66e-18 | NR | XP_024573668.1 | 4781 | g950045 | i0 | 34.7 | 3.65155131264916 | 118 | 77 | 84.5 | 0 | 356 | 3 | 2699 | 2816 | XP_024573668.1 ubiquitin domain containing protein [Plasmopara halstedii] | diamond | 1530 | 92 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 29681464 | 29681464 | PRJNA493244_P_NODE_1642210_length_211_cov_7.513333_g1619085_i0 | PRJNA493244 | 1642210 | 211 | 7.513333 | 15.85313263 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 5.34e-16 | NR | CCI45572.1 | 65357 | g1619085 | i0 | 63.2 | 4.16587677725119 | 57 | 21 | 81 | 0 | 211 | 41 | 175 | 231 | CCI45572.1 unnamed protein product [Albugo candida] | diamond | 879 | 79.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 29823502 | 29823502 | PRJNA493244_P_NODE_1452071_length_254_cov_9.720207_g1428946_i0 | PRJNA493244 | 1452071 | 254 | 9.720207 | 24.68932578 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 1.19e-9 | NR | OQS03247.1 | 74557 | g1428946 | i0 | 50.8 | 1.42913385826772 | 61 | 30 | 72 | 0 | 26 | 208 | 7 | 67 | OQS03247.1 hypothetical protein THRCLA_21202 [Thraustotheca clavata] | diamond | 363 | 60.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 30171121 | 30171121 | PRJNA493244_P_NODE_1194532_length_331_cov_1.303704_g1171408_i0 | PRJNA493244 | 1194532 | 331 | 1.303704 | 4.31526024 | Saprolegnia parasitica CBS 223.65 | 695850 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 1.46e-39 | NR | XP_012195351.1 | 695850 | g1171408 | i0 | 82.6 | 2.34743202416918 | 86 | 15 | 77.9 | 0 | 3 | 260 | 149 | 234 | XP_012195351.1 GTP-binding nuclear protein Ran [Saprolegnia parasitica CBS 223.65] | diamond | 777 | 141 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 30329763 | 30329763 | PRJNA493244_P_NODE_815452_length_498_cov_3.135011_g792719_i0 | PRJNA493244 | 815452 | 498 | 3.135011 | 15.61235478 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 1.3e-9 | NR | KAF0699988.1 | 120398 | g792719 | i0 | 53.7 | 1.96385542168675 | 54 | 25 | 32.5 | 0 | 228 | 67 | 191 | 244 | KAF0699988.1 hypothetical protein As57867_009431 [Aphanomyces stellatus] | diamond | 978 | 67.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 31372278 | 31372278 | PRJNA493244_P_NODE_996096_length_408_cov_24.726225_g973016_i0 | PRJNA493244 | 996096 | 408 | 24.726225 | 100.882998 | Peronospora belbahrii | 622444 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 9.19e-13 | NR | CAH0478668.1 | 622444 | g973016 | i0 | 51.7 | 5.05882352941176 | 60 | 29 | 44.1 | 0 | 383 | 204 | 22 | 81 | CAH0478668.1 unnamed protein product [Peronospora belbahrii] | diamond | 2064 | 70.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora belbahrii | ||
| 31625058 | 31625058 | PRJNA493244_P_NODE_431196_length_800_cov_16.396482_g412343_i0 | PRJNA493244 | 431196 | 800 | 16.396482 | 131.171856 | Phytophthora kernoviae | 325452 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 2.1099999999999998e-60 | NR | RLN54175.1 | 325452 | g412343 | i0 | 44.8 | 0.9375 | 250 | 131 | 92.6 | 4 | 33 | 773 | 22 | 267 | RLN54175.1 hypothetical protein BBP00_00009039 [Phytophthora kernoviae] | diamond | 750 | 202 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 32321413 | 32321413 | PRJNA493244_P_NODE_1230679_length_318_cov_7.143969_g1207555_i0 | PRJNA493244 | 1230679 | 318 | 7.143969 | 22.71782142 | Hyaloperonospora brassicae | 162125 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 6.91e-11 | NR | CAI5722758.1 | 162125 | g1207555 | i0 | 81 | 0.39622641509434 | 42 | 7 | 38.7 | 1 | 296 | 174 | 363 | 404 | CAI5722758.1 unnamed protein product [Hyaloperonospora brassicae] | diamond | 126 | 68.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora brassicae | ||
| 32574471 | 32574471 | PRJNA493244_P_NODE_1559059_length_229_cov_2.333333_g1535934_i0 | PRJNA493244 | 1559059 | 229 | 2.333333 | 5.34333257 | Phytophthora fragariae | 53985 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.00669 | NR | KAE8938987.1 | 53985 | g1535934 | i0 | 32.7 | 1.70305676855895 | 55 | 37 | 72.1 | 0 | 8 | 172 | 28 | 82 | KAE8938987.1 hypothetical protein PF009_g11155 [Phytophthora fragariae] | diamond | 390 | 43.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae |
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);;