contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1054617" and tax_phylum = "Ascomycota"
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 | |
| 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 | |
| 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 | |
| 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);;