contig_metadata
10 rows where analysis = "blastn", 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 | |
| 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 |
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);;