contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA915212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2170512 | 2170512 | PRJNA915212_P_NODE_1542_length_537_cov_1.213115_g1507_i0 | PRJNA915212 | 1542 | 537 | 1.213115 | 6.51442755 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 3.8e-53 | NTclustered | gi|2795061008|ref|XM_067940276.1| | 4785 | g1507 | i0 | 82.8 | 20.8379888268156 | 250 | 41 | 46 | 2 | 179 | 427 | 181 | 429 | Phytophthora cinnamomi 60S ribosomal protein L23a (IUM83_15460), partial mRNA | blastn | 11190 | 222 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 2170546 | 2170546 | PRJNA915212_P_NODE_3782_length_317_cov_0.895522_g3744_i0 | PRJNA915212 | 3782 | 317 | 0.895522 | 2.83880474 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 1e-46 | NTclustered | gi|669157777|ref|XM_008616229.1| | 1156394 | g3744 | i0 | 80.37 | 55.4227129337539 | 270 | 47 | 84 | 6 | 28 | 294 | 227 | 493 | Saprolegnia diclina VS20 60S ribosomal protein L11 mRNA | blastn | 17569 | 200 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 2526664 | 2526664 | PRJNA915212_P_NODE_11522_length_168_cov_1.285714_g11484_i0 | PRJNA915212 | 11522 | 168 | 1.285714 | 2.15999952 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 2.85e-49 | NTclustered | gi|156987041|gb|EU080554.1| | 53983 | g11484 | i0 | 89.157 | 98.75 | 166 | 18 | 99 | 0 | 3 | 168 | 1005 | 840 | Phytophthora cambivora isolate PD_00043(P0592) heat shock protein 90 (HSP90) gene, partial cds | blastn | 16590 | 209 | 0.990430622009569 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cambivora | ||
| 3445987 | 3445987 | PRJNA915212_P_NODE_1683_length_512_cov_2.684665_g1648_i0 | PRJNA915212 | 1683 | 512 | 2.684665 | 13.7454848 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 5.87e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g1648 | i0 | 80.533 | 66.0703125 | 375 | 65 | 72 | 4 | 15 | 382 | 68 | 441 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 3445996 | 3445996 | PRJNA915212_P_NODE_2383_length_425_cov_2.167553_g2347_i0 | PRJNA915212 | 2383 | 425 | 2.167553 | 9.21210025 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 8.2e-54 | NTclustered | gi|673039918|ref|XM_008875698.1| | 157072 | g2347 | i0 | 77.748 | 67.8752941176471 | 373 | 77 | 87 | 6 | 50 | 419 | 58 | 427 | Aphanomyces invadans hypothetical protein mRNA | blastn | 28847 | 224 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 3446025 | 3446025 | PRJNA915212_P_NODE_4483_length_286_cov_1.514768_g4445_i0 | PRJNA915212 | 4483 | 286 | 1.514768 | 4.33223648 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 4.24e-30 | NTclustered | gi|695460853|ref|XM_009539792.1| | 67593 | g4445 | i0 | 84.722 | 6.30769230769231 | 144 | 22 | 50 | 0 | 38 | 181 | 237 | 94 | Phytophthora sojae hypothetical protein mRNA | blastn | 1804 | 145 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 8548077 | 8548077 | PRJNA915212_P_NODE_187_length_1397_cov_2.293027_g176_i0 | PRJNA915212 | 187 | 1397 | 2.293027 | 32.03358719 | Achlya ambisexualis | 4768 | SAR_Eukaryotes | SAR_Eukaryotes | 830 | 0 | NTclustered | gi|22086552|gb|AF402101.1| | 4768 | g176 | i0 | 78.448 | 92.4430923407301 | 1327 | 246 | 94 | 30 | 91 | 1397 | 1570 | 264 | Achlya ambisexualis isolate JS855 heat shock protein Hsp90 mRNA, complete cds | blastn | 129143 | 830 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya ambisexualis | ||
| 8548119 | 8548119 | PRJNA915212_P_NODE_6467_length_230_cov_1.690608_g6429_i0 | PRJNA915212 | 6467 | 230 | 1.6906080000000001 | 3.8883984 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 1.4799999999999999e-53 | NTclustered | gi|675207712|ref|XM_008914493.1| | 761204 | g6429 | i0 | 90.476 | 98.6173913043478 | 168 | 16 | 73 | 0 | 3 | 170 | 195 | 28 | Phytophthora parasitica INRA-310 hsp70-like protein partial mRNA | blastn | 22682 | 222 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 9823003 | 9823003 | PRJNA915212_P_NODE_1408_length_563_cov_2.237354_g1374_i0 | PRJNA915212 | 1408 | 563 | 2.237354 | 12.59630302 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 604 | 3.399999999999999e-168 | NTclustered | gi|675199806|ref|XM_008910540.1| | 761204 | g1374 | i0 | 90.889 | 79.7744227353464 | 450 | 41 | 80 | 0 | 43 | 492 | 585 | 136 | Phytophthora parasitica INRA-310 calmodulin mRNA | blastn | 44913 | 604 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 9823048 | 9823048 | PRJNA915212_P_NODE_5168_length_262_cov_1.661972_g5130_i0 | PRJNA915212 | 5168 | 262 | 1.661972 | 4.35436664 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 2.92e-41 | NTclustered | gi|669146817|ref|XM_008610749.1| | 1156394 | g5130 | i0 | 82.381 | 9.08778625954199 | 210 | 35 | 80 | 2 | 3 | 211 | 223 | 431 | Saprolegnia diclina VS20 40S ribosomal protein S8 mRNA | blastn | 2381 | 182 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 10179624 | 10179624 | PRJNA915212_P_NODE_6428_length_231_cov_1.401099_g6390_i0 | PRJNA915212 | 6428 | 231 | 1.401099 | 3.23653869 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.17e-39 | NTclustered | gi|2795034154|ref|XM_067934539.1| | 4785 | g6390 | i0 | 82.439 | 57.7489177489177 | 205 | 32 | 88 | 4 | 29 | 231 | 476 | 274 | Phytophthora cinnamomi GTP-binding nuclear protein ran-1 (IUM83_10055), partial mRNA | blastn | 13340 | 176 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 12374300 | 12374300 | PRJNA915212_P_NODE_3710_length_322_cov_1.366300_g3672_i0 | PRJNA915212 | 3710 | 322 | 1.3663 | 4.399486 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 7.939999999999998e-43 | NTclustered | gi|669151349|ref|XM_008613015.1| | 1156394 | g3672 | i0 | 77.329 | 31.9285714285714 | 322 | 69 | 99 | 3 | 3 | 322 | 1158 | 839 | Saprolegnia diclina VS20 adenosylhomocysteinase mRNA | blastn | 10281 | 187 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 14005049 | 14005049 | PRJNA915212_P_NODE_151_length_1481_cov_2.247905_g142_i0 | PRJNA915212 | 151 | 1481 | 2.247905 | 33.29147305 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 944 | 0 | NTclustered | gi|189084708|gb|BT032224.1| | 4784 | g142 | i0 | 80.378 | 81.4996623902768 | 1269 | 227 | 85 | 17 | 148 | 1405 | 2041 | 784 | Phytophthora capsici clone CBOT153-M08 mRNA sequence | blastn | 120701 | 944 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 14923061 | 14923061 | PRJNA915212_P_NODE_132_length_1538_cov_2.656817_g123_i0 | PRJNA915212 | 132 | 1538 | 2.656817 | 40.86184546 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 1090 | 0 | NTclustered | gi|38489929|gb|AY456093.1| | 4792 | g123 | i0 | 80.384 | 96.2808842652796 | 1458 | 266 | 94 | 19 | 89 | 1536 | 2360 | 913 | Phytophthora nicotianae heat shock protein 70 (Hsp70a) gene, complete cds | blastn | 148080 | 1090 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 16198002 | 16198002 | PRJNA915212_P_NODE_1373_length_572_cov_2.676864_g1341_i0 | PRJNA915212 | 1373 | 572 | 2.676864 | 15.31166208 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 5.149999999999999e-67 | NTclustered | gi|673014017|ref|XM_008862748.1| | 157072 | g1341 | i0 | 82.132 | 6.72727272727273 | 319 | 51 | 55 | 5 | 130 | 445 | 480 | 165 | Aphanomyces invadans archaeal ribosomal protein S17P mRNA | blastn | 3848 | 268 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 16198087 | 16198087 | PRJNA915212_P_NODE_8173_length_204_cov_0.987097_g8135_i0 | PRJNA915212 | 8173 | 204 | 0.987097 | 2.01367788 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.73e-22 | NTclustered | gi|698810055|ref|XM_009839755.1| | 112090 | g8135 | i0 | 77.612 | 1.23039215686275 | 201 | 41 | 98 | 4 | 4 | 202 | 2166 | 1968 | Aphanomyces astaci transitional endoplasmic reticulum ATPase mRNA | blastn | 251 | 119 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 20021800 | 20021800 | PRJNA915212_P_NODE_216_length_1328_cov_2.501173_g204_i0 | PRJNA915212 | 216 | 1328 | 2.501173 | 33.21557744 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 634 | 1.0599999999999995e-176 | NTclustered | gi|189083945|gb|BT031461.1| | 4784 | g204 | i0 | 78.63 | 53.605421686747 | 978 | 193 | 73 | 16 | 359 | 1328 | 1740 | 771 | Phytophthora capsici clone CBOT17-D19 mRNA sequence | blastn | 71188 | 634 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 21653194 | 21653194 | PRJNA915212_P_NODE_1937_length_476_cov_1.824356_g1902_i0 | PRJNA915212 | 1937 | 476 | 1.824356 | 8.68393456 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 414 | 5.13e-111 | NTclustered | gi|673019533|ref|XM_008865506.1| | 157072 | g1902 | i0 | 84.397 | 87.5525210084034 | 423 | 64 | 89 | 2 | 2 | 423 | 136 | 557 | Aphanomyces invadans hypothetical protein mRNA | blastn | 41675 | 418 | 0.990430622009569 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 22572232 | 22572232 | PRJNA915212_P_NODE_5258_length_260_cov_1.194313_g5220_i0 | PRJNA915212 | 5258 | 260 | 1.194313 | 3.1052138 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.76e-33 | NTclustered | gi|2795047539|ref|XM_067937834.1| | 4785 | g5220 | i0 | 79.545 | 42.9730769230769 | 220 | 43 | 84 | 2 | 42 | 260 | 459 | 241 | Phytophthora cinnamomi 60S ribosomal protein (IUM83_13175), partial mRNA | blastn | 11173 | 156 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi |
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);;