contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA656952" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3173461 | 3173461 | PRJNA656952_P_NODE_42403_length_242_cov_0.911243_g42216_i0 | PRJNA656952 | 42403 | 242 | 0.911243 | 2.20520806 | Cryoendolithus antarcticus | 1507870 | Fungi | Fungi | 107 | 8.17e-26 | NR | OQO05860.1 | 1507870 | g42216 | i0 | 70 | 8.49173553719008 | 70 | 21 | 86.8 | 0 | 214 | 5 | 215 | 284 | OQO05860.1 hypothetical protein B0A48_09955 [Cryoendolithus antarcticus] | diamond | 2055 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cryoendolithus | Cryoendolithus antarcticus | |
| 21024932 | 21024932 | PRJNA656952_P_NODE_34897_length_248_cov_0.880000_g34710_i0 | PRJNA656952 | 34897 | 248 | 0.88 | 2.1824 | Talaromyces verruculosus | 198730 | Fungi | Fungi | 171 | 1.83e-49 | NR | KUL91205.1 | 198730 | g34710 | i0 | 97.6 | 0.991935483870968 | 82 | 2 | 99.2 | 0 | 1 | 246 | 97 | 178 | KUL91205.1 hypothetical protein ZTR_00850 [Talaromyces verruculosus] | diamond | 246 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces verruculosus | |
| 27776471 | 27776471 | PRJNA656952_P_NODE_38244_length_245_cov_1.651163_g38057_i0 | PRJNA656952 | 38244 | 245 | 1.651163 | 4.04534935 | Alternaria atra | 119953 | Fungi | Fungi | 127 | 2.1e-33 | NR | XP_043167565.1 | 119953 | g38057 | i0 | 77.2 | 1.92244897959184 | 79 | 18 | 96.7 | 0 | 9 | 245 | 4 | 82 | XP_043167565.1 uncharacterized protein ALTATR162_LOCUS4020 [Alternaria atra] | diamond | 471 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria atra | |
| 28514782 | 28514782 | PRJNA656952_P_NODE_34007_length_249_cov_0.875000_g33820_i0 | PRJNA656952 | 34007 | 249 | 0.875 | 2.17875 | Fusarium | 5506 | Fungi | Fungi | 44.3 | 0.011 | NR | KAF4339000.1 | 44412 | g33820 | i0 | 33.8 | 2.48192771084337 | 68 | 43 | 81.9 | 1 | 6 | 209 | 82 | 147 | KAF4339000.1 SET domain protein [Fusarium beomiforme] | diamond | 618 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium beomiforme | |
| 28565619 | 28565619 | PRJNA656952_P_NODE_37987_length_246_cov_0.890173_g37800_i0 | PRJNA656952 | 37987 | 246 | 0.890173 | 2.18982558 | Clonostachys rhizophaga | 160324 | Fungi | Fungi | 90.1 | 5.47e-20 | NR | CAH0028544.1 | 160324 | g37800 | i0 | 76.3 | 0.719512195121951 | 59 | 14 | 72 | 0 | 70 | 246 | 40 | 98 | CAH0028544.1 unnamed protein product [Clonostachys rhizophaga] | diamond | 177 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Bionectriaceae | Clonostachys | Clonostachys rhizophaga | |
| 28881292 | 28881292 | PRJNA656952_P_NODE_42128_length_242_cov_0.911243_g41941_i0 | PRJNA656952 | 42128 | 242 | 0.911243 | 2.20520806 | Verruconis gallopava | 253628 | Fungi | Fungi | 76.3 | 5.79e-14 | NR | XP_016215378.1 | 253628 | g41941 | i0 | 75.5 | 1.21487603305785 | 49 | 12 | 60.7 | 0 | 240 | 94 | 305 | 353 | XP_016215378.1 uncharacterized protein PV09_03392 [Verruconis gallopava] | diamond | 294 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Sympoventuriaceae | Verruconis | Verruconis gallopava | |
| 29355117 | 29355117 | PRJNA656952_P_NODE_36329_length_247_cov_0.885057_g36142_i0 | PRJNA656952 | 36329 | 247 | 0.885057 | 2.18609079 | Fusarium graminearum | 5518 | Fungi | Fungi | 105 | 4.35e-24 | NR | PCD19627.1 | 5518 | g36142 | i0 | 100 | 0.65587044534413 | 54 | 0 | 65.6 | 0 | 3 | 164 | 870 | 923 | PCD19627.1 hypothetical protein FGRA07_05376 [Fusarium graminearum] | diamond | 162 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium graminearum | |
| 29418009 | 29418009 | PRJNA656952_P_NODE_17469_length_321_cov_1.205645_g17282_i0 | PRJNA656952 | 17469 | 321 | 1.205645 | 3.87012045 | Fusarium graminearum | 5518 | Fungi | Fungi | 113 | 4.16e-30 | NR | CAG1998878.1 | 5518 | g17282 | i0 | 100 | 0.934579439252336 | 50 | 0 | 46.7 | 0 | 321 | 172 | 46 | 95 | CAG1998878.1 unnamed protein product [Fusarium graminearum] | diamond | 300 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium graminearum | |
| 30618343 | 30618343 | PRJNA656952_P_NODE_37873_length_246_cov_0.890173_g37686_i0 | PRJNA656952 | 37873 | 246 | 0.890173 | 2.18982558 | Paecilomyces variotii No. 5 | 1356009 | Fungi | Fungi | 114 | 3.44e-27 | NR | GAD93603.1 | 1356009 | g37686 | i0 | 71.6 | 0.98780487804878 | 81 | 23 | 98.8 | 0 | 2 | 244 | 363 | 443 | GAD93603.1 RecQ family helicase MusN [Paecilomyces variotii No. 5] | diamond | 243 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Thermoascaceae | Paecilomyces | Paecilomyces variotii | |
| 31250364 | 31250364 | PRJNA656952_P_NODE_41535_length_243_cov_0.905882_g41348_i0 | PRJNA656952 | 41535 | 243 | 0.905882 | 2.20129326 | Ceratocystis fimbriata CBS 114723 | 1035309 | Fungi | Fungi | 182 | 4.35e-51 | NR | PHH54580.1 | 1035309 | g41348 | i0 | 97.5 | 0.987654320987654 | 80 | 2 | 98.8 | 0 | 241 | 2 | 1291 | 1370 | PHH54580.1 putative serine/threonine-protein kinase VPS15 [Ceratocystis fimbriata CBS 114723] | diamond | 240 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Microascales | Ceratocystidaceae | Ceratocystis | Ceratocystis fimbriata | |
| 32294714 | 32294714 | PRJNA656952_P_NODE_31639_length_251_cov_0.865169_g31452_i0 | PRJNA656952 | 31639 | 251 | 0.865169 | 2.17157419 | Hapsidospora chrysogenum ATCC 1155 | 5044 | Fungi | Fungi | 77.4 | 2.59e-14 | NR | KFH43492.1 | 857340 | g31452 | i0 | 57.1 | 0.752988047808765 | 63 | 26 | 74.1 | 1 | 246 | 61 | 540 | 602 | KFH43492.1 Regulator of Ty1 transposition protein-like protein [Hapsidospora chrysogenum ATCC 11550] | diamond | 189 | 77.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Bionectriaceae | Hapsidospora | Hapsidospora chrysogena | |
| 32547723 | 32547723 | PRJNA656952_P_NODE_26799_length_270_cov_1.532995_g26612_i0 | PRJNA656952 | 26799 | 270 | 1.532995 | 4.1390865 | Paramyrothecium foliicola | 1859967 | Fungi | Fungi | 182 | 8.34e-56 | NR | KAI9170997.1 | 1859967 | g26612 | i0 | 93.3 | 0.988888888888889 | 89 | 6 | 98.9 | 0 | 3 | 269 | 40 | 128 | KAI9170997.1 Calcipressin-1 [Paramyrothecium foliicola] | diamond | 267 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Stachybotryaceae | Paramyrothecium | Paramyrothecium foliicola | |
| 32641736 | 32641736 | PRJNA656952_P_NODE_23480_length_285_cov_1.452830_g23293_i0 | PRJNA656952 | 23480 | 285 | 1.45283 | 4.1405655 | Colletotrichum kahawae | 34407 | Fungi | Fungi | 102 | 9.59e-26 | NR | KAK2772684.1 | 34407 | g23293 | i0 | 94.4 | 0.568421052631579 | 54 | 3 | 56.8 | 0 | 123 | 284 | 30 | 83 | KAK2772684.1 hypothetical protein CKAH01_13883 [Colletotrichum kahawae] | diamond | 162 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum kahawae |
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);;