contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA789095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 771611 | 771611 | PRJNA789095_P_NODE_74201_length_242_cov_2.840237_g72867_i0 | PRJNA789095 | 74201 | 242 | 2.840237 | 6.87337354 | Malassezia | 55193 | Fungi | Fungi | 68.2 | 8.89e-12 | NR | KAI3626799.1 | 55194 | g72867 | i0 | 58.6 | 2.96280991735537 | 58 | 24 | 71.9 | 0 | 232 | 59 | 131 | 188 | KAI3626799.1 hypothetical protein CBS14141_000800 [Malassezia furfur] | diamond | 717 | 68.6 | 0.994169096209913 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 10975777 | 10975777 | PRJNA789095_P_NODE_81089_length_210_cov_5.094891_g79755_i0 | PRJNA789095 | 81089 | 210 | 5.094891 | 10.6992711 | Malassezia | 55193 | Fungi | Fungi | 113 | 9.57e-28 | NR | WFD45897.1 | 55194 | g79755 | i0 | 78.6 | 2 | 70 | 3 | 100 | 1 | 1 | 210 | 342 | 399 | WFD45897.1 cross-pathway control WD-repeat protein cpc2 [Malassezia furfur] | diamond | 420 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 23723813 | 23723813 | PRJNA789095_P_NODE_53359_length_278_cov_1.478049_g52025_i0 | PRJNA789095 | 53359 | 278 | 1.478049 | 4.10897622 | Basidiomycota | 5204 | Fungi | Fungi | 177 | 9.25e-51 | NR | KLO19468.1 | 27342 | g52025 | i0 | 88 | 22.8345323741007 | 92 | 11 | 99.3 | 0 | 276 | 1 | 256 | 347 | KLO19468.1 ATP-utilizing phosphoenolpyruvate carboxykinase [Schizopora paradoxa] | diamond | 6348 | 177 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Schizoporaceae | Schizopora | Schizopora paradoxa | |
| 26841654 | 26841654 | PRJNA789095_P_NODE_64721_length_253_cov_1.683333_g63387_i0 | PRJNA789095 | 64721 | 253 | 1.683333 | 4.25883249 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 6.62e-6 | NR | XP_040625895.1 | 1858805 | g63387 | i0 | 45.5 | 2.63241106719368 | 77 | 39 | 88.9 | 3 | 26 | 250 | 40 | 115 | XP_040625895.1 uncharacterized protein DACRYDRAFT_24099 [Dacryopinax primogenitus] | diamond | 666 | 53.1 | 0.994350282485876 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Dacrymycetes | Dacrymycetales | Dacrymycetaceae | Dacryopinax | Dacryopinax primogenitus | |
| 27031253 | 27031253 | PRJNA789095_P_NODE_68862_length_248_cov_0.880000_g67528_i0 | PRJNA789095 | 68862 | 248 | 0.88 | 2.1824 | Basidiomycota | 5204 | Fungi | Fungi | 103 | 5.63e-26 | NR | KAH9959285.1 | 71967 | g67528 | i0 | 60 | 2.90322580645161 | 80 | 32 | 96.8 | 0 | 8 | 247 | 41 | 120 | KAH9959285.1 RlpA-like double-psi beta-barrel-protein domain-containing protein-containing protein [Lactifluus volemus] | diamond | 720 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Lactifluus | Lactifluus volemus | |
| 27758235 | 27758235 | PRJNA789095_P_NODE_47964_length_290_cov_2.705069_g46630_i0 | PRJNA789095 | 47964 | 290 | 2.705069 | 7.8447001 | Eukaryota | 2759 | Fungi | Fungi | 55.5 | 8.57e-7 | NR | KAG9056993.1 | 2136033 | g46630 | i0 | 47.7 | 2.78275862068966 | 65 | 31 | 67.2 | 1 | 67 | 261 | 118 | 179 | KAG9056993.1 hypothetical protein FS842_009019 [Serendipita sp. 407] | diamond | 807 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita sp. 407 | ||
| 28443540 | 28443540 | PRJNA789095_P_NODE_60586_length_262_cov_1.629630_g59252_i0 | PRJNA789095 | 60586 | 262 | 1.62963 | 4.2696306 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 66.2 | 3.49e-12 | NR | XP_025599637.1 | 58919 | g59252 | i0 | 57.8 | 0.732824427480916 | 64 | 27 | 73.3 | 0 | 257 | 66 | 8 | 71 | XP_025599637.1 glucose-repressible protein [Tilletiopsis washingtonensis] | diamond | 192 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 28885262 | 28885262 | PRJNA789095_P_NODE_58688_length_266_cov_2.533679_g57354_i0 | PRJNA789095 | 58688 | 266 | 2.533679 | 6.73958614 | Meira miltonrushii | 1280837 | Fungi | Fungi | 61.2 | 1.46e-8 | NR | XP_025354554.1 | 1280837 | g57354 | i0 | 52 | 0.56390977443609 | 50 | 24 | 56.4 | 0 | 60 | 209 | 328 | 377 | XP_025354554.1 uncharacterized protein FA14DRAFT_161709 [Meira miltonrushii] | diamond | 150 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 29232828 | 29232828 | PRJNA789095_P_NODE_6629_length_1378_cov_6.639080_g5843_i0 | PRJNA789095 | 6629 | 1378 | 6.63908 | 91.4865224 | Rhizopogon vinicolor AM-OR11- | 80600 | Fungi | Fungi | 50.8 | 4.27e-4 | NR | OAX36531.1 | 1314800 | g5843 | i0 | 39.3 | 0.132801161103048 | 61 | 37 | 13.3 | 0 | 174 | 356 | 30 | 90 | OAX36531.1 hypothetical protein K503DRAFT_292075 [Rhizopogon vinicolor AM-OR11-026] | diamond | 183 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Rhizopogonaceae | Rhizopogon | Rhizopogon vinicolor | |
| 29453364 | 29453364 | PRJNA789095_P_NODE_6750_length_1362_cov_6.141971_g5843_i1 | PRJNA789095 | 6750 | 1362 | 6.141971 | 83.65364502 | Rhizopogon vinicolor AM-OR11- | 80600 | Fungi | Fungi | 50.8 | 4.22e-4 | NR | OAX36531.1 | 1314800 | g5843 | i1 | 39.3 | 0.134361233480176 | 61 | 37 | 13.4 | 0 | 174 | 356 | 30 | 90 | OAX36531.1 hypothetical protein K503DRAFT_292075 [Rhizopogon vinicolor AM-OR11-026] | diamond | 183 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Rhizopogonaceae | Rhizopogon | Rhizopogon vinicolor | |
| 29453366 | 29453366 | PRJNA789095_P_NODE_72870_length_244_cov_0.900585_g71536_i0 | PRJNA789095 | 72870 | 244 | 0.900585 | 2.1974274 | Meira miltonrushii | 1280837 | Fungi | Fungi | 130 | 7.28e-33 | NR | XP_025357647.1 | 1280837 | g71536 | i0 | 87.7 | 0.995901639344262 | 81 | 10 | 99.6 | 0 | 1 | 243 | 61 | 141 | XP_025357647.1 uncharacterized protein FA14DRAFT_13287 [Meira miltonrushii] | diamond | 243 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 29841816 | 29841816 | PRJNA789095_P_NODE_32191_length_368_cov_1.562712_g30858_i0 | PRJNA789095 | 32191 | 368 | 1.562712 | 5.75078016 | Agaricomycetes | 155619 | Fungi | Fungi | 90.1 | 4.06e-18 | NR | OCB90505.1 | 108892 | g30858 | i0 | 55.6 | 5.3070652173913 | 81 | 35 | 65.2 | 1 | 368 | 129 | 955 | 1035 | OCB90505.1 PRMT5-domain-containing protein [Sanghuangporus baumii] | diamond | 1953 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Sanghuangporus | Sanghuangporus baumii | |
| 30022292 | 30022292 | PRJNA789095_P_NODE_42091_length_310_cov_3.025316_g40757_i0 | PRJNA789095 | 42091 | 310 | 3.025316 | 9.3784796 | Rhodotorula diobovata | 5288 | Fungi | Fungi | 95.9 | 1.74e-20 | NR | TNY20571.1 | 5288 | g40757 | i0 | 100 | 0.474193548387097 | 49 | 0 | 47.4 | 0 | 162 | 308 | 505 | 553 | TNY20571.1 fungal-specific transcription factor domain-containing protein [Rhodotorula diobovata] | diamond | 147 | 95.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula diobovata | |
| 31190813 | 31190813 | PRJNA789095_P_NODE_39315_length_319_cov_5.121951_g37981_i0 | PRJNA789095 | 39315 | 319 | 5.121951 | 16.33902369 | Flammula alnicola | 109635 | Fungi | Fungi | 43.9 | 0.0119 | NR | KAF8952608.1 | 109635 | g37981 | i0 | 34.3 | 0.630094043887147 | 67 | 44 | 63 | 0 | 100 | 300 | 53 | 119 | KAF8952608.1 hypothetical protein BDZ97DRAFT_1768292 [Flammula alnicola] | diamond | 201 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Flammula | Flammula alnicola | |
| 32108483 | 32108483 | PRJNA789095_P_NODE_71678_length_245_cov_0.895349_g70344_i0 | PRJNA789095 | 71678 | 245 | 0.895349 | 2.19360505 | Malassezia equina | 1381935 | Fungi | Fungi | 157 | 1.91e-42 | NR | WFD21966.1 | 1381935 | g70344 | i0 | 90.1 | 1.98367346938776 | 81 | 8 | 99.2 | 0 | 243 | 1 | 877 | 957 | WFD21966.1 eukaryotic translation initiation factor 5B [Malassezia equina] | diamond | 486 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia equina |
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);;