contig_metadata
11 rows where bioproject = "PRJNA883229", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3410699 | 3410699 | PRJNA883229_P_NODE_16083_length_242_cov_1.668639_g16037_i0 | PRJNA883229 | 16083 | 242 | 1.668639 | 4.03810638 | Malassezia globosa | 76773 | Fungi | Fungi | 425 | 1.11e-114 | NTclustered | gi|164662854|ref|XM_001732497.1| | 425265 | g16037 | i0 | 98.347 | 1 | 242 | 4 | 100 | 0 | 1 | 242 | 1383 | 1624 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_0324), partial mRNA | blastn | 242 | 425 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 3410738 | 3410738 | PRJNA883229_P_NODE_4103_length_332_cov_0.903475_g4057_i0 | PRJNA883229 | 4103 | 332 | 0.903475 | 2.999537 | Rhizoctonia solani | 456999 | Fungi | Fungi | 326 | 1.67e-84 | NTclustered | gi|2086746752|ref|XM_043323921.1| | 456999 | g4057 | i0 | 84.337 | 100.030120481928 | 332 | 52 | 100 | 0 | 1 | 332 | 1171 | 840 | Rhizoctonia solani ATP synthase alpha/beta family (RhiXN_04104), partial mRNA | blastn | 33210 | 326 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 4688319 | 4688319 | PRJNA883229_P_NODE_14264_length_245_cov_0.906977_g14218_i0 | PRJNA883229 | 14264 | 245 | 0.906977 | 2.22209365 | Dioszegia hungarica | 4972 | Fungi | Fungi | 257 | 4.37e-64 | NTclustered | gi|2432175759|ref|XR_008288897.1| | 4972 | g14218 | i0 | 85.887 | 135.387755102041 | 248 | 27 | 100 | 8 | 1 | 245 | 3302 | 3060 | Dioszegia hungarica 25S ribosomal RNA (MKK02DRAFT_277614), rRNA | blastn | 33170 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Dioszegia | Dioszegia hungarica | |
| 7238149 | 7238149 | PRJNA883229_P_NODE_4986_length_308_cov_2.353191_g4940_i0 | PRJNA883229 | 4986 | 308 | 2.353191 | 7.24782828 | Kwoniella botswanensis | 1268659 | Fungi | Fungi | 180 | 1.26e-40 | NTclustered | gi|2725014035|ref|XM_064888381.1| | 1268659 | g4940 | i0 | 81.14 | 5.09090909090909 | 228 | 39 | 73 | 4 | 6 | 231 | 1450 | 1225 | Kwoniella botswanensis alpha,alpha-trehalose-phosphate synthase [UDP-forming] 1 (L199_002642), partial mRNA | blastn | 1568 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella botswanensis | |
| 14887909 | 14887909 | PRJNA883229_P_NODE_12312_length_248_cov_0.891429_g12266_i0 | PRJNA883229 | 12312 | 248 | 0.891429 | 2.21074392 | Lactifluus hygrophoroides | 1837245 | Fungi | Fungi | 76.8 | 1.33e-9 | NTclustered | gi|1442329546|ref|NC_038206.1| | 1837245 | g12266 | i0 | 82.759 | 0.661290322580645 | 87 | 14 | 35 | 1 | 40 | 126 | 36116 | 36201 | Lactifluus hygrophoroides mitochondrion, complete genome | blastn | 164 | 76.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Lactifluus | Lactifluus hygrophoroides | |
| 19986579 | 19986579 | PRJNA883229_P_NODE_11276_length_249_cov_0.886364_g11230_i0 | PRJNA883229 | 11276 | 249 | 0.886364 | 2.20704636 | Vanrija pseudolonga | 143232 | Fungi | Fungi | 416 | 6.939999999999999e-112 | NTclustered | gi|2669720522|ref|XM_062767286.1| | 143232 | g11230 | i0 | 96.787 | 4.00401606425703 | 249 | 8 | 100 | 0 | 1 | 249 | 2895 | 3143 | Vanrija pseudolonga Fatty acid synthase subunit beta (FAS1), mRNA | blastn | 997 | 416 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 19986730 | 19986730 | PRJNA883229_P_NODE_9556_length_252_cov_0.871508_g9510_i0 | PRJNA883229 | 9556 | 252 | 0.871508 | 2.19620016 | Pholiotina longicystidiata | 3109156 | Fungi | Fungi | 161 | 3.639999999999999e-35 | NTclustered | gi|2647551922|gb|PP000893.1| | 3109156 | g9510 | i0 | 82.199 | 66.8412698412698 | 191 | 30 | 75 | 4 | 60 | 248 | 633 | 821 | Pholiotina longicystidiata voucher HMJAU65056 transcriptional elongation factor 1-alpha (tef1) gene, partial cds | blastn | 16844 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Bolbitiaceae | Pholiotina | Pholiotina longicystidiata | |
| 27466330 | 27466330 | PRJNA883229_P_NODE_14803_length_244_cov_0.912281_g14757_i0 | PRJNA883229 | 14803 | 244 | 0.912281 | 2.22596564 | Tulasnella sp. 4 | 1905295 | Fungi | Fungi | 77.8 | 1.72e-14 | NR | KAG8912287.1 | 2600224 | g14757 | i0 | 55 | 1.97950819672131 | 80 | 5 | 98.4 | 1 | 241 | 2 | 46 | 94 | KAG8912287.1 palmitoyltransferase akr1 [Tulasnella sp. 408] | diamond | 483 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 408 | |
| 28981955 | 28981955 | PRJNA883229_P_NODE_16688_length_242_cov_0.923077_g16642_i0 | PRJNA883229 | 16688 | 242 | 0.923077 | 2.23384634 | Tulasnella sp. 4 | 1905295 | Fungi | Fungi | 152 | 2.3599999999999993e-43 | NR | KAG8910571.1 | 2600224 | g16642 | i0 | 91.3 | 0.991735537190083 | 80 | 7 | 99.2 | 0 | 2 | 241 | 28 | 107 | KAG8910571.1 hypothetical protein FRC00_007967 [Tulasnella sp. 408] | diamond | 240 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 408 | |
| 29202898 | 29202898 | PRJNA883229_P_NODE_6149_length_286_cov_1.788732_g6103_i0 | PRJNA883229 | 6149 | 286 | 1.788732 | 5.11577352 | Exidia glandulosa HHB12 | 5219 | Fungi | Fungi | 51.6 | 4.49e-5 | NR | KZV88819.1 | 1314781 | g6103 | i0 | 66.7 | 0.986013986013986 | 36 | 12 | 37.8 | 0 | 227 | 120 | 440 | 475 | KZV88819.1 kinase-like protein, partial [Exidia glandulosa HHB12029] | diamond | 282 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Exidiaceae | Exidia | Exidia glandulosa | |
| 32867997 | 32867997 | PRJNA883229_P_NODE_13220_length_247_cov_0.896552_g13174_i0 | PRJNA883229 | 13220 | 247 | 0.896552 | 2.21448344 | Hericium alpestre | 135208 | Fungi | Fungi | 124 | 1.1e-31 | NR | TFY80870.1 | 135208 | g13174 | i0 | 76.5 | 9.83805668016194 | 81 | 19 | 98.4 | 0 | 3 | 245 | 120 | 200 | TFY80870.1 hypothetical protein EWM64_g3137 [Hericium alpestre] | diamond | 2430 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Hericiaceae | Hericium | Hericium alpestre |
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);;