contig_metadata
23 rows where bioproject = "PRJNA683902" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 665500 | 665500 | PRJNA683902_S_NODE_8961_length_520_cov_10.873706_g8536_i0 | PRJNA683902 | 8961 | 520 | 10.873706 | 56.5432712 | Pythium monospermum | 92964 | SAR_Eukaryotes | SAR_Eukaryotes | 815 | 0 | NTclustered | gi|33520250|gb|AY273995.1| | 92964 | g8536 | i0 | 95.85 | 96.6076923076923 | 506 | 18 | 97 | 3 | 1 | 504 | 19 | 523 | Pythium monospermum large subunit ribosomal RNA gene, partial sequence | blastn | 50236 | 815 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium monospermum | ||
| 5003849 | 5003849 | PRJNA683902_S_NODE_26524_length_194_cov_2.560510_g26080_i0 | PRJNA683902 | 26524 | 194 | 2.56051 | 4.9673894 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 7.85e-24 | NR | DAZ96004.1 | 4803 | g26080 | i0 | 81 | 12.5103092783505 | 63 | 12 | 97.4 | 0 | 193 | 5 | 107 | 169 | DAZ96004.1 TPA: hypothetical protein N0F65_009305 [Lagenidium giganteum] | diamond | 2427 | 102 | 0.990196078431373 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 5768860 | 5768860 | PRJNA683902_S_NODE_20565_length_233_cov_2.306122_g20121_i0 | PRJNA683902 | 20565 | 233 | 2.306122 | 5.37326426 | uncultured Oomycota | 179533 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.07e-114 | NTclustered | gi|575503194|gb|KF750352.1| | 179533 | g20121 | i0 | 99.571 | 99.6781115879828 | 233 | 1 | 100 | 0 | 1 | 233 | 280 | 48 | Uncultured oomycete clone A2g8796 large subunit ribosomal RNA gene, partial sequence | blastn | 23225 | 425 | 1 | Eukaryota | Sar | Oomycota | uncultured Oomycota | ||||||
| 7553629 | 7553629 | PRJNA683902_S_NODE_39826_length_150_cov_3.522124_g39382_i0 | PRJNA683902 | 39826 | 150 | 3.522124 | 5.283186 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 8.680000000000001e-64 | NTclustered | gi|573007521|gb|HQ643388.2| | 126845 | g39382 | i0 | 97.351 | 100.44 | 151 | 2 | 99 | 2 | 2 | 150 | 1438 | 1288 | Phytopythium megacarpum voucher CBS112351 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 | 15066 | 255 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Phytopythium | Phytopythium megacarpum | ||
| 9593932 | 9593932 | PRJNA683902_S_NODE_27708_length_188_cov_3.066225_g27264_i0 | PRJNA683902 | 27708 | 188 | 3.066225 | 5.764503 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.03e-21 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g27264 | i0 | 83.74 | 14.7234042553191 | 123 | 18 | 65 | 2 | 64 | 185 | 127 | 248 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 2768 | 115 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 10104047 | 10104047 | PRJNA683902_S_NODE_23588_length_211_cov_2.448276_g23144_i0 | PRJNA683902 | 23588 | 211 | 2.448276 | 5.16586236 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 1.68e-72 | NTclustered | gi|2440150|emb|X75631.1| | 4788 | g23144 | i0 | 91.08 | 99.0284360189574 | 213 | 16 | 100 | 3 | 1 | 211 | 2927 | 2716 | P.megasperma gene for 28S ribosomal RNA | blastn | 20895 | 285 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megasperma | ||
| 10869255 | 10869255 | PRJNA683902_S_NODE_24949_length_203_cov_2.114458_g24505_i0 | PRJNA683902 | 24949 | 203 | 2.114458 | 4.29234974 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 333 | 5.639999999999999e-87 | NTclustered | gi|7658194|gb|AF119587.1| | 120398 | g24505 | i0 | 96.517 | 90.64039408867 | 201 | 7 | 99 | 0 | 3 | 203 | 358 | 558 | Aphanomyces stellatus strain AR 51 large subunit ribosomal RNA gene, partial sequence | blastn | 18400 | 333 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 11379099 | 11379099 | PRJNA683902_S_NODE_31169_length_174_cov_2.160584_g30725_i0 | PRJNA683902 | 31169 | 174 | 2.160584 | 3.75941616 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 95.5 | 3.94e-21 | NR | KAL4159755.1 | 164328 | g30725 | i0 | 86.8 | 18.5 | 53 | 7 | 91.4 | 0 | 159 | 1 | 1234 | 1286 | KAL4159755.1 hypothetical protein PRNP1_000328 [Phytophthora ramorum] | diamond | 3219 | 95.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 12654840 | 12654840 | PRJNA683902_S_NODE_24910_length_203_cov_3.265060_g24466_i0 | PRJNA683902 | 24910 | 203 | 3.26506 | 6.6280718 | Pythiales | 121069 | SAR_Eukaryotes | SAR_Eukaryotes | 368 | 1.55e-97 | NTclustered | gi|531037406|gb|AY598692.2| | 172234 | g24466 | i0 | 99.505 | 99.512315270936 | 202 | 1 | 99 | 0 | 2 | 203 | 4041 | 3840 | Pythium grandisporangium strain CBS 286.79 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 | 20201 | 368 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium grandisporangium | ||
| 18517280 | 18517280 | PRJNA683902_S_NODE_14495_length_316_cov_2.896057_g14051_i0 | PRJNA683902 | 14495 | 316 | 2.896057 | 9.15154012 | Pythium grandisporangium | 172234 | SAR_Eukaryotes | SAR_Eukaryotes | 555 | 1.8499999999999999e-153 | NTclustered | gi|1042782939|gb|KT886041.1| | 172234 | g14051 | i0 | 98.418 | 99.9240506329114 | 316 | 4 | 100 | 1 | 1 | 316 | 951 | 637 | Pythium grandisporangium voucher CCIBt 4073 18S ribosomal RNA gene, partial sequence | blastn | 31576 | 555 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium grandisporangium | ||
| 18517487 | 18517487 | PRJNA683902_S_NODE_36795_length_157_cov_2.800000_g36351_i0 | PRJNA683902 | 36795 | 157 | 2.8 | 4.396 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 3.45e-33 | NTclustered | gi|698801103|ref|XM_009835279.1| | 112090 | g36351 | i0 | 84.713 | 99.1528662420382 | 157 | 20 | 99 | 4 | 1 | 155 | 705 | 859 | Aphanomyces astaci adenosylhomocysteinase 2 mRNA | blastn | 15567 | 154 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 19027250 | 19027250 | PRJNA683902_S_NODE_30255_length_177_cov_3.871429_g29811_i0 | PRJNA683902 | 30255 | 177 | 3.871429 | 6.85242933 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.75e-71 | NTclustered | gi|51235482|gb|AY598628.1| | 82932 | g29811 | i0 | 95.48 | 100.011299435028 | 177 | 6 | 99 | 2 | 1 | 175 | 1809 | 1633 | Pythium arrhenomanes strain CBS 324.62 internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 17702 | 281 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium arrhenomanes | ||
| 19792362 | 19792362 | PRJNA683902_S_NODE_36256_length_158_cov_5.619835_g35812_i0 | PRJNA683902 | 36256 | 158 | 5.619835 | 8.8793393 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 2.65e-44 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g35812 | i0 | 88.679 | 38.7658227848101 | 159 | 14 | 99 | 4 | 2 | 158 | 1540 | 1696 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 6125 | 191 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 25402110 | 25402110 | PRJNA683902_S_NODE_32860_length_168_cov_3.015267_g32416_i0 | PRJNA683902 | 32860 | 168 | 3.015267 | 5.06564856 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 1.7600000000000002e-26 | NTclustered | gi|189084851|gb|BT032382.1| | 4784 | g32416 | i0 | 81.646 | 16.1190476190476 | 158 | 29 | 94 | 0 | 11 | 168 | 407 | 250 | Phytophthora capsici clone CBOU49-E03 mRNA sequence | blastn | 2708 | 132 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 26892556 | 26892556 | PRJNA683902_S_NODE_19441_length_244_cov_1.869565_g18997_i0 | PRJNA683902 | 19441 | 244 | 1.869565 | 4.5617386 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 93.2 | 6.6500000000000005e-22 | NR | KAJ0410394.1 | 114742 | g18997 | i0 | 62.7 | 2.76639344262295 | 75 | 27 | 92.2 | 1 | 242 | 18 | 82 | 155 | KAJ0410394.1 hypothetical protein P43SY_002726 [Pythium insidiosum] | diamond | 675 | 93.2 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 27914913 | 27914913 | PRJNA683902_S_NODE_30065_length_178_cov_2.127660_g29621_i0 | PRJNA683902 | 30065 | 178 | 2.12766 | 3.7872348 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 1.9900000000000003e-21 | NR | KAF0718998.1 | 120398 | g29621 | i0 | 78.2 | 25.5168539325843 | 55 | 12 | 92.7 | 0 | 167 | 3 | 32 | 86 | KAF0718998.1 hypothetical protein As57867_001340 [Aphanomyces stellatus] | diamond | 4542 | 92 | 0.996739130434783 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 28546780 | 28546780 | PRJNA683902_S_NODE_29567_length_180_cov_1.727273_g29123_i0 | PRJNA683902 | 29567 | 180 | 1.727273 | 3.1090914 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 3.78e-8 | NR | RHY01079.1 | 112090 | g29123 | i0 | 96 | 2.5 | 25 | 1 | 41.7 | 0 | 1 | 75 | 38 | 62 | RHY01079.1 hypothetical protein DYB25_010126, partial [Aphanomyces astaci] | diamond | 450 | 54.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 28704534 | 28704534 | PRJNA683902_S_NODE_27427_length_190_cov_1.111111_g26983_i0 | PRJNA683902 | 27427 | 190 | 1.111111 | 2.1111109 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 7.53e-20 | NR | RHY74090.1 | 112090 | g26983 | i0 | 69.8 | 3.97894736842105 | 63 | 18 | 97.9 | 1 | 188 | 3 | 15 | 77 | RHY74090.1 hypothetical protein DYB30_004665 [Aphanomyces astaci] | diamond | 756 | 87 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 30156732 | 30156732 | PRJNA683902_S_NODE_20272_length_236_cov_1.452261_g19828_i0 | PRJNA683902 | 20272 | 236 | 1.452261 | 3.42733596 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 7.339999999999999e-43 | NR | RHZ16721.1 | 112090 | g19828 | i0 | 89.7 | 7.93220338983051 | 78 | 8 | 99.2 | 0 | 236 | 3 | 149 | 226 | RHZ16721.1 hypothetical protein DYB31_004085 [Aphanomyces astaci] | diamond | 1872 | 156 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 30378538 | 30378538 | PRJNA683902_S_NODE_19572_length_243_cov_1.422330_g19128_i0 | PRJNA683902 | 19572 | 243 | 1.42233 | 3.4562619 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 2.95e-39 | NR | KAL0583279.1 | 65357 | g19128 | i0 | 76.5 | 15.8395061728395 | 81 | 19 | 100 | 0 | 1 | 243 | 1 | 81 | KAL0583279.1 hypothetical protein ABG067_006780 [Albugo candida] | diamond | 3849 | 139 | 0.992805755395683 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 30555923 | 30555923 | PRJNA683902_S_NODE_29493_length_180_cov_2.776224_g29049_i0 | PRJNA683902 | 29493 | 180 | 2.776224 | 4.9972032 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 2.67e-25 | NR | CCA19147.1 | 890382 | g29049 | i0 | 76.7 | 3 | 60 | 14 | 100 | 0 | 1 | 180 | 91 | 150 | CCA19147.1 40S ribosomal protein S4 putative [Albugo laibachii Nc14] | diamond | 540 | 103 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 32338667 | 32338667 | PRJNA683902_S_NODE_27019_length_192_cov_1.316129_g26575_i0 | PRJNA683902 | 27019 | 192 | 1.316129 | 2.52696768 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 4.28e-30 | NR | TMW65496.1 | 41045 | g26575 | i0 | 76.2 | 14.59375 | 63 | 15 | 98.4 | 0 | 190 | 2 | 128 | 190 | TMW65496.1 hypothetical protein Poli38472_008138 [Pythium oligandrum] | diamond | 2802 | 115 | 0.991304347826087 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 32863240 | 32863240 | PRJNA683902_S_NODE_20240_length_236_cov_2.648241_g19796_i0 | PRJNA683902 | 20240 | 236 | 2.648241 | 6.24984876 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 9.67e-39 | NR | TYZ63780.1 | 1485010 | g19796 | i0 | 80.5 | 2.94915254237288 | 77 | 15 | 97.9 | 0 | 4 | 234 | 65 | 141 | TYZ63780.1 hypothetical protein PybrP1_001840 [[Pythium] brassicae (nom. inval.)] | diamond | 696 | 138 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) |
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);;