contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA385396" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13830054 | 13830054 | PRJNA385396_P_NODE_9111_length_295_cov_1.373874_g9019_i0 | PRJNA385396 | 9111 | 295 | 1.373874 | 4.0529283 | Saprolegnia parasitica CBS 223.65 | 695850 | SAR_Eukaryotes | SAR_Eukaryotes | 184 | 1.8199999999999997e-57 | NR | XP_012206797.1 | 695850 | g9019 | i0 | 96.9 | 0.996610169491525 | 98 | 3 | 99.7 | 0 | 295 | 2 | 1 | 98 | XP_012206797.1 60S ribosomal protein L12 [Saprolegnia parasitica CBS 223.65] | diamond | 294 | 184 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 14435795 | 14435795 | PRJNA385396_P_NODE_2772_length_456_cov_1.501305_g2680_i0 | PRJNA385396 | 2772 | 456 | 1.501305 | 6.8459508 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 2.34e-32 | NR | KAJ0405433.1 | 114742 | g2680 | i0 | 58.5 | 3.88157894736842 | 118 | 48 | 77.6 | 1 | 454 | 101 | 19 | 135 | KAJ0405433.1 hypothetical protein P43SY_005052 [Pythium insidiosum] | diamond | 1770 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 16379021 | 16379021 | PRJNA385396_P_NODE_16513_length_247_cov_0.885057_g16421_i0 | PRJNA385396 | 16513 | 247 | 0.885057 | 2.18609079 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.69e-35 | NR | XP_008878394.1 | 157072 | g16421 | i0 | 72 | 0.995951417004049 | 82 | 19 | 99.6 | 1 | 2 | 247 | 25 | 102 | XP_008878394.1 hypothetical protein H310_12906 [Aphanomyces invadans] | diamond | 246 | 129 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 26758602 | 26758602 | PRJNA385396_P_NODE_21561_length_241_cov_0.916667_g21469_i0 | PRJNA385396 | 21561 | 241 | 0.916667 | 2.20916747 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 3.37e-10 | NR | RHY30613.1 | 157072 | g21469 | i0 | 74.7 | 0.983402489626556 | 79 | 20 | 98.3 | 0 | 3 | 239 | 51 | 129 | RHY30613.1 hypothetical protein DYB32_004189 [Aphanomyces invadans] | diamond | 237 | 65.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 27264935 | 27264935 | PRJNA385396_P_NODE_13983_length_251_cov_0.865169_g13891_i0 | PRJNA385396 | 13983 | 251 | 0.865169 | 2.17157419 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 2.99e-20 | NR | KAF0690126.1 | 120398 | g13891 | i0 | 57.8 | 0.99203187250996006 | 83 | 32 | 95.6 | 1 | 6 | 245 | 7 | 89 | KAF0690126.1 hypothetical protein As57867_018389 [Aphanomyces stellatus] | diamond | 249 | 90.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 27454633 | 27454633 | PRJNA385396_P_NODE_11243_length_271_cov_1.363636_g11151_i0 | PRJNA385396 | 11243 | 271 | 1.363636 | 3.69545356 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 5.81e-12 | NR | KAF0686091.1 | 120398 | g11151 | i0 | 53.1 | 1.08487084870849 | 98 | 37 | 98.5 | 3 | 4 | 270 | 8 | 105 | KAF0686091.1 hypothetical protein As57867_021987 [Aphanomyces stellatus] | diamond | 294 | 70.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 27517615 | 27517615 | PRJNA385396_P_NODE_13583_length_251_cov_0.865169_g13491_i0 | PRJNA385396 | 13583 | 251 | 0.865169 | 2.17157419 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 1.15e-38 | NR | RHY26867.1 | 157072 | g13491 | i0 | 85.5 | 1.9840637450199201 | 83 | 12 | 99.2 | 0 | 249 | 1 | 89 | 171 | RHY26867.1 hypothetical protein DYB32_007220 [Aphanomyces invadans] | diamond | 498 | 140 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 27692586 | 27692586 | PRJNA385396_P_NODE_17264_length_246_cov_0.890173_g17172_i0 | PRJNA385396 | 17264 | 246 | 0.890173 | 2.18982558 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 9.19e-7 | NR | KAG9415638.1 | 112091 | g17172 | i0 | 48.6 | 1.9390243902439 | 72 | 34 | 86.6 | 2 | 214 | 2 | 458 | 527 | KAG9415638.1 hypothetical protein AC1031_000021 [Aphanomyces cochlioides] | diamond | 477 | 55.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 27770402 | 27770402 | PRJNA385396_P_NODE_8244_length_307_cov_1.294872_g8152_i0 | PRJNA385396 | 8244 | 307 | 1.294872 | 3.97525704 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.2199999999999999e-54 | NR | KAG9413149.1 | 112091 | g8152 | i0 | 82.4 | 2.99022801302932 | 102 | 18 | 99.7 | 0 | 306 | 1 | 6 | 107 | KAG9413149.1 Cytochrome c oxidase subunit 5B [Aphanomyces cochlioides] | diamond | 918 | 176 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 28039676 | 28039676 | PRJNA385396_P_NODE_14625_length_250_cov_0.870056_g14533_i0 | PRJNA385396 | 14625 | 250 | 0.870056 | 2.17514 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 7.12e-27 | NR | KAH9081102.1 | 100861 | g14533 | i0 | 64.6 | 3.912 | 82 | 29 | 98.4 | 0 | 248 | 3 | 15 | 96 | KAH9081102.1 hypothetical protein Ae201684P_012074 [Aphanomyces euteiches] | diamond | 978 | 112 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 28370028 | 28370028 | PRJNA385396_P_NODE_17726_length_246_cov_0.890173_g17634_i0 | PRJNA385396 | 17726 | 246 | 0.890173 | 2.18982558 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 71.6 | 1.29e-13 | NR | KAF0698374.1 | 120398 | g17634 | i0 | 55.4 | 0.792682926829268 | 65 | 27 | 78 | 2 | 196 | 5 | 50 | 113 | KAF0698374.1 hypothetical protein As57867_010959 [Aphanomyces stellatus] | diamond | 195 | 71.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 29001976 | 29001976 | PRJNA385396_P_NODE_14968_length_249_cov_0.875000_g14876_i0 | PRJNA385396 | 14968 | 249 | 0.875 | 2.17875 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 162 | 3.54e-44 | NR | RHY31415.1 | 157072 | g14876 | i0 | 89 | 5.92771084337349 | 82 | 9 | 98.8 | 0 | 247 | 2 | 1012 | 1093 | RHY31415.1 hypothetical protein DYB32_003508 [Aphanomyces invadans] | diamond | 1476 | 162 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 30360052 | 30360052 | PRJNA385396_P_NODE_16912_length_247_cov_0.885057_g16820_i0 | PRJNA385396 | 16912 | 247 | 0.885057 | 2.18609079 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 4.15e-41 | NR | KAF0685570.1 | 120398 | g16820 | i0 | 97.3 | 1.76113360323887 | 73 | 2 | 88.7 | 0 | 246 | 28 | 214 | 286 | KAF0685570.1 hypothetical protein As57867_022508 [Aphanomyces stellatus] | diamond | 435 | 145 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 30517553 | 30517553 | PRJNA385396_P_NODE_19153_length_244_cov_0.900585_g19061_i0 | PRJNA385396 | 19153 | 244 | 0.900585 | 2.1974274 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 97.4 | 8.84e-22 | NR | KAF0690133.1 | 120398 | g19061 | i0 | 72.1 | 0.836065573770492 | 68 | 19 | 83.6 | 0 | 204 | 1 | 25 | 92 | KAF0690133.1 hypothetical protein As57867_018396 [Aphanomyces stellatus] | diamond | 204 | 97.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 30850314 | 30850314 | PRJNA385396_P_NODE_1814_length_550_cov_0.966457_g1722_i0 | PRJNA385396 | 1814 | 550 | 0.966457 | 5.3155135 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 3.5199999999999996e-24 | NR | XP_067823137.1 | 4779 | g1722 | i0 | 37.4 | 13.3636363636364 | 179 | 94 | 88.4 | 3 | 8 | 493 | 163 | 340 | XP_067823137.1 uncharacterized protein CCR75_003021 [Bremia lactucae] | diamond | 7350 | 107 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 30959969 | 30959969 | PRJNA385396_P_NODE_21114_length_241_cov_0.916667_g21022_i0 | PRJNA385396 | 21114 | 241 | 0.916667 | 2.20916747 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 1.68e-18 | NR | XP_009840076.1 | 112090 | g21022 | i0 | 63 | 1.81742738589212 | 73 | 27 | 90.9 | 0 | 233 | 15 | 15 | 87 | XP_009840076.1 hypothetical protein H257_14051 [Aphanomyces astaci] | diamond | 438 | 87.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 32193363 | 32193363 | PRJNA385396_P_NODE_13818_length_251_cov_0.865169_g13726_i0 | PRJNA385396 | 13818 | 251 | 0.865169 | 2.17157419 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 1.45e-18 | NR | KAH9094823.1 | 100861 | g13726 | i0 | 58.3 | 1.00398406374502 | 84 | 24 | 93.2 | 3 | 235 | 2 | 234 | 312 | KAH9094823.1 hypothetical protein LEN26_018077 [Aphanomyces euteiches] | diamond | 252 | 89.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 32256945 | 32256945 | PRJNA385396_P_NODE_15018_length_249_cov_0.875000_g14926_i0 | PRJNA385396 | 15018 | 249 | 0.875 | 2.17875 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 5.0599999999999995e-45 | NR | KAG9405873.1 | 112091 | g14926 | i0 | 84.1 | 0.987951807228916 | 82 | 13 | 98.8 | 0 | 248 | 3 | 49 | 130 | KAG9405873.1 hypothetical protein AC1031_003791 [Aphanomyces cochlioides] | diamond | 246 | 154 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 32383120 | 32383120 | PRJNA385396_P_NODE_11639_length_267_cov_1.329897_g11547_i0 | PRJNA385396 | 11639 | 267 | 1.329897 | 3.55082499 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0275 | NR | TMW62031.1 | 41045 | g11547 | i0 | 29.8 | 0.943820224719101 | 84 | 56 | 91 | 1 | 23 | 265 | 1338 | 1421 | TMW62031.1 hypothetical protein Poli38472_009524 [Pythium oligandrum] | diamond | 252 | 43.5 | 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);;