contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA290839" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11851578 | 11851578 | PRJNA290839_P_NODE_430_length_394_cov_1.750779_g409_i0 | PRJNA290839 | 430 | 394 | 1.750779 | 6.89806926 | Pyronema omphalodes CBS 1 | 337075 | Fungi | Fungi | 186 | 9.099999999999997e-55 | NR | CCX32792.1 | 1076935 | g409 | i0 | 70.1 | 15.0837563451777 | 134 | 33 | 99 | 2 | 2 | 391 | 65 | 195 | CCX32792.1 Similar to 60S ribosomal protein L3; acc. no. Q8NKF4 [Pyronema omphalodes CBS 100304] | diamond | 5943 | 186 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pyronemataceae | Pyronema | Pyronema omphalodes | |
| 16950301 | 16950301 | PRJNA290839_P_NODE_714_length_303_cov_1.673913_g693_i0 | PRJNA290839 | 714 | 303 | 1.673913 | 5.07195639 | Fusarium | 5506 | Fungi | Fungi | 157 | 2.2799999999999998e-46 | NR | KAJ3522460.1 | 57161 | g693 | i0 | 74 | 25.4059405940594 | 100 | 26 | 99 | 0 | 1 | 300 | 47 | 146 | KAJ3522460.1 hypothetical protein NM208_g12851 [Fusarium decemcellulare] | diamond | 7698 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium decemcellulare | |
| 25285581 | 25285581 | PRJNA290839_P_NODE_960_length_259_cov_1.247312_g939_i0 | PRJNA290839 | 960 | 259 | 1.247312 | 3.23053808 | Fungi | 4751 | Fungi | Fungi | 134 | 1.75e-37 | NR | KAG6272318.1 | 5111 | g939 | i0 | 75.3 | 61.7374517374517 | 85 | 21 | 98.5 | 0 | 5 | 259 | 130 | 214 | KAG6272318.1 hypothetical protein E4U48_003178 [Claviceps purpurea] | diamond | 15990 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Claviceps | Claviceps purpurea | |
| 26915980 | 26915980 | PRJNA290839_P_NODE_1042_length_252_cov_0.871508_g1021_i0 | PRJNA290839 | 1042 | 252 | 0.871508 | 2.19620016 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 60.1 | 3.24e-8 | NR | XP_023631220.1 | 112498 | g1021 | i0 | 65.7 | 0.797619047619048 | 67 | 15 | 79.8 | 2 | 206 | 6 | 1 | 59 | XP_023631220.1 related to serine/threonine-specific protein kinase KIN1 [Ramularia collo-cygni] | diamond | 201 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 27010808 | 27010808 | PRJNA290839_P_NODE_1642_length_242_cov_0.917160_g1621_i0 | PRJNA290839 | 1642 | 242 | 0.91716 | 2.2195272 | Aureobasidium namibiae CBS 147.97 | 1043004 | Fungi | Fungi | 129 | 7.68e-33 | NR | XP_013422394.1 | 1043004 | g1621 | i0 | 79.7 | 0.979338842975207 | 79 | 16 | 97.9 | 0 | 239 | 3 | 414 | 492 | XP_013422394.1 CoA-transferase family III [Aureobasidium namibiae CBS 147.97] | diamond | 237 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium namibiae | |
| 27060203 | 27060203 | PRJNA290839_P_NODE_1122_length_251_cov_0.870787_g1101_i0 | PRJNA290839 | 1122 | 251 | 0.870787 | 2.18567537 | Ascomycota | 4890 | Fungi | Fungi | 46.2 | 0.00238 | NR | XP_043027831.1 | 83186 | g1101 | i0 | 33.8 | 1.85258964143426 | 77 | 50 | 90.8 | 1 | 8 | 235 | 37 | 113 | XP_043027831.1 uncharacterized protein INS49_005911 [Diaporthe citri] | diamond | 465 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Diaporthaceae | Diaporthe | Diaporthe citri | |
| 27597469 | 27597469 | PRJNA290839_P_NODE_1024_length_253_cov_0.866667_g1003_i0 | PRJNA290839 | 1024 | 253 | 0.866667 | 2.19266751 | Penicillium | 5073 | Fungi | Fungi | 143 | 2.08e-38 | NR | KGO76372.1 | 40296 | g1003 | i0 | 84.5 | 8.95256916996047 | 84 | 13 | 99.6 | 0 | 253 | 2 | 46 | 129 | KGO76372.1 Major facilitator superfamily domain, general substrate transporter [Penicillium italicum] | diamond | 2265 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium italicum | |
| 27597470 | 27597470 | PRJNA290839_P_NODE_524_length_356_cov_1.558304_g503_i0 | PRJNA290839 | 524 | 356 | 1.558304 | 5.54756224 | Fungi | 4751 | Fungi | Fungi | 155 | 1.1999999999999998e-44 | NR | KAI5787631.1 | 61495 | g503 | i0 | 62.4 | 32.5449438202247 | 117 | 44 | 98.6 | 0 | 353 | 3 | 8 | 124 | KAI5787631.1 putative 40S ribosomal protein S6-B [Peziza echinospora] | diamond | 11586 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pezizaceae | Peziza | Peziza echinospora | |
| 27769406 | 27769406 | PRJNA290839_P_NODE_1484_length_245_cov_0.895349_g1463_i0 | PRJNA290839 | 1484 | 245 | 0.895349 | 2.19360505 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 127 | 5.489999999999999e-32 | NR | XP_023624035.1 | 112498 | g1463 | i0 | 91.5 | 1.00408163265306 | 82 | 6 | 99.2 | 1 | 244 | 2 | 461 | 542 | XP_023624035.1 related to transcription factor MBP1 [Ramularia collo-cygni] | diamond | 246 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 28891660 | 28891660 | PRJNA290839_P_NODE_1428_length_246_cov_0.890173_g1407_i0 | PRJNA290839 | 1428 | 246 | 0.890173 | 2.18982558 | Sordariomycetes | 147550 | Fungi | Fungi | 107 | 6.79e-25 | NR | OTA63215.1 | 1001937 | g1407 | i0 | 59.8 | 17 | 82 | 33 | 100 | 0 | 246 | 1 | 179 | 260 | OTA63215.1 nonsense-mediated mRNA decay protein 3 [Hypoxylon sp. EC38] | diamond | 4182 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Hypoxylaceae | Hypoxylon | Hypoxylon sp. EC38 | |
| 31387588 | 31387588 | PRJNA290839_P_NODE_476_length_375_cov_0.837748_g455_i0 | PRJNA290839 | 476 | 375 | 0.837748 | 3.141555 | Fungi | 4751 | Fungi | Fungi | 144 | 5.53e-40 | NR | KKA27399.1 | 72032 | g455 | i0 | 57.9 | 18.152 | 126 | 51 | 99.2 | 1 | 2 | 373 | 45 | 170 | KKA27399.1 hypothetical protein TD95_000487 [Thielaviopsis punctulata] | diamond | 6807 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Ceratocystidaceae | Thielaviopsis | Thielaviopsis punctulata | |
| 31938987 | 31938987 | PRJNA290839_P_NODE_1157_length_250_cov_0.881356_g1136_i0 | PRJNA290839 | 1157 | 250 | 0.881356 | 2.20339 | Aspergillus glaucus CBS 516.65 | 1160497 | Fungi | Fungi | 44.3 | 0.0109 | NR | XP_022399688.1 | 1160497 | g1136 | i0 | 44.1 | 0.708 | 59 | 29 | 67.2 | 2 | 9 | 176 | 3 | 60 | XP_022399688.1 uncharacterized protein ASPGLDRAFT_48317 [Aspergillus glaucus CBS 516.65] | diamond | 177 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus |
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);;