contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1118794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2781504 | 2781504 | PRJNA1118794_P_NODE_62643_length_245_cov_0.895349_g61893_i0 | PRJNA1118794 | 62643 | 245 | 0.895349 | 2.19360505 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 136 | 7.8e-37 | NR | XP_664964.1 | 353151 | g61893 | i0 | 76.5 | 11.8530612244898 | 81 | 19 | 99.2 | 0 | 1 | 243 | 3 | 83 | XP_664964.1 hypothetical protein, partial [Cryptosporidium hominis TU502] | diamond | 2904 | 137 | 0.992700729927007 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium hominis | ||
| 6608788 | 6608788 | PRJNA1118794_P_NODE_42906_length_262_cov_1.830688_g42156_i0 | PRJNA1118794 | 42906 | 262 | 1.830688 | 4.79640256 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 3.1e-28 | NR | XP_029221002.1 | 94643 | g42156 | i0 | 64.3 | 7.7175572519084 | 84 | 28 | 96.2 | 1 | 261 | 10 | 95 | 176 | XP_029221002.1 ribosomal protein RPL10A [Besnoitia besnoiti] | diamond | 2022 | 112 | 0.991071428571429 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 7402826 | 7402826 | PRJNA1118794_P_NODE_44706_length_258_cov_3.805405_g43956_i0 | PRJNA1118794 | 44706 | 258 | 3.805405 | 9.8179449 | Hepatocystis sp. ex Piliocolobus tephrosceles | 2600580 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 3.969999999999999e-31 | NR | VWU51230.1 | 2600580 | g43956 | i0 | 73.8 | 3.75581395348837 | 80 | 20 | 91.9 | 1 | 4 | 240 | 1 | 80 | VWU51230.1 60S ribosomal protein L44 [Hepatocystis sp. ex Piliocolobus tephrosceles] | diamond | 969 | 115 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Hepatocystis | Hepatocystis sp. ex Piliocolobus tephrosceles | ||
| 9158129 | 9158129 | PRJNA1118794_P_NODE_12808_length_401_cov_2.466463_g12058_i0 | PRJNA1118794 | 12808 | 401 | 2.466463 | 9.89051663 | Babesia sp. Xinjiang | 462227 | SAR_Eukaryotes | SAR_Eukaryotes | 151 | 6.699999999999998e-44 | NR | XP_028869867.1 | 462227 | g12058 | i0 | 62.1 | 1.7356608478803 | 116 | 44 | 86.8 | 0 | 15 | 362 | 4 | 119 | XP_028869867.1 Eukaryotic translation initiation factor 5A [Babesia sp. Xinjiang] | diamond | 696 | 151 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia sp. Xinjiang | ||
| 26688192 | 26688192 | PRJNA1118794_P_NODE_45441_length_257_cov_1.461957_g44691_i0 | PRJNA1118794 | 45441 | 257 | 1.461957 | 3.75722949 | Babesia microti strain RI | 1133968 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 8.28e-13 | NR | XP_012648194.1 | 1133968 | g44691 | i0 | 42.9 | 2.82490272373541 | 84 | 46 | 95.7 | 1 | 6 | 251 | 28 | 111 | XP_012648194.1 small monomeric GTPase [Babesia microti strain RI] | diamond | 726 | 70.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 27289323 | 27289323 | PRJNA1118794_P_NODE_62943_length_245_cov_0.895349_g62193_i0 | PRJNA1118794 | 62943 | 245 | 0.895349 | 2.19360505 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 88.2 | 1.47e-19 | NR | XP_018635543.1 | 508771 | g62193 | i0 | 58.3 | 2.63265306122449 | 72 | 29 | 86.9 | 1 | 216 | 4 | 83 | 154 | XP_018635543.1 vacuolar atp synthase subunit f, putative [Toxoplasma gondii ME49] | diamond | 645 | 88.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 27636901 | 27636901 | PRJNA1118794_P_NODE_54044_length_249_cov_0.875000_g53294_i0 | PRJNA1118794 | 54044 | 249 | 0.875 | 2.17875 | Plasmodium ovale | 36330 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 8.55e-6 | NR | SBT77329.1 | 36330 | g53294 | i0 | 38.6 | 0.843373493975904 | 70 | 43 | 84.3 | 0 | 2 | 211 | 638 | 707 | SBT77329.1 dynamin-like protein, putative [Plasmodium ovale] | diamond | 210 | 53.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 27722895 | 27722895 | PRJNA1118794_P_NODE_12684_length_403_cov_1.563636_g11934_i0 | PRJNA1118794 | 12684 | 403 | 1.563636 | 6.30145308 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 83.6 | 4.02e-17 | NR | XP_028865997.1 | 189622 | g11934 | i0 | 36.9 | 4.00496277915633 | 141 | 77 | 96 | 4 | 13 | 399 | 12 | 152 | XP_028865997.1 translationally-controlled tumor protein [Babesia ovata] | diamond | 1614 | 83.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 28195943 | 28195943 | PRJNA1118794_P_NODE_10326_length_440_cov_1.468665_g9578_i0 | PRJNA1118794 | 10326 | 440 | 1.468665 | 6.462126 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 7.399999999999998e-44 | NR | KAK1443951.1 | 33632 | g9578 | i0 | 63.8 | 34.0363636363636 | 116 | 42 | 79.1 | 0 | 438 | 91 | 94 | 209 | KAK1443951.1 ribosomal protein L10e/L16 [Babesia gibsoni] | diamond | 14976 | 154 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia gibsoni | ||
| 28299714 | 28299714 | PRJNA1118794_P_NODE_10886_length_430_cov_1.380952_g10138_i0 | PRJNA1118794 | 10886 | 430 | 1.380952 | 5.9380936 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 7.68e-35 | NR | OEH76901.1 | 88456 | g10138 | i0 | 60.7 | 2.42790697674419 | 117 | 46 | 81.6 | 0 | 428 | 78 | 90 | 206 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 1044 | 130 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 28322320 | 28322320 | PRJNA1118794_P_NODE_2986_length_842_cov_2.876463_g2320_i0 | PRJNA1118794 | 2986 | 842 | 2.876463 | 24.21981846 | Eimeriidae | 5799 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 1.23e-37 | NR | CAC20153.1 | 5802 | g2320 | i0 | 47 | 1.06175771971496 | 149 | 76 | 52.7 | 2 | 44 | 487 | 282 | 428 | CAC20153.1 aspartyl proteinase (eimepsin) [Eimeria tenella] | diamond | 894 | 149 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 29017352 | 29017352 | PRJNA1118794_P_NODE_54748_length_249_cov_0.875000_g53998_i0 | PRJNA1118794 | 54748 | 249 | 0.875 | 2.17875 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 1.81e-16 | NR | XP_029217382.1 | 94643 | g53998 | i0 | 50.6 | 5.27710843373494 | 85 | 39 | 98.8 | 1 | 4 | 249 | 320 | 404 | XP_029217382.1 putative proliferation-associated protein 2G4 [Besnoitia besnoiti] | diamond | 1314 | 84 | 0.990476190476191 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 29878623 | 29878623 | PRJNA1118794_P_NODE_14231_length_384_cov_1.189711_g13481_i0 | PRJNA1118794 | 14231 | 384 | 1.189711 | 4.56849024 | Babesia bigemina | 5866 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.0128 | NR | XP_012766069.1 | 5866 | g13481 | i0 | 36.6 | 1.1484375 | 71 | 37 | 49.2 | 1 | 183 | 371 | 107 | 177 | XP_012766069.1 hypothetical protein, conserved [Babesia bigemina] | diamond | 441 | 45.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 30027619 | 30027619 | PRJNA1118794_P_NODE_72991_length_241_cov_0.916667_g72241_i0 | PRJNA1118794 | 72991 | 241 | 0.916667 | 2.20916747 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 2.22e-11 | NR | EPR57470.1 | 507601 | g72241 | i0 | 37.7 | 8.65145228215768 | 77 | 44 | 95.9 | 1 | 10 | 240 | 1634 | 1706 | EPR57470.1 putative dynein gamma chain, flagellar outer arm, partial [Toxoplasma gondii GT1] | diamond | 2085 | 68.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 30068022 | 30068022 | PRJNA1118794_P_NODE_61292_length_246_cov_0.890173_g60542_i0 | PRJNA1118794 | 61292 | 246 | 0.890173 | 2.18982558 | Hepatocystis sp. ex Piliocolobus tephrosceles | 2600580 | SAR_Eukaryotes | SAR_Eukaryotes | 96.3 | 1.63e-21 | NR | VWU51610.1 | 2600580 | g60542 | i0 | 51.9 | 0.939024390243902 | 77 | 37 | 93.9 | 0 | 11 | 241 | 219 | 295 | VWU51610.1 conserved protein, unknown function [Hepatocystis sp. ex Piliocolobus tephrosceles] | diamond | 231 | 96.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Hepatocystis | Hepatocystis sp. ex Piliocolobus tephrosceles | ||
| 30225993 | 30225993 | PRJNA1118794_P_NODE_55612_length_248_cov_0.880000_g54862_i0 | PRJNA1118794 | 55612 | 248 | 0.88 | 2.1824 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 1.64e-11 | NR | SOV77379.1 | 5854 | g54862 | i0 | 48.8 | 4.83870967741935 | 80 | 39 | 96.8 | 1 | 8 | 247 | 207 | 284 | SOV77379.1 cation/H+ antiporter [Plasmodium reichenowi] | diamond | 1200 | 69.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 30321409 | 30321409 | PRJNA1118794_P_NODE_75612_length_228_cov_2.690323_g74862_i0 | PRJNA1118794 | 75612 | 228 | 2.690323 | 6.13393644 | Cryptosporidium ubiquitum | 857276 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0322 | NR | XP_028873474.1 | 857276 | g74862 | i0 | 40.6 | 0.907894736842105 | 69 | 38 | 88.2 | 2 | 16 | 216 | 806 | 873 | XP_028873474.1 pleckstrin domain-containing protein [Cryptosporidium ubiquitum] | diamond | 207 | 42.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ubiquitum | ||
| 30478923 | 30478923 | PRJNA1118794_P_NODE_20453_length_336_cov_1.171103_g19703_i0 | PRJNA1118794 | 20453 | 336 | 1.171103 | 3.93490608 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 92 | 4.5e-19 | NR | XP_026190971.1 | 88456 | g19703 | i0 | 46.2 | 9.33035714285714 | 106 | 44 | 93.8 | 4 | 333 | 19 | 338 | 431 | XP_026190971.1 phytepsin-like [Cyclospora cayetanensis] | diamond | 3135 | 92 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 30532956 | 30532956 | PRJNA1118794_P_NODE_41653_length_265_cov_1.583333_g40903_i0 | PRJNA1118794 | 41653 | 265 | 1.583333 | 4.19583245 | root | 1 | Root_unresolved | Root_unresolved | 55.5 | 1.54e-6 | NR | XP_067196238.1 | 515981 | g40903 | i0 | 36.4 | 2.01509433962264 | 88 | 53 | 96.2 | 1 | 261 | 7 | 272 | 359 | XP_067196238.1 uncharacterized protein FG386_000696 [Cryptosporidium ryanae] | diamond | 534 | 55.8 | 0.99462365591397806 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae | ||
| 30722457 | 30722457 | PRJNA1118794_P_NODE_27494_length_302_cov_2.454148_g26744_i0 | PRJNA1118794 | 27494 | 302 | 2.454148 | 7.41152696 | Piroplasmida | 5863 | SAR_Eukaryotes | SAR_Eukaryotes | 75.1 | 2.94e-13 | NR | UKK01366.2 | 68886 | g26744 | i0 | 44.3 | 1.41059602649007 | 70 | 38 | 68.5 | 1 | 91 | 297 | 372 | 441 | UKK01366.2 cysteine protease precursor TacP [Theileria orientalis] | diamond | 426 | 75.5 | 0.994701986754967 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 30754217 | 30754217 | PRJNA1118794_P_NODE_8294_length_488_cov_6.387952_g7551_i0 | PRJNA1118794 | 8294 | 488 | 6.387952 | 31.17320576 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 9.38e-59 | NR | XP_029221789.1 | 94643 | g7551 | i0 | 62.8 | 4.36475409836066 | 148 | 54 | 91 | 1 | 44 | 487 | 1 | 147 | XP_029221789.1 ribosomal protein RPS16 [Besnoitia besnoiti] | diamond | 2130 | 189 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 31765787 | 31765787 | PRJNA1118794_P_NODE_6817_length_538_cov_4.152688_g6078_i0 | PRJNA1118794 | 6817 | 538 | 4.152688 | 22.34146144 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 201 | 3.1999999999999998e-62 | NR | OEH76901.1 | 88456 | g6078 | i0 | 62.8 | 4.78996282527881 | 172 | 64 | 95.9 | 0 | 4 | 519 | 27 | 198 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 2577 | 201 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 32018929 | 32018929 | PRJNA1118794_P_NODE_73058_length_241_cov_0.916667_g72308_i0 | PRJNA1118794 | 73058 | 241 | 0.916667 | 2.20916747 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 1.23e-10 | NR | XP_002365092.1 | 508771 | g72308 | i0 | 42.9 | 1.79253112033195 | 77 | 40 | 94.6 | 2 | 1 | 228 | 280 | 353 | XP_002365092.1 OTU family cysteine protease [Toxoplasma gondii ME49] | diamond | 432 | 67 | 0.994029850746269 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 32281312 | 32281312 | PRJNA1118794_P_NODE_72399_length_241_cov_1.398810_g71649_i0 | PRJNA1118794 | 72399 | 241 | 1.39881 | 3.3711321 | Porospora cf. gigantea A | 2853593 | SAR_Eukaryotes | SAR_Eukaryotes | 95.9 | 2.96e-22 | NR | XP_067807228.1 | 2853593 | g71649 | i0 | 54.4 | 4.92946058091286 | 79 | 34 | 98.3 | 1 | 3 | 239 | 60 | 136 | XP_067807228.1 MAG: uncharacterized protein KVP18_004536 [Porospora cf. gigantea A] | diamond | 1188 | 95.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea A |
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);;