contig_metadata
21 rows where bioproject = "PRJNA635874", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4436061 | 4436061 | PRJNA635874_P_NODE_7484_length_523_cov_2.800000_g7338_i0 | PRJNA635874 | 7484 | 523 | 2.8 | 14.644 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 170 | 2.33e-50 | NR | DBA01302.1 | 4803 | g7338 | i0 | 59.2 | 8.16252390057361 | 142 | 52 | 78.6 | 2 | 39 | 449 | 42 | 182 | DBA01302.1 TPA: hypothetical protein N0F65_001807 [Lagenidium giganteum] | diamond | 4269 | 171 | 0.994152046783626 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 13908318 | 13908318 | PRJNA635874_P_NODE_27891_length_311_cov_1.915966_g27744_i0 | PRJNA635874 | 27891 | 311 | 1.915966 | 5.95865426 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 4.02e-41 | NR | RHZ16721.1 | 112090 | g27744 | i0 | 67 | 17.8263665594855 | 103 | 34 | 99.4 | 0 | 3 | 311 | 143 | 245 | RHZ16721.1 hypothetical protein DYB31_004085 [Aphanomyces astaci] | diamond | 5544 | 152 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 14635774 | 14635774 | PRJNA635874_P_NODE_17512_length_370_cov_2.602694_g17365_i0 | PRJNA635874 | 17512 | 370 | 2.602694 | 9.6299678 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 8.529999999999999e-23 | NR | DAZ92868.1 | 4803 | g17365 | i0 | 73.7 | 3.68918918918919 | 76 | 19 | 60.8 | 1 | 229 | 5 | 3 | 78 | DAZ92868.1 TPA: hypothetical protein N0F65_003047 [Lagenidium giganteum] | diamond | 1365 | 102 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 15909862 | 15909862 | PRJNA635874_P_NODE_2313_length_822_cov_1.965287_g2193_i0 | PRJNA635874 | 2313 | 822 | 1.965287 | 16.15465914 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 229 | 2.39e-71 | NR | GLD96418.1 | 114742 | g2193 | i0 | 60.2 | 6.52919708029197 | 186 | 67 | 67.9 | 1 | 822 | 265 | 25 | 203 | GLD96418.1 hypothetical protein PINS_up005101 [Pythium insidiosum] | diamond | 5367 | 229 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 18458895 | 18458895 | PRJNA635874_P_NODE_13815_length_407_cov_1.278443_g13668_i0 | PRJNA635874 | 13815 | 407 | 1.278443 | 5.20326301 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 2.07e-35 | NR | TMW64003.1 | 41045 | g13668 | i0 | 65.8 | 1.73218673218673 | 114 | 39 | 84 | 0 | 5 | 346 | 1 | 114 | TMW64003.1 hypothetical protein Poli38472_014708 [Pythium oligandrum] | diamond | 705 | 130 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 18458913 | 18458913 | PRJNA635874_P_NODE_14515_length_398_cov_4.341538_g14368_i0 | PRJNA635874 | 14515 | 398 | 4.341538 | 17.27932124 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.0099999999999995e-55 | NR | RHY06028.1 | 112090 | g14368 | i0 | 71.9 | 0.912060301507538 | 121 | 34 | 91.2 | 0 | 366 | 4 | 19 | 139 | RHY06028.1 hypothetical protein DYB25_001794 [Aphanomyces astaci] | diamond | 363 | 180 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 18459045 | 18459045 | PRJNA635874_P_NODE_18975_length_359_cov_1.479021_g18828_i0 | PRJNA635874 | 18975 | 359 | 1.479021 | 5.30968539 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 168 | 7.559999999999999e-46 | NR | KAJ8552402.1 | 4785 | g18828 | i0 | 76.4 | 21.142061281337 | 110 | 26 | 91.9 | 0 | 28 | 357 | 681 | 790 | KAJ8552402.1 hypothetical protein ON010_g10144 [Phytophthora cinnamomi] | diamond | 7590 | 169 | 0.994082840236686 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 18459405 | 18459405 | PRJNA635874_P_NODE_31875_length_295_cov_1.387387_g31728_i0 | PRJNA635874 | 31875 | 295 | 1.387387 | 4.09279165 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 175 | 9.81e-50 | NR | KAJ8575517.1 | 4785 | g31728 | i0 | 90.8 | 40.8203389830508 | 98 | 9 | 99.7 | 0 | 1 | 294 | 315 | 412 | KAJ8575517.1 hypothetical protein ON010_g3696 [Phytophthora cinnamomi] | diamond | 12042 | 176 | 0.994318181818182 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 19734153 | 19734153 | PRJNA635874_P_NODE_38996_length_272_cov_1.211055_g38849_i0 | PRJNA635874 | 38996 | 272 | 1.211055 | 3.2940696 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 5.07e-44 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g38849 | i0 | 79.705 | 20.2610294117647 | 271 | 50 | 99 | 5 | 2 | 270 | 457 | 190 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 5511 | 191 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 21009191 | 21009191 | PRJNA635874_P_NODE_15897_length_385_cov_0.983974_g15750_i0 | PRJNA635874 | 15897 | 385 | 0.983974 | 3.7882999 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 1.4e-43 | NR | TMW58359.1 | 41045 | g15750 | i0 | 63.2 | 2.51688311688312 | 117 | 43 | 91.2 | 0 | 376 | 26 | 2 | 118 | TMW58359.1 hypothetical protein Poli38472_009918 [Pythium oligandrum] | diamond | 969 | 149 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 27030174 | 27030174 | PRJNA635874_P_NODE_55482_length_248_cov_0.880000_g55335_i0 | PRJNA635874 | 55482 | 248 | 0.88 | 2.1824 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 1.73e-11 | NR | KAF1773067.1 | 29920 | g55335 | i0 | 45.6 | 4.75403225806452 | 79 | 43 | 95.6 | 0 | 2 | 238 | 902 | 980 | KAF1773067.1 Leucine-rich repeat domain, L domain-like [Phytophthora cactorum] | diamond | 1179 | 69.7 | 0.994261119081779 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 28249354 | 28249354 | PRJNA635874_P_NODE_17026_length_375_cov_1.019868_g16879_i0 | PRJNA635874 | 17026 | 375 | 1.019868 | 3.824505 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 6.46e-35 | NR | DAZ93677.1 | 4803 | g16879 | i0 | 56.3 | 4.968 | 126 | 53 | 99.2 | 2 | 3 | 374 | 222 | 347 | DAZ93677.1 TPA: hypothetical protein N0F65_008185 [Lagenidium giganteum] | diamond | 1863 | 137 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 28407456 | 28407456 | PRJNA635874_P_NODE_22926_length_335_cov_1.175573_g22779_i0 | PRJNA635874 | 22926 | 335 | 1.175573 | 3.93816955 | Aphanomyces cochlioides | 112091 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 7.63e-5 | NR | KAG9412244.1 | 112091 | g22779 | i0 | 34.6 | 0.725373134328358 | 81 | 50 | 72.5 | 2 | 279 | 37 | 110 | 187 | KAG9412244.1 hypothetical protein AC1031_015185 [Aphanomyces cochlioides] | diamond | 243 | 51.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 28672600 | 28672600 | PRJNA635874_P_NODE_17147_length_374_cov_0.976744_g17000_i0 | PRJNA635874 | 17147 | 374 | 0.976744 | 3.65302256 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 4.160000000000001e-27 | NR | DAZ94117.1 | 4803 | g17000 | i0 | 44.4 | 3.71390374331551 | 124 | 65 | 99.5 | 2 | 374 | 3 | 27 | 146 | DAZ94117.1 TPA: hypothetical protein N0F65_008981 [Lagenidium giganteum] | diamond | 1389 | 114 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 28798586 | 28798586 | PRJNA635874_P_NODE_19667_length_355_cov_1.092199_g19520_i0 | PRJNA635874 | 19667 | 355 | 1.092199 | 3.87730645 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 4.380000000000001e-27 | NR | GLD98450.1 | 114742 | g19520 | i0 | 60 | 3.82816901408451 | 90 | 34 | 76.1 | 1 | 354 | 85 | 156 | 243 | GLD98450.1 hypothetical protein PINS_up007147 [Pythium insidiosum] | diamond | 1359 | 112 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 30776182 | 30776182 | PRJNA635874_P_NODE_49434_length_250_cov_0.870056_g49287_i0 | PRJNA635874 | 49434 | 250 | 0.870056 | 2.17514 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00467 | NR | KAF1334365.1 | 82926 | g49287 | i0 | 34.1 | 1.02 | 85 | 31 | 99.6 | 2 | 1 | 249 | 700 | 761 | KAF1334365.1 Phosphatidylinositol-3-phosphate5-kinase, partial [Globisporangium splendens] | diamond | 255 | 45.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 31376704 | 31376704 | PRJNA635874_P_NODE_4836_length_624_cov_2.339383_g4693_i0 | PRJNA635874 | 4836 | 624 | 2.339383 | 14.59774992 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 4.97e-58 | NR | GLD99359.1 | 114742 | g4693 | i0 | 75.9 | 3.45673076923077 | 145 | 32 | 69.7 | 2 | 600 | 166 | 441 | 582 | GLD99359.1 hypothetical protein PINS_up008078 [Pythium insidiosum] | diamond | 2157 | 202 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31471628 | 31471628 | PRJNA635874_P_NODE_39636_length_270_cov_1.228426_g39489_i0 | PRJNA635874 | 39636 | 270 | 1.228426 | 3.3167502 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 1.44e-8 | NR | GLD99793.1 | 114742 | g39489 | i0 | 40 | 12 | 90 | 31 | 100 | 1 | 270 | 1 | 113 | 179 | GLD99793.1 hypothetical protein PINS_up008521 [Pythium insidiosum] | diamond | 3240 | 60.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 31578943 | 31578943 | PRJNA635874_P_NODE_29856_length_303_cov_1.339130_g29709_i0 | PRJNA635874 | 29856 | 303 | 1.33913 | 4.0575639 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 3.55e-7 | NR | KAF4040277.1 | 4787 | g29709 | i0 | 48.1 | 7.59405940594059 | 54 | 28 | 53.5 | 0 | 303 | 142 | 190 | 243 | KAF4040277.1 NUDIX domain-containing protein [Phytophthora infestans] | diamond | 2301 | 58.2 | 0.993127147766323 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 31831655 | 31831655 | PRJNA635874_P_NODE_32477_length_293_cov_1.145455_g32330_i0 | PRJNA635874 | 32477 | 293 | 1.145455 | 3.35618315 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 4.7e-25 | NR | XP_067817904.1 | 4779 | g32330 | i0 | 56.7 | 15.1740614334471 | 90 | 33 | 92.2 | 1 | 23 | 292 | 350 | 433 | XP_067817904.1 hypothetical protein CCR75_007691 [Bremia lactucae] | diamond | 4446 | 109 | 0.990825688073395 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 31926734 | 31926734 | PRJNA635874_P_NODE_6257_length_562_cov_2.503067_g6113_i0 | PRJNA635874 | 6257 | 562 | 2.503067 | 14.06723654 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 4.95e-32 | NR | DAZ98414.1 | 4803 | g6113 | i0 | 69 | 2.87188612099644 | 87 | 27 | 46.4 | 0 | 17 | 277 | 595 | 681 | DAZ98414.1 TPA: hypothetical protein N0F65_000128 [Lagenidium giganteum] | diamond | 1614 | 133 | 0.992481203007519 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum |
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);;