contig_metadata
25 rows where bioproject = "PRJNA1226487", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2885839 | 2885839 | PRJNA1226487_P_NODE_31343_length_313_cov_1.745833_g31241_i0 | PRJNA1226487 | 31343 | 313 | 1.745833 | 5.46445729 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 153 | 2.28e-41 | NR | OQS03226.1 | 74557 | g31241 | i0 | 73.5 | 4.87859424920128 | 102 | 26 | 96.8 | 1 | 11 | 313 | 173 | 274 | OQS03226.1 glucose-6-phosphate isomerase [Thraustotheca clavata] | diamond | 1527 | 154 | 0.993506493506494 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 4162110 | 4162110 | PRJNA1226487_P_NODE_984_length_963_cov_3.234831_g914_i0 | PRJNA1226487 | 984 | 963 | 3.234831 | 31.15142253 | root | 1 | Root_unresolved | Root_unresolved | 587 | 3.99e-205 | NR | KAG3217446.1 | 29920 | g914 | i0 | 91.4 | 10.7601246105919 | 314 | 27 | 97.8 | 0 | 961 | 20 | 363 | 676 | KAG3217446.1 Eukaryotic initiation factor [Phytophthora cactorum] | diamond | 10362 | 592 | 0.991554054054054 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cactorum | ||
| 8699838 | 8699838 | PRJNA1226487_P_NODE_50667_length_271_cov_6.151515_g50565_i0 | PRJNA1226487 | 50667 | 271 | 6.151515 | 16.67060565 | root | 1 | Root_unresolved | Root_unresolved | 501 | 2.05e-137 | NTclustered | gi|166046604|emb|CU367721.1| | 100861 | g50565 | i0 | 100 | 89.4612546125461 | 271 | 0 | 100 | 0 | 1 | 271 | 259 | 529 | Aphanomyces euteiches cDNA | blastn | 24244 | 501 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 13088543 | 13088543 | PRJNA1226487_P_NODE_16211_length_384_cov_5.411576_g16109_i0 | PRJNA1226487 | 16211 | 384 | 5.411576 | 20.78045184 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 8.429999999999998e-39 | NR | KAJ8527431.1 | 4785 | g16109 | i0 | 78 | 4.109375 | 100 | 20 | 78.1 | 1 | 83 | 382 | 36 | 133 | KAJ8527431.1 hypothetical protein ON010_g14832 [Phytophthora cinnamomi] | diamond | 1578 | 150 | 0.993333333333333 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 13088767 | 13088767 | PRJNA1226487_P_NODE_911_length_988_cov_3.147541_g842_i0 | PRJNA1226487 | 911 | 988 | 3.147541 | 31.09770508 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 409 | 1.4299999999999999e-139 | NR | XP_024573126.1 | 4781 | g842 | i0 | 62.3 | 7.67307692307692 | 326 | 107 | 98.7 | 4 | 976 | 2 | 12 | 322 | XP_024573126.1 nucleotide-binding protein 1 [Plasmopara halstedii] | diamond | 7581 | 412 | 0.992718446601942 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 14363900 | 14363900 | PRJNA1226487_P_NODE_3232_length_646_cov_11.668412_g3141_i0 | PRJNA1226487 | 3232 | 646 | 11.668412 | 75.37794152 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 2.08e-76 | NTclustered | gi|325196715|emb|FR827504.1| | 890382 | g3141 | i0 | 95.238 | 0.292569659442724 | 189 | 9 | 29 | 0 | 87 | 275 | 1 | 189 | Albugo laibachii Nc14, genomic contig CONTIG_4671_NC14_v4_189_105 | blastn | 189 | 300 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 15637806 | 15637806 | PRJNA1226487_P_NODE_3293_length_642_cov_4.360281_g3202_i0 | PRJNA1226487 | 3293 | 642 | 4.360281 | 27.99300402 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 247 | 3.63e-76 | NR | KAH9108398.1 | 100861 | g3202 | i0 | 83.7 | 3.29439252336449 | 141 | 23 | 65.9 | 0 | 638 | 216 | 340 | 480 | KAH9108398.1 hypothetical protein AeMF1_016428 [Aphanomyces euteiches] | diamond | 2115 | 249 | 0.991967871485944 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 22011691 | 22011691 | PRJNA1226487_P_NODE_5058_length_554_cov_5.407484_g4965_i0 | PRJNA1226487 | 5058 | 554 | 5.407484 | 29.95746136 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 221 | 5.64e-63 | NR | XP_067817212.1 | 4779 | g4965 | i0 | 64.5 | 23.2148014440433 | 152 | 53 | 82.3 | 1 | 552 | 97 | 916 | 1066 | XP_067817212.1 hypothetical protein CCR75_001963 [Bremia lactucae] | diamond | 12861 | 223 | 0.991031390134529 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 26964897 | 26964897 | PRJNA1226487_P_NODE_80422_length_234_cov_2.012422_g80320_i0 | PRJNA1226487 | 80422 | 234 | 2.012422 | 4.70906748 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 2.54e-28 | NR | KAG1703166.1 | 4784 | g80320 | i0 | 72.2 | 5.52564102564103 | 72 | 20 | 92.3 | 0 | 222 | 7 | 30 | 101 | KAG1703166.1 hypothetical protein DVH05_008077 [Phytophthora capsici] | diamond | 1293 | 109 | 0.990825688073395 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora capsici | ||
| 27515126 | 27515126 | PRJNA1226487_P_NODE_33043_length_307_cov_6.414530_g32941_i0 | PRJNA1226487 | 33043 | 307 | 6.41453 | 19.6926071 | Thraustotheca clavata | 74557 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 4.2e-46 | NR | OQS00430.1 | 74557 | g32941 | i0 | 75.2 | 95.7459283387622 | 101 | 25 | 98.7 | 0 | 304 | 2 | 1157 | 1257 | OQS00430.1 pre-mRNA-splicing factor ATP-dependent RNA helicase PRP16 [Thraustotheca clavata] | diamond | 29394 | 169 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 28272701 | 28272701 | PRJNA1226487_P_NODE_10686_length_437_cov_3.920330_g10586_i0 | PRJNA1226487 | 10686 | 437 | 3.92033 | 17.1318421 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 8.69e-5 | NR | XP_009837118.1 | 112090 | g10586 | i0 | 31.6 | 0.782608695652174 | 114 | 58 | 78.3 | 3 | 8 | 349 | 303 | 396 | XP_009837118.1 hypothetical protein H257_11789 [Aphanomyces astaci] | diamond | 342 | 52.8 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 28620386 | 28620386 | PRJNA1226487_P_NODE_5467_length_540_cov_2.188437_g5374_i0 | PRJNA1226487 | 5467 | 540 | 2.188437 | 11.8175598 | Albugo laibachii Nc14 | 890382 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 8.33e-6 | NR | CCA18228.1 | 890382 | g5374 | i0 | 45.1 | 0.394444444444444 | 71 | 34 | 38.9 | 2 | 266 | 475 | 1575 | 1641 | CCA18228.1 nuclear pore complex protein putative [Albugo laibachii Nc14] | diamond | 213 | 57 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 28702210 | 28702210 | PRJNA1226487_P_NODE_1167_length_908_cov_3.094611_g1092_i0 | PRJNA1226487 | 1167 | 908 | 3.094611 | 28.09906788 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 8.81e-68 | NR | TMW66537.1 | 41045 | g1092 | i0 | 42.6 | 6.02312775330396 | 303 | 160 | 99.8 | 2 | 3 | 908 | 228 | 517 | TMW66537.1 hypothetical protein Poli38472_004302 [Pythium oligandrum] | diamond | 5469 | 235 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 29775490 | 29775490 | PRJNA1226487_P_NODE_211_length_1571_cov_2.357810_g177_i0 | PRJNA1226487 | 211 | 1571 | 2.35781 | 37.0411951 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 288 | 5.66e-83 | NR | KAJ8527496.1 | 4785 | g177 | i0 | 33.8 | 8.21323997453851 | 536 | 303 | 94.3 | 9 | 3 | 1484 | 119 | 644 | KAJ8527496.1 hypothetical protein ON010_g14767 [Phytophthora cinnamomi] | diamond | 12903 | 288 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 30072663 | 30072663 | PRJNA1226487_P_NODE_27792_length_325_cov_3.781746_g27690_i0 | PRJNA1226487 | 27792 | 325 | 3.781746 | 12.2906745 | [Pythium] brassicae (nom. inval.) | 1485010 | SAR_Eukaryotes | SAR_Eukaryotes | 96.7 | 9.42e-23 | NR | TYZ64398.1 | 1485010 | g27690 | i0 | 47.3 | 4.29230769230769 | 93 | 46 | 84 | 2 | 320 | 48 | 70 | 161 | TYZ64398.1 hypothetical protein PybrP1_012361 [[Pythium] brassicae (nom. inval.)] | diamond | 1395 | 96.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | [Pythium] brassicae (nom. inval.) | ||
| 30376307 | 30376307 | PRJNA1226487_P_NODE_792_length_1033_cov_10.064583_g725_i0 | PRJNA1226487 | 792 | 1033 | 10.064583 | 103.96714239 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 396 | 6.759999999999998e-134 | NR | TMW59772.1 | 41045 | g725 | i0 | 59.3 | 6.25847047434656 | 307 | 121 | 89.2 | 1 | 68 | 988 | 65 | 367 | TMW59772.1 hypothetical protein Poli38472_004841 [Pythium oligandrum] | diamond | 6465 | 397 | 0.997481108312343 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 30407775 | 30407775 | PRJNA1226487_P_NODE_793_length_1033_cov_8.782292_g725_i1 | PRJNA1226487 | 793 | 1033 | 8.782292 | 90.72107636 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 393 | 7.799999999999999e-133 | NR | TMW59772.1 | 41045 | g725 | i1 | 59 | 6.25847047434656 | 307 | 122 | 89.2 | 1 | 966 | 46 | 65 | 367 | TMW59772.1 hypothetical protein Poli38472_004841 [Pythium oligandrum] | diamond | 6465 | 394 | 0.99746192893401 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 30691761 | 30691761 | PRJNA1226487_P_NODE_5453_length_540_cov_5.554604_g5360_i0 | PRJNA1226487 | 5453 | 540 | 5.554604 | 29.9948616 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 186 | 2.09e-51 | NR | DAZ95743.1 | 4803 | g5360 | i0 | 49.1 | 14.7666666666667 | 175 | 88 | 97.2 | 1 | 526 | 2 | 518 | 691 | DAZ95743.1 TPA: hypothetical protein N0F65_006391 [Lagenidium giganteum] | diamond | 7974 | 186 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 30944712 | 30944712 | PRJNA1226487_P_NODE_2994_length_664_cov_3.676819_g2903_i0 | PRJNA1226487 | 2994 | 664 | 3.676819 | 24.41407816 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 94.7 | 2.39e-18 | NR | XP_067820601.1 | 4779 | g2903 | i0 | 34.9 | 6.80873493975904 | 166 | 95 | 73.2 | 4 | 496 | 11 | 646 | 802 | XP_067820601.1 hypothetical protein CCR75_003513 [Bremia lactucae] | diamond | 4521 | 94.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Bremia | Bremia lactucae | ||
| 31608518 | 31608518 | PRJNA1226487_P_NODE_17756_length_374_cov_1.637874_g17654_i0 | PRJNA1226487 | 17756 | 374 | 1.637874 | 6.12564876 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 4.74e-17 | NR | DAZ98651.1 | 4803 | g17654 | i0 | 63 | 3.4572192513369 | 54 | 20 | 43.3 | 0 | 367 | 206 | 481 | 534 | DAZ98651.1 TPA: hypothetical protein N0F65_000846 [Lagenidium giganteum] | diamond | 1293 | 87 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 31716251 | 31716251 | PRJNA1226487_P_NODE_16737_length_380_cov_7.781759_g16635_i0 | PRJNA1226487 | 16737 | 380 | 7.781759 | 29.5706842 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 94.4 | 5.93e-20 | NR | TMW62123.1 | 41045 | g16635 | i0 | 60.9 | 3.90789473684211 | 69 | 27 | 54.5 | 0 | 9 | 215 | 302 | 370 | TMW62123.1 hypothetical protein Poli38472_009616 [Pythium oligandrum] | diamond | 1485 | 94.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31988050 | 31988050 | PRJNA1226487_P_NODE_47618_length_276_cov_2.206897_g47516_i0 | PRJNA1226487 | 47618 | 276 | 2.206897 | 6.09103572 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 5.75e-5 | NR | KAK1945754.1 | 4793 | g47516 | i0 | 39.1 | 2.70652173913043 | 92 | 48 | 93.5 | 3 | 269 | 12 | 436 | 525 | KAK1945754.1 Calcium-dependent protein kinase 3 [Phytophthora citrophthora] | diamond | 747 | 51.6 | 0.992248062015504 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora citrophthora | ||
| 32273090 | 32273090 | PRJNA1226487_P_NODE_47518_length_276_cov_4.280788_g47416_i0 | PRJNA1226487 | 47518 | 276 | 4.280788 | 11.81497488 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 2.41e-44 | NR | XP_024584861.1 | 4781 | g47416 | i0 | 76.4 | 12.5760869565217 | 89 | 21 | 96.7 | 0 | 271 | 5 | 75 | 163 | XP_024584861.1 adp-ribosylation factor [Plasmopara halstedii] | diamond | 3471 | 152 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 32475768 | 32475768 | PRJNA1226487_P_NODE_12419_length_417_cov_3.732558_g12319_i0 | PRJNA1226487 | 12419 | 417 | 3.732558 | 15.56476686 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 2.36e-8 | NR | TMW61112.1 | 41045 | g12319 | i0 | 39.2 | 0.733812949640288 | 102 | 58 | 71.9 | 3 | 14 | 313 | 80 | 179 | TMW61112.1 hypothetical protein Poli38472_013575 [Pythium oligandrum] | diamond | 306 | 62.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 32589363 | 32589363 | PRJNA1226487_P_NODE_1119_length_924_cov_1.990599_g1044_i0 | PRJNA1226487 | 1119 | 924 | 1.990599 | 18.39313476 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 88.2 | 2.05e-15 | NR | OWY97301.1 | 4795 | g1044 | i0 | 48 | 1.80519480519481 | 102 | 44 | 31.5 | 2 | 452 | 742 | 315 | 412 | OWY97301.1 60S ribosomal export protein nmd3 [Phytophthora megakarya] | diamond | 1668 | 88.6 | 0.99548532731377 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora megakarya |
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);;