contig_metadata
13 rows where bioproject = "PRJNA839281" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2505979 | 2505979 | PRJNA839281_S_NODE_39242_length_153_cov_2.365385_g38973_i0 | PRJNA839281 | 39242 | 153 | 2.365385 | 3.61903905 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 1.6e-11 | NTclustered | gi|239579434|gb|FJ438471.1| | 4792 | g38973 | i0 | 81.633 | 4.6078431372549 | 98 | 18 | 64 | 0 | 54 | 151 | 466 | 563 | Phytophthora nicotianae cyclophilin B (CyPB) gene, complete cds | blastn | 705 | 82.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 7207702 | 7207702 | PRJNA839281_S_NODE_10866_length_241_cov_1.062500_g10597_i0 | PRJNA839281 | 10866 | 241 | 1.0625 | 2.560625 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 2.84e-9 | NR | KAF1324749.1 | 82926 | g10597 | i0 | 50 | 2.83817427385892 | 84 | 30 | 92.1 | 3 | 14 | 235 | 182 | 263 | KAF1324749.1 Nucleosome assembly protein 1, partial [Globisporangium splendens] | diamond | 684 | 62.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 9757930 | 9757930 | PRJNA839281_S_NODE_8028_length_282_cov_1.751073_g7759_i0 | PRJNA839281 | 8028 | 282 | 1.751073 | 4.93802586 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 8.469999999999999e-72 | NTclustered | gi|2795052452|ref|XM_067926699.1| | 4785 | g7759 | i0 | 92.424 | 68.354609929078 | 198 | 15 | 70 | 0 | 1 | 198 | 322 | 519 | Phytophthora cinnamomi caltractin (IUM83_02754), partial mRNA | blastn | 19276 | 283 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 11033236 | 11033236 | PRJNA839281_S_NODE_10349_length_246_cov_3.502538_g10080_i0 | PRJNA839281 | 10349 | 246 | 3.502538 | 8.61624348 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 3.54e-35 | NTclustered | gi|2794916528|ref|XM_067893497.1| | 164328 | g10080 | i0 | 79.821 | 63.6056910569106 | 223 | 43 | 90 | 2 | 1 | 222 | 265 | 44 | Phytophthora ramorum 60S ribosomal protein L21-B (KRP23_8096), partial mRNA | blastn | 15647 | 161 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 12308893 | 12308893 | PRJNA839281_S_NODE_27190_length_167_cov_0.864407_g26921_i0 | PRJNA839281 | 27190 | 167 | 0.864407 | 1.44355969 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 7.53e-80 | NTclustered | gi|166046671|emb|CU367781.1| | 100861 | g26921 | i0 | 100 | 99.0479041916168 | 167 | 0 | 100 | 0 | 1 | 167 | 720 | 554 | Aphanomyces euteiches cDNA | blastn | 16541 | 309 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 13984271 | 13984271 | PRJNA839281_S_NODE_9391_length_259_cov_1.638095_g9122_i0 | PRJNA839281 | 9391 | 259 | 1.638095 | 4.24266605 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 3.03e-6 | NTclustered | gi|813118109|ref|XM_012340462.1| | 695850 | g9122 | i0 | 89.091 | 0.416988416988417 | 55 | 2 | 20 | 3 | 185 | 237 | 1334 | 1282 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 108 | 65.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 16533013 | 16533013 | PRJNA839281_S_NODE_35233_length_162_cov_0.902655_g34964_i0 | PRJNA839281 | 35233 | 162 | 0.902655 | 1.4623011 | root | 1 | Root_unresolved | Root_unresolved | 294 | 2.03e-75 | NTclustered | gi|166046587|emb|CU367704.1| | 100861 | g34964 | i0 | 99.383 | 34.6358024691358 | 162 | 1 | 100 | 0 | 1 | 162 | 392 | 553 | Aphanomyces euteiches cDNA | blastn | 5611 | 294 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 18681136 | 18681136 | PRJNA839281_S_NODE_4095_length_487_cov_3.826484_g3827_i0 | PRJNA839281 | 4095 | 487 | 3.826484 | 18.63497708 | Hyaloperonospora parasitica | 123356 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.013 | NTclustered | gi|170285697|emb|CU672270.3| | 123356 | g3827 | i0 | 100 | 0.0595482546201232 | 29 | 0 | 6 | 0 | 287 | 315 | 1789 | 1761 | H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 27939209 | 27939209 | PRJNA839281_S_NODE_26205_length_167_cov_1.728814_g25936_i0 | PRJNA839281 | 26205 | 167 | 1.728814 | 2.88711938 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 6.46e-5 | NR | RHY33897.1 | 157072 | g25936 | i0 | 78.6 | 1.02395209580838 | 28 | 6 | 50.3 | 0 | 165 | 82 | 530 | 557 | RHY33897.1 hypothetical protein DYB32_003863, partial [Aphanomyces invadans] | diamond | 171 | 49.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 30117750 | 30117750 | PRJNA839281_S_NODE_7392_length_297_cov_1.153226_g7123_i0 | PRJNA839281 | 7392 | 297 | 1.153226 | 3.42508122 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 8.539999999999998e-30 | NR | GLD94132.1 | 114742 | g7123 | i0 | 56.1 | 4.94949494949495 | 98 | 43 | 99 | 0 | 3 | 296 | 247 | 344 | GLD94132.1 hypothetical protein PINS_up002743 [Pythium insidiosum] | diamond | 1470 | 120 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 30157702 | 30157702 | PRJNA839281_S_NODE_32372_length_164_cov_0.886957_g32103_i0 | PRJNA839281 | 32372 | 164 | 0.886957 | 1.45460948 | root | 1 | Root_unresolved | Root_unresolved | 41.6 | 0.0332 | NR | DBA01564.1 | 4803 | g32103 | i0 | 41.9 | 4.24390243902439 | 43 | 25 | 78.7 | 0 | 130 | 2 | 48 | 90 | DBA01564.1 TPA: hypothetical protein N0F65_011535 [Lagenidium giganteum] | diamond | 696 | 41.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 30402676 | 30402676 | PRJNA839281_S_NODE_18693_length_191_cov_1.274648_g18424_i0 | PRJNA839281 | 18693 | 191 | 1.274648 | 2.43457768 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 53.9 | 1.42e-6 | NR | KAG9399183.1 | 112091 | g18424 | i0 | 50 | 0.722513089005236 | 46 | 23 | 72.3 | 0 | 154 | 17 | 26 | 71 | KAG9399183.1 hypothetical protein AC1031_012144 [Aphanomyces cochlioides] | diamond | 138 | 53.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 30465722 | 30465722 | PRJNA839281_S_NODE_32153_length_164_cov_0.886957_g31884_i0 | PRJNA839281 | 32153 | 164 | 0.886957 | 1.45460948 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.0234 | NR | AIG55696.1 | 74557 | g31884 | i0 | 50 | 0.841463414634146 | 46 | 21 | 84.1 | 1 | 157 | 20 | 115 | 158 | AIG55696.1 secreted protein, partial [Thraustotheca clavata] | diamond | 138 | 42 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata |
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);;