contig_metadata
16 rows where bioproject = "PRJNA975724" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7324035 | 7324035 | PRJNA975724_S_NODE_39206_length_321_cov_6.483871_g39025_i0 | PRJNA975724 | 39206 | 321 | 6.483871 | 20.81322591 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 96.7 | 3.29e-21 | NR | CAL7866125.1 | 1344799 | g39025 | i0 | 74.6 | 0.551401869158878 | 59 | 15 | 55.1 | 0 | 321 | 145 | 294 | 352 | CAL7866125.1 unnamed protein product [Sarcocystis calchasi] | diamond | 177 | 96.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 9874990 | 9874990 | PRJNA975724_S_NODE_67528_length_266_cov_1.994819_g67347_i0 | PRJNA975724 | 67528 | 266 | 1.994819 | 5.30621854 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.024 | NTclustered | gi|2795632404|ref|XM_068070232.1| | 483139 | g67347 | i0 | 100 | 0.105263157894737 | 28 | 0 | 11 | 0 | 239 | 266 | 3151 | 3178 | Cystoisospora suis uncharacterized protein (CSUI_010127), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 13701219 | 13701219 | PRJNA975724_S_NODE_9571_length_454_cov_30.244094_g9390_i0 | PRJNA975724 | 9571 | 454 | 30.244094 | 137.30818676 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 6.349999999999999e-43 | NR | XP_013233901.1 | 5802 | g9390 | i0 | 76.8 | 1.3215859030837 | 95 | 22 | 62.8 | 0 | 3 | 287 | 84 | 178 | XP_013233901.1 40S ribosomal protein S9, putative [Eimeria tenella] | diamond | 600 | 150 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 16248878 | 16248878 | PRJNA975724_S_NODE_3633_length_564_cov_2.150713_g3456_i0 | PRJNA975724 | 3633 | 564 | 2.150713 | 12.130021320000001 | Plasmodium ovale curtisi | 864141 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 3.39e-65 | NR | SBS86654.1 | 864141 | g3456 | i0 | 60.3 | 6.66489361702128 | 179 | 68 | 95.2 | 1 | 3 | 539 | 242 | 417 | SBS86654.1 elongation factor 2, putative (eEF2) [Plasmodium ovale curtisi] | diamond | 3759 | 224 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 16569327 | 16569327 | PRJNA975724_S_NODE_6093_length_500_cov_9.606557_g5914_i0 | PRJNA975724 | 6093 | 500 | 9.606557 | 48.032785 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 2.96e-22 | NR | KAF8822175.1 | 476202 | g5914 | i0 | 62 | 0.474 | 79 | 30 | 47.4 | 0 | 499 | 263 | 398 | 476 | KAF8822175.1 putative vacuolar ATP synthase subunit b [Cardiosporidium cionae] | diamond | 237 | 103 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 18798433 | 18798433 | PRJNA975724_S_NODE_59615_length_279_cov_2.242718_g59434_i0 | PRJNA975724 | 59615 | 279 | 2.242718 | 6.25718322 | Theileria equi | 5872 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 1.14e-35 | NTclustered | gi|510901075|ref|XM_004829177.1| | 1537102 | g59434 | i0 | 79.565 | 13.1254480286738 | 230 | 45 | 82 | 2 | 1 | 229 | 414 | 186 | Theileria equi strain WA histone H2a, putative (BEWA_024170), mRNA | blastn | 3662 | 163 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 21347840 | 21347840 | PRJNA975724_S_NODE_26977_length_358_cov_2.550877_g26796_i0 | PRJNA975724 | 26977 | 358 | 2.550877 | 9.13213966 | Sarcocystis bertrami | 1962270 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 4.26e-21 | NTclustered | gi|1472905010|gb|MH025630.1| | 1962270 | g26796 | i0 | 88 | 0.994413407821229 | 100 | 9 | 28 | 2 | 118 | 217 | 1697 | 1601 | Sarcocystis bertrami isolate YDHSb7 28S ribosomal RNA gene, partial sequence | blastn | 356 | 115 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis bertrami | ||
| 21349336 | 21349336 | PRJNA975724_S_NODE_83417_length_247_cov_0.982759_g83236_i0 | PRJNA975724 | 83417 | 247 | 0.982759 | 2.42741473 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 5.54e-83 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g83236 | i0 | 92.857 | 24.7206477732794 | 224 | 11 | 91 | 4 | 25 | 247 | 102 | 321 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 6106 | 320 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 22624281 | 22624281 | PRJNA975724_S_NODE_8138_length_470_cov_5.783375_g7957_i0 | PRJNA975724 | 8138 | 470 | 5.783375 | 27.1818625 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 8.82e-64 | NR | EWC86021.1 | 5843 | g7957 | i0 | 67.1 | 10.2063829787234 | 140 | 46 | 89.4 | 0 | 462 | 43 | 2 | 141 | EWC86021.1 ribosomal protein L10.e [Plasmodium falciparum NF54] | diamond | 4797 | 202 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 24218453 | 24218453 | PRJNA975724_S_NODE_18179_length_395_cov_3.204969_g17998_i0 | PRJNA975724 | 18179 | 395 | 3.204969 | 12.65962755 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1.42e-22 | NR | GFE55349.1 | 5869 | g17998 | i0 | 62.1 | 3.04556962025316 | 66 | 25 | 50.1 | 0 | 27 | 224 | 649 | 714 | GFE55349.1 tRNA wybutosine-synthesizing 1 homolog [Babesia ovis] | diamond | 1203 | 104 | 0.990384615384615 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 26868008 | 26868008 | PRJNA975724_S_NODE_6241_length_497_cov_17.794811_g6062_i0 | PRJNA975724 | 6241 | 497 | 17.794811 | 88.44021067 | Babesia divergens | 32595 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 1.83e-40 | NR | KAK1932868.1 | 32595 | g6062 | i0 | 63.8 | 1.95573440643863 | 105 | 38 | 63.4 | 0 | 369 | 55 | 11 | 115 | KAK1932868.1 putative 60S ribosomal protein L35a [Babesia divergens] | diamond | 972 | 142 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia divergens | ||
| 27531541 | 27531541 | PRJNA975724_S_NODE_48883_length_299_cov_3.544248_g48702_i0 | PRJNA975724 | 48883 | 299 | 3.544248 | 10.59730152 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0479 | NR | UVC49371.1 | 68886 | g48702 | i0 | 40.3 | 0.622073578595318 | 62 | 34 | 62.2 | 1 | 297 | 112 | 128 | 186 | UVC49371.1 hypothetical protein MACK_003202 [Theileria orientalis] | diamond | 186 | 42.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 27601177 | 27601177 | PRJNA975724_S_NODE_36624_length_328_cov_2.670588_g36443_i0 | PRJNA975724 | 36624 | 328 | 2.670588 | 8.75952864 | Haemosporida | 5819 | SAR_Eukaryotes | SAR_Eukaryotes | 71.6 | 5.69e-12 | NR | SOV77090.1 | 880536 | g36443 | i0 | 45.3 | 1.28048780487805 | 64 | 35 | 58.5 | 0 | 325 | 134 | 252 | 315 | SOV77090.1 conserved Plasmodium protein, unknown function [Plasmodium sp. gorilla clade G3] | diamond | 420 | 72 | 0.994444444444444 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G3 | ||
| 30600862 | 30600862 | PRJNA975724_S_NODE_44373_length_309_cov_2.161017_g44192_i0 | PRJNA975724 | 44373 | 309 | 2.161017 | 6.67754253 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 1.16e-9 | NR | XP_667257.1 | 353151 | g44192 | i0 | 42.7 | 4.61165048543689 | 96 | 53 | 93.2 | 1 | 301 | 14 | 893 | 986 | XP_667257.1 G-protein associated signal transduction protein [Cryptosporidium hominis TU502] | diamond | 1425 | 65.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium hominis | ||
| 31606247 | 31606247 | PRJNA975724_S_NODE_9036_length_460_cov_4.578811_g8855_i0 | PRJNA975724 | 9036 | 460 | 4.578811 | 21.0625306 | Cryptosporidium canis | 195482 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 1.51e-15 | NR | KAJ1610553.1 | 195482 | g8855 | i0 | 41.7 | 3.97826086956522 | 84 | 49 | 54.8 | 0 | 32 | 283 | 80 | 163 | KAJ1610553.1 TB2/DP1/HVA22-like integral membrane protein [Cryptosporidium canis] | diamond | 1830 | 80.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium canis | ||
| 32870239 | 32870239 | PRJNA975724_S_NODE_81540_length_248_cov_8.497143_g81359_i0 | PRJNA975724 | 81540 | 248 | 8.497143 | 21.07291464 | Sarcocystis aucheniae | 65407 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 3.72e-7 | NR | WXH59474.1 | 65407 | g81359 | i0 | 66.7 | 0.471774193548387 | 39 | 13 | 47.2 | 0 | 6 | 122 | 641 | 679 | WXH59474.1 heat shock protein 70 [Sarcocystis aucheniae] | diamond | 117 | 57 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis aucheniae |
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);;