contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA630162" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9529799 | 9529799 | PRJNA630162_P_NODE_100228_length_185_cov_2.698529_g98705_i0 | PRJNA630162 | 100228 | 185 | 2.698529 | 4.99227865 | Theileria | 5873 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 3.98e-20 | NR | XP_953890.1 | 5874 | g98705 | i0 | 76.9 | 8.3027027027027 | 52 | 12 | 84.3 | 0 | 6 | 161 | 38 | 89 | XP_953890.1 eukaryotic translation initiation factor (eIF5A) [Theileria annulata] | diamond | 1536 | 87.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 12630277 | 12630277 | PRJNA630162_P_NODE_137570_length_167_cov_2.584746_g136047_i0 | PRJNA630162 | 137570 | 167 | 2.584746 | 4.31652582 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 75.5 | 3.56e-14 | NR | XP_011132156.1 | 110365 | g136047 | i0 | 69.2 | 1.88622754491018 | 52 | 16 | 93.4 | 0 | 159 | 4 | 181 | 232 | XP_011132156.1 tubulin beta chain [Gregarina niphandrodes] | diamond | 315 | 75.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 18453615 | 18453615 | PRJNA630162_P_NODE_132735_length_169_cov_0.866667_g131212_i0 | PRJNA630162 | 132735 | 169 | 0.866667 | 1.46466723 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 95.5 | 2.0299999999999998e-24 | NR | XP_018641788.1 | 647221 | g131212 | i0 | 79.2 | 11.3254437869822 | 53 | 11 | 94.1 | 0 | 9 | 167 | 3 | 55 | XP_018641788.1 alpha tubulin 1, partial [Plasmodium gaboni] | diamond | 1914 | 96.3 | 0.991692627206646 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 24828741 | 24828741 | PRJNA630162_P_NODE_62060_length_224_cov_3.222857_g60537_i0 | PRJNA630162 | 62060 | 224 | 3.222857 | 7.21919968 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 3.36e-35 | NR | ABU50373.1 | 5857 | g60537 | i0 | 82.2 | 13.6607142857143 | 73 | 13 | 97.8 | 0 | 6 | 224 | 140 | 212 | ABU50373.1 glyceraldehyde-3-phosphate dehydrogenase, partial [Plasmodium fragile] | diamond | 3060 | 131 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium fragile | ||
| 26859586 | 26859586 | PRJNA630162_P_NODE_25421_length_362_cov_10.156550_g23901_i0 | PRJNA630162 | 25421 | 362 | 10.15655 | 36.766711 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.0311 | NR | OEH73922.1 | 88456 | g23901 | i0 | 37.1 | 1.02762430939227 | 62 | 37 | 51.4 | 1 | 64 | 249 | 290 | 349 | OEH73922.1 hypothetical protein cyc_03523 [Cyclospora cayetanensis] | diamond | 372 | 44.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 27586216 | 27586216 | PRJNA630162_P_NODE_116364_length_176_cov_2.007874_g114841_i0 | PRJNA630162 | 116364 | 176 | 2.007874 | 3.53385824 | Neospora caninum Liverpool | 572307 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0214 | NR | XP_003883803.1 | 572307 | g114841 | i0 | 47.1 | 0.579545454545455 | 34 | 18 | 58 | 0 | 159 | 58 | 638 | 671 | XP_003883803.1 conserved hypothetical protein [Neospora caninum Liverpool] | diamond | 102 | 42.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 27757048 | 27757048 | PRJNA630162_P_NODE_155224_length_163_cov_1.473684_g153701_i0 | PRJNA630162 | 155224 | 163 | 1.473684 | 2.40210492 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 86.7 | 2.71e-18 | NR | XP_012767589.1 | 5866 | g153701 | i0 | 76.5 | 107.815950920245 | 51 | 12 | 93.9 | 0 | 3 | 155 | 60 | 110 | XP_012767589.1 ribosomal protein L3, putative [Babesia bigemina] | diamond | 17574 | 87.4 | 0.991990846681922 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 28185870 | 28185870 | PRJNA630162_P_NODE_157006_length_163_cov_0.912281_g155483_i0 | PRJNA630162 | 157006 | 163 | 0.912281 | 1.48701803 | Hepatocystis sp. ex Piliocolobus tephrosceles | 2600580 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 8.57e-12 | NR | VWU53187.1 | 2600580 | g155483 | i0 | 57.8 | 2.48466257668712 | 45 | 19 | 82.8 | 0 | 8 | 142 | 42 | 86 | VWU53187.1 eukaryotic translation initiation factor 5A, putative, partial [Hepatocystis sp. ex Piliocolobus tephrosceles] | diamond | 405 | 65.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Hepatocystis | Hepatocystis sp. ex Piliocolobus tephrosceles | ||
| 28514614 | 28514614 | PRJNA630162_P_NODE_38947_length_285_cov_6.694915_g37424_i0 | PRJNA630162 | 38947 | 285 | 6.694915 | 19.08050775 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 3.75e-7 | NR | EAA18798.1 | 73239 | g37424 | i0 | 43.8 | 3.17894736842105 | 73 | 39 | 74.7 | 1 | 41 | 253 | 21 | 93 | EAA18798.1 hypothetical protein [Plasmodium yoelii yoelii] | diamond | 906 | 55.1 | 0.992740471869329 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 29606691 | 29606691 | PRJNA630162_P_NODE_94230_length_189_cov_1.642857_g92707_i0 | PRJNA630162 | 94230 | 189 | 1.642857 | 3.10499973 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0071 | NR | KAF8820472.1 | 476202 | g92707 | i0 | 60 | 0.476190476190476 | 30 | 12 | 47.6 | 0 | 96 | 185 | 642 | 671 | KAF8820472.1 putative vacuolar sorting protein 35 [Cardiosporidium cionae] | diamond | 90 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 29808985 | 29808985 | PRJNA630162_P_NODE_106891_length_181_cov_2.613636_g105368_i0 | PRJNA630162 | 106891 | 181 | 2.613636 | 4.73068116 | Piroplasmida | 5863 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 2.17e-9 | NR | XP_067804115.1 | 323732 | g105368 | i0 | 50 | 6.7292817679558 | 58 | 29 | 96.1 | 0 | 174 | 1 | 139 | 196 | XP_067804115.1 bifunctional Ribosomal protein L10-like domain superfamily/50S ribosomal protein L10 [Babesia duncani] | diamond | 1218 | 62 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 30112299 | 30112299 | PRJNA630162_P_NODE_62012_length_224_cov_4.040000_g60489_i0 | PRJNA630162 | 62012 | 224 | 4.04 | 9.0496 | Cryptosporidium felis | 83540 | SAR_Eukaryotes | SAR_Eukaryotes | 41.2 | 0.0424 | NR | KAF7457853.1 | 83540 | g60489 | i0 | 65.6 | 0.428571428571429 | 32 | 10 | 41.5 | 1 | 127 | 219 | 61 | 92 | KAF7457853.1 Regulator of rDNA transcription protein 15 [Cryptosporidium felis] | diamond | 96 | 41.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium felis | ||
| 30315095 | 30315095 | PRJNA630162_P_NODE_94672_length_189_cov_1.228571_g93149_i0 | PRJNA630162 | 94672 | 189 | 1.228571 | 2.32199919 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 3.36e-5 | NR | BAN65106.1 | 5865 | g93149 | i0 | 73.3 | 1.42857142857143 | 30 | 8 | 47.6 | 0 | 98 | 187 | 54 | 83 | BAN65106.1 phosphoglycerate kinase [Babesia bovis] | diamond | 270 | 50.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 30333831 | 30333831 | PRJNA630162_P_NODE_110952_length_179_cov_1.784615_g109429_i0 | PRJNA630162 | 110952 | 179 | 1.784615 | 3.19446085 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 1.43e-4 | NR | XP_013229778.1 | 5802 | g109429 | i0 | 58.5 | 1.37430167597765 | 41 | 17 | 68.7 | 0 | 175 | 53 | 60 | 100 | XP_013229778.1 ribosomal protein L41, putative [Eimeria tenella] | diamond | 246 | 46.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 30491527 | 30491527 | PRJNA630162_P_NODE_164833_length_159_cov_2.790909_g163310_i0 | PRJNA630162 | 164833 | 159 | 2.790909 | 4.43754531 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 3.28e-7 | NR | XP_067925879.1 | 483139 | g163310 | i0 | 55.8 | 1.75471698113208 | 52 | 22 | 96.2 | 1 | 1 | 153 | 37 | 88 | XP_067925879.1 60s acidic ribosomal protein [Cystoisospora suis] | diamond | 279 | 54.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 30725271 | 30725271 | PRJNA630162_P_NODE_53494_length_241_cov_1.427083_g51971_i0 | PRJNA630162 | 53494 | 241 | 1.427083 | 3.43927003 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 4.63e-23 | NR | XP_029221901.1 | 94643 | g51971 | i0 | 59.7 | 5.80082987551867 | 77 | 31 | 95.9 | 0 | 237 | 7 | 19 | 95 | XP_029221901.1 ribosomal protein RPL7A [Besnoitia besnoiti] | diamond | 1398 | 100 | 0.99 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 30744266 | 30744266 | PRJNA630162_P_NODE_25754_length_360_cov_1.128617_g24234_i0 | PRJNA630162 | 25754 | 360 | 1.128617 | 4.0630212 | Cryptosporidium bovis | 310047 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 4.24e-6 | NR | XP_067184715.1 | 310047 | g24234 | i0 | 44.6 | 1.425 | 56 | 29 | 46.7 | 1 | 329 | 162 | 22 | 75 | XP_067184715.1 cold shock RNA binding domain of the OB fold [Cryptosporidium bovis] | diamond | 513 | 53.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis | ||
| 30820156 | 30820156 | PRJNA630162_P_NODE_155534_length_163_cov_1.359649_g154011_i0 | PRJNA630162 | 155534 | 163 | 1.359649 | 2.21622787 | Viridiplantae | 33090 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00143 | NR | KAF8821474.1 | 476202 | g154011 | i0 | 35.3 | 2.3558282208589 | 51 | 33 | 93.9 | 0 | 156 | 4 | 37 | 87 | KAF8821474.1 hypothetical protein IE077_001992, partial [Cardiosporidium cionae] | diamond | 384 | 45.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 30838952 | 30838952 | PRJNA630162_P_NODE_133714_length_168_cov_2.403361_g132191_i0 | PRJNA630162 | 133714 | 168 | 2.403361 | 4.03764648 | Cryptosporidium tyzzeri | 756076 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 2.36e-19 | NR | TRY53453.1 | 756076 | g132191 | i0 | 73.6 | 13.25 | 53 | 14 | 94.6 | 0 | 161 | 3 | 345 | 397 | TRY53453.1 Eukaryotic initiation factor 4A [Cryptosporidium tyzzeri] | diamond | 2226 | 89.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium tyzzeri | ||
| 30883235 | 30883235 | PRJNA630162_P_NODE_60134_length_227_cov_6.314607_g58611_i0 | PRJNA630162 | 60134 | 227 | 6.314607 | 14.33415789 | root | 1 | Root_unresolved | Root_unresolved | 44.3 | 0.00291 | NR | KAF7457853.1 | 83540 | g58611 | i0 | 54.3 | 1.25550660792952 | 46 | 20 | 59.5 | 1 | 92 | 226 | 59 | 104 | KAF7457853.1 Regulator of rDNA transcription protein 15 [Cryptosporidium felis] | diamond | 285 | 44.7 | 0.991051454138702 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium felis | ||
| 31502985 | 31502985 | PRJNA630162_P_NODE_135216_length_168_cov_1.176471_g133693_i0 | PRJNA630162 | 135216 | 168 | 1.176471 | 1.97647128 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 41.6 | 0.0297 | NR | XP_011132116.1 | 110365 | g133693 | i0 | 48.7 | 0.696428571428571 | 39 | 20 | 69.6 | 0 | 37 | 153 | 94 | 132 | XP_011132116.1 ankyrin repeat protein [Gregarina niphandrodes] | diamond | 117 | 41.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 32072236 | 32072236 | PRJNA630162_P_NODE_172718_length_151_cov_6.450980_g171195_i0 | PRJNA630162 | 172718 | 151 | 6.45098 | 9.7409798 | Theileria equi strain WA | 1537102 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 3.42e-4 | NR | XP_004832617.1 | 1537102 | g171195 | i0 | 60.5 | 0.754966887417219 | 38 | 15 | 75.5 | 0 | 32 | 145 | 87 | 124 | XP_004832617.1 hypothetical protein BEWA_052190 [Theileria equi strain WA] | diamond | 114 | 45.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 32704212 | 32704212 | PRJNA630162_P_NODE_159500_length_162_cov_1.548673_g157977_i0 | PRJNA630162 | 159500 | 162 | 1.548673 | 2.50885026 | Plasmodium fragile | 5857 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 5.25e-4 | NR | XP_012336558.1 | 5857 | g157977 | i0 | 65.7 | 5.55555555555556 | 35 | 12 | 64.8 | 0 | 154 | 50 | 280 | 314 | XP_012336558.1 uncharacterized protein AK88_03522 [Plasmodium fragile] | diamond | 900 | 46.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium fragile |
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);;