contig_metadata
7 rows where bioproject = "PRJNA773625" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9677754 | 9677754 | PRJNA773625_P_NODE_6008_length_183_cov_0.977612_g5993_i0 | PRJNA773625 | 6008 | 183 | 0.977612 | 1.78902996 | Aspergillus sydowii | 75750 | Fungi | Fungi | 111 | 2.54e-20 | NTclustered | gi|2028207924|ref|XM_040850072.1| | 1036612 | g5993 | i0 | 95.714 | 0.382513661202186 | 70 | 1 | 38 | 2 | 12 | 81 | 1328 | 1395 | Aspergillus sydowii CBS 593.65 uncharacterized protein (ASPSYDRAFT_62066), partial mRNA | blastn | 70 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus sydowii | |
| 14778079 | 14778079 | PRJNA773625_P_NODE_4292_length_209_cov_1.300000_g4277_i0 | PRJNA773625 | 4292 | 209 | 1.3 | 2.717 | Recurvomyces mirabilis | 574656 | Fungi | Fungi | 159 | 1.05e-34 | NTclustered | gi|2724926283|ref|XM_064843384.1| | 574656 | g4277 | i0 | 83.051 | 8.24401913875598 | 177 | 28 | 84 | 2 | 34 | 209 | 797 | 972 | Recurvomyces mirabilis uncharacterized protein (LTS14_010708), partial mRNA | blastn | 1723 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Recurvomyces | Recurvomyces mirabilis | |
| 16051858 | 16051858 | PRJNA773625_P_NODE_6553_length_175_cov_2.246032_g6538_i0 | PRJNA773625 | 6553 | 175 | 2.246032 | 3.930556 | Dothideomycetes | 147541 | Fungi | Fungi | 78.2 | 4.86e-15 | NR | XP_069232564.1 | 1052096 | g6538 | i0 | 67.9 | 2.64 | 53 | 17 | 90.9 | 0 | 14 | 172 | 684 | 736 | XP_069232564.1 uncharacterized protein WHR41_01592 [Cladosporium halotolerans] | diamond | 462 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 16051874 | 16051874 | PRJNA773625_P_NODE_7193_length_169_cov_0.866667_g7178_i0 | PRJNA773625 | 7193 | 169 | 0.866667 | 1.46466723 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 119 | 1.37e-22 | NTclustered | gi|2837765021|ref|XM_069376411.1| | 1052096 | g7178 | i0 | 88 | 0.763313609467456 | 100 | 12 | 59 | 0 | 19 | 118 | 360 | 459 | Cladosporium halotolerans NADH-ubiquinone oxidoreductase 12 kDa subunit, mitochondrial (nuo-12.3), mRNA | blastn | 129 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 19876029 | 19876029 | PRJNA773625_P_NODE_6476_length_176_cov_3.275591_g6461_i0 | PRJNA773625 | 6476 | 176 | 3.275591 | 5.76504016 | Annulohypoxylon maeteangense | 1927788 | Fungi | Fungi | 104 | 4.04e-18 | NTclustered | gi|2234930425|ref|XM_047965658.1| | 1927788 | g6461 | i0 | 85.149 | 1.53409090909091 | 101 | 15 | 57 | 0 | 67 | 167 | 1274 | 1374 | Annulohypoxylon maeteangense putative FMN dependent dehydrogenase (GGS22DRAFT_195388), partial mRNA | blastn | 270 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Hypoxylaceae | Annulohypoxylon | Annulohypoxylon maeteangense | |
| 27021744 | 27021744 | PRJNA773625_P_NODE_8542_length_167_cov_0.881356_g8527_i0 | PRJNA773625 | 8542 | 167 | 0.881356 | 1.47186452 | Epicoccum nigrum | 105696 | Fungi | Fungi | 112 | 2.9e-28 | NR | KAG9197716.1 | 105696 | g8527 | i0 | 98.2 | 0.988023952095808 | 55 | 1 | 98.8 | 0 | 1 | 165 | 175 | 229 | KAG9197716.1 hypothetical protein G6514_001107 [Epicoccum nigrum] | diamond | 165 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Epicoccum | Epicoccum nigrum | |
| 28506116 | 28506116 | PRJNA773625_P_NODE_6567_length_175_cov_1.412698_g6552_i0 | PRJNA773625 | 6567 | 175 | 1.412698 | 2.4722215 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 83.2 | 2.12e-17 | NR | XP_069233990.1 | 1052096 | g6552 | i0 | 89.8 | 7.56 | 49 | 4 | 84 | 1 | 149 | 3 | 229 | 276 | XP_069233990.1 Prohibitin-1 [Cladosporium halotolerans] | diamond | 1323 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans |
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);;