contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA606583" and tax_clade = "Opisthokonta"
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 | |
| 27680637 | 27680637 | PRJNA606583_P_NODE_20104_length_266_cov_2.126638_g19675_i0 | PRJNA606583 | 20104 | 266 | 2.126638 | 5.65685708 | Entophlyctis helioformis | 281842 | Fungi | Fungi | 42.7 | 0.0492 | NR | KAI8923882.1 | 281842 | g19675 | i0 | 33.8 | 0.834586466165414 | 74 | 46 | 80.1 | 2 | 27 | 239 | 577 | 650 | KAI8923882.1 hypothetical protein BC831DRAFT_551805 [Entophlyctis helioformis] | diamond | 222 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis helioformis | |
| 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 | |
| 28406619 | 28406619 | PRJNA606583_P_NODE_41606_length_153_cov_1.344828_g41177_i0 | PRJNA606583 | 41606 | 153 | 1.344828 | 2.05758684 | Coccinella septempunctata | 41139 | Arthropoda | Arthropoda | 61.2 | 1.86e-9 | NR | XP_044764172.1 | 41139 | g41177 | i0 | 63.3 | 1.94117647058824 | 49 | 11 | 82.4 | 2 | 23 | 148 | 128 | 176 | XP_044764172.1 uncharacterized protein LOC123320804 [Coccinella septempunctata] | diamond | 297 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Coccinellidae | Coccinella | Coccinella septempunctata | |
| 28469842 | 28469842 | PRJNA606583_P_NODE_7946_length_480_cov_2.227991_g7526_i0 | PRJNA606583 | 7946 | 480 | 2.227991 | 10.6943568 | Galemys pyrenaicus | 202257 | Chordata | Chordata | 45.4 | 0.046 | NR | KAG8524031.1 | 202257 | g7526 | i0 | 37.9 | 0.54375 | 87 | 47 | 53.8 | 3 | 156 | 413 | 408 | 488 | KAG8524031.1 Serine/threonine-protein kinase WNK2 [Galemys pyrenaicus] | diamond | 261 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Talpidae | Galemys | Galemys pyrenaicus | |
| 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 | |
| 29858882 | 29858882 | PRJNA606583_P_NODE_39211_length_159_cov_1.475410_g38782_i0 | PRJNA606583 | 39211 | 159 | 1.47541 | 2.3459019 | Engystomops pustulosus | 76066 | Chordata | Chordata | 48.5 | 1.49e-5 | NR | KAG8576659.1 | 76066 | g38782 | i0 | 61.9 | 0.792452830188679 | 42 | 16 | 79.2 | 0 | 3 | 128 | 46 | 87 | KAG8576659.1 hypothetical protein GDO81_009926 [Engystomops pustulosus] | diamond | 126 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 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 | |
| 30269936 | 30269936 | PRJNA606583_P_NODE_36252_length_168_cov_1.190840_g35823_i0 | PRJNA606583 | 36252 | 168 | 1.19084 | 2.0006112 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 42.7 | 0.014 | NR | KAK3095181.1 | 66713 | g35823 | i0 | 45.5 | 3.94642857142857 | 44 | 24 | 78.6 | 0 | 10 | 141 | 243 | 286 | KAK3095181.1 hypothetical protein FSP39_011146 [Pinctada imbricata] | diamond | 663 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 30459674 | 30459674 | PRJNA606583_P_NODE_23473_length_235_cov_3.348485_g23044_i0 | PRJNA606583 | 23473 | 235 | 3.348485 | 7.86893975 | Mytilus edulis | 6550 | Mollusca | Mollusca | 47.8 | 5.19e-4 | NR | CAG2187267.1 | 6550 | g23044 | i0 | 44.6 | 0.714893617021277 | 56 | 25 | 63.8 | 2 | 155 | 6 | 192 | 247 | CAG2187267.1 unnamed protein product [Mytilus edulis] | diamond | 168 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 30490886 | 30490886 | PRJNA606583_P_NODE_36353_length_167_cov_4.300000_g35924_i0 | PRJNA606583 | 36353 | 167 | 4.3 | 7.181 | Camelus ferus | 419612 | Chordata | Chordata | 42.7 | 0.0135 | NR | EQB77592.1 | 419612 | g35924 | i0 | 51.2 | 0.736526946107784 | 41 | 20 | 73.7 | 0 | 28 | 150 | 2 | 42 | EQB77592.1 fizzy-related protein-like protein [Camelus ferus] | diamond | 123 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Camelidae | Camelus | Camelus ferus | |
| 30933243 | 30933243 | PRJNA606583_P_NODE_40434_length_156_cov_1.142857_g40005_i0 | PRJNA606583 | 40434 | 156 | 1.142857 | 1.78285692 | Timema bartmani | 61472 | Arthropoda | Arthropoda | 41.2 | 0.0113 | NR | CAD7451667.1 | 61472 | g40005 | i0 | 48.9 | 0.903846153846154 | 47 | 23 | 88.5 | 1 | 3 | 140 | 32 | 78 | CAD7451667.1 unnamed protein product [Timema bartmani] | diamond | 141 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema bartmani | |
| 31438848 | 31438848 | PRJNA606583_P_NODE_40596_length_155_cov_2.338983_g40167_i0 | PRJNA606583 | 40596 | 155 | 2.338983 | 3.62542365 | Polypterus senegalus | 55291 | Chordata | Chordata | 46.2 | 6e-4 | NR | XP_039600437.1 | 55291 | g40167 | i0 | 59 | 0.754838709677419 | 39 | 15 | 73.5 | 1 | 120 | 7 | 9 | 47 | XP_039600437.1 protein FAM3B-like isoform X2 [Polypterus senegalus] | diamond | 117 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 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 | ||
| 32040009 | 32040009 | PRJNA606583_P_NODE_24298_length_229_cov_1.901042_g23869_i0 | PRJNA606583 | 24298 | 229 | 1.901042 | 4.35338618 | Bufotes viridis | 30338 | Chordata | Chordata | 47.8 | 5.18e-4 | NR | CAK8629749.1 | 30338 | g23869 | i0 | 73.3 | 0.393013100436681 | 30 | 8 | 39.3 | 0 | 61 | 150 | 335 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 90 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 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 | |
| 32546442 | 32546442 | PRJNA606583_P_NODE_19179_length_276_cov_2.108787_g18750_i0 | PRJNA606583 | 19179 | 276 | 2.108787 | 5.82025212 | Parasitella parasitica | 35722 | Fungi | Fungi | 87.4 | 2.04e-20 | NR | KAI8637104.1 | 35722 | g18750 | i0 | 72.3 | 0.706521739130435 | 65 | 18 | 70.7 | 0 | 1 | 195 | 5 | 69 | KAI8637104.1 hypothetical protein BD408DRAFT_425109, partial [Parasitella parasitica] | diamond | 195 | 87.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Parasitella | Parasitella parasitica | |
| 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);;