contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA450343" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15741722 | 15741722 | PRJNA450343_P_NODE_7573_length_196_cov_1.387755_g7505_i0 | PRJNA450343 | 7573 | 196 | 1.387755 | 2.7199998 | Orbilia brochopaga | 3140254 | Fungi | Fungi | 102 | 1.1e-26 | NR | KAF3921331.1 | 3140254 | g7505 | i0 | 74.6 | 3.9030612244898 | 63 | 16 | 96.4 | 0 | 189 | 1 | 18 | 80 | KAF3921331.1 Triakontatetraneuropeptide [Orbilia brochopaga] | diamond | 765 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Orbilia | Orbilia brochopaga | |
| 24665313 | 24665313 | PRJNA450343_P_NODE_7580_length_196_cov_1.387755_g7512_i0 | PRJNA450343 | 7580 | 196 | 1.387755 | 2.7199998 | Opisthokonta | 33154 | Fungi | Fungi | 104 | 3.29e-24 | NR | CAG8518996.1 | 27381 | g7512 | i0 | 70.3 | 201.658163265306 | 64 | 19 | 98 | 0 | 1 | 192 | 74 | 137 | CAG8518996.1 7929_t:CDS:2 [Funneliformis mosseae] | diamond | 39525 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Funneliformis | Funneliformis mosseae | |
| 27928946 | 27928946 | PRJNA450343_P_NODE_13385_length_162_cov_0.902655_g13317_i0 | PRJNA450343 | 13385 | 162 | 0.902655 | 1.4623011 | Gonapodya prolifera JEL478 | 1344416 | Fungi | Fungi | 72 | 2.01e-13 | NR | KXS15864.1 | 1344416 | g13317 | i0 | 57.4 | 2 | 54 | 23 | 100 | 0 | 162 | 1 | 62 | 115 | KXS15864.1 thioredoxin-like protein [Gonapodya prolifera JEL478] | diamond | 324 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Gonapodyaceae | Gonapodya | Gonapodya prolifera | |
| 27928950 | 27928950 | PRJNA450343_P_NODE_4485_length_251_cov_1.425743_g4417_i0 | PRJNA450343 | 4485 | 251 | 1.425743 | 3.57861493 | Calcarisporiella thermophila | 911321 | Fungi | Fungi | 87.4 | 3.17e-19 | NR | XP_069251615.1 | 911321 | g4417 | i0 | 58.2 | 3.75298804780877 | 67 | 28 | 80.1 | 0 | 201 | 1 | 3 | 69 | XP_069251615.1 uncharacterized protein VTP21DRAFT_1494 [Calcarisporiella thermophila] | diamond | 942 | 87.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila | ||
| 27945207 | 27945207 | PRJNA450343_P_NODE_5265_length_231_cov_1.681319_g5197_i0 | PRJNA450343 | 5265 | 231 | 1.681319 | 3.88384689 | Botryosphaeriales | 451869 | Fungi | Fungi | 103 | 2.0199999999999998e-24 | NR | OMP84831.1 | 420778 | g5197 | i0 | 60 | 5.84415584415584 | 75 | 30 | 97.4 | 0 | 225 | 1 | 1 | 75 | OMP84831.1 Guanine nucleotide-binding protein subunit beta-like protein, partial [Diplodia seriata] | diamond | 1350 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Botryosphaeriales | Botryosphaeriaceae | Diplodia | Diplodia seriata | |
| 28134754 | 28134754 | PRJNA450343_P_NODE_5165_length_233_cov_2.586957_g5097_i0 | PRJNA450343 | 5165 | 233 | 2.586957 | 6.02760981 | Eukaryota | 2759 | Fungi | Fungi | 92.8 | 1.13e-22 | NR | XP_047761105.1 | 5499 | g5097 | i0 | 66.2 | 13.9957081545064 | 68 | 23 | 87.6 | 0 | 217 | 14 | 1 | 68 | XP_047761105.1 60S ribosomal protein L38 [Fulvia fulva] | diamond | 3261 | 93.6 | 0.991452991452991 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Fulvia | Fulvia fulva | |
| 28229077 | 28229077 | PRJNA450343_P_NODE_3546_length_284_cov_1.561702_g3478_i0 | PRJNA450343 | 3546 | 284 | 1.561702 | 4.43523368 | Russula | 5402 | Fungi | Fungi | 81.6 | 1.26e-15 | NR | KAI0302165.1 | 98861 | g3478 | i0 | 44.8 | 6.4330985915493 | 87 | 47 | 90.8 | 1 | 7 | 264 | 258 | 344 | KAI0302165.1 L-methionine transporter [Russula brevipes] | diamond | 1827 | 81.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Russula | Russula brevipes | |
| 28560513 | 28560513 | PRJNA450343_P_NODE_13827_length_161_cov_0.910714_g13759_i0 | PRJNA450343 | 13827 | 161 | 0.910714 | 1.46624954 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 52.8 | 3.47e-6 | NR | KAH9259330.1 | 1357716 | g13759 | i0 | 59.1 | 0.819875776397516 | 44 | 18 | 82 | 0 | 9 | 140 | 269 | 312 | KAH9259330.1 hypothetical protein BASA81_002373 [Batrachochytrium salamandrivorans] | diamond | 132 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 29018973 | 29018973 | PRJNA450343_P_NODE_4008_length_266_cov_0.930876_g3940_i0 | PRJNA450343 | 4008 | 266 | 0.930876 | 2.47613016 | Opisthokonta | 33154 | Fungi | Fungi | 63.5 | 1.05e-10 | NR | KAJ5740150.1 | 1324776 | g3940 | i0 | 54.4 | 3.5187969924812 | 57 | 26 | 64.3 | 0 | 76 | 246 | 6 | 62 | KAJ5740150.1 Thioredoxin [Penicillium malachiteum] | diamond | 936 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium malachiteum | |
| 29334418 | 29334418 | PRJNA450343_P_NODE_7989_length_191_cov_1.880282_g7921_i0 | PRJNA450343 | 7989 | 191 | 1.880282 | 3.59133862 | Sordariomycetes | 147550 | Fungi | Fungi | 80.9 | 2.2e-18 | NR | KAH7367311.1 | 40658 | g7921 | i0 | 58.7 | 15.8167539267016 | 63 | 26 | 99 | 0 | 3 | 191 | 2 | 64 | KAH7367311.1 hypothetical protein B0T11DRAFT_221777, partial [Plectosphaerella cucumerina] | diamond | 3021 | 81.6 | 0.991421568627451 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Plectosphaerellaceae | Plectosphaerella | Plectosphaerella cucumerina | |
| 29444224 | 29444224 | PRJNA450343_P_NODE_8310_length_188_cov_1.374101_g8242_i0 | PRJNA450343 | 8310 | 188 | 1.374101 | 2.58330988 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 124 | 7.23e-34 | NR | KRH94902.1 | 146866 | g8242 | i0 | 100 | 0.98936170212766 | 62 | 0 | 98.9 | 0 | 188 | 3 | 30 | 91 | KRH94902.1 Ribosome Assembly protein, partial [Pseudoloma neurophilia] | diamond | 186 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29570648 | 29570648 | PRJNA450343_P_NODE_7130_length_201_cov_2.684211_g7062_i0 | PRJNA450343 | 7130 | 201 | 2.684211 | 5.39526411 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 53.9 | 2.21e-6 | NR | KAG1020290.1 | 64495 | g7062 | i0 | 52 | 6.71641791044776 | 50 | 24 | 74.6 | 0 | 154 | 5 | 9 | 58 | KAG1020290.1 hypothetical protein G6F26_009415 [Rhizopus arrhizus] | diamond | 1350 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 30186995 | 30186995 | PRJNA450343_P_NODE_5432_length_228_cov_1.139665_g5364_i0 | PRJNA450343 | 5432 | 228 | 1.139665 | 2.5984362 | Fungi | 4751 | Fungi | Fungi | 81.3 | 8.51e-16 | NR | KAF3925796.1 | 47266 | g5364 | i0 | 59.7 | 12.5921052631579 | 67 | 26 | 88.2 | 1 | 228 | 28 | 327 | 392 | KAF3925796.1 hypothetical protein ABW20_dc0101935 [Dactylellina cionopaga] | diamond | 2871 | 81.6 | 0.996323529411765 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Dactylellina | Dactylellina cionopaga | |
| 30297749 | 30297749 | PRJNA450343_P_NODE_7172_length_201_cov_1.269737_g7104_i0 | PRJNA450343 | 7172 | 201 | 1.269737 | 2.55217137 | Dispira parvispora | 1520584 | Fungi | Fungi | 56.6 | 4.31e-8 | NR | KAJ1968700.1 | 1520584 | g7104 | i0 | 46.2 | 4.8955223880597 | 65 | 35 | 97 | 0 | 196 | 2 | 26 | 90 | KAJ1968700.1 vacuolar ATPase V0 domain subunit c, partial [Dispira parvispora] | diamond | 984 | 56.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Dimargaritomycetes | Dimargaritales | Dimargaritaceae | Dispira | Dispira parvispora | |
| 31118475 | 31118475 | PRJNA450343_P_NODE_12215_length_164_cov_0.886957_g12147_i0 | PRJNA450343 | 12215 | 164 | 0.886957 | 1.45460948 | Aspergillus glaucus CBS 516.65 | 1160497 | Fungi | Fungi | 62 | 1.98e-9 | NR | XP_022395580.1 | 1160497 | g12147 | i0 | 77.8 | 0.658536585365854 | 36 | 8 | 65.9 | 0 | 3 | 110 | 108 | 143 | XP_022395580.1 uncharacterized protein ASPGLDRAFT_62203 [Aspergillus glaucus CBS 516.65] | diamond | 108 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 31166275 | 31166275 | PRJNA450343_P_NODE_7695_length_195_cov_1.047945_g7627_i0 | PRJNA450343 | 7695 | 195 | 1.047945 | 2.04349275 | Fungi | 4751 | Fungi | Fungi | 102 | 8.509999999999998e-24 | NR | AAN35157.1 | 109881 | g7627 | i0 | 67.2 | 9.84615384615385 | 64 | 21 | 98.5 | 0 | 2 | 193 | 168 | 231 | AAN35157.1 beta-tubulin, partial [Nowakowskiella elegans] | diamond | 1920 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Nowakowskiellaceae | Nowakowskiella | Nowakowskiella elegans | |
| 31213075 | 31213075 | PRJNA450343_P_NODE_11175_length_166_cov_0.871795_g11107_i0 | PRJNA450343 | 11175 | 166 | 0.871795 | 1.4471797 | Funneliformis caledonium | 1117310 | Fungi | Fungi | 68.6 | 7.35e-12 | NR | CAG8544615.1 | 1117310 | g11107 | i0 | 60 | 2.98192771084337 | 55 | 22 | 99.4 | 0 | 2 | 166 | 215 | 269 | CAG8544615.1 8699_t:CDS:2 [Funneliformis caledonium] | diamond | 495 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Funneliformis | Funneliformis caledonium | |
| 31593259 | 31593259 | PRJNA450343_P_NODE_11376_length_166_cov_0.871795_g11308_i0 | PRJNA450343 | 11376 | 166 | 0.871795 | 1.4471797 | Chytridium lagenaria | 64509 | Fungi | Fungi | 45.4 | 0.00144 | NR | KAI8833209.1 | 64509 | g11308 | i0 | 43.1 | 1.8433734939759 | 51 | 29 | 92.2 | 0 | 161 | 9 | 237 | 287 | KAI8833209.1 adaptin N terminal region-domain-containing protein [Chytridium lagenaria] | diamond | 306 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Chytridium | Chytridium lagenaria | |
| 31862184 | 31862184 | PRJNA450343_P_NODE_10757_length_167_cov_0.864407_g10689_i0 | PRJNA450343 | 10757 | 167 | 0.864407 | 1.44355969 | Opisthokonta | 33154 | Fungi | Fungi | 72 | 6.14e-13 | NR | KAI0065430.1 | 48021 | g10689 | i0 | 66 | 9 | 50 | 17 | 89.8 | 0 | 165 | 16 | 412 | 461 | KAI0065430.1 citrate synthase [Artomyces pyxidatus] | diamond | 1503 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Auriscalpiaceae | Artomyces | Artomyces pyxidatus | |
| 32321046 | 32321046 | PRJNA450343_P_NODE_11879_length_165_cov_0.879310_g11811_i0 | PRJNA450343 | 11879 | 165 | 0.87931 | 1.4508615 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 46.2 | 7.96e-4 | NR | KAH9258277.1 | 1357716 | g11811 | i0 | 45.8 | 0.872727272727273 | 48 | 26 | 87.3 | 0 | 153 | 10 | 521 | 568 | KAH9258277.1 hypothetical protein BASA81_003326 [Batrachochytrium salamandrivorans] | diamond | 144 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 32699634 | 32699634 | PRJNA450343_P_NODE_10180_length_170_cov_1.685950_g10112_i0 | PRJNA450343 | 10180 | 170 | 1.68595 | 2.866115 | Maudiozyma barnettii | 61262 | Fungi | Fungi | 64.7 | 6.37e-12 | NR | XP_041408628.1 | 61262 | g10112 | i0 | 63 | 0.811764705882353 | 46 | 17 | 81.2 | 0 | 4 | 141 | 37 | 82 | XP_041408628.1 long-chain fatty acid transporter ACB1 [Maudiozyma barnettii] | diamond | 138 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Maudiozyma | Maudiozyma barnettii | |
| 32715957 | 32715957 | PRJNA450343_P_NODE_4120_length_262_cov_0.957746_g4052_i0 | PRJNA450343 | 4120 | 262 | 0.957746 | 2.50929452 | Fungi | 4751 | Fungi | Fungi | 122 | 9.26e-33 | NR | XP_051394734.1 | 61397 | g4052 | i0 | 63.2 | 72.675572519084 | 87 | 32 | 99.6 | 0 | 1 | 261 | 28 | 114 | XP_051394734.1 rab protein 6 [Kickxella alabastrina] | diamond | 19041 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina |
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);;