contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA937226" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3462735 | 3462735 | PRJNA937226_S_NODE_10863_length_236_cov_1.390374_g10736_i0 | PRJNA937226 | 10863 | 236 | 1.390374 | 3.28128264 | Cystobasidium minutum | 29899 | Fungi | Fungi | 182 | 2.59e-41 | NTclustered | gi|2781596162|ref|XM_066969219.1| | 1397322 | g10736 | i0 | 80.769 | 0.991525423728814 | 234 | 43 | 99 | 2 | 4 | 236 | 856 | 624 | Cystobasidium minutum MCA 4210 uncharacterized protein (P389DRAFT_37789), mRNA | blastn | 234 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium minutum | |
| 5084104 | 5084104 | PRJNA937226_S_NODE_7624_length_266_cov_14.073733_g7497_i0 | PRJNA937226 | 7624 | 266 | 14.073733 | 37.43612978 | Malassezia | 55193 | Fungi | Fungi | 475 | 1.2199999999999997e-129 | NTclustered | gi|1473096414|gb|MH294248.1| | 76773 | g7497 | i0 | 98.872 | 99.9887218045113 | 266 | 3 | 100 | 0 | 1 | 266 | 290 | 25 | Malassezia globosa isolate GDMUZJ2015344 large subunit ribosomal RNA gene, partial sequence | blastn | 26597 | 475 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 7290012 | 7290012 | PRJNA937226_S_NODE_12726_length_222_cov_1.502890_g12599_i0 | PRJNA937226 | 12726 | 222 | 1.50289 | 3.3364158 | Peniophora lycii | 154539 | Fungi | Fungi | 237 | 5.07e-58 | NTclustered | gi|2192917331|ref|NC_060425.1| | 154539 | g12599 | i0 | 89.637 | 7.77027027027027 | 193 | 11 | 85 | 6 | 28 | 215 | 7674 | 7862 | Peniophora lycii mitochondrion, complete sequence | blastn | 1725 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora lycii | |
| 7290046 | 7290046 | PRJNA937226_S_NODE_19666_length_187_cov_1.130435_g19539_i0 | PRJNA937226 | 19666 | 187 | 1.130435 | 2.11391345 | Kwoniella heveanensis | 89924 | Fungi | Fungi | 54.7 | 0.004 | NTclustered | gi|2678472070|gb|CP144514.1| | 1296119 | g19539 | i0 | 100 | 0.155080213903743 | 29 | 0 | 16 | 0 | 101 | 129 | 1955636 | 1955664 | Kwoniella heveanensis CBS 569 chromosome 1 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella heveanensis | |
| 7290099 | 7290099 | PRJNA937226_S_NODE_4026_length_329_cov_4.650000_g3899_i0 | PRJNA937226 | 4026 | 329 | 4.65 | 15.2985 | Wolfiporia cocos | 81056 | Fungi | Fungi | 514 | 3.29e-141 | NTclustered | gi|126508724|gb|EF397600.1| | 81056 | g3899 | i0 | 94.833 | 107.039513677812 | 329 | 17 | 100 | 0 | 1 | 329 | 1915 | 1587 | Poria cocos strain KANP No. 7233 28S ribosomal RNA gene, partial sequence | blastn | 35216 | 514 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phaeolaceae | Wolfiporia | Wolfiporia cocos | |
| 8564899 | 8564899 | PRJNA937226_S_NODE_23107_length_175_cov_1.238095_g22980_i0 | PRJNA937226 | 23107 | 175 | 1.238095 | 2.16666625 | Malassezia globosa | 76773 | Fungi | Fungi | 121 | 3.98e-23 | NTclustered | gi|164657505|ref|XM_001729827.1| | 425265 | g22980 | i0 | 100 | 0.731428571428571 | 65 | 0 | 37 | 0 | 111 | 175 | 1599 | 1535 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2865), partial mRNA | blastn | 128 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 9839857 | 9839857 | PRJNA937226_S_NODE_13148_length_219_cov_2.447059_g13021_i0 | PRJNA937226 | 13148 | 219 | 2.447059 | 5.35905921 | Hericium alpestre | 135208 | Fungi | Fungi | 56.5 | 0.001 | NTclustered | gi|2489641794|ref|NC_073556.1| | 135208 | g13021 | i0 | 96.97 | 0.776255707762557 | 33 | 1 | 15 | 0 | 59 | 91 | 27974 | 27942 | Hericium alpestre mitochondrion, complete genome | blastn | 170 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Hericiaceae | Hericium | Hericium alpestre | |
| 9839905 | 9839905 | PRJNA937226_S_NODE_25988_length_167_cov_1.762712_g25861_i0 | PRJNA937226 | 25988 | 167 | 1.762712 | 2.94372904 | Cryptococcus amylolentus | 104669 | Fungi | Fungi | 209 | 7.85e-50 | NTclustered | gi|1101799820|ref|XM_019142870.1| | 1295533 | g25861 | i0 | 89.634 | 19.9820359281437 | 164 | 17 | 98 | 0 | 4 | 167 | 628 | 465 | Cryptococcus amylolentus CBS 6039 peptidyl-prolyl cis-trans isomerase, variant 1 (L202_08030), mRNA | blastn | 3337 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus amylolentus | |
| 12391013 | 12391013 | PRJNA937226_S_NODE_14090_length_213_cov_3.487805_g13963_i0 | PRJNA937226 | 14090 | 213 | 3.487805 | 7.42902465 | Malassezia globosa | 76773 | Fungi | Fungi | 270 | 4.75e-68 | NTclustered | gi|164657270|ref|XM_001729710.1| | 425265 | g13963 | i0 | 99.329 | 3.76995305164319 | 149 | 1 | 70 | 0 | 1 | 149 | 1274 | 1422 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_3306), partial mRNA | blastn | 803 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 12735157 | 12735157 | PRJNA937226_S_NODE_14910_length_208_cov_20.075472_g14783_i0 | PRJNA937226 | 14910 | 208 | 20.075472 | 41.75698176 | Opisthokonta | 33154 | Fungi | Fungi | 385 | 1.58e-102 | NTclustered | gi|126508724|gb|EF397600.1| | 81056 | g14783 | i0 | 100 | 105.995192307692 | 208 | 0 | 100 | 0 | 1 | 208 | 2679 | 2472 | Poria cocos strain KANP No. 7233 28S ribosomal RNA gene, partial sequence | blastn | 22047 | 385 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phaeolaceae | Wolfiporia | Wolfiporia cocos | |
| 13665446 | 13665446 | PRJNA937226_S_NODE_10851_length_236_cov_2.187166_g10724_i0 | PRJNA937226 | 10851 | 236 | 2.187166 | 5.16171176 | Cystobasidium laryngis | 105772 | Fungi | Fungi | 368 | 1.85e-97 | NTclustered | gi|1358186635|gb|MH047192.1| | 105772 | g10724 | i0 | 96.818 | 110.432203389831 | 220 | 7 | 93 | 0 | 17 | 236 | 4406 | 4187 | Cystobasidium laryngis 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 | 26062 | 368 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cystobasidiales | Cystobasidiaceae | Cystobasidium | Cystobasidium laryngis | |
| 17490152 | 17490152 | PRJNA937226_S_NODE_11454_length_231_cov_3.862637_g11327_i0 | PRJNA937226 | 11454 | 231 | 3.862637 | 8.92269147 | Malassezia restricta | 76775 | Fungi | Fungi | 427 | 2.9399999999999998e-115 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g11327 | i0 | 100 | 33.1515151515151 | 231 | 0 | 100 | 0 | 1 | 231 | 1607 | 1837 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 7658 | 427 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17490226 | 17490226 | PRJNA937226_S_NODE_30534_length_155_cov_2.122642_g30407_i0 | PRJNA937226 | 30534 | 155 | 2.122642 | 3.2900951 | Malassezia restricta | 76775 | Fungi | Fungi | 52.8 | 0.013 | NTclustered | gi|1546637575|ref|XM_027630429.1| | 76775 | g30407 | i0 | 100 | 0.180645161290323 | 28 | 0 | 18 | 0 | 1 | 28 | 321 | 348 | Malassezia restricta F-type H+-transporting ATPase subunit f (MRET_3802), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18763565 | 18763565 | PRJNA937226_S_NODE_14155_length_213_cov_1.585366_g14028_i0 | PRJNA937226 | 14155 | 213 | 1.585366 | 3.37682958 | Malassezia globosa | 76773 | Fungi | Fungi | 394 | 2.7e-105 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g14028 | i0 | 100 | 47.075117370892 | 213 | 0 | 100 | 0 | 1 | 213 | 2897 | 2685 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 10027 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 20038547 | 20038547 | PRJNA937226_S_NODE_13136_length_219_cov_2.935294_g13009_i0 | PRJNA937226 | 13136 | 219 | 2.935294 | 6.42829386 | Malassezia globosa | 76773 | Fungi | Fungi | 357 | 3.67e-94 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g13009 | i0 | 96.729 | 45.6438356164384 | 214 | 7 | 98 | 0 | 1 | 214 | 30060 | 29847 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 9996 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 20038643 | 20038643 | PRJNA937226_S_NODE_8816_length_254_cov_1.770732_g8689_i0 | PRJNA937226 | 8816 | 254 | 1.770732 | 4.49765928 | Malassezia restricta | 76775 | Fungi | Fungi | 331 | 2.6500000000000002e-86 | NTclustered | gi|1546632462|ref|XM_027627891.1| | 76775 | g8689 | i0 | 97.917 | 0.755905511811024 | 192 | 3 | 75 | 1 | 64 | 254 | 1917 | 1726 | Malassezia restricta heat shock 70kDa protein 1/2/6/8 (MRET_1264), partial mRNA | blastn | 192 | 331 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 21658032 | 21658032 | PRJNA937226_S_NODE_22957_length_175_cov_3.222222_g22830_i0 | PRJNA937226 | 22957 | 175 | 3.222222 | 5.6388885 | Sistotremastraceae | 3402574 | Fungi | Fungi | 324 | 2.83e-84 | NTclustered | gi|1796957026|gb|MN937561.1| | 1290441 | g22830 | i0 | 100 | 100.331428571429 | 175 | 0 | 100 | 0 | 1 | 175 | 892 | 718 | Sistotremastrum guttuliferum voucher KHL12297 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 | 17558 | 324 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sistotremastrales | Sistotremastraceae | Sistotremastrum | Sistotremastrum guttuliferum | |
| 23864198 | 23864198 | PRJNA937226_S_NODE_19839_length_186_cov_2.613139_g19712_i0 | PRJNA937226 | 19839 | 186 | 2.613139 | 4.86043854 | Malassezia restricta | 76775 | Fungi | Fungi | 254 | 4.06e-63 | NTclustered | gi|1546630961|ref|XM_027627141.1| | 76775 | g19712 | i0 | 100 | 0.736559139784946 | 137 | 0 | 74 | 0 | 1 | 137 | 22 | 158 | Malassezia restricta F-type H+-transporting ATPase subunit k (MRET_0514), partial mRNA | blastn | 137 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 24207354 | 24207354 | PRJNA937226_S_NODE_16279_length_202_cov_1.326797_g16152_i0 | PRJNA937226 | 16279 | 202 | 1.326797 | 2.68012994 | Hericium | 40459 | Fungi | Fungi | 54.7 | 0.005 | NTclustered | gi|2289434161|ref|NC_065786.1| | 91752 | g16152 | i0 | 96.875 | 0.316831683168317 | 32 | 1 | 16 | 0 | 7 | 38 | 70706 | 70675 | Hericium erinaceus strain HE 0021 mitochondrion, complete genome | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Hericiaceae | Hericium | Hericium erinaceus |
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);;