contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA606583" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24809810 | 24809810 | PRJNA606583_P_NODE_10780_length_405_cov_2.429348_g10355_i0 | PRJNA606583 | 10780 | 405 | 2.429348 | 9.8388594 | Debaryomyces hansenii CBS767 | 284592 | Fungi | Fungi | 216 | 3.09e-62 | NR | XP_002770616.1 | 284592 | g10355 | i0 | 76.7 | 0.985185185185185 | 133 | 31 | 98.5 | 0 | 403 | 5 | 1338 | 1470 | XP_002770616.1 DEHA2G11297p [Debaryomyces hansenii CBS767] | diamond | 399 | 216 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 26668319 | 26668319 | PRJNA606583_P_NODE_29881_length_194_cov_1.656051_g29452_i0 | PRJNA606583 | 29881 | 194 | 1.656051 | 3.21273894 | Periconia digitata | 1303443 | Fungi | Fungi | 40 | 0.0299 | NR | CAI6342598.1 | 1303443 | g29452 | i0 | 55.3 | 0.587628865979381 | 38 | 17 | 58.8 | 0 | 79 | 192 | 1 | 38 | CAI6342598.1 unnamed protein product [Periconia digitata] | diamond | 114 | 40 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Periconiaceae | Periconia | Periconia digitata | |
| 27111578 | 27111578 | PRJNA606583_P_NODE_21542_length_252_cov_3.032558_g21113_i0 | PRJNA606583 | 21542 | 252 | 3.032558 | 7.64204616 | Debaryomyces hansenii CBS767 | 284592 | Fungi | Fungi | 60.1 | 3.4e-8 | NR | XP_002770616.1 | 284592 | g21113 | i0 | 32.5 | 1.77380952380952 | 83 | 56 | 98.8 | 0 | 1 | 249 | 25 | 107 | XP_002770616.1 DEHA2G11297p [Debaryomyces hansenii CBS767] | diamond | 447 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 28343368 | 28343368 | PRJNA606583_P_NODE_18326_length_285_cov_2.495968_g17897_i0 | PRJNA606583 | 18326 | 285 | 2.495968 | 7.1135088 | Thermothielavioides terrestris NRRL 8126 | 578455 | Fungi | Fungi | 43.1 | 0.0423 | NR | XP_003650942.1 | 578455 | g17897 | i0 | 35.4 | 0.863157894736842 | 82 | 42 | 74.7 | 2 | 259 | 47 | 96 | 177 | XP_003650942.1 uncharacterized protein THITE_2126926 [Thermothielavioides terrestris NRRL 8126] | diamond | 246 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Chaetomiaceae | Thermothielavioides | Thermothielavioides terrestris | |
| 28659255 | 28659255 | PRJNA606583_P_NODE_31567_length_186_cov_1.912752_g31138_i0 | PRJNA606583 | 31567 | 186 | 1.912752 | 3.55771872 | Debaryomyces hansenii CBS767 | 284592 | Fungi | Fungi | 55.5 | 5.63e-7 | NR | XP_002770616.1 | 284592 | g31138 | i0 | 55.7 | 0.983870967741935 | 61 | 25 | 98.4 | 1 | 3 | 185 | 478 | 536 | XP_002770616.1 DEHA2G11297p [Debaryomyces hansenii CBS767] | diamond | 183 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 28816690 | 28816690 | PRJNA606583_P_NODE_25328_length_221_cov_2.190217_g24899_i0 | PRJNA606583 | 25328 | 221 | 2.190217 | 4.84037957 | Debaryomyces hansenii CBS767 | 284592 | Fungi | Fungi | 73.2 | 1.33e-14 | NR | XP_458168.2 | 284592 | g24899 | i0 | 62.7 | 0.800904977375566 | 59 | 22 | 80.1 | 0 | 3 | 179 | 58 | 116 | XP_458168.2 DEHA2C11352p [Debaryomyces hansenii CBS767] | diamond | 177 | 73.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 28880029 | 28880029 | PRJNA606583_P_NODE_26768_length_212_cov_1.337143_g26339_i0 | PRJNA606583 | 26768 | 212 | 1.337143 | 2.83474316 | [Candida] anglica | 148631 | Fungi | Fungi | 81.6 | 4.86e-16 | NR | CAK7920010.1 | 148631 | g26339 | i0 | 55.1 | 0.976415094339623 | 69 | 29 | 97.6 | 1 | 211 | 5 | 479 | 545 | CAK7920010.1 putative LAGLIDADG endonuclease [[Candida] anglica] | diamond | 207 | 81.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Kurtzmaniella | [Candida] anglica | |
| 29764009 | 29764009 | PRJNA606583_P_NODE_24331_length_229_cov_1.421875_g23902_i0 | PRJNA606583 | 24331 | 229 | 1.421875 | 3.25609375 | [Candida] anglica | 148631 | Fungi | Fungi | 55.5 | 9.91e-7 | NR | CAK7920010.1 | 148631 | g23902 | i0 | 71.4 | 1.37554585152838 | 35 | 10 | 45.9 | 0 | 3 | 107 | 689 | 723 | CAK7920010.1 putative LAGLIDADG endonuclease [[Candida] anglica] | diamond | 315 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Kurtzmaniella | [Candida] anglica | |
| 29890706 | 29890706 | PRJNA606583_P_NODE_34111_length_175_cov_2.311594_g33682_i0 | PRJNA606583 | 34111 | 175 | 2.311594 | 4.0452895 | Debaryomyces hansenii CBS767 | 284592 | Fungi | Fungi | 102 | 1.06e-23 | NR | XP_002770616.1 | 284592 | g33682 | i0 | 81 | 0.994285714285714 | 58 | 11 | 99.4 | 0 | 175 | 2 | 720 | 777 | XP_002770616.1 DEHA2G11297p [Debaryomyces hansenii CBS767] | diamond | 174 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 30156179 | 30156179 | PRJNA606583_P_NODE_36472_length_167_cov_1.707692_g36043_i0 | PRJNA606583 | 36472 | 167 | 1.707692 | 2.85184564 | root | 1 | Root_unresolved | Root_unresolved | 89 | 6.89e-19 | NR | KAF2151510.1 | 1168546 | g36043 | i0 | 67.3 | 2.74850299401198 | 49 | 16 | 88 | 0 | 162 | 16 | 189 | 237 | KAF2151510.1 glycoside hydrolase family 2 protein [Myriangium duriaei CBS 260.36] | diamond | 459 | 89.7 | 0.992196209587514 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Myriangiales | Myriangiaceae | Myriangium | Myriangium duriaei | |
| 31452276 | 31452276 | PRJNA606583_P_NODE_39896_length_157_cov_1.625000_g39467_i0 | PRJNA606583 | 39896 | 157 | 1.625 | 2.55125 | Debaryomyces | 4958 | Fungi | Fungi | 80.1 | 7.41e-16 | NR | YP_001621419.1 | 4959 | g39467 | i0 | 76.5 | 1.94904458598726 | 51 | 12 | 97.5 | 0 | 3 | 155 | 420 | 470 | YP_001621419.1 endonuclease [Debaryomyces hansenii] | diamond | 306 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 31881619 | 31881619 | PRJNA606583_P_NODE_37857_length_163_cov_0.928571_g37428_i0 | PRJNA606583 | 37857 | 163 | 0.928571 | 1.51357073 | Yarrowia galli | 197054 | Fungi | Fungi | 95.5 | 5.47e-22 | NR | YP_004927411.1 | 197054 | g37428 | i0 | 90.6 | 0.975460122699387 | 53 | 5 | 97.5 | 0 | 161 | 3 | 170 | 222 | YP_004927411.1 mitochondrial ribosomal protein Var1/Rps3 [Yarrowia galli] | diamond | 159 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia galli | ||
| 32230029 | 32230029 | PRJNA606583_P_NODE_40618_length_155_cov_2.245763_g40189_i0 | PRJNA606583 | 40618 | 155 | 2.245763 | 3.48093265 | Debaryomyces hansenii CBS767 | 284592 | Fungi | Fungi | 72.8 | 2.82e-13 | NR | XP_002770116.1 | 284592 | g40189 | i0 | 58.8 | 0.987096774193548 | 51 | 21 | 98.7 | 0 | 154 | 2 | 562 | 612 | XP_002770116.1 DEHA2B12787p [Debaryomyces hansenii CBS767] | diamond | 153 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 32387991 | 32387991 | PRJNA606583_P_NODE_33399_length_178_cov_1.744681_g32970_i0 | PRJNA606583 | 33399 | 178 | 1.744681 | 3.10553218 | Debaryomyces tyrocola | 522358 | Fungi | Fungi | 64.7 | 2.7e-10 | NR | CUM49890.1 | 522358 | g32970 | i0 | 58.6 | 1.8876404494382 | 58 | 24 | 97.8 | 0 | 175 | 2 | 324 | 381 | CUM49890.1 unnamed protein product [Debaryomyces tyrocola] | diamond | 336 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces tyrocola | |
| 32735417 | 32735417 | PRJNA606583_P_NODE_13280_length_357_cov_2.331250_g12852_i0 | PRJNA606583 | 13280 | 357 | 2.33125 | 8.3225625 | Debaryomyces hansenii CBS767 | 284592 | Fungi | Fungi | 169 | 8.11e-46 | NR | XP_002770616.1 | 284592 | g12852 | i0 | 72 | 1.98319327731092 | 118 | 32 | 99.2 | 1 | 2 | 355 | 1175 | 1291 | XP_002770616.1 DEHA2G11297p [Debaryomyces hansenii CBS767] | diamond | 708 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii |
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);;