contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA784979" and tax_clade = "Opisthokonta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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);;