contig_metadata
14 rows where bioproject = "PRJNA641991", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 617757 | 617757 | PRJNA641991_S_NODE_13821_length_163_cov_0.894737_g13702_i0 | PRJNA641991 | 13821 | 163 | 0.894737 | 1.45842131 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 8.12e-5 | NTclustered | gi|2795027405|ref|XM_067926264.1| | 4785 | g13702 | i0 | 100 | 3.85889570552147 | 32 | 0 | 20 | 0 | 8 | 39 | 1478 | 1447 | Phytophthora cinnamomi putative SWI/SNF-related matrix-associated actin-dependent regulator of chromatin (IUM83_02354), partial mRNA | blastn | 629 | 60.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 6262081 | 6262081 | PRJNA641991_S_NODE_1225_length_475_cov_9.889671_g1106_i0 | PRJNA641991 | 1225 | 475 | 9.889671 | 46.97593725 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 1.5399999999999998e-56 | NTclustered | gi|166301|gb|J05597.1|ACKBTUB | 4767 | g1106 | i0 | 87.081 | 41.9642105263158 | 209 | 23 | 44 | 4 | 1 | 207 | 1331 | 1537 | A.klebsiana beta-tubulin gene, complete cds | blastn | 19933 | 235 | 0.991489361702128 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 6996316 | 6996316 | PRJNA641991_S_NODE_10866_length_173_cov_4.330645_g10747_i0 | PRJNA641991 | 10866 | 173 | 4.330645 | 7.49201585 | Lagenidium sp. SL10 | 1702235 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 1.79e-36 | NTclustered | gi|918464445|gb|KT257536.1| | 1702235 | g10747 | i0 | 84.431 | 27.1156069364162 | 167 | 26 | 97 | 0 | 7 | 173 | 315 | 149 | Lagenidium sp. SL10 isolate LEV5850 beta-tubulin gene, partial cds | blastn | 4691 | 165 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium sp. SL10 | ||
| 13371794 | 13371794 | PRJNA641991_P_NODE_751_length_399_cov_1.391429_g710_i0 | PRJNA641991 | 751 | 399 | 1.391429 | 5.55180171 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 6.09e-35 | NTclustered | gi|673024575|ref|XM_008868027.1| | 157072 | g710 | i0 | 89.764 | 33.7142857142857 | 127 | 12 | 32 | 1 | 4 | 129 | 2262 | 2388 | Aphanomyces invadans tubulin beta chain mRNA | blastn | 13452 | 161 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 15920664 | 15920664 | PRJNA641991_S_NODE_9213_length_186_cov_1.299270_g9094_i0 | PRJNA641991 | 9213 | 186 | 1.29927 | 2.4166422 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 4.12e-53 | NTclustered | gi|675203540|ref|XM_008912407.1| | 761204 | g9094 | i0 | 88.462 | 78.747311827957 | 182 | 21 | 98 | 0 | 4 | 185 | 397 | 216 | Phytophthora parasitica INRA-310 actin-1 mRNA | blastn | 14647 | 220 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 16461197 | 16461197 | PRJNA641991_S_NODE_14553_length_161_cov_1.366071_g14434_i0 | PRJNA641991 | 14553 | 161 | 1.366071 | 2.19937431 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 1.69e-16 | NTclustered | gi|2248513400|ref|NC_063804.1| | 4784 | g14434 | i0 | 83.654 | 6.4472049689441 | 104 | 17 | 65 | 0 | 3 | 106 | 17471 | 17368 | Phytophthora capsici isolate TaiwanPc33e mitochondrion, complete genome | blastn | 1038 | 99 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 21560366 | 21560366 | PRJNA641991_S_NODE_1117_length_502_cov_18.938190_g998_i0 | PRJNA641991 | 1117 | 502 | 18.93819 | 95.0697138 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 1.63e-56 | NTclustered | gi|166301|gb|J05597.1|ACKBTUB | 4767 | g998 | i0 | 87.081 | 39.6334661354582 | 209 | 23 | 41 | 4 | 296 | 502 | 1537 | 1331 | A.klebsiana beta-tubulin gene, complete cds | blastn | 19896 | 235 | 0.991489361702128 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 23570496 | 23570496 | PRJNA641991_S_NODE_2779_length_316_cov_1.501873_g2660_i0 | PRJNA641991 | 2779 | 316 | 1.501873 | 4.74591868 | Phytophthora boehmeriae | 109152 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 9.64e-72 | NTclustered | gi|1133565931|gb|KU518486.1| | 109152 | g2660 | i0 | 83.226 | 95.7088607594937 | 310 | 50 | 98 | 2 | 8 | 316 | 330 | 22 | Phytophthora boehmeriae strain OCPC27 translation elongation factor 1-alpha gene, partial cds | blastn | 30244 | 283 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora boehmeriae | ||
| 28692050 | 28692050 | PRJNA641991_S_NODE_14527_length_161_cov_1.410714_g14408_i0 | PRJNA641991 | 14527 | 161 | 1.410714 | 2.27124954 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 2.03e-13 | NR | RHZ07776.1 | 112090 | g14408 | i0 | 56.6 | 4.93788819875776 | 53 | 23 | 98.8 | 0 | 161 | 3 | 92 | 144 | RHZ07776.1 hypothetical protein DYB31_012338, partial [Aphanomyces astaci] | diamond | 795 | 70.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 28735752 | 28735752 | PRJNA641991_S_NODE_14567_length_161_cov_1.366071_g14448_i0 | PRJNA641991 | 14567 | 161 | 1.366071 | 2.19937431 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 4.95e-12 | NR | XP_024573891.1 | 4781 | g14448 | i0 | 78 | 38.1614906832298 | 41 | 9 | 76.4 | 0 | 159 | 37 | 108 | 148 | XP_024573891.1 60s ribosomal protein l27a [Plasmopara halstedii] | diamond | 6144 | 69.7 | 0.994261119081779 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 28767240 | 28767240 | PRJNA641991_S_NODE_13107_length_165_cov_0.879310_g12988_i0 | PRJNA641991 | 13107 | 165 | 0.87931 | 1.4508615 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 3.84e-12 | NR | XP_067785475.1 | 4785 | g12988 | i0 | 63 | 5.89090909090909 | 54 | 14 | 98.2 | 1 | 2 | 163 | 362 | 409 | XP_067785475.1 methylmalonate-semialdehyde dehydrogenase (acylating) [Phytophthora cinnamomi] | diamond | 972 | 69.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 30429196 | 30429196 | PRJNA641991_S_NODE_9853_length_181_cov_1.431818_g9734_i0 | PRJNA641991 | 9853 | 181 | 1.431818 | 2.59159058 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 9.91e-18 | NR | RHY32367.1 | 157072 | g9734 | i0 | 78 | 2.93370165745856 | 59 | 13 | 97.8 | 0 | 3 | 179 | 168 | 226 | RHY32367.1 hypothetical protein DYB32_003166 [Aphanomyces invadans] | diamond | 531 | 85.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 31009791 | 31009791 | PRJNA641991_S_NODE_14794_length_161_cov_0.910714_g14675_i0 | PRJNA641991 | 14794 | 161 | 0.910714 | 1.46624954 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 3.62e-14 | NR | KAF0744732.1 | 100861 | g14675 | i0 | 69.8 | 5.92546583850932 | 53 | 16 | 98.8 | 0 | 159 | 1 | 22 | 74 | KAF0744732.1 hypothetical protein Ae201684_001188 [Aphanomyces euteiches] | diamond | 954 | 72.4 | 0.994475138121547 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 32704759 | 32704759 | PRJNA641991_P_NODE_2800_length_181_cov_1.545455_g2759_i0 | PRJNA641991 | 2800 | 181 | 1.545455 | 2.79727355 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 4.61e-11 | NR | RHX96559.1 | 112090 | g2759 | i0 | 52.6 | 4.72375690607735 | 57 | 27 | 94.5 | 0 | 3 | 173 | 170 | 226 | RHX96559.1 hypothetical protein DYB36_013739, partial [Aphanomyces astaci] | diamond | 855 | 65.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci |
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);;