contig_metadata
17 rows where bioproject = "PRJNA1218816", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 333219 | 333219 | PRJNA1218816_P_NODE_28681_length_380_cov_1.368078_g28248_i0 | PRJNA1218816 | 28681 | 380 | 1.368078 | 5.1986964 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 8.68e-108 | NTclustered | gi|166047767|emb|CU362882.1| | 100861 | g28248 | i0 | 86.133 | 97.8473684210526 | 375 | 50 | 98 | 2 | 1 | 374 | 471 | 98 | Aphanomyces euteiches cDNA | blastn | 37182 | 403 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 333449 | 333449 | PRJNA1218816_P_NODE_54101_length_251_cov_0.865169_g53668_i0 | PRJNA1218816 | 54101 | 251 | 0.865169 | 2.17157419 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 7.789999999999999e-37 | NTclustered | gi|673017857|ref|XM_008864668.1| | 157072 | g53668 | i0 | 79.487 | 3.92430278884462 | 234 | 48 | 93 | 0 | 8 | 241 | 229 | 462 | Aphanomyces invadans 60S ribosomal protein mRNA | blastn | 985 | 167 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 1607958 | 1607958 | PRJNA1218816_P_NODE_23402_length_439_cov_2.043716_g22969_i0 | PRJNA1218816 | 23402 | 439 | 2.043716 | 8.97191324 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 4.97e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g22969 | i0 | 80.533 | 76.9635535307517 | 375 | 65 | 84 | 4 | 3 | 370 | 68 | 441 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33787 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 16910364 | 16910364 | PRJNA1218816_P_NODE_21934_length_460_cov_3.180879_g21501_i0 | PRJNA1218816 | 21934 | 460 | 3.180879 | 14.6320434 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 186 | 4.609999999999999e-55 | NR | KAG9404282.1 | 112091 | g21501 | i0 | 76.9 | 6.11739130434783 | 117 | 27 | 76.3 | 0 | 459 | 109 | 207 | 323 | KAG9404282.1 Guanine nucleotide-binding protein subunit beta-2-like 1 [Aphanomyces cochlioides] | diamond | 2814 | 186 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 25272438 | 25272438 | PRJNA1218816_P_NODE_37460_length_318_cov_1.885714_g37027_i0 | PRJNA1218816 | 37460 | 318 | 1.885714 | 5.99657052 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 5.930000000000001e-59 | NTclustered | gi|59894163|gb|AY729864.1| | 74557 | g37027 | i0 | 81.882 | 100.672955974843 | 287 | 50 | 90 | 2 | 3 | 288 | 941 | 1226 | Thraustotheca clavata heat shock protein 90 gene, partial cds | blastn | 32014 | 241 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 27249543 | 27249543 | PRJNA1218816_P_NODE_24443_length_425_cov_3.917614_g24010_i0 | PRJNA1218816 | 24443 | 425 | 3.917614 | 16.6498595 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 2.6799999999999993e-43 | NR | XP_024573476.1 | 4781 | g24010 | i0 | 64.7 | 9.64941176470588 | 116 | 41 | 81.9 | 0 | 414 | 67 | 533 | 648 | XP_024573476.1 dead deah box helicase [Plasmopara halstedii] | diamond | 4101 | 162 | 0.993827160493827 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 27420609 | 27420609 | PRJNA1218816_P_NODE_61183_length_243_cov_0.905882_g60750_i0 | PRJNA1218816 | 61183 | 243 | 0.905882 | 2.20129326 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 7.87e-11 | NR | KAF0697097.1 | 120398 | g60750 | i0 | 42.1 | 3.93827160493827 | 76 | 38 | 86.4 | 1 | 210 | 1 | 49 | 124 | KAF0697097.1 hypothetical protein As57867_012159 [Aphanomyces stellatus] | diamond | 957 | 67.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 27830777 | 27830777 | PRJNA1218816_P_NODE_56364_length_248_cov_0.880000_g55931_i0 | PRJNA1218816 | 56364 | 248 | 0.88 | 2.1824 | Phytophthora cactorum | 29920 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 9.429999999999997e-43 | NR | KAG4058653.1 | 29920 | g55931 | i0 | 87.8 | 9.91935483870968 | 82 | 10 | 99.2 | 0 | 247 | 2 | 221 | 302 | KAG4058653.1 Alanine--tRNA ligase, partial [Phytophthora cactorum] | diamond | 2460 | 157 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 28228245 | 28228245 | PRJNA1218816_P_NODE_54826_length_250_cov_0.870056_g54393_i0 | PRJNA1218816 | 54826 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 4.9e-12 | NR | POM76828.1 | 4796 | g54393 | i0 | 60.9 | 6.42 | 69 | 22 | 76.8 | 1 | 197 | 6 | 566 | 634 | POM76828.1 Histone deacetylase [Phytophthora palmivora] | diamond | 1605 | 71.6 | 0.990223463687151 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 28575745 | 28575745 | PRJNA1218816_P_NODE_31067_length_360_cov_1.073171_g30634_i0 | PRJNA1218816 | 31067 | 360 | 1.073171 | 3.8634156 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 7.080000000000001e-27 | NR | DBA01302.1 | 4803 | g30634 | i0 | 54.2 | 1.80833333333333 | 118 | 52 | 97.5 | 2 | 359 | 9 | 54 | 170 | DBA01302.1 TPA: hypothetical protein N0F65_001807 [Lagenidium giganteum] | diamond | 651 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 28670651 | 28670651 | PRJNA1218816_P_NODE_62847_length_241_cov_0.916667_g62414_i0 | PRJNA1218816 | 62847 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 1.21e-6 | NR | XP_024573036.1 | 4781 | g62414 | i0 | 59.5 | 2.78838174273859 | 42 | 17 | 52.3 | 0 | 13 | 138 | 281 | 322 | XP_024573036.1 camk protein kinase [Plasmopara halstedii] | diamond | 672 | 55.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 28809289 | 28809289 | PRJNA1218816_P_NODE_52428_length_255_cov_1.692308_g51995_i0 | PRJNA1218816 | 52428 | 255 | 1.692308 | 4.3153854 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 5.92e-8 | NR | KAH9104585.1 | 100861 | g51995 | i0 | 42.2 | 2.92941176470588 | 83 | 40 | 88.2 | 3 | 11 | 235 | 192 | 274 | KAH9104585.1 hypothetical protein AeMF1_019369 [Aphanomyces euteiches] | diamond | 747 | 59.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 28986517 | 28986517 | PRJNA1218816_P_NODE_49648_length_265_cov_1.416667_g49215_i0 | PRJNA1218816 | 49648 | 265 | 1.416667 | 3.75416755 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 8.2e-28 | NR | XP_067789141.1 | 4785 | g49215 | i0 | 55.2 | 7.85660377358491 | 87 | 39 | 98.5 | 0 | 3 | 263 | 5 | 91 | XP_067789141.1 40S ribosomal protein S10 [Phytophthora cinnamomi] | diamond | 2082 | 107 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 29270234 | 29270234 | PRJNA1218816_P_NODE_45889_length_280_cov_1.115942_g45456_i0 | PRJNA1218816 | 45889 | 280 | 1.115942 | 3.1246376 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 3.46e-44 | NR | POM73368.1 | 4796 | g45456 | i0 | 82.6 | 12.8142857142857 | 92 | 16 | 98.6 | 0 | 3 | 278 | 78 | 169 | POM73368.1 Pyridoxal biosynthesis lyase pdxS [Phytophthora palmivora] | diamond | 3588 | 152 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 30533771 | 30533771 | PRJNA1218816_P_NODE_44613_length_285_cov_1.415094_g44180_i0 | PRJNA1218816 | 44613 | 285 | 1.415094 | 4.0330179 | root | 1 | Root_unresolved | Root_unresolved | 121 | 1.59e-29 | NR | RLN60055.1 | 325452 | g44180 | i0 | 65.9 | 7.53684210526316 | 88 | 30 | 92.6 | 0 | 17 | 280 | 822 | 909 | RLN60055.1 hypothetical protein BBP00_00006218 [Phytophthora kernoviae] | diamond | 2148 | 122 | 0.991803278688525 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora kernoviae | ||
| 31115104 | 31115104 | PRJNA1218816_P_NODE_50495_length_262_cov_1.301587_g50062_i0 | PRJNA1218816 | 50495 | 262 | 1.301587 | 3.41015794 | Peronosclerospora sorghi | 230839 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 9.82e-16 | NR | KAI9909779.1 | 230839 | g50062 | i0 | 50 | 2.48473282442748 | 72 | 36 | 82.4 | 0 | 10 | 225 | 753 | 824 | KAI9909779.1 hypothetical protein PsorP6_011182 [Peronosclerospora sorghi] | diamond | 651 | 81.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 31811136 | 31811136 | PRJNA1218816_P_NODE_48337_length_270_cov_1.172589_g47904_i0 | PRJNA1218816 | 48337 | 270 | 1.172589 | 3.1659903 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0175 | NR | TMW65280.1 | 41045 | g47904 | i0 | 42.9 | 1.83333333333333 | 42 | 23 | 45.6 | 1 | 2 | 124 | 124 | 165 | TMW65280.1 hypothetical protein Poli38472_007922 [Pythium oligandrum] | diamond | 495 | 43.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum |
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);;