contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJEB48872" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5177727 | 5177727 | PRJEB48872_P_NODE_374845_length_242_cov_2.068966_g359033_i0 | PRJEB48872 | 374845 | 242 | 2.068966 | 5.00689772 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 155 | 7.249999999999999e-47 | NR | KAJ8135180.1 | 27326 | g359033 | i0 | 93.8 | 0.991735537190083 | 80 | 5 | 99.2 | 0 | 242 | 3 | 31 | 110 | KAJ8135180.1 hypothetical protein OY671_011607, partial [Metschnikowia pulcherrima] | diamond | 240 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 26748168 | 26748168 | PRJEB48872_P_NODE_417301_length_223_cov_1.559783_g401489_i0 | PRJEB48872 | 417301 | 223 | 1.559783 | 3.47831609 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 147 | 2.56e-43 | NR | KAJ8134740.1 | 27326 | g401489 | i0 | 95.9 | 0.982062780269058 | 73 | 3 | 98.2 | 0 | 3 | 221 | 30 | 102 | KAJ8134740.1 hypothetical protein OY671_012047, partial [Metschnikowia pulcherrima] | diamond | 219 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 27127908 | 27127908 | PRJEB48872_P_NODE_380122_length_240_cov_1.104478_g364310_i0 | PRJEB48872 | 380122 | 240 | 1.104478 | 2.6507472 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 121 | 2.4999999999999998e-33 | NR | KAJ8133682.1 | 27326 | g364310 | i0 | 90.9 | 0.825 | 66 | 6 | 82.5 | 0 | 238 | 41 | 78 | 143 | KAJ8133682.1 hypothetical protein OY671_013104, partial [Metschnikowia pulcherrima] | diamond | 198 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 28416587 | 28416587 | PRJEB48872_P_NODE_358166_length_251_cov_1.528302_g342354_i0 | PRJEB48872 | 358166 | 251 | 1.528302 | 3.83603802 | Orbiliaceae | 47021 | Fungi | Fungi | 77 | 1.73e-15 | NR | KAK6499368.1 | 74498 | g342354 | i0 | 52.1 | 1.74501992031873 | 73 | 32 | 87.3 | 1 | 220 | 2 | 77 | 146 | KAK6499368.1 hypothetical protein TWF506_003996 [Arthrobotrys conoides] | diamond | 438 | 77 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Arthrobotrys | Arthrobotrys conoides | |
| 29590997 | 29590997 | PRJEB48872_P_NODE_481770_length_199_cov_2.050000_g465958_i0 | PRJEB48872 | 481770 | 199 | 2.05 | 4.0795 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 119 | 3.63e-32 | NR | KAJ8135944.1 | 27326 | g465958 | i0 | 93.9 | 0.994974874371859 | 66 | 4 | 99.5 | 0 | 198 | 1 | 72 | 137 | KAJ8135944.1 hypothetical protein OY671_010843, partial [Metschnikowia pulcherrima] | diamond | 198 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 31866595 | 31866595 | PRJEB48872_P_NODE_669577_length_155_cov_1.103448_g653765_i0 | PRJEB48872 | 669577 | 155 | 1.103448 | 1.7103444 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 103 | 9.3e-27 | NR | KAJ8134404.1 | 27326 | g653765 | i0 | 100 | 0.948387096774194 | 49 | 0 | 94.8 | 0 | 1 | 147 | 103 | 151 | KAJ8134404.1 hypothetical protein OY671_012383, partial [Metschnikowia pulcherrima] | diamond | 147 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 32056575 | 32056575 | PRJEB48872_P_NODE_330398_length_267_cov_1.750000_g314586_i0 | PRJEB48872 | 330398 | 267 | 1.75 | 4.6725 | Metschnikowia pulcherrima | 27326 | Fungi | Fungi | 169 | 6.349999999999999e-52 | NR | KAJ8134144.1 | 27326 | g314586 | i0 | 96.4 | 0.943820224719101 | 84 | 3 | 94.4 | 0 | 267 | 16 | 56 | 139 | KAJ8134144.1 hypothetical protein OY671_012642, partial [Metschnikowia pulcherrima] | diamond | 252 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 32531406 | 32531406 | PRJEB48872_P_NODE_437299_length_215_cov_1.397727_g421487_i0 | PRJEB48872 | 437299 | 215 | 1.397727 | 3.00511305 | Hyaloscypha sp. PMI_1271 | 2614599 | Fungi | Fungi | 47.8 | 4.44e-4 | NR | KAH8777176.1 | 2614599 | g421487 | i0 | 51.9 | 0.725581395348837 | 52 | 20 | 65.6 | 2 | 58 | 198 | 385 | 436 | KAH8777176.1 pectate lyase superfamily protein-domain-containing protein [Hyaloscypha sp. PMI_1271] | diamond | 156 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Hyaloscyphaceae | Hyaloscypha | Hyaloscypha sp. PMI_1271 |
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);;