contig_metadata
14 rows where bioproject = "PRJNA345071" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4898253 | 4898253 | PRJNA345071_P_NODE_8384_length_250_cov_0.881356_g8344_i0 | PRJNA345071 | 8384 | 250 | 0.881356 | 2.20339 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 2.11e-52 | NTclustered | gi|2795025992|ref|XM_067924992.1| | 4785 | g8344 | i0 | 82.996 | 79.084 | 247 | 36 | 98 | 6 | 7 | 250 | 693 | 936 | Phytophthora cinnamomi chaperonin GroL (IUM83_01160), partial mRNA | blastn | 19771 | 219 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 6771088 | 6771088 | PRJNA345071_P_NODE_9066_length_248_cov_0.891429_g9026_i0 | PRJNA345071 | 9066 | 248 | 0.891429 | 2.21074392 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 1.71e-39 | NR | DAZ97811.1 | 4803 | g9026 | i0 | 80.5 | 38.6854838709677 | 82 | 16 | 99.2 | 0 | 247 | 2 | 269 | 350 | DAZ97811.1 TPA: hypothetical protein N0F65_002481 [Lagenidium giganteum] | diamond | 9594 | 145 | 0.993103448275862 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 9998551 | 9998551 | PRJNA345071_P_NODE_1808_length_416_cov_3.518950_g1768_i0 | PRJNA345071 | 1808 | 416 | 3.51895 | 14.638832 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 6.060000000000001e-70 | NTclustered | gi|23394353|gb|AF424642.1| | 4787 | g1768 | i0 | 80.886 | 50.9855769230769 | 361 | 62 | 86 | 5 | 53 | 411 | 144 | 499 | Phytophthora infestans clone MY-03-E-01 ADP/ATP translocase mRNA, complete cds | blastn | 21210 | 278 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 10597150 | 10597150 | PRJNA345071_P_NODE_7409_length_255_cov_1.318681_g7369_i0 | PRJNA345071 | 7409 | 255 | 1.318681 | 3.36263655 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 9.31e-41 | NR | GLD93518.1 | 114742 | g7369 | i0 | 90.5 | 5.87058823529412 | 84 | 8 | 98.8 | 0 | 2 | 253 | 57 | 140 | GLD93518.1 hypothetical protein PINS_up002110 [Pythium insidiosum] | diamond | 1497 | 149 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 20794820 | 20794820 | PRJNA345071_P_NODE_7577_length_253_cov_1.405556_g7537_i0 | PRJNA345071 | 7577 | 253 | 1.405556 | 3.55605668 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 2.22e-30 | NR | KAJ8525774.1 | 4785 | g7537 | i0 | 73.8 | 36.8300395256917 | 84 | 22 | 99.6 | 0 | 252 | 1 | 662 | 745 | KAJ8525774.1 hypothetical protein ON010_g15340 [Phytophthora cinnamomi] | diamond | 9318 | 124 | 0.991935483870968 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 27927610 | 27927610 | PRJNA345071_P_NODE_10965_length_239_cov_2.704819_g10925_i0 | PRJNA345071 | 10965 | 239 | 2.704819 | 6.46451741 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 73.6 | 4.85e-13 | NR | RHY26857.1 | 157072 | g10925 | i0 | 53.8 | 0.97907949790795 | 78 | 21 | 96.7 | 3 | 231 | 1 | 48 | 111 | RHY26857.1 hypothetical protein DYB32_007280 [Aphanomyces invadans] | diamond | 234 | 73.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 28938055 | 28938055 | PRJNA345071_P_NODE_8648_length_249_cov_0.886364_g8608_i0 | PRJNA345071 | 8648 | 249 | 0.886364 | 2.20704636 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 0.0013 | NR | GLE06415.1 | 114742 | g8608 | i0 | 38.6 | 0.843373493975904 | 70 | 36 | 84.3 | 3 | 222 | 13 | 256 | 318 | GLE06415.1 hypothetical protein PINS_up015662 [Pythium insidiosum] | diamond | 210 | 47 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 29600718 | 29600718 | PRJNA345071_P_NODE_10250_length_244_cov_0.912281_g10210_i0 | PRJNA345071 | 10250 | 244 | 0.912281 | 2.22596564 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 52 | 2.06e-5 | NR | DAZ99424.1 | 4803 | g10210 | i0 | 50 | 2.13934426229508 | 58 | 21 | 61.5 | 1 | 152 | 3 | 170 | 227 | DAZ99424.1 TPA: LOW QUALITY PROTEIN: hypothetical protein N0F65_004057, partial [Lagenidium giganteum] | diamond | 522 | 52 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 30502726 | 30502726 | PRJNA345071_P_NODE_5193_length_287_cov_1.457944_g5153_i0 | PRJNA345071 | 5193 | 287 | 1.457944 | 4.18429928 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 6.969999999999999e-46 | NR | KAJ8533370.1 | 4785 | g5153 | i0 | 76.8 | 16.9128919860627 | 95 | 22 | 99.3 | 0 | 1 | 285 | 581 | 675 | KAJ8533370.1 hypothetical protein ON010_g13884 [Phytophthora cinnamomi] | diamond | 4854 | 167 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 30913599 | 30913599 | PRJNA345071_P_NODE_7734_length_253_cov_0.866667_g7694_i0 | PRJNA345071 | 7734 | 253 | 0.866667 | 2.19266751 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 8.19e-28 | NR | RHY29595.1 | 157072 | g7694 | i0 | 56 | 1.9802371541502 | 84 | 37 | 99.6 | 0 | 1 | 252 | 56 | 139 | RHY29595.1 hypothetical protein DYB32_005022 [Aphanomyces invadans] | diamond | 501 | 114 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 30945156 | 30945156 | PRJNA345071_P_NODE_2554_length_365_cov_2.815068_g2514_i0 | PRJNA345071 | 2554 | 365 | 2.815068 | 10.2749982 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 1.02e-33 | NR | CCI49799.1 | 65357 | g2514 | i0 | 71.4 | 2.76986301369863 | 84 | 22 | 67.4 | 1 | 2 | 247 | 19 | 102 | CCI49799.1 unnamed protein product [Albugo candida] | diamond | 1011 | 123 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 31356058 | 31356058 | PRJNA345071_P_NODE_7856_length_252_cov_0.871508_g7816_i0 | PRJNA345071 | 7856 | 252 | 0.871508 | 2.19620016 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0159 | NR | TMW56549.1 | 41045 | g7816 | i0 | 30.7 | 4.15476190476191 | 75 | 51 | 89.3 | 1 | 226 | 2 | 340 | 413 | TMW56549.1 hypothetical protein Poli38472_006559 [Pythium oligandrum] | diamond | 1047 | 43.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31939586 | 31939586 | PRJNA345071_P_NODE_7637_length_253_cov_0.866667_g7597_i0 | PRJNA345071 | 7637 | 253 | 0.866667 | 2.19266751 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 4.16e-13 | NR | KAG9400770.1 | 112091 | g7597 | i0 | 48.8 | 2.32411067193676 | 84 | 34 | 99.6 | 3 | 1 | 252 | 315 | 389 | KAG9400770.1 hypothetical protein AC1031_010208 [Aphanomyces cochlioides] | diamond | 588 | 73.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 32603992 | 32603992 | PRJNA345071_P_NODE_3940_length_314_cov_1.639004_g3900_i0 | PRJNA345071 | 3940 | 314 | 1.639004 | 5.14647256 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 3.07e-19 | NR | TMW67703.1 | 41045 | g3900 | i0 | 53 | 4.55732484076433 | 83 | 39 | 79.3 | 0 | 20 | 268 | 174 | 256 | TMW67703.1 hypothetical protein Poli38472_011323 [Pythium oligandrum] | diamond | 1431 | 92.4 | 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);;