contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA721440" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15222198 | 15222198 | PRJNA721440_S_NODE_4892_length_268_cov_3.273973_g4766_i0 | PRJNA721440 | 4892 | 268 | 3.273973 | 8.77424764 | Agaricomycetes | 155619 | Fungi | Fungi | 132 | 1.98e-33 | NR | VDC04220.1 | 718367 | g4766 | i0 | 67 | 8.86567164179104 | 88 | 29 | 98.5 | 0 | 266 | 3 | 101 | 188 | VDC04220.1 unnamed protein product [Peniophora sp. CBMAI 1063] | diamond | 2376 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora sp. CBMAI 1063 | |
| 26703654 | 26703654 | PRJNA721440_S_NODE_14161_length_180_cov_2.030534_g14035_i0 | PRJNA721440 | 14161 | 180 | 2.030534 | 3.6549612 | Irpex rosettiformis | 378272 | Fungi | Fungi | 59.3 | 1.9e-8 | NR | KAI0091203.1 | 378272 | g14035 | i0 | 48.3 | 0.966666666666667 | 58 | 30 | 96.7 | 0 | 6 | 179 | 145 | 202 | KAI0091203.1 hypothetical protein BDY19DRAFT_689193 [Irpex rosettiformis] | diamond | 174 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Irpicaceae | Irpex | Irpex rosettiformis | |
| 26767219 | 26767219 | PRJNA721440_S_NODE_7521_length_227_cov_6.247191_g7395_i0 | PRJNA721440 | 7521 | 227 | 6.247191 | 14.18112357 | Ceratobasidium theobromae | 1582974 | Fungi | Fungi | 50.1 | 8.18e-5 | NR | KAB5596271.1 | 1582974 | g7395 | i0 | 47.7 | 1.0704845814978 | 44 | 23 | 58.1 | 0 | 77 | 208 | 4932 | 4975 | KAB5596271.1 Histone acetyltransferase [Ceratobasidium theobromae] | diamond | 243 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium theobromae | |
| 27442041 | 27442041 | PRJNA721440_S_NODE_12243_length_190_cov_1.304965_g12117_i0 | PRJNA721440 | 12243 | 190 | 1.304965 | 2.4794335 | Fungi | 4751 | Fungi | Fungi | 49.3 | 8.24e-5 | NR | XP_052945812.1 | 4972 | g12117 | i0 | 66.7 | 2.16315789473684 | 33 | 11 | 52.1 | 0 | 92 | 190 | 26 | 58 | XP_052945812.1 nucleophile aminohydrolase [Dioszegia hungarica] | diamond | 411 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 27463008 | 27463008 | PRJNA721440_S_NODE_4103_length_287_cov_25.235294_g3977_i0 | PRJNA721440 | 4103 | 287 | 25.235294 | 72.42529378 | Agrocybe pediades | 84607 | Fungi | Fungi | 41.6 | 0.0296 | NR | KAF9561969.1 | 84607 | g3977 | i0 | 54.8 | 0.439024390243902 | 42 | 18 | 43.9 | 1 | 2 | 127 | 3 | 43 | KAF9561969.1 hypothetical protein CPC08DRAFT_634678 [Agrocybe pediades] | diamond | 126 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Agrocybe | Agrocybe pediades | |
| 27505110 | 27505110 | PRJNA721440_S_NODE_20903_length_157_cov_2.564815_g20777_i0 | PRJNA721440 | 20903 | 157 | 2.564815 | 4.02675955 | Agaricales | 5338 | Fungi | Fungi | 59.3 | 1.65e-8 | NR | XP_046082522.1 | 5353 | g20777 | i0 | 60 | 2.5796178343949 | 45 | 16 | 86 | 1 | 2 | 136 | 566 | 608 | XP_046082522.1 subtilisin-like protein [Lentinula edodes] | diamond | 405 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 28168002 | 28168002 | PRJNA721440_S_NODE_3125_length_322_cov_1.139194_g2999_i0 | PRJNA721440 | 3125 | 322 | 1.139194 | 3.66820468 | Basidiomycota | 5204 | Fungi | Fungi | 93.6 | 1.34e-19 | NR | KAI0786308.1 | 137743 | g2999 | i0 | 45.2 | 20.4037267080745 | 104 | 48 | 96.9 | 2 | 10 | 321 | 323 | 417 | KAI0786308.1 pyridoxal phosphate-dependent transferase [Abortiporus biennis] | diamond | 6570 | 94.4 | 0.991525423728813 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Podoscyphaceae | Abortiporus | Abortiporus biennis | |
| 28262521 | 28262521 | PRJNA721440_S_NODE_18926_length_164_cov_1.417391_g18800_i0 | PRJNA721440 | 18926 | 164 | 1.417391 | 2.32452124 | Eukaryota | 2759 | Fungi | Fungi | 110 | 1.74e-27 | NR | CEQ41850.1 | 5005 | g18800 | i0 | 88.9 | 7.90243902439024 | 54 | 6 | 98.8 | 0 | 3 | 164 | 188 | 241 | CEQ41850.1 SPOSA6832_03600, partial [Sporobolomyces salmonicolor] | diamond | 1296 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces salmonicolor | |
| 28262522 | 28262522 | PRJNA721440_S_NODE_3106_length_323_cov_1.328467_g2980_i0 | PRJNA721440 | 3106 | 323 | 1.328467 | 4.29094841 | Opisthokonta | 33154 | Fungi | Fungi | 97.4 | 6.230000000000001e-21 | NR | UZJ57202.1 | 63378 | g2980 | i0 | 49.5 | 4.58823529411765 | 99 | 50 | 92 | 0 | 1 | 297 | 808 | 906 | UZJ57202.1 hypothetical protein CBS101457_006522 [Exobasidium rhododendri] | diamond | 1482 | 97.8 | 0.995910020449898 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Exobasidiaceae | Exobasidium | Exobasidium rhododendri | |
| 28441821 | 28441821 | PRJNA721440_S_NODE_16846_length_169_cov_1.758333_g16720_i0 | PRJNA721440 | 16846 | 169 | 1.758333 | 2.97158277 | Cronartium quercuum f. sp. fusiforme G11 | 708437 | Fungi | Fungi | 51.6 | 3.81e-6 | NR | KAG0145562.1 | 708437 | g16720 | i0 | 49 | 3.72781065088757 | 51 | 26 | 90.5 | 0 | 159 | 7 | 69 | 119 | KAG0145562.1 hypothetical protein CROQUDRAFT_658480 [Cronartium quercuum f. sp. fusiforme G11] | diamond | 630 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Coleosporiaceae | Cronartium | Cronartium quercuum | |
| 29904695 | 29904695 | PRJNA721440_S_NODE_6431_length_241_cov_1.619792_g6305_i0 | PRJNA721440 | 6431 | 241 | 1.619792 | 3.90369872 | Agaricomycetes | 155619 | Fungi | Fungi | 57.8 | 1.79e-7 | NR | KLO17007.1 | 27342 | g6305 | i0 | 74.4 | 4.58091286307054 | 39 | 10 | 48.5 | 0 | 3 | 119 | 371 | 409 | KLO17007.1 DNA ligase I [Schizopora paradoxa] | diamond | 1104 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Schizoporaceae | Schizopora | Schizopora paradoxa | |
| 30947383 | 30947383 | PRJNA721440_S_NODE_10854_length_199_cov_1.386667_g10728_i0 | PRJNA721440 | 10854 | 199 | 1.386667 | 2.75946733 | Eukaryota | 2759 | Fungi | Fungi | 58.5 | 5.61e-8 | NR | KAI0727802.1 | 40450 | g10728 | i0 | 40 | 2.23115577889447 | 85 | 29 | 95 | 2 | 192 | 4 | 209 | 293 | KAI0727802.1 ABC1-domain-containing protein [Fomitopsis betulina] | diamond | 444 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Fomitopsidaceae | Fomitopsis | Fomitopsis betulina | |
| 32328666 | 32328666 | PRJNA721440_S_NODE_15339_length_175_cov_1.301587_g15213_i0 | PRJNA721440 | 15339 | 175 | 1.301587 | 2.27777725 | Heliocybe sulcata | 5364 | Fungi | Fungi | 68.2 | 1.62e-11 | NR | TFK53678.1 | 5364 | g15213 | i0 | 64.3 | 9.54857142857143 | 42 | 15 | 72 | 0 | 47 | 172 | 387 | 428 | TFK53678.1 hypothetical protein OE88DRAFT_1733567 [Heliocybe sulcata] | diamond | 1671 | 68.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Gloeophyllales | Gloeophyllaceae | Heliocybe | Heliocybe sulcata | |
| 32339027 | 32339027 | PRJNA721440_S_NODE_10259_length_203_cov_1.350649_g10133_i0 | PRJNA721440 | 10259 | 203 | 1.350649 | 2.74181747 | Malassezia | 55193 | Fungi | Fungi | 47.4 | 5e-4 | NR | WFC99072.1 | 253288 | g10133 | i0 | 47.8 | 3.57635467980296 | 46 | 24 | 68 | 0 | 23 | 160 | 68 | 113 | WFC99072.1 E3 ubiquitin-protein ligase pub1 [Malassezia yamatoensis] | diamond | 726 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia yamatoensis |
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);;