contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA557895" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27346002 | 27346002 | PRJNA557895_P_NODE_16803_length_224_cov_2.028571_g16448_i0 | PRJNA557895 | 16803 | 224 | 2.028571 | 4.54399904 | root | 1 | Root_unresolved | Root_unresolved | 42.4 | 0.0399 | NR | CAF9940687.1 | 116794 | g16448 | i0 | 34.8 | 1.76785714285714 | 66 | 38 | 87.1 | 2 | 198 | 4 | 303 | 364 | CAF9940687.1 MAG: hypothetical protein HETSPECPRED_002611 [Heterodermia speciosa] | diamond | 396 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Caliciales | Physciaceae | Heterodermia | Heterodermia speciosa | |
| 27630182 | 27630182 | PRJNA557895_P_NODE_34644_length_164_cov_0.886957_g34289_i0 | PRJNA557895 | 34644 | 164 | 0.886957 | 1.45460948 | Ascomycota | 4890 | Fungi | Fungi | 78.6 | 2.98e-15 | NR | KAI6715519.1 | 946123 | g34289 | i0 | 68.5 | 43.390243902439 | 54 | 17 | 98.8 | 0 | 3 | 164 | 29 | 82 | KAI6715519.1 hypothetical protein JHW43_001872 [Diplocarpon mali] | diamond | 7116 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Drepanopezizaceae | Diplocarpon | Diplocarpon mali | |
| 28563260 | 28563260 | PRJNA557895_P_NODE_14947_length_238_cov_1.296296_g14592_i0 | PRJNA557895 | 14947 | 238 | 1.296296 | 3.08518448 | Elasticomyces elasticus | 574655 | Fungi | Fungi | 67 | 9.73e-11 | NR | KAK3639982.1 | 574655 | g14592 | i0 | 61.2 | 8.89915966386555 | 49 | 19 | 61.8 | 0 | 148 | 2 | 218 | 266 | KAK3639982.1 Myo-inositol-1-phosphate synthase [Elasticomyces elasticus] | diamond | 2118 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Elasticomyces | Elasticomyces elasticus | |
| 28640583 | 28640583 | PRJNA557895_P_NODE_3747_length_494_cov_2.249438_g3400_i0 | PRJNA557895 | 3747 | 494 | 2.249438 | 11.11222372 | Aspergillus | 5052 | Fungi | Fungi | 53.1 | 1.15e-4 | NR | OOF96222.1 | 602072 | g3400 | i0 | 31.5 | 1.54251012145749 | 127 | 69 | 75.3 | 3 | 4 | 375 | 745 | 856 | OOF96222.1 hypothetical protein ASPCADRAFT_206421 [Aspergillus carbonarius ITEM 5010] | diamond | 762 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus carbonarius | |
| 29384220 | 29384220 | PRJNA557895_P_NODE_36669_length_162_cov_1.026549_g36314_i0 | PRJNA557895 | 36669 | 162 | 1.026549 | 1.66300938 | Aspergillus sp. HF37 | 1960876 | Fungi | Fungi | 76.3 | 1.83e-14 | NR | RMJ28895.1 | 1960876 | g36314 | i0 | 78.6 | 8.66666666666667 | 42 | 9 | 77.8 | 0 | 159 | 34 | 401 | 442 | RMJ28895.1 transcription initiation factor RRN7 [Aspergillus sp. HF37] | diamond | 1404 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus sp. HF37 | |
| 30882769 | 30882769 | PRJNA557895_P_NODE_35574_length_163_cov_0.894737_g35219_i0 | PRJNA557895 | 35574 | 163 | 0.894737 | 1.45842131 | Fungi | 4751 | Fungi | Fungi | 66.2 | 6.48e-11 | NR | KAF7999704.1 | 27326 | g35219 | i0 | 51.9 | 7.69325153374233 | 52 | 25 | 95.7 | 0 | 157 | 2 | 71 | 122 | KAF7999704.1 hypothetical protein HF325_005553 [Metschnikowia pulcherrima] | diamond | 1254 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia pulcherrima | |
| 31026890 | 31026890 | PRJNA557895_P_NODE_6875_length_341_cov_1.133562_g6520_i0 | PRJNA557895 | 6875 | 341 | 1.133562 | 3.86544642 | Hanseniaspora osmophila | 56408 | Fungi | Fungi | 156 | 2.0099999999999997e-46 | NR | OEJ86052.1 | 56408 | g6520 | i0 | 62.5 | 1.97947214076246 | 112 | 42 | 98.5 | 0 | 341 | 6 | 33 | 144 | OEJ86052.1 Nucleoside diphosphate kinase [Hanseniaspora osmophila] | diamond | 675 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycodales | Saccharomycodaceae | Hanseniaspora | Hanseniaspora osmophila | |
| 31279449 | 31279449 | PRJNA557895_P_NODE_7555_length_325_cov_1.978261_g7200_i0 | PRJNA557895 | 7555 | 325 | 1.978261 | 6.42934825 | Dipodascopsis uninucleata | 27313 | Fungi | Fungi | 49.7 | 3.52e-4 | NR | KAK9453400.1 | 27313 | g7200 | i0 | 37.7 | 1.23692307692308 | 61 | 38 | 56.3 | 0 | 41 | 223 | 291 | 351 | KAK9453400.1 general substrate transporter [Dipodascopsis uninucleata] | diamond | 402 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Dipodascopsis | Dipodascopsis uninucleata | |
| 31532796 | 31532796 | PRJNA557895_P_NODE_35896_length_163_cov_0.894737_g35541_i0 | PRJNA557895 | 35896 | 163 | 0.894737 | 1.45842131 | Cordyceps javanica | 43265 | Fungi | Fungi | 60.8 | 5.17e-9 | NR | TQV91503.1 | 43265 | g35541 | i0 | 49 | 0.938650306748466 | 51 | 23 | 93.9 | 1 | 154 | 2 | 504 | 551 | TQV91503.1 disintegrin-like metalloprotease [Cordyceps javanica] | diamond | 153 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Cordyceps | Cordyceps javanica | |
| 31609988 | 31609988 | PRJNA557895_P_NODE_17856_length_218_cov_1.786982_g17501_i0 | PRJNA557895 | 17856 | 218 | 1.786982 | 3.89562076 | Eukaryota | 2759 | Fungi | Fungi | 92 | 1.86e-22 | NR | XP_047761105.1 | 5499 | g17501 | i0 | 66.2 | 17.7660550458716 | 68 | 23 | 93.6 | 0 | 217 | 14 | 1 | 68 | XP_047761105.1 60S ribosomal protein L38 [Fulvia fulva] | diamond | 3873 | 92.4 | 0.995670995670996 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Fulvia | Fulvia fulva | |
| 32418505 | 32418505 | PRJNA557895_P_NODE_29339_length_168_cov_1.310924_g28984_i0 | PRJNA557895 | 29339 | 168 | 1.310924 | 2.20235232 | Pneumocystis canis | 2698477 | Fungi | Fungi | 41.6 | 0.00975 | NR | KAG4302152.1 | 2698477 | g28984 | i0 | 47.7 | 0.785714285714286 | 44 | 22 | 76.8 | 1 | 139 | 11 | 3 | 46 | KAG4302152.1 hypothetical protein PCK1_001424 [Pneumocystis canis] | diamond | 132 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pneumocystomycetes | Pneumocystales | Pneumocystaceae | Pneumocystis | Pneumocystis canis |
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);;