contig_metadata
8 rows where bioproject = "PRJNA554794", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5624795 | 5624795 | PRJNA554794_P_NODE_24825_length_161_cov_0.732143_g20896_i0 | PRJNA554794 | 24825 | 161 | 0.732143 | 1.17875023 | Martensiomyces pterosporus | 61414 | Fungi | Fungi | 87.4 | 5.13e-19 | NR | KAI8319129.1 | 61414 | g20896 | i0 | 78.4 | 1.86335403726708 | 51 | 11 | 95 | 0 | 7 | 159 | 178 | 228 | KAI8319129.1 60s ribosomal protein l5-b [Martensiomyces pterosporus] | diamond | 300 | 87.4 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Martensiomyces | Martensiomyces pterosporus | |
| 24747180 | 24747180 | PRJNA554794_P_NODE_8380_length_532_cov_0.848861_g4715_i0 | PRJNA554794 | 8380 | 532 | 0.848861 | 4.51594052 | Eukaryota | 2759 | Fungi | Fungi | 291 | 5.57e-97 | NR | KAJ1993908.1 | 215637 | g4715 | i0 | 73.9 | 12.9078947368421 | 176 | 46 | 99.2 | 0 | 532 | 5 | 46 | 221 | KAJ1993908.1 60S ribosomal protein L2 [Dimargaris cristalligena] | diamond | 6867 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dimargaris | Dimargaris cristalligena | |
| 25349844 | 25349844 | PRJNA554794_P_NODE_20900_length_187_cov_1.130435_g16971_i0 | PRJNA554794 | 20900 | 187 | 1.130435 | 2.11391345 | Zoopagomycota | 1913638 | Fungi | Fungi | 120 | 1.05e-29 | NR | KAI8326243.1 | 61414 | g16971 | i0 | 87.1 | 9.94652406417112 | 62 | 8 | 99.5 | 0 | 2 | 187 | 694 | 755 | KAI8326243.1 putative EFT2-translation elongation factor eEF2 [Martensiomyces pterosporus] | diamond | 1860 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Martensiomyces | Martensiomyces pterosporus | |
| 26857046 | 26857046 | PRJNA554794_P_NODE_24441_length_162_cov_0.566372_g20512_i0 | PRJNA554794 | 24441 | 162 | 0.566372 | 0.91752264 | Smittium culicis | 133412 | Fungi | Fungi | 81.3 | 3.03e-17 | NR | OMJ20608.1 | 133412 | g20512 | i0 | 75.5 | 0.981481481481482 | 53 | 13 | 98.1 | 0 | 159 | 1 | 66 | 118 | OMJ20608.1 60S ribosomal protein L13 [Smittium culicis] | diamond | 159 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium culicis | |
| 27551944 | 27551944 | PRJNA554794_P_NODE_22804_length_166_cov_1.025641_g18875_i0 | PRJNA554794 | 22804 | 166 | 1.025641 | 1.70256406 | Tieghemiomyces parasiticus | 78921 | Fungi | Fungi | 79.3 | 1.36e-15 | NR | KAJ1926423.1 | 78921 | g18875 | i0 | 65.4 | 1.87951807228916 | 52 | 18 | 94 | 0 | 157 | 2 | 256 | 307 | KAJ1926423.1 sphingolipid delta-4 desaturase [Tieghemiomyces parasiticus] | diamond | 312 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Tieghemiomyces | Tieghemiomyces parasiticus | |
| 28766519 | 28766519 | PRJNA554794_P_NODE_10687_length_353_cov_1.375000_g6772_i0 | PRJNA554794 | 10687 | 353 | 1.375 | 4.85375 | Fungi | 4751 | Fungi | Fungi | 112 | 3.39e-26 | NR | OLY84011.1 | 133383 | g6772 | i0 | 53.8 | 3.57790368271955 | 104 | 32 | 88.4 | 1 | 312 | 1 | 306 | 393 | OLY84011.1 Glutamine-fructose-6-phosphate aminotransferase [isomerizing] [Smittium mucronatum] | diamond | 1263 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium mucronatum | |
| 29113969 | 29113969 | PRJNA554794_P_NODE_22308_length_170_cov_0.768595_g18379_i0 | PRJNA554794 | 22308 | 170 | 0.768595 | 1.3066115 | Fungi | 4751 | Fungi | Fungi | 101 | 1.09e-24 | NR | KAJ1970205.1 | 1520584 | g18379 | i0 | 78.6 | 12.8470588235294 | 56 | 12 | 98.8 | 0 | 1 | 168 | 98 | 153 | KAJ1970205.1 60S ribosomal protein L2 [Dispira parvispora] | diamond | 2184 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dispira | Dispira parvispora | |
| 32873805 | 32873805 | PRJNA554794_P_NODE_11740_length_301_cov_0.619048_g7811_i0 | PRJNA554794 | 11740 | 301 | 0.619048 | 1.86333448 | Fungi | 4751 | Fungi | Fungi | 160 | 9.65e-48 | NR | RKP27476.1 | 1712513 | g7811 | i0 | 74 | 8.67109634551495 | 96 | 25 | 95.7 | 0 | 6 | 293 | 4 | 99 | RKP27476.1 ribosomal L18ae/LX protein domain-containing protein [Syncephalis pseudoplumigaleata] | diamond | 2610 | 161 | 0.993788819875776 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis pseudoplumigaleata |
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);;