contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJEB2333" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12776453 | 12776453 | PRJEB2333_P_NODE_1851_length_1052_cov_1.883744_g1169_i0 | PRJEB2333 | 1851 | 1052 | 1.883744 | 19.81698688 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 384 | 2.29e-128 | NR | KAH9259627.1 | 1357716 | g1169 | i0 | 81.9 | 1.41444866920152 | 248 | 44 | 70.7 | 1 | 289 | 1032 | 148 | 394 | KAH9259627.1 actin [Batrachochytrium salamandrivorans] | diamond | 1488 | 384 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 26716201 | 26716201 | PRJEB2333_P_NODE_3541_length_253_cov_1.634259_g2764_i0 | PRJEB2333 | 3541 | 253 | 1.634259 | 4.13467527 | Spizellomyces punctatus DAOM BR117 | 645134 | Fungi | Fungi | 91.7 | 1.89e-21 | NR | XP_016604005.1 | 645134 | g2764 | i0 | 63.1 | 3.98418972332016 | 84 | 30 | 98.4 | 1 | 3 | 251 | 28 | 111 | XP_016604005.1 40S ribosomal protein S16 [Spizellomyces punctatus DAOM BR117] | diamond | 1008 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 26773589 | 26773589 | PRJEB2333_P_NODE_3581_length_240_cov_2.660099_g2804_i0 | PRJEB2333 | 3581 | 240 | 2.660099 | 6.3842376 | Fungi | 4751 | Fungi | Fungi | 133 | 6.389999999999999e-38 | NR | TXT10985.1 | 5417 | g2804 | i0 | 75.9 | 130.5625 | 79 | 19 | 98.8 | 0 | 1 | 237 | 62 | 140 | TXT10985.1 hypothetical protein VHUM_01736 [Vanrija humicola] | diamond | 31335 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija humicola | |
| 27696950 | 27696950 | PRJEB2333_P_NODE_3084_length_434_cov_1.352645_g2309_i0 | PRJEB2333 | 3084 | 434 | 1.352645 | 5.8704793 | Pichia membranifaciens | 4926 | Fungi | Fungi | 77 | 7.08e-15 | NR | GAV28409.1 | 4926 | g2309 | i0 | 64.3 | 1.88709677419355 | 56 | 20 | 38.7 | 0 | 183 | 16 | 76 | 131 | GAV28409.1 60S ribosomal protein [Pichia membranifaciens] | diamond | 819 | 77 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Pichia | Pichia membranifaciens | |
| 27942856 | 27942856 | PRJEB2333_P_NODE_3265_length_408_cov_1.366577_g2489_i0 | PRJEB2333 | 3265 | 408 | 1.366577 | 5.57563416 | Agaricomycetes | 155619 | Fungi | Fungi | 72 | 1.89e-12 | NR | KAH9983893.1 | 40490 | g2489 | i0 | 33.6 | 9.61764705882353 | 134 | 72 | 97.8 | 2 | 400 | 2 | 56 | 173 | KAH9983893.1 ribosomal protein S19-domain-containing protein [Russula compacta] | diamond | 3924 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Russula | Russula compacta | |
| 28138887 | 28138887 | PRJEB2333_P_NODE_2585_length_548_cov_1.123288_g1816_i0 | PRJEB2333 | 2585 | 548 | 1.123288 | 6.15561824 | Nadsonia fulvescens var. elongata DSM 6958 | 857566 | Fungi | Fungi | 110 | 8.22e-27 | NR | ODQ66779.1 | 857566 | g1816 | i0 | 62.7 | 0.454379562043796 | 83 | 30 | 45.4 | 1 | 293 | 541 | 77 | 158 | ODQ66779.1 60S ribosomal protein L11-A, partial [Nadsonia fulvescens var. elongata DSM 6958] | diamond | 249 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Nadsonia | Nadsonia fulvescens | ||
| 28359511 | 28359511 | PRJEB2333_P_NODE_4506_length_161_cov_2.548387_g3729_i0 | PRJEB2333 | 4506 | 161 | 2.548387 | 4.10290307 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 89.4 | 7.76e-20 | NR | ORZ32491.1 | 765915 | g3729 | i0 | 83 | 7.90062111801242 | 53 | 9 | 98.8 | 0 | 159 | 1 | 147 | 199 | ORZ32491.1 60S ribosomal protein L7a [Catenaria anguillulae PL171] | diamond | 1272 | 89.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 28580794 | 28580794 | PRJEB2333_P_NODE_4167_length_176_cov_1.618705_g3390_i0 | PRJEB2333 | 4167 | 176 | 1.618705 | 2.8489208 | Auriculariopsis ampla | 97359 | Fungi | Fungi | 63.2 | 5.15e-11 | NR | TRM60718.1 | 97359 | g3390 | i0 | 60.8 | 4.43181818181818 | 51 | 20 | 86.9 | 0 | 24 | 176 | 1 | 51 | TRM60718.1 60s acidic ribosomal protein-domain-containing protein [Schizophyllum amplum] | diamond | 780 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Schizophyllaceae | Schizophyllum | Schizophyllum amplum | |
| 28637586 | 28637586 | PRJEB2333_P_NODE_2847_length_471_cov_1.456221_g2075_i0 | PRJEB2333 | 2847 | 471 | 1.456221 | 6.85880091 | Chytriomycetaceae | 1352827 | Fungi | Fungi | 75.9 | 1.19e-12 | NR | KAJ3201667.1 | 109932 | g2075 | i0 | 57.6 | 3.01273885350318 | 59 | 25 | 37.6 | 0 | 182 | 6 | 553 | 611 | KAJ3201667.1 hypothetical protein HDU82_007948 [Entophlyctis luteolus] | diamond | 1419 | 76.6 | 0.990861618798956 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Entophlyctis | Entophlyctis luteolus | |
| 28732140 | 28732140 | PRJEB2333_P_NODE_2987_length_447_cov_2.239024_g2213_i0 | PRJEB2333 | 2987 | 447 | 2.239024 | 10.00843728 | Pichiomycetes | 3239874 | Fungi | Fungi | 99.4 | 6.559999999999999e-23 | NR | ANZ77480.1 | 4922 | g2213 | i0 | 52.4 | 5.46308724832215 | 103 | 38 | 69.1 | 1 | 5 | 313 | 63 | 154 | ANZ77480.1 BA75_04938T0 [Komagataella pastoris] | diamond | 2442 | 100 | 0.994 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Komagataella | Komagataella pastoris | |
| 28732141 | 28732141 | PRJEB2333_P_NODE_3947_length_191_cov_1.519481_g3170_i0 | PRJEB2333 | 3947 | 191 | 1.519481 | 2.90220871 | Diversisporales | 214509 | Fungi | Fungi | 108 | 1.9e-27 | NR | CAG8523491.1 | 60492 | g3170 | i0 | 76.2 | 5.93717277486911 | 63 | 15 | 99 | 0 | 3 | 191 | 127 | 189 | CAG8523491.1 17401_t:CDS:2 [Racocetra fulgida] | diamond | 1134 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Racocetra | Racocetra fulgida | |
| 28770039 | 28770039 | PRJEB2333_P_NODE_4047_length_184_cov_1.455782_g3270_i0 | PRJEB2333 | 4047 | 184 | 1.455782 | 2.67863888 | Halteromyces radiatus | 101107 | Fungi | Fungi | 91.7 | 7.16e-21 | NR | XP_051398182.1 | 101107 | g3270 | i0 | 53.3 | 2.93478260869565 | 60 | 28 | 97.8 | 0 | 182 | 3 | 58 | 117 | XP_051398182.1 WD40-repeat-containing domain protein [Halteromyces radiatus] | diamond | 540 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Halteromyces | Halteromyces radiatus | |
| 29111111 | 29111111 | PRJEB2333_P_NODE_3188_length_419_cov_1.238220_g2413_i0 | PRJEB2333 | 3188 | 419 | 1.23822 | 5.1881418 | Eukaryota | 2759 | Fungi | Fungi | 69.7 | 1.72e-11 | NR | KAI9469279.1 | 4864 | g2413 | i0 | 82.9 | 8.52028639618139 | 35 | 6 | 25.1 | 0 | 419 | 315 | 116 | 150 | KAI9469279.1 ribosomal protein L15e [Coemansia mojavensis] | diamond | 3570 | 70.1 | 0.994293865905849 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia mojavensis | |
| 29464346 | 29464346 | PRJEB2333_P_NODE_2650_length_522_cov_1.311340_g1880_i0 | PRJEB2333 | 2650 | 522 | 1.31134 | 6.8451948 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 88.2 | 2.7e-17 | NR | KAH9260043.1 | 1357716 | g1880 | i0 | 52 | 0.862068965517241 | 75 | 30 | 43.1 | 1 | 521 | 297 | 243 | 311 | KAH9260043.1 hypothetical protein BASA81_001815 [Batrachochytrium salamandrivorans] | diamond | 450 | 88.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 29527974 | 29527974 | PRJEB2333_P_NODE_2810_length_478_cov_2.045351_g2038_i0 | PRJEB2333 | 2810 | 478 | 2.045351 | 9.77677778 | Kockovaella imperatae | 4999 | Fungi | Fungi | 192 | 1.26e-58 | NR | XP_021874725.1 | 4999 | g2038 | i0 | 56.9 | 6.89748953974895 | 160 | 68 | 99.8 | 1 | 1 | 477 | 72 | 231 | XP_021874725.1 putative 60s ribosomal protein l7 [Kockovaella imperatae] | diamond | 3297 | 192 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cuniculitremaceae | Kockovaella | Kockovaella imperatae | |
| 29995295 | 29995295 | PRJEB2333_P_NODE_3351_length_399_cov_1.071823_g2575_i0 | PRJEB2333 | 3351 | 399 | 1.071823 | 4.27657377 | Harpellales | 61421 | Fungi | Fungi | 45.4 | 0.00914 | NR | PVU93251.1 | 61424 | g2575 | i0 | 87 | 0.518796992481203 | 23 | 3 | 17.3 | 0 | 382 | 314 | 1 | 23 | PVU93251.1 hypothetical protein BB559_003379 [Furculomyces boomerangus] | diamond | 207 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 30381130 | 30381130 | PRJEB2333_P_NODE_3213_length_415_cov_1.748677_g2438_i0 | PRJEB2333 | 3213 | 415 | 1.748677 | 7.25700955 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 90.9 | 3.65e-19 | NR | XP_025600826.1 | 58919 | g2438 | i0 | 55.6 | 1.19277108433735 | 81 | 36 | 58.6 | 0 | 413 | 171 | 154 | 234 | XP_025600826.1 putative ribosomal protein S3aE [Tilletiopsis washingtonensis] | diamond | 495 | 90.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 30791459 | 30791459 | PRJEB2333_P_NODE_4454_length_163_cov_2.785714_g3677_i0 | PRJEB2333 | 4454 | 163 | 2.785714 | 4.54071382 | Acaulospora morrowiae | 94023 | Fungi | Fungi | 46.2 | 3.67e-4 | NR | CAG8540721.1 | 94023 | g3677 | i0 | 52 | 3.47852760736196 | 50 | 24 | 92 | 0 | 163 | 14 | 96 | 145 | CAG8540721.1 7834_t:CDS:2 [Acaulospora morrowiae] | diamond | 567 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Acaulosporaceae | Acaulospora | Acaulospora morrowiae | |
| 31006158 | 31006158 | PRJEB2333_P_NODE_4274_length_171_cov_1.455224_g3497_i0 | PRJEB2333 | 4274 | 171 | 1.455224 | 2.48843304 | Eukaryota | 2759 | Fungi | Fungi | 89.7 | 5.36e-20 | NR | KAJ3396077.1 | 109889 | g3497 | i0 | 71.4 | 12.7719298245614 | 56 | 16 | 98.2 | 0 | 169 | 2 | 12 | 67 | KAJ3396077.1 60S ribosomal protein L23 [Lobulomyces angularis] | diamond | 2184 | 90.1 | 0.995560488346282 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | Lobulomycetaceae | Lobulomyces | Lobulomyces angularis | |
| 31075953 | 31075953 | PRJEB2333_P_NODE_4275_length_171_cov_1.455224_g3498_i0 | PRJEB2333 | 4275 | 171 | 1.455224 | 2.48843304 | Xylographa carneopallida | 1590122 | Fungi | Fungi | 79 | 1.89e-16 | NR | MCJ1296998.1 | 1590122 | g3498 | i0 | 62.5 | 1.96491228070175 | 56 | 21 | 98.2 | 0 | 3 | 170 | 102 | 157 | MCJ1296998.1 Rho GTPase protein rac1 [Xylographa carneopallida] | diamond | 336 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Baeomycetales | Xylographaceae | Xylographa | Xylographa carneopallida | |
| 32119706 | 32119706 | PRJEB2333_P_NODE_3898_length_195_cov_1.727848_g3121_i0 | PRJEB2333 | 3898 | 195 | 1.727848 | 3.3693036 | Tilletiaria anomala UBC 951 | 1037660 | Fungi | Fungi | 84.7 | 2.12e-17 | NR | XP_013245366.1 | 1037660 | g3121 | i0 | 63.5 | 4.87692307692308 | 63 | 23 | 96.9 | 0 | 193 | 5 | 115 | 177 | XP_013245366.1 putative RPL3-60s ribosomal protein l3 [Tilletiaria anomala UBC 951] | diamond | 951 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Georgefischeriales | Tilletiariaceae | Tilletiaria | Tilletiaria anomala | |
| 32492961 | 32492961 | PRJEB2333_P_NODE_4019_length_186_cov_1.570470_g3242_i0 | PRJEB2333 | 4019 | 186 | 1.57047 | 2.9210742 | Ascomycota | 4890 | Fungi | Fungi | 85.1 | 3.69e-19 | NR | XP_069259469.1 | 28565 | g3242 | i0 | 64.5 | 19.4838709677419 | 62 | 22 | 100 | 0 | 186 | 1 | 49 | 110 | XP_069259469.1 40S ribosomal protein eS12 [Thermomyces dupontii] | diamond | 3624 | 85.5 | 0.9953216374269 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Thermomyces | Thermomyces dupontii | |
| 32751460 | 32751460 | PRJEB2333_P_NODE_4360_length_167_cov_1.084615_g3583_i0 | PRJEB2333 | 4360 | 167 | 1.084615 | 1.81130705 | Auriculariales sp. MPI-PUGE-AT- | 1916346 | Fungi | Fungi | 89 | 1.86e-19 | NR | KAH7105008.1 | 2829486 | g3583 | i0 | 78.2 | 7.90419161676647 | 55 | 12 | 98.8 | 0 | 165 | 1 | 211 | 265 | KAH7105008.1 mitochondrial carrier [Auriculariales sp. MPI-PUGE-AT-0066] | diamond | 1320 | 89 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Auriculariales | Auriculariales sp. MPI-PUGE-AT-0066 | |||
| 32776458 | 32776458 | PRJEB2333_P_NODE_3000_length_445_cov_1.531863_g2226_i0 | PRJEB2333 | 3000 | 445 | 1.531863 | 6.81679035 | Eukaryota | 2759 | Fungi | Fungi | 103 | 2.63e-25 | NR | KAJ1678875.1 | 68401 | g2226 | i0 | 72.9 | 5.88539325842697 | 59 | 16 | 39.8 | 0 | 267 | 443 | 59 | 117 | KAJ1678875.1 60S ribosomal protein L23 [Spiromyces aspiralis] | diamond | 2619 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces aspiralis | |
| 32782788 | 32782788 | PRJEB2333_P_NODE_3980_length_189_cov_1.407895_g3203_i0 | PRJEB2333 | 3980 | 189 | 1.407895 | 2.66092155 | Pseudomicrostroma glucosiphilum | 1684307 | Fungi | Fungi | 60.5 | 1.19e-9 | NR | XP_025348837.1 | 1684307 | g3203 | i0 | 51.9 | 0.857142857142857 | 54 | 26 | 85.7 | 0 | 189 | 28 | 73 | 126 | XP_025348837.1 ribosomal protein L24 [Pseudomicrostroma glucosiphilum] | diamond | 162 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Microstromatales | Pseudomicrostroma | Pseudomicrostroma glucosiphilum |
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);;