contig_metadata
17 rows where bioproject = "PRJNA1068830", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1458416 | 1458416 | PRJNA1068830_P_NODE_83882_length_245_cov_0.906977_g83179_i0 | PRJNA1068830 | 83882 | 245 | 0.906977 | 2.22209365 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 4.59e-29 | NTclustered | gi|695403226|ref|XM_009524933.1| | 67593 | g83179 | i0 | 81.657 | 6.29795918367347 | 169 | 31 | 69 | 0 | 77 | 245 | 40 | 208 | Phytophthora sojae hypothetical protein mRNA | blastn | 1543 | 141 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 10386168 | 10386168 | PRJNA1068830_P_NODE_47889_length_317_cov_1.692623_g47186_i0 | PRJNA1068830 | 47889 | 317 | 1.692623 | 5.36561491 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 1.01e-41 | NTclustered | gi|695370545|ref|XM_009516042.1| | 67593 | g47186 | i0 | 79.211 | 80.1892744479495 | 279 | 46 | 86 | 12 | 11 | 283 | 73 | 345 | Phytophthora sojae hypothetical protein mRNA | blastn | 25420 | 183 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 10387014 | 10387014 | PRJNA1068830_P_NODE_81429_length_247_cov_0.896552_g80726_i0 | PRJNA1068830 | 81429 | 247 | 0.896552 | 2.21448344 | Phytophthora sp. XX-2020b | 2817068 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 4.38e-69 | NTclustered | gi|2205873338|gb|MW822323.1| | 2817068 | g80726 | i0 | 86.64 | 95.5182186234818 | 247 | 33 | 100 | 0 | 1 | 247 | 740 | 986 | Phytophthora sp. XX-2020b isolate 1BLX102 heat shock protein 90 (HSP90) gene, partial cds | blastn | 23593 | 274 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sp. XX-2020b | ||
| 12936722 | 12936722 | PRJNA1068830_P_NODE_49751_length_311_cov_0.983193_g49048_i0 | PRJNA1068830 | 49751 | 311 | 0.983193 | 3.05773023 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 162 | 1.05e-46 | NR | DAZ92773.1 | 4803 | g49048 | i0 | 78.4 | 6.91639871382637 | 102 | 22 | 98.4 | 0 | 309 | 4 | 28 | 129 | DAZ92773.1 TPA: hypothetical protein N0F65_008155 [Lagenidium giganteum] | diamond | 2151 | 163 | 0.993865030674847 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 16316835 | 16316835 | PRJNA1068830_P_NODE_81273_length_247_cov_0.896552_g80570_i0 | PRJNA1068830 | 81273 | 247 | 0.896552 | 2.21448344 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 4.66e-24 | NTclustered | gi|2795049776|ref|XM_067938656.1| | 4785 | g80570 | i0 | 89 | 25.6882591093117 | 100 | 11 | 40 | 0 | 148 | 247 | 1980 | 1881 | Phytophthora cinnamomi polyadenylate-binding protein 1-B (IUM83_13951), partial mRNA | blastn | 6345 | 124 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 19307843 | 19307843 | PRJNA1068830_P_NODE_19836_length_537_cov_1.219828_g19137_i0 | PRJNA1068830 | 19836 | 537 | 1.219828 | 6.55047636 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 3.509999999999999e-55 | NR | DAZ94473.1 | 4803 | g19137 | i0 | 57.3 | 2.6927374301676 | 164 | 68 | 91.1 | 2 | 41 | 529 | 43 | 205 | DAZ94473.1 TPA: hypothetical protein N0F65_003509, partial [Lagenidium giganteum] | diamond | 1446 | 198 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 21859775 | 21859775 | PRJNA1068830_P_NODE_51418_length_305_cov_1.344828_g50715_i0 | PRJNA1068830 | 51418 | 305 | 1.344828 | 4.1017254 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 4.16e-48 | NR | TYZ60753.1 | 1485010 | g50715 | i0 | 76.2 | 8.94098360655738 | 101 | 24 | 99.3 | 0 | 304 | 2 | 22 | 122 | TYZ60753.1 hypothetical protein PybrP1_007794 [[Pythium] brassicae (nom. inval.)] | diamond | 2727 | 159 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 23134893 | 23134893 | PRJNA1068830_P_NODE_34259_length_385_cov_3.208333_g33556_i0 | PRJNA1068830 | 34259 | 385 | 3.208333 | 12.35208205 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 1.97e-79 | NTclustered | gi|301103609|ref|XM_002900845.1| | 403677 | g33556 | i0 | 83.041 | 74.774025974026 | 342 | 56 | 89 | 2 | 45 | 385 | 76 | 416 | Phytophthora infestans T30-4 ADP-ribosylation factor family (PITG_12288), mRNA | blastn | 28788 | 309 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 27943427 | 27943427 | PRJNA1068830_P_NODE_69045_length_259_cov_5.043011_g68342_i0 | PRJNA1068830 | 69045 | 259 | 5.043011 | 13.06139849 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 6.1e-8 | NR | XP_067751054.1 | 164328 | g68342 | i0 | 65 | 1.38996138996139 | 40 | 13 | 46.3 | 1 | 257 | 138 | 13 | 51 | XP_067751054.1 Ribonuclease H [Phytophthora ramorum] | diamond | 360 | 55.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 28353748 | 28353748 | PRJNA1068830_P_NODE_79346_length_248_cov_0.891429_g78643_i0 | PRJNA1068830 | 79346 | 248 | 0.891429 | 2.21074392 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 3.27e-9 | NR | OQR92960.1 | 74557 | g78643 | i0 | 74.4 | 3.7741935483871 | 39 | 10 | 47.2 | 0 | 130 | 246 | 9 | 47 | OQR92960.1 hypothetical protein THRCLA_08577 [Thraustotheca clavata] | diamond | 936 | 62.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 30501242 | 30501242 | PRJNA1068830_P_NODE_33513_length_391_cov_0.981132_g32810_i0 | PRJNA1068830 | 33513 | 391 | 0.981132 | 3.83622612 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 95.5 | 6.24e-20 | NR | CCI40734.1 | 65357 | g32810 | i0 | 38.2 | 3 | 131 | 78 | 98.2 | 2 | 389 | 6 | 240 | 370 | CCI40734.1 unnamed protein product [Albugo candida] | diamond | 1173 | 95.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 30920607 | 30920607 | PRJNA1068830_P_NODE_64414_length_270_cov_1.822335_g63711_i0 | PRJNA1068830 | 64414 | 270 | 1.822335 | 4.9203045 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 3.29e-24 | NR | OQS05744.1 | 74557 | g63711 | i0 | 56.3 | 0.966666666666667 | 87 | 37 | 95.6 | 1 | 5 | 262 | 980 | 1066 | OQS05744.1 hypothetical protein THRCLA_02157 [Thraustotheca clavata] | diamond | 261 | 105 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 31236293 | 31236293 | PRJNA1068830_P_NODE_81495_length_247_cov_0.896552_g80792_i0 | PRJNA1068830 | 81495 | 247 | 0.896552 | 2.21448344 | Albugo candida | 65357 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 2.07e-19 | NR | CCI47870.1 | 65357 | g80792 | i0 | 58.4 | 9.44939271255061 | 77 | 32 | 93.5 | 0 | 236 | 6 | 45 | 121 | CCI47870.1 unnamed protein product [Albugo candida] | diamond | 2334 | 90.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 31489690 | 31489690 | PRJNA1068830_P_NODE_80016_length_248_cov_0.891429_g79313_i0 | PRJNA1068830 | 80016 | 248 | 0.891429 | 2.21074392 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 1.14e-6 | NR | KAF0692056.1 | 120398 | g79313 | i0 | 41.8 | 0.955645161290323 | 79 | 42 | 91.9 | 3 | 236 | 9 | 134 | 211 | KAF0692056.1 hypothetical protein As57867_016743 [Aphanomyces stellatus] | diamond | 237 | 55.5 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 32050396 | 32050396 | PRJNA1068830_P_NODE_86418_length_243_cov_1.376471_g85715_i0 | PRJNA1068830 | 86418 | 243 | 1.376471 | 3.34482453 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 8.31e-9 | NR | CCI47428.1 | 65357 | g85715 | i0 | 44.7 | 4.61728395061728 | 76 | 41 | 92.6 | 1 | 237 | 13 | 404 | 479 | CCI47428.1 unnamed protein product [Albugo candida] | diamond | 1122 | 62 | 0.993548387096774 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 32240493 | 32240493 | PRJNA1068830_P_NODE_81818_length_246_cov_1.768786_g81115_i0 | PRJNA1068830 | 81818 | 246 | 1.768786 | 4.35121356 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 1.57e-22 | NR | CCI48837.1 | 65357 | g81115 | i0 | 73.7 | 1.40243902439024 | 57 | 15 | 69.5 | 0 | 1 | 171 | 277 | 333 | CCI48837.1 unnamed protein product [Albugo candida] | diamond | 345 | 99 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida | ||
| 32249027 | 32249027 | PRJNA1068830_P_NODE_67038_length_264_cov_1.633508_g66335_i0 | PRJNA1068830 | 67038 | 264 | 1.633508 | 4.31246112 | Salisapilia tartarea | 983661 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 8.57e-36 | NR | AYW51761.1 | 983661 | g66335 | i0 | 67.1 | 2.90909090909091 | 82 | 26 | 93.2 | 1 | 248 | 3 | 44 | 124 | AYW51761.1 sphingolipid delta(4)-desaturase DES1-like protein, partial [Salisapilia tartarea] | diamond | 768 | 130 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Salisapiliaceae | Salisapilia | Salisapilia tartarea |
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);;