contig_metadata
18 rows where bioproject = "PRJNA293022", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2334910 | 2334910 | PRJNA293022_P_NODE_22802_length_297_cov_2.266129_g22065_i0 | PRJNA293022 | 22802 | 297 | 2.266129 | 6.73040313 | Lagenidium | 4802 | SAR_Eukaryotes | SAR_Eukaryotes | 529 | 1.0499999999999996e-145 | NTclustered | gi|918464127|gb|KT257366.1| | 884619 | g22065 | i0 | 98.983 | 99.3232323232323 | 295 | 3 | 99 | 0 | 1 | 295 | 4003 | 3709 | Lagenidium deciduum isolate F10-KC59 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 29499 | 529 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium deciduum | ||
| 2334992 | 2334992 | PRJNA293022_P_NODE_65982_length_170_cov_3.685950_g65245_i0 | PRJNA293022 | 65982 | 170 | 3.68595 | 6.266115 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 4.659999999999999e-67 | NTclustered | gi|2661426469|ref|XR_009934769.1| | 403677 | g65245 | i0 | 95.238 | 98.7705882352941 | 168 | 8 | 99 | 0 | 3 | 170 | 1626 | 1793 | Phytophthora infestans T30-4 28S ribosomal RNA (PITG_33375), rRNA | blastn | 16791 | 267 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 4200338 | 4200338 | PRJNA293022_P_NODE_20764_length_312_cov_2.707224_g20027_i0 | PRJNA293022 | 20764 | 312 | 2.707224 | 8.44653888 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 4.519999999999999e-55 | NTclustered | gi|533310373|ref|NC_022179.1| | 74557 | g20027 | i0 | 83.399 | 50.4391025641026 | 253 | 35 | 81 | 4 | 4 | 255 | 13867 | 14113 | Thraustotheca clavata mitochondrion, complete genome | blastn | 15737 | 228 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 4200619 | 4200619 | PRJNA293022_P_NODE_77044_length_163_cov_0.912281_g76307_i0 | PRJNA293022 | 77044 | 163 | 0.912281 | 1.48701803 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 3.62e-33 | NTclustered | gi|675179278|ref|XM_008900276.1| | 761204 | g76307 | i0 | 86.861 | 1.69325153374233 | 137 | 18 | 84 | 0 | 21 | 157 | 637 | 501 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 276 | 154 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 8026512 | 8026512 | PRJNA293022_P_NODE_21247_length_308_cov_5.521236_g20510_i0 | PRJNA293022 | 21247 | 308 | 5.521236 | 17.00540688 | Lagenidium deciduum | 884619 | SAR_Eukaryotes | SAR_Eukaryotes | 566 | 8.299999999999999e-157 | NTclustered | gi|2522855646|gb|OR165096.1| | 884619 | g20510 | i0 | 100 | 98.3279220779221 | 306 | 0 | 99 | 0 | 3 | 308 | 10 | 315 | Lagenidium deciduum isolate UTHSCSA DI23-100 large subunit ribosomal RNA gene, partial sequence | blastn | 30285 | 566 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium deciduum | ||
| 10577304 | 10577304 | PRJNA293022_P_NODE_59669_length_180_cov_1.358779_g58932_i0 | PRJNA293022 | 59669 | 180 | 1.358779 | 2.4458022 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 1.37e-77 | NTclustered | gi|299830435|ref|NC_014280.1| | 2052682 | g58932 | i0 | 97.191 | 100.877777777778 | 178 | 5 | 99 | 0 | 1 | 178 | 8466 | 8643 | Pythium ultimum mitochondrion, complete genome | blastn | 18158 | 302 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 15087292 | 15087292 | PRJNA293022_P_NODE_3452_length_736_cov_6.614265_g2886_i0 | PRJNA293022 | 3452 | 736 | 6.614265 | 48.6809904 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 1074 | 0 | NTclustered | gi|2661426423|ref|XR_009934737.1| | 403677 | g2886 | i0 | 93.089 | 100.319293478261 | 738 | 44 | 99 | 7 | 3 | 735 | 1786 | 2521 | Phytophthora infestans T30-4 28S ribosomal RNA (PITG_33343), partial rRNA | blastn | 73835 | 1081 | 0.993524514338575 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 15675930 | 15675930 | PRJNA293022_P_NODE_19693_length_321_cov_1.676471_g18956_i0 | PRJNA293022 | 19693 | 321 | 1.676471 | 5.38147191 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 540 | 5.27e-149 | NTclustered | gi|269812125|gb|GU138663.1| | 2052682 | g18956 | i0 | 97.196 | 103.03738317757 | 321 | 6 | 99 | 3 | 2 | 321 | 9325 | 9007 | Pythium ultimum culture-collection CBS:398.51 mitochondrion, complete genome | blastn | 33075 | 540 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 17637308 | 17637308 | PRJNA293022_P_NODE_28494_length_263_cov_6.158879_g27757_i0 | PRJNA293022 | 28494 | 263 | 6.158879 | 16.19785177 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 7.179999999999997e-132 | NTclustered | gi|2260012693|gb|ON860583.1| | 135482 | g27757 | i0 | 100 | 99.2433460076046 | 261 | 0 | 99 | 0 | 3 | 263 | 44 | 304 | Myzocytiopsis humana voucher CCIBt4304 small subunit ribosomal RNA gene, partial sequence | blastn | 26101 | 483 | 1 | Eukaryota | Sar | Oomycota | Myzocytiopsidales | Myzocytiopsidaceae | Myzocytiopsis | Myzocytiopsis humana | |||
| 21461407 | 21461407 | PRJNA293022_P_NODE_15497_length_362_cov_6.482428_g14760_i0 | PRJNA293022 | 15497 | 362 | 6.482428 | 23.46638936 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 649 | 0 | NTclustered | gi|2922|emb|X54266.1| | 4803 | g14760 | i0 | 99.167 | 99.414364640884 | 360 | 3 | 99 | 0 | 3 | 362 | 638 | 997 | Lagenidium giganteum 16S ribosomal RNA | blastn | 35988 | 654 | 0.992354740061162 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 23325315 | 23325315 | PRJNA293022_P_NODE_38459_length_225_cov_2.062500_g37722_i0 | PRJNA293022 | 38459 | 225 | 2.0625 | 4.640625 | Paralagenidium karlingii | 1440115 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 4.15e-29 | NTclustered | gi|2554484921|ref|NC_080886.1| | 1440115 | g37722 | i0 | 90.09 | 47.2977777777778 | 111 | 8 | 49 | 3 | 65 | 174 | 41764 | 41656 | Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome | blastn | 10642 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Paralagenidium | Paralagenidium karlingii | ||||
| 25285773 | 25285773 | PRJNA293022_P_NODE_2340_length_872_cov_4.156744_g1885_i0 | PRJNA293022 | 2340 | 872 | 4.156744 | 36.24680768 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 1358 | 0 | NTclustered | gi|2026389858|gb|MT032128.1| | 4796 | g1885 | i0 | 95.233 | 100.711009174312 | 860 | 37 | 99 | 4 | 13 | 872 | 249 | 1104 | Phytophthora palmivora mitochondrion, complete genome | blastn | 87820 | 1369 | 0.991964937910884 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora palmivora | ||
| 27565564 | 27565564 | PRJNA293022_P_NODE_52204_length_193_cov_1.076389_g51467_i0 | PRJNA293022 | 52204 | 193 | 1.076389 | 2.07743077 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 3.31e-17 | NR | XP_024573891.1 | 4781 | g51467 | i0 | 72.5 | 9.55958549222798 | 51 | 14 | 79.3 | 0 | 179 | 27 | 97 | 147 | XP_024573891.1 60s ribosomal protein l27a [Plasmopara halstedii] | diamond | 1845 | 84.7 | 0.995277449822904 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 27643062 | 27643062 | PRJNA293022_P_NODE_70864_length_167_cov_0.881356_g70127_i0 | PRJNA293022 | 70864 | 167 | 0.881356 | 1.47186452 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 4.92e-14 | NR | DBA01199.1 | 4803 | g70127 | i0 | 61.8 | 0.988023952095808 | 55 | 21 | 98.8 | 0 | 166 | 2 | 52 | 106 | DBA01199.1 TPA: hypothetical protein N0F65_002334 [Lagenidium giganteum] | diamond | 165 | 75.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 27976134 | 27976134 | PRJNA293022_P_NODE_77065_length_163_cov_0.912281_g76328_i0 | PRJNA293022 | 77065 | 163 | 0.912281 | 1.48701803 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 3.8600000000000003e-22 | NR | KAH9108398.1 | 100861 | g76328 | i0 | 84.9 | 4.87730061349693 | 53 | 8 | 97.5 | 0 | 160 | 2 | 382 | 434 | KAH9108398.1 hypothetical protein AeMF1_016428 [Aphanomyces euteiches] | diamond | 795 | 97.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 28400651 | 28400651 | PRJNA293022_P_NODE_67806_length_169_cov_0.866667_g67069_i0 | PRJNA293022 | 67806 | 169 | 0.866667 | 1.46466723 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 1.44e-12 | NR | TYZ66174.1 | 1485010 | g67069 | i0 | 70.2 | 5.98224852071006 | 57 | 15 | 99.4 | 2 | 168 | 1 | 36 | 91 | TYZ66174.1 hypothetical protein PybrP1_001059, partial [[Pythium] brassicae (nom. inval.)] | diamond | 1011 | 68.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 29127092 | 29127092 | PRJNA293022_P_NODE_21489_length_307_cov_1.189922_g20752_i0 | PRJNA293022 | 21489 | 307 | 1.189922 | 3.65306054 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 7e-10 | NR | CCI43730.1 | 65357 | g20752 | i0 | 39.6 | 1.97394136807818 | 101 | 44 | 97.7 | 3 | 1 | 300 | 90 | 174 | CCI43730.1 unnamed protein product [Albugo candida] | diamond | 606 | 63.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 32872777 | 32872777 | PRJNA293022_P_NODE_75320_length_164_cov_0.904348_g74583_i0 | PRJNA293022 | 75320 | 164 | 0.904348 | 1.48313072 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 7.5e-21 | NR | XP_024579184.1 | 4781 | g74583 | i0 | 78 | 22.8292682926829 | 50 | 11 | 91.5 | 0 | 150 | 1 | 85 | 134 | XP_024579184.1 wd domain-containing protein [Plasmopara halstedii] | diamond | 3744 | 90.5 | 0.991160220994475 | 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);;