contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA857143" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2118287 | 2118287 | PRJNA857143_S_NODE_105082_length_307_cov_3.128205_g103989_i0 | PRJNA857143 | 105082 | 307 | 3.128205 | 9.60358935 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 9.94e-27 | NTclustered | gi|695411611|ref|XM_009527227.1| | 67593 | g103989 | i0 | 83.108 | 3.5928338762215 | 148 | 23 | 48 | 2 | 94 | 240 | 343 | 197 | Phytophthora sojae hypothetical protein mRNA | blastn | 1103 | 134 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 2119121 | 2119121 | PRJNA857143_S_NODE_186802_length_245_cov_1.651163_g185709_i0 | PRJNA857143 | 186802 | 245 | 1.651163 | 4.04534935 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.02e-5 | NTclustered | gi|2795044158|ref|XM_067924075.1| | 4785 | g185709 | i0 | 95 | 0.163265306122449 | 40 | 2 | 16 | 0 | 184 | 223 | 536 | 497 | Phytophthora cinnamomi 60S ribosomal protein L9 (IUM83_00313), partial mRNA | blastn | 40 | 63.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 2510834 | 2510834 | PRJNA857143_S_NODE_173482_length_251_cov_1.280899_g172389_i0 | PRJNA857143 | 173482 | 251 | 1.280899 | 3.21505649 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 1.04e-10 | NTclustered | gi|813157758|ref|XM_012346838.1| | 695850 | g172389 | i0 | 90.164 | 1.09561752988048 | 61 | 6 | 24 | 0 | 191 | 251 | 425 | 365 | Saprolegnia parasitica CBS 223.65 40S ribosomal protein S13 mRNA | blastn | 275 | 80.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 11046576 | 11046576 | PRJNA857143_S_NODE_11289_length_650_cov_1.630849_g10280_i0 | PRJNA857143 | 11289 | 650 | 1.630849 | 10.6005185 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 481 | 6.96e-131 | NTclustered | gi|1111669769|ref|NC_032052.1| | 157072 | g10280 | i0 | 80.769 | 78.3030769230769 | 650 | 96 | 98 | 20 | 7 | 643 | 2196 | 1563 | Aphanomyces invadans isolate NJM9701 mitochondrion, complete genome | blastn | 50897 | 481 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 12323277 | 12323277 | PRJNA857143_S_NODE_430_length_1789_cov_47.469114_g323_i0 | PRJNA857143 | 430 | 1789 | 47.469114 | 849.22244946 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 7.66e-80 | NTclustered | gi|328802538|emb|FR832890.1| | 890382 | g323 | i0 | 83.095 | 20.575181665735 | 349 | 54 | 19 | 5 | 1443 | 1789 | 2002 | 1657 | Albugo laibachii Nc14, mitochondrial genomic contig NODE_36_length_2553_cov_1396.121460 | blastn | 36809 | 313 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 14871603 | 14871603 | PRJNA857143_S_NODE_181332_length_248_cov_0.891429_g180239_i0 | PRJNA857143 | 181332 | 248 | 0.891429 | 2.21074392 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 9.79e-46 | NTclustered | gi|813177544|ref|XM_012349852.1| | 695850 | g180239 | i0 | 81.857 | 6.44758064516129 | 237 | 39 | 95 | 4 | 14 | 248 | 1219 | 985 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 1599 | 196 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 14872551 | 14872551 | PRJNA857143_S_NODE_92_length_2684_cov_31.775565_g59_i0 | PRJNA857143 | 92 | 2684 | 31.775565 | 852.8561646 | Phytophthora hedraiandra | 295481 | SAR_Eukaryotes | SAR_Eukaryotes | 540 | 4.879999999999998e-148 | NTclustered | gi|2314988701|ref|NC_067067.1| | 295481 | g59 | i0 | 75.098 | 42.6039493293592 | 1273 | 258 | 46 | 51 | 5 | 1247 | 33226 | 31983 | Phytophthora hedraiandra voucher CBS111725 mitochondrion, complete genome | blastn | 114349 | 540 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora hedraiandra | ||
| 16146260 | 16146260 | PRJNA857143_S_NODE_172773_length_251_cov_1.752809_g171680_i0 | PRJNA857143 | 172773 | 251 | 1.752809 | 4.39955059 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 5.98e-43 | NTclustered | gi|813141452|ref|XM_012343573.1| | 695850 | g171680 | i0 | 84.946 | 15.4183266932271 | 186 | 26 | 74 | 2 | 1 | 185 | 583 | 767 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L8 mRNA | blastn | 3870 | 187 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 16146670 | 16146670 | PRJNA857143_S_NODE_34333_length_445_cov_8.086022_g33241_i0 | PRJNA857143 | 34333 | 445 | 8.086022 | 35.9827979 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 2.47e-34 | NTclustered | gi|669146817|ref|XM_008610749.1| | 1156394 | g33241 | i0 | 77.622 | 7.33932584269663 | 286 | 48 | 63 | 13 | 165 | 445 | 633 | 359 | Saprolegnia diclina VS20 40S ribosomal protein S8 mRNA | blastn | 3266 | 159 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 17421004 | 17421004 | PRJNA857143_S_NODE_101534_length_311_cov_3.155462_g100441_i0 | PRJNA857143 | 101534 | 311 | 3.155462 | 9.81348682 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 2.12e-43 | NTclustered | gi|813141452|ref|XM_012343573.1| | 695850 | g100441 | i0 | 83.019 | 8.33440514469453 | 212 | 32 | 68 | 4 | 96 | 305 | 767 | 558 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L8 mRNA | blastn | 2592 | 189 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 17812742 | 17812742 | PRJNA857143_S_NODE_121814_length_290_cov_7.898618_g120721_i0 | PRJNA857143 | 121814 | 290 | 7.898618 | 22.9059922 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 9.19e-37 | NTclustered | gi|301119740|ref|XM_002907552.1| | 403677 | g120721 | i0 | 79.675 | 61.3241379310345 | 246 | 38 | 83 | 10 | 5 | 244 | 219 | 458 | Phytophthora infestans T30-4 60S ribosomal protein L23a (PITG_02694), mRNA | blastn | 17784 | 167 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 19969505 | 19969505 | PRJNA857143_S_NODE_113636_length_298_cov_3.835556_g112543_i0 | PRJNA857143 | 113636 | 298 | 3.835556 | 11.42995688 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 2.69e-22 | NTclustered | gi|675192356|ref|XM_008906815.1| | 761204 | g112543 | i0 | 88.66 | 30.4463087248322 | 97 | 11 | 33 | 0 | 65 | 161 | 416 | 320 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 9073 | 119 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 23796297 | 23796297 | PRJNA857143_S_NODE_49139_length_398_cov_2.350769_g48046_i0 | PRJNA857143 | 49139 | 398 | 2.350769 | 9.35606062 | Achlya klebsiana | 4767 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 2.82e-33 | NTclustered | gi|166303|gb|J05116.1|ACKCAL | 4767 | g48046 | i0 | 90 | 6.5 | 120 | 12 | 30 | 0 | 279 | 398 | 935 | 816 | A.klebsiana calmodulin gene, complete cds | blastn | 2587 | 156 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya klebsiana | ||
| 23796381 | 23796381 | PRJNA857143_S_NODE_56659_length_380_cov_3.977199_g55566_i0 | PRJNA857143 | 56659 | 380 | 3.977199 | 15.1133562 | Peronospora tabacina | 230439 | SAR_Eukaryotes | SAR_Eukaryotes | 388 | 2.4299999999999997e-103 | NTclustered | gi|948299304|ref|NC_028331.1| | 230439 | g55566 | i0 | 85.753 | 97.5973684210526 | 372 | 47 | 97 | 5 | 1 | 367 | 2395 | 2025 | Peronospora tabacina isolate 968-J2 mitochondrion, complete genome | blastn | 37087 | 388 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora tabacina | ||
| 23796495 | 23796495 | PRJNA857143_S_NODE_68319_length_357_cov_5.140845_g67226_i0 | PRJNA857143 | 68319 | 357 | 5.140845 | 18.35281665 | Halophytophthora thermoambigua | 2874305 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 3.22e-37 | NTclustered | gi|2213903340|gb|OK091352.1| | 2874305 | g67226 | i0 | 77.972 | 76.6610644257703 | 286 | 51 | 79 | 10 | 75 | 357 | 416 | 140 | Halophytophthora sp. MHJ-2021h isolate BD630 from Portugal heat shock protein 90 (hsp90) gene, partial cds | blastn | 27368 | 169 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Halophytophthora | Halophytophthora thermoambigua | ||
| 25069333 | 25069333 | PRJNA857143_S_NODE_142240_length_273_cov_1.060000_g141147_i0 | PRJNA857143 | 142240 | 273 | 1.06 | 2.8938 | Halophytophthora avicenniae | 289610 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.1e-40 | NTclustered | gi|1229862066|gb|KY788554.1| | 289610 | g141147 | i0 | 82.609 | 76.003663003663 | 207 | 32 | 75 | 4 | 4 | 208 | 730 | 526 | Halophytophthora avicenniae isolate CBS 188.85 heat shock protein 90 (Hsp90) gene, partial cds | blastn | 20749 | 180 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Halophytophthora | Halophytophthora avicenniae |
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);;