contig_metadata
17 rows where bioproject = "PRJNA1087264", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21870867 | 21870867 | PRJNA1087264_P_NODE_21718_length_161_cov_0.910714_g21636_i0 | PRJNA1087264 | 21718 | 161 | 0.910714 | 1.46624954 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 2e-15 | NR | KAF8822636.1 | 476202 | g21636 | i0 | 73.1 | 0.968944099378882 | 52 | 14 | 96.9 | 0 | 159 | 4 | 268 | 319 | KAF8822636.1 putative eukaryotic initiation factor-2 gamma [Cardiosporidium cionae] | diamond | 156 | 79 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 23146192 | 23146192 | PRJNA1087264_P_NODE_12719_length_177_cov_1.195312_g12637_i0 | PRJNA1087264 | 12719 | 177 | 1.195312 | 2.11570224 | Cryptosporidium ryanae | 515981 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 1.13e-21 | NR | XP_067198213.1 | 515981 | g12637 | i0 | 74.1 | 5.89830508474576 | 58 | 15 | 98.3 | 0 | 3 | 176 | 255 | 312 | XP_067198213.1 uncharacterized protein FG386_000104 [Cryptosporidium ryanae] | diamond | 1044 | 97.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae | ||
| 23146196 | 23146196 | PRJNA1087264_P_NODE_12979_length_175_cov_1.214286_g12897_i0 | PRJNA1087264 | 12979 | 175 | 1.214286 | 2.1250005 | Cryptosporidium viatorum | 1176757 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 2.42e-15 | NTclustered | gi|441431303|gb|JX978273.1| | 1176757 | g12897 | i0 | 89.333 | 52.5771428571429 | 75 | 8 | 43 | 0 | 47 | 121 | 1770 | 1844 | Cryptosporidium viatorum isolate Swec025 70 kDa heat shock protein (HSP70) gene, partial cds | blastn | 9201 | 95.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium viatorum | ||
| 23146255 | 23146255 | PRJNA1087264_P_NODE_2399_length_433_cov_2.286458_g2318_i0 | PRJNA1087264 | 2399 | 433 | 2.286458 | 9.90036314 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.042 | NTclustered | gi|1620172169|ref|XM_028682118.1| | 880535 | g2318 | i0 | 92.308 | 0.0900692840646651 | 39 | 0 | 9 | 2 | 366 | 403 | 9213 | 9249 | Plasmodium sp. gorilla clade G2 conserved Plasmodium protein, unknown function (PADL01_1006600), partial mRNA | blastn | 39 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 23146274 | 23146274 | PRJNA1087264_P_NODE_4499_length_306_cov_1.630350_g4417_i0 | PRJNA1087264 | 4499 | 306 | 1.63035 | 4.988871 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 155 | 1.35e-45 | NR | CAL7863955.1 | 1344799 | g4417 | i0 | 72 | 2.94117647058824 | 100 | 28 | 98 | 0 | 305 | 6 | 59 | 158 | CAL7863955.1 unnamed protein product [Sarcocystis calchasi] | diamond | 900 | 155 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 26615652 | 26615652 | PRJNA1087264_P_NODE_22081_length_153_cov_2.269231_g21999_i0 | PRJNA1087264 | 22081 | 153 | 2.269231 | 3.47192343 | Aconoidasida | 422676 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 1.98e-4 | NR | BAN64635.1 | 5865 | g21999 | i0 | 60 | 9.33333333333333 | 40 | 16 | 78.4 | 0 | 122 | 3 | 134 | 173 | BAN64635.1 40S ribosomal protein S3Ae, putative [Babesia bovis] | diamond | 1428 | 47.8 | 0.99163179916318 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 27225363 | 27225363 | PRJNA1087264_P_NODE_10363_length_196_cov_0.986395_g10281_i0 | PRJNA1087264 | 10363 | 196 | 0.986395 | 1.9333342 | Theileria equi strain WA | 1537102 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.0138 | NR | XP_004832879.1 | 1537102 | g10281 | i0 | 61.5 | 0.397959183673469 | 26 | 10 | 39.8 | 0 | 78 | 1 | 8 | 33 | XP_004832879.1 60S ribosomal protein L35a, putative [Theileria equi strain WA] | diamond | 78 | 42 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 27438444 | 27438444 | PRJNA1087264_P_NODE_5443_length_274_cov_1.360000_g5361_i0 | PRJNA1087264 | 5443 | 274 | 1.36 | 3.7264 | root | 1 | Root_unresolved | Root_unresolved | 134 | 4.96e-34 | NR | ABN55905.1 | 5811 | g5361 | i0 | 74.4 | 8.85766423357664 | 90 | 23 | 98.5 | 0 | 2 | 271 | 942 | 1031 | ABN55905.1 PMCA-type calcium ATPase A2 [Toxoplasma gondii] | diamond | 2427 | 135 | 0.992592592592593 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 27825746 | 27825746 | PRJNA1087264_P_NODE_9524_length_204_cov_1.354839_g9442_i0 | PRJNA1087264 | 9524 | 204 | 1.354839 | 2.76387156 | Cryptosporidium parvum Iowa II | 353152 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 9.989999999999999e-17 | NR | XP_625504.1 | 353152 | g9442 | i0 | 58.2 | 1.98529411764706 | 67 | 28 | 98.5 | 0 | 204 | 4 | 183 | 249 | XP_625504.1 60S ribosomal protein L7A, partial [Cryptosporidium parvum Iowa II] | diamond | 405 | 81.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 29742849 | 29742849 | PRJNA1087264_P_NODE_6230_length_255_cov_1.456311_g6148_i0 | PRJNA1087264 | 6230 | 255 | 1.456311 | 3.71359305 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 5.96e-35 | NR | XP_067804708.1 | 323732 | g6148 | i0 | 74.1 | 12 | 85 | 22 | 100 | 0 | 255 | 1 | 3 | 87 | XP_067804708.1 bifunctional Ribosomal protein S8e/Ribosomal protein S8e [Babesia duncani] | diamond | 3060 | 127 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 29932763 | 29932763 | PRJNA1087264_P_NODE_13051_length_174_cov_2.040000_g12969_i0 | PRJNA1087264 | 13051 | 174 | 2.04 | 3.5496 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 7.24e-14 | NR | XP_001612131.1 | 484906 | g12969 | i0 | 54.5 | 10.6034482758621 | 55 | 25 | 94.8 | 0 | 167 | 3 | 362 | 416 | XP_001612131.1 Papain cysteine protease family protein [Babesia bovis T2Bo] | diamond | 1845 | 74.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 30943761 | 30943761 | PRJNA1087264_P_NODE_7314_length_233_cov_1.320652_g7232_i0 | PRJNA1087264 | 7314 | 233 | 1.320652 | 3.07711916 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 2.42e-16 | NR | KAF8822296.1 | 476202 | g7232 | i0 | 51.9 | 13.8798283261803 | 77 | 37 | 99.1 | 0 | 231 | 1 | 151 | 227 | KAF8822296.1 ribosomal protein RPL4 [Cardiosporidium cionae] | diamond | 3234 | 82.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 31038702 | 31038702 | PRJNA1087264_P_NODE_19115_length_163_cov_0.894737_g19033_i0 | PRJNA1087264 | 19115 | 163 | 0.894737 | 1.45842131 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 3.13e-18 | NR | EPR61441.1 | 507601 | g19033 | i0 | 74.1 | 9.93865030674847 | 54 | 14 | 99.4 | 0 | 162 | 1 | 156 | 209 | EPR61441.1 putative translation elongation factor 2 family protein [Toxoplasma gondii GT1] | diamond | 1620 | 87.8 | 0.990888382687927 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 31512835 | 31512835 | PRJNA1087264_P_NODE_18656_length_164_cov_0.886957_g18574_i0 | PRJNA1087264 | 18656 | 164 | 0.886957 | 1.45460948 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 8.7e-6 | NR | XP_013337589.1 | 5804 | g18574 | i0 | 59.5 | 25.1341463414634 | 42 | 17 | 76.8 | 0 | 158 | 33 | 222 | 263 | XP_013337589.1 heat shock protein 90, putative [Eimeria maxima] | diamond | 4122 | 51.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 31607577 | 31607577 | PRJNA1087264_P_NODE_6896_length_241_cov_1.062500_g6814_i0 | PRJNA1087264 | 6896 | 241 | 1.0625 | 2.560625 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 9.96e-26 | NR | CDI75113.1 | 51316 | g6814 | i0 | 84.4 | 8.78838174273859 | 64 | 10 | 79.7 | 0 | 43 | 234 | 1 | 64 | CDI75113.1 40S ribosomal protein S17, putative [Eimeria praecox] | diamond | 2118 | 110 | 0.990909090909091 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria praecox | ||
| 31742544 | 31742544 | PRJNA1087264_P_NODE_6597_length_247_cov_1.030303_g6515_i0 | PRJNA1087264 | 6597 | 247 | 1.030303 | 2.54484841 | Neospora caninum Liverpool | 572307 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 6.12e-28 | NR | XP_003884403.1 | 572307 | g6515 | i0 | 61 | 5.79352226720648 | 82 | 32 | 99.6 | 0 | 2 | 247 | 12 | 93 | XP_003884403.1 hypothetical protein NCLIV_048030 [Neospora caninum Liverpool] | diamond | 1431 | 107 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 31797110 | 31797110 | PRJNA1087264_P_NODE_14097_length_167_cov_1.296610_g14015_i0 | PRJNA1087264 | 14097 | 167 | 1.29661 | 2.1653387 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 4.92e-15 | NR | UKK02333.1 | 68886 | g14015 | i0 | 69.1 | 1.95808383233533 | 55 | 17 | 98.8 | 0 | 2 | 166 | 124 | 178 | UKK02333.1 60S ribosomal protein L10 [Theileria orientalis] | diamond | 327 | 76.3 | 0.99475753604194 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis |
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);;