contig_metadata
25 rows where bioproject = "PRJEB50332", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119529 | 119529 | PRJEB50332_P_NODE_8081_length_235_cov_1.494253_g7999_i0 | PRJEB50332 | 8081 | 235 | 1.494253 | 3.51149455 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 3.87e-114 | NTclustered | gi|166044499|emb|CU367408.1| | 100861 | g7999 | i0 | 99.149 | 1 | 235 | 2 | 100 | 0 | 1 | 235 | 683 | 449 | Aphanomyces euteiches cDNA | blastn | 235 | 424 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 2669526 | 2669526 | PRJEB50332_P_NODE_1883_length_409_cov_1.821839_g1802_i0 | PRJEB50332 | 1883 | 409 | 1.821839 | 7.45132151 | Phytophthora megakarya | 4795 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 2.54e-9 | NR | OWZ20071.1 | 4795 | g1802 | i0 | 50.7 | 3.18337408312958 | 71 | 32 | 52.1 | 1 | 408 | 196 | 99 | 166 | OWZ20071.1 hypothetical protein PHMEG_0005576 [Phytophthora megakarya] | diamond | 1302 | 65.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya | ||
| 5221873 | 5221873 | PRJEB50332_P_NODE_2165_length_382_cov_2.570093_g2084_i0 | PRJEB50332 | 2165 | 382 | 2.570093 | 9.81775526 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 2.6399999999999994e-48 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g2084 | i0 | 79.795 | 57.9607329842932 | 292 | 51 | 75 | 4 | 98 | 382 | 441 | 151 | Aphanomyces astaci polyubiquitin mRNA | blastn | 22141 | 206 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 6497724 | 6497724 | PRJEB50332_P_NODE_6546_length_245_cov_1.766304_g6464_i0 | PRJEB50332 | 6546 | 245 | 1.766304 | 4.3274448 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 448 | 2.41e-121 | NTclustered | gi|166046682|emb|CU367792.1| | 100861 | g6464 | i0 | 99.592 | 98.6775510204082 | 245 | 1 | 100 | 0 | 1 | 245 | 674 | 430 | Aphanomyces euteiches cDNA | blastn | 24176 | 448 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 9046718 | 9046718 | PRJEB50332_P_NODE_5428_length_264_cov_1.280788_g5346_i0 | PRJEB50332 | 5428 | 264 | 1.280788 | 3.38128032 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 3.79e-45 | NTclustered | gi|673019759|ref|XM_008865619.1| | 157072 | g5346 | i0 | 80.62 | 23.3219696969697 | 258 | 45 | 97 | 5 | 10 | 264 | 207 | 462 | Aphanomyces invadans 40S ribosomal protein S23 mRNA | blastn | 6157 | 195 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 10322466 | 10322466 | PRJEB50332_P_NODE_9869_length_225_cov_1.585366_g9787_i0 | PRJEB50332 | 9869 | 225 | 1.585366 | 3.5670735 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 416 | 6.159999999999998e-112 | NTclustered | gi|166044636|emb|CU367545.1| | 100861 | g9787 | i0 | 100 | 42.4888888888889 | 225 | 0 | 100 | 0 | 1 | 225 | 268 | 492 | Aphanomyces euteiches cDNA | blastn | 9560 | 416 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 16696017 | 16696017 | PRJEB50332_P_NODE_11434_length_216_cov_2.509677_g11352_i0 | PRJEB50332 | 11434 | 216 | 2.509677 | 5.42090232 | Achlya bisexualis | 4766 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 4.9699999999999994e-48 | NTclustered | gi|2289|emb|X59936.1| | 4766 | g11352 | i0 | 88.235 | 76.1527777777778 | 170 | 20 | 79 | 0 | 7 | 176 | 170 | 1 | A.bisexualis gene for actin | blastn | 16449 | 204 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya bisexualis | ||
| 17970993 | 17970993 | PRJEB50332_P_NODE_155_length_1226_cov_2.453219_g119_i0 | PRJEB50332 | 155 | 1226 | 2.453219 | 30.07646494 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 540 | 1.45e-189 | NR | TMW60420.1 | 41045 | g119 | i0 | 68.5 | 21.3009787928222 | 394 | 110 | 96.4 | 3 | 1 | 1182 | 4 | 383 | TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] | diamond | 26115 | 543 | 0.994475138121547 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 21796197 | 21796197 | PRJEB50332_P_NODE_5538_length_262_cov_2.124378_g5456_i0 | PRJEB50332 | 5538 | 262 | 2.124378 | 5.56587036 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 2.74e-18 | NR | KAF0750677.1 | 112090 | g5456 | i0 | 67.6 | 0.847328244274809 | 74 | 17 | 76.7 | 3 | 201 | 1 | 1 | 74 | KAF0750677.1 hypothetical protein AaE_006624 [Aphanomyces astaci] | diamond | 222 | 87.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 23943608 | 23943608 | PRJEB50332_P_NODE_5999_length_254_cov_1.010363_g5917_i0 | PRJEB50332 | 5999 | 254 | 1.010363 | 2.56632202 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.89e-42 | NR | TMW61573.1 | 41045 | g5917 | i0 | 92.9 | 2.97637795275591 | 84 | 6 | 99.2 | 0 | 252 | 1 | 180 | 263 | TMW61573.1 hypothetical protein Poli38472_012764 [Pythium oligandrum] | diamond | 756 | 157 | 0.993630573248408 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 24345302 | 24345302 | PRJEB50332_P_NODE_18040_length_200_cov_3.424460_g17958_i0 | PRJEB50332 | 18040 | 200 | 3.42446 | 6.84892 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 4.22e-98 | NTclustered | gi|166046668|emb|CU367778.1| | 100861 | g17958 | i0 | 100 | 43.875 | 200 | 0 | 100 | 0 | 1 | 200 | 287 | 88 | Aphanomyces euteiches cDNA | blastn | 8775 | 370 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 24345333 | 24345333 | PRJEB50332_P_NODE_4800_length_277_cov_1.601852_g4718_i0 | PRJEB50332 | 4800 | 277 | 1.601852 | 4.43713004 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 322 | 1.76e-83 | NTclustered | gi|698823278|ref|XM_009846366.1| | 112090 | g4718 | i0 | 87.681 | 24.2166064981949 | 276 | 34 | 99 | 0 | 1 | 276 | 314 | 39 | Aphanomyces astaci 60S ribosomal protein mRNA | blastn | 6708 | 322 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 27058419 | 27058419 | PRJEB50332_P_NODE_17362_length_203_cov_0.915493_g17280_i0 | PRJEB50332 | 17362 | 203 | 0.915493 | 1.85845079 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.6e-30 | NR | RHY08334.1 | 112090 | g17280 | i0 | 79.1 | 3.96059113300493 | 67 | 14 | 99 | 0 | 202 | 2 | 193 | 259 | RHY08334.1 hypothetical protein DYB25_003472 [Aphanomyces astaci] | diamond | 804 | 119 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 27318153 | 27318153 | PRJEB50332_P_NODE_12443_length_211_cov_1.420000_g12361_i0 | PRJEB50332 | 12443 | 211 | 1.42 | 2.9962 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 5.2e-19 | NR | DAZ95514.1 | 4803 | g12361 | i0 | 61.8 | 2.90047393364929 | 68 | 26 | 96.7 | 0 | 204 | 1 | 1378 | 1445 | DAZ95514.1 TPA: LOW QUALITY PROTEIN: hypothetical protein N0F65_001853, partial [Lagenidium giganteum] | diamond | 612 | 90.1 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 28549673 | 28549673 | PRJEB50332_P_NODE_4767_length_278_cov_1.304147_g4685_i0 | PRJEB50332 | 4767 | 278 | 1.304147 | 3.62552866 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0157 | NR | KAH9158171.1 | 100861 | g4685 | i0 | 35 | 4.99640287769784 | 60 | 39 | 64.7 | 0 | 11 | 190 | 257 | 316 | KAH9158171.1 hypothetical protein AeRB84_000004 [Aphanomyces euteiches] | diamond | 1389 | 44.3 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 29016689 | 29016689 | PRJEB50332_P_NODE_5568_length_262_cov_1.268657_g5486_i0 | PRJEB50332 | 5568 | 262 | 1.268657 | 3.32388134 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 2.16e-9 | NR | RHY69310.1 | 112090 | g5486 | i0 | 41.8 | 2.77099236641221 | 79 | 42 | 90.5 | 2 | 242 | 6 | 468 | 542 | RHY69310.1 hypothetical protein DYB34_009213 [Aphanomyces astaci] | diamond | 726 | 63.9 | 0.993740219092332 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 29048058 | 29048058 | PRJEB50332_P_NODE_11708_length_215_cov_1.681818_g11626_i0 | PRJEB50332 | 11708 | 215 | 1.681818 | 3.6159087 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 2.55e-26 | NR | XP_024572062.1 | 4781 | g11626 | i0 | 74.3 | 14.6651162790698 | 70 | 18 | 97.7 | 0 | 213 | 4 | 435 | 504 | XP_024572062.1 trna wybutosine-synthesizing protein 1 homolog [Plasmopara halstedii] | diamond | 3153 | 111 | 0.990990990990991 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 30121461 | 30121461 | PRJEB50332_P_NODE_6092_length_252_cov_1.670157_g6010_i0 | PRJEB50332 | 6092 | 252 | 1.670157 | 4.20879564 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 7.140000000000001e-27 | NR | KAI9907086.1 | 230839 | g6010 | i0 | 80 | 4.26190476190476 | 70 | 14 | 83.3 | 0 | 249 | 40 | 88 | 157 | KAI9907086.1 hypothetical protein PsorP6_004328 [Peronosclerospora sorghi] | diamond | 1074 | 107 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronosclerospora | Peronosclerospora sorghi | ||
| 30374813 | 30374813 | PRJEB50332_P_NODE_10532_length_221_cov_2.031250_g10450_i0 | PRJEB50332 | 10532 | 221 | 2.03125 | 4.4890625 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 4.16e-28 | NR | KAG1703166.1 | 4784 | g10450 | i0 | 71.6 | 5.93212669683258 | 74 | 20 | 99.1 | 1 | 1 | 219 | 23 | 96 | KAG1703166.1 hypothetical protein DVH05_008077 [Phytophthora capsici] | diamond | 1311 | 109 | 0.990825688073395 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 30570406 | 30570406 | PRJEB50332_P_NODE_9013_length_230_cov_1.449704_g8931_i0 | PRJEB50332 | 9013 | 230 | 1.449704 | 3.3343192 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 7.19e-11 | NR | KAH9184750.1 | 100861 | g8931 | i0 | 52.1 | 0.952173913043478 | 73 | 33 | 92.6 | 1 | 215 | 3 | 130 | 202 | KAH9184750.1 hypothetical protein AeNC1_013271, partial [Aphanomyces euteiches] | diamond | 219 | 67 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 30602123 | 30602123 | PRJEB50332_P_NODE_9293_length_228_cov_1.754491_g9211_i0 | PRJEB50332 | 9293 | 228 | 1.754491 | 4.00023948 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 71.2 | 1.72e-12 | NR | KAF0750677.1 | 112090 | g9211 | i0 | 54.7 | 0.986842105263158 | 75 | 31 | 94.7 | 2 | 221 | 6 | 155 | 229 | KAF0750677.1 hypothetical protein AaE_006624 [Aphanomyces astaci] | diamond | 225 | 71.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 31360870 | 31360870 | PRJEB50332_P_NODE_17476_length_202_cov_2.297872_g17394_i0 | PRJEB50332 | 17476 | 202 | 2.297872 | 4.64170144 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00244 | NR | CCA25018.1 | 890382 | g17394 | i0 | 37.7 | 1.75247524752475 | 53 | 31 | 75.7 | 1 | 199 | 47 | 420 | 472 | CCA25018.1 Rab7 family GTPase putative [Albugo laibachii Nc14] | diamond | 354 | 45.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 31765119 | 31765119 | PRJEB50332_P_NODE_5017_length_272_cov_2.279621_g4935_i0 | PRJEB50332 | 5017 | 272 | 2.279621 | 6.20056912 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 8.83e-9 | NR | KAI9996507.1 | 4787 | g4935 | i0 | 59.6 | 10.9963235294118 | 52 | 21 | 57.4 | 0 | 13 | 168 | 684 | 735 | KAI9996507.1 hypothetical protein PInf_014235 [Phytophthora infestans] | diamond | 2991 | 62 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 32025053 | 32025053 | PRJEB50332_P_NODE_4218_length_290_cov_2.122271_g4136_i0 | PRJEB50332 | 4218 | 290 | 2.122271 | 6.1545859 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 5.78e-9 | NR | KAJ0404901.1 | 114742 | g4136 | i0 | 60.4 | 2.48275862068966 | 48 | 19 | 49.7 | 0 | 2 | 145 | 486 | 533 | KAJ0404901.1 hypothetical protein P43SY_001813 [Pythium insidiosum] | diamond | 720 | 62.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 32594524 | 32594524 | PRJEB50332_P_NODE_14440_length_208_cov_0.884354_g14358_i0 | PRJEB50332 | 14440 | 208 | 0.884354 | 1.83945632 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 2.81e-4 | NR | XP_009825362.1 | 112090 | g14358 | i0 | 50 | 3 | 52 | 25 | 73.6 | 1 | 203 | 51 | 368 | 419 | XP_009825362.1 hypothetical protein H257_03107 [Aphanomyces astaci] | diamond | 624 | 48.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci |
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);;