contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1233317" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27041180 | 27041180 | PRJNA1233317_S_NODE_13922_length_206_cov_4.326531_g13886_i0 | PRJNA1233317 | 13922 | 206 | 4.326531 | 8.91265386 | Endocarpon pusillum | 364733 | Fungi | Fungi | 129 | 6.72e-33 | NR | KAF7509200.1 | 364733 | g13886 | i0 | 91.2 | 0.990291262135922 | 68 | 6 | 99 | 0 | 206 | 3 | 6 | 73 | KAF7509200.1 hypothetical protein GJ744_008260 [Endocarpon pusillum] | diamond | 204 | 129 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Verrucariales | Verrucariaceae | Endocarpon | Endocarpon pusillum | |
| 28209588 | 28209588 | PRJNA1233317_S_NODE_8226_length_269_cov_2.323810_g8190_i0 | PRJNA1233317 | 8226 | 269 | 2.32381 | 6.2510489 | Endocarpon pusillum | 364733 | Fungi | Fungi | 137 | 2.7899999999999997e-35 | NR | KAF7503732.1 | 364733 | g8190 | i0 | 79.8 | 1.94052044609665 | 89 | 17 | 99.3 | 1 | 269 | 3 | 1228 | 1315 | KAF7503732.1 hypothetical protein GJ744_003315 [Endocarpon pusillum] | diamond | 522 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Verrucariales | Verrucariaceae | Endocarpon | Endocarpon pusillum | |
| 28620404 | 28620404 | PRJNA1233317_S_NODE_5727_length_306_cov_2.963563_g5691_i0 | PRJNA1233317 | 5727 | 306 | 2.963563 | 9.06850278 | Endocarpon pusillum | 364733 | Fungi | Fungi | 86.3 | 9.13e-20 | NR | KAF7506236.1 | 364733 | g5691 | i0 | 64 | 0.735294117647059 | 75 | 24 | 70.6 | 1 | 26 | 241 | 4 | 78 | KAF7506236.1 hypothetical protein GJ744_012128 [Endocarpon pusillum] | diamond | 225 | 86.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Verrucariales | Verrucariaceae | Endocarpon | Endocarpon pusillum | |
| 28746517 | 28746517 | PRJNA1233317_S_NODE_9427_length_253_cov_2.201031_g9391_i0 | PRJNA1233317 | 9427 | 253 | 2.201031 | 5.56860843 | Exophiala dermatitidis NIH/UT8656 | 858893 | Fungi | Fungi | 127 | 2.48e-34 | NR | XP_009161809.1 | 858893 | g9391 | i0 | 74.7 | 1.96837944664032 | 83 | 21 | 98.4 | 0 | 3 | 251 | 14 | 96 | XP_009161809.1 ATP synthase subunit 6 [Exophiala dermatitidis NIH/UT8656] | diamond | 498 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala dermatitidis | |
| 29144455 | 29144455 | PRJNA1233317_S_NODE_9209_length_256_cov_1.355330_g9173_i0 | PRJNA1233317 | 9209 | 256 | 1.35533 | 3.4696448 | Endocarpon | 364710 | Fungi | Fungi | 93.2 | 1.68e-20 | NR | KAF7512970.1 | 364733 | g9173 | i0 | 82.2 | 1.0546875 | 45 | 8 | 52.7 | 0 | 3 | 137 | 271 | 315 | KAF7512970.1 hypothetical protein GJ744_011236 [Endocarpon pusillum] | diamond | 270 | 94 | 0.991489361702128 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Verrucariales | Verrucariaceae | Endocarpon | Endocarpon pusillum | |
| 29914976 | 29914976 | PRJNA1233317_S_NODE_1691_length_405_cov_4.526012_g1655_i0 | PRJNA1233317 | 1691 | 405 | 4.526012 | 18.3303486 | Endocarpon pusillum Z | 364733 | Fungi | Fungi | 147 | 1.14e-38 | NR | XP_007787173.1 | 1263415 | g1655 | i0 | 82.7 | 0.6 | 81 | 14 | 60 | 0 | 401 | 159 | 514 | 594 | XP_007787173.1 catabolite repression protein creC [Endocarpon pusillum Z07020] | diamond | 243 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Verrucariales | Verrucariaceae | Endocarpon | Endocarpon pusillum | |
| 30420667 | 30420667 | PRJNA1233317_S_NODE_4873_length_321_cov_3.958015_g4837_i0 | PRJNA1233317 | 4873 | 321 | 3.958015 | 12.70522815 | Endocarpon pusillum | 364733 | Fungi | Fungi | 189 | 2.3600000000000007e-59 | NR | KAF7509945.1 | 364733 | g4837 | i0 | 84 | 0.934579439252336 | 100 | 15 | 92.5 | 1 | 306 | 10 | 63 | 162 | KAF7509945.1 hypothetical protein GJ744_007259 [Endocarpon pusillum] | diamond | 300 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Verrucariales | Verrucariaceae | Endocarpon | Endocarpon pusillum | |
| 30546692 | 30546692 | PRJNA1233317_S_NODE_10333_length_242_cov_3.136612_g10297_i0 | PRJNA1233317 | 10333 | 242 | 3.136612 | 7.59060104 | Endocarpon pusillum Z | 364733 | Fungi | Fungi | 82 | 5.46e-17 | NR | XP_007806039.1 | 1263415 | g10297 | i0 | 80.4 | 1.10330578512397 | 51 | 5 | 63.2 | 1 | 221 | 69 | 32 | 77 | XP_007806039.1 uncharacterized protein EPUS_02720 [Endocarpon pusillum Z07020] | diamond | 267 | 82 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Verrucariales | Verrucariaceae | Endocarpon | Endocarpon pusillum | |
| 31115160 | 31115160 | PRJNA1233317_S_NODE_9555_length_251_cov_4.161458_g9519_i0 | PRJNA1233317 | 9555 | 251 | 4.161458 | 10.44525958 | Lobaria immixta | 669869 | Fungi | Fungi | 43.9 | 0.0144 | NR | MCJ1269269.1 | 669869 | g9519 | i0 | 43.1 | 0.693227091633466 | 58 | 26 | 66.9 | 2 | 21 | 188 | 182 | 234 | MCJ1269269.1 Cytochrome c1 heme lyase [Lobaria immixta] | diamond | 174 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Peltigerales | Lobariaceae | Lobaria | Lobaria immixta | |
| 31165459 | 31165459 | PRJNA1233317_S_NODE_7235_length_283_cov_6.276786_g7199_i0 | PRJNA1233317 | 7235 | 283 | 6.276786 | 17.76330438 | Ascomycota | 4890 | Fungi | Fungi | 43.9 | 0.0227 | NR | KAG9769604.1 | 46634 | g7199 | i0 | 100 | 2.75618374558304 | 20 | 0 | 21.2 | 0 | 282 | 223 | 376 | 395 | KAG9769604.1 hypothetical protein KCU88_g6835, partial [Aureobasidium melanogenum] | diamond | 780 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum | |
| 32222522 | 32222522 | PRJNA1233317_S_NODE_3658_length_345_cov_2.559441_g3622_i0 | PRJNA1233317 | 3658 | 345 | 2.559441 | 8.83007145 | Exophiala mesophila | 212818 | Fungi | Fungi | 138 | 4.28e-35 | NR | XP_016221323.1 | 212818 | g3622 | i0 | 70.2 | 0.904347826086957 | 104 | 28 | 89.6 | 2 | 309 | 1 | 632 | 733 | XP_016221323.1 uncharacterized protein PV10_07129 [Exophiala mesophila] | diamond | 312 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala mesophila | |
| 32317714 | 32317714 | PRJNA1233317_S_NODE_14819_length_199_cov_3.864286_g14783_i0 | PRJNA1233317 | 14819 | 199 | 3.864286 | 7.68992914 | Endocarpon pusillum | 364733 | Fungi | Fungi | 72.4 | 8.27e-15 | NR | KAF7510206.1 | 364733 | g14783 | i0 | 74.5 | 0.708542713567839 | 47 | 10 | 67.8 | 1 | 65 | 199 | 4 | 50 | KAF7510206.1 hypothetical protein GJ744_006902 [Endocarpon pusillum] | diamond | 141 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Verrucariales | Verrucariaceae | Endocarpon | Endocarpon pusillum |
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);;