contig_metadata
14 rows where bioproject = "PRJNA849172", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3783644 | 3783644 | PRJNA849172_P_NODE_100903_length_246_cov_0.895954_g100543_i0 | PRJNA849172 | 100903 | 246 | 0.895954 | 2.20404684 | root | 1 | Root_unresolved | Root_unresolved | 427 | 3.16e-115 | NTclustered | gi|166046486|emb|CU367603.1| | 100861 | g100543 | i0 | 97.976 | 40.8739837398374 | 247 | 4 | 100 | 1 | 1 | 246 | 309 | 63 | Aphanomyces euteiches cDNA | blastn | 10055 | 427 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 6337124 | 6337124 | PRJNA849172_P_NODE_95305_length_248_cov_13.360000_g94945_i0 | PRJNA849172 | 95305 | 248 | 13.36 | 33.1328 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 78.2 | 1.46e-15 | NR | KAF0700968.1 | 120398 | g94945 | i0 | 60.6 | 2.39516129032258 | 66 | 26 | 79.8 | 0 | 4 | 201 | 142 | 207 | KAF0700968.1 hypothetical protein As57867_008506 [Aphanomyces stellatus] | diamond | 594 | 78.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 8489076 | 8489076 | PRJNA849172_P_NODE_40567_length_324_cov_43.641434_g40207_i0 | PRJNA849172 | 40567 | 324 | 43.641434 | 141.39824616 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 8.229999999999999e-23 | NTclustered | gi|669137463|ref|XM_008606078.1| | 1156394 | g40207 | i0 | 81.818 | 15.0802469135802 | 143 | 26 | 44 | 0 | 182 | 324 | 2027 | 1885 | Saprolegnia diclina VS20 heat shock protein 90-2 partial mRNA | blastn | 4886 | 121 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 13591682 | 13591682 | PRJNA849172_P_NODE_9871_length_684_cov_50.407529_g9522_i0 | PRJNA849172 | 9871 | 684 | 50.407529 | 344.78749836 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 2.9000000000000002e-65 | NTclustered | gi|937408816|ref|NC_027966.1| | 114742 | g9522 | i0 | 76.265 | 1.53801169590643 | 573 | 90 | 81 | 37 | 125 | 677 | 32433 | 31887 | Pythium insidiosum mitochondrial DNA, complete genome | blastn | 1052 | 263 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 25459316 | 25459316 | PRJNA849172_P_NODE_50700_length_294_cov_5.171946_g50340_i0 | PRJNA849172 | 50700 | 294 | 5.171946 | 15.20552124 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 4.31e-40 | NTclustered | gi|58202010|gb|AY898628.1| | 4787 | g50340 | i0 | 88.966 | 50.6836734693878 | 145 | 15 | 49 | 1 | 3 | 147 | 2324 | 2467 | Phytophthora infestans haplotype IIb mitochondrion, complete genome | blastn | 14901 | 178 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 26737842 | 26737842 | PRJNA849172_P_NODE_120961_length_231_cov_3.018987_g120601_i0 | PRJNA849172 | 120961 | 231 | 3.018987 | 6.97385997 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 9.52e-40 | NR | KAL0581093.1 | 65357 | g120601 | i0 | 94.8 | 2 | 77 | 4 | 100 | 0 | 1 | 231 | 7 | 83 | KAL0581093.1 hypothetical protein ABG067_008481, partial [Albugo candida] | diamond | 462 | 138 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 28073802 | 28073802 | PRJNA849172_P_NODE_31725_length_364_cov_3.773196_g31366_i0 | PRJNA849172 | 31725 | 364 | 3.773196 | 13.73443344 | root | 1 | Root_unresolved | Root_unresolved | 238 | 9.38e-78 | NR | KAL0582261.1 | 65357 | g31366 | i0 | 99.2 | 2.99175824175824 | 121 | 1 | 99.7 | 0 | 2 | 364 | 40 | 160 | KAL0582261.1 hypothetical protein ABG067_007890, partial [Albugo candida] | diamond | 1089 | 238 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 28318101 | 28318101 | PRJNA849172_P_NODE_13406_length_575_cov_24.121514_g13048_i0 | PRJNA849172 | 13406 | 575 | 24.121514 | 138.6987055 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 1.99e-31 | NR | KAJ0396306.1 | 114742 | g13048 | i0 | 60.2 | 2.17565217391304 | 108 | 43 | 56.3 | 0 | 173 | 496 | 1675 | 1782 | KAJ0396306.1 hypothetical protein P43SY_007156 [Pythium insidiosum] | diamond | 1251 | 131 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 28444591 | 28444591 | PRJNA849172_P_NODE_33146_length_356_cov_22.212014_g32787_i0 | PRJNA849172 | 33146 | 356 | 22.212014 | 79.07476984 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 2.86e-24 | NR | KAF1336584.1 | 82926 | g32787 | i0 | 64 | 0.72471910112359506 | 86 | 23 | 65.7 | 1 | 6 | 239 | 628 | 713 | KAF1336584.1 Transmembrane protein, partial [Globisporangium splendens] | diamond | 258 | 107 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 28697233 | 28697233 | PRJNA849172_P_NODE_60267_length_280_cov_21.995169_g59907_i0 | PRJNA849172 | 60267 | 280 | 21.995169 | 61.5864732 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00106 | NR | DBA00579.1 | 4803 | g59907 | i0 | 47.1 | 0.75 | 70 | 32 | 75 | 2 | 278 | 69 | 84 | 148 | DBA00579.1 TPA: hypothetical protein N0F65_007708 [Lagenidium giganteum] | diamond | 210 | 46.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 29557712 | 29557712 | PRJNA849172_P_NODE_133030_length_216_cov_17.489510_g132670_i0 | PRJNA849172 | 133030 | 216 | 17.48951 | 37.7773416 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 98.2 | 7.48e-25 | NR | KAH9091754.1 | 100861 | g132670 | i0 | 72.7 | 1.52777777777778 | 55 | 15 | 76.4 | 0 | 5 | 169 | 32 | 86 | KAH9091754.1 hypothetical protein Ae201684P_011298 [Aphanomyces euteiches] | diamond | 330 | 99 | 0.991919191919192 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 30379515 | 30379515 | PRJNA849172_P_NODE_80052_length_259_cov_9.946237_g79692_i0 | PRJNA849172 | 80052 | 259 | 9.946237 | 25.76075383 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00409 | NR | OQR81488.1 | 74557 | g79692 | i0 | 48.7 | 2.07335907335907 | 39 | 20 | 45.2 | 0 | 65 | 181 | 78 | 116 | OQR81488.1 hypothetical protein THRCLA_23360, partial [Thraustotheca clavata] | diamond | 537 | 44.7 | 0.991051454138702 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 31603581 | 31603581 | PRJNA849172_P_NODE_98496_length_247_cov_1.436782_g98136_i0 | PRJNA849172 | 98496 | 247 | 1.436782 | 3.54885154 | Peronospora farinosa | 134698 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 1.23e-32 | NR | CAH0488358.1 | 134698 | g98136 | i0 | 80.7 | 5.04048582995951 | 83 | 13 | 99.6 | 2 | 1 | 246 | 65 | 145 | CAH0488358.1 unnamed protein product [Peronospora farinosa] | diamond | 1245 | 127 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 32709971 | 32709971 | PRJNA849172_P_NODE_120880_length_231_cov_3.436709_g120520_i0 | PRJNA849172 | 120880 | 231 | 3.436709 | 7.93879779 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 5.5e-15 | NR | KAH9131724.1 | 100861 | g120520 | i0 | 50.6 | 3 | 77 | 37 | 98.7 | 1 | 2 | 229 | 292 | 368 | KAH9131724.1 hypothetical protein LEN26_007646 [Aphanomyces euteiches] | diamond | 693 | 79 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;