contig_metadata
14 rows where bioproject = "PRJNA546018", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3061657 | 3061657 | PRJNA546018_S_NODE_20423_length_357_cov_5.513514_g20098_i0 | PRJNA546018 | 20423 | 357 | 5.513514 | 19.68324498 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 634 | 2.6399999999999993e-177 | NTclustered | gi|166046642|emb|CU367759.1| | 100861 | g20098 | i0 | 99.429 | 85.6302521008403 | 350 | 0 | 98 | 2 | 8 | 357 | 82 | 429 | Aphanomyces euteiches cDNA | blastn | 30570 | 634 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 3061716 | 3061716 | PRJNA546018_S_NODE_24363_length_323_cov_249.083969_g24038_i0 | PRJNA546018 | 24363 | 323 | 249.083969 | 804.54121987 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 580 | 3.129999999999999e-161 | NTclustered | gi|325194239|emb|FR825095.1| | 890382 | g24038 | i0 | 99.375 | 103.417956656347 | 320 | 2 | 99 | 0 | 1 | 320 | 928 | 1247 | Albugo laibachii Nc14, genomic contig CONTIG_1625_NC14_v4_1818_619 | blastn | 33404 | 580 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 7497314 | 7497314 | PRJNA546018_S_NODE_26086_length_311_cov_2.788000_g25761_i0 | PRJNA546018 | 26086 | 311 | 2.788 | 8.67068 | root | 1 | Root_unresolved | Root_unresolved | 507 | 5.16e-139 | NTclustered | gi|166046477|emb|CU367594.1| | 100861 | g25761 | i0 | 97.959 | 142.900321543408 | 294 | 2 | 94 | 3 | 3 | 294 | 323 | 614 | Aphanomyces euteiches cDNA | blastn | 44442 | 507 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 8772233 | 8772233 | PRJNA546018_S_NODE_35787_length_259_cov_2.484848_g35462_i0 | PRJNA546018 | 35787 | 259 | 2.484848 | 6.43575632 | root | 1 | Root_unresolved | Root_unresolved | 427 | 3.349999999999999e-115 | NTclustered | gi|166046691|emb|CU367801.1| | 100861 | g35462 | i0 | 100 | 89.3166023166023 | 231 | 0 | 89 | 0 | 22 | 252 | 115 | 345 | Aphanomyces euteiches cDNA | blastn | 23133 | 427 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 9439597 | 9439597 | PRJNA546018_S_NODE_50308_length_213_cov_5.190789_g49983_i0 | PRJNA546018 | 50308 | 213 | 5.190789 | 11.05638057 | Peronospora alsinearum | 162097 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 2.119999999999999e-96 | NTclustered | gi|23306489|gb|AY035472.1| | 162097 | g49983 | i0 | 100 | 92.4882629107981 | 197 | 0 | 92 | 0 | 1 | 197 | 263 | 67 | Peronospora alsinearum isolate HV 6a large subunit ribosomal RNA gene, partial sequence | blastn | 19700 | 364 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora alsinearum | ||
| 10047648 | 10047648 | PRJNA546018_S_NODE_32108_length_276_cov_1.446512_g31783_i0 | PRJNA546018 | 32108 | 276 | 1.446512 | 3.99237312 | root | 1 | Root_unresolved | Root_unresolved | 490 | 4.54e-134 | NTclustered | gi|166044625|emb|CU367534.1| | 100861 | g31783 | i0 | 100 | 33.4275362318841 | 265 | 0 | 96 | 0 | 10 | 274 | 238 | 502 | Aphanomyces euteiches cDNA | blastn | 9226 | 490 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 10047738 | 10047738 | PRJNA546018_S_NODE_49388_length_216_cov_1.329032_g49063_i0 | PRJNA546018 | 49388 | 216 | 1.329032 | 2.87070912 | root | 1 | Root_unresolved | Root_unresolved | 364 | 2.16e-96 | NTclustered | gi|166046726|emb|CU367836.1| | 100861 | g49063 | i0 | 99.502 | 36.1481481481481 | 201 | 0 | 93 | 1 | 1 | 201 | 291 | 92 | Aphanomyces euteiches cDNA | blastn | 7808 | 364 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 12598101 | 12598101 | PRJNA546018_S_NODE_13830_length_450_cov_3.401028_g13505_i0 | PRJNA546018 | 13830 | 450 | 3.401028 | 15.304626 | root | 1 | Root_unresolved | Root_unresolved | 815 | 0 | NTclustered | gi|166046649|emb|CU367766.1| | 100861 | g13505 | i0 | 99.554 | 99.8977777777778 | 448 | 1 | 99 | 1 | 1 | 448 | 768 | 322 | Aphanomyces euteiches cDNA | blastn | 44954 | 815 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 13264480 | 13264480 | PRJNA546018_S_NODE_14371_length_440_cov_1.846966_g14046_i0 | PRJNA546018 | 14371 | 440 | 1.846966 | 8.1266504 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 802 | 0 | NTclustered | gi|166046588|emb|CU367705.1| | 100861 | g14046 | i0 | 99.545 | 54.6136363636364 | 440 | 2 | 100 | 0 | 1 | 440 | 77 | 516 | Aphanomyces euteiches cDNA | blastn | 24030 | 802 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 16421981 | 16421981 | PRJNA546018_S_NODE_30493_length_284_cov_2.282511_g30168_i0 | PRJNA546018 | 30493 | 284 | 2.282511 | 6.48233124 | root | 1 | Root_unresolved | Root_unresolved | 438 | 1.7199999999999995e-118 | NTclustered | gi|166044479|emb|CU367388.1| | 100861 | g30168 | i0 | 99.583 | 89.2640845070423 | 240 | 1 | 85 | 0 | 23 | 262 | 418 | 179 | Aphanomyces euteiches cDNA | blastn | 25351 | 438 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 18362709 | 18362709 | PRJNA546018_S_NODE_44535_length_229_cov_2.267857_g44210_i0 | PRJNA546018 | 44535 | 229 | 2.267857 | 5.19339253 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 8.309999999999999e-96 | NTclustered | gi|325193895|emb|FR824859.1| | 890382 | g44210 | i0 | 98.077 | 0.908296943231441 | 208 | 4 | 91 | 0 | 22 | 229 | 2547 | 2754 | Albugo laibachii Nc14, genomic contig CONTIG_1064_NC14_v4_3734_133 | blastn | 208 | 363 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 21521247 | 21521247 | PRJNA546018_S_NODE_27897_length_299_cov_2.852941_g27572_i0 | PRJNA546018 | 27897 | 299 | 2.852941 | 8.53029359 | Hyaloperonospora | 184462 | SAR_Eukaryotes | SAR_Eukaryotes | 553 | 6.25e-153 | NTclustered | gi|158519366|gb|EU054926.1| | 123356 | g27572 | i0 | 100 | 93.9130434782609 | 299 | 0 | 100 | 0 | 1 | 299 | 317 | 19 | Hyaloperonospora parasitica strain GG156 (MA) large subunit ribosomal RNA gene, partial sequence | blastn | 28080 | 553 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Hyaloperonospora | Hyaloperonospora parasitica | ||
| 21521300 | 21521300 | PRJNA546018_S_NODE_37297_length_253_cov_2.932292_g36972_i0 | PRJNA546018 | 37297 | 253 | 2.932292 | 7.41869876 | root | 1 | Root_unresolved | Root_unresolved | 468 | 1.92e-127 | NTclustered | gi|166046619|emb|CU367736.1| | 100861 | g36972 | i0 | 100 | 99.9920948616601 | 253 | 0 | 100 | 0 | 1 | 253 | 115 | 367 | Aphanomyces euteiches cDNA | blastn | 25298 | 468 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 24071320 | 24071320 | PRJNA546018_S_NODE_7659_length_641_cov_5.879310_g7355_i0 | PRJNA546018 | 7659 | 641 | 5.87931 | 37.6863771 | root | 1 | Root_unresolved | Root_unresolved | 1077 | 0 | NTclustered | gi|166044488|emb|CU367397.1| | 100861 | g7355 | i0 | 99.661 | 93.1716068642746 | 590 | 1 | 97 | 1 | 23 | 612 | 784 | 196 | Aphanomyces euteiches cDNA | blastn | 59723 | 1083 | 0.994459833795014 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;