contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6076701 | 6076701 | PRJNA986481_P_NODE_29365_length_302_cov_2.000000_g28840_i0 | PRJNA986481 | 29365 | 302 | 2 | 6.04 | Cryptosporidium felis | 83540 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 1.97e-20 | NR | KAF7459395.1 | 83540 | g28840 | i0 | 51.5 | 3.00993377483444 | 101 | 42 | 99.3 | 2 | 3 | 302 | 81 | 175 | KAF7459395.1 putative eukaryotic translation initiation factor 2 alpha subunit [Cryptosporidium felis] | diamond | 909 | 94 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium felis | ||
| 8626256 | 8626256 | PRJNA986481_P_NODE_17087_length_396_cov_4.547550_g16562_i0 | PRJNA986481 | 17087 | 396 | 4.54755 | 18.008298 | Toxoplasma gondii TgCatPRC2 | 1130821 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 7.51e-44 | NR | KYK69415.1 | 1130821 | g16562 | i0 | 69 | 1.81060606060606 | 116 | 36 | 87.9 | 0 | 395 | 48 | 133 | 248 | KYK69415.1 heat shock protein 90 [Toxoplasma gondii TgCatPRC2] | diamond | 717 | 154 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 9901403 | 9901403 | PRJNA986481_P_NODE_14288_length_434_cov_1.259740_g13763_i0 | PRJNA986481 | 14288 | 434 | 1.25974 | 5.4672716 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 201 | 2.43e-63 | NR | XP_013227760.1 | 5802 | g13763 | i0 | 74.1 | 23.3571428571429 | 135 | 35 | 93.3 | 0 | 430 | 26 | 34 | 168 | XP_013227760.1 40S ribosomal protein S14, putative [Eimeria tenella] | diamond | 10137 | 202 | 0.995049504950495 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 13727239 | 13727239 | PRJNA986481_P_NODE_38771_length_265_cov_1.509259_g38246_i0 | PRJNA986481 | 38771 | 265 | 1.509259 | 3.99953635 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 1.7e-32 | NR | XP_013334321.1 | 5804 | g38246 | i0 | 68.5 | 13.9471698113208 | 89 | 26 | 98.5 | 1 | 1 | 261 | 374 | 462 | XP_013334321.1 seryl-tRNA synthetase, putative [Eimeria maxima] | diamond | 3696 | 127 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 18825005 | 18825005 | PRJNA986481_P_NODE_15155_length_421_cov_3.446237_g14630_i0 | PRJNA986481 | 15155 | 421 | 3.446237 | 14.50865777 | Theileria annulata | 5874 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 9.3e-38 | NR | XP_955059.1 | 5874 | g14630 | i0 | 76.1 | 1.84560570071259 | 88 | 21 | 62.7 | 0 | 1 | 264 | 364 | 451 | XP_955059.1 DEAD-box family helicase, putative [Theileria annulata] | diamond | 777 | 143 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 27374430 | 27374430 | PRJNA986481_P_NODE_53143_length_249_cov_1.010000_g52618_i0 | PRJNA986481 | 53143 | 249 | 1.01 | 2.5149 | Plasmodium knowlesi | 5850 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0127 | NR | P84152.1 | 5850 | g52618 | i0 | 37.3 | 1.62650602409639 | 75 | 44 | 86.7 | 2 | 5 | 220 | 55 | 129 | P84152.1 RecName: Full=Translationally-controlled tumor protein homolog; Short=TCTP [Plasmodium knowlesi] | diamond | 405 | 43.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 27664376 | 27664376 | PRJNA986481_P_NODE_49244_length_253_cov_0.990196_g48719_i0 | PRJNA986481 | 49244 | 253 | 0.990196 | 2.50519588 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 8.75e-10 | NR | XP_018635811.1 | 508771 | g48719 | i0 | 35.2 | 4.11462450592885 | 88 | 48 | 96 | 4 | 247 | 5 | 55 | 140 | XP_018635811.1 dual-specificity protein phosphatase [Toxoplasma gondii ME49] | diamond | 1041 | 62.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 28200741 | 28200741 | PRJNA986481_P_NODE_60526_length_241_cov_1.046875_g60001_i0 | PRJNA986481 | 60526 | 241 | 1.046875 | 2.52296875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 6.18e-13 | NR | XP_955300.1 | 5874 | g60001 | i0 | 50 | 7.92946058091286 | 80 | 39 | 98.3 | 1 | 239 | 3 | 131 | 210 | XP_955300.1 GTP-binding protein, putative [Theileria annulata] | diamond | 1911 | 73.9 | 0.990527740189445 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 28422164 | 28422164 | PRJNA986481_P_NODE_18846_length_377_cov_1.426829_g18321_i0 | PRJNA986481 | 18846 | 377 | 1.426829 | 5.37914533 | Eimeriidae | 5799 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 1.86e-18 | NR | CAC20153.1 | 5802 | g18321 | i0 | 43 | 2.38726790450928 | 100 | 54 | 78.8 | 2 | 6 | 302 | 334 | 431 | CAC20153.1 aspartyl proteinase (eimepsin) [Eimeria tenella] | diamond | 900 | 90.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 28485164 | 28485164 | PRJNA986481_P_NODE_44506_length_258_cov_2.703349_g43981_i0 | PRJNA986481 | 44506 | 258 | 2.703349 | 6.97464042 | root | 1 | Root_unresolved | Root_unresolved | 84 | 5.39e-19 | NR | XP_067803900.1 | 323732 | g43981 | i0 | 58.1 | 5.74418604651163 | 62 | 26 | 72.1 | 0 | 4 | 189 | 14 | 75 | XP_067803900.1 bifunctional Acyl-CoA-binding protein [Babesia duncani] | diamond | 1482 | 84 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 28516765 | 28516765 | PRJNA986481_P_NODE_55227_length_246_cov_1.766497_g54702_i0 | PRJNA986481 | 55227 | 246 | 1.766497 | 4.34558262 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 1.01e-14 | NR | XP_067920711.1 | 483139 | g54702 | i0 | 80.4 | 3.10975609756098 | 46 | 9 | 56.1 | 0 | 180 | 43 | 63 | 108 | XP_067920711.1 calmodulin [Cystoisospora suis] | diamond | 765 | 76.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 29274302 | 29274302 | PRJNA986481_P_NODE_20629_length_361_cov_1.294872_g20104_i0 | PRJNA986481 | 20629 | 361 | 1.294872 | 4.67448792 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 2.12e-17 | NR | ABK31937.1 | 5811 | g20104 | i0 | 44.6 | 6.10803324099723 | 121 | 53 | 89.8 | 6 | 361 | 38 | 286 | 405 | ABK31937.1 aspartic protease 6 [Toxoplasma gondii] | diamond | 2205 | 88.2 | 0.99092970521542 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 29394885 | 29394885 | PRJNA986481_P_NODE_29249_length_303_cov_1.322835_g28724_i0 | PRJNA986481 | 29249 | 303 | 1.322835 | 4.00819005 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 8.31e-14 | NR | XP_029215085.1 | 94643 | g28724 | i0 | 41.5 | 1.83168316831683 | 94 | 46 | 87.1 | 4 | 2 | 265 | 347 | 437 | XP_029215085.1 aspartyl protease [Besnoitia besnoiti] | diamond | 555 | 76.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 29521119 | 29521119 | PRJNA986481_P_NODE_63410_length_200_cov_4.847682_g62885_i0 | PRJNA986481 | 63410 | 200 | 4.847682 | 9.695364 | Toxoplasma gondii ARI | 1074872 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 4.16e-13 | NR | KYF40426.1 | 1074872 | g62885 | i0 | 63.6 | 0.66 | 44 | 16 | 66 | 0 | 196 | 65 | 86 | 129 | KYF40426.1 Tctex2-related light chain [Toxoplasma gondii ARI] | diamond | 132 | 69.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 29747805 | 29747805 | PRJNA986481_P_NODE_18890_length_376_cov_2.486239_g18365_i0 | PRJNA986481 | 18890 | 376 | 2.486239 | 9.34825864 | root | 1 | Root_unresolved | Root_unresolved | 81.3 | 3.08e-17 | NR | XP_955166.1 | 5874 | g18365 | i0 | 51.9 | 2.42553191489362 | 77 | 35 | 59.8 | 1 | 304 | 80 | 18 | 94 | XP_955166.1 high-mobility-group (HMG) protein, putative [Theileria annulata] | diamond | 912 | 81.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 29937665 | 29937665 | PRJNA986481_P_NODE_44231_length_259_cov_0.961905_g43706_i0 | PRJNA986481 | 44231 | 259 | 0.961905 | 2.49133395 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 1.68e-12 | NR | UKJ89915.2 | 68886 | g43706 | i0 | 43.8 | 2.55984555984556 | 80 | 44 | 91.5 | 1 | 255 | 19 | 988 | 1067 | UKJ89915.2 hypothetical protein MACJ_003169 [Theileria orientalis] | diamond | 663 | 72.8 | 0.994505494505495 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 30057870 | 30057870 | PRJNA986481_P_NODE_52931_length_249_cov_1.010000_g52406_i0 | PRJNA986481 | 52931 | 249 | 1.01 | 2.5149 | Porospora cf. gigantea B | 2853592 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 6.73e-26 | NR | XP_068377318.1 | 2853592 | g52406 | i0 | 67.9 | 2.92771084337349 | 81 | 26 | 97.6 | 0 | 244 | 2 | 1 | 81 | XP_068377318.1 MAG: uncharacterized protein KVP17_004068 [Porospora cf. gigantea B] | diamond | 729 | 105 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea B | ||
| 30121041 | 30121041 | PRJNA986481_P_NODE_28112_length_309_cov_2.292308_g27587_i0 | PRJNA986481 | 28112 | 309 | 2.292308 | 7.08323172 | Toxoplasma gondii GT1 | 507601 | SAR_Eukaryotes | SAR_Eukaryotes | 84 | 1.35e-17 | NR | EPR60526.1 | 507601 | g27587 | i0 | 54.9 | 2.54368932038835 | 82 | 30 | 72.8 | 2 | 82 | 306 | 49 | 130 | EPR60526.1 putative adrenodoxin-type ferredoxin [Toxoplasma gondii GT1] | diamond | 786 | 84 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 30311266 | 30311266 | PRJNA986481_P_NODE_23252_length_340_cov_1.800687_g22727_i0 | PRJNA986481 | 23252 | 340 | 1.800687 | 6.1223358 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 2.1099999999999998e-47 | NR | UKK01874.1 | 68886 | g22727 | i0 | 71.4 | 0.988235294117647 | 112 | 32 | 98.8 | 0 | 337 | 2 | 12 | 123 | UKK01874.1 calmodulin [Theileria orientalis] | diamond | 336 | 159 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 30443226 | 30443226 | PRJNA986481_P_NODE_45333_length_257_cov_2.096154_g44808_i0 | PRJNA986481 | 45333 | 257 | 2.096154 | 5.38711578 | root | 1 | Root_unresolved | Root_unresolved | 42.7 | 0.0398 | NR | BAN64943.1 | 5865 | g44808 | i0 | 43.2 | 1.43579766536965 | 44 | 24 | 50.2 | 1 | 3 | 131 | 210 | 253 | BAN64943.1 40S ribosomal protein S3Ae, putative [Babesia bovis] | diamond | 369 | 42.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 30563231 | 30563231 | PRJNA986481_P_NODE_61393_length_235_cov_2.172043_g60868_i0 | PRJNA986481 | 61393 | 235 | 2.172043 | 5.10430105 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 4.61e-8 | NR | XP_026191053.1 | 88456 | g60868 | i0 | 40.3 | 0.982978723404255 | 77 | 44 | 97 | 2 | 235 | 8 | 98 | 173 | XP_026191053.1 heterogeneous nuclear ribonucleoprotein D-like-A [Cyclospora cayetanensis] | diamond | 231 | 59.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 31264644 | 31264644 | PRJNA986481_P_NODE_29755_length_300_cov_1.621514_g29230_i0 | PRJNA986481 | 29755 | 300 | 1.621514 | 4.864542 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 7.96e-24 | NR | XP_012769233.1 | 5866 | g29230 | i0 | 56.1 | 4.21 | 82 | 36 | 82 | 0 | 247 | 2 | 21 | 102 | XP_012769233.1 mitochondrial carrier protein family protein, putative [Babesia bigemina] | diamond | 1263 | 102 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 31327828 | 31327828 | PRJNA986481_P_NODE_15615_length_415_cov_2.948087_g15090_i0 | PRJNA986481 | 15615 | 415 | 2.948087 | 12.23456105 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.8200000000000002e-71 | NR | CDU16580.1 | 5861 | g15090 | i0 | 79.2 | 8.53734939759036 | 130 | 25 | 92.5 | 1 | 385 | 2 | 1 | 130 | CDU16580.1 alpha tubulin 1 [Plasmodium yoelii] | diamond | 3543 | 232 | 0.991379310344828 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 32807665 | 32807665 | PRJNA986481_P_NODE_6480_length_632_cov_5.737564_g6003_i0 | PRJNA986481 | 6480 | 632 | 5.737564 | 36.26140448 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 1.09e-63 | NR | OEH76901.1 | 88456 | g6003 | i0 | 60 | 3.40822784810127 | 185 | 74 | 87.8 | 0 | 32 | 586 | 27 | 211 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 2154 | 206 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 32907978 | 32907978 | PRJNA986481_P_NODE_34420_length_278_cov_3.716157_g33895_i0 | PRJNA986481 | 34420 | 278 | 3.716157 | 10.33091646 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 2.9e-15 | NR | XP_067196590.1 | 515981 | g33895 | i0 | 42.7 | 7.79136690647482 | 82 | 46 | 87.4 | 1 | 31 | 273 | 42 | 123 | XP_067196590.1 uncharacterized protein FG386_001129 [Cryptosporidium ryanae] | diamond | 2166 | 77.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae |
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);;