contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1156092" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11781364 | 11781364 | PRJNA1156092_P_NODE_18150_length_276_cov_1.507389_g18020_i0 | PRJNA1156092 | 18150 | 276 | 1.507389 | 4.16039364 | Ascomycota | 4890 | Fungi | Fungi | 63.9 | 4.86e-10 | NR | XP_044655807.1 | 84275 | g18020 | i0 | 55.7 | 4.77173913043478 | 61 | 26 | 65.2 | 1 | 217 | 38 | 6 | 66 | XP_044655807.1 uncharacterized protein CKM354_000462700 [Cercospora kikuchii] | diamond | 1317 | 64.3 | 0.993779160186625 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Cercospora | Cercospora kikuchii | |
| 26870121 | 26870121 | PRJNA1156092_P_NODE_9821_length_353_cov_1.503571_g9691_i0 | PRJNA1156092 | 9821 | 353 | 1.503571 | 5.30760563 | Ascomycota | 4890 | Fungi | Fungi | 60.5 | 1.95e-8 | NR | KAI2732586.1 | 5082 | g9691 | i0 | 28.9 | 13.6317280453258 | 114 | 72 | 89.2 | 1 | 37 | 351 | 27 | 140 | KAI2732586.1 hypothetical protein CBS147332_1725 [Penicillium roqueforti] | diamond | 4812 | 60.8 | 0.995065789473684 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium roqueforti | |
| 27008478 | 27008478 | PRJNA1156092_P_NODE_23962_length_249_cov_0.875000_g23832_i0 | PRJNA1156092 | 23962 | 249 | 0.875 | 2.17875 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 158 | 1.13e-42 | NR | XP_069227523.1 | 1052096 | g23832 | i0 | 95.2 | 1 | 83 | 4 | 100 | 0 | 249 | 1 | 586 | 668 | XP_069227523.1 uncharacterized protein WHR41_06347 [Cladosporium halotolerans] | diamond | 249 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 27356554 | 27356554 | PRJNA1156092_P_NODE_31203_length_242_cov_0.911243_g31073_i0 | PRJNA1156092 | 31203 | 242 | 0.911243 | 2.20520806 | Aspergillus flavus | 5059 | Fungi | Fungi | 113 | 4.5e-27 | NR | XP_071364244.1 | 5059 | g31073 | i0 | 64.6 | 8.81404958677686 | 79 | 28 | 97.9 | 0 | 238 | 2 | 794 | 872 | XP_071364244.1 uncharacterized protein F9C07_2203631 [Aspergillus flavus] | diamond | 2133 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus flavus | |
| 27849228 | 27849228 | PRJNA1156092_P_NODE_32384_length_241_cov_0.916667_g32254_i0 | PRJNA1156092 | 32384 | 241 | 0.916667 | 2.20916747 | Pleosporaceae | 28556 | Fungi | Fungi | 94 | 1.57e-22 | NR | XP_014557988.1 | 930091 | g32254 | i0 | 94.5 | 2.81327800829876 | 55 | 3 | 68.5 | 0 | 233 | 69 | 78 | 132 | XP_014557988.1 hypothetical protein COCVIDRAFT_95579 [Bipolaris victoriae FI3] | diamond | 678 | 94.4 | 0.995762711864407 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Bipolaris | Bipolaris victoriae | |
| 28354532 | 28354532 | PRJNA1156092_P_NODE_18426_length_274_cov_1.532338_g18296_i0 | PRJNA1156092 | 18426 | 274 | 1.532338 | 4.19860612 | Colletotrichum | 5455 | Fungi | Fungi | 80.9 | 2.08e-15 | NR | XP_049148845.1 | 145971 | g18296 | i0 | 45.7 | 5.01459854014599 | 92 | 49 | 99.6 | 1 | 274 | 2 | 191 | 282 | XP_049148845.1 vacuolar protein sorting-associated protein 4 [Colletotrichum lupini] | diamond | 1374 | 80.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum lupini | |
| 28619554 | 28619554 | PRJNA1156092_P_NODE_21587_length_252_cov_1.720670_g21457_i0 | PRJNA1156092 | 21587 | 252 | 1.72067 | 4.3360884 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 65.9 | 3.07e-10 | NR | XP_069232672.1 | 1052096 | g21457 | i0 | 54.3 | 0.964285714285714 | 81 | 31 | 96.4 | 3 | 10 | 252 | 614 | 688 | XP_069232672.1 uncharacterized protein WHR41_01543 [Cladosporium halotolerans] | diamond | 243 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 29314020 | 29314020 | PRJNA1156092_P_NODE_32109_length_241_cov_0.916667_g31979_i0 | PRJNA1156092 | 32109 | 241 | 0.916667 | 2.20916747 | Aspergillus unguis | 40381 | Fungi | Fungi | 97.4 | 9.73e-22 | NR | KAL4805541.1 | 40381 | g31979 | i0 | 59.5 | 0.921161825726141 | 74 | 30 | 92.1 | 0 | 239 | 18 | 332 | 405 | KAL4805541.1 hypothetical protein BDV18DRAFT_141218 [Aspergillus unguis] | diamond | 222 | 97.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus unguis | |
| 29724183 | 29724183 | PRJNA1156092_P_NODE_3470_length_540_cov_1.646681_g3341_i0 | PRJNA1156092 | 3470 | 540 | 1.646681 | 8.8920774 | Candida tropicalis MYA-34 | 5482 | Fungi | Fungi | 52 | 4.05e-4 | NR | XP_002548829.1 | 294747 | g3341 | i0 | 29.3 | 0.816666666666667 | 147 | 85 | 71.7 | 4 | 33 | 419 | 714 | 859 | XP_002548829.1 predicted protein [Candida tropicalis MYA-3404] | diamond | 441 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida tropicalis | |
| 30028260 | 30028260 | PRJNA1156092_P_NODE_28071_length_245_cov_0.895349_g27941_i0 | PRJNA1156092 | 28071 | 245 | 0.895349 | 2.19360505 | Fungi | 4751 | Fungi | Fungi | 117 | 2.94e-29 | NR | XP_064771628.1 | 54550 | g27941 | i0 | 68.8 | 7.8 | 80 | 25 | 98 | 0 | 244 | 5 | 252 | 331 | XP_064771628.1 peroxisomal 3-oxoacyl-CoA thiolase [Myxozyma melibiosi] | diamond | 1911 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Myxozyma | Myxozyma melibiosi | |
| 30185986 | 30185986 | PRJNA1156092_P_NODE_24312_length_249_cov_0.875000_g24182_i0 | PRJNA1156092 | 24312 | 249 | 0.875 | 2.17875 | Ascomycota | 4890 | Fungi | Fungi | 137 | 1.75e-35 | NR | CUS12833.1 | 59557 | g24182 | i0 | 79.3 | 2.96385542168675 | 82 | 17 | 98.8 | 0 | 249 | 4 | 416 | 497 | CUS12833.1 unnamed protein product [Tuber aestivum] | diamond | 738 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Tuberaceae | Tuber | Tuber aestivum | |
| 30988297 | 30988297 | PRJNA1156092_P_NODE_25294_length_248_cov_0.880000_g25164_i0 | PRJNA1156092 | 25294 | 248 | 0.88 | 2.1824 | Curvularia kusanoi | 90978 | Fungi | Fungi | 175 | 8.340000000000002e-51 | NR | KAF3008810.1 | 90978 | g25164 | i0 | 100 | 1.98387096774194 | 82 | 0 | 99.2 | 0 | 1 | 246 | 298 | 379 | KAF3008810.1 hydrolase 76 protein [Curvularia kusanoi] | diamond | 492 | 175 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Curvularia | Curvularia kusanoi | |
| 31746957 | 31746957 | PRJNA1156092_P_NODE_16157_length_290_cov_1.419355_g16027_i0 | PRJNA1156092 | 16157 | 290 | 1.419355 | 4.1161295 | Exophiala xenobiotica | 348802 | Fungi | Fungi | 46.6 | 0.00265 | NR | XP_013317913.1 | 348802 | g16027 | i0 | 37.9 | 0.682758620689655 | 66 | 38 | 68.3 | 1 | 231 | 34 | 8 | 70 | XP_013317913.1 uncharacterized protein PV05_05894 [Exophiala xenobiotica] | diamond | 198 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala xenobiotica | |
| 32443391 | 32443391 | PRJNA1156092_P_NODE_17479_length_281_cov_1.110577_g17349_i0 | PRJNA1156092 | 17479 | 281 | 1.110577 | 3.12072137 | Peltula sp. TS41687 | 2939398 | Fungi | Fungi | 50.1 | 5.74e-5 | NR | KAI9789989.1 | 2939398 | g17349 | i0 | 48.9 | 1.83629893238434 | 45 | 23 | 48 | 0 | 38 | 172 | 101 | 145 | KAI9789989.1 MAG: hypothetical protein M1816_005603 [Peltula sp. TS41687] | diamond | 516 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lichinomycetes | Lichinales | Phylliscaceae | Peltula | Peltula sp. TS41687 | |
| 32683284 | 32683284 | PRJNA1156092_P_NODE_22000_length_251_cov_0.865169_g21870_i0 | PRJNA1156092 | 22000 | 251 | 0.865169 | 2.17157419 | Dothideomycetes | 147541 | Fungi | Fungi | 103 | 1.09e-24 | NR | XP_069232500.1 | 1052096 | g21870 | i0 | 72.1 | 1.68525896414343 | 68 | 19 | 81.3 | 0 | 204 | 1 | 125 | 192 | XP_069232500.1 uncharacterized protein WHR41_02154 [Cladosporium halotolerans] | diamond | 423 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 32727150 | 32727150 | PRJNA1156092_P_NODE_25100_length_248_cov_0.880000_g24970_i0 | PRJNA1156092 | 25100 | 248 | 0.88 | 2.1824 | Rachicladosporium sp. CCFEE 5 | 2040939 | Fungi | Fungi | 126 | 1.95e-33 | NR | OQO31183.1 | 1974281 | g24970 | i0 | 87.5 | 1.54838709677419 | 64 | 8 | 77.4 | 0 | 248 | 57 | 226 | 289 | OQO31183.1 hypothetical protein B0A51_01562 [Rachicladosporium sp. CCFEE 5018] | diamond | 384 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Rachicladosporium | Rachicladosporium sp. CCFEE 5018 |
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);;