contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA549880" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3062844 | 3062844 | PRJNA549880_P_NODE_4323_length_363_cov_1.058621_g4230_i0 | PRJNA549880 | 4323 | 363 | 1.058621 | 3.84279423 | Schizosaccharomyces pombe | 4896 | Fungi | Fungi | 124 | 4.94e-34 | NR | NP_593852.1 | 4896 | g4230 | i0 | 55.6 | 3.33884297520661 | 99 | 44 | 81.8 | 0 | 22 | 318 | 1 | 99 | NP_593852.1 cytosolic thioredoxin Trx1 [Schizosaccharomyces pombe] | diamond | 1212 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe | |
| 4338800 | 4338800 | PRJNA549880_P_NODE_10304_length_251_cov_1.623596_g10211_i0 | PRJNA549880 | 10304 | 251 | 1.623596 | 4.07522596 | [Torrubiella] hemipterigena | 1531966 | Fungi | Fungi | 128 | 3.7899999999999997e-32 | NR | CEJ93205.1 | 1531966 | g10211 | i0 | 76.2 | 2.1394422310757 | 84 | 19 | 99.2 | 1 | 249 | 1 | 1953 | 2036 | CEJ93205.1 hypothetical protein VHEMI08813 [[Torrubiella] hemipterigena] | diamond | 537 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | [Torrubiella] hemipterigena | ||
| 15147674 | 15147674 | PRJNA549880_P_NODE_10392_length_251_cov_0.865169_g10299_i0 | PRJNA549880 | 10392 | 251 | 0.865169 | 2.17157419 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 111 | 2.59e-26 | NR | XP_069229019.1 | 1052096 | g10299 | i0 | 67.5 | 0.99203187250996006 | 83 | 27 | 99.2 | 0 | 250 | 2 | 452 | 534 | XP_069229019.1 uncharacterized protein WHR41_04979 [Cladosporium halotolerans] | diamond | 249 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 27488774 | 27488774 | PRJNA549880_P_NODE_10623_length_251_cov_0.865169_g10530_i0 | PRJNA549880 | 10623 | 251 | 0.865169 | 2.17157419 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 44.3 | 0.00675 | NR | XP_069233882.1 | 1052096 | g10530 | i0 | 77.3 | 0.262948207171315 | 22 | 5 | 26.3 | 0 | 250 | 185 | 147 | 168 | XP_069233882.1 uncharacterized protein WHR41_00799 [Cladosporium halotolerans] | diamond | 66 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 27583345 | 27583345 | PRJNA549880_P_NODE_13004_length_246_cov_0.890173_g12911_i0 | PRJNA549880 | 13004 | 246 | 0.890173 | 2.18982558 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 130 | 5.62e-33 | NR | XP_069225877.1 | 1052096 | g12911 | i0 | 69.5 | 1 | 82 | 25 | 100 | 0 | 246 | 1 | 493 | 574 | XP_069225877.1 uncharacterized protein WHR41_08368 [Cladosporium halotolerans] | diamond | 246 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 28309720 | 28309720 | PRJNA549880_P_NODE_11526_length_249_cov_0.875000_g11433_i0 | PRJNA549880 | 11526 | 249 | 0.875 | 2.17875 | Neophaeococcomyces mojaviensis | 3383035 | Fungi | Fungi | 110 | 2.62e-29 | NR | KAJ9656160.1 | 3383035 | g11433 | i0 | 76.7 | 0.72289156626506 | 60 | 14 | 72.3 | 0 | 3 | 182 | 55 | 114 | KAJ9656160.1 hypothetical protein H2198_005122 [Neophaeococcomyces mojaviensis] | diamond | 180 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Neophaeococcomyces | Neophaeococcomyces mojaviensis | ||
| 28972823 | 28972823 | PRJNA549880_P_NODE_12588_length_247_cov_0.885057_g12495_i0 | PRJNA549880 | 12588 | 247 | 0.885057 | 2.18609079 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 66.6 | 1.46e-10 | NR | XP_069232567.1 | 1052096 | g12495 | i0 | 86.5 | 0.449392712550607 | 37 | 5 | 44.9 | 0 | 137 | 247 | 247 | 283 | XP_069232567.1 uncharacterized protein WHR41_01829 [Cladosporium halotolerans] | diamond | 111 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 29840037 | 29840037 | PRJNA549880_P_NODE_8111_length_283_cov_1.352381_g8018_i0 | PRJNA549880 | 8111 | 283 | 1.352381 | 3.82723823 | Xylaria | 37991 | Fungi | Fungi | 45.1 | 0.009 | NR | KAI2637317.1 | 490159 | g8018 | i0 | 46.7 | 0.954063604240283 | 45 | 24 | 47.7 | 0 | 206 | 72 | 323 | 367 | KAI2637317.1 Sodium/hydrogen exchanger family-domain-containing protein [Xylaria nigripes] | diamond | 270 | 45.4 | 0.993392070484582 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria nigripes | |
| 29888526 | 29888526 | PRJNA549880_P_NODE_15811_length_241_cov_0.875000_g15718_i0 | PRJNA549880 | 15811 | 241 | 0.875 | 2.10875 | Salinomyces thailandicus | 706561 | Fungi | Fungi | 65.5 | 9.81e-11 | NR | TKA24294.1 | 706561 | g15718 | i0 | 48.7 | 1.87966804979253 | 76 | 36 | 94.6 | 1 | 3 | 230 | 137 | 209 | TKA24294.1 hypothetical protein B0A50_06763 [Salinomyces thailandicus] | diamond | 453 | 65.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Salinomyces | Salinomyces thailandicus | |
| 30092579 | 30092579 | PRJNA549880_P_NODE_13772_length_245_cov_0.895349_g13679_i0 | PRJNA549880 | 13772 | 245 | 0.895349 | 2.19360505 | Pleosporaceae | 28556 | Fungi | Fungi | 115 | 7.18e-28 | NR | KAG9193092.1 | 48097 | g13679 | i0 | 67.1 | 6.24489795918367 | 73 | 24 | 89.4 | 0 | 3 | 221 | 254 | 326 | KAG9193092.1 L-histidine Nalpha-methyltransferase / hercynylcysteine S-oxide synthase [Alternaria panax] | diamond | 1530 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria panax | |
| 31214930 | 31214930 | PRJNA549880_P_NODE_11595_length_249_cov_0.875000_g11502_i0 | PRJNA549880 | 11595 | 249 | 0.875 | 2.17875 | Lineolata rhizophorae | 578093 | Fungi | Fungi | 57.4 | 2.84e-7 | NR | KAF2457979.1 | 578093 | g11502 | i0 | 42.5 | 0.879518072289157 | 73 | 41 | 86.7 | 1 | 3 | 218 | 5161 | 5233 | KAF2457979.1 hypothetical protein BDY21DRAFT_20445 [Lineolata rhizophorae] | diamond | 219 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Lineolatales | Lineolataceae | Lineolata | Lineolata rhizophorae | |
| 31246956 | 31246956 | PRJNA549880_P_NODE_9175_length_268_cov_1.297436_g9082_i0 | PRJNA549880 | 9175 | 268 | 1.297436 | 3.47712848 | Fusarium heterosporum | 42747 | Fungi | Fungi | 105 | 5.25e-25 | NR | KAF5663741.1 | 42747 | g9082 | i0 | 66.2 | 1.52238805970149 | 68 | 23 | 76.1 | 0 | 1 | 204 | 129 | 196 | KAF5663741.1 mediator complex subunit med18 [Fusarium heterosporum] | diamond | 408 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium heterosporum | |
| 31436728 | 31436728 | PRJNA549880_P_NODE_14976_length_242_cov_0.911243_g14883_i0 | PRJNA549880 | 14976 | 242 | 0.911243 | 2.20520806 | Exophiala sideris | 1016849 | Fungi | Fungi | 130 | 2.41e-33 | NR | KAK5033585.1 | 1016849 | g14883 | i0 | 81.3 | 0.991735537190083 | 80 | 15 | 99.2 | 0 | 242 | 3 | 95 | 174 | KAK5033585.1 hypothetical protein LTS07_003890 [Exophiala sideris] | diamond | 240 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala sideris | |
| 31767844 | 31767844 | PRJNA549880_P_NODE_15757_length_241_cov_0.916667_g15664_i0 | PRJNA549880 | 15757 | 241 | 0.916667 | 2.20916747 | Pleosporales | 92860 | Fungi | Fungi | 119 | 8.46e-31 | NR | KAJ8114880.1 | 749465 | g15664 | i0 | 84.4 | 2.36514522821577 | 64 | 10 | 79.7 | 0 | 50 | 241 | 137 | 200 | KAJ8114880.1 hypothetical protein OPT61_g3345 [Boeremia exigua] | diamond | 570 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Boeremia | Boeremia exigua | |
| 31957646 | 31957646 | PRJNA549880_P_NODE_12937_length_246_cov_0.890173_g12844_i0 | PRJNA549880 | 12937 | 246 | 0.890173 | 2.18982558 | Ascomycota | 4890 | Fungi | Fungi | 129 | 1.85e-32 | NR | KAL4915772.1 | 41725 | g12844 | i0 | 85.2 | 49.3658536585366 | 81 | 12 | 98.8 | 0 | 2 | 244 | 660 | 740 | KAL4915772.1 hypothetical protein BDW62DRAFT_219178 [Aspergillus aurantiobrunneus] | diamond | 12144 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus aurantiobrunneus | |
| 32101069 | 32101069 | PRJNA549880_P_NODE_8338_length_280_cov_1.333333_g8245_i0 | PRJNA549880 | 8338 | 280 | 1.333333 | 3.7333324 | [Torrubiella] hemipterigena | 1531966 | Fungi | Fungi | 114 | 2.88e-27 | NR | CEJ82013.1 | 1531966 | g8245 | i0 | 77.8 | 0.771428571428571 | 72 | 15 | 76.1 | 1 | 271 | 59 | 234 | 305 | CEJ82013.1 Putative Dual specificity protein kinase lkh1 [[Torrubiella] hemipterigena] | diamond | 216 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | [Torrubiella] hemipterigena | ||
| 32210918 | 32210918 | PRJNA549880_P_NODE_12278_length_248_cov_0.880000_g12185_i0 | PRJNA549880 | 12278 | 248 | 0.88 | 2.1824 | Pleosporales | 92860 | Fungi | Fungi | 87.8 | 5.2e-18 | NR | KAH3906620.1 | 13684 | g12185 | i0 | 62.5 | 6.45967741935484 | 56 | 21 | 67.7 | 0 | 168 | 1 | 151 | 206 | KAH3906620.1 hypothetical protein HBH56_200970 [Parastagonospora nodorum] | diamond | 1602 | 88.6 | 0.99097065462754 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora nodorum | |
| 32716383 | 32716383 | PRJNA549880_P_NODE_10040_length_255_cov_1.483516_g9947_i0 | PRJNA549880 | 10040 | 255 | 1.483516 | 3.7829658 | Pleosporales | 92860 | Fungi | Fungi | 52 | 2.52e-5 | NR | KAH7090567.1 | 798071 | g9947 | i0 | 52.3 | 1.04705882352941 | 44 | 21 | 51.8 | 0 | 1 | 132 | 2194 | 2237 | KAH7090567.1 Mus7/MMS22 family-domain-containing protein [Paraphoma chrysanthemicola] | diamond | 267 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Paraphoma | Paraphoma chrysanthemicola |
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);;