contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA883229" 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 |
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);;