contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA886442" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9789804 | 9789804 | PRJNA886442_P_NODE_12948_length_247_cov_0.896552_g12784_i0 | PRJNA886442 | 12948 | 247 | 0.896552 | 2.21448344 | Viridothelium virens | 1048519 | Fungi | Fungi | 108 | 7.05e-27 | NR | KAF2231410.1 | 1048519 | g12784 | i0 | 76.9 | 0.789473684210526 | 65 | 15 | 78.9 | 0 | 52 | 246 | 1 | 65 | KAF2231410.1 lytic polysaccharide monooxygenase [Viridothelium virens] | diamond | 195 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Trypetheliales | Trypetheliaceae | Viridothelium | Viridothelium virens | |
| 22538618 | 22538618 | PRJNA886442_P_NODE_11138_length_251_cov_0.876404_g10974_i0 | PRJNA886442 | 11138 | 251 | 0.876404 | 2.19977404 | Ascomycota | 4890 | Fungi | Fungi | 164 | 3.36e-47 | NR | KKY24457.1 | 158046 | g10974 | i0 | 90.4 | 77.3784860557769 | 83 | 8 | 99.2 | 0 | 1 | 249 | 168 | 250 | KKY24457.1 putative cytosolic fe-s cluster assembling factor nbp35 [Phaeomoniella chlamydospora] | diamond | 19422 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Phaeomoniellales | Phaeomoniellaceae | Phaeomoniella | Phaeomoniella chlamydospora | |
| 26738502 | 26738502 | PRJNA886442_P_NODE_14021_length_244_cov_1.777778_g13857_i0 | PRJNA886442 | 14021 | 244 | 1.777778 | 4.33777832 | Aspergillus multicolor | 41759 | Fungi | Fungi | 105 | 5.47e-27 | NR | KAL4900459.1 | 41759 | g13857 | i0 | 64.1 | 3.94672131147541 | 78 | 25 | 94.7 | 2 | 232 | 2 | 53 | 128 | KAL4900459.1 hypothetical protein BDW74DRAFT_161960 [Aspergillus multicolor] | diamond | 963 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus multicolor | |
| 27340079 | 27340079 | PRJNA886442_P_NODE_9343_length_264_cov_1.382199_g9179_i0 | PRJNA886442 | 9343 | 264 | 1.382199 | 3.64900536 | Zasmidium cellare ATCC 36951 | 1080233 | Fungi | Fungi | 45.1 | 0.0065 | NR | XP_033673329.1 | 1080233 | g9179 | i0 | 44.2 | 1.61363636363636 | 43 | 24 | 48.9 | 0 | 176 | 48 | 172 | 214 | XP_033673329.1 uncharacterized protein M409DRAFT_35630 [Zasmidium cellare ATCC 36951] | diamond | 426 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 27434918 | 27434918 | PRJNA886442_P_NODE_10363_length_253_cov_0.866667_g10199_i0 | PRJNA886442 | 10363 | 253 | 0.866667 | 2.19266751 | Mollisia scopiformis | 149040 | Fungi | Fungi | 90.9 | 2.0200000000000003e-21 | NR | XP_018068631.1 | 149040 | g10199 | i0 | 67.8 | 0.699604743083004 | 59 | 18 | 70 | 1 | 20 | 196 | 21 | 78 | XP_018068631.1 uncharacterized protein LY89DRAFT_736321 [Mollisia scopiformis] | diamond | 177 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Mollisiaceae | Mollisia | Mollisia scopiformis | |
| 27719308 | 27719308 | PRJNA886442_P_NODE_11104_length_251_cov_0.876404_g10940_i0 | PRJNA886442 | 11104 | 251 | 0.876404 | 2.19977404 | Fusarium graminearum | 5518 | Fungi | Fungi | 146 | 5.94e-44 | NR | CAF3469949.1 | 5518 | g10940 | i0 | 96 | 0.896414342629482 | 75 | 3 | 89.6 | 0 | 249 | 25 | 8 | 82 | CAF3469949.1 unnamed protein product [Fusarium graminearum] | diamond | 225 | 146 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium graminearum | |
| 28129431 | 28129431 | PRJNA886442_P_NODE_13645_length_245_cov_1.360465_g13481_i0 | PRJNA886442 | 13645 | 245 | 1.360465 | 3.33313925 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 114 | 1.64e-27 | NR | XP_069225816.1 | 1052096 | g13481 | i0 | 65.8 | 0.96734693877551 | 79 | 21 | 96.7 | 1 | 240 | 4 | 164 | 236 | XP_069225816.1 uncharacterized protein WHR41_08614 [Cladosporium halotolerans] | diamond | 237 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 28666210 | 28666210 | PRJNA886442_P_NODE_13367_length_246_cov_0.901734_g13203_i0 | PRJNA886442 | 13367 | 246 | 0.901734 | 2.21826564 | Clonostachys rosea f. rosea IK726 | 1349383 | Fungi | Fungi | 55.1 | 1.81e-6 | NR | CAG9953918.1 | 1349383 | g13203 | i0 | 45.7 | 1.70731707317073 | 70 | 38 | 85.4 | 0 | 1 | 210 | 629 | 698 | CAG9953918.1 unnamed protein product [Clonostachys rosea f. rosea IK726] | diamond | 420 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Bionectriaceae | Clonostachys | Clonostachys rosea | |
| 30434917 | 30434917 | PRJNA886442_P_NODE_11533_length_250_cov_0.881356_g11369_i0 | PRJNA886442 | 11533 | 250 | 0.881356 | 2.20339 | Niveomyces insectorum RCEF 264 | 1081102 | Fungi | Fungi | 99 | 6.84e-22 | NR | OAA57131.1 | 1081102 | g11369 | i0 | 60.8 | 0.948 | 79 | 31 | 94.8 | 0 | 249 | 13 | 745 | 823 | OAA57131.1 phd finger domain protein [Niveomyces insectorum RCEF 264] | diamond | 237 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Niveomyces | Niveomyces insectorum | |
| 30497865 | 30497865 | PRJNA886442_P_NODE_2733_length_427_cov_1.274011_g2569_i0 | PRJNA886442 | 2733 | 427 | 1.274011 | 5.44002697 | Pichia californica | 460514 | Fungi | Fungi | 46.2 | 0.0156 | NR | KAG0686347.1 | 460514 | g2569 | i0 | 28.7 | 0.807962529274005 | 115 | 77 | 77.3 | 2 | 35 | 364 | 90 | 204 | KAG0686347.1 hypothetical protein C6P40_004370, partial [Pichia californica] | diamond | 345 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia californica | |
| 30592486 | 30592486 | PRJNA886442_P_NODE_13793_length_245_cov_0.906977_g13629_i0 | PRJNA886442 | 13793 | 245 | 0.906977 | 2.22209365 | Fusarium kuroshium | 2010991 | Fungi | Fungi | 151 | 1.04e-40 | NR | RMJ07901.1 | 2010991 | g13629 | i0 | 86.4 | 0.991836734693878 | 81 | 11 | 99.2 | 0 | 1 | 243 | 117 | 197 | RMJ07901.1 hypothetical protein CDV36_012495 [Fusarium kuroshium] | diamond | 243 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium kuroshium | |
| 30782145 | 30782145 | PRJNA886442_P_NODE_13934_length_245_cov_0.906977_g13770_i0 | PRJNA886442 | 13934 | 245 | 0.906977 | 2.22209365 | Alternaria alternata | 5599 | Fungi | Fungi | 71.6 | 6.47e-14 | NR | KAH8634978.1 | 5599 | g13770 | i0 | 86.4 | 0.538775510204082 | 44 | 6 | 53.9 | 0 | 35 | 166 | 1 | 44 | KAH8634978.1 hypothetical protein IG631_10378 [Alternaria alternata] | diamond | 132 | 71.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 31105871 | 31105871 | PRJNA886442_P_NODE_10955_length_252_cov_0.871508_g10791_i0 | PRJNA886442 | 10955 | 252 | 0.871508 | 2.19620016 | Clonostachys | 110564 | Fungi | Fungi | 180 | 1.21e-56 | NR | VUC20393.1 | 29856 | g10791 | i0 | 97.6 | 2 | 84 | 2 | 100 | 0 | 252 | 1 | 6 | 89 | VUC20393.1 unnamed protein product, partial [Clonostachys rosea] | diamond | 504 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Bionectriaceae | Clonostachys | Clonostachys rosea | |
| 31192518 | 31192518 | PRJNA886442_P_NODE_12955_length_247_cov_0.896552_g12791_i0 | PRJNA886442 | 12955 | 247 | 0.896552 | 2.21448344 | Microthyrium microscopicum | 703497 | Fungi | Fungi | 50.8 | 5.53e-5 | NR | KAF2669269.1 | 703497 | g12791 | i0 | 42.7 | 0.995951417004049 | 82 | 44 | 99.6 | 2 | 2 | 247 | 284 | 362 | KAF2669269.1 hypothetical protein BT63DRAFT_455246 [Microthyrium microscopicum] | diamond | 246 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Microthyriales | Microthyriaceae | Microthyrium | Microthyrium microscopicum | |
| 31477715 | 31477715 | PRJNA886442_P_NODE_3956_length_370_cov_1.636364_g3792_i0 | PRJNA886442 | 3956 | 370 | 1.636364 | 6.0545468 | Trichoderma harzianum | 5544 | Fungi | Fungi | 77 | 1.48e-13 | NR | AAF89327.2 | 5544 | g3792 | i0 | 67.2 | 0.948648648648649 | 61 | 19 | 48.6 | 1 | 203 | 24 | 6 | 66 | AAF89327.2 ORF1 [Trichoderma harzianum] | diamond | 351 | 77 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma harzianum | |
| 31825296 | 31825296 | PRJNA886442_P_NODE_3737_length_379_cov_0.718954_g3573_i0 | PRJNA886442 | 3737 | 379 | 0.718954 | 2.72483566 | Xylaria longipes | 114818 | Fungi | Fungi | 47.4 | 0.00374 | NR | RYC56572.1 | 114818 | g3573 | i0 | 48.4 | 1.36147757255937 | 64 | 29 | 47.5 | 3 | 184 | 363 | 306 | 369 | RYC56572.1 hypothetical protein CHU98_g9638 [Xylaria longipes] | diamond | 516 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria longipes | |
| 31920400 | 31920400 | PRJNA886442_P_NODE_5697_length_323_cov_0.920000_g5533_i0 | PRJNA886442 | 5697 | 323 | 0.92 | 2.9716 | Teratosphaeriaceae sp. CCFEE 6253 | 2901253 | Fungi | Fungi | 56.2 | 4.99e-7 | NR | KAK3069053.1 | 2901253 | g5533 | i0 | 34.8 | 0.826625386996904 | 89 | 58 | 82.7 | 0 | 55 | 321 | 60 | 148 | KAK3069053.1 hypothetical protein LTR53_012910 [Teratosphaeriaceae sp. CCFEE 6253] | diamond | 267 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Teratosphaeriaceae sp. CCFEE 6253 | ||
| 31928240 | 31928240 | PRJNA886442_P_NODE_15197_length_242_cov_0.923077_g15033_i0 | PRJNA886442 | 15197 | 242 | 0.923077 | 2.23384634 | Schizosaccharomyces | 4895 | Fungi | Fungi | 128 | 1.57e-32 | NR | NP_595092.1 | 4896 | g15033 | i0 | 77.5 | 2.97520661157025 | 80 | 18 | 99.2 | 0 | 241 | 2 | 215 | 294 | NP_595092.1 DNA replication factor A subunit Ssb1 [Schizosaccharomyces pombe] | diamond | 720 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe | |
| 32205203 | 32205203 | PRJNA886442_P_NODE_14658_length_243_cov_0.917647_g14494_i0 | PRJNA886442 | 14658 | 243 | 0.917647 | 2.22988221 | Cyberlindnera fabianii | 36022 | Fungi | Fungi | 71.2 | 2.51e-12 | NR | ONH70058.1 | 36022 | g14494 | i0 | 42.7 | 1.09876543209877 | 89 | 41 | 97.5 | 1 | 6 | 242 | 119 | 207 | ONH70058.1 hypothetical protein BON22_0348 [Cyberlindnera fabianii] | diamond | 267 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Phaffomycetaceae | Cyberlindnera | Cyberlindnera fabianii |
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);;