contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA999747" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7358271 | 7358271 | PRJNA999747_S_NODE_2606_length_192_cov_2.111801_g2574_i0 | PRJNA999747 | 2606 | 192 | 2.111801 | 4.05465792 | Eukaryota | 2759 | Fungi | Fungi | 112 | 7.35e-27 | NR | AAD09565.1 | 4754 | g2574 | i0 | 79.7 | 130 | 64 | 13 | 100 | 0 | 192 | 1 | 204 | 267 | AAD09565.1 heat shock protein 70, partial [Pneumocystis carinii] | diamond | 24960 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pneumocystomycetes | Pneumocystales | Pneumocystaceae | Pneumocystis | Pneumocystis carinii | |
| 20107159 | 20107159 | PRJNA999747_S_NODE_896_length_305_cov_3.306569_g864_i0 | PRJNA999747 | 896 | 305 | 3.306569 | 10.08503545 | Borealophlyctis nickersoniae | 2735257 | Fungi | Fungi | 164 | 2.8199999999999996e-45 | NR | KAJ3300505.1 | 2735257 | g864 | i0 | 77 | 20.4 | 100 | 23 | 98.4 | 0 | 6 | 305 | 14 | 113 | KAJ3300505.1 70-kilodalton heat shock protein [Borealophlyctis nickersoniae] | diamond | 6222 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Borealophlyctidaceae | Borealophlyctis | Borealophlyctis nickersoniae | |
| 21382745 | 21382745 | PRJNA999747_S_NODE_3037_length_179_cov_2.337838_g3005_i0 | PRJNA999747 | 3037 | 179 | 2.337838 | 4.18473002 | root | 1 | Root_unresolved | Root_unresolved | 102 | 1.6700000000000002e-26 | NR | CAG8741682.1 | 60492 | g3005 | i0 | 87.7 | 41.0949720670391 | 57 | 7 | 95.5 | 0 | 174 | 4 | 50 | 106 | CAG8741682.1 6520_t:CDS:1, partial [Racocetra fulgida] | diamond | 7356 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Racocetra | Racocetra fulgida | |
| 21382755 | 21382755 | PRJNA999747_S_NODE_397_length_411_cov_4.294737_g365_i0 | PRJNA999747 | 397 | 411 | 4.294737 | 17.65136907 | Chytridiomycetes | 451435 | Fungi | Fungi | 168 | 1.03e-50 | NR | KAJ3354468.1 | 109932 | g365 | i0 | 71.9 | 31.9416058394161 | 121 | 32 | 88.3 | 1 | 44 | 406 | 7 | 125 | KAJ3354468.1 Histone H2A type 1-C [Entophlyctis luteolus] | diamond | 13128 | 169 | 0.994082840236686 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis luteolus | |
| 26747075 | 26747075 | PRJNA999747_S_NODE_681_length_336_cov_3.163934_g649_i0 | PRJNA999747 | 681 | 336 | 3.163934 | 10.63081824 | Exophiala | 5583 | Fungi | Fungi | 53.5 | 1.51e-5 | NR | KAJ4516297.1 | 5970 | g649 | i0 | 40.7 | 2.23214285714286 | 81 | 38 | 71.4 | 2 | 332 | 93 | 232 | 303 | KAJ4516297.1 hypothetical protein HRR73_004759 [Exophiala dermatitidis] | diamond | 750 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala dermatitidis | |
| 27158484 | 27158484 | PRJNA999747_S_NODE_2802_length_186_cov_2.354839_g2770_i0 | PRJNA999747 | 2802 | 186 | 2.354839 | 4.38000054 | Fungi | 4751 | Fungi | Fungi | 87.4 | 1.35e-19 | NR | XP_066787155.1 | 44089 | g2770 | i0 | 66.1 | 21.6129032258065 | 59 | 20 | 95.2 | 0 | 180 | 4 | 123 | 181 | XP_066787155.1 thioredoxin-like protein [Dipodascopsis tothii] | diamond | 4020 | 87.8 | 0.995444191343964 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Dipodascopsis | Dipodascopsis tothii | |
| 27342827 | 27342827 | PRJNA999747_S_NODE_2143_length_208_cov_3.694915_g2111_i0 | PRJNA999747 | 2143 | 208 | 3.694915 | 7.6854232 | Austropuccinia psidii | 181123 | Fungi | Fungi | 71.6 | 9.29e-14 | NR | MBW0462034.1 | 1389203 | g2111 | i0 | 64.2 | 6.47596153846154 | 53 | 19 | 76.4 | 0 | 3 | 161 | 64 | 116 | MBW0462034.1 hypothetical protein [Austropuccinia psidii MF-1] | diamond | 1347 | 71.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Sphaerophragmiaceae | Austropuccinia | Austropuccinia psidii | |
| 27816459 | 27816459 | PRJNA999747_S_NODE_2444_length_197_cov_2.789157_g2412_i0 | PRJNA999747 | 2444 | 197 | 2.789157 | 5.49463929 | Lojkania enalia | 147567 | Fungi | Fungi | 42.4 | 0.0266 | NR | KAF2257479.1 | 147567 | g2412 | i0 | 47.3 | 0.83756345177665 | 55 | 28 | 83.8 | 1 | 20 | 184 | 167 | 220 | KAF2257479.1 hypothetical protein CC78DRAFT_563415 [Lojkania enalia] | diamond | 165 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Lojkania | Lojkania enalia | ||
| 27910735 | 27910735 | PRJNA999747_S_NODE_1165_length_277_cov_2.707317_g1133_i0 | PRJNA999747 | 1165 | 277 | 2.707317 | 7.49926809 | Aspergillus pseudoviridinutans | 1517512 | Fungi | Fungi | 56.6 | 4.64e-7 | NR | XP_043157348.1 | 1517512 | g1133 | i0 | 46.7 | 2.42599277978339 | 60 | 31 | 65 | 1 | 62 | 241 | 67 | 125 | XP_043157348.1 uncharacterized protein Asppvi_005492 [Aspergillus pseudoviridinutans] | diamond | 672 | 56.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus pseudoviridinutans | |
| 28068806 | 28068806 | PRJNA999747_S_NODE_2885_length_183_cov_6.802632_g2853_i0 | PRJNA999747 | 2885 | 183 | 6.802632 | 12.44881656 | Scheffersomyces stipitis CBS 6 | 4924 | Fungi | Fungi | 49.7 | 1.84e-5 | NR | XP_001387993.2 | 322104 | g2853 | i0 | 45.5 | 1.81967213114754 | 55 | 27 | 85.2 | 1 | 158 | 3 | 5 | 59 | XP_001387993.2 predicted protein [Scheffersomyces stipitis CBS 6054] | diamond | 333 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Scheffersomyces | Scheffersomyces stipitis | |
| 29211528 | 29211528 | PRJNA999747_S_NODE_2569_length_193_cov_2.753086_g2537_i0 | PRJNA999747 | 2569 | 193 | 2.753086 | 5.31345598 | Opisthokonta | 33154 | Fungi | Fungi | 67.8 | 3.33e-12 | NR | KAI8890078.1 | 1314798 | g2537 | i0 | 75.6 | 1.9119170984456 | 41 | 10 | 63.7 | 0 | 4 | 126 | 125 | 165 | KAI8890078.1 peptidyl-prolyl cis-trans isomerase cyclophilin type [Backusella circina FSU 941] | diamond | 369 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Backusellaceae | Backusella | Backusella circina | |
| 30247930 | 30247930 | PRJNA999747_S_NODE_3412_length_170_cov_2.035971_g3380_i0 | PRJNA999747 | 3412 | 170 | 2.035971 | 3.4611507 | Candida verbasci | 1227364 | Fungi | Fungi | 42.4 | 0.018 | NR | CAI5758658.1 | 1227364 | g3380 | i0 | 51 | 0.9 | 51 | 21 | 90 | 2 | 4 | 156 | 199 | 245 | CAI5758658.1 unnamed protein product [Candida verbasci] | diamond | 153 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida verbasci | |
| 30247931 | 30247931 | PRJNA999747_S_NODE_952_length_299_cov_3.410448_g920_i0 | PRJNA999747 | 952 | 299 | 3.410448 | 10.19723952 | Penicillium malachiteum | 1324776 | Fungi | Fungi | 43.5 | 0.0196 | NR | KAJ5710222.1 | 1324776 | g920 | i0 | 65.5 | 0.290969899665552 | 29 | 10 | 29.1 | 0 | 48 | 134 | 97 | 125 | KAJ5710222.1 hypothetical protein N7493_009389 [Penicillium malachiteum] | diamond | 87 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium malachiteum | |
| 30759155 | 30759155 | PRJNA999747_S_NODE_2134_length_209_cov_1.932584_g2102_i0 | PRJNA999747 | 2134 | 209 | 1.932584 | 4.03910056 | Opisthokonta | 33154 | Fungi | Fungi | 52 | 9.01e-6 | NR | TQB67787.1 | 5098 | g2102 | i0 | 45.1 | 7.09090909090909 | 71 | 24 | 80.4 | 3 | 1 | 168 | 43 | 113 | TQB67787.1 Elongation factor [Monascus purpureus] | diamond | 1482 | 52.4 | 0.99236641221374 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Monascus | Monascus purpureus | |
| 31163671 | 31163671 | PRJNA999747_S_NODE_3695_length_164_cov_2.601504_g3663_i0 | PRJNA999747 | 3695 | 164 | 2.601504 | 4.26646656 | Rhizophlyctis rosea | 64517 | Fungi | Fungi | 58.9 | 2.47e-8 | NR | KAJ3043537.1 | 64517 | g3663 | i0 | 58.5 | 1.9390243902439 | 53 | 22 | 97 | 0 | 160 | 2 | 409 | 461 | KAJ3043537.1 hypothetical protein HK097_001731 [Rhizophlyctis rosea] | diamond | 318 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 31416965 | 31416965 | PRJNA999747_S_NODE_1756_length_228_cov_2.157360_g1724_i0 | PRJNA999747 | 1756 | 228 | 2.15736 | 4.9187808 | Ambrosiozyma monospora | 43982 | Fungi | Fungi | 91.7 | 8.16e-22 | NR | GMG40253.1 | 43982 | g1724 | i0 | 61.4 | 2.73684210526316 | 70 | 27 | 92.1 | 0 | 7 | 216 | 31 | 100 | GMG40253.1 unnamed protein product [Ambrosiozyma monospora] | diamond | 624 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Ambrosiozyma | Ambrosiozyma monospora | |
| 31638265 | 31638265 | PRJNA999747_S_NODE_3756_length_163_cov_2.045455_g3724_i0 | PRJNA999747 | 3756 | 163 | 2.045455 | 3.33409165 | Tilletiaria anomala UBC 951 | 1037660 | Fungi | Fungi | 93.2 | 2.07e-20 | NR | XP_013244530.1 | 1037660 | g3724 | i0 | 82.7 | 4.78527607361963 | 52 | 9 | 95.7 | 0 | 160 | 5 | 175 | 226 | XP_013244530.1 Myo-inositol-1-phosphate synthase [Tilletiaria anomala UBC 951] | diamond | 780 | 93.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Georgefischeriales | Tilletiariaceae | Tilletiaria | Tilletiaria anomala | |
| 31891402 | 31891402 | PRJNA999747_S_NODE_2277_length_203_cov_2.104651_g2245_i0 | PRJNA999747 | 2277 | 203 | 2.104651 | 4.27244153 | Olpidium bornovanus | 278681 | Fungi | Fungi | 110 | 3.7e-26 | NR | BAL15351.1 | 278681 | g2245 | i0 | 77.3 | 0.975369458128079 | 66 | 15 | 97.5 | 0 | 5 | 202 | 144 | 209 | BAL15351.1 translation elongation factor 2, partial [Olpidium bornovanus] | diamond | 198 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium bornovanus | |
| 32144573 | 32144573 | PRJNA999747_S_NODE_3078_length_178_cov_2.659864_g3046_i0 | PRJNA999747 | 3078 | 178 | 2.659864 | 4.73455792 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 80.5 | 7.85e-16 | NR | WFD16437.1 | 1514897 | g3046 | i0 | 74.2 | 1.04494382022472 | 62 | 4 | 84.3 | 1 | 177 | 28 | 947 | 1008 | WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei] | diamond | 186 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 32593383 | 32593383 | PRJNA999747_S_NODE_1719_length_230_cov_2.547739_g1687_i0 | PRJNA999747 | 1719 | 230 | 2.547739 | 5.8597997 | Fungi | 4751 | Fungi | Fungi | 72.4 | 1.76e-13 | NR | RUS25710.1 | 994334 | g1687 | i0 | 55.9 | 4.8 | 68 | 30 | 88.7 | 0 | 226 | 23 | 111 | 178 | RUS25710.1 S25 ribosomal protein-domain-containing protein [Jimgerdemannia flammicorona] | diamond | 1104 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Endogonaceae | Jimgerdemannia | Jimgerdemannia flammicorona |
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);;