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