contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1146029" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2840992 | 2840992 | PRJNA1146029_P_NODE_3243_length_475_cov_2.641791_g2966_i0 | PRJNA1146029 | 3243 | 475 | 2.641791 | 12.54850725 | Malassezia restricta | 76775 | Fungi | Fungi | 878 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g2966 | i0 | 100 | 106.513684210526 | 475 | 0 | 100 | 0 | 1 | 475 | 1943 | 1469 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 50594 | 878 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3584078 | 3584078 | PRJNA1146029_P_NODE_13143_length_270_cov_2.619289_g12862_i0 | PRJNA1146029 | 13143 | 270 | 2.619289 | 7.0720803 | Opisthokonta | 33154 | Fungi | Fungi | 499 | 7.349999999999998e-137 | NTclustered | gi|126508724|gb|EF397600.1| | 81056 | g12862 | i0 | 100 | 106.003703703704 | 270 | 0 | 100 | 0 | 1 | 270 | 2464 | 2733 | Poria cocos strain KANP No. 7233 28S ribosomal RNA gene, partial sequence | blastn | 28621 | 499 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phaeolaceae | Wolfiporia | Wolfiporia cocos | |
| 4117128 | 4117128 | PRJNA1146029_P_NODE_19484_length_245_cov_1.656977_g19203_i0 | PRJNA1146029 | 19484 | 245 | 1.656977 | 4.05959365 | Malassezia restricta | 76775 | Fungi | Fungi | 448 | 2.41e-121 | NTclustered | gi|1546631449|ref|XM_027627385.1| | 76775 | g19203 | i0 | 99.592 | 2.89387755102041 | 245 | 1 | 100 | 0 | 1 | 245 | 3247 | 3491 | Malassezia restricta phosphoribosylformylglycinamidine synthase (MRET_0758), partial mRNA | blastn | 709 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 5393371 | 5393371 | PRJNA1146029_P_NODE_20685_length_243_cov_1.358824_g20404_i0 | PRJNA1146029 | 20685 | 243 | 1.358824 | 3.30194232 | Kwoniella dendrophila | 4975 | Fungi | Fungi | 228 | 3.389999999999999e-55 | NTclustered | gi|2752973927|ref|XM_066215864.1| | 1295534 | g20404 | i0 | 83.74 | 16.4814814814815 | 246 | 34 | 100 | 4 | 1 | 243 | 413 | 171 | Kwoniella dendrophila CBS 6074 histone H3 (L201_000057), partial mRNA | blastn | 4005 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella dendrophila | |
| 6136492 | 6136492 | PRJNA1146029_P_NODE_2465_length_545_cov_3.925847_g2190_i0 | PRJNA1146029 | 2465 | 545 | 3.925847 | 21.39586615 | Opisthokonta | 33154 | Fungi | Fungi | 579 | 1.9899999999999998e-160 | NTclustered | gi|915512607|gb|KP825390.1| | 76775 | g2190 | i0 | 100 | 92.9302752293578 | 313 | 0 | 84 | 0 | 1 | 313 | 519 | 207 | Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence | blastn | 50647 | 579 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 13786964 | 13786964 | PRJNA1146029_P_NODE_15531_length_253_cov_1.711111_g15250_i0 | PRJNA1146029 | 15531 | 253 | 1.711111 | 4.32911083 | Malassezia | 55193 | Fungi | Fungi | 468 | 1.92e-127 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g15250 | i0 | 100 | 49.4743083003953 | 253 | 0 | 100 | 0 | 1 | 253 | 1689 | 1437 | Malassezia restricta mitochondrion, complete genome | blastn | 12517 | 468 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 21966909 | 21966909 | PRJNA1146029_P_NODE_16018_length_251_cov_0.865169_g15737_i0 | PRJNA1146029 | 16018 | 251 | 0.865169 | 2.17157419 | Vanrija pseudolonga | 143232 | Fungi | Fungi | 93.5 | 1.34e-14 | NTclustered | gi|2669736644|ref|XM_062770045.1| | 143232 | g15737 | i0 | 94.915 | 1.0597609561753 | 59 | 3 | 24 | 0 | 1 | 59 | 477 | 535 | Vanrija pseudolonga putative transporter (SPCC417.10_7), partial mRNA | blastn | 266 | 93.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 23242396 | 23242396 | PRJNA1146029_P_NODE_13719_length_266_cov_3.834197_g13438_i0 | PRJNA1146029 | 13719 | 266 | 3.834197 | 10.19896402 | Malassezia restricta | 76775 | Fungi | Fungi | 479 | 9.42e-131 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g13438 | i0 | 99.245 | 89.6353383458647 | 265 | 2 | 99 | 0 | 2 | 266 | 3241 | 2977 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 23843 | 479 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;