contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA1008624" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26971075 | 26971075 | PRJNA1008624_P_NODE_29882_length_167_cov_0.881356_g29694_i0 | PRJNA1008624 | 29882 | 167 | 0.881356 | 1.47186452 | Phialemonium thermophilum | 223376 | Fungi | Fungi | 50.8 | 1.86e-5 | NR | KAL1884135.1 | 223376 | g29694 | i0 | 51.1 | 0.844311377245509 | 47 | 23 | 84.4 | 0 | 26 | 166 | 1292 | 1338 | KAL1884135.1 hypothetical protein VTK73DRAFT_6804 [Phialemonium thermophilum] | diamond | 141 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Cephalothecales | Cephalothecaceae | Phialemonium | Phialemonium thermophilum | |
| 27034474 | 27034474 | PRJNA1008624_P_NODE_17022_length_206_cov_1.560510_g16834_i0 | PRJNA1008624 | 17022 | 206 | 1.56051 | 3.2146506 | Aplosporella prunicola CBS 121167 | 1176127 | Fungi | Fungi | 42.4 | 0.0322 | NR | XP_033402087.1 | 1176127 | g16834 | i0 | 43.4 | 0.771844660194175 | 53 | 27 | 72.8 | 1 | 157 | 8 | 482 | 534 | XP_033402087.1 uncharacterized protein K452DRAFT_294938 [Aplosporella prunicola CBS 121167] | diamond | 159 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Botryosphaeriales | Aplosporellaceae | Aplosporella | Aplosporella prunicola | |
| 27603420 | 27603420 | PRJNA1008624_P_NODE_31144_length_166_cov_0.888889_g30956_i0 | PRJNA1008624 | 31144 | 166 | 0.888889 | 1.47555574 | Exophiala aquamarina CBS 119918 | 1182545 | Fungi | Fungi | 51.6 | 9.86e-6 | NR | XP_013259299.1 | 1182545 | g30956 | i0 | 57.4 | 0.849397590361446 | 47 | 16 | 84.9 | 1 | 1 | 141 | 13 | 55 | XP_013259299.1 triacylglycerol lipase [Exophiala aquamarina CBS 119918] | diamond | 141 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala aquamarina | |
| 29055744 | 29055744 | PRJNA1008624_P_NODE_27508_length_169_cov_0.866667_g27320_i0 | PRJNA1008624 | 27508 | 169 | 0.866667 | 1.46466723 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 102 | 8.989999999999998e-24 | NR | PJF19140.1 | 1246581 | g27320 | i0 | 81.8 | 0.976331360946746 | 55 | 10 | 97.6 | 0 | 169 | 5 | 450 | 504 | PJF19140.1 hypothetical protein PSACC_01058 [Paramicrosporidium saccamoebae] | diamond | 165 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 30287660 | 30287660 | PRJNA1008624_P_NODE_28892_length_168_cov_0.873950_g28704_i0 | PRJNA1008624 | 28892 | 168 | 0.87395 | 1.468236 | Podospora comata | 48703 | Fungi | Fungi | 41.2 | 0.0477 | NR | VBB81160.1 | 48703 | g28704 | i0 | 42 | 0.892857142857143 | 50 | 24 | 80.4 | 1 | 136 | 2 | 860 | 909 | VBB81160.1 Putative protein of unknown function [Podospora comata] | diamond | 150 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Podosporaceae | Podospora | Podospora comata | |
| 30476997 | 30476997 | PRJNA1008624_P_NODE_15193_length_217_cov_0.886905_g15005_i0 | PRJNA1008624 | 15193 | 217 | 0.886905 | 1.92458385 | Cyclocybe aegerita | 1973307 | Fungi | Fungi | 43.1 | 0.0108 | NR | CAA7263378.1 | 1973307 | g15005 | i0 | 44.7 | 0.525345622119816 | 38 | 20 | 52.5 | 1 | 77 | 190 | 51 | 87 | CAA7263378.1 unnamed protein product [Cyclocybe aegerita] | diamond | 114 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Bolbitiaceae | Cyclocybe | Cyclocybe aegerita | |
| 30532511 | 30532511 | PRJNA1008624_P_NODE_29053_length_168_cov_0.873950_g28865_i0 | PRJNA1008624 | 29053 | 168 | 0.87395 | 1.468236 | Cadophora | 210567 | Fungi | Fungi | 42 | 0.0251 | NR | XP_058359988.1 | 51156 | g28865 | i0 | 47.5 | 5.71428571428571 | 40 | 21 | 71.4 | 0 | 166 | 47 | 106 | 145 | XP_058359988.1 uncharacterized protein ONS95_009718 [Cadophora gregata] | diamond | 960 | 42.4 | 0.990566037735849 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Ploettnerulaceae | Cadophora | Cadophora gregata | |
| 31235034 | 31235034 | PRJNA1008624_P_NODE_29675_length_167_cov_0.881356_g29487_i0 | PRJNA1008624 | 29675 | 167 | 0.881356 | 1.47186452 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 68.9 | 7.62e-12 | NR | KAH9260345.1 | 1357716 | g29487 | i0 | 57.4 | 0.970059880239521 | 54 | 23 | 97 | 0 | 1 | 162 | 734 | 787 | KAH9260345.1 ATP-dependent Clp protease, ATP-binding subunit ClpX [Batrachochytrium salamandrivorans] | diamond | 162 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 31519985 | 31519985 | PRJNA1008624_P_NODE_27576_length_169_cov_0.866667_g27388_i0 | PRJNA1008624 | 27576 | 169 | 0.866667 | 1.46466723 | Dactylonectria macrodidyma | 307937 | Fungi | Fungi | 72.4 | 3.86e-13 | NR | KAH7121494.1 | 307937 | g27388 | i0 | 85.7 | 2.16568047337278 | 42 | 6 | 74.6 | 0 | 44 | 169 | 168 | 209 | KAH7121494.1 phosphorylcholine phosphatase [Dactylonectria macrodidyma] | diamond | 366 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Dactylonectria | Dactylonectria macrodidyma | |
| 32815714 | 32815714 | PRJNA1008624_P_NODE_16540_length_209_cov_1.062500_g16352_i0 | PRJNA1008624 | 16540 | 209 | 1.0625 | 2.220625 | Trichoderma harzianum CBS 226.95 | 983964 | Fungi | Fungi | 42.7 | 0.00476 | NR | XP_024780201.1 | 983964 | g16352 | i0 | 54.5 | 0.861244019138756 | 33 | 13 | 47.4 | 1 | 1 | 99 | 50 | 80 | XP_024780201.1 hypothetical protein M431DRAFT_131280, partial [Trichoderma harzianum CBS 226.95] | diamond | 180 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma harzianum |
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);;