contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA1036688" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5272543 | 5272543 | PRJNA1036688_P_NODE_8985_length_181_cov_3.479167_g8693_i0 | PRJNA1036688 | 8985 | 181 | 3.479167 | 6.29729227 | Cladochytrium tenue | 1604274 | Fungi | Fungi | 107 | 3.11e-27 | NR | KAJ1544066.1 | 1604274 | g8693 | i0 | 80 | 22.7734806629834 | 60 | 12 | 99.4 | 0 | 2 | 181 | 61 | 120 | KAJ1544066.1 60S ribosomal protein L15, partial [Cladochytrium tenue] | diamond | 4122 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium tenue | |
| 9936213 | 9936213 | PRJNA1036688_P_NODE_9508_length_175_cov_2.253623_g9216_i0 | PRJNA1036688 | 9508 | 175 | 2.253623 | 3.94384025 | Globomyces pollinis-pini | 382532 | Fungi | Fungi | 89.4 | 5.5e-19 | NR | KAI8893489.1 | 382532 | g9216 | i0 | 71.9 | 0.977142857142857 | 57 | 16 | 97.7 | 0 | 3 | 173 | 420 | 476 | KAI8893489.1 P-loop containing nucleoside triphosphate hydrolase protein [Globomyces pollinis-pini] | diamond | 171 | 89.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Globomycetaceae | Globomyces | Globomyces pollinis-pini | |
| 23121905 | 23121905 | PRJNA1036688_P_NODE_11759_length_154_cov_1.658120_g11467_i0 | PRJNA1036688 | 11759 | 154 | 1.65812 | 2.5535048 | Kappamyces sp. JEL | 2040833 | Fungi | Fungi | 75.9 | 6.69e-15 | NR | KAJ3346861.1 | 2724210 | g11467 | i0 | 74 | 0.974025974025974 | 50 | 13 | 97.4 | 0 | 3 | 152 | 160 | 209 | KAJ3346861.1 40S ribosomal protein [Kappamyces sp. JEL0680] | diamond | 150 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Kappamycetaceae | Kappamyces | Kappamyces sp. JEL0680 | |
| 31828594 | 31828594 | PRJNA1036688_P_NODE_7477_length_204_cov_3.035928_g7185_i0 | PRJNA1036688 | 7477 | 204 | 3.035928 | 6.19329312 | Eukaryota | 2759 | Fungi | Fungi | 99 | 2.0499999999999999e-23 | NR | KAJ3387474.1 | 109889 | g7185 | i0 | 67.2 | 21.4411764705882 | 64 | 21 | 94.1 | 0 | 12 | 203 | 64 | 127 | KAJ3387474.1 40S ribosomal protein S4 [Lobulomyces angularis] | diamond | 4374 | 100 | 0.99 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetaceae | Lobulomyces | Lobulomyces angularis | |
| 31995043 | 31995043 | PRJNA1036688_P_NODE_5958_length_241_cov_1.892157_g5666_i0 | PRJNA1036688 | 5958 | 241 | 1.892157 | 4.56009837 | Geranomyces variabilis | 109894 | Fungi | Fungi | 86.7 | 2.01e-19 | NR | KAJ3168399.1 | 109894 | g5666 | i0 | 61.2 | 1.73029045643154 | 67 | 26 | 83.4 | 0 | 202 | 2 | 39 | 105 | KAJ3168399.1 60S acidic ribosomal protein P2 [Geranomyces variabilis] | diamond | 417 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 32839794 | 32839794 | PRJNA1036688_P_NODE_10580_length_164_cov_1.811024_g10288_i0 | PRJNA1036688 | 10580 | 164 | 1.811024 | 2.97007936 | Chytridiomycota | 4761 | Fungi | Fungi | 48.5 | 4.58e-5 | NR | KAJ3376926.1 | 109889 | g10288 | i0 | 58 | 3.56707317073171 | 50 | 21 | 91.5 | 0 | 164 | 15 | 20 | 69 | KAJ3376926.1 hypothetical protein HDU92_008808 [Lobulomyces angularis] | diamond | 585 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetaceae | Lobulomyces | Lobulomyces angularis |
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);;