contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJEB14664" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21154 | 21154 | PRJEB14664_P_NODE_11721_length_216_cov_2.237569_g11591_i0 | PRJEB14664 | 11721 | 216 | 2.237569 | 4.83314904 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 388 | 1.28e-103 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g11591 | i0 | 99.074 | 106.601851851852 | 216 | 2 | 100 | 0 | 1 | 216 | 2179 | 2394 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 23026 | 388 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 21173 | 21173 | PRJEB14664_P_NODE_13321_length_198_cov_1.453988_g13191_i0 | PRJEB14664 | 13321 | 198 | 1.453988 | 2.87889624 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 3.61e-19 | NTclustered | gi|813142527|ref|XM_012343931.1| | 695850 | g13191 | i0 | 90.244 | 1.08585858585859 | 82 | 8 | 41 | 0 | 30 | 111 | 1209 | 1128 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA | blastn | 215 | 108 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 21189 | 21189 | PRJEB14664_P_NODE_14621_length_186_cov_1.589404_g14491_i0 | PRJEB14664 | 14621 | 186 | 1.589404 | 2.95629144 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 7.04e-36 | NTclustered | gi|673035777|ref|XM_008873628.1| | 157072 | g14491 | i0 | 83.146 | 1.93010752688172 | 178 | 30 | 96 | 0 | 8 | 185 | 86 | 263 | Aphanomyces invadans hypothetical protein mRNA | blastn | 359 | 163 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 21340 | 21340 | PRJEB14664_P_NODE_9401_length_252_cov_2.884793_g9271_i0 | PRJEB14664 | 9401 | 252 | 2.884793 | 7.26967836 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.49e-123 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g9271 | i0 | 99.209 | 100.043650793651 | 253 | 1 | 100 | 1 | 1 | 252 | 1869 | 1617 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 25211 | 455 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 1295314 | 1295314 | PRJEB14664_P_NODE_10902_length_227_cov_8.989583_g10772_i0 | PRJEB14664 | 10902 | 227 | 8.989583 | 20.40635341 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 375 | 1.06e-99 | NTclustered | gi|256009645|gb|GQ374534.1| | 112090 | g10772 | i0 | 96.476 | 85.2290748898678 | 227 | 8 | 100 | 0 | 1 | 227 | 159 | 385 | Aphanomyces astaci strain Gb04 28S ribosomal RNA gene, partial sequence | blastn | 19347 | 375 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 1295385 | 1295385 | PRJEB14664_P_NODE_18202_length_160_cov_1.600000_g18072_i0 | PRJEB14664 | 18202 | 160 | 1.6 | 2.56 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 5.629999999999999e-66 | NTclustered | gi|673038061|ref|XM_008874770.1| | 157072 | g18072 | i0 | 96.25 | 5.3125 | 160 | 6 | 100 | 0 | 1 | 160 | 78 | 237 | Aphanomyces invadans 60S ribosomal protein L38 mRNA | blastn | 850 | 263 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 2571148 | 2571148 | PRJEB14664_P_NODE_6363_length_327_cov_1.571918_g6233_i0 | PRJEB14664 | 6363 | 327 | 1.571918 | 5.14017186 | Phytophthora chrysanthemi | 638948 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 2.7999999999999998e-67 | NTclustered | gi|1337859674|gb|MG601089.1| | 638948 | g6233 | i0 | 82.951 | 98.1467889908257 | 305 | 44 | 92 | 8 | 1 | 301 | 14 | 314 | Phytophthora chrysanthemi isolate 201600114 ODA translation elongation factor 1-alpha gene, partial cds | blastn | 32094 | 268 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora chrysanthemi | ||
| 2571176 | 2571176 | PRJEB14664_P_NODE_8683_length_267_cov_1.379310_g8553_i0 | PRJEB14664 | 8683 | 267 | 1.37931 | 3.6827577 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 4.76e-74 | NTclustered | gi|673043756|ref|XM_008877617.1| | 157072 | g8553 | i0 | 86.617 | 1.00749063670412 | 269 | 29 | 99 | 7 | 1 | 265 | 467 | 202 | Aphanomyces invadans hypothetical protein mRNA | blastn | 269 | 291 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 5123560 | 5123560 | PRJEB14664_P_NODE_13245_length_199_cov_1.219512_g13115_i0 | PRJEB14664 | 13245 | 199 | 1.219512 | 2.42682888 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 2.64e-65 | NTclustered | gi|698783094|ref|XM_009826289.1| | 112090 | g13115 | i0 | 94.643 | 79.9597989949749 | 168 | 9 | 84 | 0 | 1 | 168 | 331 | 498 | Aphanomyces astaci 40S ribosomal protein S23 mRNA | blastn | 15912 | 261 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 5123635 | 5123635 | PRJEB14664_P_NODE_2165_length_625_cov_4.328814_g2054_i0 | PRJEB14664 | 2165 | 625 | 4.328814 | 27.0550875 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 922 | 0 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g2054 | i0 | 97.757 | 90.7344 | 535 | 12 | 86 | 0 | 91 | 625 | 2616 | 2082 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 56709 | 922 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 6088851 | 6088851 | PRJEB14664_P_NODE_10945_length_227_cov_1.619792_g10815_i0 | PRJEB14664 | 10945 | 227 | 1.619792 | 3.67692784 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 6.269999999999998e-107 | NTclustered | gi|166051677|emb|CU353805.1| | 100861 | g10815 | i0 | 98.667 | 100.31718061674 | 225 | 3 | 99 | 0 | 3 | 227 | 297 | 73 | Aphanomyces euteiches cDNA | blastn | 22772 | 399 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 7363421 | 7363421 | PRJEB14664_P_NODE_12826_length_203_cov_1.904762_g12696_i0 | PRJEB14664 | 12826 | 203 | 1.904762 | 3.86666686 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.24e-16 | NTclustered | gi|189084639|gb|BT032155.1| | 4784 | g12696 | i0 | 84.694 | 7.80788177339902 | 98 | 15 | 48 | 0 | 1 | 98 | 222 | 125 | Phytophthora capsici clone CBOT141-D08 mRNA sequence | blastn | 1585 | 99 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 8948179 | 8948179 | PRJEB14664_P_NODE_18048_length_161_cov_1.269841_g17918_i0 | PRJEB14664 | 18048 | 161 | 1.269841 | 2.04444401 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 3.64e-18 | NTclustered | gi|698776983|ref|XM_009823234.1| | 112090 | g17918 | i0 | 79.141 | 29.6645962732919 | 163 | 25 | 96 | 6 | 5 | 159 | 461 | 300 | Aphanomyces astaci hypothetical protein mRNA | blastn | 4776 | 104 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 14049324 | 14049324 | PRJEB14664_P_NODE_17312_length_166_cov_0.977099_g17182_i0 | PRJEB14664 | 17312 | 166 | 0.977099 | 1.62198434 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 6.16e-36 | NTclustered | gi|813171659|ref|XM_012349195.1| | 695850 | g17182 | i0 | 84.848 | 23.0421686746988 | 165 | 21 | 98 | 4 | 1 | 163 | 55 | 217 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 3825 | 163 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 15013607 | 15013607 | PRJEB14664_P_NODE_3032_length_520_cov_1.668041_g2912_i0 | PRJEB14664 | 3032 | 520 | 1.668041 | 8.6738132 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 1.65e-76 | NTclustered | gi|327206264|gb|JF414554.1| | 143453 | g2912 | i0 | 77.316 | 101.107692307692 | 529 | 104 | 99 | 11 | 3 | 520 | 1631 | 1108 | Pseudoperonospora cubensis isolate CDM-276 cytochrome c oxidase subunit II (cox2) and cytochrome c oxidase subunit I (cox1) genes, partial cds; mitochondrial | blastn | 52576 | 302 | 0.993377483443709 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Pseudoperonospora | Pseudoperonospora cubensis | ||
| 15323339 | 15323339 | PRJEB14664_P_NODE_14533_length_187_cov_1.578947_g14403_i0 | PRJEB14664 | 14533 | 187 | 1.578947 | 2.95263089 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 6.989999999999999e-46 | NTclustered | gi|698813201|ref|XM_009841328.1| | 112090 | g14403 | i0 | 85.561 | 2.77540106951872 | 187 | 27 | 100 | 0 | 1 | 187 | 366 | 552 | Aphanomyces astaci hypothetical protein mRNA | blastn | 519 | 196 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 16598092 | 16598092 | PRJEB14664_P_NODE_4514_length_408_cov_2.828418_g4386_i0 | PRJEB14664 | 4514 | 408 | 2.828418 | 11.53994544 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 749 | 0 | NTclustered | gi|1578815424|gb|MK546601.1| | 1982524 | g4386 | i0 | 99.755 | 99.781862745098 | 408 | 1 | 100 | 0 | 1 | 408 | 188 | 595 | Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence | blastn | 40711 | 749 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 17563588 | 17563588 | PRJEB14664_P_NODE_13294_length_198_cov_1.815951_g13164_i0 | PRJEB14664 | 13294 | 198 | 1.815951 | 3.59558298 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 7.71e-26 | NTclustered | gi|813182419|ref|XM_012350790.1| | 695850 | g13164 | i0 | 87.611 | 1.14141414141414 | 113 | 13 | 57 | 1 | 84 | 196 | 424 | 313 | Saprolegnia parasitica CBS 223.65 50S ribosomal protein L35Ae mRNA | blastn | 226 | 130 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 17563607 | 17563607 | PRJEB14664_P_NODE_2694_length_555_cov_3.038462_g2579_i0 | PRJEB14664 | 2694 | 555 | 3.038462 | 16.8634641 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.001 | NTclustered | gi|325182092|emb|FR824068.1| | 890382 | g2579 | i0 | 94.595 | 0.133333333333333 | 37 | 2 | 7 | 0 | 514 | 550 | 33969 | 34005 | Albugo laibachii Nc14, genomic contig CONTIG_23_NC14_v4_178735_235 | blastn | 74 | 58.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 17872774 | 17872774 | PRJEB14664_P_NODE_14035_length_191_cov_1.929487_g13905_i0 | PRJEB14664 | 14035 | 191 | 1.929487 | 3.68532017 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 5.3899999999999993e-67 | NTclustered | gi|166038943|emb|CU355173.1| | 100861 | g13905 | i0 | 92.063 | 83.0942408376963 | 189 | 15 | 99 | 0 | 1 | 189 | 451 | 639 | Aphanomyces euteiches cDNA | blastn | 15871 | 267 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 21387893 | 21387893 | PRJEB14664_P_NODE_7777_length_287_cov_1.876984_g7647_i0 | PRJEB14664 | 7777 | 287 | 1.876984 | 5.38694408 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 5.58e-19 | NTclustered | gi|58202010|gb|AY898628.1| | 4787 | g7647 | i0 | 75.099 | 88.2961672473868 | 253 | 52 | 86 | 10 | 39 | 286 | 1001 | 755 | Phytophthora infestans haplotype IIb mitochondrion, complete genome | blastn | 25341 | 108 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 21697881 | 21697881 | PRJEB14664_P_NODE_14278_length_189_cov_2.000000_g14148_i0 | PRJEB14664 | 14278 | 189 | 2 | 3.78 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.62e-25 | NTclustered | gi|166035576|emb|CU354455.1| | 100861 | g14148 | i0 | 92.222 | 4.97354497354497 | 90 | 7 | 48 | 0 | 1 | 90 | 753 | 842 | Aphanomyces euteiches cDNA | blastn | 940 | 128 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 21697984 | 21697984 | PRJEB14664_P_NODE_7078_length_305_cov_2.814815_g6948_i0 | PRJEB14664 | 7078 | 305 | 2.814815 | 8.58518575 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.6299999999999999e-34 | NTclustered | gi|673051000|ref|XM_008881239.1| | 157072 | g6948 | i0 | 88.06 | 12.6262295081967 | 134 | 16 | 44 | 0 | 1 | 134 | 900 | 1033 | Aphanomyces invadans fructose-bisphosphate aldolase, class II mRNA | blastn | 3851 | 159 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 22662681 | 22662681 | PRJEB14664_P_NODE_15098_length_182_cov_1.462585_g14968_i0 | PRJEB14664 | 15098 | 182 | 1.462585 | 2.6619047 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 8.559999999999999e-60 | NTclustered | gi|166051442|emb|CU364545.1| | 100861 | g14968 | i0 | 92.857 | 91.7747252747253 | 168 | 10 | 92 | 1 | 15 | 182 | 508 | 343 | Aphanomyces euteiches cDNA | blastn | 16703 | 243 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 22973267 | 22973267 | PRJEB14664_P_NODE_779_length_1027_cov_5.848790_g713_i0 | PRJEB14664 | 779 | 1027 | 5.84879 | 60.0670733 | Phytophthora novae-guineae | 3070859 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 6.049999999999999e-24 | NTclustered | gi|1940379313|gb|MN883605.1| | 3070859 | g713 | i0 | 77.477 | 9.27458617332035 | 222 | 42 | 21 | 7 | 8 | 225 | 828 | 611 | Phytophthora novae-guineae culture ICMP:19637 mitochondrion, complete genome | blastn | 9525 | 126 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora novae-guineae |
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);;