contig_metadata
20 rows where bioproject = "PRJNA473641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 445225 | 445225 | PRJNA473641_P_NODE_2921_length_503_cov_1.374419_g2838_i0 | PRJNA473641 | 2921 | 503 | 1.374419 | 6.91332757 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 229 | 3.82e-69 | NR | OQR94786.1 | 74557 | g2838 | i0 | 71.9 | 10.9562624254473 | 167 | 47 | 99.6 | 0 | 2 | 502 | 320 | 486 | OQR94786.1 chaperonin CPN60-1, mitochondrial precursor [Thraustotheca clavata] | diamond | 5511 | 230 | 0.995652173913044 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Thraustotheca | Thraustotheca clavata | ||
| 5548696 | 5548696 | PRJNA473641_P_NODE_2225_length_564_cov_1.602851_g2143_i0 | PRJNA473641 | 2225 | 564 | 1.602851 | 9.04007964 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 7.91e-115 | NTclustered | gi|166043465|emb|CU359703.1| | 100861 | g2143 | i0 | 83.058 | 69.7978723404255 | 484 | 68 | 85 | 12 | 44 | 520 | 529 | 53 | Aphanomyces euteiches cDNA | blastn | 39366 | 427 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 5548804 | 5548804 | PRJNA473641_P_NODE_2625_length_525_cov_1.586283_g2542_i0 | PRJNA473641 | 2625 | 525 | 1.586283 | 8.32798575 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 146 | 7.029999999999998e-42 | NR | DBA05327.1 | 4803 | g2542 | i0 | 64.8 | 7.90285714285714 | 105 | 37 | 60 | 0 | 199 | 513 | 1 | 105 | DBA05327.1 TPA: hypothetical protein N0F65_007489 [Lagenidium giganteum] | diamond | 4149 | 146 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 6822885 | 6822885 | PRJNA473641_P_NODE_6026_length_378_cov_1.570492_g5943_i0 | PRJNA473641 | 6026 | 378 | 1.570492 | 5.93645976 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 9.6e-33 | NTclustered | gi|166036439|emb|CU349481.1| | 100861 | g5943 | i0 | 80.905 | 6.48412698412698 | 199 | 34 | 52 | 2 | 3 | 199 | 558 | 754 | Aphanomyces euteiches cDNA | blastn | 2451 | 154 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 9372620 | 9372620 | PRJNA473641_P_NODE_14368_length_273_cov_1.570000_g14285_i0 | PRJNA473641 | 14368 | 273 | 1.57 | 4.2861 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.39e-59 | NTclustered | gi|698785784|ref|XM_009827634.1| | 112090 | g14285 | i0 | 86.425 | 95.1648351648352 | 221 | 30 | 81 | 0 | 26 | 246 | 163 | 383 | Aphanomyces astaci histone H3 partial mRNA | blastn | 25980 | 243 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 11298704 | 11298704 | PRJNA473641_P_NODE_3669_length_459_cov_5.196891_g3586_i0 | PRJNA473641 | 3669 | 459 | 5.196891 | 23.85372969 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 4.12e-57 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g3586 | i0 | 84.979 | 68.3050108932462 | 233 | 34 | 51 | 1 | 226 | 457 | 299 | 67 | Aphanomyces astaci polyubiquitin mRNA | blastn | 31352 | 235 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 18296464 | 18296464 | PRJNA473641_P_NODE_14175_length_275_cov_1.500000_g14092_i0 | PRJNA473641 | 14175 | 275 | 1.5 | 4.125 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 5.21e-34 | NTclustered | gi|698810055|ref|XM_009839755.1| | 112090 | g14092 | i0 | 77.407 | 1.82909090909091 | 270 | 58 | 98 | 3 | 1 | 269 | 1106 | 839 | Aphanomyces astaci transitional endoplasmic reticulum ATPase mRNA | blastn | 503 | 158 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 18296648 | 18296648 | PRJNA473641_P_NODE_21255_length_246_cov_0.890173_g21172_i0 | PRJNA473641 | 21255 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 2.0799999999999994e-23 | NR | XP_008865564.1 | 157072 | g21172 | i0 | 64.6 | 23.1341463414634 | 79 | 28 | 96.3 | 0 | 3 | 239 | 895 | 973 | XP_008865564.1 hypothetical protein H310_03471 [Aphanomyces invadans] | diamond | 5691 | 104 | 0.990384615384615 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 24047419 | 24047419 | PRJNA473641_P_NODE_21499_length_246_cov_0.890173_g21416_i0 | PRJNA473641 | 21499 | 246 | 0.890173 | 2.18982558 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 94.4 | 1.72e-20 | NR | KAF1329210.1 | 82926 | g21416 | i0 | 71 | 12.2682926829268 | 62 | 18 | 75.6 | 0 | 244 | 59 | 359 | 420 | KAF1329210.1 Cell division cycle protein 20, partial [Globisporangium splendens] | diamond | 3018 | 95.1 | 0.992639327024185 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 28023822 | 28023822 | PRJNA473641_P_NODE_25225_length_242_cov_0.911243_g25142_i0 | PRJNA473641 | 25225 | 242 | 0.911243 | 2.20520806 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 1.62e-8 | NR | KAF0694748.1 | 120398 | g25142 | i0 | 52.6 | 1.41322314049587 | 57 | 20 | 70.7 | 1 | 172 | 2 | 5 | 54 | KAF0694748.1 hypothetical protein As57867_014370 [Aphanomyces stellatus] | diamond | 342 | 59.7 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 28197633 | 28197633 | PRJNA473641_P_NODE_6746_length_363_cov_2.244828_g6663_i0 | PRJNA473641 | 6746 | 363 | 2.244828 | 8.14872564 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 2.38e-43 | NR | TMW65749.1 | 41045 | g6663 | i0 | 73.1 | 5.4297520661157 | 104 | 26 | 86 | 1 | 314 | 3 | 26 | 127 | TMW65749.1 hypothetical protein Poli38472_008391 [Pythium oligandrum] | diamond | 1971 | 150 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 28892190 | 28892190 | PRJNA473641_P_NODE_6528_length_367_cov_5.411565_g6445_i0 | PRJNA473641 | 6528 | 367 | 5.411565 | 19.86044355 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 3.4600000000000003e-29 | NR | RHY32367.1 | 157072 | g6445 | i0 | 69 | 3.29427792915531 | 100 | 31 | 81.7 | 0 | 28 | 327 | 171 | 270 | RHY32367.1 hypothetical protein DYB32_003166 [Aphanomyces invadans] | diamond | 1209 | 122 | 0.991803278688525 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 29239779 | 29239779 | PRJNA473641_P_NODE_18789_length_249_cov_0.875000_g18706_i0 | PRJNA473641 | 18789 | 249 | 0.875 | 2.17875 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 4.73e-9 | NR | KAG9400180.1 | 112091 | g18706 | i0 | 45.7 | 4.19277108433735 | 70 | 38 | 84.3 | 0 | 17 | 226 | 534 | 603 | KAG9400180.1 AP-4 complex subunit beta-1 [Aphanomyces cochlioides] | diamond | 1044 | 62.4 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces cochlioides | ||
| 29618244 | 29618244 | PRJNA473641_P_NODE_16170_length_258_cov_0.935135_g16087_i0 | PRJNA473641 | 16170 | 258 | 0.935135 | 2.4126483 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00193 | NR | TMW60351.1 | 41045 | g16087 | i0 | 37.9 | 2.36046511627907 | 87 | 43 | 98.8 | 3 | 3 | 257 | 81 | 158 | TMW60351.1 hypothetical protein Poli38472_000393 [Pythium oligandrum] | diamond | 609 | 46.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 30755928 | 30755928 | PRJNA473641_P_NODE_6454_length_369_cov_1.395270_g6371_i0 | PRJNA473641 | 6454 | 369 | 1.39527 | 5.1485463 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 1.71e-26 | NR | XP_008864102.1 | 157072 | g6371 | i0 | 45.8 | 10.5528455284553 | 118 | 62 | 95.9 | 1 | 362 | 9 | 67 | 182 | XP_008864102.1 hypothetical protein H310_02387, partial [Aphanomyces invadans] | diamond | 3894 | 107 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 31024106 | 31024106 | PRJNA473641_P_NODE_10475_length_310_cov_2.299578_g10392_i0 | PRJNA473641 | 10475 | 310 | 2.299578 | 7.1286918 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 1.36e-31 | NR | XP_008616217.1 | 1156394 | g10392 | i0 | 65.2 | 2.67096774193548 | 69 | 24 | 66.8 | 0 | 295 | 89 | 9 | 77 | XP_008616217.1 hypothetical protein SDRG_11941 [Saprolegnia diclina VS20] | diamond | 828 | 116 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 31388114 | 31388114 | PRJNA473641_P_NODE_5036_length_404_cov_4.000000_g4953_i0 | PRJNA473641 | 5036 | 404 | 4 | 16.16 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 3.74e-35 | NR | DBA05427.1 | 4803 | g4953 | i0 | 70.5 | 6.02227722772277 | 88 | 26 | 65.3 | 0 | 379 | 116 | 1 | 88 | DBA05427.1 TPA: hypothetical protein N0F65_007589, partial [Lagenidium giganteum] | diamond | 2433 | 127 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 32242400 | 32242400 | PRJNA473641_P_NODE_14758_length_270_cov_1.274112_g14675_i0 | PRJNA473641 | 14758 | 270 | 1.274112 | 3.4401024 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 3.4e-9 | NR | KAH9124220.1 | 100861 | g14675 | i0 | 64.3 | 6.37777777777778 | 42 | 15 | 46.7 | 0 | 1 | 126 | 308 | 349 | KAH9124220.1 hypothetical protein AeMF1_004971 [Aphanomyces euteiches] | diamond | 1722 | 63.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 32352742 | 32352742 | PRJNA473641_P_NODE_22259_length_245_cov_0.895349_g22176_i0 | PRJNA473641 | 22259 | 245 | 0.895349 | 2.19360505 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 1.24e-30 | NR | TMW59720.1 | 41045 | g22176 | i0 | 74.1 | 6.94285714285714 | 81 | 21 | 99.2 | 0 | 243 | 1 | 178 | 258 | TMW59720.1 hypothetical protein Poli38472_004789 [Pythium oligandrum] | diamond | 1701 | 123 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 32762799 | 32762799 | PRJNA473641_P_NODE_18080_length_250_cov_0.870056_g17997_i0 | PRJNA473641 | 18080 | 250 | 0.870056 | 2.17514 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 5.649999999999999e-23 | NR | KAJ0412463.1 | 114742 | g17997 | i0 | 59.5 | 1.776 | 74 | 30 | 88.8 | 0 | 29 | 250 | 174 | 247 | KAJ0412463.1 hypothetical protein ATCC90586_005483 [Pythium insidiosum] | diamond | 444 | 98.6 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum |
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);;