contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1025141" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2713276 | 2713276 | PRJNA1025141_P_NODE_7943_length_279_cov_1.087379_g7882_i0 | PRJNA1025141 | 7943 | 279 | 1.087379 | 3.03378741 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 151 | 2.39e-41 | NR | XP_665568.1 | 353151 | g7882 | i0 | 78.9 | 14.6451612903226 | 90 | 19 | 96.8 | 0 | 274 | 5 | 39 | 128 | XP_665568.1 Pfsec61 [Cryptosporidium hominis TU502] | diamond | 4086 | 152 | 0.993421052631579 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium hominis | ||
| 5265603 | 5265603 | PRJNA1025141_P_NODE_2345_length_533_cov_2.500000_g2284_i0 | PRJNA1025141 | 2345 | 533 | 2.5 | 13.325 | Babesia bovis T2Bo | 484906 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 1.84e-65 | NR | XP_001608890.2 | 484906 | g2284 | i0 | 56.3 | 1.9812382739212 | 176 | 76 | 99.1 | 1 | 2 | 529 | 59 | 233 | XP_001608890.2 putative cysteinyl-tRNA synthetase [Babesia bovis T2Bo] | diamond | 1056 | 222 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 18014664 | 18014664 | PRJNA1025141_P_NODE_3735_length_420_cov_2.193084_g3674_i0 | PRJNA1025141 | 3735 | 420 | 2.193084 | 9.2109528 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 1.33e-70 | NR | XP_067916959.1 | 483139 | g3674 | i0 | 72.1 | 8.70714285714286 | 136 | 38 | 97.1 | 0 | 2 | 409 | 6 | 141 | XP_067916959.1 nucleoside diphosphate kinase [Cystoisospora suis] | diamond | 3657 | 219 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 27066506 | 27066506 | PRJNA1025141_P_NODE_22_length_2933_cov_1.832517_g20_i0 | PRJNA1025141 | 22 | 2933 | 1.832517 | 53.74772361 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 0.0382 | NR | CDU16592.1 | 5861 | g20 | i0 | 23.3 | 0.693487896351858 | 678 | 403 | 66 | 28 | 2661 | 727 | 419 | 1012 | CDU16592.1 reticulocyte binding protein, putative [Plasmodium yoelii] | diamond | 2034 | 51.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 27351370 | 27351370 | PRJNA1025141_P_NODE_9023_length_257_cov_1.255435_g8962_i0 | PRJNA1025141 | 9023 | 257 | 1.255435 | 3.22646795 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 1.2e-5 | NR | XP_011129685.1 | 110365 | g8962 | i0 | 41.9 | 1.00389105058366 | 86 | 43 | 95.7 | 3 | 12 | 257 | 1 | 83 | XP_011129685.1 putative 3-oxo-5-alpha-steroid 4-dehydrogenase [Gregarina niphandrodes] | diamond | 258 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 27540660 | 27540660 | PRJNA1025141_P_NODE_304_length_1294_cov_1.369369_g280_i0 | PRJNA1025141 | 304 | 1294 | 1.369369 | 17.71963486 | Toxoplasma gondii RUB | 935652 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 7.14e-19 | NR | KFG59111.1 | 935652 | g280 | i0 | 24.1 | 0.943585780525502 | 407 | 247 | 92.5 | 15 | 1291 | 95 | 665 | 1017 | KFG59111.1 F5/8 type C domain-containing protein [Toxoplasma gondii RUB] | diamond | 1221 | 101 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 27564019 | 27564019 | PRJNA1025141_P_NODE_5964_length_328_cov_1.207843_g5903_i0 | PRJNA1025141 | 5964 | 328 | 1.207843 | 3.96172504 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 3.1e-25 | NR | XP_029215634.1 | 94643 | g5903 | i0 | 46 | 10.3353658536585 | 113 | 53 | 97.9 | 2 | 3 | 323 | 640 | 750 | XP_029215634.1 putative eukaryotic initiation factor-3, subunit 8 [Besnoitia besnoiti] | diamond | 3390 | 110 | 0.990909090909091 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 27974718 | 27974718 | PRJNA1025141_P_NODE_2885_length_482_cov_1.400978_g2824_i0 | PRJNA1025141 | 2885 | 482 | 1.400978 | 6.75271396 | Piroplasmida | 5863 | SAR_Eukaryotes | SAR_Eukaryotes | 186 | 5.139999999999999e-57 | NR | XP_763944.1 | 333668 | g2824 | i0 | 60.1 | 5.83195020746888 | 158 | 62 | 98.3 | 1 | 482 | 9 | 2 | 158 | XP_763944.1 ribosomal protein S4 [Theileria parva strain Muguga] | diamond | 2811 | 187 | 0.994652406417112 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria parva | ||
| 28416908 | 28416908 | PRJNA1025141_P_NODE_12286_length_243_cov_0.905882_g12225_i0 | PRJNA1025141 | 12286 | 243 | 0.905882 | 2.20129326 | Plasmodiidae | 1639119 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 4.72e-20 | NR | SBT77329.1 | 36330 | g12225 | i0 | 55 | 8.75308641975309 | 80 | 35 | 97.5 | 1 | 6 | 242 | 72 | 151 | SBT77329.1 dynamin-like protein, putative [Plasmodium ovale] | diamond | 2127 | 93.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 29206320 | 29206320 | PRJNA1025141_P_NODE_10749_length_247_cov_1.327586_g10688_i0 | PRJNA1025141 | 10749 | 247 | 1.327586 | 3.27913742 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 1.19e-5 | NR | XP_034423160.1 | 5823 | g10688 | i0 | 43.5 | 5.56275303643725 | 46 | 26 | 55.9 | 0 | 192 | 55 | 552 | 597 | XP_034423160.1 LCCL domain-containing protein [Plasmodium berghei ANKA] | diamond | 1374 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 30382974 | 30382974 | PRJNA1025141_P_NODE_4793_length_371_cov_0.882550_g4732_i0 | PRJNA1025141 | 4793 | 371 | 0.88255 | 3.2742605 | Theileria equi strain WA | 1537102 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 1.13e-8 | NR | XP_004830270.1 | 1537102 | g4732 | i0 | 40.8 | 0.792452830188679 | 98 | 50 | 75.2 | 3 | 356 | 78 | 291 | 385 | XP_004830270.1 sortilin, putative [Theileria equi strain WA] | diamond | 294 | 63.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 31132686 | 31132686 | PRJNA1025141_P_NODE_6595_length_311_cov_1.352941_g6534_i0 | PRJNA1025141 | 6595 | 311 | 1.352941 | 4.20764651 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 1.56e-11 | NR | KAK1445097.1 | 33632 | g6534 | i0 | 37 | 3.85852090032154 | 100 | 61 | 96.5 | 1 | 302 | 3 | 824 | 921 | KAK1445097.1 radical SAM [Babesia gibsoni] | diamond | 1200 | 71.2 | 0.990168539325843 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia gibsoni | ||
| 31172177 | 31172177 | PRJNA1025141_P_NODE_11995_length_244_cov_0.900585_g11934_i0 | PRJNA1025141 | 11995 | 244 | 0.900585 | 2.1974274 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00412 | NR | CAL7862308.1 | 1344799 | g11934 | i0 | 45.5 | 0.676229508196721 | 55 | 23 | 62.7 | 2 | 6 | 158 | 281 | 332 | CAL7862308.1 unnamed protein product [Sarcocystis calchasi] | diamond | 165 | 45.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 31773287 | 31773287 | PRJNA1025141_P_NODE_6597_length_311_cov_1.294118_g6536_i0 | PRJNA1025141 | 6597 | 311 | 1.294118 | 4.02470698 | Cryptosporidium ryanae | 515981 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 9.88e-16 | NR | XP_067198501.1 | 515981 | g6536 | i0 | 44.8 | 0.92604501607717 | 96 | 50 | 91.6 | 3 | 286 | 2 | 178 | 271 | XP_067198501.1 uncharacterized protein FG386_000255, partial [Cryptosporidium ryanae] | diamond | 288 | 82.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae | ||
| 32248285 | 32248285 | PRJNA1025141_P_NODE_9098_length_255_cov_1.692308_g9037_i0 | PRJNA1025141 | 9098 | 255 | 1.692308 | 4.3153854 | Cryptosporidium hominis TU5 | 237895 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 1.04e-11 | NR | XP_667741.1 | 353151 | g9037 | i0 | 38.6 | 0.976470588235294 | 83 | 51 | 97.6 | 0 | 255 | 7 | 409 | 491 | XP_667741.1 hypothetical protein [Cryptosporidium hominis TU502] | diamond | 249 | 70.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium hominis | ||
| 32564645 | 32564645 | PRJNA1025141_P_NODE_13019_length_241_cov_0.916667_g12958_i0 | PRJNA1025141 | 13019 | 241 | 0.916667 | 2.20916747 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 3.05e-5 | NR | CAL7862950.1 | 1344799 | g12958 | i0 | 35 | 0.995850622406639 | 80 | 51 | 98.3 | 1 | 5 | 241 | 12 | 91 | CAL7862950.1 unnamed protein product [Sarcocystis calchasi] | diamond | 240 | 50.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 32808374 | 32808374 | PRJNA1025141_P_NODE_8860_length_260_cov_2.032086_g8799_i0 | PRJNA1025141 | 8860 | 260 | 2.032086 | 5.2834236 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 1.53e-29 | NR | XP_028859676.1 | 5858 | g8799 | i0 | 57.8 | 5.79230769230769 | 83 | 35 | 95.8 | 0 | 2 | 250 | 6 | 88 | XP_028859676.1 60S ribosomal protein L37ae, putative [Plasmodium malariae] | diamond | 1506 | 110 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium malariae |
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);;