contig_metadata
17 rows where bioproject = "PRJNA1108009", tax_kingdom = "Fungi" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2763795 | 2763795 | PRJNA1108009_P_NODE_26623_length_248_cov_1.320000_g26305_i0 | PRJNA1108009 | 26623 | 248 | 1.32 | 3.2736 | Fungi | 4751 | Fungi | Fungi | 106 | 2.1e-25 | NR | KAK9694201.1 | 34480 | g26305 | i0 | 58.2 | 18.9798387096774 | 91 | 27 | 96.8 | 1 | 244 | 5 | 104 | 194 | KAK9694201.1 protein phosphatase 2A regulatory subunit cdc55 [Basidiobolus ranarum] | diamond | 4707 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 5316253 | 5316253 | PRJNA1108009_P_NODE_8565_length_468_cov_1.159494_g8248_i0 | PRJNA1108009 | 8565 | 468 | 1.159494 | 5.42643192 | Spiromyces aspiralis | 68401 | Fungi | Fungi | 162 | 6.34e-48 | NR | KAJ1675135.1 | 68401 | g8248 | i0 | 56 | 4.3525641025641 | 134 | 58 | 85.3 | 1 | 446 | 48 | 6 | 139 | KAJ1675135.1 Protein component of the small (40S) ribosomal subunit [Spiromyces aspiralis] | diamond | 2037 | 162 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces aspiralis | |
| 6590930 | 6590930 | PRJNA1108009_P_NODE_16906_length_318_cov_1.110204_g16588_i0 | PRJNA1108009 | 16906 | 318 | 1.110204 | 3.53044872 | Eukaryota | 2759 | Fungi | Fungi | 138 | 8.270000000000001e-36 | NR | BAL15332.1 | 90248 | g16588 | i0 | 67.3 | 3.92452830188679 | 104 | 34 | 98.1 | 0 | 313 | 2 | 217 | 320 | BAL15332.1 translation elongation factor 2, partial [Basidiobolus haptosporus] | diamond | 1248 | 139 | 0.992805755395683 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus haptosporus | |
| 16789907 | 16789907 | PRJNA1108009_P_NODE_15174_length_338_cov_1.162264_g14856_i0 | PRJNA1108009 | 15174 | 338 | 1.162264 | 3.92845232 | Coemansia reversa NRRL 1564 | 763665 | Fungi | Fungi | 106 | 1.59e-26 | NR | PIA15605.1 | 763665 | g14856 | i0 | 46.9 | 14.0414201183432 | 113 | 58 | 98.5 | 1 | 334 | 2 | 10 | 122 | PIA15605.1 ubiquitin and ribosomal protein S27a-like protein [Coemansia reversa NRRL 1564] | diamond | 4746 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia reversa | |
| 20614290 | 20614290 | PRJNA1108009_P_NODE_29397_length_244_cov_0.900585_g29079_i0 | PRJNA1108009 | 29397 | 244 | 0.900585 | 2.1974274 | Dimargaris cristalligena | 215637 | Fungi | Fungi | 124 | 6.96e-34 | NR | KAJ1990535.1 | 215637 | g29079 | i0 | 69.1 | 5.93852459016393 | 81 | 25 | 99.6 | 0 | 2 | 244 | 97 | 177 | KAJ1990535.1 translation machinery-associated protein 20 [Dimargaris cristalligena] | diamond | 1449 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dimargaris | Dimargaris cristalligena | |
| 21889925 | 21889925 | PRJNA1108009_P_NODE_28698_length_245_cov_0.895349_g28380_i0 | PRJNA1108009 | 28698 | 245 | 0.895349 | 2.19360505 | Zoopagomycota | 1913638 | Fungi | Fungi | 143 | 1.26e-41 | NR | KAJ1983967.1 | 215637 | g28380 | i0 | 86.4 | 2.8530612244898 | 81 | 11 | 99.2 | 0 | 245 | 3 | 23 | 103 | KAJ1983967.1 60S ribosomal protein L23A [Dimargaris cristalligena] | diamond | 699 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dimargaris | Dimargaris cristalligena | |
| 23165390 | 23165390 | PRJNA1108009_P_NODE_27059_length_248_cov_0.880000_g26741_i0 | PRJNA1108009 | 27059 | 248 | 0.88 | 2.1824 | Fungi | 4751 | Fungi | Fungi | 136 | 1.0899999999999998e-37 | NR | KAK9680365.1 | 34480 | g26741 | i0 | 72 | 16.8387096774194 | 82 | 23 | 99.2 | 0 | 246 | 1 | 27 | 108 | KAK9680365.1 translation elongation factor 2 [Basidiobolus ranarum] | diamond | 4176 | 137 | 0.992700729927007 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 24438776 | 24438776 | PRJNA1108009_P_NODE_17680_length_309_cov_1.957627_g17362_i0 | PRJNA1108009 | 17680 | 309 | 1.957627 | 6.04906743 | Eukaryota | 2759 | Fungi | Fungi | 116 | 1.83e-28 | NR | KAI8320682.1 | 61414 | g17362 | i0 | 60.6 | 49.9805825242718 | 99 | 37 | 94.2 | 1 | 292 | 2 | 230 | 328 | KAI8320682.1 ribosomal protein L22 [Martensiomyces pterosporus] | diamond | 15444 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Martensiomyces | Martensiomyces pterosporus | |
| 26909551 | 26909551 | PRJNA1108009_P_NODE_26082_length_249_cov_0.875000_g25764_i0 | PRJNA1108009 | 26082 | 249 | 0.875 | 2.17875 | Smittium simulii | 133385 | Fungi | Fungi | 101 | 6.359999999999999e-23 | NR | PVU95265.1 | 133385 | g25764 | i0 | 58.5 | 0.987951807228916 | 82 | 34 | 98.8 | 0 | 2 | 247 | 265 | 346 | PVU95265.1 hypothetical protein BB561_001924 [Smittium simulii] | diamond | 246 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium simulii | |
| 27943515 | 27943515 | PRJNA1108009_P_NODE_21445_length_276_cov_1.349754_g21127_i0 | PRJNA1108009 | 21445 | 276 | 1.349754 | 3.72532104 | Eukaryota | 2759 | Fungi | Fungi | 70.9 | 7.01e-12 | NR | KAK9768413.1 | 34480 | g21127 | i0 | 40.4 | 8.71739130434783 | 89 | 51 | 96.7 | 1 | 275 | 9 | 11 | 97 | KAK9768413.1 Serine/threonine-protein kinase [Basidiobolus ranarum] | diamond | 2406 | 71.2 | 0.995786516853933 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 28867751 | 28867751 | PRJNA1108009_P_NODE_8448_length_472_cov_0.897243_g8131_i0 | PRJNA1108009 | 8448 | 472 | 0.897243 | 4.23498696 | Basidiobolus meristosporus CBS 931.73 | 1314790 | Fungi | Fungi | 174 | 5.96e-49 | NR | ORX88871.1 | 1314790 | g8131 | i0 | 59.4 | 6.23516949152542 | 143 | 56 | 90.9 | 1 | 1 | 429 | 324 | 464 | ORX88871.1 elongation factor alpha-like protein [Basidiobolus meristosporus CBS 931.73] | diamond | 2943 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 29309734 | 29309734 | PRJNA1108009_P_NODE_14329_length_349_cov_1.086957_g14011_i0 | PRJNA1108009 | 14329 | 349 | 1.086957 | 3.79347993 | Furculomyces boomerangus | 61424 | Fungi | Fungi | 92.8 | 4.3700000000000005e-21 | NR | PVU86898.1 | 61424 | g14011 | i0 | 41.4 | 0.954154727793696 | 111 | 64 | 94.6 | 1 | 341 | 12 | 4 | 114 | PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus] | diamond | 333 | 92.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 29435793 | 29435793 | PRJNA1108009_P_NODE_22410_length_268_cov_1.338462_g22092_i0 | PRJNA1108009 | 22410 | 268 | 1.338462 | 3.58707816 | Basidiobolus meristosporus CBS 931.73 | 1314790 | Fungi | Fungi | 53.1 | 5.03e-6 | NR | ORY04908.1 | 1314790 | g22092 | i0 | 50.7 | 2.23880597014925 | 67 | 30 | 71.6 | 3 | 212 | 21 | 1 | 67 | ORY04908.1 40S ribosomal protein S7 [Basidiobolus meristosporus CBS 931.73] | diamond | 600 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 29972914 | 29972914 | PRJNA1108009_P_NODE_14111_length_351_cov_1.708633_g13793_i0 | PRJNA1108009 | 14111 | 351 | 1.708633 | 5.99730183 | Ramicandelaber brevisporus | 304332 | Fungi | Fungi | 95.9 | 8.89e-23 | NR | KAI8872700.1 | 304332 | g13793 | i0 | 41.7 | 0.923076923076923 | 108 | 55 | 92.3 | 1 | 324 | 1 | 13 | 112 | KAI8872700.1 ribosomal protein S1 [Ramicandelaber brevisporus] | diamond | 324 | 95.9 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Ramicandelaberales | Ramicandelaberaceae | Ramicandelaber | Ramicandelaber brevisporus | ||
| 30352614 | 30352614 | PRJNA1108009_P_NODE_18112_length_305_cov_1.362069_g17794_i0 | PRJNA1108009 | 18112 | 305 | 1.362069 | 4.15431045 | Zancudomyces culisetae | 1213189 | Fungi | Fungi | 119 | 4.1e-31 | NR | OMH80642.1 | 1213189 | g17794 | i0 | 59.8 | 2.94098360655738 | 97 | 39 | 95.4 | 0 | 291 | 1 | 110 | 206 | OMH80642.1 Elongation factor 1-beta [Zancudomyces culisetae] | diamond | 897 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Zancudomyces | Zancudomyces culisetae | |
| 31481418 | 31481418 | PRJNA1108009_P_NODE_26776_length_248_cov_0.880000_g26458_i0 | PRJNA1108009 | 26776 | 248 | 0.88 | 2.1824 | Fungi | 4751 | Fungi | Fungi | 74.3 | 2.69e-13 | NR | RKP07667.1 | 78915 | g26458 | i0 | 53.2 | 4.68145161290323 | 77 | 31 | 93.1 | 1 | 231 | 1 | 5 | 76 | RKP07667.1 Thiolase, N-terminal domain-containing protein [Thamnocephalis sphaerospora] | diamond | 1161 | 74.7 | 0.994645247657296 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Sigmoideomycetaceae | Thamnocephalis | Thamnocephalis sphaerospora | |
| 32050482 | 32050482 | PRJNA1108009_P_NODE_12758_length_372_cov_1.518395_g12440_i0 | PRJNA1108009 | 12758 | 372 | 1.518395 | 5.6484294 | Harpellales | 61421 | Fungi | Fungi | 95.5 | 5.35e-22 | NR | PVU86898.1 | 61424 | g12440 | i0 | 40.2 | 3.91129032258065 | 122 | 72 | 97.6 | 1 | 4 | 366 | 4 | 125 | PVU86898.1 hypothetical protein BB559_006328 [Furculomyces boomerangus] | diamond | 1455 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus |
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);;