contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA1073005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6564941 | 6564941 | PRJNA1073005_P_NODE_5066_length_423_cov_1.320000_g4947_i0 | PRJNA1073005 | 5066 | 423 | 1.32 | 5.5836 | Ascomycota | 4890 | Fungi | Fungi | 223 | 6.97e-70 | NR | KAK5796054.1 | 5077 | g4947 | i0 | 73.6 | 5.97163120567376 | 140 | 37 | 99.3 | 0 | 3 | 422 | 83 | 222 | KAK5796054.1 hypothetical protein VI817_005339 [Penicillium citrinum] | diamond | 2526 | 225 | 0.991111111111111 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium citrinum | |
| 26972390 | 26972390 | PRJNA1073005_P_NODE_9442_length_248_cov_0.880000_g9323_i0 | PRJNA1073005 | 9442 | 248 | 0.88 | 2.1824 | Aspergillus nanangensis | 2582783 | Fungi | Fungi | 42.7 | 0.0392 | NR | KAF9894478.1 | 2582783 | g9323 | i0 | 38.7 | 0.75 | 62 | 36 | 75 | 1 | 203 | 18 | 78 | 137 | KAF9894478.1 hypothetical protein FE257_006361 [Aspergillus nanangensis] | diamond | 186 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus nanangensis | |
| 27161949 | 27161949 | PRJNA1073005_P_NODE_9022_length_251_cov_0.865169_g8903_i0 | PRJNA1073005 | 9022 | 251 | 0.865169 | 2.17157419 | Kluyveromyces marxianus DMKU3-1 | 4911 | Fungi | Fungi | 64.7 | 9.67e-11 | NR | XP_022676417.1 | 1003335 | g8903 | i0 | 54.9 | 4.37450199203187 | 51 | 23 | 61 | 0 | 95 | 247 | 28 | 78 | XP_022676417.1 uncharacterized protein KLMA_40572 [Kluyveromyces marxianus DMKU3-1042] | diamond | 1098 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Kluyveromyces | Kluyveromyces marxianus | |
| 27280266 | 27280266 | PRJNA1073005_P_NODE_7943_length_285_cov_1.193396_g7824_i0 | PRJNA1073005 | 7943 | 285 | 1.193396 | 3.4011786 | Eukaryota | 2759 | Fungi | Fungi | 97.1 | 5e-21 | NR | XP_062875422.1 | 291208 | g7824 | i0 | 51.1 | 3.95789473684211 | 94 | 46 | 98.9 | 0 | 2 | 283 | 200 | 293 | XP_062875422.1 uncharacterized protein PUMCH_000259 [Australozyma saopauloensis] | diamond | 1128 | 97.4 | 0.996919917864476 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Australozyma | Australozyma saopauloensis | |
| 27288609 | 27288609 | PRJNA1073005_P_NODE_9703_length_246_cov_0.890173_g9584_i0 | PRJNA1073005 | 9703 | 246 | 0.890173 | 2.18982558 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 94 | 1.42e-20 | NR | XP_069230582.1 | 1052096 | g9584 | i0 | 70.8 | 0.878048780487805 | 72 | 17 | 82.9 | 1 | 209 | 6 | 1 | 72 | XP_069230582.1 uncharacterized protein WHR41_03805 [Cladosporium halotolerans] | diamond | 216 | 94 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 27320337 | 27320337 | PRJNA1073005_P_NODE_8023_length_282_cov_1.612440_g7904_i0 | PRJNA1073005 | 8023 | 282 | 1.61244 | 4.5470808 | Coniosporium uncinatum | 93489 | Fungi | Fungi | 107 | 1.51e-24 | NR | KAK3065466.1 | 93489 | g7904 | i0 | 58.7 | 1.9468085106383 | 92 | 37 | 96.8 | 1 | 275 | 3 | 209 | 300 | KAK3065466.1 hypothetical protein LTS18_006177 [Coniosporium uncinatum] | diamond | 549 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Coniosporium | Coniosporium uncinatum | |||
| 27888545 | 27888545 | PRJNA1073005_P_NODE_9605_length_246_cov_1.335260_g9486_i0 | PRJNA1073005 | 9605 | 246 | 1.33526 | 3.2847396 | Ascodesmis nigricans | 341454 | Fungi | Fungi | 54.7 | 1.73e-6 | NR | TGZ84292.1 | 341454 | g9486 | i0 | 46.3 | 0.975609756097561 | 80 | 41 | 95.1 | 1 | 237 | 4 | 1 | 80 | TGZ84292.1 60S ribosomal protein L7 [Ascodesmis nigricans] | diamond | 240 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Ascodesmidaceae | Ascodesmis | Ascodesmis nigricans | |
| 28962409 | 28962409 | PRJNA1073005_P_NODE_8688_length_259_cov_1.456989_g8569_i0 | PRJNA1073005 | 8688 | 259 | 1.456989 | 3.77360151 | Phaeosphaeria sp. MPI-PUGE-AT- | 1715242 | Fungi | Fungi | 140 | 1.31e-36 | NR | KAH7398828.1 | 2821754 | g8569 | i0 | 95.3 | 0.996138996138996 | 86 | 4 | 99.6 | 0 | 258 | 1 | 614 | 699 | KAH7398828.1 ketopantoate reductase PanE/ApbA-domain-containing protein [Phaeosphaeria sp. MPI-PUGE-AT-0046c] | diamond | 258 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Phaeosphaeria | Phaeosphaeria sp. MPI-PUGE-AT-0046c | |
| 28994031 | 28994031 | PRJNA1073005_P_NODE_4728_length_446_cov_1.032172_g4609_i0 | PRJNA1073005 | 4728 | 446 | 1.032172 | 4.60348712 | Orbilia oligospora | 2813651 | Fungi | Fungi | 198 | 1.1699999999999999e-60 | NR | KAF3225157.1 | 2813651 | g4609 | i0 | 65.1 | 43.0896860986547 | 149 | 51 | 99.6 | 1 | 445 | 2 | 75 | 223 | KAF3225157.1 hypothetical protein TWF191_005448 [Orbilia oligospora] | diamond | 19218 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Orbilia | Orbilia oligospora | |
| 29120261 | 29120261 | PRJNA1073005_P_NODE_10109_length_243_cov_0.905882_g9990_i0 | PRJNA1073005 | 10109 | 243 | 0.905882 | 2.20129326 | Cenococcum geophilum 1.58 | 794803 | Fungi | Fungi | 83.6 | 7.69e-17 | NR | XP_067500059.1 | 794803 | g9990 | i0 | 57.9 | 0.703703703703704 | 57 | 24 | 70.4 | 0 | 60 | 230 | 4 | 60 | XP_067500059.1 alcohol dehydrogenase [Cenococcum geophilum 1.58] | diamond | 171 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Gloniales | Gloniaceae | Cenococcum | Cenococcum geophilum | |
| 29624739 | 29624739 | PRJNA1073005_P_NODE_8030_length_282_cov_1.301435_g7911_i0 | PRJNA1073005 | 8030 | 282 | 1.301435 | 3.6700467 | Eremothecium cymbalariae DBVPG#7215 | 931890 | Fungi | Fungi | 47 | 0.00197 | NR | XP_003645382.1 | 931890 | g7911 | i0 | 37.3 | 0.882978723404255 | 83 | 47 | 83 | 2 | 273 | 40 | 608 | 690 | XP_003645382.1 DEAH-box ATP-dependent RNA helicase PRP43 Ecym_3053 [Eremothecium cymbalariae DBVPG#7215] | diamond | 249 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Eremothecium | Eremothecium cymbalariae | |
| 29656369 | 29656369 | PRJNA1073005_P_NODE_9050_length_250_cov_1.598870_g8931_i0 | PRJNA1073005 | 9050 | 250 | 1.59887 | 3.997175 | Exophiala aquamarina CBS 119918 | 1182545 | Fungi | Fungi | 61.6 | 8.74e-9 | NR | XP_013253697.1 | 1182545 | g8931 | i0 | 93.5 | 0.744 | 31 | 2 | 37.2 | 0 | 156 | 248 | 1 | 31 | XP_013253697.1 uncharacterized protein A1O9_12830 [Exophiala aquamarina CBS 119918] | diamond | 186 | 61.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala aquamarina | |
| 29774484 | 29774484 | PRJNA1073005_P_NODE_8051_length_281_cov_1.471154_g7932_i0 | PRJNA1073005 | 8051 | 281 | 1.471154 | 4.13394274 | Herpotrichiellaceae | 43219 | Fungi | Fungi | 183 | 2.0599999999999998e-54 | NR | KAK5254524.1 | 348802 | g7932 | i0 | 93.5 | 4.94306049822064 | 93 | 6 | 99.3 | 0 | 279 | 1 | 132 | 224 | KAK5254524.1 hypothetical protein LTR40_010986 [Exophiala xenobiotica] | diamond | 1389 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala xenobiotica | |
| 29941188 | 29941188 | PRJNA1073005_P_NODE_8251_length_274_cov_1.482587_g8132_i0 | PRJNA1073005 | 8251 | 274 | 1.482587 | 4.06228838 | Verruconis gallopava | 253628 | Fungi | Fungi | 132 | 1.84e-34 | NR | XP_016219307.1 | 253628 | g8132 | i0 | 69.2 | 0.996350364963504 | 91 | 28 | 99.6 | 0 | 2 | 274 | 269 | 359 | XP_016219307.1 uncharacterized protein PV09_00323 [Verruconis gallopava] | diamond | 273 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Sympoventuriaceae | Verruconis | Verruconis gallopava | |
| 30027444 | 30027444 | PRJNA1073005_P_NODE_7971_length_284_cov_1.374408_g7852_i0 | PRJNA1073005 | 7971 | 284 | 1.374408 | 3.90331872 | Exophiala | 5583 | Fungi | Fungi | 49.7 | 2.21e-4 | NR | XP_016258438.1 | 215243 | g7852 | i0 | 76.7 | 0.633802816901408 | 30 | 7 | 31.7 | 0 | 131 | 42 | 65 | 94 | XP_016258438.1 uncharacterized protein PV06_09206 [Exophiala oligosperma] | diamond | 180 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala oligosperma | |
| 30185209 | 30185209 | PRJNA1073005_P_NODE_7212_length_315_cov_0.954545_g7093_i0 | PRJNA1073005 | 7212 | 315 | 0.954545 | 3.00681675 | Schizosaccharomyces | 4895 | Fungi | Fungi | 136 | 6.22e-35 | NR | NP_593377.1 | 4896 | g7093 | i0 | 65.1 | 8.09523809523809 | 106 | 32 | 98.1 | 2 | 5 | 313 | 334 | 437 | NP_593377.1 major poly(A) binding protein Pabp/Pab1 [Schizosaccharomyces pombe] | diamond | 2550 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe | |
| 30509714 | 30509714 | PRJNA1073005_P_NODE_8353_length_271_cov_1.106061_g8234_i0 | PRJNA1073005 | 8353 | 271 | 1.106061 | 2.99742531 | Nemania sp. FL | 1912656 | Fungi | Fungi | 42.7 | 0.0497 | NR | KAI1174176.1 | 2614608 | g8234 | i0 | 43.1 | 0.564575645756458 | 51 | 21 | 47.6 | 2 | 148 | 20 | 121 | 171 | KAI1174176.1 CaaX protease [Nemania sp. FL0916] | diamond | 153 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Nemania | Nemania sp. FL0916 | |
| 30983831 | 30983831 | PRJNA1073005_P_NODE_10054_length_243_cov_0.905882_g9935_i0 | PRJNA1073005 | 10054 | 243 | 0.905882 | 2.20129326 | Exophiala aquamarina CBS 119918 | 1182545 | Fungi | Fungi | 90.1 | 6.88e-19 | NR | XP_013264212.1 | 1182545 | g9935 | i0 | 86.5 | 0.641975308641975 | 52 | 7 | 64.2 | 0 | 86 | 241 | 1 | 52 | XP_013264212.1 uncharacterized protein A1O9_03190 [Exophiala aquamarina CBS 119918] | diamond | 156 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala aquamarina | |
| 31070166 | 31070166 | PRJNA1073005_P_NODE_8975_length_251_cov_0.865169_g8856_i0 | PRJNA1073005 | 8975 | 251 | 0.865169 | 2.17157419 | Exophiala | 5583 | Fungi | Fungi | 152 | 5.24e-43 | NR | XP_013259713.1 | 1182545 | g8856 | i0 | 85.5 | 1.9840637450199201 | 83 | 12 | 99.2 | 0 | 2 | 250 | 202 | 284 | XP_013259713.1 adenosine deaminase [Exophiala aquamarina CBS 119918] | diamond | 498 | 153 | 0.993464052287582 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala aquamarina | |
| 31132861 | 31132861 | PRJNA1073005_P_NODE_8255_length_274_cov_1.338308_g8136_i0 | PRJNA1073005 | 8255 | 274 | 1.338308 | 3.66696392 | Aspergillus | 5052 | Fungi | Fungi | 126 | 2.71e-33 | NR | XP_043144270.1 | 91492 | g8136 | i0 | 78 | 5.85766423357664 | 91 | 20 | 99.6 | 0 | 2 | 274 | 25 | 115 | XP_043144270.1 uncharacterized protein Aud_003385 [Aspergillus udagawae] | diamond | 1605 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus udagawae | |
| 31268104 | 31268104 | PRJNA1073005_P_NODE_9855_length_245_cov_0.895349_g9736_i0 | PRJNA1073005 | 9855 | 245 | 0.895349 | 2.19360505 | Exophiala oligosperma | 215243 | Fungi | Fungi | 115 | 1.26e-31 | NR | XP_016268788.1 | 215243 | g9736 | i0 | 78.5 | 1.59183673469388 | 65 | 14 | 79.6 | 0 | 195 | 1 | 1 | 65 | XP_016268788.1 uncharacterized protein PV06_01145 [Exophiala oligosperma] | diamond | 390 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala oligosperma |
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);;