contig_metadata
12 rows where bioproject = "PRJNA1249535" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6734798 | 6734798 | PRJNA1249535_S_NODE_251366_length_279_cov_3.024272_g247983_i0 | PRJNA1249535 | 251366 | 279 | 3.024272 | 8.43771888 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|325187216|emb|FR824178.1| | 890382 | g247983 | i0 | 100 | 0.100358422939068 | 28 | 0 | 10 | 0 | 119 | 146 | 28372 | 28345 | Albugo laibachii Nc14, genomic contig CONTIG_133_NC14_v4_68809_223 | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 6736040 | 6736040 | PRJNA1249535_S_NODE_44386_length_500_cov_2.604215_g41057_i0 | PRJNA1249535 | 44386 | 500 | 2.604215 | 13.021075 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.049 | NTclustered | gi|325187216|emb|FR824178.1| | 890382 | g41057 | i0 | 100 | 0.056 | 28 | 0 | 6 | 0 | 153 | 180 | 28372 | 28345 | Albugo laibachii Nc14, genomic contig CONTIG_133_NC14_v4_68809_223 | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 7430415 | 7430415 | PRJNA1249535_S_NODE_80726_length_400_cov_4.198777_g77345_i0 | PRJNA1249535 | 80726 | 400 | 4.198777 | 16.795108 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.038 | NTclustered | gi|325182251|emb|FR824070.1| | 890382 | g77345 | i0 | 96.875 | 0.16 | 32 | 0 | 8 | 1 | 143 | 174 | 112267 | 112237 | Albugo laibachii Nc14, genomic contig CONTIG_25_NC14_v4_162253_173 | blastn | 64 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 14385291 | 14385291 | PRJNA1249535_S_NODE_187432_length_313_cov_3.158333_g184049_i0 | PRJNA1249535 | 187432 | 313 | 3.158333 | 9.88558229 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 6.29e-4 | NTclustered | gi|675174426|ref|XM_008897850.1| | 761204 | g184049 | i0 | 100 | 0.389776357827476 | 31 | 0 | 10 | 0 | 283 | 313 | 1022 | 992 | Phytophthora parasitica INRA-310 hypothetical protein, variant 2 mRNA | blastn | 122 | 58.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 27028455 | 27028455 | PRJNA1249535_S_NODE_107842_length_367_cov_3.190476_g104459_i0 | PRJNA1249535 | 107842 | 367 | 3.190476 | 11.70904692 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 1.51e-6 | NR | KAE9215043.1 | 53985 | g104459 | i0 | 35.5 | 2.28065395095368 | 93 | 59 | 76 | 1 | 6 | 284 | 382 | 473 | KAE9215043.1 hypothetical protein PF004_g14871 [Phytophthora fragariae] | diamond | 837 | 57 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 27610970 | 27610970 | PRJNA1249535_S_NODE_32844_length_557_cov_2.865702_g29575_i0 | PRJNA1249535 | 32844 | 557 | 2.865702 | 15.96196014 | Phytophthora rubi | 129364 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 0.00219 | NR | KAE9015137.1 | 129364 | g29575 | i0 | 36.4 | 0.355475763016158 | 66 | 42 | 35.5 | 0 | 313 | 116 | 247 | 312 | KAE9015137.1 hypothetical protein PR001_g14969 [Phytophthora rubi] | diamond | 198 | 50.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora rubi | ||
| 27674146 | 27674146 | PRJNA1249535_S_NODE_208764_length_301_cov_6.135965_g205381_i0 | PRJNA1249535 | 208764 | 301 | 6.135965 | 18.46925465 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 3.32e-8 | NR | KAJ0391852.1 | 114742 | g205381 | i0 | 41.2 | 2.68106312292359 | 68 | 40 | 67.8 | 0 | 240 | 37 | 652 | 719 | KAJ0391852.1 hypothetical protein P43SY_010752 [Pythium insidiosum] | diamond | 807 | 60.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 28607571 | 28607571 | PRJNA1249535_S_NODE_139507_length_342_cov_3.156134_g136124_i0 | PRJNA1249535 | 139507 | 342 | 3.156134 | 10.79397828 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00981 | NR | KAE8877845.1 | 53985 | g136124 | i0 | 34.8 | 6.94736842105263 | 66 | 43 | 57.9 | 0 | 336 | 139 | 526 | 591 | KAE8877845.1 hypothetical protein PF003_g37962 [Phytophthora fragariae] | diamond | 2376 | 46.2 | 0.991341991341991 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 30073603 | 30073603 | PRJNA1249535_S_NODE_296132_length_255_cov_1.489011_g292749_i0 | PRJNA1249535 | 296132 | 255 | 1.489011 | 3.79697805 | Phytophthora cactorum | 29920 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00255 | NR | KAG2778066.1 | 29920 | g292749 | i0 | 32.4 | 5.45882352941176 | 68 | 46 | 80 | 0 | 244 | 41 | 182 | 249 | KAG2778066.1 hypothetical protein Pcac1_g11532 [Phytophthora cactorum] | diamond | 1392 | 46.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 30263620 | 30263620 | PRJNA1249535_S_NODE_297752_length_254_cov_1.723757_g294369_i0 | PRJNA1249535 | 297752 | 254 | 1.723757 | 4.37834278 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 9.23e-4 | NR | KAF1334404.1 | 82926 | g294369 | i0 | 62.5 | 0.377952755905512 | 32 | 12 | 37.8 | 0 | 4 | 99 | 111 | 142 | KAF1334404.1 Tkl protein kinase, partial [Globisporangium splendens] | diamond | 96 | 47.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 31893328 | 31893328 | PRJNA1249535_S_NODE_206237_length_303_cov_2.243478_g202854_i0 | PRJNA1249535 | 206237 | 303 | 2.243478 | 6.79773834 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 0.00185 | NR | KAE9215043.1 | 53985 | g202854 | i0 | 33.3 | 2.22772277227723 | 75 | 50 | 74.3 | 0 | 25 | 249 | 399 | 473 | KAE9215043.1 hypothetical protein PF004_g14871 [Phytophthora fragariae] | diamond | 675 | 47.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 32494746 | 32494746 | PRJNA1249535_S_NODE_43679_length_502_cov_36.000000_g40351_i0 | PRJNA1249535 | 43679 | 502 | 36 | 180.72 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 0.00121 | NR | OWY93302.1 | 4795 | g40351 | i0 | 33.3 | 4.22509960159363 | 72 | 48 | 43 | 0 | 51 | 266 | 2 | 73 | OWY93302.1 putative membrane protein, partial [Phytophthora megakarya] | diamond | 2121 | 50.1 | 0.992015968063872 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya |
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);;