contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA752572" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2476739 | 2476739 | PRJNA752572_P_NODE_270422_length_163_cov_2.148438_g269915_i0 | PRJNA752572 | 270422 | 163 | 2.148438 | 3.50195394 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 2.72e-54 | NTclustered | gi|1233048122|gb|KX252489.1| | 89336 | g269915 | i0 | 91.411 | 100 | 163 | 14 | 100 | 0 | 1 | 163 | 49 | 211 | Phytophthora sp. isolate 38D9(authentic) beta-tubulin gene, partial cds | blastn | 16300 | 226 | 0.991150442477876 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sp. | ||
| 3279891 | 3279891 | PRJNA752572_P_NODE_110443_length_256_cov_2.972851_g109936_i0 | PRJNA752572 | 110443 | 256 | 2.972851 | 7.61049856 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 2.2299999999999998e-32 | NTclustered | gi|2795038730|ref|XM_067938895.1| | 4785 | g109936 | i0 | 83.636 | 19.69921875 | 165 | 23 | 64 | 4 | 37 | 199 | 213 | 51 | Phytophthora cinnamomi ADP-ribosylation factor-like protein 3 (IUM83_14170), partial mRNA | blastn | 5043 | 152 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 3279931 | 3279931 | PRJNA752572_P_NODE_209803_length_183_cov_2.439189_g209296_i0 | PRJNA752572 | 209803 | 183 | 2.439189 | 4.46371587 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 1.55e-7 | NTclustered | gi|166043101|emb|CU357747.1| | 100861 | g209296 | i0 | 97.5 | 0.879781420765027 | 40 | 1 | 22 | 0 | 144 | 183 | 876 | 837 | Aphanomyces euteiches cDNA | blastn | 161 | 69.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 4556968 | 4556968 | PRJNA752572_P_NODE_141784_length_225_cov_1.494737_g141277_i0 | PRJNA752572 | 141784 | 225 | 1.494737 | 3.36315825 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 5.409999999999999e-23 | NTclustered | gi|695396134|ref|XM_009523071.1| | 67593 | g141277 | i0 | 78.283 | 2.46666666666667 | 198 | 36 | 87 | 5 | 1 | 196 | 290 | 482 | Phytophthora sojae hypothetical protein mRNA | blastn | 555 | 121 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 5029671 | 5029671 | PRJNA752572_P_NODE_31684_length_485_cov_2.433333_g31193_i0 | PRJNA752572 | 31684 | 485 | 2.433333 | 11.80166505 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 2.3999999999999998e-119 | NTclustered | gi|1036393066|gb|KU682611.1| | 1861850 | g31193 | i0 | 83.299 | 98.8226804123711 | 479 | 80 | 99 | 0 | 1 | 479 | 183 | 661 | Phytophthora sp. x Kunnunara-like isolate TW338 cytochrome oxidase subunit I (coxI) gene, partial cds; mitochondrial | blastn | 47929 | 442 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sp. x Kunnunara-like | ||
| 8381851 | 8381851 | PRJNA752572_P_NODE_118367_length_247_cov_2.056604_g117860_i0 | PRJNA752572 | 118367 | 247 | 2.056604 | 5.07981188 | Phytophthora sp. | 89336 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 2.04e-67 | NTclustered | gi|1233049813|gb|KX251484.1| | 89336 | g117860 | i0 | 87.826 | 93.2348178137652 | 230 | 24 | 92 | 4 | 20 | 247 | 1210 | 1437 | Phytophthora sp. isolate 48H2(authentic) heat shock protein 90 gene, partial cds | blastn | 23029 | 268 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sp. | ||
| 9657065 | 9657065 | PRJNA752572_P_NODE_199928_length_188_cov_1.823529_g199421_i0 | PRJNA752572 | 199928 | 188 | 1.823529 | 3.42823452 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 2.58e-30 | NTclustered | gi|669165645|ref|XM_008620163.1| | 1156394 | g199421 | i0 | 83.766 | 3.6063829787234 | 154 | 23 | 81 | 2 | 6 | 158 | 257 | 105 | Saprolegnia diclina VS20 caltractin mRNA | blastn | 678 | 145 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 9657149 | 9657149 | PRJNA752572_P_NODE_7928_length_895_cov_3.026744_g7634_i0 | PRJNA752572 | 7928 | 895 | 3.026744 | 27.0893588 | Phytophthora humicola | 129352 | SAR_Eukaryotes | SAR_Eukaryotes | 486 | 2.0899999999999994e-132 | NTclustered | gi|2314988859|ref|NC_067071.1| | 129352 | g7634 | i0 | 79.883 | 69.604469273743 | 686 | 121 | 76 | 16 | 215 | 893 | 1447 | 772 | Phytophthora humicola voucher P3826 mitochondrion, complete genome | blastn | 62296 | 486 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora humicola | ||
| 12208078 | 12208078 | PRJNA752572_P_NODE_261390_length_166_cov_1.007634_g260883_i0 | PRJNA752572 | 261390 | 166 | 1.007634 | 1.67267244 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 3.78e-18 | NTclustered | gi|813103042|ref|XM_012338618.1| | 695850 | g260883 | i0 | 85.714 | 2.25301204819277 | 98 | 14 | 59 | 0 | 49 | 146 | 618 | 715 | Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA | blastn | 374 | 104 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 15229911 | 15229911 | PRJNA752572_P_NODE_105512_length_263_cov_1.030702_g105005_i0 | PRJNA752572 | 105512 | 263 | 1.030702 | 2.71074626 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 3.59e-80 | NTclustered | gi|156987037|gb|EU080541.1| | 4793 | g105005 | i0 | 90.336 | 90.6273764258555 | 238 | 21 | 90 | 2 | 1 | 237 | 784 | 1020 | Phytophthora citrophthora isolate PD_00041(P6310) heat shock protein 90 (HSP90) gene, partial cds | blastn | 23835 | 311 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 18580403 | 18580403 | PRJNA752572_P_NODE_251315_length_168_cov_1.819549_g250808_i0 | PRJNA752572 | 251315 | 168 | 1.819549 | 3.05684232 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.28e-25 | NTclustered | gi|695423047|ref|XM_009530291.1| | 67593 | g250808 | i0 | 82.639 | 27.9642857142857 | 144 | 25 | 86 | 0 | 10 | 153 | 1076 | 1219 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 4698 | 128 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 19855660 | 19855660 | PRJNA752572_P_NODE_16796_length_652_cov_2.478120_g16377_i0 | PRJNA752572 | 16796 | 652 | 2.47812 | 16.1573424 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 431 | 7.13e-116 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g16377 | i0 | 81.374 | 76.5751533742331 | 553 | 82 | 83 | 15 | 47 | 587 | 1929 | 2472 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 49927 | 431 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 20327843 | 20327843 | PRJNA752572_P_NODE_47416_length_397_cov_2.513812_g46911_i0 | PRJNA752572 | 47416 | 397 | 2.513812 | 9.97983364 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 8.17e-4 | NTclustered | gi|2794880233|ref|XM_067890569.1| | 164328 | g46911 | i0 | 97.143 | 3.32241813602015 | 35 | 0 | 9 | 1 | 26 | 59 | 211 | 177 | Phytophthora ramorum Translation machinery-associated protein 22 (KRP23_570), partial mRNA | blastn | 1319 | 58.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 21131173 | 21131173 | PRJNA752572_P_NODE_221417_length_178_cov_1.678322_g220910_i0 | PRJNA752572 | 221417 | 178 | 1.678322 | 2.98741316 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 2.5e-5 | NTclustered | gi|2795051890|ref|XM_067940205.1| | 4785 | g220910 | i0 | 94.872 | 0.219101123595506 | 39 | 2 | 22 | 0 | 124 | 162 | 837 | 799 | Phytophthora cinnamomi U3 small nucleolar ribonucleoprotein IMP4 (IUM83_15392), partial mRNA | blastn | 39 | 62.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 23681558 | 23681558 | PRJNA752572_P_NODE_245919_length_170_cov_0.977778_g245412_i0 | PRJNA752572 | 245919 | 170 | 0.977778 | 1.6622226 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.0699999999999997e-23 | NTclustered | gi|2795024423|ref|XM_067938288.1| | 4785 | g245412 | i0 | 81.366 | 0.947058823529412 | 161 | 20 | 92 | 7 | 1 | 156 | 9 | 164 | Phytophthora cinnamomi 60S ribosomal protein (IUM83_13598), partial mRNA | blastn | 161 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 24955200 | 24955200 | PRJNA752572_P_NODE_73820_length_317_cov_1.347518_g73313_i0 | PRJNA752572 | 73820 | 317 | 1.347518 | 4.27163206 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 2.1499999999999997e-48 | NTclustered | gi|301107833|ref|XM_002902953.1| | 403677 | g73313 | i0 | 78.683 | 3.75078864353312 | 319 | 60 | 99 | 7 | 2 | 316 | 233 | 547 | Phytophthora infestans T30-4 40S ribosomal protein S3-3 (PITG_08959), mRNA | blastn | 1189 | 206 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans |
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);;