contig_metadata
20 rows where bioproject = "PRJNA1022139", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3554143 | 3554143 | PRJNA1022139_P_NODE_8703_length_448_cov_1.570667_g8598_i0 | PRJNA1022139 | 8703 | 448 | 1.570667 | 7.03658816 | Fungi | 4751 | Fungi | Fungi | 214 | 3.69e-65 | NR | ORZ37063.1 | 765915 | g8598 | i0 | 70.7 | 7.90178571428571 | 147 | 43 | 98.4 | 0 | 447 | 7 | 232 | 378 | ORZ37063.1 thiolase [Catenaria anguillulae PL171] | diamond | 3540 | 214 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 11640173 | 11640173 | PRJNA1022139_P_NODE_22270_length_297_cov_1.870536_g22165_i0 | PRJNA1022139 | 22270 | 297 | 1.870536 | 5.55549192 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 95.5 | 2.1e-20 | NR | KAI9149871.1 | 1313167 | g22165 | i0 | 50 | 6.14141414141414 | 88 | 44 | 88.9 | 0 | 264 | 1 | 379 | 466 | KAI9149871.1 medium-chain fatty acid-CoA ligase faa2 [Blastocladiella emersonii ATCC 22665] | diamond | 1824 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 20562983 | 20562983 | PRJNA1022139_P_NODE_9637_length_428_cov_1.411268_g9532_i0 | PRJNA1022139 | 9637 | 428 | 1.411268 | 6.04022704 | Fungi | 4751 | Fungi | Fungi | 139 | 2.8199999999999997e-37 | NR | KAI9223353.1 | 64508 | g9532 | i0 | 52.1 | 4.98364485981308 | 144 | 54 | 99.5 | 2 | 428 | 3 | 25 | 155 | KAI9223353.1 hypothetical protein BC828DRAFT_410548 [Blastocladiella britannica] | diamond | 2133 | 140 | 0.992857142857143 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 27477328 | 27477328 | PRJNA1022139_P_NODE_23063_length_292_cov_1.831050_g22958_i0 | PRJNA1022139 | 23063 | 292 | 1.83105 | 5.346666 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 67 | 6.5500000000000006e-11 | NR | KAI9151193.1 | 1313167 | g22958 | i0 | 57.1 | 1.29452054794521 | 63 | 27 | 64.7 | 0 | 9 | 197 | 163 | 225 | KAI9151193.1 tRNA 2'-phosphotransferase [Blastocladiella emersonii ATCC 22665] | diamond | 378 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 28298226 | 28298226 | PRJNA1022139_P_NODE_40466_length_244_cov_0.900585_g40361_i0 | PRJNA1022139 | 40466 | 244 | 0.900585 | 2.1974274 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 49.3 | 1.87e-4 | NR | KNE55648.1 | 578462 | g40361 | i0 | 37.7 | 1.56147540983607 | 77 | 43 | 91 | 2 | 242 | 21 | 2637 | 2711 | KNE55648.1 hypothetical protein AMAG_01535 [Allomyces macrogynus ATCC 38327] | diamond | 381 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 28321990 | 28321990 | PRJNA1022139_P_NODE_43846_length_227_cov_2.961039_g43741_i0 | PRJNA1022139 | 43846 | 227 | 2.961039 | 6.72155853 | Fungi | 4751 | Fungi | Fungi | 56.2 | 3.97e-7 | NR | KAI9141841.1 | 1500003 | g43741 | i0 | 36.5 | 6.81938325991189 | 74 | 47 | 97.8 | 0 | 224 | 3 | 173 | 246 | KAI9141841.1 hypothetical protein BKA69DRAFT_1174834 [Paraphysoderma sedebokerense] | diamond | 1548 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28929760 | 28929760 | PRJNA1022139_P_NODE_17988_length_327_cov_1.818898_g17883_i0 | PRJNA1022139 | 17988 | 327 | 1.818898 | 5.94779646 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 109 | 3.03e-28 | NR | ORZ39709.1 | 765915 | g17883 | i0 | 50.9 | 0.990825688073395 | 108 | 53 | 99.1 | 0 | 2 | 325 | 6 | 113 | ORZ39709.1 ribosomal protein L14-domain-containing protein [Catenaria anguillulae PL171] | diamond | 324 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 29655560 | 29655560 | PRJNA1022139_P_NODE_3570_length_667_cov_3.117845_g3468_i0 | PRJNA1022139 | 3570 | 667 | 3.117845 | 20.79602615 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 62 | 3.84e-7 | NR | KAJ1515449.1 | 945690 | g3468 | i0 | 27.9 | 0.661169415292354 | 147 | 106 | 66.1 | 0 | 38 | 478 | 438 | 584 | KAJ1515449.1 hypothetical protein HMI56_004666 [Coelomomyces lativittatus] | diamond | 441 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 30690558 | 30690558 | PRJNA1022139_P_NODE_37873_length_247_cov_0.885057_g37768_i0 | PRJNA1022139 | 37873 | 247 | 0.885057 | 2.18609079 | Allomyces | 28581 | Fungi | Fungi | 58.5 | 1.1e-7 | NR | KAJ3362301.1 | 64504 | g37768 | i0 | 41 | 5.02834008097166 | 83 | 48 | 99.6 | 1 | 246 | 1 | 626 | 708 | KAJ3362301.1 Sec63 [Allomyces arbusculus] | diamond | 1242 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 30951395 | 30951395 | PRJNA1022139_P_NODE_16894_length_336_cov_1.171103_g16789_i0 | PRJNA1022139 | 16894 | 336 | 1.171103 | 3.93490608 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 129 | 1.6699999999999998e-32 | NR | KAI9152443.1 | 1313167 | g16789 | i0 | 58 | 1 | 112 | 45 | 99.1 | 2 | 333 | 1 | 154 | 264 | KAI9152443.1 hypothetical protein H9P43_009234 [Blastocladiella emersonii ATCC 22665] | diamond | 336 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 31481134 | 31481134 | PRJNA1022139_P_NODE_19336_length_317_cov_1.807377_g19231_i0 | PRJNA1022139 | 19336 | 317 | 1.807377 | 5.72938509 | Opisthokonta | 33154 | Fungi | Fungi | 101 | 1.57e-22 | NR | KAI9168422.1 | 1313167 | g19231 | i0 | 44.8 | 2.97160883280757 | 105 | 57 | 99.4 | 1 | 316 | 2 | 437 | 540 | KAI9168422.1 Dihydrosphingosine phosphate lyase [Blastocladiella emersonii ATCC 22665] | diamond | 942 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 31520403 | 31520403 | PRJNA1022139_P_NODE_25716_length_282_cov_1.473684_g25611_i0 | PRJNA1022139 | 25716 | 282 | 1.473684 | 4.15578888 | Blastocladiella britannica | 64508 | Fungi | Fungi | 48.1 | 7.49e-4 | NR | KAI9220524.1 | 64508 | g25611 | i0 | 35.1 | 0.819148936170213 | 77 | 48 | 79.8 | 2 | 227 | 3 | 41 | 117 | KAI9220524.1 major facilitator superfamily domain-containing protein [Blastocladiella britannica] | diamond | 231 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 31646652 | 31646652 | PRJNA1022139_P_NODE_5697_length_544_cov_1.738854_g5593_i0 | PRJNA1022139 | 5697 | 544 | 1.738854 | 9.45936576 | Blastocladiella britannica | 64508 | Fungi | Fungi | 99.4 | 1.69e-20 | NR | KAI9223501.1 | 64508 | g5593 | i0 | 38 | 2.73529411764706 | 163 | 92 | 84.9 | 3 | 514 | 53 | 222 | 384 | KAI9223501.1 Sec1-like protein [Blastocladiella britannica] | diamond | 1488 | 99.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 31923578 | 31923578 | PRJNA1022139_P_NODE_1377_length_1016_cov_1.977731_g1311_i0 | PRJNA1022139 | 1377 | 1016 | 1.977731 | 20.09374696 | Opisthokonta | 33154 | Fungi | Fungi | 291 | 1.0599999999999998e-85 | NR | KAI9224066.1 | 64508 | g1311 | i0 | 45.3 | 38.9261811023622 | 338 | 182 | 99.8 | 2 | 1015 | 2 | 415 | 749 | KAI9224066.1 splicing factor 3B subunit 1 [Blastocladiella britannica] | diamond | 39549 | 293 | 0.993174061433447 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 31994786 | 31994786 | PRJNA1022139_P_NODE_19178_length_318_cov_2.436735_g19073_i0 | PRJNA1022139 | 19178 | 318 | 2.436735 | 7.7488173 | Blastocladiella britannica | 64508 | Fungi | Fungi | 43.5 | 0.0444 | NR | KAI9220896.1 | 64508 | g19073 | i0 | 27.5 | 0.962264150943396 | 102 | 57 | 90.6 | 3 | 304 | 17 | 28 | 118 | KAI9220896.1 hypothetical protein BC828DRAFT_382400 [Blastocladiella britannica] | diamond | 306 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 32057995 | 32057995 | PRJNA1022139_P_NODE_17738_length_329_cov_1.652344_g17633_i0 | PRJNA1022139 | 17738 | 329 | 1.652344 | 5.43621176 | Blastocladiella britannica | 64508 | Fungi | Fungi | 54.3 | 5.53e-6 | NR | KAI9220248.1 | 64508 | g17633 | i0 | 42 | 2.89969604863222 | 81 | 40 | 72 | 2 | 2 | 238 | 143 | 218 | KAI9220248.1 phosphatase 2C-like domain-containing protein, partial [Blastocladiella britannica] | diamond | 954 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 32216379 | 32216379 | PRJNA1022139_P_NODE_7138_length_491_cov_2.112440_g7033_i0 | PRJNA1022139 | 7138 | 491 | 2.11244 | 10.3720804 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 45.4 | 0.0477 | NR | ORZ41216.1 | 765915 | g7033 | i0 | 29.9 | 0.592668024439919 | 97 | 61 | 59.3 | 3 | 350 | 60 | 292 | 381 | ORZ41216.1 hypothetical protein BCR44DRAFT_60341 [Catenaria anguillulae PL171] | diamond | 291 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 32311508 | 32311508 | PRJNA1022139_P_NODE_33319_length_254_cov_1.635359_g33214_i0 | PRJNA1022139 | 33319 | 254 | 1.635359 | 4.15381186 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 43.5 | 0.0226 | NR | KAJ1504375.1 | 945690 | g33214 | i0 | 44.7 | 0.897637795275591 | 38 | 21 | 44.9 | 0 | 81 | 194 | 370 | 407 | KAJ1504375.1 Translin-associated factor X-interacting protein 1 [Coelomomyces lativittatus] | diamond | 228 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 32650685 | 32650685 | PRJNA1022139_P_NODE_23100_length_292_cov_1.406393_g22995_i0 | PRJNA1022139 | 23100 | 292 | 1.406393 | 4.10666756 | Blastocladiales | 4805 | Fungi | Fungi | 117 | 4.79e-28 | NR | KNE68715.1 | 578462 | g22995 | i0 | 54.1 | 4.95205479452055 | 98 | 42 | 97.6 | 1 | 1 | 285 | 146 | 243 | KNE68715.1 hypothetical protein AMAG_13356 [Allomyces macrogynus ATCC 38327] | diamond | 1446 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 32847635 | 32847635 | PRJNA1022139_P_NODE_21740_length_301_cov_1.013158_g21635_i0 | PRJNA1022139 | 21740 | 301 | 1.013158 | 3.04960558 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 53.5 | 1.19e-5 | NR | KAI9142381.1 | 1500003 | g21635 | i0 | 36.4 | 1.78405315614618 | 88 | 50 | 81.7 | 2 | 49 | 294 | 441 | 528 | KAI9142381.1 hypothetical protein BKA69DRAFT_1124062 [Paraphysoderma sedebokerense] | diamond | 537 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense |
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);;