contig_metadata
17 rows where bioproject = "PRJNA642647" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1158563 | 1158563 | PRJNA642647_P_NODE_3641_length_186_cov_2.865772_g3591_i0 | PRJNA642647 | 3641 | 186 | 2.865772 | 5.33033592 | Malassezia | 55193 | Fungi | Fungi | 176 | 9.04e-40 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g3591 | i0 | 100 | 23.6881720430108 | 95 | 0 | 92 | 0 | 89 | 183 | 1138 | 1044 | Malassezia restricta mitochondrion, complete genome | blastn | 4406 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 1894183 | 1894183 | PRJNA642647_P_NODE_1582_length_277_cov_2.400000_g1532_i0 | PRJNA642647 | 1582 | 277 | 2.4 | 6.648 | Malassezia globosa | 76773 | Fungi | Fungi | 507 | 4.53e-139 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g1532 | i0 | 100 | 86.3862815884477 | 274 | 0 | 99 | 0 | 4 | 277 | 29684 | 29957 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 23929 | 507 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 2433724 | 2433724 | PRJNA642647_P_NODE_3482_length_189_cov_8.289474_g3432_i0 | PRJNA642647 | 3482 | 189 | 8.289474 | 15.66710586 | Malassezia | 55193 | Fungi | Fungi | 337 | 4e-88 | NTclustered | gi|375267973|dbj|AB663498.1| | 175244 | g3432 | i0 | 99.459 | 97.8835978835979 | 185 | 1 | 98 | 0 | 4 | 188 | 11 | 195 | Uncultured Basidiomycota gene for 26S rRNA, partial sequence, clone: 248 | blastn | 18500 | 337 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | uncultured Basidiomycota | |||||
| 3710336 | 3710336 | PRJNA642647_P_NODE_1523_length_281_cov_4.750000_g1473_i0 | PRJNA642647 | 1523 | 281 | 4.75 | 13.3475 | Malassezia | 55193 | Fungi | Fungi | 510 | 3.56e-140 | NTclustered | gi|37575174|gb|AY387222.1| | 55194 | g1473 | i0 | 99.643 | 99.6334519572954 | 280 | 0 | 99 | 1 | 3 | 281 | 4 | 283 | Malassezia furfur strain TPB1 large subunit ribosomal RNA gene, partial sequence | blastn | 27997 | 510 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 4445658 | 4445658 | PRJNA642647_P_NODE_1524_length_281_cov_3.483607_g1474_i0 | PRJNA642647 | 1524 | 281 | 3.483607 | 9.78893567 | uncultured Malassezia | 338567 | Fungi | Fungi | 518 | 2.13e-142 | NTclustered | gi|398360769|gb|JX132826.1| | 338567 | g1474 | i0 | 100 | 100.142348754448 | 280 | 0 | 99 | 0 | 2 | 281 | 550 | 271 | Uncultured Malassezia clone CEas161 26S ribosomal RNA gene, partial sequence | blastn | 28140 | 518 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | uncultured Malassezia | ||
| 6262248 | 6262248 | PRJNA642647_P_NODE_3625_length_186_cov_6.879195_g3575_i0 | PRJNA642647 | 3625 | 186 | 6.879195 | 12.7953027 | Hirschioporaceae | 3074113 | Fungi | Fungi | 281 | 1.86e-71 | NTclustered | gi|2136610469|gb|OL462832.1| | 50381 | g3575 | i0 | 94.536 | 98.6827956989247 | 183 | 9 | 98 | 1 | 1 | 183 | 1084 | 903 | Trichaptum biforme voucher Dai 22919 large subunit ribosomal RNA gene, partial sequence | blastn | 18355 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hirschioporaceae | Pallidohirschioporus | Pallidohirschioporus biformis | |
| 8271290 | 8271290 | PRJNA642647_P_NODE_4607_length_169_cov_10.356061_g4557_i0 | PRJNA642647 | 4607 | 169 | 10.356061 | 17.50174309 | Geastrum cf. triplex B KH-2011 | 1124827 | Fungi | Fungi | 287 | 3.55e-73 | NTclustered | gi|359751614|gb|JN939742.1| | 1124827 | g4557 | i0 | 97.605 | 98.8165680473373 | 167 | 4 | 99 | 0 | 1 | 167 | 569 | 735 | Geastrum cf. triplex B KH-2011 strain B037 28S ribosomal RNA (LSU) gene, partial sequence | blastn | 16700 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Geastrales | Geastraceae | Geastrum | Geastrum cf. triplex B KH-2011 | |
| 8271302 | 8271302 | PRJNA642647_P_NODE_5727_length_159_cov_2.303279_g5677_i0 | PRJNA642647 | 5727 | 159 | 2.303279 | 3.66221361 | Nidularia deformis | 566112 | Fungi | Fungi | 71.3 | 3.63e-8 | NTclustered | gi|1532344649|gb|MK278412.1| | 566112 | g5677 | i0 | 80.412 | 16.3018867924528 | 97 | 15 | 60 | 4 | 44 | 139 | 53 | 146 | Nidularia deformis strain G1717 large subunit ribosomal RNA gene, partial sequence | blastn | 2592 | 71.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Nidulariaceae | Nidularia | Nidularia deformis | |
| 11361952 | 11361952 | PRJNA642647_P_NODE_1449_length_289_cov_16.845238_g1399_i0 | PRJNA642647 | 1449 | 289 | 16.845238 | 48.68273782 | Fungi | 4751 | Fungi | Fungi | 115 | 3.36e-21 | NTclustered | gi|1859735574|gb|MT644892.1| | 71933 | g1399 | i0 | 100 | 21.8339100346021 | 62 | 0 | 21 | 0 | 228 | 289 | 4296 | 4235 | Amanita rubescens isolate DM1089 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 6310 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita rubescens | |
| 12637729 | 12637729 | PRJNA642647_P_NODE_3530_length_188_cov_8.781457_g3480_i0 | PRJNA642647 | 3530 | 188 | 8.781457 | 16.50913916 | Hirschioporaceae | 3074113 | Fungi | Fungi | 337 | 3.97e-88 | NTclustered | gi|1473261245|gb|MH874189.1| | 50381 | g3480 | i0 | 100 | 96.8723404255319 | 182 | 0 | 97 | 0 | 4 | 185 | 824 | 643 | Trichaptum biforme culture CBS:842.95 strain CBS 842.95 large subunit ribosomal RNA gene, partial sequence | blastn | 18212 | 337 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hirschioporaceae | Pallidohirschioporus | Pallidohirschioporus biformis | |
| 13912543 | 13912543 | PRJNA642647_P_NODE_2931_length_204_cov_3.239521_g2881_i0 | PRJNA642647 | 2931 | 204 | 3.239521 | 6.60862284 | Hymenochaetales | 139380 | Fungi | Fungi | 366 | 5.599999999999998e-97 | NTclustered | gi|2472531740|gb|OQ723339.1| | 50381 | g2881 | i0 | 99.502 | 98.3627450980392 | 201 | 1 | 99 | 0 | 1 | 201 | 569 | 369 | Trichaptum biforme voucher SVER-691133 large subunit ribosomal RNA gene, partial sequence | blastn | 20066 | 366 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hirschioporaceae | Pallidohirschioporus | Pallidohirschioporus biformis | |
| 18470263 | 18470263 | PRJNA642647_P_NODE_715_length_420_cov_8.668407_g666_i0 | PRJNA642647 | 715 | 420 | 8.668407 | 36.4073094 | Malassezia restricta | 76775 | Fungi | Fungi | 732 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g666 | i0 | 98.554 | 105.107142857143 | 415 | 5 | 99 | 1 | 3 | 417 | 1864 | 1451 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 44145 | 732 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19744853 | 19744853 | PRJNA642647_P_NODE_3676_length_185_cov_8.290541_g3626_i0 | PRJNA642647 | 3676 | 185 | 8.290541 | 15.33750085 | Wolfiporia cocos | 81056 | Fungi | Fungi | 326 | 8.430000000000001e-85 | NTclustered | gi|126508724|gb|EF397600.1| | 81056 | g3626 | i0 | 99.441 | 100.675675675676 | 179 | 1 | 97 | 0 | 4 | 182 | 2180 | 2002 | Poria cocos strain KANP No. 7233 28S ribosomal RNA gene, partial sequence | blastn | 18625 | 326 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phaeolaceae | Wolfiporia | Wolfiporia cocos | |
| 21020376 | 21020376 | PRJNA642647_P_NODE_2397_length_222_cov_4.989189_g2347_i0 | PRJNA642647 | 2397 | 222 | 4.989189 | 11.07599958 | Phellinidium pouzarii | 167371 | Fungi | Fungi | 372 | 1.33e-98 | NTclustered | gi|1569120656|gb|MK501618.1| | 167371 | g2347 | i0 | 97.273 | 104.342342342342 | 220 | 5 | 99 | 1 | 4 | 222 | 4252 | 4033 | Phellinidium pouzarii strain DSM 108285 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 23164 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Phellinidium | Phellinidium pouzarii | |
| 21560531 | 21560531 | PRJNA642647_P_NODE_5417_length_163_cov_2.420635_g5367_i0 | PRJNA642647 | 5417 | 163 | 2.420635 | 3.94563505 | Coltricia | 40425 | Fungi | Fungi | 95.3 | 2.23e-15 | NTclustered | gi|721633477|gb|KJ000222.1| | 1571649 | g5367 | i0 | 84 | 59.2147239263804 | 100 | 14 | 61 | 2 | 2 | 100 | 306 | 208 | Coltricia minor voucher Dai 13050 28S ribosomal RNA gene, partial sequence | blastn | 9652 | 95.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Coltricia | Coltricia minor | |
| 31389315 | 31389315 | PRJNA642647_P_NODE_5056_length_166_cov_2.914729_g5006_i0 | PRJNA642647 | 5056 | 166 | 2.914729 | 4.83845014 | Agaricales | 5338 | Fungi | Fungi | 49.7 | 4.56e-5 | NR | KAJ7601139.1 | 1033242 | g5006 | i0 | 84 | 1.35542168674699 | 25 | 4 | 45.2 | 0 | 164 | 90 | 495 | 519 | KAJ7601139.1 thiamine diphosphate-binding protein [Mycena floridula] | diamond | 225 | 50.1 | 0.992015968063872 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena floridula | |
| 32736580 | 32736580 | PRJNA642647_P_NODE_2520_length_218_cov_1.259669_g2470_i0 | PRJNA642647 | 2520 | 218 | 1.259669 | 2.74607842 | Phenoliferia sp. Uapishka_3 | 3038894 | Fungi | Fungi | 42.4 | 0.0364 | NR | KAK4701127.1 | 3038894 | g2470 | i0 | 52.2 | 0.63302752293578 | 46 | 17 | 63.3 | 1 | 197 | 60 | 234 | 274 | KAK4701127.1 hypothetical protein P7C70_g5108, partial [Phenoliferia sp. Uapishka_3] | diamond | 138 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Kriegeriales | Kriegeriaceae | Phenoliferia | Phenoliferia sp. Uapishka_3 |
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);;