contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA459724" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 443057 | 443057 | PRJNA459724_S_NODE_1561_length_179_cov_2.055556_g1558_i0 | PRJNA459724 | 1561 | 179 | 2.055556 | 3.67944524 | Salinomyces thailandicus | 706561 | Fungi | Fungi | 88.6 | 1.13e-18 | NR | TKA25294.1 | 706561 | g1558 | i0 | 86.4 | 0.988826815642458 | 59 | 8 | 98.9 | 0 | 178 | 2 | 2290 | 2348 | TKA25294.1 hypothetical protein B0A50_06198 [Salinomyces thailandicus] | diamond | 177 | 88.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Salinomyces | Salinomyces thailandicus | |
| 27044570 | 27044570 | PRJNA459724_S_NODE_1842_length_172_cov_2.197080_g1839_i0 | PRJNA459724 | 1842 | 172 | 2.19708 | 3.7789776 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 87.8 | 1.02e-18 | NR | KAK5091843.1 | 1690604 | g1839 | i0 | 87 | 0.802325581395349 | 46 | 6 | 80.2 | 0 | 164 | 27 | 330 | 375 | KAK5091843.1 hypothetical protein LTR24_005739 [Lithohypha guttulata] | diamond | 138 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 27992253 | 27992253 | PRJNA459724_S_NODE_2425_length_160_cov_3.928000_g2422_i0 | PRJNA459724 | 2425 | 160 | 3.928 | 6.2848 | Penicillium thymicola | 293382 | Fungi | Fungi | 50.4 | 2.91e-6 | NR | KAJ9484416.1 | 293382 | g2422 | i0 | 73.3 | 0.5625 | 30 | 8 | 56.3 | 0 | 106 | 17 | 33 | 62 | KAJ9484416.1 hypothetical protein VN97_g8961 [Penicillium thymicola] | diamond | 90 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium thymicola | |
| 28608253 | 28608253 | PRJNA459724_S_NODE_1407_length_184_cov_4.006711_g1404_i0 | PRJNA459724 | 1407 | 184 | 4.006711 | 7.37234824 | Dothideomycetes | 147541 | Fungi | Fungi | 42.7 | 0.0171 | NR | OQO12941.1 | 1507870 | g1404 | i0 | 79.2 | 1.17391304347826 | 24 | 5 | 39.1 | 0 | 184 | 113 | 365 | 388 | OQO12941.1 hypothetical protein B0A48_02405 [Cryoendolithus antarcticus] | diamond | 216 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cryoendolithus | Cryoendolithus antarcticus | |
| 28687034 | 28687034 | PRJNA459724_S_NODE_1127_length_195_cov_2.956250_g1124_i0 | PRJNA459724 | 1127 | 195 | 2.95625 | 5.7646875 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 69.7 | 6.21e-12 | NR | XP_069232226.1 | 1052096 | g1124 | i0 | 77.3 | 2.03076923076923 | 44 | 6 | 67.7 | 1 | 192 | 61 | 506 | 545 | XP_069232226.1 uncharacterized protein WHR41_02163 [Cladosporium halotolerans] | diamond | 396 | 69.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 29034329 | 29034329 | PRJNA459724_S_NODE_1788_length_173_cov_6.304348_g1785_i0 | PRJNA459724 | 1788 | 173 | 6.304348 | 10.90652204 | Penicillium rubens Wisconsin 54-1255 | 500485 | Fungi | Fungi | 78.2 | 1.05e-15 | NR | CAP94145.1 | 500485 | g1785 | i0 | 95.1 | 0.710982658959538 | 41 | 2 | 71.1 | 0 | 147 | 25 | 96 | 136 | CAP94145.1 hypothetical protein PCH_Pc16g14750 [Penicillium rubens Wisconsin 54-1255] | diamond | 123 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium rubens | |
| 29570715 | 29570715 | PRJNA459724_S_NODE_1210_length_191_cov_8.730769_g1207_i0 | PRJNA459724 | 1210 | 191 | 8.730769 | 16.67576879 | Chrysothrix sp. TS-e1954 | 2939400 | Fungi | Fungi | 44.7 | 0.00385 | NR | KAI9726092.1 | 2939400 | g1207 | i0 | 69.2 | 0.408376963350785 | 26 | 8 | 40.8 | 0 | 178 | 101 | 347 | 372 | KAI9726092.1 MAG: hypothetical protein M1828_002100 [Chrysothrix sp. TS-e1954] | diamond | 78 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Arthoniomycetes | Arthoniales | Chrysotrichaceae | Chrysothrix | Chrysothrix sp. TS-e1954 | |
| 29728445 | 29728445 | PRJNA459724_S_NODE_2150_length_165_cov_8.015385_g2147_i0 | PRJNA459724 | 2150 | 165 | 8.015385 | 13.22538525 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 81.3 | 3.34e-16 | NR | XP_069227984.1 | 1052096 | g2147 | i0 | 91.5 | 0.854545454545454 | 47 | 3 | 83.6 | 1 | 158 | 21 | 509 | 555 | XP_069227984.1 uncharacterized protein WHR41_06679 [Cladosporium halotolerans] | diamond | 141 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 30297829 | 30297829 | PRJNA459724_S_NODE_1072_length_197_cov_4.154321_g1069_i0 | PRJNA459724 | 1072 | 197 | 4.154321 | 8.18401237 | Penicillium rubens Wisconsin 54-1255 | 500485 | Fungi | Fungi | 109 | 6.82e-29 | NR | CAP79085.1 | 500485 | g1069 | i0 | 100 | 0.776649746192893 | 51 | 0 | 77.7 | 0 | 22 | 174 | 1 | 51 | CAP79085.1 hypothetical protein PCH_Pc06g00920 [Penicillium rubens Wisconsin 54-1255] | diamond | 153 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium rubens | |
| 30676314 | 30676314 | PRJNA459724_S_NODE_1653_length_176_cov_2.205674_g1650_i0 | PRJNA459724 | 1653 | 176 | 2.205674 | 3.88198624 | Penicillium italicum | 40296 | Fungi | Fungi | 75.9 | 8.73e-17 | NR | KGO77943.1 | 40296 | g1650 | i0 | 87.5 | 0.681818181818182 | 40 | 5 | 68.2 | 0 | 137 | 18 | 1 | 40 | KGO77943.1 hypothetical protein PITC_024710 [Penicillium italicum] | diamond | 120 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium italicum | |
| 31087228 | 31087228 | PRJNA459724_S_NODE_3195_length_150_cov_1.556522_g3192_i0 | PRJNA459724 | 3195 | 150 | 1.556522 | 2.334783 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 45.8 | 8.81e-4 | NR | XP_069228427.1 | 1052096 | g3192 | i0 | 85.2 | 0.54 | 27 | 4 | 54 | 0 | 141 | 61 | 1252 | 1278 | XP_069228427.1 uncharacterized protein WHR41_05793 [Cladosporium halotolerans] | diamond | 81 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 31403537 | 31403537 | PRJNA459724_S_NODE_2416_length_160_cov_6.440000_g2413_i0 | PRJNA459724 | 2416 | 160 | 6.44 | 10.304 | Viridothelium virens | 1048519 | Fungi | Fungi | 52.4 | 4.62e-6 | NR | KAF2238101.1 | 1048519 | g2413 | i0 | 80.6 | 0.58125 | 31 | 6 | 58.1 | 0 | 140 | 48 | 520 | 550 | KAF2238101.1 ATP synthase F1, alpha subunit [Viridothelium virens] | diamond | 93 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Trypetheliales | Trypetheliaceae | Viridothelium | Viridothelium virens |
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);;