contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA493632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1104079 | 1104079 | PRJNA493632_P_NODE_708041_length_222_cov_6.375839_g704600_i0 | PRJNA493632 | 708041 | 222 | 6.375839 | 14.15436258 | Peronospora | 70742 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 6.37e-77 | NTclustered | gi|1663822467|gb|MH730839.1| | 120572 | g704600 | i0 | 98.246 | 101.022522522523 | 171 | 3 | 100 | 0 | 1 | 171 | 874 | 1044 | Peronospora bulbocapni voucher GLM64102 28S ribosomal RNA gene, partial sequence | blastn | 22427 | 300 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora bulbocapni | ||
| 2377692 | 2377692 | PRJNA493632_P_NODE_369342_length_278_cov_14.107317_g365903_i0 | PRJNA493632 | 369342 | 278 | 14.107317 | 39.21834126 | Salisapilia | 983658 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 3.1099999999999998e-46 | NTclustered | gi|1244022750|gb|MF979505.1| | 758748 | g365903 | i0 | 89.241 | 55.2158273381295 | 158 | 17 | 57 | 0 | 4 | 161 | 638 | 481 | Salisapilia elongata strain NBRC 100786 large subunit ribosomal RNA gene, partial sequence | blastn | 15350 | 198 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Salisapiliaceae | Salisapilia | Salisapilia elongata | ||
| 6207517 | 6207517 | PRJNA493632_P_NODE_716365_length_214_cov_4.730496_g712923_i0 | PRJNA493632 | 716365 | 214 | 4.730496 | 10.12326144 | Pseudoperonospora | 143452 | SAR_Eukaryotes | SAR_Eukaryotes | 390 | 3.519999999999999e-104 | NTclustered | gi|33520221|gb|AY273966.1| | 162119 | g712923 | i0 | 99.533 | 99.9532710280374 | 214 | 1 | 100 | 0 | 1 | 214 | 265 | 52 | Pseudoperonospora urticae large subunit ribosomal RNA gene, partial sequence | blastn | 21390 | 390 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Pseudoperonospora | Pseudoperonospora urticae | ||
| 6845988 | 6845988 | PRJNA493632_P_NODE_697686_length_228_cov_2.993548_g694245_i0 | PRJNA493632 | 697686 | 228 | 2.993548 | 6.82528944 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 6.9599999999999994e-37 | NTclustered | gi|325195094|emb|FR825888.1| | 890382 | g694245 | i0 | 92.308 | 0.513157894736842 | 117 | 9 | 51 | 0 | 112 | 228 | 6 | 122 | Albugo laibachii Nc14, genomic contig CONTIG_2935_NC14_v4_521_59 | blastn | 117 | 167 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 9391857 | 9391857 | PRJNA493632_P_NODE_437428_length_264_cov_2.376963_g433989_i0 | PRJNA493632 | 437428 | 264 | 2.376963 | 6.27518232 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 433 | 7.37e-117 | NTclustered | gi|813199071|ref|XR_001099870.1| | 695850 | g433989 | i0 | 96.212 | 102.25 | 264 | 10 | 100 | 0 | 1 | 264 | 1013 | 750 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 26994 | 433 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 11307004 | 11307004 | PRJNA493632_P_NODE_656269_length_241_cov_0.916667_g652828_i0 | PRJNA493632 | 656269 | 241 | 0.916667 | 2.20916747 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2308292368|gb|OK574295.1| | 29920 | g652828 | i0 | 96.875 | 1.19502074688797 | 32 | 1 | 13 | 0 | 1 | 32 | 22176 | 22207 | Phytophthora cactorum voucher CH9812411 mitochondrion, complete genome | blastn | 288 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 14486955 | 14486955 | PRJNA493632_P_NODE_118772_length_424_cov_1.350427_g115361_i0 | PRJNA493632 | 118772 | 424 | 1.350427 | 5.72581048 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 723 | 0 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g115361 | i0 | 97.412 | 1.72641509433962 | 425 | 10 | 100 | 1 | 1 | 424 | 1411 | 987 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 732 | 723 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 15769067 | 15769067 | PRJNA493632_P_NODE_583673_length_246_cov_0.890173_g580232_i0 | PRJNA493632 | 583673 | 246 | 0.890173 | 2.18982558 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 3.39e-65 | NTclustered | gi|145843803|gb|EF564000.1| | 67593 | g580232 | i0 | 85.83 | 6.75609756097561 | 247 | 33 | 100 | 2 | 1 | 246 | 2212 | 2457 | Phytophthora sojae cellulose synthase 4 (CES4) gene, complete cds | blastn | 1662 | 261 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 18317041 | 18317041 | PRJNA493632_P_NODE_523095_length_250_cov_0.870056_g519656_i0 | PRJNA493632 | 523095 | 250 | 0.870056 | 2.17514 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 7.799999999999999e-32 | NTclustered | gi|695405840|ref|XM_009525641.1| | 67593 | g519656 | i0 | 79.279 | 3.276 | 222 | 40 | 88 | 5 | 32 | 250 | 402 | 184 | Phytophthora sojae hypothetical protein mRNA | blastn | 819 | 150 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 20229911 | 20229911 | PRJNA493632_P_NODE_573976_length_246_cov_8.849711_g570535_i0 | PRJNA493632 | 573976 | 246 | 8.849711 | 21.77028906 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.2399999999999997e-54 | NTclustered | gi|33520221|gb|AY273966.1| | 162119 | g570535 | i0 | 84.016 | 99.260162601626 | 244 | 29 | 96 | 9 | 1 | 235 | 58 | 300 | Pseudoperonospora urticae large subunit ribosomal RNA gene, partial sequence | blastn | 24418 | 226 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Pseudoperonospora | Pseudoperonospora urticae | ||
| 20860736 | 20860736 | PRJNA493632_P_NODE_172857_length_365_cov_3.037671_g169429_i0 | PRJNA493632 | 172857 | 365 | 3.037671 | 11.08749915 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 1.14e-66 | NTclustered | gi|695467116|ref|XM_009541261.1| | 67593 | g169429 | i0 | 98.675 | 1.94246575342466 | 151 | 0 | 60 | 1 | 215 | 365 | 81 | 229 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 709 | 267 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae |
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);;