contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA906294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3800903 | 3800903 | PRJNA906294_P_NODE_73483_length_526_cov_1.772627_g69378_i0 | PRJNA906294 | 73483 | 526 | 1.772627 | 9.32401802 | Theileria | 5873 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 6.52e-83 | NR | PVC52278.1 | 68886 | g69378 | i0 | 73.9 | 2.82889733840304 | 165 | 42 | 93.5 | 1 | 494 | 3 | 60 | 224 | PVC52278.1 peptidyl-prolyl cis-trans isomerase [Theileria orientalis] | diamond | 1488 | 255 | 0.996078431372549 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 21289315 | 21289315 | PRJNA906294_P_NODE_189057_length_266_cov_1.575130_g184941_i0 | PRJNA906294 | 189057 | 266 | 1.57513 | 4.1898458 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 9.22e-37 | NR | XP_012768418.1 | 5866 | g184941 | i0 | 79.5 | 7.93984962406015 | 88 | 18 | 99.2 | 0 | 266 | 3 | 132 | 219 | XP_012768418.1 40S ribosomal protein S5, putative [Babesia bigemina] | diamond | 2112 | 134 | 0.992537313432836 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 26897877 | 26897877 | PRJNA906294_P_NODE_221821_length_244_cov_0.888889_g217705_i0 | PRJNA906294 | 221821 | 244 | 0.888889 | 2.16888916 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 1.06e-15 | NR | CAL7862397.1 | 1344799 | g217705 | i0 | 54.5 | 0.811475409836066 | 66 | 29 | 79.9 | 1 | 2 | 196 | 160 | 225 | CAL7862397.1 unnamed protein product [Sarcocystis calchasi] | diamond | 198 | 81.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 26992456 | 26992456 | PRJNA906294_P_NODE_200542_length_255_cov_1.087912_g196426_i0 | PRJNA906294 | 200542 | 255 | 1.087912 | 2.7741756 | Porospora cf. gigantea B | 2853592 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 8.47e-8 | NR | XP_068373845.1 | 2853592 | g196426 | i0 | 44 | 0.988235294117647 | 84 | 38 | 98.8 | 2 | 254 | 3 | 633 | 707 | XP_068373845.1 MAG: uncharacterized protein KVP17_001728 [Porospora cf. gigantea B] | diamond | 252 | 58.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea B | ||
| 27056028 | 27056028 | PRJNA906294_P_NODE_151522_length_309_cov_2.084746_g147406_i0 | PRJNA906294 | 151522 | 309 | 2.084746 | 6.44186514 | Cryptosporidium muris RN66 | 441375 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 9.92e-25 | NR | XP_002140866.1 | 441375 | g147406 | i0 | 57.1 | 1.76699029126214 | 98 | 41 | 94.2 | 1 | 3 | 293 | 33 | 130 | XP_002140866.1 40S ribosomal protein S24, putative [Cryptosporidium muris RN66] | diamond | 546 | 100 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 28074075 | 28074075 | PRJNA906294_P_NODE_147445_length_315_cov_1.793388_g143329_i0 | PRJNA906294 | 147445 | 315 | 1.793388 | 5.6491722 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 8.72e-14 | NR | XP_067713567.1 | 5871 | g143329 | i0 | 48.7 | 2.9047619047619 | 78 | 39 | 74.3 | 1 | 299 | 66 | 9 | 85 | XP_067713567.1 60S acidic ribosomal protein p1, putative [Babesia caballi] | diamond | 915 | 72.8 | 0.994505494505495 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 29108707 | 29108707 | PRJNA906294_P_NODE_111928_length_382_cov_1.540453_g107813_i0 | PRJNA906294 | 111928 | 382 | 1.540453 | 5.88453046 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.0201 | NR | CAL7860724.1 | 1344799 | g107813 | i0 | 36.8 | 0.596858638743455 | 76 | 47 | 59.7 | 1 | 85 | 312 | 1009 | 1083 | CAL7860724.1 unnamed protein product [Sarcocystis calchasi] | diamond | 228 | 45.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 29203519 | 29203519 | PRJNA906294_P_NODE_200309_length_255_cov_1.252747_g196193_i0 | PRJNA906294 | 200309 | 255 | 1.252747 | 3.19450485 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 1.53e-13 | NR | XP_067714118.1 | 5871 | g196193 | i0 | 46.9 | 2.85882352941176 | 81 | 43 | 95.3 | 0 | 13 | 255 | 98 | 178 | XP_067714118.1 Ras-related protein Rab-1 [Babesia caballi] | diamond | 729 | 75.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 29961142 | 29961142 | PRJNA906294_P_NODE_211031_length_248_cov_0.868571_g206915_i0 | PRJNA906294 | 211031 | 248 | 0.868571 | 2.15405608 | Babesia ovis | 5869 | SAR_Eukaryotes | SAR_Eukaryotes | 97.4 | 5.18e-24 | NR | GFE54039.1 | 5869 | g206915 | i0 | 61.8 | 4.48790322580645 | 76 | 29 | 91.9 | 0 | 228 | 1 | 5 | 80 | GFE54039.1 60S ribosomal protein L31 [Babesia ovis] | diamond | 1113 | 97.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 30189760 | 30189760 | PRJNA906294_P_NODE_201732_length_253_cov_6.894444_g197616_i0 | PRJNA906294 | 201732 | 253 | 6.894444 | 17.44294332 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 1.02e-26 | NR | BAN65741.1 | 5865 | g197616 | i0 | 71.4 | 8.40711462450593 | 70 | 20 | 83 | 0 | 250 | 41 | 388 | 457 | BAN65741.1 eIF-4A-like DEAD family RNA helicase, putative [Babesia bovis] | diamond | 2127 | 112 | 0.991071428571429 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 30245706 | 30245706 | PRJNA906294_P_NODE_135132_length_334_cov_6.934866_g131016_i0 | PRJNA906294 | 135132 | 334 | 6.934866 | 23.16245244 | Babesia microti strain RI | 1133968 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.4399999999999999e-23 | NR | XP_021337160.1 | 1133968 | g131016 | i0 | 49.1 | 2.86526946107784 | 106 | 47 | 95.2 | 1 | 13 | 330 | 1 | 99 | XP_021337160.1 large subunit ribosomal protein L18e [Babesia microti strain RI] | diamond | 957 | 99 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 30379776 | 30379776 | PRJNA906294_P_NODE_125292_length_352_cov_2.491039_g121176_i0 | PRJNA906294 | 125292 | 352 | 2.491039 | 8.76845728 | Haemosporida | 5819 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 1.55e-7 | NR | ETW61268.1 | 5835 | g121176 | i0 | 33.3 | 5.71875 | 111 | 64 | 87.8 | 2 | 325 | 17 | 50 | 158 | ETW61268.1 hypothetical protein PFMC_02688 [Plasmodium falciparum CAMP/Malaysia] | diamond | 2013 | 59.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 30467014 | 30467014 | PRJNA906294_P_NODE_210593_length_248_cov_0.868571_g206477_i0 | PRJNA906294 | 210593 | 248 | 0.868571 | 2.15405608 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 1.57e-12 | NR | XP_013229759.1 | 5802 | g206477 | i0 | 50.8 | 0.762096774193548 | 63 | 31 | 76.2 | 0 | 244 | 56 | 267 | 329 | XP_013229759.1 OTU-like cysteine protease domain-containing protein, putative [Eimeria tenella] | diamond | 189 | 72 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 30498334 | 30498334 | PRJNA906294_P_NODE_218153_length_245_cov_1.406977_g214037_i0 | PRJNA906294 | 218153 | 245 | 1.406977 | 3.44709365 | Cryptosporidium meleagridis | 93969 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 2.4999999999999998e-31 | NR | KAK9173059.1 | 93969 | g214037 | i0 | 69.1 | 3.89387755102041 | 81 | 24 | 99.2 | 1 | 3 | 245 | 80 | 159 | KAK9173059.1 40S ribosomal protein S3a [Cryptosporidium meleagridis] | diamond | 954 | 120 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium meleagridis | ||
| 30821744 | 30821744 | PRJNA906294_P_NODE_174954_length_281_cov_1.086538_g170838_i0 | PRJNA906294 | 174954 | 281 | 1.086538 | 3.05317178 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 2.19e-10 | NR | XP_013233838.1 | 5802 | g170838 | i0 | 46.6 | 5.27402135231317 | 88 | 44 | 94 | 1 | 275 | 12 | 7 | 91 | XP_013233838.1 cell division protein pelota, putative [Eimeria tenella] | diamond | 1482 | 66.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 31161492 | 31161492 | PRJNA906294_P_NODE_230775_length_241_cov_0.904762_g226659_i0 | PRJNA906294 | 230775 | 241 | 0.904762 | 2.18047642 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 2.17e-29 | NR | KAF8817929.1 | 476202 | g226659 | i0 | 67.1 | 0.946058091286307 | 76 | 25 | 94.6 | 0 | 228 | 1 | 65 | 140 | KAF8817929.1 hypothetical protein IE077_002751 [Cardiosporidium cionae] | diamond | 228 | 114 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 31446460 | 31446460 | PRJNA906294_P_NODE_71616_length_536_cov_13.617711_g67514_i0 | PRJNA906294 | 71616 | 536 | 13.617711 | 72.99093096 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 5.8e-60 | NR | OEH76901.1 | 88456 | g67514 | i0 | 61.3 | 4.61753731343284 | 168 | 65 | 94 | 0 | 3 | 506 | 38 | 205 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 2475 | 196 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 31549076 | 31549076 | PRJNA906294_P_NODE_187276_length_268_cov_1.210256_g183160_i0 | PRJNA906294 | 187276 | 268 | 1.210256 | 3.24348608 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 1.45e-33 | NR | AFJ45055.1 | 5874 | g183160 | i0 | 69.7 | 19.9253731343284 | 89 | 27 | 99.6 | 0 | 267 | 1 | 11 | 99 | AFJ45055.1 ribosomal protein S8, partial [Theileria annulata] | diamond | 5340 | 124 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 32079005 | 32079005 | PRJNA906294_P_NODE_115758_length_373_cov_1.316667_g111643_i0 | PRJNA906294 | 115758 | 373 | 1.316667 | 4.91116791 | Plasmodium vivax Brazil I | 1033975 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 4.68e-6 | NR | KMZ86275.1 | 1033975 | g111643 | i0 | 41.3 | 1.7372654155496 | 80 | 45 | 63.5 | 2 | 358 | 122 | 89 | 167 | KMZ86275.1 cyclin2 like protein [Plasmodium vivax Brazil I] | diamond | 648 | 55.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 32300900 | 32300900 | PRJNA906294_P_NODE_162239_length_295_cov_2.081081_g158123_i0 | PRJNA906294 | 162239 | 295 | 2.081081 | 6.13918895 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 1.01e-12 | NR | CAL7864417.1 | 1344799 | g158123 | i0 | 42.7 | 2.89830508474576 | 96 | 47 | 94.6 | 3 | 14 | 292 | 42 | 132 | CAL7864417.1 unnamed protein product [Sarcocystis calchasi] | diamond | 855 | 72.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi |
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);;