contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA861969" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2121873 | 2121873 | PRJNA861969_P_NODE_35302_length_247_cov_0.885057_g35071_i0 | PRJNA861969 | 35302 | 247 | 0.885057 | 2.18609079 | Aspergillus | 5052 | Fungi | Fungi | 107 | 1.81e-26 | NR | XP_043131565.1 | 182096 | g35071 | i0 | 67.9 | 1.96761133603239 | 81 | 19 | 98.4 | 1 | 247 | 5 | 67 | 140 | XP_043131565.1 uncharacterized protein ACHE_10445A [Aspergillus chevalieri] | diamond | 486 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 8499260 | 8499260 | PRJNA861969_P_NODE_26707_length_267_cov_2.020619_g26476_i0 | PRJNA861969 | 26707 | 267 | 2.020619 | 5.39505273 | Nothophoma quercina | 749835 | Fungi | Fungi | 180 | 2.0299999999999993e-52 | NR | KAL1607195.1 | 749835 | g26476 | i0 | 98.9 | 1 | 89 | 1 | 100 | 0 | 1 | 267 | 188 | 276 | KAL1607195.1 hypothetical protein SLS59_002899 [Nothophoma quercina] | diamond | 267 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Nothophoma | Nothophoma quercina | |
| 10165082 | 10165082 | PRJNA861969_P_NODE_39968_length_242_cov_2.639053_g39737_i0 | PRJNA861969 | 39968 | 242 | 2.639053 | 6.38650826 | Aspergillus | 5052 | Fungi | Fungi | 116 | 3.88e-30 | NR | XP_033426591.1 | 1220188 | g39737 | i0 | 85.1 | 1.63636363636364 | 67 | 10 | 83.1 | 0 | 41 | 241 | 2 | 68 | XP_033426591.1 uncharacterized protein ATNIH1004_005920 [Aspergillus tanneri] | diamond | 396 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus tanneri | |
| 18697695 | 18697695 | PRJNA861969_P_NODE_26555_length_268_cov_1.579487_g26324_i0 | PRJNA861969 | 26555 | 268 | 1.579487 | 4.23302516 | Teratosphaeriaceae | 668547 | Fungi | Fungi | 162 | 2.31e-45 | NR | KAI6899853.1 | 91943 | g26324 | i0 | 94.4 | 12.951492537313401 | 89 | 5 | 99.6 | 0 | 2 | 268 | 234 | 322 | KAI6899853.1 DNA repair helicase, partial [Hortaea werneckii] | diamond | 3471 | 162 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Hortaea | Hortaea werneckii | |
| 26674966 | 26674966 | PRJNA861969_P_NODE_34301_length_248_cov_0.880000_g34070_i0 | PRJNA861969 | 34301 | 248 | 0.88 | 2.1824 | Knufia obscura | 1635080 | Fungi | Fungi | 87 | 1.03e-17 | NR | XP_064732512.1 | 1635080 | g34070 | i0 | 95.3 | 1.04032258064516 | 43 | 2 | 52 | 0 | 248 | 120 | 969 | 1011 | XP_064732512.1 uncharacterized protein PMZ80_003704 [Knufia obscura] | diamond | 258 | 87 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Knufia | Knufia obscura | |
| 27023442 | 27023442 | PRJNA861969_P_NODE_23202_length_284_cov_1.004739_g22971_i0 | PRJNA861969 | 23202 | 284 | 1.004739 | 2.85345876 | Thermoascus aurantiacus ATCC 269 | 5087 | Fungi | Fungi | 53.9 | 7.18e-6 | NR | KAL2221676.1 | 1133049 | g22971 | i0 | 50.9 | 1.11971830985915 | 53 | 25 | 56 | 1 | 284 | 126 | 771 | 822 | KAL2221676.1 aconitase family protein [Thermoascus aurantiacus ATCC 26904] | diamond | 318 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Thermoascaceae | Thermoascus | Thermoascus aurantiacus | |
| 27276464 | 27276464 | PRJNA861969_P_NODE_30023_length_253_cov_1.400000_g29792_i0 | PRJNA861969 | 30023 | 253 | 1.4 | 3.542 | Aspergillus cristatus | 573508 | Fungi | Fungi | 121 | 7.77e-30 | NR | ODM18828.1 | 573508 | g29792 | i0 | 68.3 | 1.94466403162055 | 82 | 24 | 97.2 | 1 | 246 | 1 | 762 | 841 | ODM18828.1 hypothetical protein SI65_05445 [Aspergillus cristatus] | diamond | 492 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus cristatus | |
| 28011064 | 28011064 | PRJNA861969_P_NODE_40805_length_242_cov_0.911243_g40574_i0 | PRJNA861969 | 40805 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | Fungi | Fungi | 48.1 | 4.6e-4 | NR | XP_047755520.1 | 5499 | g40574 | i0 | 51.2 | 1.82231404958678 | 41 | 20 | 50.8 | 0 | 240 | 118 | 249 | 289 | XP_047755520.1 Cell division cycle-related protein res2/pct1 [Fulvia fulva] | diamond | 441 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Fulvia | Fulvia fulva | |
| 28886628 | 28886628 | PRJNA861969_P_NODE_30188_length_252_cov_1.720670_g29957_i0 | PRJNA861969 | 30188 | 252 | 1.72067 | 4.3360884 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 170 | 4.309999999999999e-52 | NR | KAJ8135824.1 | 27326 | g29957 | i0 | 94 | 0.988095238095238 | 83 | 5 | 98.8 | 0 | 3 | 251 | 76 | 158 | KAJ8135824.1 hypothetical protein OY671_010963, partial [Metschnikowia pulcherrima] | diamond | 249 | 170 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 29013339 | 29013339 | PRJNA861969_P_NODE_34528_length_248_cov_0.880000_g34297_i0 | PRJNA861969 | 34528 | 248 | 0.88 | 2.1824 | Hypocenomyce scalaris | 318760 | Fungi | Fungi | 90.9 | 4.44e-19 | NR | MCJ1299232.1 | 318760 | g34297 | i0 | 53.1 | 2.90322580645161 | 81 | 38 | 98 | 0 | 248 | 6 | 493 | 573 | MCJ1299232.1 hypothetical protein [Hypocenomyce scalaris] | diamond | 720 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Umbilicariales | Ophioparmaceae | Hypocenomyce | Hypocenomyce scalaris | |
| 29265427 | 29265427 | PRJNA861969_P_NODE_27229_length_265_cov_1.604167_g26998_i0 | PRJNA861969 | 27229 | 265 | 1.604167 | 4.25104255 | Dothistroma septosporum NZE1 | 64363 | Fungi | Fungi | 67.8 | 7.09e-11 | NR | EME48728.1 | 675120 | g26998 | i0 | 77.3 | 0.928301886792453 | 44 | 10 | 49.8 | 0 | 188 | 57 | 48 | 91 | EME48728.1 hypothetical protein DOTSEDRAFT_142040 [Dothistroma septosporum NZE10] | diamond | 246 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Dothistroma | Dothistroma septosporum | |
| 29802310 | 29802310 | PRJNA861969_P_NODE_38191_length_244_cov_0.900585_g37960_i0 | PRJNA861969 | 38191 | 244 | 0.900585 | 2.1974274 | Colletotrichum fructicola | 690256 | Fungi | Fungi | 55.8 | 9.04e-7 | NR | KAF5499380.1 | 690256 | g37960 | i0 | 53.3 | 1.70901639344262 | 45 | 21 | 55.3 | 0 | 12 | 146 | 901 | 945 | KAF5499380.1 Vegetative incompatibility protein HET-E-1 [Colletotrichum fructicola] | diamond | 417 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum fructicola | |
| 29873747 | 29873747 | PRJNA861969_P_NODE_23171_length_284_cov_1.109005_g22940_i0 | PRJNA861969 | 23171 | 284 | 1.109005 | 3.1495742 | Teratosphaeriaceae | 668547 | Fungi | Fungi | 140 | 1.47e-36 | NR | TKA32458.1 | 706561 | g22940 | i0 | 71.3 | 6.95070422535211 | 94 | 25 | 99.3 | 2 | 283 | 2 | 461 | 552 | TKA32458.1 hypothetical protein B0A50_01566 [Salinomyces thailandicus] | diamond | 1974 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Salinomyces | Salinomyces thailandicus | |
| 29936961 | 29936961 | PRJNA861969_P_NODE_28171_length_261_cov_1.638298_g27940_i0 | PRJNA861969 | 28171 | 261 | 1.638298 | 4.27595778 | Oleoguttula | 1507866 | Fungi | Fungi | 147 | 1.1299999999999998e-41 | NR | KAK4548978.1 | 1507867 | g27940 | i0 | 81.6 | 11 | 87 | 16 | 100 | 0 | 261 | 1 | 116 | 202 | KAK4548978.1 hypothetical protein LTR36_008751 [Oleoguttula mirabilis] | diamond | 2871 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Oleoguttula | Oleoguttula mirabilis | |
| 30126221 | 30126221 | PRJNA861969_P_NODE_22712_length_286_cov_1.328638_g22481_i0 | PRJNA861969 | 22712 | 286 | 1.328638 | 3.79990468 | Sordariomycetes | 147550 | Fungi | Fungi | 174 | 3.31e-51 | NR | KAH7318745.1 | 80388 | g22481 | i0 | 88 | 24.6083916083916 | 92 | 11 | 96.5 | 0 | 10 | 285 | 199 | 290 | KAH7318745.1 S-adenosyl-L-methionine-dependent methyltransferase [Stachybotrys elegans] | diamond | 7038 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Stachybotryaceae | Stachybotrys | Stachybotrys elegans | |
| 30181429 | 30181429 | PRJNA861969_P_NODE_30372_length_251_cov_1.904494_g30141_i0 | PRJNA861969 | 30372 | 251 | 1.904494 | 4.78027994 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 127 | 4.1e-32 | NR | XP_023628972.1 | 112498 | g30141 | i0 | 71.1 | 0.99203187250996006 | 83 | 24 | 99.2 | 0 | 3 | 251 | 212 | 294 | XP_023628972.1 related to E.coli tetracycline resistance protein TCR1 [Ramularia collo-cygni] | diamond | 249 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 31097616 | 31097616 | PRJNA861969_P_NODE_30575_length_251_cov_0.977528_g30344_i0 | PRJNA861969 | 30575 | 251 | 0.977528 | 2.45359528 | [Torrubiella] hemipterigena | 1531966 | Fungi | Fungi | 129 | 3.83e-33 | NR | CEJ92298.1 | 1531966 | g30344 | i0 | 69.5 | 0.9800796812749 | 82 | 25 | 98 | 0 | 3 | 248 | 383 | 464 | CEJ92298.1 hypothetical protein VHEMI07958 [[Torrubiella] hemipterigena] | diamond | 246 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | [Torrubiella] hemipterigena | ||
| 31327139 | 31327139 | PRJNA861969_P_NODE_33135_length_249_cov_0.875000_g32904_i0 | PRJNA861969 | 33135 | 249 | 0.875 | 2.17875 | Teratosphaeriaceae | 668547 | Fungi | Fungi | 57 | 3.7e-7 | NR | KAK4547121.1 | 1507867 | g32904 | i0 | 67.6 | 1.32530120481928 | 37 | 11 | 44.6 | 1 | 112 | 2 | 9 | 44 | KAK4547121.1 hypothetical protein LTR36_001342 [Oleoguttula mirabilis] | diamond | 330 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Oleoguttula | Oleoguttula mirabilis | |
| 31635266 | 31635266 | PRJNA861969_P_NODE_30196_length_252_cov_1.720670_g29965_i0 | PRJNA861969 | 30196 | 252 | 1.72067 | 4.3360884 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 105 | 2.52e-24 | NR | XP_069230740.1 | 1052096 | g29965 | i0 | 80.6 | 0.738095238095238 | 62 | 12 | 73.8 | 0 | 187 | 2 | 82 | 143 | XP_069230740.1 uncharacterized protein WHR41_03632 [Cladosporium halotolerans] | diamond | 186 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 32529569 | 32529569 | PRJNA861969_P_NODE_37919_length_244_cov_1.444444_g37688_i0 | PRJNA861969 | 37919 | 244 | 1.444444 | 3.52444336 | Herpotrichiellaceae | 43219 | Fungi | Fungi | 66.6 | 1.35e-10 | NR | XP_016244237.1 | 569365 | g37688 | i0 | 37.5 | 2.96311475409836 | 80 | 48 | 98.4 | 1 | 243 | 4 | 102 | 179 | XP_016244237.1 uncharacterized protein PV07_09760 [Cladophialophora immunda] | diamond | 723 | 67 | 0.994029850746269 | 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);;