contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA407886" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2967695 | 2967695 | PRJNA407886_P_NODE_19883_length_573_cov_3.046000_g18201_i0 | PRJNA407886 | 19883 | 573 | 3.046 | 17.45358 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 6.62e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g18201 | i0 | 80.533 | 59.0366492146597 | 375 | 65 | 64 | 4 | 191 | 558 | 441 | 68 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 2968640 | 2968640 | PRJNA407886_P_NODE_66663_length_258_cov_1.151351_g64969_i0 | PRJNA407886 | 66663 | 258 | 1.151351 | 2.97048558 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.33e-44 | NTclustered | gi|813198223|ref|XM_012353305.1| | 695850 | g64969 | i0 | 86.364 | 7.52325581395349 | 176 | 24 | 68 | 0 | 3 | 178 | 488 | 663 | Saprolegnia parasitica CBS 223.65 hypothetical protein partial mRNA | blastn | 1941 | 193 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 8071106 | 8071106 | PRJNA407886_P_NODE_61767_length_270_cov_1.142132_g60073_i0 | PRJNA407886 | 61767 | 270 | 1.142132 | 3.0837564 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.41e-39 | NTclustered | gi|195970350|gb|EU880228.1| | 67593 | g60073 | i0 | 84.659 | 12.9666666666667 | 176 | 27 | 65 | 0 | 85 | 260 | 449 | 274 | Phytophthora sojae calmodulin (CAM1) mRNA, complete cds | blastn | 3501 | 176 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 8734988 | 8734988 | PRJNA407886_P_NODE_39147_length_351_cov_1.571942_g37453_i0 | PRJNA407886 | 39147 | 351 | 1.571942 | 5.51751642 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 5.129999999999999e-55 | NTclustered | gi|2795037587|ref|XM_067935188.1| | 4785 | g37453 | i0 | 79.697 | 12.1367521367521 | 330 | 55 | 92 | 9 | 7 | 330 | 330 | 7 | Phytophthora cinnamomi 60S ribosomal protein L5 (IUM83_10672), partial mRNA | blastn | 4260 | 228 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 11896236 | 11896236 | PRJNA407886_P_NODE_41850_length_337_cov_1.556818_g40156_i0 | PRJNA407886 | 41850 | 337 | 1.556818 | 5.24647666 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 1.32e-80 | NTclustered | gi|675185100|ref|XM_008903187.1| | 761204 | g40156 | i0 | 83.383 | 96.4124629080119 | 337 | 56 | 100 | 0 | 1 | 337 | 1357 | 1693 | Phytophthora parasitica INRA-310 luminal-binding protein mRNA | blastn | 32491 | 313 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 13170725 | 13170725 | PRJNA407886_P_NODE_20911_length_550_cov_4.192872_g19225_i0 | PRJNA407886 | 20911 | 550 | 4.192872 | 23.060796 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 2.99e-59 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g19225 | i0 | 79.05 | 14.4090909090909 | 358 | 71 | 65 | 4 | 104 | 459 | 482 | 127 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 7925 | 243 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 18269062 | 18269062 | PRJNA407886_P_NODE_45235_length_322_cov_3.594378_g43541_i0 | PRJNA407886 | 45235 | 322 | 3.594378 | 11.57389716 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 3.64e-51 | NTclustered | gi|675165742|ref|XM_008893508.1| | 761204 | g43541 | i0 | 78.947 | 41.0093167701863 | 323 | 62 | 99 | 6 | 2 | 321 | 1657 | 1338 | Phytophthora parasitica INRA-310 translation elongation factor aEF-2 mRNA | blastn | 13205 | 215 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 19543152 | 19543152 | PRJNA407886_P_NODE_40396_length_344_cov_3.051661_g38702_i0 | PRJNA407886 | 40396 | 344 | 3.051661 | 10.49771384 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 1.7599999999999997e-74 | NTclustered | gi|669151349|ref|XM_008613015.1| | 1156394 | g38702 | i0 | 82.029 | 23.625 | 345 | 60 | 100 | 2 | 1 | 344 | 1158 | 1501 | Saprolegnia diclina VS20 adenosylhomocysteinase mRNA | blastn | 8127 | 292 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 20819018 | 20819018 | PRJNA407886_P_NODE_41417_length_339_cov_1.590226_g39723_i0 | PRJNA407886 | 41417 | 339 | 1.590226 | 5.39086614 | Plectospira myriandra | 100863 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 8.06e-73 | NTclustered | gi|57903345|gb|AY729823.1| | 100863 | g39723 | i0 | 82.143 | 54.6430678466077 | 336 | 58 | 99 | 2 | 2 | 336 | 514 | 848 | Plectospira myriandra beta-tubulin gene, partial cds | blastn | 18524 | 287 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Plectospira | Plectospira myriandra | ||
| 20819268 | 20819268 | PRJNA407886_P_NODE_52737_length_295_cov_1.387387_g51043_i0 | PRJNA407886 | 52737 | 295 | 1.387387 | 4.09279165 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.2e-40 | NTclustered | gi|2795017327|ref|XM_067936784.1| | 4785 | g51043 | i0 | 79.842 | 4.66440677966102 | 253 | 45 | 85 | 6 | 46 | 295 | 947 | 1196 | Phytophthora cinnamomi Dihydrolipoyl dehydrogenase (IUM83_12177), partial mRNA | blastn | 1376 | 180 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 23369076 | 23369076 | PRJNA407886_P_NODE_22479_length_519_cov_4.394619_g20791_i0 | PRJNA407886 | 22479 | 519 | 4.394619 | 22.80807261 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 4.639999999999999e-67 | NTclustered | gi|698822976|ref|XM_009846215.1| | 112090 | g20791 | i0 | 83.505 | 59.0481695568401 | 291 | 45 | 56 | 3 | 91 | 380 | 527 | 239 | Aphanomyces astaci 40S ribosomal protein S13 mRNA | blastn | 30646 | 268 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 24033604 | 24033604 | PRJNA407886_P_NODE_19459_length_583_cov_1.192157_g17780_i0 | PRJNA407886 | 19459 | 583 | 1.192157 | 6.95027531 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 2.28e-115 | NTclustered | gi|2689409129|gb|OR569882.1| | 4793 | g17780 | i0 | 80.589 | 98.9605488850772 | 577 | 95 | 97 | 11 | 1 | 567 | 27 | 596 | Phytophthora citrophthora isolate JP1384 heat shock protein 90 (hsp90) gene, partial cds | blastn | 57694 | 429 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora |
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);;