contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1002816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1427676 | 1427676 | PRJNA1002816_P_NODE_20542_length_242_cov_0.911243_g20382_i0 | PRJNA1002816 | 20542 | 242 | 0.911243 | 2.20520806 | Cucurbitaria berberidis CBS 394.84 | 1168544 | Fungi | Fungi | 92.4 | 1.67e-21 | NR | XP_040783944.1 | 1168544 | g20382 | i0 | 57.5 | 1.98347107438017 | 80 | 16 | 99.2 | 1 | 2 | 241 | 39 | 100 | XP_040783944.1 uncharacterized protein K460DRAFT_397621 [Cucurbitaria berberidis CBS 394.84] | diamond | 480 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Cucurbitariaceae | Cucurbitaria | Cucurbitaria berberidis | |
| 6531112 | 6531112 | PRJNA1002816_P_NODE_20946_length_241_cov_0.916667_g20786_i0 | PRJNA1002816 | 20946 | 241 | 0.916667 | 2.20916747 | Lentithecium fluviatile CBS 122367 | 1168545 | Fungi | Fungi | 151 | 8.81e-42 | NR | KAF2678830.1 | 1168545 | g20786 | i0 | 82.5 | 1.99170124481328 | 80 | 14 | 99.6 | 0 | 1 | 240 | 219 | 298 | KAF2678830.1 glycoside hydrolase family 16 protein [Lentithecium fluviatile CBS 122367] | diamond | 480 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Lentitheciaceae | Lentithecium | Lentithecium fluviatile | |
| 7805388 | 7805388 | PRJNA1002816_P_NODE_15927_length_270_cov_0.964467_g15767_i0 | PRJNA1002816 | 15927 | 270 | 0.964467 | 2.6040609 | root | 1 | Root_unresolved | Root_unresolved | 124 | 6.36e-32 | NR | XP_001645507.1 | 436907 | g15767 | i0 | 64 | 21.0111111111111 | 89 | 32 | 98.9 | 0 | 3 | 269 | 87 | 175 | XP_001645507.1 sterol 24-C-methyltransferase [Vanderwaltozyma polyspora DSM 70294] | diamond | 5673 | 125 | 0.992 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Vanderwaltozyma | Vanderwaltozyma polyspora | |
| 13754289 | 13754289 | PRJNA1002816_P_NODE_15591_length_274_cov_1.149254_g15431_i0 | PRJNA1002816 | 15591 | 274 | 1.149254 | 3.14895596 | Xylariaceae | 37990 | Fungi | Fungi | 150 | 2.4199999999999998e-42 | NR | XP_051369071.1 | 419775 | g15431 | i0 | 79.1 | 20.9233576642336 | 91 | 19 | 99.6 | 0 | 274 | 2 | 52 | 142 | XP_051369071.1 mitochondrial carrier [Durotheca rogersii] | diamond | 5733 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Durotheca | Durotheca rogersii | |
| 13754295 | 13754295 | PRJNA1002816_P_NODE_17651_length_251_cov_0.865169_g17491_i0 | PRJNA1002816 | 17651 | 251 | 0.865169 | 2.17157419 | Lentithecium fluviatile CBS 122367 | 1168545 | Fungi | Fungi | 160 | 1.9e-45 | NR | KAF2676588.1 | 1168545 | g17491 | i0 | 87.8 | 2.92828685258964 | 82 | 10 | 98 | 0 | 251 | 6 | 199 | 280 | KAF2676588.1 aromatic prenyltransferase [Lentithecium fluviatile CBS 122367] | diamond | 735 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Lentitheciaceae | Lentithecium | Lentithecium fluviatile | |
| 24378851 | 24378851 | PRJNA1002816_P_NODE_17520_length_251_cov_0.865169_g17360_i0 | PRJNA1002816 | 17520 | 251 | 0.865169 | 2.17157419 | Neohortaea acidophila | 245834 | Fungi | Fungi | 129 | 9.01e-33 | NR | XP_033590686.1 | 245834 | g17360 | i0 | 75.9 | 0.99203187250996006 | 83 | 20 | 99.2 | 0 | 3 | 251 | 525 | 607 | XP_033590686.1 Transketolase, thiamine diphosphate binding domain-containing protein [Neohortaea acidophila] | diamond | 249 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Neohortaea | Neohortaea acidophila | |
| 26907871 | 26907871 | PRJNA1002816_P_NODE_21062_length_234_cov_2.391304_g20902_i0 | PRJNA1002816 | 21062 | 234 | 2.391304 | 5.59565136 | Botrytis cinerea T4 | 999810 | Fungi | Fungi | 46.6 | 0.00139 | NR | CCD54628.1 | 999810 | g20902 | i0 | 34.5 | 0.743589743589744 | 58 | 36 | 71.8 | 2 | 173 | 6 | 6 | 63 | CCD54628.1 hypothetical protein BofuT4_P126760.1 [Botrytis cinerea T4] | diamond | 174 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 27438118 | 27438118 | PRJNA1002816_P_NODE_17643_length_251_cov_0.865169_g17483_i0 | PRJNA1002816 | 17643 | 251 | 0.865169 | 2.17157419 | Fungi | 4751 | Fungi | Fungi | 115 | 3.7e-28 | NR | KAI9832246.1 | 273283 | g17483 | i0 | 62.7 | 8.8207171314741 | 83 | 31 | 99.2 | 0 | 1 | 249 | 285 | 367 | KAI9832246.1 MAG: Aldehyde dehydrogenase [Sarea resinae] | diamond | 2214 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sareomycetes | Sareales | Zythiaceae | Sarea | Sarea resinae | |
| 28708407 | 28708407 | PRJNA1002816_P_NODE_17787_length_250_cov_0.870056_g17627_i0 | PRJNA1002816 | 17787 | 250 | 0.870056 | 2.17514 | Lentithecium fluviatile CBS 122367 | 1168545 | Fungi | Fungi | 96.7 | 4.4300000000000005e-21 | NR | KAF2689389.1 | 1168545 | g17627 | i0 | 68.4 | 0.912 | 76 | 24 | 91.2 | 0 | 229 | 2 | 201 | 276 | KAF2689389.1 Rgp1-domain-containing protein [Lentithecium fluviatile CBS 122367] | diamond | 228 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Lentitheciaceae | Lentithecium | Lentithecium fluviatile | |
| 28866075 | 28866075 | PRJNA1002816_P_NODE_18008_length_250_cov_0.870056_g17848_i0 | PRJNA1002816 | 18008 | 250 | 0.870056 | 2.17514 | Lentithecium fluviatile CBS 122367 | 1168545 | Fungi | Fungi | 148 | 2.5799999999999998e-39 | NR | KAF2686485.1 | 1168545 | g17848 | i0 | 88 | 0.996 | 83 | 10 | 99.6 | 0 | 2 | 250 | 546 | 628 | KAF2686485.1 ARM repeat-containing protein [Lentithecium fluviatile CBS 122367] | diamond | 249 | 148 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Lentitheciaceae | Lentithecium | Lentithecium fluviatile | |
| 28897559 | 28897559 | PRJNA1002816_P_NODE_19428_length_245_cov_0.895349_g19268_i0 | PRJNA1002816 | 19428 | 245 | 0.895349 | 2.19360505 | Lentithecium fluviatile CBS 122367 | 1168545 | Fungi | Fungi | 109 | 1.47e-28 | NR | KAF2682977.1 | 1168545 | g19268 | i0 | 89.6 | 0.587755102040816 | 48 | 5 | 58.8 | 0 | 145 | 2 | 1 | 48 | KAF2682977.1 PLAC8-domain-containing protein [Lentithecium fluviatile CBS 122367] | diamond | 144 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Lentitheciaceae | Lentithecium | Lentithecium fluviatile | |
| 30065946 | 30065946 | PRJNA1002816_P_NODE_9952_length_354_cov_1.096085_g9792_i0 | PRJNA1002816 | 9952 | 354 | 1.096085 | 3.8801409 | Xylona heveae TC161 | 1328760 | Fungi | Fungi | 53.5 | 5.04e-6 | NR | XP_018186825.1 | 1328760 | g9792 | i0 | 36.7 | 0.923728813559322 | 109 | 63 | 92.4 | 2 | 2 | 328 | 30 | 132 | XP_018186825.1 ribosomal protein L28e [Xylona heveae TC161] | diamond | 327 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Xylonomycetes | Xylonales | Xylonaceae | Xylona | Xylona heveae | |
| 31519934 | 31519934 | PRJNA1002816_P_NODE_20276_length_243_cov_0.905882_g20116_i0 | PRJNA1002816 | 20276 | 243 | 0.905882 | 2.20129326 | Lentithecium fluviatile CBS 122367 | 1168545 | Fungi | Fungi | 130 | 2.26e-33 | NR | KAF2690117.1 | 1168545 | g20116 | i0 | 92.3 | 0.962962962962963 | 78 | 6 | 96.3 | 0 | 242 | 9 | 63 | 140 | KAF2690117.1 hypothetical protein K458DRAFT_426948 [Lentithecium fluviatile CBS 122367] | diamond | 234 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Lentitheciaceae | Lentithecium | Lentithecium fluviatile | |
| 31765314 | 31765314 | PRJNA1002816_P_NODE_20577_length_242_cov_0.911243_g20417_i0 | PRJNA1002816 | 20577 | 242 | 0.911243 | 2.20520806 | Pleosporales | 92860 | Fungi | Fungi | 154 | 1.9199999999999993e-43 | NR | XP_033687511.1 | 390896 | g20417 | i0 | 91.1 | 4.94628099173554 | 79 | 7 | 97.9 | 0 | 237 | 1 | 257 | 335 | XP_033687511.1 Clavaminate synthase-like protein [Trematosphaeria pertusa] | diamond | 1197 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Trematosphaeriaceae | Trematosphaeria | Trematosphaeria pertusa | |
| 32839654 | 32839654 | PRJNA1002816_P_NODE_13480_length_300_cov_1.229075_g13320_i0 | PRJNA1002816 | 13480 | 300 | 1.229075 | 3.687225 | root | 1 | Root_unresolved | Root_unresolved | 109 | 4.83e-26 | NR | GME88824.1 | 5477 | g13320 | i0 | 60.4 | 3.99 | 101 | 36 | 97 | 2 | 1 | 291 | 236 | 336 | GME88824.1 unnamed protein product [[Candida] boidinii] | diamond | 1197 | 110 | 0.990909090909091 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Ogataea | [Candida] boidinii |
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);;