contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA675042" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 645848 | 645848 | PRJNA675042_P_NODE_120861_length_249_cov_0.875000_g120411_i0 | PRJNA675042 | 120861 | 249 | 0.875 | 2.17875 | Tricholomella constricta | 117010 | Fungi | Fungi | 138 | 8.199999999999999e-36 | NR | KAF5386610.1 | 117010 | g120411 | i0 | 91.7 | 1.81927710843373 | 72 | 6 | 86.7 | 0 | 217 | 2 | 70 | 141 | KAF5386610.1 hypothetical protein D9615_001930 [Tricholomella constricta] | diamond | 453 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Tricholomella | Tricholomella constricta | |
| 6272226 | 6272226 | PRJNA675042_P_NODE_5565_length_606_cov_9.227017_g5132_i0 | PRJNA675042 | 5565 | 606 | 9.227017 | 55.91572302 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 213 | 7.8e-60 | NR | XP_069226237.1 | 1052096 | g5132 | i0 | 96.4 | 0.544554455445545 | 110 | 4 | 54.5 | 0 | 332 | 3 | 245 | 354 | XP_069226237.1 uncharacterized protein WHR41_07999 [Cladosporium halotolerans] | diamond | 330 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 13400946 | 13400946 | PRJNA675042_P_NODE_35851_length_354_cov_1.501779_g35401_i0 | PRJNA675042 | 35851 | 354 | 1.501779 | 5.31629766 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 148 | 2.46e-39 | NR | XP_069228774.1 | 1052096 | g35401 | i0 | 90.1 | 0.771186440677966 | 91 | 8 | 77.1 | 1 | 5 | 277 | 453 | 542 | XP_069228774.1 uncharacterized protein WHR41_06021 [Cladosporium halotolerans] | diamond | 273 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 26828851 | 26828851 | PRJNA675042_P_NODE_181941_length_229_cov_4.141026_g181491_i0 | PRJNA675042 | 181941 | 229 | 4.141026 | 9.48294954 | Stereum hirsutum FP-91666 SS1 | 721885 | Fungi | Fungi | 60.1 | 1.3e-8 | NR | XP_007308664.1 | 721885 | g181491 | i0 | 61.5 | 0.681222707423581 | 52 | 18 | 68.1 | 1 | 55 | 210 | 6 | 55 | XP_007308664.1 ICMT-domain-containing protein [Stereum hirsutum FP-91666 SS1] | diamond | 156 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Stereum | Stereum hirsutum | |
| 27144686 | 27144686 | PRJNA675042_P_NODE_38042_length_349_cov_0.811594_g37592_i0 | PRJNA675042 | 38042 | 349 | 0.811594 | 2.83246306 | Polyporus grammocephalus | 196234 | Fungi | Fungi | 41.2 | 0.049 | NR | ACT52857.1 | 196234 | g37592 | i0 | 51.2 | 0.369627507163324 | 43 | 21 | 37 | 0 | 86 | 214 | 12 | 54 | ACT52857.1 retrotransposon protein, partial [Polyporus grammocephalus] | diamond | 129 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Polyporus | Polyporus grammocephalus | |
| 27429770 | 27429770 | PRJNA675042_P_NODE_26323_length_385_cov_1.714744_g25873_i0 | PRJNA675042 | 26323 | 385 | 1.714744 | 6.6017644 | Racocetra persica | 160502 | Fungi | Fungi | 47.4 | 0.0041 | NR | CAG8723677.1 | 160502 | g25873 | i0 | 44.4 | 0.490909090909091 | 63 | 35 | 49.1 | 0 | 4 | 192 | 378 | 440 | CAG8723677.1 17464_t:CDS:2, partial [Racocetra persica] | diamond | 189 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Racocetra | Racocetra persica | |
| 27619043 | 27619043 | PRJNA675042_P_NODE_138584_length_247_cov_0.885057_g138134_i0 | PRJNA675042 | 138584 | 247 | 0.885057 | 2.18609079 | Saitoella complicata NRRL Y-178 | 5606 | Fungi | Fungi | 53.1 | 7.83e-6 | NR | GAO51261.1 | 698492 | g138134 | i0 | 30.9 | 3.86234817813765 | 81 | 56 | 98.4 | 0 | 3 | 245 | 61 | 141 | GAO51261.1 hypothetical protein G7K_5367-t1 [Saitoella complicata NRRL Y-17804] | diamond | 954 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saitoella | Saitoella complicata | ||||
| 27902965 | 27902965 | PRJNA675042_P_NODE_87965_length_271_cov_1.555556_g87515_i0 | PRJNA675042 | 87965 | 271 | 1.555556 | 4.21555676 | Hyaloscypha bicolor E | 1095630 | Fungi | Fungi | 47.8 | 3.99e-4 | NR | XP_024727052.1 | 1095630 | g87515 | i0 | 33.3 | 0.896678966789668 | 81 | 33 | 75.3 | 3 | 21 | 224 | 23 | 95 | XP_024727052.1 uncharacterized protein K444DRAFT_637562 [Hyaloscypha bicolor E] | diamond | 243 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Hyaloscyphaceae | Hyaloscypha | Hyaloscypha bicolor | |
| 28293753 | 28293753 | PRJNA675042_P_NODE_94226_length_264_cov_1.356021_g93776_i0 | PRJNA675042 | 94226 | 264 | 1.356021 | 3.57989544 | Eukaryota | 2759 | Fungi | Fungi | 65.1 | 6.4e-10 | NR | KAH9258498.1 | 1357716 | g93776 | i0 | 75.7 | 10.0909090909091 | 37 | 9 | 42 | 0 | 117 | 7 | 174 | 210 | KAH9258498.1 hypothetical protein BASA81_003000 [Batrachochytrium salamandrivorans] | diamond | 2664 | 65.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 28913265 | 28913265 | PRJNA675042_P_NODE_68308_length_295_cov_2.081081_g67858_i0 | PRJNA675042 | 68308 | 295 | 2.081081 | 6.13918895 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 85.9 | 7.95e-18 | NR | XP_064752093.1 | 1690604 | g67858 | i0 | 46.9 | 2.91864406779661 | 96 | 50 | 97.6 | 1 | 4 | 291 | 155 | 249 | XP_064752093.1 uncharacterized protein LTR64_006688 [Lithohypha guttulata] | diamond | 861 | 85.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 29639441 | 29639441 | PRJNA675042_P_NODE_88350_length_271_cov_1.141414_g87900_i0 | PRJNA675042 | 88350 | 271 | 1.141414 | 3.09323194 | uncultured Trichoderma | 265189 | Fungi | Fungi | 89.7 | 3.63e-21 | NR | AIA84157.1 | 265189 | g87900 | i0 | 59.5 | 0.874538745387454 | 79 | 32 | 87.5 | 0 | 269 | 33 | 14 | 92 | AIA84157.1 CAZy families GH18 protein [uncultured Trichoderma] | diamond | 237 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | uncultured Trichoderma | ||
| 29797437 | 29797437 | PRJNA675042_P_NODE_29151_length_375_cov_4.033113_g28701_i0 | PRJNA675042 | 29151 | 375 | 4.033113 | 15.12417375 | Malassezia restricta | 76775 | Fungi | Fungi | 116 | 3.1199999999999997e-31 | NR | XP_027485477.1 | 76775 | g28701 | i0 | 70.7 | 1.192 | 75 | 18 | 56.8 | 1 | 280 | 68 | 6 | 80 | XP_027485477.1 NADH-ubiquinone oxidoreductase 9.5 kDa subunit [Malassezia restricta] | diamond | 447 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 29924042 | 29924042 | PRJNA675042_P_NODE_57391_length_312_cov_1.062762_g56941_i0 | PRJNA675042 | 57391 | 312 | 1.062762 | 3.31581744 | Lipomyces japonicus | 56871 | Fungi | Fungi | 44.3 | 0.0198 | NR | XP_066780918.1 | 56871 | g56941 | i0 | 43.6 | 0.528846153846154 | 55 | 30 | 51.9 | 1 | 209 | 48 | 63 | 117 | XP_066780918.1 SGNH hydrolase-type esterase domain-containing protein [Lipomyces japonicus] | diamond | 165 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces japonicus | |
| 30239915 | 30239915 | PRJNA675042_P_NODE_68112_length_296_cov_0.991031_g67662_i0 | PRJNA675042 | 68112 | 296 | 0.991031 | 2.93345176 | Anaeromyces robustus | 1754192 | Fungi | Fungi | 49.7 | 2.42e-4 | NR | ORX88284.1 | 1754192 | g67662 | i0 | 39 | 0.831081081081081 | 82 | 47 | 80.1 | 2 | 248 | 12 | 281 | 362 | ORX88284.1 hypothetical protein BCR32DRAFT_263717 [Anaeromyces robustus] | diamond | 246 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Anaeromyces | Anaeromyces robustus | |
| 30713698 | 30713698 | PRJNA675042_P_NODE_13734_length_455_cov_3.916230_g13284_i0 | PRJNA675042 | 13734 | 455 | 3.91623 | 17.8188465 | Cladophialophora chaetospira | 386627 | Fungi | Fungi | 208 | 5.220000000000001e-59 | NR | KAJ9608079.1 | 386627 | g13284 | i0 | 91.9 | 0.817582417582418 | 124 | 10 | 81.8 | 0 | 82 | 453 | 175 | 298 | KAJ9608079.1 plasma membrane localization protein [Cladophialophora chaetospira] | diamond | 372 | 208 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Cladophialophora | Cladophialophora chaetospira | |
| 30966730 | 30966730 | PRJNA675042_P_NODE_48034_length_328_cov_0.850980_g47584_i0 | PRJNA675042 | 48034 | 328 | 0.85098 | 2.7912144 | Podila humilis | 64523 | Fungi | Fungi | 54.3 | 7.36e-7 | NR | KAI9236711.1 | 64523 | g47584 | i0 | 62.8 | 0.393292682926829 | 43 | 16 | 39.3 | 0 | 213 | 85 | 48 | 90 | KAI9236711.1 MAG: hypothetical protein BYD32DRAFT_369445, partial [Podila humilis] | diamond | 129 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Podila | Podila humilis | |
| 31705595 | 31705595 | PRJNA675042_P_NODE_5437_length_611_cov_1.295539_g5006_i0 | PRJNA675042 | 5437 | 611 | 1.295539 | 7.91574329 | Talaromyces | 5094 | Fungi | Fungi | 148 | 2.68e-41 | NR | KAI7970711.1 | 128442 | g5006 | i0 | 75.3 | 2.50409165302782 | 85 | 21 | 41.7 | 0 | 2 | 256 | 96 | 180 | KAI7970711.1 hypothetical protein EIK77_007891 [Talaromyces pinophilus] | diamond | 1530 | 149 | 0.993288590604027 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces pinophilus | |
| 32642256 | 32642256 | PRJNA675042_P_NODE_178500_length_241_cov_0.916667_g178050_i0 | PRJNA675042 | 178500 | 241 | 0.916667 | 2.20916747 | Ogataea polymorpha | 460523 | Fungi | Fungi | 58.9 | 4.14e-8 | NR | KAH3659872.1 | 460523 | g178050 | i0 | 53.7 | 1.34439834024896 | 54 | 25 | 67.2 | 0 | 191 | 30 | 138 | 191 | KAH3659872.1 hypothetical protein OGATHE_005917 [Ogataea polymorpha] | diamond | 324 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Ogataea | Ogataea polymorpha |
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);;