contig_metadata
16 rows where bioproject = "PRJNA339266", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1666008 | 1666008 | PRJNA339266_P_NODE_8242_length_153_cov_4.000000_g8212_i0 | PRJNA339266 | 8242 | 153 | 4 | 6.12 | Malassezia globosa | 76773 | Fungi | Fungi | 147 | 5.589999999999999e-31 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g8212 | i0 | 100 | 10.1503267973856 | 79 | 0 | 87 | 0 | 1 | 79 | 2781 | 2859 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 1553 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 1666239 | 1666239 | PRJNA339266_S_NODE_4682_length_218_cov_2.447514_g4671_i0 | PRJNA339266 | 4682 | 218 | 2.447514 | 5.33558052 | Malassezia restricta | 76775 | Fungi | Fungi | 231 | 2.3099999999999997e-56 | NTclustered | gi|1546635923|ref|XM_027629604.1| | 76775 | g4671 | i0 | 98.473 | 1.04587155963303 | 131 | 2 | 94 | 0 | 14 | 144 | 1 | 131 | Malassezia restricta parafibromin (MRET_2977), partial mRNA | blastn | 228 | 231 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 8722428 | 8722428 | PRJNA339266_P_NODE_6527_length_172_cov_1.614815_g6497_i0 | PRJNA339266 | 6527 | 172 | 1.614815 | 2.7774818 | Sporidiobolaceae | 1799696 | Fungi | Fungi | 318 | 1.2899999999999999e-82 | NTclustered | gi|671394780|gb|KJ806312.1| | 5288 | g6497 | i0 | 100 | 99.9767441860465 | 172 | 0 | 100 | 0 | 1 | 172 | 736 | 907 | Rhodosporidium diobovatum isolate H-5 18S ribosomal RNA gene, partial sequence | blastn | 17196 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula diobovata | |
| 13823321 | 13823321 | PRJNA339266_S_NODE_4211_length_223_cov_7.876344_g4200_i0 | PRJNA339266 | 4211 | 223 | 7.876344 | 17.56424712 | Agaricales | 5338 | Fungi | Fungi | 363 | 8.049999999999997e-96 | NTclustered | gi|358679416|gb|JQ045879.1| | 5350 | g4200 | i0 | 95.982 | 100.273542600897 | 224 | 7 | 100 | 2 | 1 | 223 | 270 | 48 | Coprinopsis radiata strain SZMC-NL-1269 28S ribosomal RNA (LSU) gene, partial sequence | blastn | 22361 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinopsis | Coprinopsis radiata | |
| 16968684 | 16968684 | PRJNA339266_P_NODE_4394_length_189_cov_4.309211_g4364_i0 | PRJNA339266 | 4394 | 189 | 4.309211 | 8.14440879 | Trametes versicolor | 5325 | Fungi | Fungi | 121 | 4.38e-23 | NTclustered | gi|636622788|ref|XM_008044338.1| | 717944 | g4364 | i0 | 93.75 | 0.423280423280423 | 80 | 5 | 42 | 0 | 2 | 81 | 325 | 404 | Trametes versicolor FP-101664 SS1 uncharacterized protein (TRAVEDRAFT_23145), partial mRNA | blastn | 80 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Trametes | Trametes versicolor | |
| 17647469 | 17647469 | PRJNA339266_S_NODE_1274_length_300_cov_13.205323_g1263_i0 | PRJNA339266 | 1274 | 300 | 13.205323 | 39.615969 | Cylindrobasidium torrendii FP15 | 394432 | Fungi | Fungi | 152 | 3.22e-42 | NR | KIY64996.1 | 1314674 | g1263 | i0 | 93.8 | 0.8 | 80 | 5 | 80 | 0 | 300 | 61 | 315 | 394 | KIY64996.1 DnaJ-domain-containing protein [Cylindrobasidium torrendii FP15055 ss-10] | diamond | 240 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Cylindrobasidium | Cylindrobasidium torrendii | |
| 23343500 | 23343500 | PRJNA339266_S_NODE_3259_length_238_cov_4.960199_g3248_i0 | PRJNA339266 | 3259 | 238 | 4.960199 | 11.80527362 | Coprinellus micaceus | 71717 | Fungi | Fungi | 385 | 1.86e-102 | NTclustered | gi|2088246494|ref|NC_057083.1| | 71717 | g3248 | i0 | 95.798 | 104.411764705882 | 238 | 10 | 100 | 0 | 1 | 238 | 18990 | 18753 | Coprinellus micaceus mitochondrion, complete genome | blastn | 24850 | 385 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinellus | Coprinellus micaceus | |
| 24021633 | 24021633 | PRJNA339266_S_NODE_5779_length_206_cov_4.248521_g5768_i0 | PRJNA339266 | 5779 | 206 | 4.248521 | 8.75195326 | Basidiomycota | 5204 | Fungi | Fungi | 375 | 9.41e-100 | NTclustered | gi|1256909|dbj|D38239.1|BENJCM2896 | 4996 | g5768 | i0 | 99.515 | 100 | 206 | 1 | 100 | 0 | 1 | 206 | 762 | 967 | Bensingtonia yamatoana (strain JCM 2896) gene for 18S rRNA | blastn | 20600 | 375 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Chrysozymaceae | Bannozyma | Bannozyma yamatoana | ||
| 27534314 | 27534314 | PRJNA339266_S_NODE_19703_length_150_cov_5.115044_g19692_i0 | PRJNA339266 | 19703 | 150 | 5.115044 | 7.672566 | Agaricomycetes | 155619 | Fungi | Fungi | 51.6 | 1.9e-6 | NR | XP_007395572.1 | 650164 | g19692 | i0 | 85.7 | 2.96 | 28 | 4 | 56 | 0 | 1 | 84 | 48 | 75 | XP_007395572.1 uncharacterized protein PHACADRAFT_208754 [Phanerochaete carnosa HHB-10118-sp] | diamond | 444 | 52 | 0.992307692307692 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phanerochaetaceae | Phanerochaete | Phanerochaete carnosa | |
| 29348442 | 29348442 | PRJNA339266_S_NODE_15909_length_159_cov_2.377049_g15898_i0 | PRJNA339266 | 15909 | 159 | 2.377049 | 3.77950791 | Candolleomyces aberdarensis | 2316362 | Fungi | Fungi | 68.6 | 9.14e-12 | NR | RXW16985.1 | 2316362 | g15898 | i0 | 70.7 | 3.20754716981132 | 41 | 12 | 77.4 | 0 | 11 | 133 | 397 | 437 | RXW16985.1 hypothetical protein EST38_g8869 [Candolleomyces aberdarensis] | diamond | 510 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Candolleomyces | Candolleomyces aberdarensis | |
| 30137481 | 30137481 | PRJNA339266_P_NODE_3472_length_199_cov_84.049383_g3442_i0 | PRJNA339266 | 3472 | 199 | 84.049383 | 167.25827217 | Phaffia rhodozyma | 264483 | Fungi | Fungi | 62.8 | 1.79e-9 | NR | CED82426.1 | 264483 | g3442 | i0 | 67.7 | 5.23115577889447 | 62 | 15 | 85.9 | 1 | 172 | 2 | 313 | 374 | CED82426.1 agc ndr protein kinase [Phaffia rhodozyma] | diamond | 1041 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Phaffia | Phaffia rhodozyma | |
| 31148480 | 31148480 | PRJNA339266_S_NODE_10875_length_175_cov_7.731884_g10864_i0 | PRJNA339266 | 10875 | 175 | 7.731884 | 13.530797 | Austropuccinia psidii | 181123 | Fungi | Fungi | 43.1 | 0.00449 | NR | MBW0562822.1 | 1389203 | g10864 | i0 | 40 | 0.685714285714286 | 40 | 24 | 68.6 | 0 | 124 | 5 | 55 | 94 | MBW0562822.1 hypothetical protein [Austropuccinia psidii MF-1] | diamond | 120 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Sphaerophragmiaceae | Austropuccinia | Austropuccinia psidii | |
| 31939498 | 31939498 | PRJNA339266_S_NODE_5037_length_214_cov_2.615819_g5026_i0 | PRJNA339266 | 5037 | 214 | 2.615819 | 5.59785266 | Lentinula raphanica | 153919 | Fungi | Fungi | 44.3 | 0.00714 | NR | KAJ3827713.1 | 153919 | g5026 | i0 | 58.5 | 1.06542056074766 | 41 | 16 | 56.1 | 1 | 72 | 191 | 37 | 77 | KAJ3827713.1 acyltransferase ChoActase/COT/CPT [Lentinula raphanica] | diamond | 228 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula raphanica | |
| 32034577 | 32034577 | PRJNA339266_S_NODE_6838_length_198_cov_2.012422_g6827_i0 | PRJNA339266 | 6838 | 198 | 2.012422 | 3.98459556 | Coprinopsis cinerea AmutBmut pab1-1 | 1132390 | Fungi | Fungi | 88.6 | 1.45e-18 | NR | KAG2023262.1 | 1132390 | g6827 | i0 | 66.2 | 0.984848484848485 | 65 | 22 | 98.5 | 0 | 197 | 3 | 632 | 696 | KAG2023262.1 hypothetical protein CC2G_000935 [Coprinopsis cinerea AmutBmut pab1-1] | diamond | 195 | 88.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinopsis | Coprinopsis cinerea | |
| 32178571 | 32178571 | PRJNA339266_S_NODE_14998_length_161_cov_7.943548_g14987_i0 | PRJNA339266 | 14998 | 161 | 7.943548 | 12.78911228 | Sporobolomyces | 5429 | Fungi | Fungi | 50.8 | 2.2e-6 | NR | GAA6021474.1 | 183961 | g14987 | i0 | 77.8 | 1.04347826086957 | 27 | 6 | 50.3 | 0 | 161 | 81 | 69 | 95 | GAA6021474.1 hypothetical protein JCM11491_006508 [Sporobolomyces phaffii] | diamond | 168 | 51.2 | 0.9921875 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces phaffii | |
| 32319650 | 32319650 | PRJNA339266_P_NODE_4179_length_191_cov_4.493506_g4149_i0 | PRJNA339266 | 4179 | 191 | 4.493506 | 8.58259646 | Rhodotorula sp. JG-1b | 1305733 | Fungi | Fungi | 70.5 | 1.6e-12 | NR | KWU46170.1 | 1305733 | g4149 | i0 | 94.6 | 0.581151832460733 | 37 | 2 | 58.1 | 0 | 3 | 113 | 49 | 85 | KWU46170.1 hypothetical protein RHOSPDRAFT_32162 [Rhodotorula sp. JG-1b] | diamond | 111 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula sp. JG-1b |
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);;