contig_metadata
19 rows where bioproject = "PRJNA680334", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 650013 | 650013 | PRJNA680334_S_NODE_61441_length_180_cov_1.278912_g60955_i0 | PRJNA680334 | 61441 | 180 | 1.278912 | 2.3020416 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 2.2699999999999996e-85 | NTclustered | gi|166044664|emb|CU367573.1| | 100861 | g60955 | i0 | 99.444 | 99.3555555555556 | 180 | 1 | 100 | 0 | 1 | 180 | 496 | 675 | Aphanomyces euteiches cDNA | blastn | 17884 | 327 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 2444541 | 2444541 | PRJNA680334_S_NODE_11562_length_300_cov_5.112360_g11076_i0 | PRJNA680334 | 11562 | 300 | 5.11236 | 15.33708 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 472 | 1.81e-128 | NTclustered | gi|1542033659|ref|NC_040179.1| | 4779 | g11076 | i0 | 95.578 | 97.21 | 294 | 13 | 98 | 0 | 7 | 300 | 674 | 967 | Bremia lactucae mitochondrion, complete genome | blastn | 29163 | 472 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 2444746 | 2444746 | PRJNA680334_S_NODE_74242_length_169_cov_2.448529_g73756_i0 | PRJNA680334 | 74242 | 169 | 2.448529 | 4.13801401 | root | 1 | Root_unresolved | Root_unresolved | 313 | 5.859999999999999e-81 | NTclustered | gi|166046611|emb|CU367728.1| | 100861 | g73756 | i0 | 100 | 97.508875739645 | 169 | 0 | 100 | 0 | 1 | 169 | 420 | 252 | Aphanomyces euteiches cDNA | blastn | 16479 | 313 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 3721093 | 3721093 | PRJNA680334_S_NODE_66223_length_175_cov_4.992958_g65737_i0 | PRJNA680334 | 66223 | 175 | 4.992958 | 8.7376765 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 2.25e-65 | NTclustered | gi|338798143|gb|HQ665204.1| | 82935 | g65737 | i0 | 93.75 | 100.485714285714 | 176 | 8 | 100 | 2 | 1 | 175 | 112 | 285 | Pythium deliense isolate CBS 314.33 28S large subunit ribosomal RNA gene, partial sequence | blastn | 17585 | 261 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium deliense | ||
| 7028072 | 7028072 | PRJNA680334_S_NODE_23406_length_242_cov_6.373206_g22920_i0 | PRJNA680334 | 23406 | 242 | 6.373206 | 15.42315852 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 78.7 | 3.6e-10 | NTclustered | gi|695374258|ref|XM_009516957.1| | 67593 | g22920 | i0 | 91.228 | 0.462809917355372 | 57 | 5 | 24 | 0 | 80 | 136 | 525 | 581 | Phytophthora sojae hypothetical protein mRNA | blastn | 112 | 78.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 7547079 | 7547079 | PRJNA680334_S_NODE_106126_length_150_cov_9.547009_g105640_i0 | PRJNA680334 | 106126 | 150 | 9.547009 | 14.3205135 | root | 1 | Root_unresolved | Root_unresolved | 272 | 8.609999999999998e-69 | NTclustered | gi|166046651|emb|CU367768.1| | 100861 | g105640 | i0 | 99.333 | 4 | 150 | 1 | 100 | 0 | 1 | 150 | 359 | 508 | Aphanomyces euteiches cDNA | blastn | 600 | 272 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 7547258 | 7547258 | PRJNA680334_S_NODE_64146_length_177_cov_3.354167_g63660_i0 | PRJNA680334 | 64146 | 177 | 3.354167 | 5.93687559 | root | 1 | Root_unresolved | Root_unresolved | 320 | 3.71e-83 | NTclustered | gi|166044655|emb|CU367564.1| | 100861 | g63660 | i0 | 99.432 | 18.3446327683616 | 176 | 1 | 99 | 0 | 1 | 176 | 215 | 390 | Aphanomyces euteiches cDNA | blastn | 3247 | 320 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 8302862 | 8302862 | PRJNA680334_S_NODE_30507_length_223_cov_8.289474_g30021_i0 | PRJNA680334 | 30507 | 223 | 8.289474 | 18.48552702 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.47e-33 | NTclustered | gi|669146513|ref|XM_008610597.1| | 1156394 | g30021 | i0 | 79.452 | 9.29596412556054 | 219 | 45 | 98 | 0 | 5 | 223 | 434 | 216 | Saprolegnia diclina VS20 40S ribosomal protein S20 mRNA | blastn | 2073 | 156 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 17747097 | 17747097 | PRJNA680334_S_NODE_36454_length_211_cov_14.269663_g35968_i0 | PRJNA680334 | 36454 | 211 | 14.269663 | 30.10898893 | Hyaloperonospora | 184462 | SAR_Eukaryotes | SAR_Eukaryotes | 385 | 1.61e-102 | NTclustered | gi|158519308|gb|EU054868.1| | 123356 | g35968 | i0 | 99.526 | 99.914691943128 | 211 | 1 | 100 | 0 | 1 | 211 | 74 | 284 | Hyaloperonospora parasitica strain J4011/01 (TUB 12421) large subunit ribosomal RNA gene, partial sequence | blastn | 21082 | 385 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 19021043 | 19021043 | PRJNA680334_S_NODE_37475_length_210_cov_1.988701_g36989_i0 | PRJNA680334 | 37475 | 210 | 1.988701 | 4.1762721 | root | 1 | Root_unresolved | Root_unresolved | 388 | 1.24e-103 | NTclustered | gi|166046794|emb|CU367369.1| | 100861 | g36989 | i0 | 100 | 99.9285714285714 | 210 | 0 | 100 | 0 | 1 | 210 | 409 | 618 | Aphanomyces euteiches cDNA | blastn | 20985 | 388 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 20295503 | 20295503 | PRJNA680334_S_NODE_101376_length_153_cov_1.666667_g100890_i0 | PRJNA680334 | 101376 | 153 | 1.666667 | 2.55000051 | root | 1 | Root_unresolved | Root_unresolved | 283 | 4.0799999999999995e-72 | NTclustered | gi|166046559|emb|CU367676.1| | 100861 | g100890 | i0 | 100 | 8.67320261437908 | 153 | 0 | 100 | 0 | 1 | 153 | 176 | 328 | Aphanomyces euteiches cDNA | blastn | 1327 | 283 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 20295639 | 20295639 | PRJNA680334_S_NODE_45596_length_197_cov_5.756098_g45110_i0 | PRJNA680334 | 45596 | 197 | 5.756098 | 11.33951306 | root | 1 | Root_unresolved | Root_unresolved | 364 | 1.929999999999999e-96 | NTclustered | gi|166044531|emb|CU367440.1| | 100861 | g45110 | i0 | 100 | 12.7817258883249 | 197 | 0 | 100 | 0 | 1 | 197 | 2 | 198 | Aphanomyces euteiches cDNA | blastn | 2518 | 364 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 21052193 | 21052193 | PRJNA680334_S_NODE_35457_length_213_cov_5.238889_g34971_i0 | PRJNA680334 | 35457 | 213 | 5.238889 | 11.15883357 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 89.8 | 1.43e-13 | NTclustered | gi|2795018750|ref|XM_067929461.1| | 4785 | g34971 | i0 | 87.342 | 0.793427230046948 | 79 | 8 | 37 | 2 | 7 | 84 | 117 | 194 | Phytophthora cinnamomi 40S ribosomal protein S28-A (IUM83_05328), partial mRNA | blastn | 169 | 89.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 21571427 | 21571427 | PRJNA680334_S_NODE_31257_length_222_cov_2.693122_g30771_i0 | PRJNA680334 | 31257 | 222 | 2.693122 | 5.97873084 | root | 1 | Root_unresolved | Root_unresolved | 401 | 1.6999999999999994e-107 | NTclustered | gi|166046506|emb|CU367623.1| | 100861 | g30771 | i0 | 99.548 | 41.0495495495495 | 221 | 0 | 99 | 1 | 1 | 221 | 638 | 419 | Aphanomyces euteiches cDNA | blastn | 9113 | 401 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 21571509 | 21571509 | PRJNA680334_S_NODE_56337_length_185_cov_1.342105_g55851_i0 | PRJNA680334 | 56337 | 185 | 1.342105 | 2.48289425 | root | 1 | Root_unresolved | Root_unresolved | 340 | 3.0099999999999993e-89 | NTclustered | gi|166046519|emb|CU367636.1| | 100861 | g55851 | i0 | 100 | 94.4378378378378 | 184 | 0 | 99 | 0 | 2 | 185 | 420 | 237 | Aphanomyces euteiches cDNA | blastn | 17471 | 340 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 21571591 | 21571591 | PRJNA680334_S_NODE_82277_length_163_cov_6.569231_g81791_i0 | PRJNA680334 | 82277 | 163 | 6.569231 | 10.70784653 | root | 1 | Root_unresolved | Root_unresolved | 296 | 5.68e-76 | NTclustered | gi|166046580|emb|CU367697.1| | 100861 | g81791 | i0 | 99.39 | 101.361963190184 | 164 | 0 | 100 | 1 | 1 | 163 | 363 | 526 | Aphanomyces euteiches cDNA | blastn | 16522 | 296 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 22327686 | 22327686 | PRJNA680334_S_NODE_73918_length_169_cov_3.625000_g73432_i0 | PRJNA680334 | 73918 | 169 | 3.625 | 6.12625 | Plasmopara viticola | 143451 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 5.859999999999999e-81 | NTclustered | gi|126565763|gb|EF426546.1| | 143451 | g73432 | i0 | 100 | 93.414201183432 | 169 | 0 | 100 | 0 | 1 | 169 | 36 | 204 | Plasmopara viticola strain UASWS SG1 28S ribosomal RNA gene, complete sequence | blastn | 15787 | 313 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara viticola | ||
| 22846831 | 22846831 | PRJNA680334_S_NODE_85518_length_161_cov_6.085938_g85032_i0 | PRJNA680334 | 85518 | 161 | 6.085938 | 9.79836018 | root | 1 | Root_unresolved | Root_unresolved | 291 | 2.6e-74 | NTclustered | gi|166044514|emb|CU367423.1| | 100861 | g85032 | i0 | 99.379 | 99.3229813664596 | 161 | 0 | 100 | 1 | 1 | 161 | 622 | 463 | Aphanomyces euteiches cDNA | blastn | 15991 | 291 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 24876064 | 24876064 | PRJNA680334_S_NODE_52640_length_189_cov_1.653846_g52154_i0 | PRJNA680334 | 52640 | 189 | 1.653846 | 3.12576894 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 3.3600000000000003e-29 | NTclustered | gi|695393193|ref|XM_009522251.1| | 67593 | g52154 | i0 | 82.209 | 86.2486772486773 | 163 | 29 | 86 | 0 | 26 | 188 | 1298 | 1136 | Phytophthora sojae hypothetical protein mRNA | blastn | 16301 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae |
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);;