contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA641991" 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 |
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);;