contig_metadata
10 rows where bioproject = "PRJNA690234", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5007192 | 5007192 | PRJNA690234_P_NODE_32744_length_227_cov_4.811688_g32377_i0 | PRJNA690234 | 32744 | 227 | 4.811688 | 10.92253176 | Malassezia | 55193 | Fungi | Fungi | 420 | 4.81e-113 | NTclustered | gi|19908237|gb|AY083223.1| | 55194 | g32377 | i0 | 100 | 100 | 227 | 0 | 100 | 0 | 1 | 227 | 811 | 1037 | Malassezia furfur strain NCPF 3349 18S ribosomal RNA gene, partial sequence | blastn | 22700 | 420 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 9598525 | 9598525 | PRJNA690234_P_NODE_15808_length_320_cov_1.028340_g15441_i0 | PRJNA690234 | 15808 | 320 | 1.02834 | 3.290688 | Psilocybe cubensis | 181762 | Fungi | Fungi | 58.4 | 6.45e-4 | NTclustered | gi|2234857607|ref|XM_047891812.1| | 181762 | g15441 | i0 | 97.059 | 0.10625 | 34 | 1 | 11 | 0 | 103 | 136 | 749 | 782 | Psilocybe cubensis U1 small nuclear ribonucleoprotein 70 kDa-like protein (JR316_0006063), partial mRNA | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Strophariaceae | Psilocybe | Psilocybe cubensis | |
| 10874116 | 10874116 | PRJNA690234_P_NODE_19289_length_288_cov_4.325581_g18922_i0 | PRJNA690234 | 19289 | 288 | 4.325581 | 12.45767328 | Malassezia japonica | 223818 | Fungi | Fungi | 438 | 1.7499999999999995e-118 | NTclustered | gi|1321659535|gb|KY911090.1| | 223818 | g18922 | i0 | 94.118 | 66.5208333333333 | 289 | 16 | 100 | 1 | 1 | 288 | 4863 | 5151 | Malassezia japonica mitochondrion, complete genome | blastn | 19158 | 438 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia japonica | |
| 13423811 | 13423811 | PRJNA690234_P_NODE_14231_length_336_cov_2.593156_g13864_i0 | PRJNA690234 | 14231 | 336 | 2.593156 | 8.71300416 | Malassezia restricta | 76775 | Fungi | Fungi | 455 | 2.0700000000000003e-123 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g13864 | i0 | 91.892 | 89.0148809523809 | 333 | 16 | 99 | 7 | 4 | 336 | 3299 | 2978 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 29909 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 14698830 | 14698830 | PRJNA690234_P_NODE_11172_length_380_cov_3.957655_g10806_i0 | PRJNA690234 | 11172 | 380 | 3.957655 | 15.039089 | Malassezia restricta | 76775 | Fungi | Fungi | 699 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g10806 | i0 | 100 | 103.226315789474 | 378 | 0 | 99 | 0 | 3 | 380 | 1846 | 1469 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 39226 | 699 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 19797251 | 19797251 | PRJNA690234_P_NODE_29576_length_245_cov_1.709302_g29209_i0 | PRJNA690234 | 29576 | 245 | 1.709302 | 4.1877899 | Kondoa malvinella | 36055 | Fungi | Fungi | 342 | 1.17e-89 | NTclustered | gi|1393510851|ref|NG_057733.1| | 36055 | g29209 | i0 | 100 | 145.134693877551 | 185 | 0 | 76 | 0 | 61 | 245 | 1441 | 1257 | Kondoa malvinella CBS 6082 28S rRNA gene, partial sequence; from TYPE material | blastn | 35558 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricostilbomycetes | Agaricostilbales | Kondoaceae | Kondoa | Kondoa malvinella | |
| 23623168 | 23623168 | PRJNA690234_P_NODE_29999_length_245_cov_0.906977_g29632_i0 | PRJNA690234 | 29999 | 245 | 0.906977 | 2.22209365 | Leucosporidium sp. AY30 | 662878 | Fungi | Fungi | 364 | 2.5e-96 | NTclustered | gi|254927417|gb|GQ336996.1| | 662878 | g29632 | i0 | 93.469 | 78.0938775510204 | 245 | 16 | 100 | 0 | 1 | 245 | 5473 | 5717 | Leucosporidium sp. AY30 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 19133 | 364 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium sp. AY30 | |
| 24130784 | 24130784 | PRJNA690234_P_NODE_7759_length_461_cov_4.569588_g7393_i0 | PRJNA690234 | 7759 | 461 | 4.569588 | 21.06580068 | Basidiomycota | 5204 | Fungi | Fungi | 728 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g7393 | i0 | 95.228 | 106.101952277657 | 461 | 21 | 100 | 1 | 1 | 461 | 1918 | 1459 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 48913 | 728 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 31642325 | 31642325 | PRJNA690234_P_NODE_3096_length_748_cov_2.681481_g2759_i0 | PRJNA690234 | 3096 | 748 | 2.681481 | 20.05747788 | Fungi | 4751 | Fungi | Fungi | 98.6 | 2.13e-19 | NR | KDE07049.1 | 683840 | g2759 | i0 | 36.7 | 1.8168449197861 | 147 | 85 | 56.1 | 3 | 424 | 5 | 522 | 667 | KDE07049.1 hypothetical protein MVLG_02625 [Microbotryum lychnidis-dioicae p1A1 Lamole] | diamond | 1359 | 98.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Microbotryales | Microbotryaceae | Microbotryum | Microbotryum lychnidis-dioicae | |
| 32243924 | 32243924 | PRJNA690234_P_NODE_24838_length_254_cov_1.149171_g24471_i0 | PRJNA690234 | 24838 | 254 | 1.149171 | 2.91889434 | Eukaryota | 2759 | Fungi | Fungi | 74.3 | 3.17e-13 | NR | KZO91950.1 | 1330018 | g24471 | i0 | 43.7 | 3.07086614173228 | 87 | 44 | 96.9 | 2 | 3 | 248 | 108 | 194 | KZO91950.1 P-loop containing nucleoside triphosphate hydrolase protein [Calocera viscosa TUFC12733] | diamond | 780 | 74.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Dacrymycetes | Dacrymycetales | Dacrymycetaceae | Calocera | Calocera viscosa |
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);;