contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA753704" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 730903 | 730903 | PRJNA753704_P_NODE_13421_length_325_cov_3.460317_g13060_i0 | PRJNA753704 | 13421 | 325 | 3.460317 | 11.24603025 | Saprolegnia ferax | 4770 | SAR_Eukaryotes | SAR_Eukaryotes | 510 | 4.19e-140 | NTclustered | gi|50261276|ref|NC_005984.1| | 4770 | g13060 | i0 | 95.077 | 106.661538461538 | 325 | 14 | 100 | 2 | 1 | 325 | 10690 | 11012 | Saprolegnia ferax mitochondrion, complete genome | blastn | 34665 | 510 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia ferax | ||
| 730989 | 730989 | PRJNA753704_P_NODE_21821_length_261_cov_2.968085_g21460_i0 | PRJNA753704 | 21821 | 261 | 2.968085 | 7.74670185 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 7.12e-132 | NTclustered | gi|1923460157|gb|MW187635.1| | 1982524 | g21460 | i0 | 100 | 101.011494252874 | 261 | 0 | 100 | 0 | 1 | 261 | 372 | 112 | Aphanomyces sp. isolate CCRJB_30 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 26364 | 483 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 731012 | 731012 | PRJNA753704_P_NODE_23621_length_253_cov_0.866667_g23260_i0 | PRJNA753704 | 23621 | 253 | 0.866667 | 2.19266751 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 462 | 8.95e-126 | NTclustered | gi|166046610|emb|CU367727.1| | 100861 | g23260 | i0 | 99.605 | 18.8893280632411 | 253 | 1 | 100 | 0 | 1 | 253 | 549 | 297 | Aphanomyces euteiches cDNA | blastn | 4779 | 462 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 2007024 | 2007024 | PRJNA753704_P_NODE_18162_length_283_cov_8.990476_g17801_i0 | PRJNA753704 | 18162 | 283 | 8.990476 | 25.44304708 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 405 | 1.74e-108 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g17801 | i0 | 93.455 | 73.3957597173145 | 275 | 14 | 96 | 4 | 1 | 273 | 1393 | 1665 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 20771 | 405 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 2007196 | 2007196 | PRJNA753704_P_NODE_5402_length_490_cov_3.798561_g5041_i0 | PRJNA753704 | 5402 | 490 | 3.798561 | 18.6129489 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 841 | 0 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g5041 | i0 | 97.566 | 109.7 | 493 | 8 | 100 | 2 | 1 | 490 | 6423 | 5932 | Achlya hypogyna mitochondrion, complete genome | blastn | 53753 | 841 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 3282269 | 3282269 | PRJNA753704_P_NODE_13263_length_327_cov_1.842520_g12902_i0 | PRJNA753704 | 13263 | 327 | 1.84252 | 6.0250404 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 604 | 1.8799999999999993e-168 | NTclustered | gi|166044512|emb|CU367421.1| | 100861 | g12902 | i0 | 100 | 22.4250764525994 | 327 | 0 | 100 | 0 | 1 | 327 | 59 | 385 | Aphanomyces euteiches cDNA | blastn | 7333 | 604 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 3282341 | 3282341 | PRJNA753704_P_NODE_19923_length_272_cov_1.989950_g19562_i0 | PRJNA753704 | 19923 | 272 | 1.98995 | 5.412664 | Achlya bisexualis | 4766 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 3.01e-51 | NTclustered | gi|2289|emb|X59936.1| | 4766 | g19562 | i0 | 87.912 | 62.5294117647059 | 182 | 22 | 67 | 0 | 1 | 182 | 182 | 1 | A.bisexualis gene for actin | blastn | 17008 | 215 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya bisexualis | ||
| 5834753 | 5834753 | PRJNA753704_P_NODE_3165_length_626_cov_2.629295_g2810_i0 | PRJNA753704 | 3165 | 626 | 2.629295 | 16.4593867 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 562 | 2.32e-155 | NTclustered | gi|1899253468|gb|MT780642.1| | 82926 | g2810 | i0 | 83.226 | 99.3594249201278 | 620 | 96 | 98 | 7 | 5 | 620 | 730 | 115 | Globisporangium splendens isolate 63PYspl cytochrome oxidase subunit 1 (COXI) gene, partial cds; mitochondrial | blastn | 62199 | 562 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 7579995 | 7579995 | PRJNA753704_P_NODE_2066_length_757_cov_4.776316_g1734_i0 | PRJNA753704 | 2066 | 757 | 4.776316 | 36.15671212 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 1.83e-102 | NTclustered | gi|2055402917|ref|NC_056124.1| | 360399 | g1734 | i0 | 77.545 | 83.8811096433289 | 668 | 132 | 87 | 15 | 91 | 749 | 20822 | 21480 | Phytophthora fallax culture ICMP:17563 mitochondrion, complete genome | blastn | 63498 | 390 | 0.992307692307692 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fallax | ||
| 9659637 | 9659637 | PRJNA753704_P_NODE_29688_length_231_cov_6.259494_g29327_i0 | PRJNA753704 | 29688 | 231 | 6.259494 | 14.45943114 | Peronospora tabacina | 230439 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 3.31e-30 | NTclustered | gi|948299304|ref|NC_028331.1| | 230439 | g29327 | i0 | 86.029 | 58.7359307359307 | 136 | 17 | 58 | 2 | 3 | 137 | 14232 | 14098 | Peronospora tabacina isolate 968-J2 mitochondrion, complete genome | blastn | 13568 | 145 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora tabacina | ||
| 12210471 | 12210471 | PRJNA753704_P_NODE_15610_length_303_cov_4.817391_g15249_i0 | PRJNA753704 | 15610 | 303 | 4.817391 | 14.59669473 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 538 | 1.7799999999999995e-148 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g15249 | i0 | 98.68 | 105.683168316832 | 303 | 4 | 100 | 0 | 1 | 303 | 381 | 683 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 32022 | 538 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 16033650 | 16033650 | PRJNA753704_P_NODE_19833_length_273_cov_1.100000_g19472_i0 | PRJNA753704 | 19833 | 273 | 1.1 | 3.003 | Phytopythium vexans | 907947 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.1e-40 | NTclustered | gi|2248513842|ref|NC_063815.1| | 907947 | g19472 | i0 | 83.756 | 54.6923076923077 | 197 | 24 | 71 | 8 | 1 | 194 | 2304 | 2495 | Phytopythium vexans culture CBS:119.80 mitochondrion, complete genome | blastn | 14931 | 180 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Phytopythium | Phytopythium vexans | ||
| 21133708 | 21133708 | PRJNA753704_P_NODE_4417_length_537_cov_2.984914_g4058_i0 | PRJNA753704 | 4417 | 537 | 2.984914 | 16.02898818 | Peronosclerospora sorghi | 230839 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 1.81e-36 | NTclustered | gi|2431515601|ref|NC_070108.1| | 230839 | g4058 | i0 | 73.852 | 78.2905027932961 | 501 | 96 | 90 | 24 | 54 | 537 | 648 | 166 | Peronosclerospora sorghi isolate P6 mitochondrion, complete genome | blastn | 42042 | 167 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 22879663 | 22879663 | PRJNA753704_P_NODE_26538_length_246_cov_0.901734_g26177_i0 | PRJNA753704 | 26538 | 246 | 0.901734 | 2.21826564 | root | 1 | Root_unresolved | Root_unresolved | 455 | 1.4500000000000002e-123 | NTclustered | gi|166044489|emb|CU367398.1| | 100861 | g26177 | i0 | 100 | 98.4634146341463 | 246 | 0 | 100 | 0 | 1 | 246 | 198 | 443 | Aphanomyces euteiches cDNA | blastn | 24222 | 455 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 23683921 | 23683921 | PRJNA753704_P_NODE_10179_length_370_cov_1.774411_g9818_i0 | PRJNA753704 | 10179 | 370 | 1.774411 | 6.5653207 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 628 | 1.28e-175 | NTclustered | gi|1111669769|ref|NC_032052.1| | 157072 | g9818 | i0 | 97.305 | 107.264864864865 | 371 | 9 | 100 | 1 | 1 | 370 | 4101 | 3731 | Aphanomyces invadans isolate NJM9701 mitochondrion, complete genome | blastn | 39688 | 628 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 24153687 | 24153687 | PRJNA753704_P_NODE_20199_length_270_cov_11.380711_g19838_i0 | PRJNA753704 | 20199 | 270 | 11.380711 | 30.7279197 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 496 | 9.51e-136 | NTclustered | gi|2099741709|gb|OK271022.1| | 253176 | g19838 | i0 | 99.63 | 99.8851851851852 | 270 | 1 | 100 | 0 | 1 | 270 | 634 | 903 | Aphanomyces cladogamus voucher CCIBt3854 small subunit ribosomal RNA gene, partial sequence | blastn | 26969 | 499 | 0.993987975951904 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cladogamus | ||
| 24153804 | 24153804 | PRJNA753704_P_NODE_9859_length_374_cov_6.106312_g9498_i0 | PRJNA753704 | 9859 | 374 | 6.106312 | 22.83760688 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 684 | 0 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g9498 | i0 | 99.732 | 100.021390374332 | 373 | 1 | 99 | 0 | 2 | 374 | 338 | 710 | Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 37408 | 689 | 0.992743105950653 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 25428719 | 25428719 | PRJNA753704_P_NODE_26900_length_245_cov_0.906977_g26539_i0 | PRJNA753704 | 26900 | 245 | 0.906977 | 2.22209365 | root | 1 | Root_unresolved | Root_unresolved | 453 | 5.1900000000000006e-123 | NTclustered | gi|166044610|emb|CU367519.1| | 100861 | g26539 | i0 | 100 | 95.4489795918367 | 245 | 0 | 100 | 0 | 1 | 245 | 288 | 44 | Aphanomyces euteiches cDNA | blastn | 23385 | 453 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;