contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA1067443" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7391072 | 7391072 | PRJNA1067443_P_NODE_10766_length_280_cov_5.801932_g10748_i0 | PRJNA1067443 | 10766 | 280 | 5.801932 | 16.2454096 | Ophiobolus disseminans | 1469910 | Fungi | Fungi | 105 | 3.95e-25 | NR | KAF2830475.1 | 1469910 | g10748 | i0 | 90.2 | 0.546428571428571 | 51 | 5 | 54.6 | 0 | 255 | 103 | 232 | 282 | KAF2830475.1 NAD(P)-binding protein [Ophiobolus disseminans] | diamond | 153 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Ophiobolus | Ophiobolus disseminans | |
| 27185174 | 27185174 | PRJNA1067443_P_NODE_19222_length_246_cov_1.705202_g19204_i0 | PRJNA1067443 | 19222 | 246 | 1.705202 | 4.19479692 | Ascomycota | 4890 | Fungi | Fungi | 59.3 | 5.42e-8 | NR | XP_008079054.1 | 1116229 | g19204 | i0 | 79.3 | 1.01219512195122 | 29 | 6 | 35.4 | 0 | 3 | 89 | 442 | 470 | XP_008079054.1 Ribokinase-like protein [Glarea lozoyensis ATCC 20868] | diamond | 249 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Helotiaceae | Glarea | Glarea lozoyensis | |
| 27185175 | 27185175 | PRJNA1067443_P_NODE_19442_length_246_cov_0.890173_g19424_i0 | PRJNA1067443 | 19442 | 246 | 0.890173 | 2.18982558 | Ascomycota | 4890 | Fungi | Fungi | 53.5 | 5.88e-6 | NR | KAF2769708.1 | 161662 | g19424 | i0 | 62.5 | 1.48780487804878 | 32 | 12 | 39 | 0 | 122 | 217 | 1 | 32 | KAF2769708.1 splicesome-associated protein [Teratosphaeria nubilosa] | diamond | 366 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Teratosphaeria | Teratosphaeria nubilosa | |
| 28204084 | 28204084 | PRJNA1067443_P_NODE_20746_length_244_cov_0.900585_g20728_i0 | PRJNA1067443 | 20746 | 244 | 0.900585 | 2.1974274 | Dactylonectria macrodidyma | 307937 | Fungi | Fungi | 58.9 | 7.66e-8 | NR | KAH7117488.1 | 307937 | g20728 | i0 | 50.8 | 4.38934426229508 | 59 | 29 | 72.5 | 0 | 44 | 220 | 223 | 281 | KAH7117488.1 hypothetical protein EDB81DRAFT_767268 [Dactylonectria macrodidyma] | diamond | 1071 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Dactylonectria | Dactylonectria macrodidyma | |
| 28678039 | 28678039 | PRJNA1067443_P_NODE_9247_length_290_cov_1.419355_g9229_i0 | PRJNA1067443 | 9247 | 290 | 1.419355 | 4.1161295 | Remersonia thermophila | 72144 | Fungi | Fungi | 43.5 | 0.0348 | NR | XP_070866785.1 | 72144 | g9229 | i0 | 32.8 | 0.693103448275862 | 67 | 45 | 69.3 | 0 | 46 | 246 | 7 | 73 | XP_070866785.1 hypothetical protein VTJ83DRAFT_2904 [Remersonia thermophila] | diamond | 201 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Remersonia | Remersonia thermophila | ||
| 29056888 | 29056888 | PRJNA1067443_P_NODE_14328_length_260_cov_2.155080_g14310_i0 | PRJNA1067443 | 14328 | 260 | 2.15508 | 5.603208 | Macroventuria anomochaeta | 301207 | Fungi | Fungi | 47 | 0.00105 | NR | XP_033556360.1 | 301207 | g14310 | i0 | 61.5 | 0.45 | 39 | 14 | 45 | 1 | 43 | 159 | 17 | 54 | XP_033556360.1 uncharacterized protein BU25DRAFT_425946 [Macroventuria anomochaeta] | diamond | 117 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Macroventuria | Macroventuria anomochaeta | |
| 29246209 | 29246209 | PRJNA1067443_P_NODE_15329_length_255_cov_2.340659_g15311_i0 | PRJNA1067443 | 15329 | 255 | 2.340659 | 5.96868045 | Ophiostoma piceae UAMH 11346 | 1262450 | Fungi | Fungi | 160 | 1.37e-43 | NR | EPE03758.1 | 1262450 | g15311 | i0 | 98.8 | 1 | 85 | 1 | 100 | 0 | 255 | 1 | 409 | 493 | EPE03758.1 serine threonine protein kinase [Ophiostoma piceae UAMH 11346] | diamond | 255 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Ophiostoma | Ophiostoma piceae | |
| 30415186 | 30415186 | PRJNA1067443_P_NODE_18253_length_248_cov_0.880000_g18235_i0 | PRJNA1067443 | 18253 | 248 | 0.88 | 2.1824 | Hortaea werneckii | 91943 | Fungi | Fungi | 87.8 | 5.55e-18 | NR | GAB1731874.1 | 91943 | g18235 | i0 | 72.6 | 0.75 | 62 | 17 | 75 | 0 | 188 | 3 | 100 | 161 | GAB1731874.1 hypothetical protein NU195Hw_Modified_347t1 [Hortaea werneckii] | diamond | 186 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Hortaea | Hortaea werneckii | |
| 31227775 | 31227775 | PRJNA1067443_P_NODE_22735_length_241_cov_0.916667_g22717_i0 | PRJNA1067443 | 22735 | 241 | 0.916667 | 2.20916747 | Penicillium | 5073 | Fungi | Fungi | 109 | 1.37e-25 | NR | KAJ5184172.1 | 69766 | g22717 | i0 | 85.2 | 6.149377593361 | 61 | 9 | 75.9 | 0 | 241 | 59 | 935 | 995 | KAJ5184172.1 hypothetical protein N7492_001788 [Penicillium capsulatum] | diamond | 1482 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium capsulatum | |
| 31268012 | 31268012 | PRJNA1067443_P_NODE_5215_length_351_cov_4.115108_g5197_i0 | PRJNA1067443 | 5215 | 351 | 4.115108 | 14.44402908 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 155 | 2.6499999999999994e-42 | NR | PWI73734.1 | 33203 | g5197 | i0 | 68.1 | 1.93162393162393 | 113 | 36 | 96.6 | 0 | 341 | 3 | 350 | 462 | PWI73734.1 C6 zinc finger domain protein [Purpureocillium lilacinum] | diamond | 678 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 32470350 | 32470350 | PRJNA1067443_P_NODE_24199_length_213_cov_6.378571_g24181_i0 | PRJNA1067443 | 24199 | 213 | 6.378571 | 13.58635623 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 114 | 1.16e-27 | NR | KAK5094920.1 | 1690604 | g24181 | i0 | 74.6 | 1 | 71 | 18 | 100 | 0 | 1 | 213 | 318 | 388 | KAK5094920.1 hypothetical protein LTR24_003368 [Lithohypha guttulata] | diamond | 213 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata |
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);;