contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA330616" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2940433 | 2940433 | PRJNA330616_P_NODE_29443_length_163_cov_3.570175_g29034_i0 | PRJNA330616 | 29443 | 163 | 3.570175 | 5.81938525 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 7.95e-20 | NTclustered | gi|189084924|gb|BT032455.1| | 4784 | g29034 | i0 | 81.119 | 1.58895705521472 | 143 | 21 | 86 | 4 | 2 | 141 | 155 | 294 | Phytophthora capsici clone CBOU133-E02 mRNA sequence | blastn | 259 | 110 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 4217099 | 4217099 | PRJNA330616_P_NODE_32984_length_154_cov_2.914286_g32575_i0 | PRJNA330616 | 32984 | 154 | 2.914286 | 4.48800044 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 3.319999999999999e-43 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g32575 | i0 | 90.345 | 35.1948051948052 | 145 | 10 | 93 | 4 | 1 | 143 | 1523 | 1665 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 5420 | 187 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 5493068 | 5493068 | PRJNA330616_P_NODE_13265_length_228_cov_1.139665_g12856_i0 | PRJNA330616 | 13265 | 228 | 1.139665 | 2.5984362 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 359 | 1.07e-94 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g12856 | i0 | 95.175 | 106.842105263158 | 228 | 9 | 99 | 2 | 3 | 228 | 8728 | 8501 | Achlya hypogyna mitochondrion, complete genome | blastn | 24360 | 359 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 5493084 | 5493084 | PRJNA330616_P_NODE_14545_length_218_cov_3.011834_g14136_i0 | PRJNA330616 | 14545 | 218 | 3.011834 | 6.56579812 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 5.969999999999999e-107 | NTclustered | gi|1578815424|gb|MK546601.1| | 1982524 | g14136 | i0 | 100 | 99.1192660550459 | 216 | 0 | 99 | 0 | 1 | 216 | 356 | 571 | Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence | blastn | 21608 | 399 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 5493359 | 5493359 | PRJNA330616_P_NODE_3145_length_491_cov_2.382353_g2740_i0 | PRJNA330616 | 3145 | 491 | 2.382353 | 11.69735323 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 5.61e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g2740 | i0 | 80.533 | 68.8859470468432 | 375 | 65 | 75 | 4 | 118 | 485 | 441 | 68 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33823 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 6767469 | 6767469 | PRJNA330616_P_NODE_4826_length_385_cov_6.383929_g4417_i0 | PRJNA330616 | 4826 | 385 | 6.383929 | 24.57812665 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 512 | 1.4000000000000001e-140 | NTclustered | gi|325195057|emb|FR825852.1| | 890382 | g4417 | i0 | 91.689 | 87.6441558441558 | 373 | 25 | 96 | 5 | 16 | 384 | 108 | 478 | Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 | blastn | 33743 | 512 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 6767478 | 6767478 | PRJNA330616_P_NODE_5506_length_358_cov_1.776699_g5097_i0 | PRJNA330616 | 5506 | 358 | 1.776699 | 6.36058242 | Phytophthora cactorum | 29920 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 8.909999999999998e-43 | NTclustered | gi|1490229970|gb|MH094138.1| | 29920 | g5097 | i0 | 90.714 | 39.7905027932961 | 140 | 13 | 39 | 0 | 13 | 152 | 536 | 675 | Phytophthora cactorum isolate KRJ1 ATP synthase protein 9 (atp9) gene, partial cds; NADH dehydrogenase subunit 9 (nad9) gene, complete cds; and apocytochrome b (cob) gene, partial cds; mitochondrial | blastn | 14245 | 187 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 11868217 | 11868217 | PRJNA330616_P_NODE_16630_length_205_cov_2.410256_g16221_i0 | PRJNA330616 | 16630 | 205 | 2.410256 | 4.9410248 | Aphanomyces sinensis | 1125843 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 7.279999999999998e-96 | NTclustered | gi|378925979|gb|JQ070142.1| | 1125843 | g16221 | i0 | 98.537 | 100 | 205 | 3 | 100 | 0 | 1 | 205 | 75 | 279 | Aphanomyces sinensis strain ATCC MYA-4825 28S ribosomal RNA gene, complete sequence | blastn | 20500 | 363 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sinensis | ||
| 12547877 | 12547877 | PRJNA330616_P_NODE_22470_length_178_cov_1.581395_g22061_i0 | PRJNA330616 | 22470 | 178 | 1.581395 | 2.8148831 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 1.34e-82 | NTclustered | gi|698793877|ref|XR_717099.1| | 112090 | g22061 | i0 | 98.876 | 99.8314606741573 | 178 | 2 | 100 | 0 | 1 | 178 | 701 | 878 | Aphanomyces astaci 18S ribosomal RNA rRNA | blastn | 17770 | 318 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 13822910 | 13822910 | PRJNA330616_P_NODE_5491_length_358_cov_3.799353_g5082_i0 | PRJNA330616 | 5491 | 358 | 3.799353 | 13.60168374 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 662 | 0 | NTclustered | gi|166048041|emb|CU364162.1| | 100861 | g5082 | i0 | 100 | 98.6787709497207 | 358 | 0 | 100 | 0 | 1 | 358 | 540 | 183 | Aphanomyces euteiches cDNA | blastn | 35327 | 662 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 18241175 | 18241175 | PRJNA330616_P_NODE_13655_length_225_cov_1.159091_g13246_i0 | PRJNA330616 | 13655 | 225 | 1.159091 | 2.60795475 | Achlya bisexualis | 4766 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 6.6099999999999996e-62 | NTclustered | gi|2289|emb|X59936.1| | 4766 | g13246 | i0 | 86.667 | 95.4844444444444 | 225 | 30 | 100 | 0 | 1 | 225 | 233 | 9 | A.bisexualis gene for actin | blastn | 21484 | 250 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya bisexualis | ||
| 18241254 | 18241254 | PRJNA330616_P_NODE_18775_length_194_cov_1.758621_g18366_i0 | PRJNA330616 | 18775 | 194 | 1.758621 | 3.41172474 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 3.2599999999999993e-74 | NTclustered | gi|1111669769|ref|NC_032052.1| | 157072 | g18366 | i0 | 93.782 | 105.5 | 193 | 12 | 99 | 0 | 1 | 193 | 2860 | 2668 | Aphanomyces invadans isolate NJM9701 mitochondrion, complete genome | blastn | 20467 | 291 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 18241445 | 18241445 | PRJNA330616_P_NODE_33035_length_153_cov_3.144231_g32626_i0 | PRJNA330616 | 33035 | 153 | 3.144231 | 4.81067343 | Plasmopara halstedii | 4781 | SAR_Eukaryotes | SAR_Eukaryotes | 84.2 | 4.44e-12 | NTclustered | gi|1378160993|ref|XM_024729844.1| | 4781 | g32626 | i0 | 87.671 | 2.05228758169935 | 73 | 7 | 47 | 2 | 38 | 109 | 398 | 469 | Plasmopara halstedii 40s ribosomal protein s6 (PHALS_14102), partial mRNA | blastn | 314 | 84.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 18241472 | 18241472 | PRJNA330616_P_NODE_5195_length_370_cov_2.208723_g4786_i0 | PRJNA330616 | 5195 | 370 | 2.208723 | 8.1722751 | Achlya klebsiana | 4767 | SAR_Eukaryotes | SAR_Eukaryotes | 366 | 1.1099999999999999e-96 | NTclustered | gi|166303|gb|J05116.1|ACKCAL | 4767 | g4786 | i0 | 88.487 | 80.8459459459459 | 304 | 33 | 82 | 2 | 68 | 370 | 945 | 643 | A.klebsiana calmodulin gene, complete cds | blastn | 29913 | 366 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 19515599 | 19515599 | PRJNA330616_P_NODE_25956_length_167_cov_0.864407_g25547_i0 | PRJNA330616 | 25956 | 167 | 0.864407 | 1.44355969 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 7.69e-65 | NTclustered | gi|673038275|ref|XM_008874877.1| | 157072 | g25547 | i0 | 94.611 | 62.6586826347305 | 167 | 9 | 100 | 0 | 1 | 167 | 225 | 59 | Aphanomyces invadans 60S ribosomal protein L27a mRNA | blastn | 10464 | 259 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 22066277 | 22066277 | PRJNA330616_P_NODE_3778_length_442_cov_1.526718_g3371_i0 | PRJNA330616 | 3778 | 442 | 1.526718 | 6.74809356 | Paralagenidium karlingii | 1440115 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 8.87e-29 | NTclustered | gi|2554484921|ref|NC_080886.1| | 1440115 | g3371 | i0 | 90.09 | 25.2149321266968 | 111 | 8 | 25 | 3 | 256 | 365 | 41764 | 41656 | Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome | blastn | 11145 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Paralagenidium | Paralagenidium karlingii | ||||
| 23341595 | 23341595 | PRJNA330616_P_NODE_22819_length_177_cov_1.234375_g22410_i0 | PRJNA330616 | 22819 | 177 | 1.234375 | 2.18484375 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.89e-79 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g22410 | i0 | 97.778 | 95.6101694915254 | 180 | 1 | 100 | 2 | 1 | 177 | 1619 | 1798 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 16923 | 307 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 24616009 | 24616009 | PRJNA330616_P_NODE_6880_length_318_cov_2.323420_g6471_i0 | PRJNA330616 | 6880 | 318 | 2.32342 | 7.3884756 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 1.01e-41 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g6471 | i0 | 80.672 | 13.2358490566038 | 238 | 44 | 75 | 2 | 1 | 237 | 363 | 127 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 4209 | 183 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans |
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);;