contig_metadata
6 rows where bioproject = "PRJNA1047551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4837911 | 4837911 | PRJNA1047551_S_NODE_8164_length_181_cov_1.178082_g8037_i0 | PRJNA1047551 | 8164 | 181 | 1.178082 | 2.13232842 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 1.16e-23 | NTclustered | gi|23394349|gb|AF424640.1| | 4787 | g8037 | i0 | 91.111 | 32.3204419889503 | 90 | 8 | 50 | 0 | 92 | 181 | 734 | 645 | Phytophthora infestans clone MY-01-D-08 14-3-3-like protein mRNA, complete cds | blastn | 5850 | 122 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 14203412 | 14203412 | PRJNA1047551_S_NODE_7712_length_184_cov_1.731544_g7585_i0 | PRJNA1047551 | 7712 | 184 | 1.731544 | 3.18604096 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 1.65e-27 | NR | RHY32007.1 | 157072 | g7585 | i0 | 82 | 2.98369565217391 | 61 | 11 | 99.5 | 0 | 2 | 184 | 313 | 373 | RHY32007.1 hypothetical protein DYB32_002977 [Aphanomyces invadans] | diamond | 549 | 111 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 19300232 | 19300232 | PRJNA1047551_S_NODE_10016_length_168_cov_1.323308_g9889_i0 | PRJNA1047551 | 10016 | 168 | 1.323308 | 2.22315744 | Bremia lactucae | 4779 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 4.66e-62 | NTclustered | gi|2794733310|ref|XM_067963730.1| | 4779 | g9889 | i0 | 93.452 | 2 | 168 | 11 | 100 | 0 | 1 | 168 | 3184 | 3017 | Bremia lactucae uncharacterized protein (CCR75_005652), mRNA | blastn | 336 | 250 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 20575675 | 20575675 | PRJNA1047551_S_NODE_3337_length_255_cov_1.650000_g3210_i0 | PRJNA1047551 | 3337 | 255 | 1.65 | 4.2075 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 6.98e-127 | NTclustered | gi|325193589|emb|FR824715.1| | 890382 | g3210 | i0 | 99.608 | 43.043137254902 | 255 | 1 | 100 | 0 | 1 | 255 | 1189 | 1443 | Albugo laibachii Nc14, genomic contig CONTIG_781_NC14_v4_6138_160 | blastn | 10976 | 466 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 27785569 | 27785569 | PRJNA1047551_S_NODE_7204_length_189_cov_1.110390_g7077_i0 | PRJNA1047551 | 7204 | 189 | 1.11039 | 2.0986371 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 2.63e-8 | NR | XP_067814741.1 | 4779 | g7077 | i0 | 50 | 14.3015873015873 | 56 | 23 | 88.9 | 1 | 174 | 7 | 419 | 469 | XP_067814741.1 uncharacterized protein CCR75_006060 [Bremia lactucae] | diamond | 2703 | 59.3 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 30943610 | 30943610 | PRJNA1047551_S_NODE_2174_length_306_cov_4.848708_g2047_i0 | PRJNA1047551 | 2174 | 306 | 4.848708 | 14.83704648 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 1.46e-12 | NR | KAF0750018.1 | 112090 | g2047 | i0 | 66.7 | 1.76470588235294 | 45 | 15 | 44.1 | 0 | 301 | 167 | 65 | 109 | KAF0750018.1 hypothetical protein AaE_006855, partial [Aphanomyces astaci] | diamond | 540 | 69.3 | 0.994227994227994 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci |
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);;