contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJEB673" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6513001 | 6513001 | PRJEB673_P_NODE_2546_length_617_cov_2.276632_g2252_i0 | PRJEB673 | 2546 | 617 | 2.276632 | 14.04681944 | Ascomycota | 4890 | Fungi | Fungi | 205 | 1.06e-61 | NR | KAK5796054.1 | 5077 | g2252 | i0 | 72 | 3.88978930307942 | 132 | 37 | 64.2 | 0 | 221 | 616 | 83 | 214 | KAK5796054.1 hypothetical protein VI817_005339 [Penicillium citrinum] | diamond | 2400 | 207 | 0.990338164251208 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium citrinum | |
| 11613465 | 11613465 | PRJEB673_P_NODE_8850_length_231_cov_1.397959_g8501_i0 | PRJEB673 | 8850 | 231 | 1.397959 | 3.22928529 | Grosmannia clavigera kw14 | 226899 | Fungi | Fungi | 103 | 1.7600000000000002e-26 | NR | XP_014173999.1 | 655863 | g8501 | i0 | 67.1 | 4.93506493506494 | 76 | 25 | 98.7 | 0 | 3 | 230 | 31 | 106 | XP_014173999.1 ribosomal protein l26 [Grosmannia clavigera kw1407] | diamond | 1140 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Leptographium | Leptographium clavigerum | |
| 15437401 | 15437401 | PRJEB673_P_NODE_3753_length_514_cov_1.365344_g3426_i0 | PRJEB673 | 3753 | 514 | 1.365344 | 7.01786816 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 127 | 6.729999999999999e-31 | NR | KAK5095389.1 | 1690604 | g3426 | i0 | 46.3 | 2.33463035019455 | 134 | 69 | 77 | 2 | 35 | 430 | 80 | 212 | KAK5095389.1 hypothetical protein LTR24_003101 [Lithohypha guttulata] | diamond | 1200 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 21811720 | 21811720 | PRJEB673_P_NODE_8538_length_264_cov_1.165939_g8189_i0 | PRJEB673 | 8538 | 264 | 1.165939 | 3.07807896 | root | 1 | Root_unresolved | Root_unresolved | 82.8 | 7.7e-18 | NR | KAF5092528.1 | 27317 | g8189 | i0 | 56.3 | 4.04545454545455 | 71 | 30 | 79.5 | 1 | 260 | 51 | 71 | 141 | KAF5092528.1 hypothetical protein D0Z00_004542 [Geotrichum galactomycetum] | diamond | 1068 | 83.6 | 0.990430622009569 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Dipodascaceae | Geotrichum | Geotrichum galactomycetum | |
| 25221438 | 25221438 | PRJEB673_P_NODE_11160_length_164_cov_1.550388_g10811_i0 | PRJEB673 | 11160 | 164 | 1.550388 | 2.54263632 | root | 1 | Root_unresolved | Root_unresolved | 91.7 | 2.48e-20 | NR | 3CQ0_A | 4932 | g10811 | i0 | 79.6 | 13.7926829268293 | 54 | 11 | 98.8 | 0 | 164 | 3 | 100 | 153 | 3CQ0_A Chain A, Putative transaldolase YGR043C [Saccharomyces cerevisiae] | diamond | 2262 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 27381911 | 27381911 | PRJEB673_P_NODE_7663_length_310_cov_2.025455_g7314_i0 | PRJEB673 | 7663 | 310 | 2.025455 | 6.2789105 | Hortaea werneckii | 91943 | Fungi | Fungi | 49.3 | 6.57e-5 | NR | KAI7004786.1 | 91943 | g7314 | i0 | 53.5 | 2.91290322580645 | 43 | 20 | 41.6 | 0 | 307 | 179 | 65 | 107 | KAI7004786.1 hypothetical protein KC362_g18698, partial [Hortaea werneckii] | diamond | 903 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Hortaea | Hortaea werneckii | |
| 27595795 | 27595795 | PRJEB673_P_NODE_4684_length_429_cov_1.659898_g4336_i0 | PRJEB673 | 4684 | 429 | 1.659898 | 7.12096242 | Eukaryota | 2759 | Fungi | Fungi | 53.9 | 3.31e-5 | NR | MCJ1232639.1 | 160984 | g4336 | i0 | 48.4 | 4.6013986013986 | 64 | 29 | 44.8 | 1 | 405 | 214 | 120 | 179 | MCJ1232639.1 hypothetical protein [Varicellaria rhodocarpa] | diamond | 1974 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Pertusariales | Pertusariaceae | Varicellaria | Varicellaria rhodocarpa | |
| 28171118 | 28171118 | PRJEB673_P_NODE_4786_length_421_cov_1.898964_g4438_i0 | PRJEB673 | 4786 | 421 | 1.898964 | 7.99463844 | Ramularia collo-cygni | 112498 | Fungi | Fungi | 43.1 | 0.0375 | NR | XP_023629431.1 | 112498 | g4438 | i0 | 60.3 | 0.448931116389549 | 63 | 22 | 44.2 | 2 | 178 | 363 | 50 | 110 | XP_023629431.1 probable ribosomal protein P2 [Ramularia collo-cygni] | diamond | 189 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Ramularia | Ramularia collo-cygni | |
| 28518560 | 28518560 | PRJEB673_P_NODE_11867_length_158_cov_1.081301_g11518_i0 | PRJEB673 | 11867 | 158 | 1.081301 | 1.70845558 | Aspergillus udagawae | 91492 | Fungi | Fungi | 78.6 | 1.71e-15 | NR | GFF41351.1 | 91492 | g11518 | i0 | 65.4 | 10.8607594936709 | 52 | 17 | 98.7 | 1 | 158 | 3 | 148 | 198 | GFF41351.1 guanine nucleotide-binding protein subunit beta-like protein [Aspergillus udagawae] | diamond | 1716 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus udagawae | |
| 28960781 | 28960781 | PRJEB673_P_NODE_11848_length_158_cov_1.292683_g11499_i0 | PRJEB673 | 11848 | 158 | 1.292683 | 2.04243914 | Ogataea philodendri | 1378263 | Fungi | Fungi | 78.2 | 3.6e-15 | NR | XP_046058886.1 | 1378263 | g11499 | i0 | 70 | 1.89873417721519 | 50 | 15 | 94.9 | 0 | 150 | 1 | 103 | 152 | XP_046058886.1 uncharacterized protein OGAPHI_005960 [Ogataea philodendri] | diamond | 300 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Ogataea | Ogataea philodendri | |
| 28992380 | 28992380 | PRJEB673_P_NODE_11268_length_163_cov_1.234375_g10919_i0 | PRJEB673 | 11268 | 163 | 1.234375 | 2.01203125 | Saitoella complicata NRRL Y-178 | 5606 | Fungi | Fungi | 71.2 | 1.07e-12 | NR | XP_019026759.1 | 698492 | g10919 | i0 | 56.9 | 1.87730061349693 | 51 | 22 | 93.9 | 0 | 161 | 9 | 721 | 771 | XP_019026759.1 nitrate reductase NiaD [Saitoella complicata NRRL Y-17804] | diamond | 306 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saitoella | Saitoella complicata | ||||
| 29963802 | 29963802 | PRJEB673_P_NODE_10591_length_171_cov_2.051471_g10242_i0 | PRJEB673 | 10591 | 171 | 2.051471 | 3.50801541 | Ascomycota | 4890 | Fungi | Fungi | 88.2 | 1.64e-20 | NR | CEP22011.1 | 4903 | g10242 | i0 | 71.4 | 9.54385964912281 | 56 | 16 | 98.2 | 0 | 170 | 3 | 40 | 95 | CEP22011.1 unnamed protein product [Cyberlindnera jadinii] | diamond | 1632 | 89 | 0.991011235955056 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Phaffomycetaceae | Cyberlindnera | Cyberlindnera jadinii | |
| 30343401 | 30343401 | PRJEB673_P_NODE_9872_length_185_cov_1.826667_g9523_i0 | PRJEB673 | 9872 | 185 | 1.826667 | 3.37933395 | Ascomycota | 4890 | Fungi | Fungi | 63.9 | 5.33e-11 | NR | MCJ1233202.1 | 160984 | g9523 | i0 | 58.9 | 7.94594594594595 | 56 | 23 | 90.8 | 0 | 170 | 3 | 22 | 77 | MCJ1233202.1 60S ribosomal protein L18 [Varicellaria rhodocarpa] | diamond | 1470 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Pertusariales | Pertusariaceae | Varicellaria | Varicellaria rhodocarpa | |
| 30950592 | 30950592 | PRJEB673_P_NODE_9474_length_196_cov_1.391304_g9125_i0 | PRJEB673 | 9474 | 196 | 1.391304 | 2.72695584 | Brettanomyces nanus | 13502 | Fungi | Fungi | 80.5 | 1.6e-16 | NR | XP_038779566.1 | 13502 | g9125 | i0 | 63.1 | 5.96938775510204 | 65 | 18 | 99.5 | 1 | 2 | 196 | 51 | 109 | XP_038779566.1 40S ribosomal protein S6 [Brettanomyces nanus] | diamond | 1170 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Brettanomyces | Brettanomyces nanus | |
| 31045519 | 31045519 | PRJEB673_P_NODE_9695_length_190_cov_1.032258_g9346_i0 | PRJEB673 | 9695 | 190 | 1.032258 | 1.9612902 | Xylographa carneopallida | 1590122 | Fungi | Fungi | 47.8 | 3.23e-4 | NR | MCJ1289050.1 | 1590122 | g9346 | i0 | 51.4 | 0.58421052631579 | 37 | 18 | 58.4 | 0 | 130 | 20 | 10 | 46 | MCJ1289050.1 hypothetical protein [Xylographa carneopallida] | diamond | 111 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Baeomycetales | Xylographaceae | Xylographa | Xylographa carneopallida | |
| 31195567 | 31195567 | PRJEB673_P_NODE_10675_length_170_cov_1.548148_g10326_i0 | PRJEB673 | 10675 | 170 | 1.548148 | 2.6318516 | Ascomycota | 4890 | Fungi | Fungi | 75.1 | 5.38e-14 | NR | VEU19657.1 | 13370 | g10326 | i0 | 78 | 7.95882352941176 | 41 | 9 | 72.4 | 0 | 48 | 170 | 88 | 128 | VEU19657.1 DEKNAAC100258 [Brettanomyces naardenensis] | diamond | 1353 | 75.5 | 0.994701986754967 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Brettanomyces | Brettanomyces naardenensis | |
| 31456282 | 31456282 | PRJEB673_P_NODE_12976_length_150_cov_1.391304_g12627_i0 | PRJEB673 | 12976 | 150 | 1.391304 | 2.086956 | Fusarium anthophilum | 48485 | Fungi | Fungi | 44.3 | 5.69e-4 | NR | KAF5237302.1 | 48485 | g12627 | i0 | 71.4 | 0.56 | 28 | 8 | 56 | 0 | 1 | 84 | 58 | 85 | KAF5237302.1 hypothetical protein FANTH_10868 [Fusarium anthophilum] | diamond | 84 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium anthophilum | |
| 31480944 | 31480944 | PRJEB673_P_NODE_4956_length_409_cov_1.604278_g4608_i0 | PRJEB673 | 4956 | 409 | 1.604278 | 6.56149702 | Ascomycota | 4890 | Fungi | Fungi | 97.4 | 1.24e-22 | NR | KAJ2900401.1 | 339359 | g4608 | i0 | 75.8 | 7.73105134474328 | 62 | 14 | 45.5 | 1 | 4 | 189 | 101 | 161 | KAJ2900401.1 hypothetical protein MKZ38_002458 [Zalerion maritima] | diamond | 3162 | 97.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Lulworthiales | Lulworthiaceae | Zalerion | Zalerion maritima | |
| 31835547 | 31835547 | PRJEB673_P_NODE_12297_length_154_cov_2.882353_g11948_i0 | PRJEB673 | 12297 | 154 | 2.882353 | 4.43882362 | Talaromyces rugulosus | 121627 | Fungi | Fungi | 57.4 | 7.56e-8 | NR | XP_035343016.1 | 121627 | g11948 | i0 | 55.6 | 1.69480519480519 | 45 | 20 | 87.7 | 0 | 1 | 135 | 500 | 544 | XP_035343016.1 uncharacterized protein TRUGW13939_03945 [Talaromyces rugulosus] | diamond | 261 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces rugulosus | |
| 32208286 | 32208286 | PRJEB673_P_NODE_9758_length_188_cov_1.307190_g9409_i0 | PRJEB673 | 9758 | 188 | 1.30719 | 2.4575172 | Debaryomycetaceae | 766764 | Fungi | Fungi | 60.8 | 1.52e-9 | NR | CAK7894231.1 | 148631 | g9409 | i0 | 57.7 | 10.3404255319149 | 52 | 18 | 76.6 | 1 | 158 | 15 | 1 | 52 | CAK7894231.1 translationally-controlled tumor protein homolog [[Candida] anglica] | diamond | 1944 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Kurtzmaniella | [Candida] anglica | |
| 32783754 | 32783754 | PRJEB673_P_NODE_11880_length_158_cov_0.975610_g11531_i0 | PRJEB673 | 11880 | 158 | 0.97561 | 1.5414638 | Aspergillus chevalieri | 182096 | Fungi | Fungi | 73.9 | 8.74e-14 | NR | XP_043131684.1 | 182096 | g11531 | i0 | 69.1 | 1.04430379746835 | 55 | 13 | 96.8 | 2 | 155 | 3 | 216 | 270 | XP_043131684.1 fructose-1,6-bisphosphatase [Aspergillus chevalieri] | diamond | 165 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri |
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);;