contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA661142" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3179010 | 3179010 | PRJNA661142_P_NODE_2223_length_527_cov_32.849372_g2160_i0 | PRJNA661142 | 2223 | 527 | 32.849372 | 173.11619044 | Zalaria obscura | 2024903 | Fungi | Fungi | 313 | 3.47e-102 | NR | KAK8206896.1 | 2024903 | g2160 | i0 | 84 | 5.96015180265655 | 175 | 28 | 99.6 | 0 | 3 | 527 | 273 | 447 | KAK8206896.1 hypothetical protein M8818_004731 [Zalaria obscura] | diamond | 3141 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Zalariaceae | Zalaria | Zalaria obscura | |
| 4456097 | 4456097 | PRJNA661142_P_NODE_9484_length_228_cov_6.547486_g9419_i0 | PRJNA661142 | 9484 | 228 | 6.547486 | 14.92826808 | Rhizodiscina lignyota | 1504668 | Fungi | Fungi | 85.1 | 4.6e-18 | NR | KAF2092881.1 | 1504668 | g9419 | i0 | 92.9 | 1.64473684210526 | 42 | 3 | 55.3 | 0 | 102 | 227 | 131 | 172 | KAF2092881.1 glutathione S-transferase [Rhizodiscina lignyota] | diamond | 375 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Aulographales | Rhizodiscinaceae | Rhizodiscina | Rhizodiscina lignyota | |
| 27061938 | 27061938 | PRJNA661142_P_NODE_2082_length_541_cov_50.640244_g2020_i0 | PRJNA661142 | 2082 | 541 | 50.640244 | 273.96372004 | Debaryomycetaceae | 766764 | Fungi | Fungi | 82.4 | 1.23e-14 | NR | XP_007373690.1 | 619300 | g2020 | i0 | 48.4 | 1.80776340110906 | 93 | 38 | 49.4 | 3 | 450 | 184 | 479 | 565 | XP_007373690.1 uncharacterized protein SPAPADRAFT_49178 [Spathaspora passalidarum NRRL Y-27907] | diamond | 978 | 83.2 | 0.990384615384615 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Spathaspora | Spathaspora passalidarum | |
| 28218143 | 28218143 | PRJNA661142_P_NODE_1186_length_676_cov_49.695375_g1130_i0 | PRJNA661142 | 1186 | 676 | 49.695375 | 335.940735 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 375 | 1.4899999999999998e-125 | NR | XP_069229124.1 | 1052096 | g1130 | i0 | 83 | 0.994082840236686 | 224 | 37 | 99.4 | 1 | 674 | 3 | 51 | 273 | XP_069229124.1 uncharacterized protein WHR41_04794 [Cladosporium halotolerans] | diamond | 672 | 375 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 29544364 | 29544364 | PRJNA661142_P_NODE_3930_length_395_cov_8.167630_g3865_i0 | PRJNA661142 | 3930 | 395 | 8.16763 | 32.2621385 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 147 | 3.97e-38 | NR | XP_069231391.1 | 1052096 | g3865 | i0 | 64.5 | 0.918987341772152 | 121 | 39 | 91.9 | 1 | 1 | 363 | 675 | 791 | XP_069231391.1 uncharacterized protein WHR41_02842 [Cladosporium halotolerans] | diamond | 363 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 29670434 | 29670434 | PRJNA661142_P_NODE_12250_length_163_cov_0.894737_g12185_i0 | PRJNA661142 | 12250 | 163 | 0.894737 | 1.45842131 | Aspergillus japonicus CBS 114.51 | 1448312 | Fungi | Fungi | 85.1 | 5.59e-18 | NR | XP_025532237.1 | 1448312 | g12185 | i0 | 73.6 | 1.95092024539877 | 53 | 14 | 97.5 | 0 | 3 | 161 | 17 | 69 | XP_025532237.1 uncharacterized protein BO86DRAFT_395778 [Aspergillus japonicus CBS 114.51] | diamond | 318 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus japonicus | |
| 30156512 | 30156512 | PRJNA661142_P_NODE_9172_length_237_cov_1.627660_g9107_i0 | PRJNA661142 | 9172 | 237 | 1.62766 | 3.8575542 | Candida | 5475 | Fungi | Fungi | 135 | 4.17e-36 | NR | CAL1189430.1 | 5480 | g9107 | i0 | 84.6 | 7.89873417721519 | 78 | 12 | 98.7 | 0 | 234 | 1 | 263 | 340 | CAL1189430.1 unnamed protein product [Candida parapsilosis] | diamond | 1872 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida parapsilosis | |
| 30871250 | 30871250 | PRJNA661142_P_NODE_4234_length_379_cov_3.090909_g4169_i0 | PRJNA661142 | 4234 | 379 | 3.090909 | 11.71454511 | Meristemomyces frigidus | 1508187 | Fungi | Fungi | 115 | 4.910000000000001e-27 | NR | KAK5118679.1 | 1508187 | g4169 | i0 | 82.1 | 1.06068601583113 | 67 | 12 | 53 | 0 | 351 | 151 | 68 | 134 | KAK5118679.1 hypothetical protein LTR85_007885 [Meristemomyces frigidus] | diamond | 402 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Meristemomyces | Meristemomyces frigidus | |
| 31294245 | 31294245 | PRJNA661142_P_NODE_10915_length_186_cov_1.175182_g10850_i0 | PRJNA661142 | 10915 | 186 | 1.175182 | 2.18583852 | Aspergillus | 5052 | Fungi | Fungi | 90.5 | 2.13e-19 | NR | TPR03890.1 | 5061 | g10850 | i0 | 68.9 | 12.7903225806452 | 61 | 19 | 98.4 | 0 | 3 | 185 | 401 | 461 | TPR03890.1 hypothetical protein CAN33_002395 [Aspergillus niger] | diamond | 2379 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 32452880 | 32452880 | PRJNA661142_P_NODE_10179_length_210_cov_1.267081_g10114_i0 | PRJNA661142 | 10179 | 210 | 1.267081 | 2.6608701 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 112 | 2.28e-29 | NR | XP_069230374.1 | 1052096 | g10114 | i0 | 83.6 | 0.957142857142857 | 67 | 11 | 95.7 | 0 | 1 | 201 | 24 | 90 | XP_069230374.1 uncharacterized protein WHR41_04310 [Cladosporium halotolerans] | diamond | 201 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 32799306 | 32799306 | PRJNA661142_P_NODE_3320_length_432_cov_32.389034_g3256_i0 | PRJNA661142 | 3320 | 432 | 32.389034 | 139.92062688 | Epicoccum nigrum | 105696 | Fungi | Fungi | 71.6 | 8.06e-13 | NR | OSS49657.1 | 105696 | g3256 | i0 | 64.7 | 0.354166666666667 | 51 | 18 | 35.4 | 0 | 206 | 54 | 81 | 131 | OSS49657.1 hypothetical protein B5807_06295 [Epicoccum nigrum] | diamond | 153 | 71.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Epicoccum | Epicoccum nigrum |
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);;