contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA431371" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 428268 | 428268 | PRJNA431371_P_NODE_26361_length_250_cov_0.870056_g26288_i0 | PRJNA431371 | 26361 | 250 | 0.870056 | 2.17514 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 4.63e-39 | NTclustered | gi|695394000|ref|XM_009522467.1| | 67593 | g26288 | i0 | 86.25 | 1.248 | 160 | 22 | 64 | 0 | 42 | 201 | 298 | 457 | Phytophthora sojae hypothetical protein mRNA | blastn | 312 | 174 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 428375 | 428375 | PRJNA431371_P_NODE_3101_length_639_cov_1.360424_g3028_i0 | PRJNA431371 | 3101 | 639 | 1.360424 | 8.69310936 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 2.08e-66 | NTclustered | gi|2795049948|ref|XM_067938671.1| | 4785 | g3028 | i0 | 80 | 13.2472613458529 | 365 | 69 | 57 | 4 | 272 | 634 | 543 | 181 | Phytophthora cinnamomi S-phase kinase-associated protein 1A (IUM83_13963), partial mRNA | blastn | 8465 | 267 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 1703415 | 1703415 | PRJNA431371_P_NODE_6502_length_478_cov_1.520988_g6429_i0 | PRJNA431371 | 6502 | 478 | 1.520988 | 7.27032264 | Phytophthora asparagi | 631358 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 9.52e-39 | NTclustered | gi|2314988779|ref|NC_067069.1| | 631358 | g6429 | i0 | 81.25 | 3.16317991631799 | 224 | 34 | 46 | 5 | 259 | 478 | 12242 | 12461 | Phytophthora asparagi voucher CBS132095 mitochondrion, complete genome | blastn | 1512 | 174 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora asparagi | ||
| 2363425 | 2363425 | PRJNA431371_P_NODE_20222_length_284_cov_1.701422_g20149_i0 | PRJNA431371 | 20222 | 284 | 1.701422 | 4.83203848 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 1.4199999999999999e-74 | NTclustered | gi|2248513440|ref|NC_063805.1| | 4781 | g20149 | i0 | 86.792 | 96.169014084507 | 265 | 31 | 93 | 4 | 4 | 266 | 2448 | 2186 | Plasmopara halstedii isolate 710 mitochondrion, complete genome | blastn | 27312 | 292 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 5531611 | 5531611 | PRJNA431371_P_NODE_1185_length_886_cov_5.220172_g1123_i0 | PRJNA431371 | 1185 | 886 | 5.220172 | 46.25072392 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 2.2199999999999995e-82 | NTclustered | gi|2795019585|ref|XM_067931629.1| | 4785 | g1123 | i0 | 81.39 | 35.5914221218962 | 403 | 65 | 45 | 8 | 78 | 475 | 14 | 411 | Phytophthora cinnamomi peptidyl-prolyl cis-trans isomerase (IUM83_07343), partial mRNA | blastn | 31534 | 320 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 5531855 | 5531855 | PRJNA431371_P_NODE_22265_length_269_cov_1.964286_g22192_i0 | PRJNA431371 | 22265 | 269 | 1.964286 | 5.28392934 | Halophytophthora thermoambigua | 2874305 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 3.03e-36 | NTclustered | gi|2213903340|gb|OK091352.1| | 2874305 | g22192 | i0 | 79.835 | 83.7843866171004 | 243 | 35 | 88 | 9 | 12 | 247 | 528 | 293 | Halophytophthora sp. MHJ-2021h isolate BD630 from Portugal heat shock protein 90 (hsp90) gene, partial cds | blastn | 22538 | 165 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Halophytophthora | Halophytophthora thermoambigua | ||
| 6805858 | 6805858 | PRJNA431371_P_NODE_19206_length_292_cov_1.054795_g19133_i0 | PRJNA431371 | 19206 | 292 | 1.054795 | 3.0800014 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 3.4e-21 | NTclustered | gi|2794905809|ref|XM_067889902.1| | 164328 | g19133 | i0 | 89.13 | 25.6301369863014 | 92 | 10 | 32 | 0 | 8 | 99 | 215 | 306 | Phytophthora ramorum 13 kDa ribonucleoprotein-associated protein (KRP23_4892), partial mRNA | blastn | 7484 | 115 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 8081529 | 8081529 | PRJNA431371_P_NODE_25907_length_250_cov_0.870056_g25834_i0 | PRJNA431371 | 25907 | 250 | 0.870056 | 2.17514 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 5.99e-38 | NTclustered | gi|669166303|ref|XM_008620492.1| | 1156394 | g25834 | i0 | 80.93 | 17.124 | 215 | 41 | 86 | 0 | 4 | 218 | 317 | 103 | Saprolegnia diclina VS20 ribonucleoprotein-associated protein mRNA | blastn | 4281 | 171 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 10632298 | 10632298 | PRJNA431371_P_NODE_329_length_1325_cov_2.606230_g282_i0 | PRJNA431371 | 329 | 1325 | 2.60623 | 34.5325475 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 632 | 3.8099999999999985e-176 | NTclustered | gi|166044823|emb|CU351082.1| | 100861 | g282 | i0 | 80.404 | 28.457358490566 | 842 | 155 | 63 | 9 | 253 | 1089 | 84 | 920 | Aphanomyces euteiches cDNA | blastn | 37706 | 632 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 11906802 | 11906802 | PRJNA431371_P_NODE_16230_length_318_cov_2.412245_g16157_i0 | PRJNA431371 | 16230 | 318 | 2.412245 | 7.6709391 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.67e-49 | NTclustered | gi|813207114|ref|XM_012354790.1| | 695850 | g16157 | i0 | 82.979 | 12.0534591194969 | 235 | 36 | 73 | 4 | 61 | 293 | 432 | 200 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein partial mRNA | blastn | 3833 | 209 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 13181814 | 13181814 | PRJNA431371_P_NODE_18871_length_294_cov_3.361991_g18798_i0 | PRJNA431371 | 18871 | 294 | 3.361991 | 9.88425354 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 4.16e-65 | NTclustered | gi|9858457|gb|AF085344.1|AF085344 | 82926 | g18798 | i0 | 89.1 | 43.2312925170068 | 211 | 22 | 72 | 1 | 3 | 213 | 274 | 483 | Pythium splendens calmodulin mRNA, complete cds | blastn | 12710 | 261 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 13182114 | 13182114 | PRJNA431371_P_NODE_3471_length_613_cov_1.424074_g3398_i0 | PRJNA431371 | 3471 | 613 | 1.424074 | 8.72957362 | Phytophthora sumatera | 3073786 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 3.53e-24 | NTclustered | gi|2689407522|gb|OR549606.1| | 3073786 | g3398 | i0 | 78.462 | 11.7879282218597 | 195 | 40 | 32 | 2 | 355 | 548 | 649 | 456 | Phytophthora sumatera isolate JV146 cytochrome oxidase subunit II (cox2) gene, partial cds; hypothetical protein (orf32) gene, complete cds; and cytochrome oxidase subunit I (cox1) gene, partial cds; mitochondrial | blastn | 7226 | 126 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sumatera | ||
| 13182191 | 13182191 | PRJNA431371_P_NODE_4991_length_533_cov_2.676087_g4918_i0 | PRJNA431371 | 4991 | 533 | 2.676087 | 14.26354371 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 6.13e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g4918 | i0 | 80.533 | 63.4652908067542 | 375 | 65 | 69 | 4 | 25 | 392 | 68 | 441 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33827 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 20829620 | 20829620 | PRJNA431371_P_NODE_12017_length_363_cov_4.893103_g11944_i0 | PRJNA431371 | 12017 | 363 | 4.893103 | 17.76196389 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|695467473|ref|XM_009541341.1| | 67593 | g11944 | i0 | 100 | 0.165289256198347 | 30 | 0 | 8 | 0 | 129 | 158 | 2872 | 2843 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 60 | 56.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 23380197 | 23380197 | PRJNA431371_P_NODE_16079_length_320_cov_1.246964_g16006_i0 | PRJNA431371 | 16079 | 320 | 1.246964 | 3.9902848 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 2.26e-23 | NTclustered | gi|675206244|ref|XM_008913759.1| | 761204 | g16006 | i0 | 87.619 | 8.946875 | 105 | 13 | 33 | 0 | 213 | 317 | 522 | 418 | Phytophthora parasitica INRA-310 60S ribosomal protein L11 mRNA | blastn | 2863 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae |
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);;