contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA541476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 509293 | 509293 | PRJNA541476_P_NODE_4261_length_555_cov_51.686722_g4065_i0 | PRJNA541476 | 4261 | 555 | 51.686722 | 286.8613071 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 3.0200000000000002e-59 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g4065 | i0 | 79.05 | 14.2792792792793 | 358 | 71 | 64 | 4 | 105 | 460 | 127 | 482 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 7925 | 243 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 1783758 | 1783758 | PRJNA541476_P_NODE_10022_length_360_cov_4.411150_g9816_i0 | PRJNA541476 | 10022 | 360 | 4.41115 | 15.88014 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 1.14e-56 | NTclustered | gi|166041070|emb|CU355542.1| | 100861 | g9816 | i0 | 79.518 | 41.9888888888889 | 332 | 64 | 92 | 4 | 19 | 348 | 120 | 449 | Aphanomyces euteiches cDNA | blastn | 15116 | 233 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 1783815 | 1783815 | PRJNA541476_P_NODE_12602_length_329_cov_10.253906_g12396_i0 | PRJNA541476 | 12602 | 329 | 10.253906 | 33.73535074 | Achlya bisexualis | 4766 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 1.3e-70 | NTclustered | gi|2289|emb|X59936.1| | 4766 | g12396 | i0 | 87.552 | 71.0091185410334 | 241 | 30 | 73 | 0 | 89 | 329 | 1 | 241 | A.bisexualis gene for actin | blastn | 23362 | 279 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya bisexualis | ||
| 1784725 | 1784725 | PRJNA541476_P_NODE_8962_length_379_cov_1.493464_g8756_i0 | PRJNA541476 | 8962 | 379 | 1.493464 | 5.66022856 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 4.26e-66 | NTclustered | gi|695428657|ref|XM_009531708.1| | 67593 | g8756 | i0 | 81.269 | 17.4353562005277 | 331 | 58 | 87 | 4 | 14 | 342 | 130 | 458 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 6608 | 265 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 4336247 | 4336247 | PRJNA541476_P_NODE_8264_length_393_cov_2.365625_g8060_i0 | PRJNA541476 | 8264 | 393 | 2.365625 | 9.29690625 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 5.8199999999999984e-55 | NTclustered | gi|813198519|ref|XM_012353453.1| | 695850 | g8060 | i0 | 78.393 | 12.9236641221374 | 361 | 70 | 91 | 8 | 8 | 364 | 477 | 121 | Saprolegnia parasitica CBS 223.65 succinate dehydrogenase iron-sulfur subunit mRNA | blastn | 5079 | 228 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 10047015 | 10047015 | PRJNA541476_P_NODE_8488_length_389_cov_0.955696_g8284_i0 | PRJNA541476 | 8488 | 389 | 0.955696 | 3.71765744 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 2.17e-19 | NTclustered | gi|2314988938|ref|NC_067073.1| | 89334 | g8284 | i0 | 86.275 | 25.6118251928021 | 102 | 12 | 26 | 2 | 34 | 134 | 6670 | 6570 | Phytophthora clandestina voucher P3942 mitochondrion, complete genome | blastn | 9963 | 111 | 0.990990990990991 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora clandestina | ||
| 10712728 | 10712728 | PRJNA541476_P_NODE_22609_length_271_cov_2.343434_g22403_i0 | PRJNA541476 | 22609 | 271 | 2.343434 | 6.35070614 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 1.1e-35 | NTclustered | gi|813142527|ref|XM_012343931.1| | 695850 | g22403 | i0 | 77.778 | 25.8523985239852 | 270 | 56 | 99 | 4 | 1 | 268 | 616 | 883 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA | blastn | 7006 | 163 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 11321629 | 11321629 | PRJNA541476_P_NODE_8629_length_386_cov_0.945687_g8425_i0 | PRJNA541476 | 8629 | 386 | 0.94568700000000006 | 3.65035182 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 3.39e-62 | NTclustered | gi|50261276|ref|NC_005984.1| | 4770 | g8425 | i0 | 78.663 | 76.2538860103627 | 389 | 75 | 99 | 7 | 2 | 386 | 27036 | 27420 | Saprolegnia ferax mitochondrion, complete genome | blastn | 29434 | 252 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia ferax | ||
| 14537247 | 14537247 | PRJNA541476_P_NODE_1512_length_966_cov_2.344905_g1364_i0 | PRJNA541476 | 1512 | 966 | 2.344905 | 22.6517823 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 664 | 0 | NTclustered | gi|752272326|gb|KJ639192.1| | 115421 | g1364 | i0 | 79.485 | 95.4844720496894 | 970 | 171 | 99 | 22 | 1 | 956 | 1112 | 2067 | Pythium ultimum var. sporangiiferum strain DAOM 240290 cytochrome c oxidase subunit 2 (COII) and cytochrome c oxidase subunit 1 (COI) genes, partial cds; mitochondrial | blastn | 92238 | 664 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 15146623 | 15146623 | PRJNA541476_P_NODE_40152_length_242_cov_0.917160_g39946_i0 | PRJNA541476 | 40152 | 242 | 0.91716 | 2.2195272 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 2.6099999999999996e-56 | NTclustered | gi|2314988899|ref|NC_067072.1| | 89335 | g39946 | i0 | 84.298 | 95.3347107438017 | 242 | 32 | 99 | 6 | 2 | 240 | 2851 | 3089 | Phytophthora ilicis voucher P3939 mitochondrion, complete genome | blastn | 23071 | 231 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ilicis | ||
| 17086259 | 17086259 | PRJNA541476_P_NODE_27414_length_255_cov_1.445055_g27208_i0 | PRJNA541476 | 27414 | 255 | 1.445055 | 3.68489025 | Paralagenidium karlingii | 1440115 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 2.24e-27 | NTclustered | gi|2554484921|ref|NC_080886.1| | 1440115 | g27208 | i0 | 89.189 | 23.6 | 111 | 9 | 43 | 3 | 72 | 181 | 41764 | 41656 | Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome | blastn | 6018 | 135 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Paralagenidium | Paralagenidium karlingii | ||||
| 18360078 | 18360078 | PRJNA541476_P_NODE_19255_length_285_cov_2.764151_g19049_i0 | PRJNA541476 | 19255 | 285 | 2.764151 | 7.87783035 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 5.35e-44 | NTclustered | gi|669165625|ref|XM_008620153.1| | 1156394 | g19049 | i0 | 80.632 | 4.54736842105263 | 253 | 43 | 88 | 5 | 25 | 274 | 1093 | 1342 | Saprolegnia diclina VS20 succinyl-CoA synthetase beta subunit mRNA | blastn | 1296 | 191 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 19635219 | 19635219 | PRJNA541476_P_NODE_3836_length_589_cov_44.098837_g3642_i0 | PRJNA541476 | 3836 | 589 | 44.098837 | 259.74214993 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 6.82e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g3642 | i0 | 80.533 | 57.4329371816638 | 375 | 65 | 62 | 4 | 30 | 397 | 68 | 441 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 23460934 | 23460934 | PRJNA541476_P_NODE_259_length_1928_cov_8.711051_g215_i0 | PRJNA541476 | 259 | 1928 | 8.711051 | 167.94906328 | Achlya ambisexualis | 4768 | SAR_Eukaryotes | SAR_Eukaryotes | 1038 | 0 | NTclustered | gi|22086549|gb|AF402100.1| | 4768 | g215 | i0 | 77.223 | 79.8054979253112 | 1844 | 376 | 95 | 40 | 24 | 1845 | 1843 | 22 | Achlya ambisexualis isolate JS854 heat shock protein Hsp90 mRNA, complete cds | blastn | 153865 | 1038 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya ambisexualis | ||
| 24734654 | 24734654 | PRJNA541476_P_NODE_260_length_1928_cov_8.243666_g215_i1 | PRJNA541476 | 260 | 1928 | 8.243666 | 158.93788048 | Achlya ambisexualis | 4768 | SAR_Eukaryotes | SAR_Eukaryotes | 1016 | 0 | NTclustered | gi|22086549|gb|AF402100.1| | 4768 | g215 | i1 | 77.069 | 86.149377593361 | 1849 | 370 | 95 | 43 | 84 | 1905 | 22 | 1843 | Achlya ambisexualis isolate JS854 heat shock protein Hsp90 mRNA, complete cds | blastn | 166096 | 1016 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya ambisexualis |
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);;