contig_metadata
7 rows where bioproject = "PRJNA773247", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18600688 | 18600688 | PRJNA773247_P_NODE_27915_length_263_cov_1.621053_g27831_i0 | PRJNA773247 | 27915 | 263 | 1.621053 | 4.26336939 | Fungi | 4751 | Fungi | Fungi | 144 | 4.77e-40 | NR | KAI8926618.1 | 281842 | g27831 | i0 | 73.6 | 23.7946768060837 | 87 | 23 | 99.2 | 0 | 3 | 263 | 194 | 280 | KAI8926618.1 60S ribosomal protein L3, partial [Entophlyctis helioformis] | diamond | 6258 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis helioformis | |
| 26936226 | 26936226 | PRJNA773247_P_NODE_24622_length_283_cov_1.942857_g24538_i0 | PRJNA773247 | 24622 | 283 | 1.942857 | 5.49828531 | root | 1 | Root_unresolved | Root_unresolved | 90.1 | 1.41e-18 | NR | XP_052962581.1 | 110093 | g24538 | i0 | 49.4 | 3.92226148409894 | 87 | 44 | 92.2 | 0 | 20 | 280 | 1555 | 1641 | XP_052962581.1 uncharacterized protein BJ171DRAFT_249954 [Polychytrium aggregatum] | diamond | 1110 | 90.5 | 0.995580110497237 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 27274652 | 27274652 | PRJNA773247_P_NODE_883_length_2030_cov_14.098109_g866_i0 | PRJNA773247 | 883 | 2030 | 14.098109 | 286.1916127 | Spizellomyces punctatus DAOM BR117 | 645134 | Fungi | Fungi | 571 | 2.67e-193 | NR | XP_016604088.1 | 645134 | g866 | i0 | 50.4 | 2.60098522167488 | 587 | 258 | 85.4 | 5 | 41 | 1774 | 103 | 665 | XP_016604088.1 hypothetical protein, variant [Spizellomyces punctatus DAOM BR117] | diamond | 5280 | 571 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 28474545 | 28474545 | PRJNA773247_P_NODE_17426_length_349_cov_8.083333_g17342_i0 | PRJNA773247 | 17426 | 349 | 8.083333 | 28.21083217 | Gorgonomyces haynaldii | 382530 | Fungi | Fungi | 129 | 2.13e-36 | NR | KAI8903770.1 | 382530 | g17342 | i0 | 66.3 | 1.50429799426934 | 89 | 30 | 76.5 | 0 | 11 | 277 | 15 | 103 | KAI8903770.1 thioredoxine 2 [Gorgonomyces haynaldii] | diamond | 525 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Gorgonomycetaceae | Gorgonomyces | Gorgonomyces haynaldii | |
| 30338142 | 30338142 | PRJNA773247_P_NODE_19932_length_321_cov_7.064516_g19848_i0 | PRJNA773247 | 19932 | 321 | 7.064516 | 22.67709636 | Hyaloraphidium curvatum | 82268 | Fungi | Fungi | 82 | 3.13e-16 | NR | KAI9030377.1 | 82268 | g19848 | i0 | 44.8 | 0.813084112149533 | 87 | 47 | 81.3 | 1 | 262 | 2 | 48 | 133 | KAI9030377.1 beta-lactamase-like protein [Hyaloraphidium curvatum] | diamond | 261 | 82 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Hyaloraphidium | Hyaloraphidium curvatum | ||
| 31696854 | 31696854 | PRJNA773247_P_NODE_8397_length_558_cov_13.940206_g8314_i0 | PRJNA773247 | 8397 | 558 | 13.940206 | 77.78634948 | Chytriomyces sp. MP71 | 1882861 | Fungi | Fungi | 132 | 6.85e-36 | NR | KAI8616905.1 | 1882861 | g8314 | i0 | 51.6 | 8.3494623655914 | 128 | 62 | 68.8 | 0 | 508 | 125 | 7 | 134 | KAI8616905.1 ribosomal protein L14-domain-containing protein [Chytriomyces sp. MP71] | diamond | 4659 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces sp. MP71 | |
| 32329922 | 32329922 | PRJNA773247_P_NODE_28459_length_260_cov_1.866310_g28375_i0 | PRJNA773247 | 28459 | 260 | 1.86631 | 4.852406 | Quaeritorhiza haematococci | 2654861 | Fungi | Fungi | 45.8 | 0.0024 | NR | KAJ3085310.1 | 2654861 | g28375 | i0 | 44.7 | 0.542307692307692 | 47 | 26 | 54.2 | 0 | 1 | 141 | 64 | 110 | KAJ3085310.1 hypothetical protein HK102_000123 [Quaeritorhiza haematococci] | diamond | 141 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Quaeritorhizaceae | Quaeritorhiza | Quaeritorhiza haematococci |
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);;