contig_metadata
12 rows where bioproject = "PRJNA669701", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1911879 | 1911879 | PRJNA669701_P_NODE_36722_length_389_cov_2.702532_g36327_i0 | PRJNA669701 | 36722 | 389 | 2.702532 | 10.51284948 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 9.36e-73 | NTclustered | gi|9858457|gb|AF085344.1|AF085344 | 82926 | g36327 | i0 | 79.949 | 66.2082262210797 | 389 | 78 | 100 | 0 | 1 | 389 | 66 | 454 | Pythium splendens calmodulin mRNA, complete cds | blastn | 25755 | 287 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 3715413 | 3715413 | PRJNA669701_P_NODE_103983_length_254_cov_3.027624_g103588_i0 | PRJNA669701 | 103983 | 254 | 3.027624 | 7.69016496 | root | 1 | Root_unresolved | Root_unresolved | 470 | 5.37e-128 | NTclustered | gi|354801984|gb|JN113287.1| | 4787 | g103588 | i0 | 100 | 100 | 254 | 0 | 100 | 0 | 1 | 254 | 6326 | 6073 | Phytophthora infestans transgenic clone Cu24_cyc_6_R1 retrotransposon gypsy-like, complete sequence; hygromycin phosphotransferase gene, complete cds; and retrotransposons gypsy-like, complete sequence | blastn | 25400 | 470 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 7013871 | 7013871 | PRJNA669701_P_NODE_133606_length_243_cov_1.670588_g133211_i0 | PRJNA669701 | 133606 | 243 | 1.670588 | 4.05952884 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 1.27e-38 | NR | DAZ97811.1 | 4803 | g133211 | i0 | 78.8 | 10.8641975308642 | 80 | 17 | 98.8 | 0 | 243 | 4 | 271 | 350 | DAZ97811.1 TPA: hypothetical protein N0F65_002481 [Lagenidium giganteum] | diamond | 2640 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 14665251 | 14665251 | PRJNA669701_P_NODE_80912_length_281_cov_1.134615_g80517_i0 | PRJNA669701 | 80912 | 281 | 1.134615 | 3.18826815 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 6.9e-33 | NTclustered | gi|673024575|ref|XM_008868027.1| | 157072 | g80517 | i0 | 85.235 | 44.0818505338078 | 149 | 22 | 53 | 0 | 2 | 150 | 2257 | 2405 | Aphanomyces invadans tubulin beta chain mRNA | blastn | 12387 | 154 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 22313423 | 22313423 | PRJNA669701_P_NODE_66558_length_302_cov_4.484716_g66163_i0 | PRJNA669701 | 66558 | 302 | 4.484716 | 13.54384232 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 1.53e-69 | NTclustered | gi|695460914|ref|XM_009539807.1| | 67593 | g66163 | i0 | 85.824 | 86.9635761589404 | 261 | 35 | 86 | 2 | 35 | 294 | 358 | 99 | Phytophthora sojae hypothetical protein mRNA | blastn | 26263 | 276 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 23588794 | 23588794 | PRJNA669701_P_NODE_56679_length_322_cov_2.365462_g56284_i0 | PRJNA669701 | 56679 | 322 | 2.365462 | 7.61678764 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 173 | 1.2399999999999998e-47 | NR | XP_008610586.1 | 1156394 | g56284 | i0 | 76.6 | 2.99068322981366 | 107 | 25 | 99.7 | 0 | 2 | 322 | 5 | 111 | XP_008610586.1 hypothetical protein SDRG_06578 [Saprolegnia diclina VS20] | diamond | 963 | 173 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 26765168 | 26765168 | PRJNA669701_P_NODE_95461_length_264_cov_1.287958_g95066_i0 | PRJNA669701 | 95461 | 264 | 1.287958 | 3.40020912 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 1.08e-5 | NR | CCI46784.1 | 65357 | g95066 | i0 | 40.7 | 1.22727272727273 | 54 | 32 | 61.4 | 0 | 68 | 229 | 87 | 140 | CCI46784.1 unnamed protein product [Albugo candida] | diamond | 324 | 51.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 29481269 | 29481269 | PRJNA669701_P_NODE_53150_length_331_cov_2.631783_g52755_i0 | PRJNA669701 | 53150 | 331 | 2.631783 | 8.71120173 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 1.16e-10 | NR | XP_009834982.1 | 112090 | g52755 | i0 | 37.2 | 2.58308157099698 | 86 | 46 | 70.7 | 3 | 3 | 236 | 365 | 450 | XP_009834982.1 hypothetical protein H257_10209 [Aphanomyces astaci] | diamond | 855 | 68.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 29714255 | 29714255 | PRJNA669701_P_NODE_75350_length_287_cov_3.546729_g74955_i0 | PRJNA669701 | 75350 | 287 | 3.546729 | 10.17911223 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 3.23e-30 | NR | KAJ0412157.1 | 114742 | g74955 | i0 | 67.5 | 15.3031358885017 | 83 | 26 | 86.8 | 1 | 285 | 37 | 621 | 702 | KAJ0412157.1 hypothetical protein ATCC90586_005770 [Pythium insidiosum] | diamond | 4392 | 123 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 30883503 | 30883503 | PRJNA669701_P_NODE_88294_length_272_cov_1.537688_g87899_i0 | PRJNA669701 | 88294 | 272 | 1.537688 | 4.18251136 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 2.94e-41 | NR | CCI45708.1 | 65357 | g87899 | i0 | 75 | 7.45588235294118 | 88 | 22 | 97.1 | 0 | 270 | 7 | 1 | 88 | CCI45708.1 unnamed protein product [Albugo candida] | diamond | 2028 | 141 | 0.99290780141844 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 31389400 | 31389400 | PRJNA669701_P_NODE_18556_length_547_cov_2.251055_g18163_i0 | PRJNA669701 | 18556 | 547 | 2.251055 | 12.31327085 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 2.98e-6 | NR | XP_067814297.1 | 4779 | g18163 | i0 | 28.3 | 3.21389396709324 | 145 | 88 | 70.7 | 4 | 489 | 103 | 277 | 421 | XP_067814297.1 uncharacterized protein CCR75_002132 [Bremia lactucae] | diamond | 1758 | 58.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 31958534 | 31958534 | PRJNA669701_P_NODE_134177_length_243_cov_0.905882_g133782_i0 | PRJNA669701 | 134177 | 243 | 0.905882 | 2.20129326 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 1.92e-18 | NR | XP_024578065.1 | 4781 | g133782 | i0 | 62.3 | 25.5555555555556 | 77 | 14 | 95.1 | 1 | 3 | 233 | 490 | 551 | XP_024578065.1 heat shock protein 90 [Plasmopara halstedii] | diamond | 6210 | 89 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii |
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);;