contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA998413" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15007093 | 15007093 | PRJNA998413_S_NODE_7852_length_240_cov_1.135593_g7821_i0 | PRJNA998413 | 7852 | 240 | 1.135593 | 2.7254232 | Blyttiomyces sp. JEL | 2750429 | Fungi | Fungi | 121 | 5.49e-33 | NR | KAJ3329793.1 | 2724214 | g7821 | i0 | 82.5 | 1 | 80 | 14 | 100 | 0 | 240 | 1 | 83 | 162 | KAJ3329793.1 60S ribosomal protein L18 [Blyttiomyces sp. JEL0837] | diamond | 240 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Blyttiomyces | Blyttiomyces sp. JEL0837 | |||
| 16281893 | 16281893 | PRJNA998413_S_NODE_12613_length_211_cov_1.148649_g12582_i0 | PRJNA998413 | 12613 | 211 | 1.148649 | 2.42364939 | Coemansia | 4863 | Fungi | Fungi | 114 | 2.8e-30 | NR | PIA15605.1 | 763665 | g12582 | i0 | 68.6 | 6.93838862559242 | 70 | 22 | 99.5 | 0 | 210 | 1 | 80 | 149 | PIA15605.1 ubiquitin and ribosomal protein S27a-like protein [Coemansia reversa NRRL 1564] | diamond | 1464 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia reversa | |
| 27121018 | 27121018 | PRJNA998413_S_NODE_4342_length_286_cov_1.201794_g4311_i0 | PRJNA998413 | 4342 | 286 | 1.201794 | 3.43713084 | Sarocladium implicatum | 1610689 | Fungi | Fungi | 43.5 | 0.0331 | NR | KAH8172320.1 | 1610689 | g4311 | i0 | 79.2 | 0.251748251748252 | 24 | 5 | 25.2 | 0 | 1 | 72 | 495 | 518 | KAH8172320.1 reverse transcriptase (RNA-dependent DNA polymerase) domain-containing protein [Sarocladium implicatum] | diamond | 72 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium implicatum | |
| 27721968 | 27721968 | PRJNA998413_S_NODE_7804_length_240_cov_1.892655_g7773_i0 | PRJNA998413 | 7804 | 240 | 1.892655 | 4.542372 | Sarocladium strictum | 5046 | Fungi | Fungi | 51.2 | 2.56e-5 | NR | KAL2211635.1 | 5046 | g7773 | i0 | 89.7 | 0.3625 | 29 | 3 | 36.3 | 0 | 89 | 175 | 202 | 230 | KAL2211635.1 hypothetical protein CC79DRAFT_1363933 [Sarocladium strictum] | diamond | 87 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 28037379 | 28037379 | PRJNA998413_S_NODE_7305_length_245_cov_1.686813_g7274_i0 | PRJNA998413 | 7305 | 245 | 1.686813 | 4.13269185 | Armillaria solidipes | 1076256 | Fungi | Fungi | 122 | 4.769999999999999e-31 | NR | PBK65859.1 | 1076256 | g7274 | i0 | 100 | 1.9469387755102 | 53 | 0 | 64.9 | 0 | 1 | 159 | 332 | 384 | PBK65859.1 hypothetical protein ARMSODRAFT_1006344 [Armillaria solidipes] | diamond | 477 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Armillaria | Armillaria solidipes | |
| 28194946 | 28194946 | PRJNA998413_S_NODE_10506_length_219_cov_1.288462_g10475_i0 | PRJNA998413 | 10506 | 219 | 1.288462 | 2.82173178 | Pilatotrama ljubarskyi | 2735509 | Fungi | Fungi | 43.1 | 0.0063 | NR | KAI0369038.1 | 2735509 | g10475 | i0 | 36.1 | 0.986301369863014 | 72 | 44 | 98.6 | 1 | 4 | 219 | 40 | 109 | KAI0369038.1 hypothetical protein BV20DRAFT_423959 [Pilatotrama ljubarskyi] | diamond | 216 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Pilatotrama | Pilatotrama ljubarskyi | |
| 28447916 | 28447916 | PRJNA998413_S_NODE_12446_length_212_cov_0.899329_g12415_i0 | PRJNA998413 | 12446 | 212 | 0.899329 | 1.90657748 | Sarocladium strictum | 5046 | Fungi | Fungi | 83.2 | 6.12e-17 | NR | KAL2211892.1 | 5046 | g12415 | i0 | 87.5 | 0.566037735849057 | 40 | 5 | 56.6 | 0 | 211 | 92 | 287 | 326 | KAL2211892.1 nicotinamide N-methyltransferase [Sarocladium strictum] | diamond | 120 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 28479358 | 28479358 | PRJNA998413_S_NODE_4206_length_288_cov_2.697778_g4175_i0 | PRJNA998413 | 4206 | 288 | 2.697778 | 7.76960064 | Ophiocordyceps polyrhachis-furcata BCC 54312 | 1330021 | Fungi | Fungi | 82.4 | 7.32e-17 | NR | RCI16660.1 | 1330021 | g4175 | i0 | 58.5 | 0.854166666666667 | 82 | 33 | 84.4 | 1 | 276 | 34 | 135 | 216 | RCI16660.1 hypothetical protein L249_3291 [Ophiocordyceps polyrhachis-furcata BCC 54312] | diamond | 246 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Ophiocordyceps | Ophiocordyceps polyrhachis-furcata | |
| 28668879 | 28668879 | PRJNA998413_S_NODE_12347_length_212_cov_0.899329_g12316_i0 | PRJNA998413 | 12347 | 212 | 0.899329 | 1.90657748 | Mycena sp. CBHHK59/15 | 1940295 | Fungi | Fungi | 43.5 | 0.0125 | NR | KAJ6618920.1 | 1940295 | g12316 | i0 | 34.5 | 0.820754716981132 | 58 | 27 | 66.5 | 2 | 43 | 183 | 48 | 105 | KAJ6618920.1 hypothetical protein B0H10DRAFT_1794488 [Mycena sp. CBHHK59/15] | diamond | 174 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena sp. CBHHK59/15 | |
| 29148616 | 29148616 | PRJNA998413_S_NODE_9709_length_224_cov_1.664596_g9678_i0 | PRJNA998413 | 9709 | 224 | 1.664596 | 3.72869504 | Eukaryota | 2759 | Fungi | Fungi | 52 | 1.58e-5 | NR | QDS68068.1 | 50376 | g9678 | i0 | 57.5 | 3.83035714285714 | 40 | 17 | 53.6 | 0 | 3 | 122 | 160 | 199 | QDS68068.1 hypothetical protein FKW77_009870 [Venturia effusa] | diamond | 858 | 52.4 | 0.99236641221374 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Venturiaceae | Venturia | Venturia effusa | |
| 30500485 | 30500485 | PRJNA998413_S_NODE_6993_length_248_cov_2.443243_g6962_i0 | PRJNA998413 | 6993 | 248 | 2.443243 | 6.05924264 | Sarocladium strictum | 5046 | Fungi | Fungi | 72 | 4.59e-13 | NR | KAK0383648.1 | 5046 | g6962 | i0 | 69.6 | 0.67741935483871 | 56 | 17 | 67.7 | 0 | 1 | 168 | 171 | 226 | KAK0383648.1 hypothetical protein NLU13_9559 [Sarocladium strictum] | diamond | 168 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 30563319 | 30563319 | PRJNA998413_S_NODE_8033_length_238_cov_1.531429_g8002_i0 | PRJNA998413 | 8033 | 238 | 1.531429 | 3.64480102 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 52.8 | 1.02e-5 | NR | KAI9168422.1 | 1313167 | g8002 | i0 | 65.6 | 0.403361344537815 | 32 | 11 | 40.3 | 0 | 1 | 96 | 510 | 541 | KAI9168422.1 Dihydrosphingosine phosphate lyase [Blastocladiella emersonii ATCC 22665] | diamond | 96 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 30759154 | 30759154 | PRJNA998413_S_NODE_12614_length_211_cov_1.148649_g12583_i0 | PRJNA998413 | 12614 | 211 | 1.148649 | 2.42364939 | Agaricomycetes | 155619 | Fungi | Fungi | 73.9 | 2.25e-13 | NR | KAJ8473137.1 | 34470 | g12583 | i0 | 100 | 4.83412322274881 | 34 | 0 | 48.3 | 0 | 1 | 102 | 380 | 413 | KAJ8473137.1 hypothetical protein ONZ45_g16407 [Pleurotus djamor] | diamond | 1020 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Pleurotaceae | Pleurotus | Pleurotus djamor | |
| 31290315 | 31290315 | PRJNA998413_S_NODE_7295_length_245_cov_1.840659_g7264_i0 | PRJNA998413 | 7295 | 245 | 1.840659 | 4.50961455 | Sarocladium strictum | 5046 | Fungi | Fungi | 87.8 | 1.06e-19 | NR | KAK0385511.1 | 5046 | g7264 | i0 | 65 | 0.73469387755102 | 60 | 21 | 73.5 | 0 | 6 | 185 | 107 | 166 | KAK0385511.1 hypothetical protein NLU13_6691 [Sarocladium strictum] | diamond | 180 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 31480514 | 31480514 | PRJNA998413_S_NODE_10336_length_220_cov_1.280255_g10305_i0 | PRJNA998413 | 10336 | 220 | 1.280255 | 2.816561 | Infundibulicybe gibba | 378275 | Fungi | Fungi | 122 | 2.86e-33 | NR | KAF8888245.1 | 378275 | g10305 | i0 | 74 | 2.97272727272727 | 73 | 19 | 99.5 | 0 | 1 | 219 | 109 | 181 | KAF8888245.1 CAP domain-containing protein [Infundibulicybe gibba] | diamond | 654 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Infundibulicybe | Infundibulicybe gibba | ||
| 32176406 | 32176406 | PRJNA998413_S_NODE_6178_length_257_cov_2.530928_g6147_i0 | PRJNA998413 | 6178 | 257 | 2.530928 | 6.50448496 | Sarocladium strictum | 5046 | Fungi | Fungi | 49.7 | 1.03e-4 | NR | KAL2214572.1 | 5046 | g6147 | i0 | 100 | 0.280155642023346 | 24 | 0 | 28 | 0 | 1 | 72 | 189 | 212 | KAL2214572.1 hypothetical protein CC79DRAFT_151479 [Sarocladium strictum] | diamond | 72 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum |
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);;