contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA690234" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26670612 | 26670612 | PRJNA690234_P_NODE_28341_length_247_cov_1.764368_g27974_i0 | PRJNA690234 | 28341 | 247 | 1.764368 | 4.35798896 | Ascodesmis nigricans | 341454 | Fungi | Fungi | 57.4 | 2.16e-7 | NR | TGZ82176.1 | 341454 | g27974 | i0 | 47.8 | 2.59919028340081 | 69 | 35 | 83.8 | 1 | 3 | 209 | 16 | 83 | TGZ82176.1 TIP41-domain-containing protein [Ascodesmis nigricans] | diamond | 642 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Ascodesmidaceae | Ascodesmis | Ascodesmis nigricans | |
| 26733836 | 26733836 | PRJNA690234_P_NODE_4401_length_625_cov_1.597826_g4042_i0 | PRJNA690234 | 4401 | 625 | 1.597826 | 9.9864125 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 87.4 | 5.34e-16 | NR | KAF8002457.1 | 27326 | g4042 | i0 | 43.3 | 0.432 | 90 | 51 | 43.2 | 0 | 2 | 271 | 132 | 221 | KAF8002457.1 hypothetical protein HF325_003422 [Metschnikowia pulcherrima] | diamond | 270 | 87.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 28282325 | 28282325 | PRJNA690234_P_NODE_7086_length_484_cov_1.333333_g6720_i0 | PRJNA690234 | 7086 | 484 | 1.333333 | 6.45333172 | [Candida] jaroonii | 467808 | Fungi | Fungi | 98.2 | 2.31e-22 | NR | CAH6719291.1 | 467808 | g6720 | i0 | 41.6 | 1.8904958677686 | 101 | 58 | 62.6 | 1 | 311 | 9 | 29 | 128 | CAH6719291.1 NEDD8-conjugating enzyme Ubc12p [[Candida] jaroonii] | diamond | 915 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Yamadazyma | [Candida] jaroonii | |
| 28293862 | 28293862 | PRJNA690234_P_NODE_24466_length_256_cov_1.278689_g24099_i0 | PRJNA690234 | 24466 | 256 | 1.278689 | 3.27344384 | Opisthokonta | 33154 | Fungi | Fungi | 65.1 | 5.99e-10 | NR | XP_011277251.1 | 1041607 | g24099 | i0 | 38.8 | 3.9375 | 80 | 49 | 93.8 | 0 | 1 | 240 | 489 | 568 | XP_011277251.1 uncharacterized protein BN7_391 [Wickerhamomyces ciferrii] | diamond | 1008 | 65.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Wickerhamomycetaceae | Wickerhamomyces | Wickerhamomyces ciferrii | |
| 28704585 | 28704585 | PRJNA690234_P_NODE_30987_length_243_cov_0.917647_g30620_i0 | PRJNA690234 | 30987 | 243 | 0.917647 | 2.22988221 | Aspergillaceae | 1131492 | Fungi | Fungi | 104 | 1.0999999999999998e-24 | NR | KAF4157850.1 | 293939 | g30620 | i0 | 88.2 | 5.11111111111111 | 51 | 6 | 63 | 0 | 6 | 158 | 280 | 330 | KAF4157850.1 hypothetical protein CNMCM6069_004933 [Aspergillus lentulus] | diamond | 1242 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus lentulus | |
| 28882355 | 28882355 | PRJNA690234_P_NODE_5888_length_533_cov_5.397826_g5525_i0 | PRJNA690234 | 5888 | 533 | 5.397826 | 28.77041258 | Hanseniaspora osmophila | 56408 | Fungi | Fungi | 195 | 1.5e-60 | NR | OEJ86052.1 | 56408 | g5525 | i0 | 60.8 | 9.21388367729831 | 148 | 58 | 83.3 | 0 | 37 | 480 | 7 | 154 | OEJ86052.1 Nucleoside diphosphate kinase [Hanseniaspora osmophila] | diamond | 4911 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycodales | Saccharomycodaceae | Hanseniaspora | Hanseniaspora osmophila | |
| 28925342 | 28925342 | PRJNA690234_P_NODE_5408_length_559_cov_2.744856_g5045_i0 | PRJNA690234 | 5408 | 559 | 2.744856 | 15.34374504 | root | 1 | Root_unresolved | Root_unresolved | 48.9 | 0.0052 | NR | CAF9921102.1 | 1940652 | g5045 | i0 | 31.4 | 0.912343470483005 | 102 | 63 | 54.7 | 2 | 227 | 532 | 270 | 364 | CAF9921102.1 MAG: hypothetical protein GOMPHAMPRED_002229 [Gomphillus americanus] | diamond | 510 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Ostropales | Graphidaceae | Gomphillus | Gomphillus americanus | |
| 29261124 | 29261124 | PRJNA690234_P_NODE_15569_length_322_cov_1.253012_g15202_i0 | PRJNA690234 | 15569 | 322 | 1.253012 | 4.03469864 | Spathaspora sp. JA1 | 2028339 | Fungi | Fungi | 57 | 9.04e-7 | NR | RLV90187.1 | 2028339 | g15202 | i0 | 33 | 1.01552795031056 | 109 | 67 | 98.8 | 3 | 1 | 318 | 189 | 294 | RLV90187.1 NADH dehydrogenase ubiquinone complex I assembly factor 7 [Spathaspora sp. JA1] | diamond | 327 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Spathaspora | Spathaspora sp. JA1 | |
| 29924525 | 29924525 | PRJNA690234_P_NODE_11211_length_380_cov_1.296417_g10845_i0 | PRJNA690234 | 11211 | 380 | 1.296417 | 4.9263846 | Komagataella phaffii GS115 | 644223 | Fungi | Fungi | 46.2 | 0.00895 | NR | XP_002489962.1 | 644223 | g10845 | i0 | 38.6 | 0.907894736842105 | 57 | 34 | 45 | 1 | 173 | 3 | 66 | 121 | XP_002489962.1 uncharacterized protein PAS_chr1-1_0304 [Komagataella phaffii GS115] | diamond | 345 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Komagataella | Komagataella phaffii | |
| 30536166 | 30536166 | PRJNA690234_P_NODE_32153_length_239_cov_12.873494_g31786_i0 | PRJNA690234 | 32153 | 239 | 12.873494 | 30.76765066 | Eukaryota | 2759 | Fungi | Fungi | 92.8 | 1.22e-22 | NR | XP_047761105.1 | 5499 | g31786 | i0 | 66.2 | 16.2050209205021 | 68 | 23 | 85.4 | 0 | 22 | 225 | 1 | 68 | XP_047761105.1 60S ribosomal protein L38 [Fulvia fulva] | diamond | 3873 | 93.2 | 0.995708154506438 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Fulvia | Fulvia fulva | |
| 31504677 | 31504677 | PRJNA690234_P_NODE_8296_length_445_cov_2.801075_g7930_i0 | PRJNA690234 | 8296 | 445 | 2.801075 | 12.46478375 | Pneumocystis sp. 'macacae' | 2698480 | Fungi | Fungi | 79 | 6.55e-14 | NR | KAG5519159.1 | 2698480 | g7930 | i0 | 48.8 | 0.950561797752809 | 84 | 41 | 56.6 | 2 | 254 | 3 | 43 | 124 | KAG5519159.1 hypothetical protein PMAC_002247 [Pneumocystis sp. 'macacae'] | diamond | 423 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pneumocystomycetes | Pneumocystales | Pneumocystaceae | Pneumocystis | Pneumocystis sp. 'macacae' | |
| 31768946 | 31768946 | PRJNA690234_P_NODE_19117_length_290_cov_1.078341_g18750_i0 | PRJNA690234 | 19117 | 290 | 1.078341 | 3.1271889 | Opisthokonta | 33154 | Fungi | Fungi | 75.9 | 1.29e-14 | NR | XP_025339803.1 | 45357 | g18750 | i0 | 46.4 | 5.04827586206897 | 97 | 47 | 95.2 | 1 | 2 | 277 | 31 | 127 | XP_025339803.1 hypothetical protein CXQ85_001153 [Candidozyma haemuli] | diamond | 1464 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Candidozyma | Candidozyma haemuli | |
| 32200544 | 32200544 | PRJNA690234_P_NODE_7938_length_456_cov_1.091384_g7572_i0 | PRJNA690234 | 7938 | 456 | 1.091384 | 4.97671104 | Rasamsonia emersonii CBS 393.64 | 1408163 | Fungi | Fungi | 69.7 | 1.52e-10 | NR | XP_013327271.1 | 1408163 | g7572 | i0 | 33.1 | 3.19736842105263 | 121 | 69 | 79.6 | 2 | 449 | 87 | 1366 | 1474 | XP_013327271.1 Rho GTPase activator (Bem3) [Rasamsonia emersonii CBS 393.64] | diamond | 1458 | 69.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Rasamsonia | Rasamsonia emersonii | |
| 32295762 | 32295762 | PRJNA690234_P_NODE_24699_length_254_cov_3.701657_g24332_i0 | PRJNA690234 | 24699 | 254 | 3.701657 | 9.40220878 | Saccharomycopsis crataegensis | 43959 | Fungi | Fungi | 75.1 | 1.72e-13 | NR | XP_064851041.1 | 43959 | g24332 | i0 | 48.6 | 6.16535433070866 | 70 | 35 | 82.7 | 1 | 243 | 34 | 268 | 336 | XP_064851041.1 protein phosphatase 2A regulatory subunit RTS1 [Saccharomycopsis crataegensis] | diamond | 1566 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Ascoideales | Saccharomycopsidaceae | Saccharomycopsis | Saccharomycopsis crataegensis | |
| 32307187 | 32307187 | PRJNA690234_P_NODE_21219_length_275_cov_1.925743_g20852_i0 | PRJNA690234 | 21219 | 275 | 1.925743 | 5.29579325 | Ascomycota | 4890 | Fungi | Fungi | 44.3 | 0.0152 | NR | KAL3955720.1 | 33203 | g20852 | i0 | 46.5 | 5.18181818181818 | 43 | 23 | 46.9 | 0 | 134 | 6 | 39 | 81 | KAL3955720.1 hypothetical protein ACCO45_011283 [Purpureocillium lilacinum] | diamond | 1425 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 32465224 | 32465224 | PRJNA690234_P_NODE_25719_length_252_cov_0.871508_g25352_i0 | PRJNA690234 | 25719 | 252 | 0.871508 | 2.19620016 | root | 1 | Root_unresolved | Root_unresolved | 119 | 4.79e-31 | NR | KAF3927184.1 | 47266 | g25352 | i0 | 61.4 | 26.7261904761905 | 83 | 32 | 98.8 | 0 | 249 | 1 | 168 | 250 | KAF3927184.1 hypothetical protein ABW20_dc0103557 [Dactylellina cionopaga] | diamond | 6735 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Dactylellina | Dactylellina cionopaga |
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);;