contig_metadata
20 rows where bioproject = "PRJNA594101", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 566984 | 566984 | PRJNA594101_S_NODE_20841_length_367_cov_4.306122_g20539_i0 | PRJNA594101 | 20841 | 367 | 4.306122 | 15.80346774 | Fungi | 4751 | Fungi | Fungi | 114 | 3.95e-30 | NR | KAI9221418.1 | 64508 | g20539 | i0 | 60.4 | 19.8310626702997 | 91 | 36 | 74.4 | 0 | 6 | 278 | 20 | 110 | KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica] | diamond | 7278 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 3117843 | 3117843 | PRJNA594101_S_NODE_10043_length_517_cov_3.664414_g9743_i0 | PRJNA594101 | 10043 | 517 | 3.664414 | 18.94502038 | Fungi | 4751 | Fungi | Fungi | 197 | 2.79e-59 | NR | KAI9136705.1 | 1500003 | g9743 | i0 | 49.7 | 26.100580270793 | 173 | 86 | 99.8 | 1 | 517 | 2 | 138 | 310 | KAI9136705.1 kinase-like domain-containing protein [Paraphysoderma sedebokerense] | diamond | 13494 | 197 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 27662003 | 27662003 | PRJNA594101_S_NODE_4724_length_744_cov_1.712370_g4449_i0 | PRJNA594101 | 4724 | 744 | 1.71237 | 12.7400328 | Eukaryota | 2759 | Fungi | Fungi | 64.3 | 8.77e-8 | NR | KAI9164214.1 | 1313167 | g4449 | i0 | 30.4 | 3.12096774193548 | 161 | 98 | 60.5 | 6 | 111 | 560 | 337 | 494 | KAI9164214.1 hypothetical protein H9P43_008031 [Blastocladiella emersonii ATCC 22665] | diamond | 2322 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 28058848 | 28058848 | PRJNA594101_S_NODE_44705_length_261_cov_1.638298_g44403_i0 | PRJNA594101 | 44705 | 261 | 1.638298 | 4.27595778 | Blastocladiella britannica | 64508 | Fungi | Fungi | 70.9 | 4.81e-12 | NR | KAI9219447.1 | 64508 | g44403 | i0 | 58.2 | 0.632183908045977 | 55 | 23 | 63.2 | 0 | 176 | 12 | 199 | 253 | KAI9219447.1 guanine-1-methyltransferase-domain-containing protein [Blastocladiella britannica] | diamond | 165 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 28279699 | 28279699 | PRJNA594101_S_NODE_33146_length_299_cov_1.681416_g32844_i0 | PRJNA594101 | 33146 | 299 | 1.681416 | 5.02743384 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 47.8 | 0.00114 | NR | KAI9143263.1 | 1500003 | g32844 | i0 | 41 | 0.752508361204013 | 39 | 23 | 39.1 | 0 | 226 | 110 | 269 | 307 | KAI9143263.1 WD40 repeat-like protein [Paraphysoderma sedebokerense] | diamond | 225 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28406294 | 28406294 | PRJNA594101_S_NODE_5866_length_672_cov_2.076795_g5577_i0 | PRJNA594101 | 5866 | 672 | 2.076795 | 13.9560624 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 119 | 9.72e-27 | NR | KAI9168472.1 | 1313167 | g5577 | i0 | 59.3 | 1.98214285714286 | 91 | 37 | 40.6 | 0 | 320 | 48 | 409 | 499 | KAI9168472.1 Ribosome biogenesis protein erb1 [Blastocladiella emersonii ATCC 22665] | diamond | 1332 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 28482778 | 28482778 | PRJNA594101_S_NODE_35606_length_290_cov_1.354839_g35304_i0 | PRJNA594101 | 35606 | 290 | 1.354839 | 3.9290331 | Eukaryota | 2759 | Fungi | Fungi | 43.5 | 0.0351 | NR | KAI9188937.1 | 1313167 | g35304 | i0 | 28.8 | 3.43448275862069 | 80 | 52 | 82.8 | 2 | 283 | 44 | 335 | 409 | KAI9188937.1 hypothetical protein H9P43_000359 [Blastocladiella emersonii ATCC 22665] | diamond | 996 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 28501016 | 28501016 | PRJNA594101_S_NODE_32227_length_303_cov_1.339130_g31925_i0 | PRJNA594101 | 32227 | 303 | 1.33913 | 4.0575639 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 56.6 | 1e-6 | NR | KNE61278.1 | 578462 | g31925 | i0 | 40.6 | 0.95049504950495 | 96 | 42 | 90.1 | 3 | 14 | 286 | 171 | 256 | KNE61278.1 hypothetical protein AMAG_07020 [Allomyces macrogynus ATCC 38327] | diamond | 288 | 56.6 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 28672329 | 28672329 | PRJNA594101_S_NODE_24267_length_343_cov_1.370370_g23965_i0 | PRJNA594101 | 24267 | 343 | 1.37037 | 4.7003691 | Eukaryota | 2759 | Fungi | Fungi | 45.1 | 0.00538 | NR | ORZ38358.1 | 765915 | g23965 | i0 | 45.5 | 1.60932944606414 | 44 | 22 | 37.6 | 2 | 131 | 3 | 40 | 82 | ORZ38358.1 ubiquitin-conjugating enzyme/RWD-like protein [Catenaria anguillulae PL171] | diamond | 552 | 45.4 | 0.993392070484582 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 29429770 | 29429770 | PRJNA594101_S_NODE_57169_length_241_cov_1.375000_g56867_i0 | PRJNA594101 | 57169 | 241 | 1.375 | 3.31375 | root | 1 | Root_unresolved | Root_unresolved | 126 | 5.919999999999999e-32 | NR | KAI9143012.1 | 1500003 | g56867 | i0 | 76.3 | 20.1161825726141 | 76 | 17 | 94.6 | 1 | 229 | 2 | 311 | 385 | KAI9143012.1 ATP-utilizing phosphoenolpyruvate carboxykinase [Paraphysoderma sedebokerense] | diamond | 4848 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29524796 | 29524796 | PRJNA594101_S_NODE_56390_length_242_cov_1.153846_g56088_i0 | PRJNA594101 | 56390 | 242 | 1.153846 | 2.79230732 | Opisthokonta | 33154 | Fungi | Fungi | 75.9 | 7.97e-14 | NR | KAI9136818.1 | 1500003 | g56088 | i0 | 49.3 | 10.797520661157 | 75 | 37 | 91.7 | 1 | 242 | 21 | 153 | 227 | KAI9136818.1 oxoglutarate dehydrogenase, E1 component [Paraphysoderma sedebokerense] | diamond | 2613 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29556118 | 29556118 | PRJNA594101_S_NODE_40070_length_275_cov_1.143564_g39768_i0 | PRJNA594101 | 40070 | 275 | 1.143564 | 3.144801 | Blastocladiales | 4805 | Fungi | Fungi | 75.1 | 2.27e-13 | NR | ORZ39888.1 | 765915 | g39768 | i0 | 41.9 | 1.87636363636364 | 86 | 50 | 93.8 | 0 | 271 | 14 | 201 | 286 | ORZ39888.1 glutamine synthetase type III N terminal-domain-containing protein [Catenaria anguillulae PL171] | diamond | 516 | 75.5 | 0.994701986754967 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 29935365 | 29935365 | PRJNA594101_S_NODE_43651_length_264_cov_1.596859_g43349_i0 | PRJNA594101 | 43651 | 264 | 1.596859 | 4.21570776 | Allomyces | 28581 | Fungi | Fungi | 112 | 2.6900000000000003e-27 | NR | KAJ3372924.1 | 64504 | g43349 | i0 | 57.8 | 2.82954545454545 | 83 | 35 | 94.3 | 0 | 5 | 253 | 222 | 304 | KAJ3372924.1 Deoxycytidine monophosphate (dCMP) deaminase [Allomyces arbusculus] | diamond | 747 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 29998522 | 29998522 | PRJNA594101_S_NODE_16491_length_409_cov_3.833333_g16189_i0 | PRJNA594101 | 16491 | 409 | 3.833333 | 15.67833197 | root | 1 | Root_unresolved | Root_unresolved | 79.3 | 3.16e-14 | NR | KAI9189815.1 | 1313167 | g16189 | i0 | 42.1 | 1.85574572127139 | 126 | 68 | 88.8 | 3 | 44 | 406 | 106 | 231 | KAI9189815.1 Protoheme IX farnesyltransferase, mitochondrial [Blastocladiella emersonii ATCC 22665] | diamond | 759 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 30142642 | 30142642 | PRJNA594101_S_NODE_7312_length_604_cov_2.024482_g7015_i0 | PRJNA594101 | 7312 | 604 | 2.024482 | 12.22787128 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 47.4 | 0.021 | NR | KAI9138354.1 | 1500003 | g7015 | i0 | 43.2 | 0.218543046357616 | 44 | 25 | 21.9 | 0 | 588 | 457 | 61 | 104 | KAI9138354.1 hypothetical protein BKA69DRAFT_1092452, partial [Paraphysoderma sedebokerense] | diamond | 132 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 30838023 | 30838023 | PRJNA594101_S_NODE_16274_length_412_cov_1.941003_g15972_i0 | PRJNA594101 | 16274 | 412 | 1.941003 | 7.99693236 | Blastocladiella britannica | 64508 | Fungi | Fungi | 149 | 6.4699999999999986e-40 | NR | KAI9218564.1 | 64508 | g15972 | i0 | 54.1 | 1.95145631067961 | 133 | 57 | 96.8 | 2 | 13 | 411 | 26 | 154 | KAI9218564.1 HD phosphohydrolase domain-containing protein [Blastocladiella britannica] | diamond | 804 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 31375480 | 31375480 | PRJNA594101_S_NODE_43836_length_264_cov_1.005236_g43534_i0 | PRJNA594101 | 43836 | 264 | 1.005236 | 2.65382304 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 47 | 0.00145 | NR | KNE63602.1 | 578462 | g43534 | i0 | 71.4 | 0.318181818181818 | 28 | 8 | 31.8 | 0 | 2 | 85 | 198 | 225 | KNE63602.1 glycoprotease/Kae1 family metallohydrolase [Allomyces macrogynus ATCC 38327] | diamond | 84 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 32021448 | 32021448 | PRJNA594101_S_NODE_318_length_2050_cov_43.731411_g253_i0 | PRJNA594101 | 318 | 2050 | 43.731411 | 896.4939255 | Allomyces | 28581 | Fungi | Fungi | 298 | 1.84e-84 | NR | KAJ3372639.1 | 64504 | g253 | i0 | 37.6 | 4.95512195121951 | 497 | 257 | 67.5 | 8 | 1845 | 463 | 387 | 866 | KAJ3372639.1 hypothetical protein GGF31_001660 [Allomyces arbusculus] | diamond | 10158 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 32432949 | 32432949 | PRJNA594101_S_NODE_35559_length_290_cov_1.442396_g35257_i0 | PRJNA594101 | 35559 | 290 | 1.442396 | 4.1829484 | Fungi | 4751 | Fungi | Fungi | 76.3 | 6.95e-14 | NR | KAI9219709.1 | 64508 | g35257 | i0 | 72.1 | 9.56896551724138 | 43 | 12 | 44.5 | 0 | 289 | 161 | 165 | 207 | KAI9219709.1 peptidase C14, caspase domain-containing protein [Blastocladiella britannica] | diamond | 2775 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 32860861 | 32860861 | PRJNA594101_S_NODE_58160_length_236_cov_2.766871_g57858_i0 | PRJNA594101 | 58160 | 236 | 2.766871 | 6.52981556 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 119 | 2.34e-30 | NR | ORZ39685.1 | 765915 | g57858 | i0 | 78.2 | 8.92372881355932 | 78 | 17 | 99.2 | 0 | 236 | 3 | 110 | 187 | ORZ39685.1 P-loop containing nucleoside triphosphate hydrolase protein [Catenaria anguillulae PL171] | diamond | 2106 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae |
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);;