contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA811725" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6327861 | 6327861 | PRJNA811725_P_NODE_18525_length_352_cov_3.971326_g18279_i0 | PRJNA811725 | 18525 | 352 | 3.971326 | 13.97906752 | Acaromyces ingoldii | 215250 | Fungi | Fungi | 102 | 1.17e-22 | NR | XP_025381487.1 | 215250 | g18279 | i0 | 57 | 1.03125 | 121 | 29 | 99.7 | 3 | 351 | 1 | 751 | 852 | XP_025381487.1 hypothetical protein FA10DRAFT_44781 [Acaromyces ingoldii] | diamond | 363 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Cryptobasidiaceae | Acaromyces | Acaromyces ingoldii | |
| 18661572 | 18661572 | PRJNA811725_P_NODE_5755_length_608_cov_23.867290_g5516_i0 | PRJNA811725 | 5755 | 608 | 23.86729 | 145.1131232 | Rhodotorula | 5533 | Fungi | Fungi | 374 | 7.03e-127 | NR | KWU43698.1 | 1305733 | g5516 | i0 | 98.5 | 1.99342105263158 | 202 | 3 | 99.7 | 0 | 3 | 608 | 136 | 337 | KWU43698.1 calcium/proton exchanger, partial [Rhodotorula sp. JG-1b] | diamond | 1212 | 377 | 0.992042440318302 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. JG-1b | |
| 22486714 | 22486714 | PRJNA811725_P_NODE_14358_length_396_cov_19.758514_g14113_i0 | PRJNA811725 | 14358 | 396 | 19.758514 | 78.24371544 | Rhodotorula | 5533 | Fungi | Fungi | 99 | 4.230000000000001e-21 | NR | KWU41760.1 | 1305733 | g14113 | i0 | 66.1 | 1.29545454545455 | 112 | 29 | 84.1 | 4 | 335 | 3 | 474 | 577 | KWU41760.1 hypothetical protein RHOSPDRAFT_36710 [Rhodotorula sp. JG-1b] | diamond | 513 | 99.4 | 0.995975855130785 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. JG-1b | |
| 27654688 | 27654688 | PRJNA811725_P_NODE_9324_length_484_cov_7.094891_g9080_i0 | PRJNA811725 | 9324 | 484 | 7.094891 | 34.33927244 | Rhodotorula sp. CCFEE 5 | 1853554 | Fungi | Fungi | 192 | 1.6199999999999998e-54 | NR | TKA50465.1 | 1965284 | g9080 | i0 | 79.1 | 0.948347107438017 | 153 | 22 | 93.6 | 6 | 483 | 31 | 269 | 413 | TKA50465.1 hypothetical protein B0A53_06135 [Rhodotorula sp. CCFEE 5036] | diamond | 459 | 192 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. CCFEE 5036 | |
| 29043943 | 29043943 | PRJNA811725_P_NODE_21068_length_330_cov_2.396887_g20822_i0 | PRJNA811725 | 21068 | 330 | 2.396887 | 7.9097271 | Pleurotus ostreatus PC15 | 1137138 | Fungi | Fungi | 160 | 1.02e-46 | NR | KDQ22457.1 | 1137138 | g20822 | i0 | 95.9 | 0.672727272727273 | 74 | 3 | 67.3 | 0 | 2 | 223 | 169 | 242 | KDQ22457.1 hypothetical protein PLEOSDRAFT_1090976 [Pleurotus ostreatus PC15] | diamond | 222 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus ostreatus | |
| 29928071 | 29928071 | PRJNA811725_P_NODE_7091_length_552_cov_11.467641_g6850_i0 | PRJNA811725 | 7091 | 552 | 11.467641 | 63.30137832 | Rhodotorula sp. JG-1b | 1305733 | Fungi | Fungi | 120 | 6.7599999999999985e-28 | NR | KWU41760.1 | 1305733 | g6850 | i0 | 67.6 | 0.989130434782609 | 182 | 47 | 96.7 | 3 | 17 | 550 | 1 | 174 | KWU41760.1 hypothetical protein RHOSPDRAFT_36710 [Rhodotorula sp. JG-1b] | diamond | 546 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. JG-1b | |
| 30243974 | 30243974 | PRJNA811725_P_NODE_8192_length_515_cov_4.794118_g7949_i0 | PRJNA811725 | 8192 | 515 | 4.794118 | 24.6897077 | Naganishia albida | 100951 | Fungi | Fungi | 300 | 2.49e-95 | NR | KAI5450702.1 | 100951 | g7949 | i0 | 92.9 | 0.978640776699029 | 168 | 12 | 97.9 | 0 | 504 | 1 | 43 | 210 | KAI5450702.1 Cystathionine gamma-synthase [Naganishia albida] | diamond | 504 | 300 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia albida | |
| 30528133 | 30528133 | PRJNA811725_P_NODE_42153_length_241_cov_0.916667_g41907_i0 | PRJNA811725 | 42153 | 241 | 0.916667 | 2.20916747 | Sporobolomyces koalae | 500713 | Fungi | Fungi | 98.2 | 3.3400000000000003e-22 | NR | GAA5928022.1 | 500713 | g41907 | i0 | 67.5 | 1.92946058091286 | 77 | 24 | 94.6 | 1 | 1 | 228 | 93 | 169 | GAA5928022.1 hypothetical protein JCM15063_006060 [Sporobolomyces koalae] | diamond | 465 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces koalae | |
| 31128166 | 31128166 | PRJNA811725_P_NODE_5215_length_634_cov_12.951872_g4978_i0 | PRJNA811725 | 5215 | 634 | 12.951872 | 82.11486848 | Pleurotus ostreatus PC15 | 1137138 | Fungi | Fungi | 337 | 1.11e-114 | NR | KDQ22457.1 | 1137138 | g4978 | i0 | 91.6 | 0.95583596214511 | 202 | 17 | 95.6 | 0 | 2 | 607 | 41 | 242 | KDQ22457.1 hypothetical protein PLEOSDRAFT_1090976 [Pleurotus ostreatus PC15] | diamond | 606 | 337 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus ostreatus | |
| 31159719 | 31159719 | PRJNA811725_P_NODE_22895_length_316_cov_2.382716_g22649_i0 | PRJNA811725 | 22895 | 316 | 2.382716 | 7.52938256 | Rhodotorula mucilaginosa | 5537 | Fungi | Fungi | 211 | 1.08e-65 | NR | KAG0660759.1 | 5537 | g22649 | i0 | 99 | 0.996835443037975 | 105 | 1 | 99.7 | 0 | 2 | 316 | 49 | 153 | KAG0660759.1 methylglyoxal reductase (NADPH-dependent) gre2 [Rhodotorula mucilaginosa] | diamond | 315 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 31358779 | 31358779 | PRJNA811725_P_NODE_12296_length_426_cov_1.640227_g12052_i0 | PRJNA811725 | 12296 | 426 | 1.640227 | 6.98736702 | Malassezia | 55193 | Fungi | Fungi | 177 | 2.24e-53 | NR | WFD26644.1 | 180528 | g12052 | i0 | 87.9 | 1.52112676056338 | 107 | 13 | 75.4 | 0 | 424 | 104 | 36 | 142 | WFD26644.1 DNA-directed DNA polymerase [Malassezia nana] | diamond | 648 | 177 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia nana | |
| 31539755 | 31539755 | PRJNA811725_P_NODE_6116_length_591_cov_18.839768_g5877_i0 | PRJNA811725 | 6116 | 591 | 18.839768 | 111.34302888 | Naganishia albida | 100951 | Fungi | Fungi | 248 | 8.98e-75 | NR | KAI5454183.1 | 100951 | g5877 | i0 | 93.1 | 0.87817258883248706 | 173 | 11 | 87.3 | 1 | 589 | 74 | 482 | 654 | KAI5454183.1 GTPase required for pre-60S ribosomal subunit nuclear export and maturation [Naganishia albida] | diamond | 519 | 248 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia albida | |
| 31634407 | 31634407 | PRJNA811725_P_NODE_39596_length_245_cov_0.895349_g39350_i0 | PRJNA811725 | 39596 | 245 | 0.895349 | 2.19360505 | Pleurotus cornucopiae | 5321 | Fungi | Fungi | 77 | 1.5e-15 | NR | KAG9218068.1 | 5321 | g39350 | i0 | 100 | 0.477551020408163 | 39 | 0 | 47.8 | 0 | 117 | 1 | 1 | 39 | KAG9218068.1 hypothetical protein CCMSSC00406_0010082 [Pleurotus cornucopiae] | diamond | 117 | 77 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus cornucopiae | |
| 31760981 | 31760981 | PRJNA811725_P_NODE_12737_length_419_cov_3.118497_g12493_i0 | PRJNA811725 | 12737 | 419 | 3.118497 | 13.06650243 | Naganishia albida | 100951 | Fungi | Fungi | 264 | 8.31e-82 | NR | KAI5450702.1 | 100951 | g12493 | i0 | 100 | 0.995226730310263 | 139 | 0 | 99.5 | 0 | 1 | 417 | 214 | 352 | KAI5450702.1 Cystathionine gamma-synthase [Naganishia albida] | diamond | 417 | 264 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia albida | |
| 32235967 | 32235967 | PRJNA811725_P_NODE_36558_length_250_cov_0.870056_g36312_i0 | PRJNA811725 | 36558 | 250 | 0.870056 | 2.17514 | Dioszegia hungarica | 4972 | Fungi | Fungi | 64.7 | 7.21e-10 | NR | XP_052946026.1 | 4972 | g36312 | i0 | 72.7 | 0.912 | 44 | 11 | 51.6 | 1 | 57 | 185 | 87 | 130 | XP_052946026.1 Serine/threonine-protein phosphatase 2B catalytic subunit A1 [Dioszegia hungarica] | diamond | 228 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica |
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);;