contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA784979" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8418662 | 8418662 | PRJNA784979_S_NODE_1987_length_330_cov_1.516014_g1945_i0 | PRJNA784979 | 1987 | 330 | 1.516014 | 5.0028462 | Bacillariaceae | 33852 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 7.87e-33 | NR | YP_009029080.1 | 2856 | g1945 | i0 | 57.3 | 1.87272727272727 | 103 | 44 | 93.6 | 0 | 2 | 310 | 47 | 149 | YP_009029080.1 hypothetical protein [Cylindrotheca closterium] | diamond | 618 | 129 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Cylindrotheca | Cylindrotheca closterium | ||
| 26705229 | 26705229 | PRJNA784979_S_NODE_11341_length_165_cov_0.879310_g11299_i0 | PRJNA784979 | 11341 | 165 | 0.87931 | 1.4508615 | Cylindrobasidium torrendii FP15 | 394432 | Fungi | Fungi | 65.1 | 1.73e-10 | NR | KIY68659.1 | 1314674 | g11299 | i0 | 48.1 | 0.981818181818182 | 54 | 28 | 98.2 | 0 | 4 | 165 | 219 | 272 | KIY68659.1 hypothetical protein CYLTODRAFT_489577 [Cylindrobasidium torrendii FP15055 ss-10] | diamond | 162 | 65.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Cylindrobasidium | Cylindrobasidium torrendii | |
| 26705231 | 26705231 | PRJNA784979_S_NODE_1821_length_351_cov_1.225166_g1779_i0 | PRJNA784979 | 1821 | 351 | 1.225166 | 4.30033266 | Rhizoclosmatium globosum | 329046 | Fungi | Fungi | 44.7 | 0.0226 | NR | ORY50952.1 | 329046 | g1779 | i0 | 40.7 | 0.692307692307692 | 81 | 36 | 62.4 | 3 | 71 | 289 | 173 | 249 | ORY50952.1 hypothetical protein BCR33DRAFT_498941 [Rhizoclosmatium globosum] | diamond | 243 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Rhizoclosmatium | Rhizoclosmatium globosum | |
| 26832176 | 26832176 | PRJNA784979_S_NODE_5821_length_204_cov_1.077419_g5779_i0 | PRJNA784979 | 5821 | 204 | 1.077419 | 2.19793476 | Phytophthora lilii | 2077276 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 6.71e-12 | NR | GMF31033.1 | 2077276 | g5779 | i0 | 56.1 | 0.838235294117647 | 57 | 25 | 83.8 | 0 | 199 | 29 | 113 | 169 | GMF31033.1 unnamed protein product [Phytophthora lilii] | diamond | 171 | 69.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora lilii | ||
| 27116641 | 27116641 | PRJNA784979_S_NODE_9382_length_172_cov_1.130081_g9340_i0 | PRJNA784979 | 9382 | 172 | 1.130081 | 1.94373932 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 6.12e-14 | NR | KAF4128241.1 | 4787 | g9340 | i0 | 60.7 | 0.976744186046512 | 56 | 21 | 97.7 | 1 | 170 | 3 | 27 | 81 | KAF4128241.1 hypothetical protein GN958_ATG22563 [Phytophthora infestans] | diamond | 168 | 73.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 27464609 | 27464609 | PRJNA784979_S_NODE_8223_length_180_cov_1.877863_g8181_i0 | PRJNA784979 | 8223 | 180 | 1.877863 | 3.3801534 | Phytophthora fragariae | 53985 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 4.14e-8 | NR | KAE9302619.1 | 53985 | g8181 | i0 | 77.1 | 0.8 | 48 | 10 | 78.3 | 1 | 148 | 8 | 34 | 81 | KAE9302619.1 hypothetical protein PF008_g22450 [Phytophthora fragariae] | diamond | 144 | 58.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariae | ||
| 27527541 | 27527541 | PRJNA784979_S_NODE_11403_length_165_cov_0.879310_g11361_i0 | PRJNA784979 | 11403 | 165 | 0.87931 | 1.4508615 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 61.2 | 3.78e-9 | NR | XP_069230063.1 | 1052096 | g11361 | i0 | 71.4 | 1.01818181818182 | 56 | 12 | 96.4 | 2 | 2 | 160 | 609 | 663 | XP_069230063.1 uncharacterized protein WHR41_04051 [Cladosporium halotolerans] | diamond | 168 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 28127617 | 28127617 | PRJNA784979_S_NODE_3125_length_261_cov_8.042453_g3083_i0 | PRJNA784979 | 3125 | 261 | 8.042453 | 20.99080233 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 159 | 7.829999999999999e-46 | NR | KRH93531.1 | 146866 | g3083 | i0 | 97.7 | 1 | 87 | 2 | 100 | 0 | 261 | 1 | 16 | 102 | KRH93531.1 hypothetical protein M153_7960002914 [Pseudoloma neurophilia] | diamond | 261 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28506419 | 28506419 | PRJNA784979_S_NODE_10507_length_167_cov_0.864407_g10465_i0 | PRJNA784979 | 10507 | 167 | 0.864407 | 1.44355969 | Kwoniella heveanensis CBS 569 | 1296119 | Fungi | Fungi | 70.5 | 2.18e-12 | NR | OCF42488.1 | 1296119 | g10465 | i0 | 68.6 | 3.66467065868263 | 51 | 16 | 91.6 | 0 | 166 | 14 | 585 | 635 | OCF42488.1 CDP-diacylglycerol-glycerol-3-phosphate 3-phosphatidyltransferase [Kwoniella heveanensis CBS 569] | diamond | 612 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Kwoniella | Kwoniella heveanensis | |
| 28569494 | 28569494 | PRJNA784979_S_NODE_13507_length_161_cov_0.901786_g13465_i0 | PRJNA784979 | 13507 | 161 | 0.901786 | 1.45187546 | Acer saccharum | 4024 | Plants | Plants | 81.6 | 6.57e-17 | NR | KAK0603915.1 | 4024 | g13465 | i0 | 75 | 0.968944099378882 | 52 | 13 | 96.9 | 0 | 4 | 159 | 32 | 83 | KAK0603915.1 hypothetical protein LWI29_010072 [Acer saccharum] | diamond | 156 | 81.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Sapindaceae | Acer | Acer saccharum | |
| 28916643 | 28916643 | PRJNA784979_S_NODE_1548_length_388_cov_1.905605_g1506_i0 | PRJNA784979 | 1548 | 388 | 1.905605 | 7.3937474 | Armillaria gallica | 47427 | Fungi | Fungi | 44.3 | 0.00544 | NR | PBK95230.1 | 47427 | g1506 | i0 | 38 | 0.548969072164949 | 71 | 40 | 54.9 | 1 | 292 | 80 | 9 | 75 | PBK95230.1 hypothetical protein ARMGADRAFT_791432 [Armillaria gallica] | diamond | 213 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Armillaria | Armillaria gallica | |
| 29106417 | 29106417 | PRJNA784979_S_NODE_10948_length_166_cov_0.871795_g10906_i0 | PRJNA784979 | 10948 | 166 | 0.871795 | 1.4471797 | Malassezia restricta | 76775 | Fungi | Fungi | 78.6 | 2.24e-15 | NR | XP_027484859.1 | 76775 | g10906 | i0 | 85.5 | 0.993975903614458 | 55 | 8 | 99.4 | 0 | 166 | 2 | 137 | 191 | XP_027484859.1 ESCRT-I complex subunit TSG101 [Malassezia restricta] | diamond | 165 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 29421865 | 29421865 | PRJNA784979_S_NODE_8689_length_176_cov_2.409449_g8647_i0 | PRJNA784979 | 8689 | 176 | 2.409449 | 4.24063024 | Drosophila erecta | 7220 | Arthropoda | Arthropoda | 88.6 | 2e-19 | NR | XP_026838606.1 | 7220 | g8647 | i0 | 91.8 | 0.835227272727273 | 49 | 4 | 83.5 | 0 | 2 | 148 | 191 | 239 | XP_026838606.1 LOW QUALITY PROTEIN: uncharacterized protein LOC113564595, partial [Drosophila erecta] | diamond | 147 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila erecta | |
| 30116732 | 30116732 | PRJNA784979_S_NODE_11832_length_164_cov_0.886957_g11790_i0 | PRJNA784979 | 11832 | 164 | 0.886957 | 1.45460948 | Zasmidium cellare | 395010 | Fungi | Fungi | 84.7 | 8.13e-18 | NR | KAK4496592.1 | 395010 | g11790 | i0 | 69.8 | 0.969512195121951 | 53 | 16 | 97 | 0 | 163 | 5 | 30 | 82 | KAK4496592.1 hypothetical protein PRZ48_012572 [Zasmidium cellare] | diamond | 159 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Zasmidium | Zasmidium cellare | |
| 30125892 | 30125892 | PRJNA784979_S_NODE_6712_length_194_cov_0.689655_g6670_i0 | PRJNA784979 | 6712 | 194 | 0.689655 | 1.3379307 | Opisthokonta | 33154 | Arthropoda | Arthropoda | 51.6 | 1.42e-5 | NR | KAL3192712.1 | 6941 | g6670 | i0 | 78.1 | 2.62886597938144 | 32 | 7 | 49.5 | 0 | 100 | 5 | 215 | 246 | KAL3192712.1 hypothetical protein MRX96_058767 [Rhipicephalus microplus] | diamond | 510 | 52 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Rhipicephalus | Rhipicephalus microplus | |
| 30189257 | 30189257 | PRJNA784979_S_NODE_10592_length_166_cov_1.811966_g10550_i0 | PRJNA784979 | 10592 | 166 | 1.811966 | 3.00786356 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 4.1e-10 | NR | KAF4128246.1 | 4787 | g10550 | i0 | 60.7 | 6.05421686746988 | 56 | 19 | 97.6 | 2 | 3 | 164 | 67 | 121 | KAF4128246.1 hypothetical protein GN958_ATG22568 [Phytophthora infestans] | diamond | 1005 | 63.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 30811898 | 30811898 | PRJNA784979_S_NODE_13294_length_161_cov_0.910714_g13252_i0 | PRJNA784979 | 13294 | 161 | 0.910714 | 1.46624954 | Lolium multiflorum | 4521 | Plants | Plants | 92.4 | 3.01e-21 | NR | KAK1660610.1 | 4521 | g13252 | i0 | 85.7 | 43.8260869565217 | 49 | 7 | 91.3 | 0 | 14 | 160 | 29 | 77 | KAK1660610.1 hypothetical protein QYE76_048769 [Lolium multiflorum] | diamond | 7056 | 92.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium multiflorum | |
| 30852784 | 30852784 | PRJNA784979_S_NODE_6494_length_196_cov_1.034014_g6452_i0 | PRJNA784979 | 6494 | 196 | 1.034014 | 2.02666744 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 7.12e-11 | NR | KAF4128243.1 | 4787 | g6452 | i0 | 40.3 | 2.05102040816327 | 67 | 38 | 99.5 | 1 | 195 | 1 | 57 | 123 | KAF4128243.1 hypothetical protein GN958_ATG22565 [Phytophthora infestans] | diamond | 402 | 63.9 | 0.993740219092332 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 31064965 | 31064965 | PRJNA784979_S_NODE_5335_length_210_cov_1.136646_g5293_i0 | PRJNA784979 | 5335 | 210 | 1.136646 | 2.3869566 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 2.02e-14 | NR | KAF0714686.1 | 120398 | g5293 | i0 | 53.8 | 0.928571428571429 | 65 | 28 | 90 | 1 | 199 | 11 | 283 | 347 | KAF0714686.1 hypothetical protein As57867_003739 [Aphanomyces stellatus] | diamond | 195 | 76.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 31950118 | 31950118 | PRJNA784979_S_NODE_7597_length_185_cov_1.602941_g7555_i0 | PRJNA784979 | 7597 | 185 | 1.602941 | 2.96544085 | Morus notabilis | 981085 | Plants | Plants | 78.6 | 2.35e-16 | NR | EXC14993.1 | 981085 | g7555 | i0 | 94.9 | 17.7081081081081 | 39 | 2 | 63.2 | 0 | 185 | 69 | 94 | 132 | EXC14993.1 hypothetical protein L484_008147 [Morus notabilis] | diamond | 3276 | 78.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Moraceae | Morus | Morus notabilis | |
| 32045200 | 32045200 | PRJNA784979_S_NODE_10398_length_167_cov_0.864407_g10356_i0 | PRJNA784979 | 10398 | 167 | 0.864407 | 1.44355969 | Cylindrobasidium torrendii FP15 | 394432 | Fungi | Fungi | 64.7 | 2.37e-10 | NR | KIY67911.1 | 1314674 | g10356 | i0 | 90.3 | 0.55688622754491 | 31 | 3 | 55.7 | 0 | 2 | 94 | 398 | 428 | KIY67911.1 Pkinase-domain-containing protein [Cylindrobasidium torrendii FP15055 ss-10] | diamond | 93 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Cylindrobasidium | Cylindrobasidium torrendii | |
| 32212713 | 32212713 | PRJNA784979_S_NODE_12278_length_163_cov_0.894737_g12236_i0 | PRJNA784979 | 12278 | 163 | 0.894737 | 1.45842131 | root | 1 | Root_unresolved | Root_unresolved | 57.8 | 6.34e-8 | NR | CAM6053282.1 | 128247 | g12236 | i0 | 48.9 | 2.42944785276074 | 45 | 23 | 82.8 | 0 | 11 | 145 | 1073 | 1117 | CAM6053282.1 unnamed protein product [Sphagnum tenellum] | diamond | 396 | 57.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum tenellum | |
| 32424874 | 32424874 | PRJNA784979_S_NODE_5059_length_214_cov_1.539394_g5017_i0 | PRJNA784979 | 5059 | 214 | 1.539394 | 3.29430316 | Phytophthora fragariaefolia | 1490495 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 8.93e-5 | NR | GMF22350.1 | 1490495 | g5017 | i0 | 56.9 | 0.714953271028037 | 51 | 21 | 70.1 | 1 | 152 | 3 | 184 | 234 | GMF22350.1 unnamed protein product [Phytophthora fragariaefolia] | diamond | 153 | 49.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora fragariaefolia | ||
| 32614451 | 32614451 | PRJNA784979_S_NODE_6320_length_198_cov_1.134228_g6278_i0 | PRJNA784979 | 6320 | 198 | 1.134228 | 2.24577144 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 45.4 | 3.92e-4 | NR | EDO32471.1 | 45351 | g6278 | i0 | 59 | 0.590909090909091 | 39 | 16 | 59.1 | 0 | 7 | 123 | 50 | 88 | EDO32471.1 predicted protein, partial [Nematostella vectensis] | diamond | 117 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 32866261 | 32866261 | PRJNA784979_S_NODE_7280_length_188_cov_1.525180_g7238_i0 | PRJNA784979 | 7280 | 188 | 1.52518 | 2.8673384 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 107 | 1.7e-25 | NR | KAK2707618.1 | 6661 | g7238 | i0 | 100 | 0.877659574468085 | 55 | 0 | 87.8 | 0 | 165 | 1 | 338 | 392 | KAK2707618.1 hypothetical protein QYM36_015356 [Artemia franciscana] | diamond | 165 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana |
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);;