contig_metadata
10 rows where analysis = "diamond", tax_kingdom = "Metazoa" and tax_phylum = "Onychophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14640290 | 14640290 | PRJNA641707_P_NODE_127192_length_244_cov_11.769231_g124529_i0 | PRJNA641707 | 127192 | 244 | 11.769231 | 28.71692364 | Metazoa | 33208 | Onychophora | other_Eukaryota | 60.5 | 1.2e-8 | NR | AJG44466.1 | 49087 | g124529 | i0 | 90 | 7.37704918032787 | 30 | 3 | 36.9 | 0 | 152 | 241 | 4 | 33 | AJG44466.1 pox-meso, partial [Euperipatoides rowelli] | diamond | 1800 | 60.8 | 0.995065789473684 | Eukaryota | Opisthokonta | Metazoa | Onychophora | Udeonychophora | Euonychophora | Peripatopsidae | Euperipatoides | Euperipatoides rowelli | |
| 22134084 | 22134084 | PRJNA493244_P_NODE_842698_length_483_cov_3.334123_g819882_i0 | PRJNA493244 | 842698 | 483 | 3.334123 | 16.10381409 | Epiperipatus biolleyi | 172520 | Onychophora | other_Eukaryota | 82 | 9.89e-16 | NR | YP_001083076.1 | 172520 | g819882 | i0 | 71.1 | 1.95652173913043 | 45 | 13 | 28 | 0 | 374 | 240 | 168 | 212 | YP_001083076.1 cytochrome c oxidase subunit II [Epiperipatus biolleyi] | diamond | 945 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Onychophora | Udeonychophora | Euonychophora | Peripatidae | Epiperipatus | Epiperipatus biolleyi | |
| 27335195 | 27335195 | PRJNA683669_P_NODE_31103_length_245_cov_0.895349_g30871_i0 | PRJNA683669 | 31103 | 245 | 0.895349 | 2.19360505 | Principapillatus hitoyensis | 1281314 | Onychophora | other_Eukaryota | 67.4 | 5.7e-11 | NR | WMM48044.1 | 1281314 | g30871 | i0 | 71.7 | 1.68979591836735 | 46 | 13 | 56.3 | 0 | 1 | 138 | 272 | 317 | WMM48044.1 phosphoenolpyruvate mutase [Principapillatus hitoyensis] | diamond | 414 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Onychophora | Udeonychophora | Euonychophora | Peripatidae | Principapillatus | Principapillatus hitoyensis | |
| 27910545 | 27910545 | PRJNA983848_P_NODE_52985_length_467_cov_1.624365_g47107_i0 | PRJNA983848 | 52985 | 467 | 1.624365 | 7.58578455 | Euperipatoides rowelli | 49087 | Onychophora | other_Eukaryota | 44.7 | 0.0168 | NR | ADI48492.1 | 49087 | g47107 | i0 | 39.1 | 0.295503211991435 | 46 | 26 | 29.6 | 1 | 8 | 145 | 79 | 122 | ADI48492.1 lectin [Euperipatoides rowelli] | diamond | 138 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Onychophora | Udeonychophora | Euonychophora | Peripatopsidae | Euperipatoides | Euperipatoides rowelli | |
| 28171095 | 28171095 | PRJEB66218_P_NODE_72346_length_376_cov_2.428571_g69921_i0 | PRJEB66218 | 72346 | 376 | 2.428571 | 9.13142696 | Euperipatoides rowelli | 49087 | Onychophora | other_Eukaryota | 82.4 | 1.71e-15 | NR | WMM48047.1 | 49087 | g69921 | i0 | 60 | 1.6436170212766 | 55 | 22 | 43.9 | 0 | 375 | 211 | 360 | 414 | WMM48047.1 2-aminoethyl phosphonate transaminase [Euperipatoides rowelli] | diamond | 618 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Onychophora | Udeonychophora | Euonychophora | Peripatopsidae | Euperipatoides | Euperipatoides rowelli | |
| 28639973 | 28639973 | PRJNA446034_S_NODE_110027_length_152_cov_1.321739_g109990_i0 | PRJNA446034 | 110027 | 152 | 1.321739 | 2.00904328 | Metazoa | 33208 | Onychophora | other_Eukaryota | 43.1 | 0.00495 | NR | ADI48501.1 | 49087 | g109990 | i0 | 60 | 2.01315789473684 | 25 | 10 | 49.3 | 0 | 5 | 79 | 121 | 145 | ADI48501.1 cysteine protease [Euperipatoides rowelli] | diamond | 306 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Onychophora | Udeonychophora | Euonychophora | Peripatopsidae | Euperipatoides | Euperipatoides rowelli | |
| 29489695 | 29489695 | PRJEB14803_P_NODE_15050_length_312_cov_2.350181_g14584_i0 | PRJEB14803 | 15050 | 312 | 2.350181 | 7.33256472 | Opisthokonta | 33154 | Onychophora | other_Eukaryota | 147 | 1.76e-41 | NR | CFW94246.1 | 488523 | g14584 | i0 | 63.1 | 9.83653846153846 | 103 | 38 | 99 | 0 | 310 | 2 | 151 | 253 | CFW94246.1 Eka-PI transferase 3 protein [Euperipatoides kanangrensis] | diamond | 3069 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Metazoa | Onychophora | Udeonychophora | Euonychophora | Peripatopsidae | Euperipatoides | Euperipatoides kanangrensis | |
| 30906561 | 30906561 | PRJNA770826_P_NODE_39534_length_163_cov_0.912281_g39363_i0 | PRJNA770826 | 39534 | 163 | 0.912281 | 1.48701803 | Peripatus sp. 'Pep' | 681529 | Onychophora | other_Eukaryota | 74.7 | 2.84e-14 | NR | ACY44731.1 | 681529 | g39363 | i0 | 64.2 | 3.90184049079755 | 53 | 19 | 97.5 | 0 | 4 | 162 | 125 | 177 | ACY44731.1 GTP-binding protein, partial [Peripatus sp. 'Pep'] | diamond | 636 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Onychophora | Udeonychophora | Euonychophora | Peripatidae | Peripatus | Peripatus sp. 'Pep' | |
| 31168165 | 31168165 | PRJNA725806_P_NODE_185415_length_154_cov_1.239316_g185113_i0 | PRJNA725806 | 185415 | 154 | 1.239316 | 1.90854664 | Metazoa | 33208 | Onychophora | other_Eukaryota | 102 | 1.2699999999999999e-24 | NR | ACY44815.1 | 49087 | g185113 | i0 | 98 | 21.8571428571429 | 51 | 1 | 99.4 | 0 | 2 | 154 | 248 | 298 | ACY44815.1 clathrin heavy chain, partial [Euperipatoides rowelli] | diamond | 3366 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Onychophora | Udeonychophora | Euonychophora | Peripatopsidae | Euperipatoides | Euperipatoides rowelli | |
| 32273320 | 32273320 | PRJNA195897_P_NODE_7178_length_186_cov_1.197080_g7145_i0 | PRJNA195897 | 7178 | 186 | 1.19708 | 2.2265688 | Metazoa | 33208 | Onychophora | other_Eukaryota | 78.2 | 5.72e-15 | NR | AME17874.1 | 49107 | g7145 | i0 | 61.3 | 7 | 62 | 24 | 100 | 0 | 186 | 1 | 51 | 112 | AME17874.1 lamin [Phallocephale tallagandensis] | diamond | 1302 | 78.6 | 0.994910941475827 | Eukaryota | Opisthokonta | Metazoa | Onychophora | Udeonychophora | Euonychophora | Peripatopsidae | Phallocephale | Phallocephale tallagandensis |
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);;