contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA785164" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23719417 | 23719417 | PRJNA785164_P_NODE_55199_length_247_cov_1.327586_g54734_i0 | PRJNA785164 | 55199 | 247 | 1.327586 | 3.27913742 | Agaricomycetes | 155619 | Fungi | Fungi | 83.6 | 1.71e-16 | NR | PPQ69774.1 | 93625 | g54734 | i0 | 75.6 | 13.1052631578947 | 45 | 11 | 54.7 | 0 | 198 | 64 | 591 | 635 | PPQ69774.1 hypothetical protein CVT25_009758 [Psilocybe cyanescens] | diamond | 3237 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Psilocybe | Psilocybe cyanescens | |
| 26736720 | 26736720 | PRJNA785164_P_NODE_58481_length_244_cov_0.900585_g58016_i0 | PRJNA785164 | 58481 | 244 | 0.900585 | 2.1974274 | Irpex lacteus | 5319 | Fungi | Fungi | 158 | 9.689999999999999e-43 | NR | KAI0821229.1 | 5319 | g58016 | i0 | 97.5 | 0.983606557377049 | 80 | 2 | 98.4 | 0 | 3 | 242 | 302 | 381 | KAI0821229.1 hypothetical protein BC629DRAFT_1459321 [Irpex lacteus] | diamond | 240 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Irpicaceae | Irpex | Irpex lacteus | |
| 27053727 | 27053727 | PRJNA785164_P_NODE_51382_length_251_cov_0.865169_g50917_i0 | PRJNA785164 | 51382 | 251 | 0.865169 | 2.17157419 | Peniophora sp. CBMAI 1 | 1756134 | Fungi | Fungi | 49.3 | 2.06e-4 | NR | VDB85539.1 | 718367 | g50917 | i0 | 50.8 | 0.776892430278884 | 65 | 30 | 77.7 | 1 | 199 | 5 | 260 | 322 | VDB85539.1 unnamed protein product [Peniophora sp. CBMAI 1063] | diamond | 195 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora sp. CBMAI 1063 | |
| 27622488 | 27622488 | PRJNA785164_P_NODE_35744_length_303_cov_1.026087_g35279_i0 | PRJNA785164 | 35744 | 303 | 1.026087 | 3.10904361 | Exidia glandulosa HHB12 | 5219 | Fungi | Fungi | 51.2 | 7.33e-5 | NR | KZV85490.1 | 1314781 | g35279 | i0 | 41.1 | 0.722772277227723 | 73 | 38 | 72.3 | 1 | 229 | 11 | 32 | 99 | KZV85490.1 hypothetical protein EXIGLDRAFT_753308 [Exidia glandulosa HHB12029] | diamond | 219 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Exidiaceae | Exidia | Exidia glandulosa | |
| 28095946 | 28095946 | PRJNA785164_P_NODE_40045_length_285_cov_1.051887_g39580_i0 | PRJNA785164 | 40045 | 285 | 1.051887 | 2.99787795 | Exidia glandulosa HHB12 | 5219 | Fungi | Fungi | 161 | 3.06e-48 | NR | KZV93014.1 | 1314781 | g39580 | i0 | 96.2 | 0.821052631578947 | 78 | 3 | 82.1 | 0 | 283 | 50 | 114 | 191 | KZV93014.1 hypothetical protein EXIGLDRAFT_836018 [Exidia glandulosa HHB12029] | diamond | 234 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Exidiaceae | Exidia | Exidia glandulosa | |
| 28885197 | 28885197 | PRJNA785164_P_NODE_32408_length_320_cov_1.246964_g31943_i0 | PRJNA785164 | 32408 | 320 | 1.246964 | 3.9902848 | Exidia glandulosa HHB12 | 5219 | Fungi | Fungi | 51.2 | 3.08e-5 | NR | KZV95851.1 | 1314781 | g31943 | i0 | 31.5 | 0.8625 | 92 | 48 | 86.3 | 1 | 12 | 287 | 78 | 154 | KZV95851.1 hypothetical protein EXIGLDRAFT_706435 [Exidia glandulosa HHB12029] | diamond | 276 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Exidiaceae | Exidia | Exidia glandulosa | |
| 29832517 | 29832517 | PRJNA785164_P_NODE_51611_length_251_cov_0.865169_g51146_i0 | PRJNA785164 | 51611 | 251 | 0.865169 | 2.17157419 | Steccherinum ochraceum | 92696 | Fungi | Fungi | 91.3 | 3.48e-19 | NR | TCD71043.1 | 92696 | g51146 | i0 | 89.6 | 0.573705179282869 | 48 | 5 | 57.4 | 0 | 2 | 145 | 952 | 999 | TCD71043.1 hypothetical protein EIP91_000542 [Steccherinum ochraceum] | diamond | 144 | 91.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Steccherinaceae | Steccherinum | Steccherinum ochraceum | |
| 29864093 | 29864093 | PRJNA785164_P_NODE_38691_length_290_cov_1.064516_g38226_i0 | PRJNA785164 | 38691 | 290 | 1.064516 | 3.0870964 | Malassezia japonica | 223818 | Fungi | Fungi | 55.8 | 1.56e-6 | NR | XP_060120974.1 | 223818 | g38226 | i0 | 41.8 | 0.941379310344828 | 91 | 27 | 86.9 | 4 | 277 | 26 | 231 | 302 | XP_060120974.1 uncharacterized protein MJAP1_001025 [Malassezia japonica] | diamond | 273 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 30053498 | 30053498 | PRJNA785164_P_NODE_39151_length_288_cov_1.404651_g38686_i0 | PRJNA785164 | 39151 | 288 | 1.404651 | 4.04539488 | Microbotryum intermedium | 269621 | Fungi | Fungi | 67.4 | 1.38e-10 | NR | SCV68322.1 | 269621 | g38686 | i0 | 38 | 3.46875 | 79 | 49 | 82.3 | 0 | 237 | 1 | 431 | 509 | SCV68322.1 BQ2448_443 [Microbotryum intermedium] | diamond | 999 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Microbotryales | Microbotryaceae | Microbotryum | Microbotryum intermedium | |
| 30970080 | 30970080 | PRJNA785164_P_NODE_60554_length_242_cov_1.343195_g60089_i0 | PRJNA785164 | 60554 | 242 | 1.343195 | 3.2505319 | Peniophora sp. CBMAI 1 | 1756134 | Fungi | Fungi | 67 | 1.05e-10 | NR | VDB85539.1 | 718367 | g60089 | i0 | 53.1 | 1.00413223140496 | 81 | 34 | 97.9 | 3 | 6 | 242 | 99 | 177 | VDB85539.1 unnamed protein product [Peniophora sp. CBMAI 1063] | diamond | 243 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora sp. CBMAI 1063 | |
| 32456674 | 32456674 | PRJNA785164_P_NODE_54359_length_248_cov_0.880000_g53894_i0 | PRJNA785164 | 54359 | 248 | 0.88 | 2.1824 | Sporobolomyces salmonicolor | 5005 | Fungi | Fungi | 91.7 | 2.43e-19 | NR | CEQ39964.1 | 5005 | g53894 | i0 | 81.5 | 0.653225806451613 | 54 | 10 | 65.3 | 0 | 80 | 241 | 656 | 709 | CEQ39964.1 SPOSA6832_01552, partial [Sporobolomyces salmonicolor] | diamond | 162 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces salmonicolor | |
| 32520025 | 32520025 | PRJNA785164_P_NODE_46319_length_264_cov_1.821990_g45854_i0 | PRJNA785164 | 46319 | 264 | 1.82199 | 4.8100536 | Peniophora sp. CONT | 1314672 | Fungi | Fungi | 88.2 | 9.05e-19 | NR | KZV68938.1 | 1314672 | g45854 | i0 | 94.1 | 0.579545454545455 | 51 | 3 | 58 | 0 | 153 | 1 | 1 | 51 | KZV68938.1 RmlC-like cupin [Peniophora sp. CONT] | diamond | 153 | 88.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora sp. CONT | |
| 32645618 | 32645618 | PRJNA785164_P_NODE_22080_length_402_cov_1.352584_g21615_i0 | PRJNA785164 | 22080 | 402 | 1.352584 | 5.43738768 | Cystobasidium minutum MCA 421 | 29899 | Fungi | Fungi | 48.9 | 0.00136 | NR | XP_066826863.1 | 1397322 | g21615 | i0 | 44.6 | 0.552238805970149 | 74 | 32 | 50 | 4 | 22 | 222 | 297 | 368 | XP_066826863.1 uncharacterized protein P389DRAFT_18698 [Cystobasidium minutum MCA 4210] | diamond | 222 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum |
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);;