contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1054617" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1451174 | 1451174 | PRJNA1054617_S_NODE_9182_length_190_cov_0.938776_g9094_i0 | PRJNA1054617 | 9182 | 190 | 0.938776 | 1.7836744 | Dichotomopilus funicola | 1934379 | Fungi | Fungi | 119 | 1.59e-22 | NTclustered | gi|2669712432|ref|XM_062784711.1| | 1934379 | g9094 | i0 | 82.963 | 3.82631578947368 | 135 | 19 | 70 | 2 | 14 | 146 | 423 | 555 | Dichotomopilus funicola ribosomal protein L18e/L15P (C8A04DRAFT_39780), partial mRNA | blastn | 727 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Dichotomopilus | Dichotomopilus funicola | |
| 4002951 | 4002951 | PRJNA1054617_S_NODE_13804_length_160_cov_1.179487_g13716_i0 | PRJNA1054617 | 13804 | 160 | 1.179487 | 1.8871792 | Xanthoria parietina | 107463 | Fungi | Fungi | 296 | 5.55e-76 | NTclustered | gi|394998614|gb|JQ301589.1| | 107463 | g13716 | i0 | 100 | 99.9625 | 160 | 0 | 100 | 0 | 1 | 160 | 231 | 72 | Xanthoria parietina isolate Gaya 8 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15994 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Teloschistales | Teloschistaceae | Xanthoria | Xanthoria parietina | |
| 6114420 | 6114420 | PRJNA1054617_S_NODE_8285_length_198_cov_0.987097_g8197_i0 | PRJNA1054617 | 8285 | 198 | 0.987097 | 1.95445206 | Malassezia | 55193 | Fungi | Fungi | 307 | 3.32e-79 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g8197 | i0 | 99.408 | 84.4292929292929 | 169 | 1 | 85 | 0 | 30 | 198 | 34 | 202 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 16717 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 6554420 | 6554420 | PRJNA1054617_S_NODE_11466_length_173_cov_1.769231_g11378_i0 | PRJNA1054617 | 11466 | 173 | 1.769231 | 3.06076963 | Beauveria bassiana | 176275 | Fungi | Fungi | 241 | 2.8900000000000007e-59 | NTclustered | gi|667651742|ref|XM_008599481.1| | 655819 | g11378 | i0 | 93.75 | 0.92485549132948 | 160 | 10 | 92 | 0 | 14 | 173 | 55 | 214 | Beauveria bassiana ARSEF 2860 uncharacterized protein (BBA_04384), partial mRNA | blastn | 160 | 241 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Beauveria | Beauveria bassiana | |
| 9104138 | 9104138 | PRJNA1054617_S_NODE_7008_length_212_cov_1.360947_g6920_i0 | PRJNA1054617 | 7008 | 212 | 1.360947 | 2.88520764 | Boeremia exigua | 749465 | Fungi | Fungi | 322 | 1.29e-83 | NTclustered | gi|2185355581|ref|XM_046143886.1| | 749465 | g6920 | i0 | 95.522 | 62.9858490566038 | 201 | 9 | 95 | 0 | 1 | 201 | 220 | 420 | Boeremia exigua cytochrome c oxidase-like protein subunit VIa (C7974DRAFT_415375), partial mRNA | blastn | 13353 | 322 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Boeremia | Boeremia exigua | |
| 11655068 | 11655068 | PRJNA1054617_S_NODE_5150_length_240_cov_1.634518_g5062_i0 | PRJNA1054617 | 5150 | 240 | 1.634518 | 3.9228432 | Malassezia restricta | 76775 | Fungi | Fungi | 189 | 1.58e-43 | NTclustered | gi|1546630011|ref|XM_027626666.1| | 76775 | g5062 | i0 | 100 | 0.808333333333333 | 102 | 0 | 43 | 0 | 1 | 102 | 1366 | 1467 | Malassezia restricta oligosaccharyltransferase complex subunit alpha (ribophorin I) (MRET_0039), partial mRNA | blastn | 194 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18028309 | 18028309 | PRJNA1054617_S_NODE_13675_length_160_cov_4.264957_g13587_i0 | PRJNA1054617 | 13675 | 160 | 4.264957 | 6.8239312 | Malassezia restricta | 76775 | Fungi | Fungi | 296 | 5.55e-76 | NTclustered | gi|1546632316|ref|XM_027627818.1| | 76775 | g13587 | i0 | 100 | 1 | 160 | 0 | 100 | 0 | 1 | 160 | 423 | 582 | Malassezia restricta U3 small nucleolar RNA-associated protein 23 (MRET_1191), partial mRNA | blastn | 160 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 20137710 | 20137710 | PRJNA1054617_S_NODE_9936_length_184_cov_0.978723_g9848_i0 | PRJNA1054617 | 9936 | 184 | 0.978723 | 1.80085032 | Dothideales | 5014 | Fungi | Fungi | 340 | 2.99e-89 | NTclustered | gi|1046863917|gb|KU254558.1| | 5423 | g9848 | i0 | 100 | 100 | 184 | 0 | 100 | 0 | 1 | 184 | 55 | 238 | Kabatiella microsticta strain 6/1-5 26S ribosomal RNA gene, partial sequence | blastn | 18400 | 340 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Kabatiella | Kabatiella microsticta | |
| 21853332 | 21853332 | PRJNA1054617_S_NODE_11118_length_175_cov_3.303030_g11030_i0 | PRJNA1054617 | 11118 | 175 | 3.30303 | 5.7803025 | Rhizopogon vinicolor | 80600 | Fungi | Fungi | 54.7 | 0.004 | NTclustered | gi|1693287358|ref|NC_042699.1| | 80600 | g11030 | i0 | 87.5 | 0.274285714285714 | 48 | 4 | 27 | 2 | 35 | 82 | 75201 | 75156 | Rhizopogon vinicolor mitochondrion, complete genome | blastn | 48 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Rhizopogonaceae | Rhizopogon | Rhizopogon vinicolor | |
| 23128789 | 23128789 | PRJNA1054617_S_NODE_11799_length_171_cov_1.078125_g11711_i0 | PRJNA1054617 | 11799 | 171 | 1.078125 | 1.84359375 | Malassezia restricta | 76775 | Fungi | Fungi | 311 | 2.14e-80 | NTclustered | gi|1546634690|ref|XM_027629004.1| | 76775 | g11711 | i0 | 99.415 | 2 | 171 | 1 | 100 | 0 | 1 | 171 | 2619 | 2449 | Malassezia restricta multifunctional beta-oxidation protein (MRET_2377), partial mRNA | blastn | 342 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 23963677 | 23963677 | PRJNA1054617_S_NODE_13139_length_163_cov_1.533333_g13051_i0 | PRJNA1054617 | 13139 | 163 | 1.533333 | 2.49933279 | Sordariomycetes | 147550 | Fungi | Fungi | 296 | 5.68e-76 | NTclustered | gi|9588015|gb|AF221624.1|AF221624 | 38032 | g13051 | i0 | 99.387 | 99.9509202453988 | 163 | 1 | 100 | 0 | 1 | 163 | 64 | 226 | Ophiostoma piliferum strain AU55-4 large subunit ribosomal RNA gene, partial sequence | blastn | 16292 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Ophiostoma | Ophiostoma piliferum |
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);;