contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1215774" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5434734 | 5434734 | PRJNA1215774_P_NODE_74885_length_247_cov_0.885057_g74565_i0 | PRJNA1215774 | 74885 | 247 | 0.885057 | 2.18609079 | Vermiconidia calcicola | 1690605 | Fungi | Fungi | 141 | 2.99e-39 | NR | KAK3714659.1 | 1690605 | g74565 | i0 | 81.5 | 0.983805668016194 | 81 | 15 | 98.4 | 0 | 245 | 3 | 168 | 248 | KAK3714659.1 hypothetical protein LTR37_007639 [Vermiconidia calcicola] | diamond | 243 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Extremaceae | Vermiconidia | Vermiconidia calcicola | |
| 19457631 | 19457631 | PRJNA1215774_P_NODE_81216_length_243_cov_0.905882_g80896_i0 | PRJNA1215774 | 81216 | 243 | 0.905882 | 2.20129326 | Pseudocercospora musae | 113226 | Fungi | Fungi | 121 | 1.11e-32 | NR | KXT17177.1 | 113226 | g80896 | i0 | 70.7 | 1.01234567901235 | 82 | 23 | 100 | 1 | 1 | 243 | 69 | 150 | KXT17177.1 hypothetical protein AC579_331 [Pseudocercospora musae] | diamond | 246 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora musae | |
| 20733071 | 20733071 | PRJNA1215774_P_NODE_84097_length_241_cov_0.916667_g83777_i0 | PRJNA1215774 | 84097 | 241 | 0.916667 | 2.20916747 | Dothideomycetes | 147541 | Fungi | Fungi | 140 | 1.84e-36 | NR | KAF1353193.1 | 147560 | g83777 | i0 | 88.8 | 6.95850622406639 | 80 | 9 | 99.6 | 0 | 2 | 241 | 352 | 431 | KAF1353193.1 hypothetical protein BDV97DRAFT_290659 [Delphinella strobiligena] | diamond | 1677 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Dothioraceae | Delphinella | Delphinella strobiligena | |
| 23283641 | 23283641 | PRJNA1215774_P_NODE_72259_length_249_cov_0.875000_g71939_i0 | PRJNA1215774 | 72259 | 249 | 0.875 | 2.17875 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 56.2 | 5.61e-8 | NR | XP_069228720.1 | 1052096 | g71939 | i0 | 84.8 | 0.397590361445783 | 33 | 5 | 39.8 | 0 | 4 | 102 | 68 | 100 | XP_069228720.1 uncharacterized protein WHR41_05990 [Cladosporium halotolerans] | diamond | 99 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 27072651 | 27072651 | PRJNA1215774_P_NODE_53042_length_289_cov_1.425926_g52722_i0 | PRJNA1215774 | 53042 | 289 | 1.425926 | 4.12092614 | Extremus antarcticus | 702011 | Fungi | Fungi | 155 | 4.56e-45 | NR | KAK3051725.1 | 702011 | g52722 | i0 | 79.2 | 1.99307958477509 | 96 | 20 | 99.7 | 0 | 288 | 1 | 77 | 172 | KAK3051725.1 Peroxisomal membrane protein PMP27 [Extremus antarcticus] | diamond | 576 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Extremaceae | Extremus | Extremus antarcticus | |
| 28765126 | 28765126 | PRJNA1215774_P_NODE_73827_length_248_cov_0.880000_g73507_i0 | PRJNA1215774 | 73827 | 248 | 0.88 | 2.1824 | Sordariomycetes | 147550 | Fungi | Fungi | 87.8 | 4.71e-18 | NR | KAH7131341.1 | 307937 | g73507 | i0 | 75 | 2.93951612903226 | 56 | 14 | 67.7 | 0 | 248 | 81 | 2 | 57 | KAH7131341.1 hypothetical protein EDB81DRAFT_808390 [Dactylonectria macrodidyma] | diamond | 729 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Dactylonectria | Dactylonectria macrodidyma | |
| 30104177 | 30104177 | PRJNA1215774_P_NODE_77712_length_245_cov_0.895349_g77392_i0 | PRJNA1215774 | 77712 | 245 | 0.895349 | 2.19360505 | Extremus antarcticus | 702011 | Fungi | Fungi | 79.3 | 1.06e-15 | NR | KAK3051989.1 | 702011 | g77392 | i0 | 83.7 | 1.01632653061224 | 43 | 7 | 52.7 | 0 | 130 | 2 | 1 | 43 | KAK3051989.1 p23 chaperone protein wos2 [Extremus antarcticus] | diamond | 249 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Extremaceae | Extremus | Extremus antarcticus | |
| 30407755 | 30407755 | PRJNA1215774_P_NODE_59893_length_271_cov_1.555556_g59573_i0 | PRJNA1215774 | 59893 | 271 | 1.555556 | 4.21555676 | Recurvomyces | 701936 | Fungi | Fungi | 47.4 | 0.00115 | NR | XP_064697173.1 | 574656 | g59573 | i0 | 63.3 | 1.61623616236162 | 30 | 11 | 33.2 | 0 | 140 | 51 | 219 | 248 | XP_064697173.1 uncharacterized protein LTS14_002532 [Recurvomyces mirabilis] | diamond | 438 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Recurvomyces | Recurvomyces mirabilis | |
| 31494934 | 31494934 | PRJNA1215774_P_NODE_74676_length_247_cov_0.885057_g74356_i0 | PRJNA1215774 | 74676 | 247 | 0.885057 | 2.18609079 | Histoplasma ohiense (nom. inval.) | 2902605 | Fungi | Fungi | 41.2 | 0.0366 | NR | KAG5301112.1 | 2902605 | g74356 | i0 | 33.3 | 0.801619433198381 | 66 | 42 | 77.7 | 2 | 15 | 206 | 25 | 90 | KAG5301112.1 hypothetical protein I7I48_01013 [Histoplasma ohiense (nom. inval.)] | diamond | 198 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ajellomycetaceae | Histoplasma | Histoplasma ohiense (nom. inval.) | |
| 31526540 | 31526540 | PRJNA1215774_P_NODE_78296_length_245_cov_0.895349_g77976_i0 | PRJNA1215774 | 78296 | 245 | 0.895349 | 2.19360505 | Lepidopterella palustris CBS 459.81 | 1314670 | Fungi | Fungi | 49.7 | 9.89e-6 | NR | OCK72762.1 | 1314670 | g77976 | i0 | 60.5 | 0.52653061224489806 | 43 | 17 | 52.7 | 0 | 180 | 52 | 2 | 44 | OCK72762.1 hypothetical protein K432DRAFT_315083, partial [Lepidopterella palustris CBS 459.81] | diamond | 129 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mytilinidiales | Argynnaceae | Lepidopterella | Lepidopterella palustris | |
| 31861366 | 31861366 | PRJNA1215774_P_NODE_84597_length_241_cov_0.916667_g84277_i0 | PRJNA1215774 | 84597 | 241 | 0.916667 | 2.20916747 | Aspergillus | 5052 | Fungi | Fungi | 137 | 2.36e-37 | NR | XP_043134603.1 | 182096 | g84277 | i0 | 84.6 | 2.91286307053942 | 78 | 12 | 97.1 | 0 | 240 | 7 | 255 | 332 | XP_043134603.1 uncharacterized protein ACHE_30068A [Aspergillus chevalieri] | diamond | 702 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 32064101 | 32064101 | PRJNA1215774_P_NODE_61898_length_266_cov_1.595855_g61578_i0 | PRJNA1215774 | 61898 | 266 | 1.595855 | 4.2449743 | Lecanosticta acicola | 111012 | Fungi | Fungi | 63.9 | 1.54e-9 | NR | CAK3734120.1 | 111012 | g61578 | i0 | 52.3 | 2.41353383458647 | 65 | 29 | 73.3 | 2 | 195 | 1 | 191 | 253 | CAK3734120.1 unnamed protein product [Lecanosticta acicola] | diamond | 642 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Lecanosticta | Lecanosticta acicola | |
| 32064102 | 32064102 | PRJNA1215774_P_NODE_64058_length_261_cov_1.250000_g63738_i0 | PRJNA1215774 | 64058 | 261 | 1.25 | 3.2625 | Cladophialophora immunda | 569365 | Fungi | Fungi | 45.8 | 0.00365 | NR | OQU98288.1 | 569365 | g63738 | i0 | 34.9 | 1.44827586206897 | 63 | 35 | 70.1 | 2 | 72 | 254 | 109 | 167 | OQU98288.1 hypothetical protein CLAIMM_04094 isoform 1 [Cladophialophora immunda] | diamond | 378 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Cladophialophora | Cladophialophora immunda |
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);;