contig_metadata
11 rows where bioproject = "PRJNA1192965", tax_clade = "Opisthokonta" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13795751 | 13795751 | PRJNA1192965_P_NODE_5051_length_241_cov_1.833333_g5032_i0 | PRJNA1192965 | 5051 | 241 | 1.833333 | 4.41833253 | Fungi | 4751 | Fungi | Fungi | 76.3 | 3.3e-15 | NR | KAI8908321.1 | 382530 | g5032 | i0 | 60 | 2.77593360995851 | 75 | 29 | 93.4 | 1 | 15 | 239 | 30 | 103 | KAI8908321.1 Mss4-like protein [Gorgonomyces haynaldii] | diamond | 669 | 76.6 | 0.996083550913838 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Gorgonomycetaceae | Gorgonomyces | Gorgonomyces haynaldii | |
| 29018064 | 29018064 | PRJNA1192965_P_NODE_1088_length_377_cov_1.427632_g1069_i0 | PRJNA1192965 | 1088 | 377 | 1.427632 | 5.38217264 | Spizellomycetales | 34478 | Fungi | Fungi | 172 | 1.5499999999999998e-48 | NR | TPX58786.1 | 109895 | g1069 | i0 | 62.3 | 9.74005305039788 | 122 | 46 | 97.1 | 0 | 367 | 2 | 268 | 389 | TPX58786.1 hypothetical protein PhCBS80983_g02902 [Powellomyces hirtus] | diamond | 3672 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 29535459 | 29535459 | PRJNA1192965_P_NODE_2730_length_269_cov_1.214286_g2711_i0 | PRJNA1192965 | 2730 | 269 | 1.214286 | 3.26642934 | Siphonaria sp. JEL | 2047469 | Fungi | Fungi | 58.2 | 1.9e-7 | NR | KAJ3017754.1 | 2723227 | g2711 | i0 | 38.9 | 2.64312267657993 | 90 | 51 | 98.1 | 2 | 264 | 1 | 361 | 448 | KAJ3017754.1 Poly [ADP-ribose] polymerase 2 [Siphonaria sp. JEL0065] | diamond | 711 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Siphonaria | Siphonaria sp. JEL0065 | |
| 29819436 | 29819436 | PRJNA1192965_P_NODE_4571_length_244_cov_0.900585_g4552_i0 | PRJNA1192965 | 4571 | 244 | 0.900585 | 2.1974274 | Terramyces sp. JEL | 2040976 | Fungi | Fungi | 65.5 | 2.92e-10 | NR | KAJ3275729.1 | 2724204 | g4552 | i0 | 44.2 | 2.84016393442623 | 77 | 43 | 94.7 | 0 | 233 | 3 | 235 | 311 | KAJ3275729.1 Protein kinase [Terramyces sp. JEL0728] | diamond | 693 | 65.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Terramycetaceae | Terramyces | Terramyces sp. JEL0728 | |
| 30103821 | 30103821 | PRJNA1192965_P_NODE_792_length_424_cov_4.128205_g773_i0 | PRJNA1192965 | 792 | 424 | 4.128205 | 17.5035892 | Cladochytrium tenue | 1604274 | Fungi | Fungi | 151 | 4.05e-44 | NR | KAJ1568147.1 | 1604274 | g773 | i0 | 60.9 | 2.75235849056604 | 128 | 50 | 90.6 | 0 | 422 | 39 | 4 | 131 | KAJ1568147.1 60S ribosomal protein L32 [Cladochytrium tenue] | diamond | 1167 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium tenue | |
| 30439156 | 30439156 | PRJNA1192965_P_NODE_4633_length_244_cov_0.900585_g4614_i0 | PRJNA1192965 | 4633 | 244 | 0.900585 | 2.1974274 | Fungi | 4751 | Fungi | Fungi | 130 | 2.17e-34 | NR | KAI9034341.1 | 82268 | g4614 | i0 | 80.2 | 28.6598360655738 | 81 | 16 | 99.6 | 0 | 1 | 243 | 57 | 137 | KAI9034341.1 60S ribosomal protein L3 [Hyaloraphidium curvatum] | diamond | 6993 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 30546295 | 30546295 | PRJNA1192965_P_NODE_2273_length_286_cov_3.826291_g2254_i0 | PRJNA1192965 | 2273 | 286 | 3.826291 | 10.94319226 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 121 | 4.17e-31 | NR | KAI9026238.1 | 82268 | g2254 | i0 | 72.5 | 1.64685314685315 | 80 | 19 | 83.9 | 1 | 46 | 285 | 4 | 80 | KAI9026238.1 putative mitochondrial ADP/ATP translocase [Hyaloraphidium curvatum] | diamond | 471 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 31039557 | 31039557 | PRJNA1192965_P_NODE_4335_length_245_cov_0.895349_g4316_i0 | PRJNA1192965 | 4335 | 245 | 0.895349 | 2.19360505 | Fungi | 4751 | Fungi | Fungi | 49.3 | 1.91e-4 | NR | KAJ3165644.1 | 109884 | g4316 | i0 | 38 | 1.77551020408163 | 79 | 46 | 93.1 | 1 | 242 | 15 | 612 | 690 | KAJ3165644.1 hypothetical protein HK101_000185 [Irineochytrium annulatum] | diamond | 435 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Irineochytrium | Irineochytrium annulatum | |
| 31146166 | 31146166 | PRJNA1192965_P_NODE_4455_length_245_cov_0.895349_g4436_i0 | PRJNA1192965 | 4455 | 245 | 0.895349 | 2.19360505 | Cladochytrium replicatum | 109936 | Fungi | Fungi | 42.7 | 0.02 | NR | KAI8801732.1 | 109936 | g4436 | i0 | 32.1 | 0.991836734693878 | 81 | 44 | 89.4 | 2 | 14 | 232 | 25 | 102 | KAI8801732.1 AP complex, mu/sigma subunit [Cladochytrium replicatum] | diamond | 243 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium replicatum | |
| 31810794 | 31810794 | PRJNA1192965_P_NODE_697_length_449_cov_3.824468_g678_i0 | PRJNA1192965 | 697 | 449 | 3.824468 | 17.17186132 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 261 | 3.62e-85 | NR | KAI9026238.1 | 82268 | g678 | i0 | 84.4 | 0.982182628062361 | 147 | 23 | 98.2 | 0 | 441 | 1 | 133 | 279 | KAI9026238.1 putative mitochondrial ADP/ATP translocase [Hyaloraphidium curvatum] | diamond | 441 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 32526235 | 32526235 | PRJNA1192965_P_NODE_759_length_432_cov_1.908078_g740_i0 | PRJNA1192965 | 759 | 432 | 1.908078 | 8.24289696 | Eukaryota | 2759 | Fungi | Fungi | 201 | 9.82e-64 | NR | KAI8930051.1 | 281842 | g740 | i0 | 68.8 | 29.9652777777778 | 144 | 43 | 98.6 | 1 | 4 | 429 | 1 | 144 | KAI8930051.1 40S ribosomal protein S13 [Entophlyctis helioformis] | diamond | 12945 | 202 | 0.995049504950495 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis helioformis |
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);;