contig_metadata
14 rows where bioproject = "PRJNA534016" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3058375 | 3058375 | PRJNA534016_P_NODE_16243_length_245_cov_2.209302_g16153_i0 | PRJNA534016 | 16243 | 245 | 2.209302 | 5.4127899 | Pisolithus orientalis | 936130 | Fungi | Fungi | 65.8 | 2.84e-6 | NTclustered | gi|2325053199|ref|XM_051746077.1| | 936130 | g16153 | i0 | 81.707 | 0.33469387755102 | 82 | 11 | 33 | 4 | 128 | 207 | 2623 | 2544 | Pisolithus orientalis salt tolerance down-regulator-domain-containing protein (F5J12DRAFT_839508), mRNA | blastn | 82 | 65.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Pisolithaceae | Pisolithus | Pisolithus orientalis | |
| 4334429 | 4334429 | PRJNA534016_P_NODE_17104_length_244_cov_0.865497_g17014_i0 | PRJNA534016 | 17104 | 244 | 0.865497 | 2.11181268 | Malassezia restricta | 76775 | Fungi | Fungi | 440 | 4.019999999999999e-119 | NTclustered | gi|1546637143|ref|XM_027630214.1| | 76775 | g17014 | i0 | 99.18 | 1.82786885245902 | 244 | 2 | 100 | 0 | 1 | 244 | 33 | 276 | Malassezia restricta lipid transfer protein (MRET_3587), partial mRNA | blastn | 446 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6221904 | 6221904 | PRJNA534016_P_NODE_3185_length_458_cov_1.200000_g3095_i0 | PRJNA534016 | 3185 | 458 | 1.2 | 5.496 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.012 | NTclustered | gi|2491063213|gb|CP122433.1| | 5207 | g3095 | i0 | 100 | 2.64847161572052 | 29 | 0 | 6 | 0 | 370 | 398 | 608420 | 608392 | Cryptococcus neoformans isolate IUM96-2828 | blastn | 1213 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus neoformans | |
| 11321334 | 11321334 | PRJNA534016_P_NODE_16389_length_245_cov_0.895349_g16299_i0 | PRJNA534016 | 16389 | 245 | 0.895349 | 2.19360505 | Cryptococcus | 5206 | Fungi | Fungi | 453 | 5.1900000000000006e-123 | NTclustered | gi|1376261204|ref|XM_567977.2| | 214684 | g16299 | i0 | 100 | 10.4734693877551 | 245 | 0 | 100 | 0 | 1 | 245 | 26 | 270 | Cryptococcus neoformans var. neoformans JEC21 bud site selection-related protein, putative (CNL04250), mRNA | blastn | 2566 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus deneoformans | |
| 15810265 | 15810265 | PRJNA534016_P_NODE_18113_length_241_cov_1.708333_g18023_i0 | PRJNA534016 | 18113 | 241 | 1.708333 | 4.11708253 | Malassezia globosa | 76773 | Fungi | Fungi | 412 | 8.64e-111 | NTclustered | gi|164659775|ref|XM_001730960.1| | 425265 | g18023 | i0 | 97.51 | 1 | 241 | 6 | 100 | 0 | 1 | 241 | 113 | 353 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2011), partial mRNA | blastn | 241 | 412 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 19633545 | 19633545 | PRJNA534016_P_NODE_13796_length_251_cov_0.865169_g13706_i0 | PRJNA534016 | 13796 | 251 | 0.865169 | 2.17157419 | Wallemia | 148959 | Fungi | Fungi | 72.4 | 1.45e-12 | NR | TIA92543.1 | 1540922 | g13706 | i0 | 77.3 | 3.14342629482072 | 44 | 10 | 52.6 | 0 | 120 | 251 | 278 | 321 | TIA92543.1 hypothetical protein E3P99_00572 [Wallemia hederae] | diamond | 789 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Wallemiomycetes | Wallemiales | Wallemiaceae | Wallemia | Wallemia hederae | |
| 23459649 | 23459649 | PRJNA534016_P_NODE_11139_length_270_cov_1.543147_g11049_i0 | PRJNA534016 | 11139 | 270 | 1.543147 | 4.1664969 | Malassezia restricta | 76775 | Fungi | Fungi | 499 | 7.349999999999998e-137 | NTclustered | gi|1546631754|ref|XM_027627537.1| | 76775 | g11049 | i0 | 100 | 3.03333333333333 | 270 | 0 | 100 | 0 | 1 | 270 | 553 | 822 | Malassezia restricta methylenetetrahydrofolate reductase (NADPH) (MRET_0910), partial mRNA | blastn | 819 | 499 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 28025426 | 28025426 | PRJNA534016_P_NODE_8885_length_288_cov_1.293023_g8795_i0 | PRJNA534016 | 8885 | 288 | 1.293023 | 3.72390624 | Coprinopsis sp. MPI-PUGE-AT- | 1859955 | Fungi | Fungi | 67.8 | 6.74e-11 | NR | KAH6897529.1 | 2826081 | g8795 | i0 | 38.9 | 1.91666666666667 | 95 | 57 | 97.9 | 1 | 6 | 287 | 139 | 233 | KAH6897529.1 metalloprotease, partial [Coprinopsis sp. MPI-PUGE-AT-0042] | diamond | 552 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Psathyrellaceae | Coprinopsis | Coprinopsis sp. MPI-PUGE-AT-0042 | |
| 28513892 | 28513892 | PRJNA534016_P_NODE_18067_length_241_cov_2.071429_g17977_i0 | PRJNA534016 | 18067 | 241 | 2.071429 | 4.99214389 | Ceratobasidium | 5251 | Fungi | Fungi | 133 | 2.45e-34 | NR | QRV75876.1 | 170446 | g17977 | i0 | 77.2 | 13.7676348547718 | 79 | 18 | 98.3 | 0 | 239 | 3 | 360 | 438 | QRV75876.1 mucoidy inhibitor A [Ceratobasidium sp. AG-Ba] | diamond | 3318 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. AG-Ba | |
| 29414511 | 29414511 | PRJNA534016_P_NODE_15289_length_248_cov_0.880000_g15199_i0 | PRJNA534016 | 15289 | 248 | 0.88 | 2.1824 | Malassezia restricta | 76775 | Fungi | Fungi | 93.6 | 4.64e-21 | NR | XP_027484041.1 | 76775 | g15199 | i0 | 73.6 | 0.641129032258065 | 53 | 14 | 64.1 | 0 | 3 | 161 | 62 | 114 | XP_027484041.1 cysteine-rich secretory protein [Malassezia restricta] | diamond | 159 | 93.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30520107 | 30520107 | PRJNA534016_P_NODE_11593_length_266_cov_2.336788_g11503_i0 | PRJNA534016 | 11593 | 266 | 2.336788 | 6.21585608 | Meira miltonrushii | 1280837 | Fungi | Fungi | 152 | 3.999999999999999e-42 | NR | XP_025358680.1 | 1280837 | g11503 | i0 | 79.1 | 10.6917293233083 | 86 | 18 | 97 | 0 | 266 | 9 | 148 | 233 | XP_025358680.1 histone deacetylase, partial [Meira miltonrushii] | diamond | 2844 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 30724595 | 30724595 | PRJNA534016_P_NODE_2774_length_490_cov_2.268585_g2684_i0 | PRJNA534016 | 2774 | 490 | 2.268585 | 11.1160665 | Eukaryota | 2759 | Fungi | Fungi | 73.2 | 8.61e-12 | NR | KAJ1308859.1 | 456999 | g2684 | i0 | 36.2 | 2.36938775510204 | 105 | 60 | 60.6 | 2 | 314 | 18 | 141 | 244 | KAJ1308859.1 hypothetical protein OPQ81_004547 [Rhizoctonia solani] | diamond | 1161 | 73.6 | 0.994565217391304 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 31563430 | 31563430 | PRJNA534016_P_NODE_18896_length_232_cov_2.522013_g18806_i0 | PRJNA534016 | 18896 | 232 | 2.522013 | 5.85107016 | Ceratobasidium sp. 395 | 2600204 | Fungi | Fungi | 97.1 | 1.3099999999999999e-23 | NR | KAG8707497.1 | 2600204 | g18806 | i0 | 58.7 | 0.969827586206897 | 75 | 31 | 97 | 0 | 6 | 230 | 1 | 75 | KAG8707497.1 hypothetical protein FRC09_001786 [Ceratobasidium sp. 395] | diamond | 225 | 97.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Ceratobasidium | Ceratobasidium sp. 395 | |
| 32195908 | 32195908 | PRJNA534016_P_NODE_13158_length_254_cov_1.701657_g13068_i0 | PRJNA534016 | 13158 | 254 | 1.701657 | 4.32220878 | Leucosporidium creatinivorum | 106004 | Fungi | Fungi | 146 | 1.36e-40 | NR | ORY77273.1 | 106004 | g13068 | i0 | 89.3 | 0.992125984251969 | 84 | 9 | 99.2 | 0 | 3 | 254 | 204 | 287 | ORY77273.1 hypothetical protein BCR35DRAFT_305580 [Leucosporidium creatinivorum] | diamond | 252 | 146 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium creatinivorum |
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);;