contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA815356" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28696860 | 28696860 | PRJNA815356_P_NODE_9667_length_248_cov_0.891429_g9504_i0 | PRJNA815356 | 9667 | 248 | 0.891429 | 2.21074392 | Aspergillus ruber CBS 13568 | 396024 | Fungi | Fungi | 72.8 | 9.96e-13 | NR | XP_040641929.1 | 1388766 | g9504 | i0 | 51.9 | 0.955645161290323 | 79 | 22 | 95.6 | 2 | 1 | 237 | 35 | 97 | XP_040641929.1 putative cyclin-like protein [Aspergillus ruber CBS 135680] | diamond | 237 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus ruber | |
| 28981014 | 28981014 | PRJNA815356_P_NODE_9028_length_252_cov_0.871508_g8865_i0 | PRJNA815356 | 9028 | 252 | 0.871508 | 2.19620016 | Aspergillus glaucus CBS 516.65 | 1160497 | Fungi | Fungi | 104 | 6.48e-24 | NR | XP_022399111.1 | 1160497 | g8865 | i0 | 75.7 | 0.880952380952381 | 74 | 17 | 86.9 | 1 | 221 | 3 | 822 | 895 | XP_022399111.1 uncharacterized protein ASPGLDRAFT_67877 [Aspergillus glaucus CBS 516.65] | diamond | 222 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 29643511 | 29643511 | PRJNA815356_P_NODE_9250_length_250_cov_1.762712_g9087_i0 | PRJNA815356 | 9250 | 250 | 1.762712 | 4.40678 | Aspergillus sclerotioniger CBS 115572 | 1450535 | Fungi | Fungi | 46.2 | 4.41e-4 | NR | XP_025461232.1 | 1450535 | g9087 | i0 | 71.9 | 0.384 | 32 | 7 | 38.4 | 1 | 174 | 79 | 1 | 30 | XP_025461232.1 uncharacterized protein BO94DRAFT_480689, partial [Aspergillus sclerotioniger CBS 115572] | diamond | 96 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus sclerotioniger | |
| 29706588 | 29706588 | PRJNA815356_P_NODE_8870_length_252_cov_3.921788_g8707_i0 | PRJNA815356 | 8870 | 252 | 3.921788 | 9.88290576 | Penicillium angulare | 116970 | Fungi | Fungi | 93.6 | 6.37e-23 | NR | XP_056779450.1 | 116970 | g8707 | i0 | 63.8 | 0.821428571428571 | 69 | 25 | 82.1 | 0 | 242 | 36 | 4 | 72 | XP_056779450.1 uncharacterized protein N7478_005199 [Penicillium angulare] | diamond | 207 | 93.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium angulare | |
| 30189440 | 30189440 | PRJNA815356_P_NODE_9632_length_248_cov_0.891429_g9469_i0 | PRJNA815356 | 9632 | 248 | 0.891429 | 2.21074392 | Aspergillus | 5052 | Fungi | Fungi | 48.9 | 2.57e-4 | NR | XP_022400977.1 | 1160497 | g9469 | i0 | 82.6 | 0.834677419354839 | 23 | 4 | 27.8 | 0 | 3 | 71 | 410 | 432 | XP_022400977.1 uncharacterized protein ASPGLDRAFT_171422 [Aspergillus glaucus CBS 516.65] | diamond | 207 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 31476698 | 31476698 | PRJNA815356_P_NODE_11416_length_228_cov_2.012903_g11253_i0 | PRJNA815356 | 11416 | 228 | 2.012903 | 4.5894188400000004 | Aspergillus uvarum CBS 121591 | 1448315 | Fungi | Fungi | 48.5 | 3.12e-5 | NR | XP_025491096.1 | 1448315 | g11253 | i0 | 60 | 0.526315789473684 | 40 | 16 | 52.6 | 0 | 181 | 62 | 9 | 48 | XP_025491096.1 uncharacterized protein BO82DRAFT_100881 [Aspergillus uvarum CBS 121591] | diamond | 120 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus uvarum |
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);;