contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1102048" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2762420 | 2762420 | PRJNA1102048_P_NODE_15443_length_245_cov_1.750000_g15339_i0 | PRJNA1102048 | 15443 | 245 | 1.75 | 4.2875 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 87.9 | 6.06e-13 | NTclustered | gi|695406607|ref|XM_009525859.1| | 67593 | g15339 | i0 | 85.714 | 2.86938775510204 | 84 | 10 | 34 | 2 | 162 | 244 | 541 | 459 | Phytophthora sojae hypothetical protein mRNA | blastn | 703 | 87.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 6589760 | 6589760 | PRJNA1102048_P_NODE_1126_length_707_cov_2.219243_g1030_i0 | PRJNA1102048 | 1126 | 707 | 2.219243 | 15.69004801 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 1.77e-77 | NTclustered | gi|669146817|ref|XM_008610749.1| | 1156394 | g1030 | i0 | 79.185 | 7.90947666195191 | 466 | 75 | 65 | 15 | 72 | 532 | 621 | 173 | Saprolegnia diclina VS20 40S ribosomal protein S8 mRNA | blastn | 5592 | 303 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 6589794 | 6589794 | PRJNA1102048_P_NODE_15006_length_246_cov_0.971098_g14902_i0 | PRJNA1102048 | 15006 | 246 | 0.971098 | 2.38890108 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.11e-37 | NTclustered | gi|673021649|ref|XM_008866564.1| | 157072 | g14902 | i0 | 79.675 | 15.6219512195122 | 246 | 40 | 99 | 7 | 3 | 246 | 1185 | 948 | Aphanomyces invadans hypothetical protein partial mRNA | blastn | 3843 | 169 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 7864475 | 7864475 | PRJNA1102048_P_NODE_4547_length_400_cov_2.688073_g4443_i0 | PRJNA1102048 | 4547 | 400 | 2.688073 | 10.752292 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 1.23e-81 | NTclustered | gi|695447497|ref|XM_009536456.1| | 67593 | g4443 | i0 | 81.627 | 75.5925 | 381 | 70 | 95 | 0 | 19 | 399 | 1676 | 2056 | Phytophthora sojae hypothetical protein mRNA | blastn | 30237 | 316 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 7864492 | 7864492 | PRJNA1102048_P_NODE_6907_length_329_cov_2.402344_g6803_i0 | PRJNA1102048 | 6907 | 329 | 2.402344 | 7.90371176 | Phytophthora capsici | 4784 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 6.24e-49 | NTclustered | gi|189083887|gb|BT031403.1| | 4784 | g6803 | i0 | 84.434 | 55.1550151975684 | 212 | 31 | 64 | 2 | 1 | 211 | 352 | 142 | Phytophthora capsici clone CBOT69-P12 mRNA sequence | blastn | 18146 | 207 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 10415188 | 10415188 | PRJNA1102048_P_NODE_8249_length_303_cov_1.334783_g8145_i0 | PRJNA1102048 | 8249 | 303 | 1.334783 | 4.04439249 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 9.66e-37 | NTclustered | gi|166035705|emb|CU351918.1| | 100861 | g8145 | i0 | 77.133 | 36.4191419141914 | 293 | 63 | 96 | 4 | 12 | 302 | 539 | 249 | Aphanomyces euteiches cDNA | blastn | 11035 | 167 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 14240505 | 14240505 | PRJNA1102048_P_NODE_2512_length_522_cov_39.576837_g2408_i0 | PRJNA1102048 | 2512 | 522 | 39.576837 | 206.59108914 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 5.9999999999999995e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g2408 | i0 | 80.533 | 64.8045977011494 | 375 | 65 | 70 | 4 | 29 | 396 | 68 | 441 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 16788899 | 16788899 | PRJNA1102048_P_NODE_5454_length_369_cov_1.016892_g5350_i0 | PRJNA1102048 | 5454 | 369 | 1.016892 | 3.75233148 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 2.05e-19 | NTclustered | gi|813192155|ref|XM_012352570.1| | 695850 | g5350 | i0 | 76.549 | 0.994579945799458 | 226 | 37 | 58 | 13 | 134 | 348 | 1042 | 822 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 367 | 110 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 18063496 | 18063496 | PRJNA1102048_P_NODE_7635_length_314_cov_10.609959_g7531_i0 | PRJNA1102048 | 7635 | 314 | 10.609959 | 33.31527126 | Achlya bisexualis | 4766 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 9.64e-67 | NTclustered | gi|2289|emb|X59936.1| | 4766 | g7531 | i0 | 87.179 | 72.343949044586 | 234 | 30 | 75 | 0 | 81 | 314 | 1 | 234 | A.bisexualis gene for actin | blastn | 22716 | 267 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya bisexualis | ||
| 19337470 | 19337470 | PRJNA1102048_P_NODE_10816_length_269_cov_1.571429_g10712_i0 | PRJNA1102048 | 10816 | 269 | 1.571429 | 4.22714401 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 3.9e-40 | NTclustered | gi|2794930130|ref|XM_067885621.1| | 164328 | g10712 | i0 | 83.163 | 21.4237918215613 | 196 | 31 | 72 | 2 | 71 | 265 | 46 | 240 | Phytophthora ramorum putative small nuclear ribonucleoprotein Sm D2 (KRP23_14762), partial mRNA | blastn | 5763 | 178 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 19337507 | 19337507 | PRJNA1102048_P_NODE_14336_length_248_cov_0.880000_g14232_i0 | PRJNA1102048 | 14336 | 248 | 0.88 | 2.1824 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 4.489999999999999e-54 | NTclustered | gi|675185260|ref|XM_008903267.1| | 761204 | g14232 | i0 | 84.513 | 3.23790322580645 | 226 | 35 | 91 | 0 | 9 | 234 | 612 | 387 | Phytophthora parasitica INRA-310 pyridoxal biosynthesis lyase pdxS mRNA | blastn | 803 | 224 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 19337569 | 19337569 | PRJNA1102048_P_NODE_6616_length_336_cov_1.612167_g6512_i0 | PRJNA1102048 | 6616 | 336 | 1.612167 | 5.41688112 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 6.13e-79 | NTclustered | gi|2794923360|ref|XM_067881981.1| | 164328 | g6512 | i0 | 93.269 | 62.3541666666667 | 208 | 14 | 62 | 0 | 129 | 336 | 450 | 243 | Phytophthora ramorum Calmodulin (KRP23_11430), partial mRNA | blastn | 20951 | 307 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 21888527 | 21888527 | PRJNA1102048_P_NODE_14178_length_248_cov_0.880000_g14074_i0 | PRJNA1102048 | 14178 | 248 | 0.88 | 2.1824 | Pythium sp. CHE-287 | 480030 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 2.06e-62 | NTclustered | gi|158905788|gb|EU199087.1| | 480030 | g14074 | i0 | 85.214 | 97.6370967741936 | 257 | 24 | 99 | 12 | 2 | 248 | 267 | 15 | Pythium sp. CHE-287 translation elongation factor 1 alpha gene, partial cds | blastn | 24214 | 252 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium sp. CHE-287 | ||
| 21888613 | 21888613 | PRJNA1102048_P_NODE_6238_length_345_cov_2.150735_g6134_i0 | PRJNA1102048 | 6238 | 345 | 2.150735 | 7.42003575 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 4.98e-65 | NTclustered | gi|2795024423|ref|XM_067938288.1| | 4785 | g6134 | i0 | 81.481 | 77.5449275362319 | 324 | 54 | 93 | 6 | 3 | 323 | 1 | 321 | Phytophthora cinnamomi 60S ribosomal protein (IUM83_13598), partial mRNA | blastn | 26753 | 261 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 23164076 | 23164076 | PRJNA1102048_P_NODE_5499_length_367_cov_1.785714_g5395_i0 | PRJNA1102048 | 5499 | 367 | 1.785714 | 6.55357038 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 2.51e-53 | NTclustered | gi|813184507|ref|XM_012351036.1| | 695850 | g5395 | i0 | 87.065 | 23.9673024523161 | 201 | 20 | 54 | 4 | 122 | 319 | 336 | 139 | Saprolegnia parasitica CBS 223.65 40S ribosomal protein mRNA | blastn | 8796 | 222 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 24437628 | 24437628 | PRJNA1102048_P_NODE_16480_length_243_cov_1.064706_g16376_i0 | PRJNA1102048 | 16480 | 243 | 1.064706 | 2.58723558 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 7.289999999999999e-57 | NTclustered | gi|813138583|ref|XM_012343405.1| | 695850 | g16376 | i0 | 85.65 | 15.0123456790123 | 223 | 30 | 91 | 2 | 11 | 232 | 751 | 530 | Saprolegnia parasitica CBS 223.65 tubulin alpha chain mRNA | blastn | 3648 | 233 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 25246364 | 25246364 | PRJNA1102048_P_NODE_4160_length_418_cov_2.028986_g4056_i0 | PRJNA1102048 | 4160 | 418 | 2.028986 | 8.48116148 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 2.8199999999999996e-73 | NTclustered | gi|23394400|gb|AF424664.1| | 4787 | g4056 | i0 | 80.256 | 93.4545454545455 | 390 | 71 | 93 | 5 | 10 | 396 | 464 | 78 | Phytophthora infestans clone MY-11-B-09 S-adenosyl methionine synthetase mRNA, complete cds | blastn | 39064 | 289 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans |
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);;