contig_metadata
17 rows where bioproject = "PRJNA781453" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 762486 | 762486 | PRJNA781453_P_NODE_22341_length_309_cov_1.110169_g22226_i0 | PRJNA781453 | 22341 | 309 | 1.110169 | 3.43042221 | Malassezia restricta | 76775 | Fungi | Fungi | 571 | 1.7899999999999995e-158 | NTclustered | gi|1546631275|ref|XM_027627298.1| | 76775 | g22226 | i0 | 100 | 1 | 309 | 0 | 100 | 0 | 1 | 309 | 2463 | 2771 | Malassezia restricta leucyl-tRNA synthetase (MRET_0671), partial mRNA | blastn | 309 | 571 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3313408 | 3313408 | PRJNA781453_P_NODE_1163_length_1241_cov_1.591610_g1114_i0 | PRJNA781453 | 1163 | 1241 | 1.59161 | 19.7518801 | Malassezia restricta | 76775 | Fungi | Fungi | 857 | 0 | NTclustered | gi|1546637129|ref|XM_027630207.1| | 76775 | g1114 | i0 | 93.151 | 0.991941982272361 | 584 | 40 | 47 | 0 | 658 | 1241 | 1152 | 569 | Malassezia restricta putative methyltransferase (MRET_3580), partial mRNA | blastn | 1231 | 857 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 3313411 | 3313411 | PRJNA781453_P_NODE_11763_length_433_cov_0.988889_g11649_i0 | PRJNA781453 | 11763 | 433 | 0.988889 | 4.28188937 | Malassezia restricta | 76775 | Fungi | Fungi | 791 | 0 | NTclustered | gi|1546631854|ref|XM_027627587.1| | 76775 | g11649 | i0 | 99.54 | 10.0762124711316 | 435 | 0 | 100 | 2 | 1 | 433 | 285 | 719 | Malassezia restricta ATP-dependent RNA helicase DDX18/HAS1 (MRET_0960), partial mRNA | blastn | 4363 | 791 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 10966260 | 10966260 | PRJNA781453_P_NODE_11749_length_433_cov_1.283333_g11635_i0 | PRJNA781453 | 11749 | 433 | 1.283333 | 5.55683189 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 270 | 5.61e-81 | NR | KAE9397860.1 | 1447944 | g11635 | i0 | 100 | 1.99538106235566 | 144 | 0 | 99.8 | 0 | 1 | 432 | 1074 | 1217 | KAE9397860.1 pre-mRNA splicing factor [Gymnopus androsaceus JB14] | diamond | 864 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 12242087 | 12242087 | PRJNA781453_P_NODE_22390_length_308_cov_2.293617_g22275_i0 | PRJNA781453 | 22390 | 308 | 2.293617 | 7.06434036 | Papiliotrema terrestris | 425109 | Fungi | Fungi | 453 | 6.75e-123 | NTclustered | gi|1758753257|emb|LR697097.1| | 425109 | g22275 | i0 | 93.182 | 149.798701298701 | 308 | 21 | 100 | 0 | 1 | 308 | 2145 | 1838 | Papiliotrema terrestris partial 28S rRNA gene | blastn | 46138 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Rhynchogastremaceae | Papiliotrema | Papiliotrema terrestris | |
| 14791062 | 14791062 | PRJNA781453_P_NODE_2292_length_949_cov_2.569635_g2215_i0 | PRJNA781453 | 2292 | 949 | 2.569635 | 24.38583615 | Sterigmatomyces sp. | 1972484 | Fungi | Fungi | 603 | 2.1099999999999993e-167 | NTclustered | gi|1894457345|gb|MT755636.1| | 1972484 | g2215 | i0 | 89.605 | 13.913593256059 | 481 | 40 | 59 | 8 | 475 | 949 | 8634 | 8158 | Sterigmatomyces sp. mitochondrion, complete genome | blastn | 13204 | 603 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricostilbomycetes | Agaricostilbales | Agaricostilbaceae | Sterigmatomyces | Sterigmatomyces sp. | |
| 16064574 | 16064574 | PRJNA781453_P_NODE_10573_length_458_cov_4.150649_g10459_i0 | PRJNA781453 | 10573 | 458 | 4.150649 | 19.00997242 | Malassezia restricta | 76775 | Fungi | Fungi | 846 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g10459 | i0 | 100 | 106.491266375546 | 458 | 0 | 100 | 0 | 1 | 458 | 1477 | 1934 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 48773 | 846 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 17341108 | 17341108 | PRJNA781453_P_NODE_36854_length_245_cov_3.133721_g36739_i0 | PRJNA781453 | 36854 | 245 | 3.133721 | 7.67761645 | Stereum hirsutum | 40492 | Fungi | Fungi | 185 | 2.09e-42 | NTclustered | gi|618818313|ref|XM_007311670.1| | 721885 | g36739 | i0 | 82.692 | 2.95510204081633 | 208 | 36 | 85 | 0 | 3 | 210 | 1582 | 1789 | Stereum hirsutum FP-91666 SS1 UTP-glucose-1-phosphate uridylyltransferase (STEHIDRAFT_116737), partial mRNA | blastn | 724 | 185 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Stereum | Stereum hirsutum | |
| 18614657 | 18614657 | PRJNA781453_P_NODE_5435_length_644_cov_1.861646_g5328_i0 | PRJNA781453 | 5435 | 644 | 1.861646 | 11.98900024 | Desarmillaria tabescens | 1929756 | Fungi | Fungi | 636 | 1.39e-177 | NTclustered | gi|2607576442|ref|XM_060477136.1| | 1929756 | g5328 | i0 | 84.52 | 60.3664596273292 | 646 | 96 | 100 | 3 | 1 | 644 | 1282 | 639 | Desarmillaria tabescens UTP-glucose-1-phosphate uridylyltransferase (EV420DRAFT_1640717), partial mRNA | blastn | 38876 | 636 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Desarmillaria | Desarmillaria tabescens | |
| 22440154 | 22440154 | PRJNA781453_P_NODE_33498_length_249_cov_1.636364_g33383_i0 | PRJNA781453 | 33498 | 249 | 1.636364 | 4.07454636 | Malassezia restricta | 76775 | Fungi | Fungi | 388 | 1.51e-103 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g33383 | i0 | 94.8 | 104.012048192771 | 250 | 11 | 99 | 1 | 2 | 249 | 1757 | 1508 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 25899 | 388 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 23715489 | 23715489 | PRJNA781453_P_NODE_29199_length_266_cov_1.196891_g29084_i0 | PRJNA781453 | 29199 | 266 | 1.196891 | 3.18373006 | Malassezia restricta | 76775 | Fungi | Fungi | 492 | 1.2099999999999999e-134 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g29084 | i0 | 100 | 24.1015037593985 | 266 | 0 | 100 | 0 | 1 | 266 | 588 | 323 | Malassezia restricta mitochondrion, complete genome | blastn | 6411 | 492 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 28032901 | 28032901 | PRJNA781453_P_NODE_9805_length_477_cov_1.633663_g9691_i0 | PRJNA781453 | 9805 | 477 | 1.633663 | 7.79257251 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 276 | 5.209999999999999e-87 | NR | KAE9398844.1 | 1447944 | g9691 | i0 | 90.6 | 1 | 159 | 14 | 99.4 | 1 | 2 | 475 | 220 | 378 | KAE9398844.1 hypothetical protein BT96DRAFT_920598 [Gymnopus androsaceus JB14] | diamond | 477 | 276 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 29201138 | 29201138 | PRJNA781453_P_NODE_13309_length_403_cov_2.393939_g13195_i0 | PRJNA781453 | 13309 | 403 | 2.393939 | 9.64757417 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 277 | 1.59e-90 | NR | KAE9409971.1 | 1447944 | g13195 | i0 | 100 | 0.997518610421836 | 134 | 0 | 99.8 | 0 | 402 | 1 | 173 | 306 | KAE9409971.1 hypothetical protein BT96DRAFT_462336 [Gymnopus androsaceus JB14] | diamond | 402 | 277 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 29390562 | 29390562 | PRJNA781453_P_NODE_27329_length_276_cov_1.630542_g27214_i0 | PRJNA781453 | 27329 | 276 | 1.630542 | 4.50029592 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 120 | 2.54e-30 | NR | KAE9409971.1 | 1447944 | g27214 | i0 | 100 | 0.554347826086957 | 51 | 0 | 55.4 | 0 | 2 | 154 | 102 | 152 | KAE9409971.1 hypothetical protein BT96DRAFT_462336 [Gymnopus androsaceus JB14] | diamond | 153 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 29611144 | 29611144 | PRJNA781453_P_NODE_28110_length_272_cov_1.115578_g27995_i0 | PRJNA781453 | 28110 | 272 | 1.115578 | 3.03437216 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 172 | 1.26e-52 | NR | KAE9391144.1 | 1447944 | g27995 | i0 | 100 | 0.992647058823529 | 90 | 0 | 99.3 | 0 | 272 | 3 | 92 | 181 | KAE9391144.1 hypothetical protein BT96DRAFT_959616 [Gymnopus androsaceus JB14] | diamond | 270 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 30243290 | 30243290 | PRJNA781453_P_NODE_15292_length_374_cov_1.750831_g15178_i0 | PRJNA781453 | 15292 | 374 | 1.750831 | 6.54810794 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 114 | 1.36e-28 | NR | XP_025596234.1 | 58919 | g15178 | i0 | 52.1 | 1.77272727272727 | 119 | 56 | 95.5 | 1 | 373 | 17 | 106 | 223 | XP_025596234.1 hypothetical protein FA09DRAFT_340529 [Tilletiopsis washingtonensis] | diamond | 663 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 31602362 | 31602362 | PRJNA781453_P_NODE_19496_length_331_cov_1.445736_g19381_i0 | PRJNA781453 | 19496 | 331 | 1.445736 | 4.78538616 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 218 | 4.08e-63 | NR | KAE9397860.1 | 1447944 | g19381 | i0 | 100 | 62.2205438066465 | 107 | 0 | 97 | 0 | 9 | 329 | 955 | 1061 | KAE9397860.1 pre-mRNA splicing factor [Gymnopus androsaceus JB14] | diamond | 20595 | 218 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus |
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);;