contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA807347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5909663 | 5909663 | PRJNA807347_P_NODE_11925_length_252_cov_0.871508_g11822_i0 | PRJNA807347 | 11925 | 252 | 0.871508 | 2.19620016 | Coniochaeta pulveracea | 177199 | Fungi | Fungi | 155 | 7.229999999999998e-42 | NR | RKU44198.1 | 177199 | g11822 | i0 | 94 | 0.988095238095238 | 83 | 5 | 98.8 | 0 | 251 | 3 | 683 | 765 | RKU44198.1 mannose-ethanolamine phosphotransferase gpi13 [Coniochaeta pulveracea] | diamond | 249 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Coniochaetales | Coniochaetaceae | Coniochaeta | Coniochaeta pulveracea | |
| 14834511 | 14834511 | PRJNA807347_P_NODE_13452_length_249_cov_0.880682_g13349_i0 | PRJNA807347 | 13452 | 249 | 0.880682 | 2.19289818 | Coniochaeta pulveracea | 177199 | Fungi | Fungi | 159 | 4.02e-43 | NR | RKU45570.1 | 177199 | g13349 | i0 | 92.7 | 0.987951807228916 | 82 | 6 | 98.8 | 0 | 247 | 2 | 745 | 826 | RKU45570.1 MutS-like protein [Coniochaeta pulveracea] | diamond | 246 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Coniochaetales | Coniochaetaceae | Coniochaeta | Coniochaeta pulveracea | |
| 27623029 | 27623029 | PRJNA807347_P_NODE_9884_length_269_cov_1.321429_g9781_i0 | PRJNA807347 | 9884 | 269 | 1.321429 | 3.55464401 | Trichoderma gamsii | 398673 | Fungi | Fungi | 74.7 | 4.17e-14 | NR | PNP39934.1 | 398673 | g9781 | i0 | 90 | 0.446096654275093 | 40 | 4 | 44.6 | 0 | 104 | 223 | 169 | 208 | PNP39934.1 hypothetical protein TGAMA5MH_08200 [Trichoderma gamsii] | diamond | 120 | 74.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma gamsii | |
| 29296260 | 29296260 | PRJNA807347_P_NODE_12829_length_250_cov_0.881356_g12726_i0 | PRJNA807347 | 12829 | 250 | 0.881356 | 2.20339 | Podospora fimiseda | 252190 | Fungi | Fungi | 54.3 | 3.51e-6 | NR | KAK4220855.1 | 252190 | g12726 | i0 | 54.4 | 1.752 | 57 | 21 | 63.6 | 2 | 92 | 250 | 509 | 564 | KAK4220855.1 P-loop containing nucleoside triphosphate hydrolase protein [Podospora fimiseda] | diamond | 438 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Podosporaceae | Podospora | Podospora fimiseda | |
| 29296269 | 29296269 | PRJNA807347_P_NODE_9009_length_278_cov_1.512195_g8906_i0 | PRJNA807347 | 9009 | 278 | 1.512195 | 4.2039021 | Thozetella sp. PMI_491 | 1506992 | Fungi | Fungi | 51.2 | 5.73e-5 | NR | KAH8897668.1 | 1506992 | g8906 | i0 | 46.4 | 0.60431654676259 | 56 | 22 | 51.8 | 1 | 146 | 3 | 408 | 463 | KAH8897668.1 hypothetical protein GQ53DRAFT_449273 [Thozetella sp. PMI_491] | diamond | 168 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Chaetosphaeriales | Chaetosphaeriaceae | Thozetella | Thozetella sp. PMI_491 | |
| 29548665 | 29548665 | PRJNA807347_P_NODE_15130_length_245_cov_2.302326_g15027_i0 | PRJNA807347 | 15130 | 245 | 2.302326 | 5.6406987 | Sodiomyces alkalinus F11 | 1314773 | Fungi | Fungi | 88.6 | 4.71e-20 | NR | XP_028470608.1 | 1314773 | g15027 | i0 | 86 | 0.52653061224489806 | 43 | 6 | 52.7 | 0 | 186 | 58 | 102 | 144 | XP_028470608.1 hypothetical protein SODALDRAFT_288359 [Sodiomyces alkalinus F11] | diamond | 129 | 88.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Plectosphaerellaceae | Sodiomyces | Sodiomyces alkalinus | |
| 29643257 | 29643257 | PRJNA807347_P_NODE_8750_length_281_cov_1.370192_g8647_i0 | PRJNA807347 | 8750 | 281 | 1.370192 | 3.85023952 | Chrysoporthe cubensis | 305400 | Fungi | Fungi | 73.9 | 6.23e-13 | NR | YP_009262158.1 | 305400 | g8647 | i0 | 50.5 | 0.99288256227758 | 93 | 35 | 99.3 | 3 | 1 | 279 | 573 | 654 | YP_009262158.1 NADH dehydrogenase subunit 5 [Chrysoporthe cubensis] | diamond | 279 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Cryphonectriaceae | Chrysoporthe | Chrysoporthe cubensis | |
| 30085659 | 30085659 | PRJNA807347_P_NODE_17212_length_242_cov_0.911243_g17109_i0 | PRJNA807347 | 17212 | 242 | 0.911243 | 2.20520806 | Coniochaeta sp. 2T2.1 | 1571157 | Fungi | Fungi | 54.7 | 2.27e-6 | NR | KAB5540453.1 | 1571157 | g17109 | i0 | 82.4 | 0.421487603305785 | 34 | 6 | 42.1 | 0 | 115 | 216 | 6 | 39 | KAB5540453.1 putative fungal-specific transcription factor [Coniochaeta sp. 2T2.1] | diamond | 102 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Coniochaetales | Coniochaetaceae | Coniochaeta | Coniochaeta sp. 2T2.1 | |
| 30243876 | 30243876 | PRJNA807347_P_NODE_14472_length_247_cov_0.890805_g14369_i0 | PRJNA807347 | 14472 | 247 | 0.890805 | 2.20028835 | Cadophora malorum | 108018 | Fungi | Fungi | 162 | 1.1999999999999999e-46 | NR | KAG4416364.1 | 108018 | g14369 | i0 | 97.6 | 0.995951417004049 | 82 | 2 | 99.6 | 0 | 2 | 247 | 272 | 353 | KAG4416364.1 hypothetical protein IFR04_010526 [Cadophora malorum] | diamond | 246 | 162 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Ploettnerulaceae | Cadophora | Cadophora malorum | |
| 31476391 | 31476391 | PRJNA807347_P_NODE_11696_length_253_cov_0.866667_g11593_i0 | PRJNA807347 | 11696 | 253 | 0.866667 | 2.19266751 | Coniochaeta pulveracea | 177199 | Fungi | Fungi | 94.4 | 3.02e-20 | NR | RKU43695.1 | 177199 | g11593 | i0 | 92.5 | 0.628458498023715 | 53 | 4 | 62.8 | 0 | 252 | 94 | 45 | 97 | RKU43695.1 hypothetical protein DL546_001417 [Coniochaeta pulveracea] | diamond | 159 | 94.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Coniochaetales | Coniochaetaceae | Coniochaeta | Coniochaeta pulveracea | |
| 31792341 | 31792341 | PRJNA807347_P_NODE_10957_length_259_cov_1.311828_g10854_i0 | PRJNA807347 | 10957 | 259 | 1.311828 | 3.39763452 | Colletotrichum jinshuiense | 2283408 | Fungi | Fungi | 45.1 | 0.00705 | NR | WYZ45891.1 | 2283408 | g10854 | i0 | 38.7 | 1.51737451737452 | 62 | 36 | 69.5 | 1 | 187 | 8 | 668 | 729 | WYZ45891.1 hypothetical protein EsH8_IX_000116 [Colletotrichum jinshuiense] | diamond | 393 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum jinshuiense | |
| 31950643 | 31950643 | PRJNA807347_P_NODE_16057_length_244_cov_0.900585_g15954_i0 | PRJNA807347 | 16057 | 244 | 0.900585 | 2.1974274 | Sporothrix stenoceras | 5173 | Fungi | Fungi | 45.1 | 0.00595 | NR | KAL1898503.1 | 5173 | g15954 | i0 | 41.5 | 0.651639344262295 | 53 | 31 | 65.2 | 0 | 162 | 4 | 326 | 378 | KAL1898503.1 hypothetical protein Sste5346_003407 [Sporothrix stenoceras] | diamond | 159 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Sporothrix | Sporothrix stenoceras | |
| 32022926 | 32022926 | PRJNA807347_P_NODE_16638_length_243_cov_0.905882_g16535_i0 | PRJNA807347 | 16638 | 243 | 0.905882 | 2.20129326 | Aspergillus | 5052 | Fungi | Fungi | 79.7 | 1.31e-15 | NR | XP_001275233.1 | 344612 | g16535 | i0 | 61.4 | 2 | 83 | 26 | 98.8 | 3 | 242 | 3 | 162 | 241 | XP_001275233.1 uncharacterized protein ACLA_068340 [Aspergillus clavatus NRRL 1] | diamond | 486 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus clavatus |
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);;