contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA975724" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 946845 | 946845 | PRJNA975724_S_NODE_66881_length_267_cov_2.257732_g66700_i0 | PRJNA975724 | 66881 | 267 | 2.257732 | 6.02814444 | root | 1 | Root_unresolved | Root_unresolved | 133 | 1.28e-34 | NR | KAI9142265.1 | 1500003 | g66700 | i0 | 72.7 | 10.9550561797753 | 88 | 24 | 98.9 | 0 | 4 | 267 | 371 | 458 | KAI9142265.1 fumarate hydratase [Paraphysoderma sedebokerense] | diamond | 2925 | 133 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 4775615 | 4775615 | PRJNA975724_S_NODE_85604_length_245_cov_1.720930_g85423_i0 | PRJNA975724 | 85604 | 245 | 1.72093 | 4.2162785 | Fungi | 4751 | Fungi | Fungi | 145 | 1.61e-42 | NR | KAJ3354864.1 | 64505 | g85423 | i0 | 89.3 | 51.4163265306122 | 75 | 8 | 91.8 | 0 | 244 | 20 | 96 | 170 | KAJ3354864.1 Ubiquitin-conjugating enzyme E2 4 [Allomyces javanicus] | diamond | 12597 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces javanicus | |
| 12424750 | 12424750 | PRJNA975724_S_NODE_19110_length_390_cov_10.936909_g18929_i0 | PRJNA975724 | 19110 | 390 | 10.936909 | 42.6539451 | Eukaryota | 2759 | Fungi | Fungi | 160 | 6.159999999999998e-48 | NR | KAJ3373363.1 | 64504 | g18929 | i0 | 66.7 | 5.24615384615385 | 114 | 38 | 87.7 | 0 | 1 | 342 | 20 | 133 | KAJ3373363.1 60S ribosomal protein L32 [Allomyces arbusculus] | diamond | 2046 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 20073248 | 20073248 | PRJNA975724_S_NODE_58756_length_281_cov_1.110577_g58575_i0 | PRJNA975724 | 58756 | 281 | 1.110577 | 3.12072137 | Fungi | 4751 | Fungi | Fungi | 70.9 | 4.44e-12 | NR | KAI9224161.1 | 64508 | g58575 | i0 | 50 | 3.2135231316726 | 66 | 27 | 64.1 | 1 | 181 | 2 | 37 | 102 | KAI9224161.1 cytochrome C1 family-domain-containing protein [Blastocladiella britannica] | diamond | 903 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 26962566 | 26962566 | PRJNA975724_S_NODE_74542_length_256_cov_1.475410_g74361_i0 | PRJNA975724 | 74542 | 256 | 1.47541 | 3.7770496 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 56.6 | 5.65e-7 | NR | KAI9179261.1 | 1313167 | g74361 | i0 | 69.2 | 1.0078125 | 39 | 12 | 45.7 | 0 | 230 | 114 | 1482 | 1520 | KAI9179261.1 hypothetical protein H9P43_005924 [Blastocladiella emersonii ATCC 22665] | diamond | 258 | 56.6 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 27215456 | 27215456 | PRJNA975724_S_NODE_73262_length_258_cov_1.248649_g73081_i0 | PRJNA975724 | 73262 | 258 | 1.248649 | 3.22151442 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 110 | 5.13e-26 | NR | KAI9139356.1 | 1500003 | g73081 | i0 | 57.5 | 1.01162790697674 | 87 | 36 | 100 | 1 | 258 | 1 | 2241 | 2327 | KAI9139356.1 PRP8 pre-mRNA processing factor 8 [Paraphysoderma sedebokerense] | diamond | 261 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28762853 | 28762853 | PRJNA975724_S_NODE_82607_length_248_cov_0.880000_g82426_i0 | PRJNA975724 | 82607 | 248 | 0.88 | 2.1824 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 61.2 | 5.04e-9 | NR | KAI9141473.1 | 1500003 | g82426 | i0 | 53.2 | 0.568548387096774 | 47 | 21 | 55.6 | 1 | 7 | 144 | 169 | 215 | KAI9141473.1 Atg6/Beclin [Paraphysoderma sedebokerense] | diamond | 141 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29394508 | 29394508 | PRJNA975724_S_NODE_1909_length_672_cov_10.292154_g1742_i0 | PRJNA975724 | 1909 | 672 | 10.292154 | 69.16327488 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 154 | 3.95e-39 | NR | KAI9144950.1 | 1500003 | g1742 | i0 | 54.8 | 3.41071428571429 | 146 | 61 | 65.2 | 1 | 670 | 233 | 1502 | 1642 | KAI9144950.1 clathrin heavy chain [Paraphysoderma sedebokerense] | diamond | 2292 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 29615121 | 29615121 | PRJNA975724_S_NODE_50590_length_296_cov_1.596413_g50409_i0 | PRJNA975724 | 50590 | 296 | 1.596413 | 4.72538248 | Blastocladiella britannica | 64508 | Fungi | Fungi | 60.1 | 4.84e-8 | NR | KAI9221354.1 | 64508 | g50409 | i0 | 39.5 | 0.820945945945946 | 81 | 38 | 82.1 | 1 | 24 | 266 | 264 | 333 | KAI9221354.1 mitochondrial carrier domain-containing protein [Blastocladiella britannica] | diamond | 243 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 29678269 | 29678269 | PRJNA975724_S_NODE_38590_length_323_cov_2.004000_g38409_i0 | PRJNA975724 | 38590 | 323 | 2.004 | 6.47292 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 50.4 | 4.48e-5 | NR | KAJ1498614.1 | 945690 | g38409 | i0 | 64.3 | 1.5232198142414901 | 42 | 14 | 39 | 1 | 322 | 197 | 73 | 113 | KAJ1498614.1 Mitochondrial matrix cochaperone [Coelomomyces lativittatus] | diamond | 492 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 29709805 | 29709805 | PRJNA975724_S_NODE_29170_length_351_cov_0.859712_g28989_i0 | PRJNA975724 | 29170 | 351 | 0.859712 | 3.01758912 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 46.6 | 3.79e-4 | NR | ORZ36211.1 | 765915 | g28989 | i0 | 34.5 | 0.495726495726496 | 58 | 36 | 49.6 | 1 | 21 | 194 | 4 | 59 | ORZ36211.1 cytochrome b-c1 complex subunit 9 [Catenaria anguillulae PL171] | diamond | 174 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 30253692 | 30253692 | PRJNA975724_S_NODE_33912_length_336_cov_1.463878_g33731_i0 | PRJNA975724 | 33912 | 336 | 1.463878 | 4.91863008 | Eukaryota | 2759 | Fungi | Fungi | 54.7 | 1.28e-6 | NR | KAI9141512.1 | 1500003 | g33731 | i0 | 34.8 | 1.70535714285714 | 92 | 60 | 82.1 | 0 | 307 | 32 | 26 | 117 | KAI9141512.1 Sec62/63 complex, subunit Sec66, partial [Paraphysoderma sedebokerense] | diamond | 573 | 55.1 | 0.992740471869329 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 30626156 | 30626156 | PRJNA975724_S_NODE_46573_length_304_cov_2.619048_g46392_i0 | PRJNA975724 | 46573 | 304 | 2.619048 | 7.96190592 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 43.5 | 0.0369 | NR | ORZ33434.1 | 765915 | g46392 | i0 | 29.3 | 0.976973684210526 | 99 | 64 | 92.8 | 3 | 5 | 286 | 185 | 282 | ORZ33434.1 hypothetical protein BCR44DRAFT_122403 [Catenaria anguillulae PL171] | diamond | 297 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 30853699 | 30853699 | PRJNA975724_S_NODE_74474_length_256_cov_1.683060_g74293_i0 | PRJNA975724 | 74474 | 256 | 1.68306 | 4.3086336 | Blastocladiaceae | 4806 | Fungi | Fungi | 48.5 | 4.14e-4 | NR | KNE63260.1 | 578462 | g74293 | i0 | 35.4 | 2.8828125 | 82 | 48 | 96.1 | 1 | 256 | 11 | 737 | 813 | KNE63260.1 hypothetical protein AMAG_08405 [Allomyces macrogynus ATCC 38327] | diamond | 738 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 31100097 | 31100097 | PRJNA975724_S_NODE_18015_length_396_cov_2.027864_g17834_i0 | PRJNA975724 | 18015 | 396 | 2.027864 | 8.03034144 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 169 | 9.99e-46 | NR | KAI9179054.1 | 1313167 | g17834 | i0 | 74.3 | 4.59090909090909 | 101 | 26 | 76.5 | 0 | 3 | 305 | 1229 | 1329 | KAI9179054.1 hypothetical protein H9P43_005716 [Blastocladiella emersonii ATCC 22665] | diamond | 1818 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 31131567 | 31131567 | PRJNA975724_S_NODE_3375_length_574_cov_12.902196_g3199_i0 | PRJNA975724 | 3375 | 574 | 12.902196 | 74.05860504 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 155 | 5.89e-41 | NR | KAI9140729.1 | 1500003 | g3199 | i0 | 77.5 | 4.1602787456446 | 102 | 23 | 53.3 | 0 | 571 | 266 | 422 | 523 | KAI9140729.1 acyl-CoA dehydrogenase/oxidase [Paraphysoderma sedebokerense] | diamond | 2388 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 31131573 | 31131573 | PRJNA975724_S_NODE_73755_length_257_cov_1.739130_g73574_i0 | PRJNA975724 | 73755 | 257 | 1.73913 | 4.4695641 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 75.5 | 4.39e-14 | NR | KNE64248.1 | 578462 | g73574 | i0 | 68.1 | 1.09727626459144 | 47 | 15 | 54.9 | 0 | 256 | 116 | 221 | 267 | KNE64248.1 hypothetical protein AMAG_09285 [Allomyces macrogynus ATCC 38327] | diamond | 282 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 31543046 | 31543046 | PRJNA975724_S_NODE_2676_length_612_cov_4.564007_g2503_i0 | PRJNA975724 | 2676 | 612 | 4.564007 | 27.93172284 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 94.7 | 1.37e-18 | NR | KNE59398.1 | 578462 | g2503 | i0 | 46.6 | 0.504901960784314 | 103 | 49 | 49 | 3 | 612 | 313 | 558 | 657 | KNE59398.1 hypothetical protein AMAG_03681 [Allomyces macrogynus ATCC 38327] | diamond | 309 | 94.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 31802050 | 31802050 | PRJNA975724_S_NODE_75337_length_255_cov_1.269231_g75156_i0 | PRJNA975724 | 75337 | 255 | 1.269231 | 3.23653905 | Fungi | 4751 | Fungi | Fungi | 67.8 | 2.19e-11 | NR | ORZ35218.1 | 765915 | g75156 | i0 | 62.5 | 1.81176470588235 | 48 | 18 | 56.5 | 0 | 238 | 95 | 186 | 233 | ORZ35218.1 proteasome beta subunit [Catenaria anguillulae PL171] | diamond | 462 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 32017414 | 32017414 | PRJNA975724_S_NODE_18058_length_396_cov_1.340557_g17877_i0 | PRJNA975724 | 18058 | 396 | 1.340557 | 5.30860572 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 97.4 | 1.48e-20 | NR | KAI9140958.1 | 1500003 | g17877 | i0 | 50 | 1.48484848484848 | 98 | 43 | 74.2 | 3 | 2 | 295 | 544 | 635 | KAI9140958.1 P-loop containing nucleoside triphosphate hydrolase protein [Paraphysoderma sedebokerense] | diamond | 588 | 97.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 32334144 | 32334144 | PRJNA975724_S_NODE_60559_length_278_cov_1.121951_g60378_i0 | PRJNA975724 | 60559 | 278 | 1.121951 | 3.11902378 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 109 | 1.13e-26 | NR | ORZ32059.1 | 765915 | g60378 | i0 | 59 | 2.53597122302158 | 78 | 32 | 84.2 | 0 | 277 | 44 | 210 | 287 | ORZ32059.1 glutathione S-transferase [Catenaria anguillulae PL171] | diamond | 705 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 32555664 | 32555664 | PRJNA975724_S_NODE_36639_length_328_cov_2.529412_g36458_i0 | PRJNA975724 | 36639 | 328 | 2.529412 | 8.29647136 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 140 | 6.82e-38 | NR | ORZ39971.1 | 765915 | g36458 | i0 | 59.6 | 8.50609756097561 | 104 | 42 | 95.1 | 0 | 1 | 312 | 224 | 327 | ORZ39971.1 rab geranylgeranyltransferase [Catenaria anguillulae PL171] | diamond | 2790 | 140 | 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);;