contig_metadata
14 rows where bioproject = "PRJNA289590" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8025752 | 8025752 | PRJNA289590_P_NODE_19087_length_205_cov_0.878205_g18863_i0 | PRJNA289590 | 19087 | 205 | 0.878205 | 1.80032025 | Armillaria mellea | 47429 | Fungi | Fungi | 357 | 3.3899999999999996e-94 | NTclustered | gi|239740618|gb|FJ875693.1| | 47429 | g18863 | i0 | 98.049 | 102.053658536585 | 205 | 4 | 100 | 0 | 1 | 205 | 1454 | 1658 | Armillaria mellea strain CMW 3961 large subunit ribosomal RNA gene, partial sequence | blastn | 20921 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Armillaria | Armillaria mellea | |
| 9987584 | 9987584 | PRJNA289590_P_NODE_30828_length_162_cov_1.690265_g30604_i0 | PRJNA289590 | 30828 | 162 | 1.690265 | 2.7382293 | Agaricomycetes | 155619 | Fungi | Fungi | 298 | 1.57e-76 | NTclustered | gi|2576441|gb|AF026587.1|AF026587 | 40491 | g30604 | i0 | 100 | 99.4197530864197 | 161 | 0 | 99 | 0 | 2 | 162 | 1271 | 1431 | Stereum annosum 18S ribosomal RNA gene, partial sequence | blastn | 16106 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Xylobolus | Xylobolus annosus | |
| 9987595 | 9987595 | PRJNA289590_P_NODE_5688_length_410_cov_2.072022_g5464_i0 | PRJNA289590 | 5688 | 410 | 2.072022 | 8.4952902 | Microbotryomycetes | 162481 | Fungi | Fungi | 676 | 0 | NTclustered | gi|1358186634|gb|MH047191.1| | 5278 | g5464 | i0 | 96.79 | 103.226829268293 | 405 | 13 | 99 | 0 | 3 | 407 | 3718 | 4122 | Leucosporidium scottii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 42323 | 676 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium scottii | |
| 11850903 | 11850903 | PRJNA289590_P_NODE_10050_length_292_cov_1.497942_g9826_i0 | PRJNA289590 | 10050 | 292 | 1.497942 | 4.37399064 | Fungi | 4751 | Fungi | Fungi | 146 | 2.66e-41 | NR | KAH9993630.1 | 517384 | g9826 | i0 | 73 | 7.97260273972603 | 89 | 24 | 91.4 | 0 | 290 | 24 | 23 | 111 | KAH9993630.1 guanine nucleotide binding protein beta subunit [Russula vinacea] | diamond | 2328 | 147 | 0.993197278911565 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Russula | Russula vinacea | |
| 11851269 | 11851269 | PRJNA289590_P_NODE_26070_length_169_cov_0.866667_g25846_i0 | PRJNA289590 | 26070 | 169 | 0.866667 | 1.46466723 | Filobasidium floriforme | 5210 | Fungi | Fungi | 130 | 6.34e-26 | NTclustered | gi|2185536376|ref|XM_046180702.1| | 5210 | g25846 | i0 | 82.119 | 4.36094674556213 | 151 | 27 | 89 | 0 | 19 | 169 | 306 | 456 | Filobasidium floriforme ribosomal protein L3-domain-containing protein (HD553DRAFT_317005), mRNA | blastn | 737 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 12537944 | 12537944 | PRJNA289590_P_NODE_25690_length_170_cov_1.173554_g25466_i0 | PRJNA289590 | 25690 | 170 | 1.173554 | 1.9950418 | Fungi | 4751 | Fungi | Fungi | 309 | 7.64e-80 | NTclustered | gi|2724480650|gb|PP467489.1| | 5315 | g25466 | i0 | 99.412 | 105.994117647059 | 170 | 1 | 100 | 0 | 1 | 170 | 6512 | 6343 | Ganoderma lucidum strain Red Reishi No.6 intergenic spacer 2, partial sequence; 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S large subunit ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, intergenic spacer 2, 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S large subunit ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, and intergenic spacer 2, complete sequence; and 18S small subunit ribosomal RNA gene, partial sequence | blastn | 18019 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma lucidum | |
| 13812757 | 13812757 | PRJNA289590_P_NODE_16391_length_222_cov_3.543353_g16167_i0 | PRJNA289590 | 16391 | 222 | 3.543353 | 7.86624366 | Fungi | 4751 | Fungi | Fungi | 405 | 1.31e-108 | NTclustered | gi|2576865988|gb|OR548146.1| | 133752 | g16167 | i0 | 99.55 | 100 | 222 | 1 | 100 | 0 | 1 | 222 | 345 | 124 | Puccinia rufipes voucher HGUP21176 large subunit ribosomal RNA gene, partial sequence | blastn | 22200 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia rufipes | |
| 14401423 | 14401423 | PRJNA289590_P_NODE_18632_length_207_cov_1.689873_g18408_i0 | PRJNA289590 | 18632 | 207 | 1.689873 | 3.49803711 | Xylobolus sp. 101 OA-2013 | 1321930 | Fungi | Fungi | 333 | 5.779999999999999e-87 | NTclustered | gi|480327092|gb|JX535115.1| | 1321930 | g18408 | i0 | 96.078 | 103.285024154589 | 204 | 8 | 99 | 0 | 1 | 204 | 1857 | 2060 | Xylobolus sp. 101 OA-2013 large subunit ribosomal RNA gene, partial sequence | blastn | 21380 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Xylobolus | Xylobolus sp. 101 OA-2013 | |
| 19498205 | 19498205 | PRJNA289590_P_NODE_11056_length_276_cov_5.770925_g10832_i0 | PRJNA289590 | 11056 | 276 | 5.770925 | 15.927753 | Rhodotorula glutinis | 5535 | Fungi | Fungi | 494 | 3.51e-135 | NTclustered | gi|225134685|gb|FJ345357.1| | 5535 | g10832 | i0 | 98.913 | 73.6449275362319 | 276 | 3 | 100 | 0 | 1 | 276 | 3656 | 3931 | Rhodotorula glutinis strain ATCC 16726 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 20326 | 494 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula glutinis | |
| 19498428 | 19498428 | PRJNA289590_P_NODE_21156_length_193_cov_1.055556_g20932_i0 | PRJNA289590 | 21156 | 193 | 1.055556 | 2.03722308 | Rhodotorula glutinis | 5535 | Fungi | Fungi | 342 | 8.819999999999999e-90 | NTclustered | gi|225134685|gb|FJ345357.1| | 5535 | g20932 | i0 | 98.462 | 103.279792746114 | 195 | 1 | 100 | 1 | 1 | 193 | 2191 | 2385 | Rhodotorula glutinis strain ATCC 16726 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 19933 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula glutinis | |
| 20185443 | 20185443 | PRJNA289590_P_NODE_19896_length_200_cov_1.331126_g19672_i0 | PRJNA289590 | 19896 | 200 | 1.331126 | 2.662252 | Rhodotorula | 5533 | Fungi | Fungi | 370 | 4.22e-98 | NTclustered | gi|1102645436|gb|KY109006.1| | 5288 | g19672 | i0 | 100 | 100 | 200 | 0 | 100 | 0 | 1 | 200 | 236 | 37 | Rhodotorula diobovata culture CBS:11071 large subunit ribosomal RNA gene, partial sequence | blastn | 20000 | 370 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula diobovata | |
| 20774136 | 20774136 | PRJNA289590_P_NODE_27577_length_167_cov_0.881356_g27353_i0 | PRJNA289590 | 27577 | 167 | 0.881356 | 1.47186452 | Malassezia restricta | 76775 | Fungi | Fungi | 244 | 2.15e-60 | NTclustered | gi|1546634876|ref|XM_027629097.1| | 76775 | g27353 | i0 | 93.333 | 0.988023952095808 | 165 | 11 | 99 | 0 | 3 | 167 | 939 | 775 | Malassezia restricta dynamin-binding protein (MRET_2470), partial mRNA | blastn | 165 | 244 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24598731 | 24598731 | PRJNA289590_P_NODE_26080_length_169_cov_0.866667_g25856_i0 | PRJNA289590 | 26080 | 169 | 0.866667 | 1.46466723 | Malassezia arunalokei | 1514897 | Fungi | Fungi | 294 | 2.12e-75 | NTclustered | gi|2692937071|ref|NC_086476.1| | 1514897 | g25856 | i0 | 98.225 | 7.46745562130178 | 169 | 2 | 100 | 1 | 1 | 169 | 15583 | 15750 | Malassezia arunalokei culture CBS:13387 strain CBS13387 mitochondrion, complete genome | blastn | 1262 | 294 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia arunalokei | |
| 32729384 | 32729384 | PRJNA289590_P_NODE_26120_length_169_cov_0.866667_g25896_i0 | PRJNA289590 | 26120 | 169 | 0.866667 | 1.46466723 | Fomitiporia mediterranea MF3/22 | 694068 | Fungi | Fungi | 75.1 | 5.03e-14 | NR | XP_007265867.1 | 694068 | g25896 | i0 | 79.6 | 0.869822485207101 | 49 | 8 | 83.4 | 1 | 143 | 3 | 44 | 92 | XP_007265867.1 uncharacterized protein FOMMEDRAFT_167489 [Fomitiporia mediterranea MF3/22] | diamond | 147 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Fomitiporia | Fomitiporia mediterranea |
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);;