contig_metadata
17 rows where bioproject = "PRJNA929922", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2182029 | 2182029 | PRJNA929922_P_NODE_162902_length_241_cov_0.916667_g162362_i0 | PRJNA929922 | 162902 | 241 | 0.916667 | 2.20916747 | Bremia lactucae | 4779 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 8.759999999999998e-101 | NTclustered | gi|2794721556|ref|XM_067967754.1| | 4779 | g162362 | i0 | 95.021 | 1.44398340248963 | 241 | 12 | 100 | 0 | 1 | 241 | 799 | 1039 | Bremia lactucae uncharacterized protein (CCR75_009715), partial mRNA | blastn | 348 | 379 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 12386584 | 12386584 | PRJNA929922_P_NODE_7550_length_574_cov_0.988024_g7027_i0 | PRJNA929922 | 7550 | 574 | 0.988024 | 5.67125776 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.17e-30 | NR | XP_067737238.1 | 164328 | g7027 | i0 | 44.2 | 4.2595818815331 | 163 | 89 | 84.1 | 2 | 493 | 11 | 510 | 672 | XP_067737238.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Phytophthora ramorum] | diamond | 2445 | 129 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 23861030 | 23861030 | PRJNA929922_S_NODE_68099_length_243_cov_0.905882_g67875_i0 | PRJNA929922 | 68099 | 243 | 0.905882 | 2.20129326 | Peronospora aestivalis | 162107 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.09e-120 | NTclustered | gi|145209007|gb|AY035482.2| | 162107 | g67875 | i0 | 99.588 | 100 | 243 | 1 | 100 | 0 | 1 | 243 | 259 | 17 | Peronospora aestivalis isolate HV 167 large subunit ribosomal RNA gene, partial sequence | blastn | 24300 | 444 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora aestivalis | ||
| 25133324 | 25133324 | PRJNA929922_P_NODE_53060_length_318_cov_1.257143_g52520_i0 | PRJNA929922 | 53060 | 318 | 1.257143 | 3.99771474 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 2.16e-48 | NTclustered | gi|673036523|ref|XM_008874001.1| | 157072 | g52520 | i0 | 78.638 | 9.47169811320755 | 323 | 59 | 100 | 8 | 1 | 318 | 1180 | 863 | Aphanomyces invadans hypothetical protein mRNA | blastn | 3012 | 206 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 27632338 | 27632338 | PRJNA929922_P_NODE_58624_length_309_cov_0.872881_g58084_i0 | PRJNA929922 | 58624 | 309 | 0.872881 | 2.69720229 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 0.00171 | NR | KAH9153253.1 | 100861 | g58084 | i0 | 51.3 | 2.72815533980583 | 39 | 19 | 37.9 | 0 | 228 | 112 | 110 | 148 | KAH9153253.1 hypothetical protein AeRB84_004457 [Aphanomyces euteiches] | diamond | 843 | 47.8 | 0.99163179916318 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 27656939 | 27656939 | PRJNA929922_P_NODE_161564_length_241_cov_0.916667_g161024_i0 | PRJNA929922 | 161564 | 241 | 0.916667 | 2.20916747 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00543 | NR | OQR85254.1 | 1202772 | g161024 | i0 | 44.4 | 0.560165975103734 | 45 | 17 | 56 | 2 | 18 | 152 | 618 | 654 | OQR85254.1 hypothetical protein ACHHYP_12041 [Achlya hypogyna] | diamond | 135 | 45.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 27751702 | 27751702 | PRJNA929922_P_NODE_124024_length_248_cov_0.880000_g123484_i0 | PRJNA929922 | 124024 | 248 | 0.88 | 2.1824 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00428 | NR | KAH9107631.1 | 100861 | g123484 | i0 | 40.7 | 2.61290322580645 | 54 | 30 | 62.9 | 1 | 35 | 190 | 164 | 217 | KAH9107631.1 hypothetical protein AeMF1_017065, partial [Aphanomyces euteiches] | diamond | 648 | 45.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 27877771 | 27877771 | PRJNA929922_P_NODE_108145_length_251_cov_0.865169_g107605_i0 | PRJNA929922 | 108145 | 251 | 0.865169 | 2.17157419 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.00242 | NR | KAJ8503125.1 | 4785 | g107605 | i0 | 50 | 0.573705179282869 | 48 | 23 | 56.2 | 1 | 215 | 75 | 6 | 53 | KAJ8503125.1 hypothetical protein ON010_g19125 [Phytophthora cinnamomi] | diamond | 144 | 43.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 28042759 | 28042759 | PRJNA929922_P_NODE_3785_length_737_cov_1.138554_g3305_i0 | PRJNA929922 | 3785 | 737 | 1.138554 | 8.39114298 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 3.5799999999999995e-31 | NR | XP_067797790.1 | 4785 | g3305 | i0 | 55.9 | 6.05698778833107 | 127 | 54 | 50.9 | 1 | 2 | 376 | 235 | 361 | XP_067797790.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Phytophthora cinnamomi] | diamond | 4464 | 130 | 0.992307692307692 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 28793285 | 28793285 | PRJNA929922_P_NODE_163487_length_241_cov_0.916667_g162947_i0 | PRJNA929922 | 163487 | 241 | 0.916667 | 2.20916747 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00151 | NR | KAF0692072.1 | 120398 | g162947 | i0 | 40 | 0.746887966804979 | 60 | 32 | 69.7 | 1 | 73 | 240 | 68 | 127 | KAF0692072.1 hypothetical protein As57867_016730, partial [Aphanomyces stellatus] | diamond | 180 | 46.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 29835314 | 29835314 | PRJNA929922_P_NODE_128111_length_247_cov_0.885057_g127571_i0 | PRJNA929922 | 128111 | 247 | 0.885057 | 2.18609079 | Peronosclerospora sorghi | 230839 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.047 | NR | KAI9922459.1 | 230839 | g127571 | i0 | 37.7 | 1.08097165991903 | 53 | 33 | 64.4 | 0 | 245 | 87 | 44 | 96 | KAI9922459.1 hypothetical protein PsorP6_001201 [Peronosclerospora sorghi] | diamond | 267 | 42 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 29842439 | 29842439 | PRJNA929922_P_NODE_160911_length_241_cov_0.916667_g160371_i0 | PRJNA929922 | 160911 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 4.71e-21 | NR | KAH9116034.1 | 100861 | g160371 | i0 | 56.3 | 2.65145228215768 | 71 | 31 | 88.4 | 0 | 221 | 9 | 124 | 194 | KAH9116034.1 hypothetical protein AeMF1_010004 [Aphanomyces euteiches] | diamond | 639 | 94.7 | 0.992608236536431 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 29937297 | 29937297 | PRJNA929922_P_NODE_130411_length_247_cov_0.885057_g129871_i0 | PRJNA929922 | 130411 | 247 | 0.885057 | 2.18609079 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 3.67e-7 | NR | OWZ09846.1 | 4795 | g129871 | i0 | 42.9 | 4.2753036437247 | 56 | 32 | 68 | 0 | 64 | 231 | 389 | 444 | OWZ09846.1 LOW QUALITY PROTEIN: hypothetical protein PHMEG_00017388 [Phytophthora megakarya] | diamond | 1056 | 57 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 29937303 | 29937303 | PRJNA929922_P_NODE_64271_length_300_cov_0.863436_g63731_i0 | PRJNA929922 | 64271 | 300 | 0.863436 | 2.590308 | root | 1 | Root_unresolved | Root_unresolved | 85.1 | 5.49e-17 | NR | KAH9088139.1 | 100861 | g63731 | i0 | 39.4 | 6.93 | 99 | 59 | 99 | 1 | 300 | 4 | 211 | 308 | KAH9088139.1 hypothetical protein Ae201684P_002241 [Aphanomyces euteiches] | diamond | 2079 | 85.9 | 0.990686845168801 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 30467589 | 30467589 | PRJNA929922_P_NODE_67273_length_295_cov_1.387387_g66733_i0 | PRJNA929922 | 67273 | 295 | 1.387387 | 4.09279165 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 9.41e-7 | NR | OQR88966.1 | 1202772 | g66733 | i0 | 34.3 | 1.00677966101695 | 99 | 61 | 97.6 | 3 | 8 | 295 | 87 | 184 | OQR88966.1 hypothetical protein ACHHYP_06546 [Achlya hypogyna] | diamond | 297 | 56.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 31510384 | 31510384 | PRJNA929922_P_NODE_146596_length_244_cov_0.900585_g146056_i0 | PRJNA929922 | 146596 | 244 | 0.900585 | 2.1974274 | Phytophthora fragariae | 53985 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 5.39e-5 | NR | KAE9063837.1 | 53985 | g146056 | i0 | 57.5 | 0.983606557377049 | 40 | 16 | 48 | 1 | 197 | 81 | 84 | 123 | KAE9063837.1 hypothetical protein PF006_g30847 [Phytophthora fragariae] | diamond | 240 | 50.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 32774585 | 32774585 | PRJNA929922_P_NODE_105140_length_252_cov_0.854749_g104600_i0 | PRJNA929922 | 105140 | 252 | 0.854749 | 2.15396748 | Phytophthora cactorum | 29920 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 8.04e-5 | NR | KAG2758968.1 | 29920 | g104600 | i0 | 51 | 6.46428571428571 | 49 | 24 | 58.3 | 0 | 208 | 62 | 544 | 592 | KAG2758968.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Phytophthora cactorum] | diamond | 1629 | 50.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum |
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);;