contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA689790" and tax_phylum = "Apicomplexa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3219641 | 3219641 | PRJNA689790_S_NODE_9923_length_188_cov_1.470199_g9808_i0 | PRJNA689790 | 9923 | 188 | 1.470199 | 2.76397412 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 3.13e-28 | NR | XP_002365662.1 | 508771 | g9808 | i0 | 82.3 | 28.5478723404255 | 62 | 11 | 98.9 | 0 | 2 | 187 | 84 | 145 | XP_002365662.1 proteasome regulatory subunit [Toxoplasma gondii ME49] | diamond | 5367 | 112 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 16480972 | 16480972 | PRJNA689790_S_NODE_11053_length_179_cov_1.098592_g10938_i0 | PRJNA689790 | 11053 | 179 | 1.098592 | 1.96647968 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 7.76e-19 | NR | XP_067926325.1 | 483139 | g10938 | i0 | 77.6 | 7.77653631284916 | 58 | 13 | 97.2 | 0 | 176 | 3 | 229 | 286 | XP_067926325.1 cullin family [Cystoisospora suis] | diamond | 1392 | 88.2 | 0.99092970521542 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 27441726 | 27441726 | PRJNA689790_S_NODE_3903_length_311_cov_3.237226_g3788_i0 | PRJNA689790 | 3903 | 311 | 3.237226 | 10.06777286 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 1.4599999999999998e-37 | NR | XP_029215122.1 | 94643 | g3788 | i0 | 81.3 | 4.28295819935691 | 75 | 14 | 72.3 | 0 | 310 | 86 | 107 | 181 | XP_029215122.1 ADP ribosylation factor ARF1 [Besnoitia besnoiti] | diamond | 1332 | 135 | 0.992592592592593 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 28250760 | 28250760 | PRJNA689790_S_NODE_1966_length_465_cov_2.156542_g1854_i0 | PRJNA689790 | 1966 | 465 | 2.156542 | 10.0279203 | Plasmodium gonderi | 77519 | SAR_Eukaryotes | SAR_Eukaryotes | 79.7 | 9.64e-15 | NR | XP_028543962.1 | 77519 | g1854 | i0 | 35.9 | 3.38064516129032 | 117 | 63 | 75.5 | 1 | 399 | 49 | 46 | 150 | XP_028543962.1 cyclin [Plasmodium gonderi] | diamond | 1572 | 79.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gonderi | ||
| 28830601 | 28830601 | PRJNA689790_S_NODE_14448_length_159_cov_1.819672_g14333_i0 | PRJNA689790 | 14448 | 159 | 1.819672 | 2.89327848 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 3.51e-12 | NR | XP_002141206.1 | 441375 | g14333 | i0 | 82.5 | 7.52830188679245 | 40 | 7 | 75.5 | 0 | 158 | 39 | 408 | 447 | XP_002141206.1 26S proteasome subunit 4, putative [Cryptosporidium muris RN66] | diamond | 1197 | 70.1 | 0.994293865905849 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 29178189 | 29178189 | PRJNA689790_S_NODE_3289_length_344_cov_3.078176_g3174_i0 | PRJNA689790 | 3289 | 344 | 3.078176 | 10.58892544 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 3.82e-38 | NR | XP_013336399.1 | 5804 | g3174 | i0 | 66.3 | 9.79360465116279 | 101 | 34 | 88.1 | 0 | 8 | 310 | 144 | 244 | XP_013336399.1 protein transport protein Sec61 alpha subunit isoform 1, putative [Eimeria maxima] | diamond | 3369 | 138 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 29367569 | 29367569 | PRJNA689790_S_NODE_15789_length_154_cov_1.299145_g15674_i0 | PRJNA689790 | 15789 | 154 | 1.299145 | 2.0006833 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 6.69e-18 | NR | XP_028527098.1 | 5849 | g15674 | i0 | 85.7 | 15.2727272727273 | 49 | 7 | 95.5 | 0 | 152 | 6 | 1730 | 1778 | XP_028527098.1 DNA-directed RNA polymerase II subunit RPB1, putative [Plasmodium gallinaceum] | diamond | 2352 | 86.3 | 0.995365005793743 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 29608210 | 29608210 | PRJNA689790_S_NODE_13230_length_165_cov_1.500000_g13115_i0 | PRJNA689790 | 13230 | 165 | 1.5 | 2.475 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 41.2 | 0.0314 | NR | OEH75208.1 | 88456 | g13115 | i0 | 32.1 | 1.92727272727273 | 53 | 36 | 96.4 | 0 | 163 | 5 | 23 | 75 | OEH75208.1 p23 family protein [Cyclospora cayetanensis] | diamond | 318 | 41.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 30872193 | 30872193 | PRJNA689790_S_NODE_5874_length_247_cov_1.666667_g5759_i0 | PRJNA689790 | 5874 | 247 | 1.666667 | 4.11666749 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 7.31e-8 | NR | CAL7865005.1 | 1344799 | g5759 | i0 | 40.7 | 3.04858299595142 | 81 | 38 | 94.7 | 2 | 242 | 9 | 175 | 248 | CAL7865005.1 unnamed protein product [Sarcocystis calchasi] | diamond | 753 | 58.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 31042040 | 31042040 | PRJNA689790_S_NODE_8055_length_208_cov_2.052632_g7940_i0 | PRJNA689790 | 8055 | 208 | 2.052632 | 4.26947456 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.2e-4 | NR | XP_011134254.1 | 110365 | g7940 | i0 | 38.7 | 2.03365384615385 | 75 | 29 | 89.4 | 3 | 17 | 202 | 2650 | 2720 | XP_011134254.1 bacterial Ig-like domain protein [Gregarina niphandrodes] | diamond | 423 | 49.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 32053691 | 32053691 | PRJNA689790_S_NODE_14438_length_159_cov_1.909836_g14323_i0 | PRJNA689790 | 14438 | 159 | 1.909836 | 3.03663924 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 9.91e-11 | NR | XP_067805034.1 | 323732 | g14323 | i0 | 60 | 1.52830188679245 | 40 | 16 | 75.5 | 0 | 36 | 155 | 1 | 40 | XP_067805034.1 bifunctional Thioredoxin domain/Thioredoxin-like superfamily/Thioredoxin [Babesia duncani] | diamond | 243 | 62.4 | 0.993589743589744 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 32654176 | 32654176 | PRJNA689790_S_NODE_16040_length_153_cov_1.336207_g15925_i0 | PRJNA689790 | 16040 | 153 | 1.336207 | 2.04439671 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 71.6 | 6.88e-13 | NR | XP_013249147.1 | 5801 | g15925 | i0 | 64 | 32.2549019607843 | 50 | 18 | 98 | 0 | 151 | 2 | 132 | 181 | XP_013249147.1 polyadenylate-binding protein, putative [Eimeria acervulina] | diamond | 4935 | 72 | 0.994444444444444 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 32705897 | 32705897 | PRJNA689790_S_NODE_8780_length_199_cov_2.203704_g8665_i0 | PRJNA689790 | 8780 | 199 | 2.203704 | 4.38537096 | Babesia microti strain RI | 1133968 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 1.93e-8 | NR | XP_012648939.1 | 1133968 | g8665 | i0 | 64.4 | 1.38693467336683 | 45 | 16 | 67.8 | 0 | 198 | 64 | 271 | 315 | XP_012648939.1 ubiquilin [Babesia microti strain RI] | diamond | 276 | 59.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 32800308 | 32800308 | PRJNA689790_S_NODE_7260_length_220_cov_1.245902_g7145_i0 | PRJNA689790 | 7260 | 220 | 1.245902 | 2.7409844 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 2.39e-8 | NR | XP_013349452.1 | 44415 | g7145 | i0 | 48.5 | 2.61818181818182 | 68 | 35 | 92.7 | 0 | 218 | 15 | 73 | 140 | XP_013349452.1 LOW QUALITY PROTEIN: CBR-FKB-6 protein, related, related [Eimeria mitis] | diamond | 576 | 59.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis |
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);;