contig_metadata
18 rows where bioproject = "PRJNA756891", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008057 | 2008057 | PRJNA756891_P_NODE_5162_length_373_cov_1.000000_g5093_i0 | PRJNA756891 | 5162 | 373 | 1 | 3.73 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|1620174044|ref|XM_028682437.1| | 880535 | g5093 | i0 | 100 | 0.0804289544235925 | 30 | 0 | 8 | 0 | 157 | 186 | 994 | 965 | Plasmodium sp. gorilla clade G2 conserved Plasmodium protein, unknown function (PADL01_1035500), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 7110746 | 7110746 | PRJNA756891_P_NODE_7406_length_317_cov_2.274590_g7337_i0 | PRJNA756891 | 7406 | 317 | 2.27459 | 7.2104503 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 6.38e-4 | NTclustered | gi|1145258134|ref|XM_012906805.2| | 5854 | g7337 | i0 | 88.235 | 0.249211356466877 | 51 | 3 | 16 | 2 | 161 | 211 | 4380 | 4333 | Plasmodium reichenowi hypothetical protein partial mRNA | blastn | 79 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 13485810 | 13485810 | PRJNA756891_P_NODE_5091_length_375_cov_1.274834_g5022_i0 | PRJNA756891 | 5091 | 375 | 1.274834 | 4.7806275 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 4.39e-18 | NR | KFG62839.1 | 935652 | g5022 | i0 | 39.6 | 5.856 | 106 | 54 | 84.8 | 1 | 319 | 2 | 690 | 785 | KFG62839.1 putative histone kinase SNF1, partial [Toxoplasma gondii RUB] | diamond | 2196 | 90.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 14760974 | 14760974 | PRJNA756891_P_NODE_6392_length_338_cov_1.403774_g6323_i0 | PRJNA756891 | 6392 | 338 | 1.403774 | 4.74475612 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 3.8199999999999995e-56 | NTclustered | gi|1620150562|ref|XM_028678648.1| | 85471 | g6323 | i0 | 79.635 | 54.4940828402367 | 329 | 61 | 96 | 6 | 2 | 327 | 782 | 457 | Plasmodium relictum polyubiquitin, putative (PRELSG_1312500), partial mRNA | blastn | 18419 | 231 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 15230807 | 15230807 | PRJNA756891_P_NODE_9232_length_286_cov_1.920188_g9163_i0 | PRJNA756891 | 9232 | 286 | 1.920188 | 5.49173768 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.68e-4 | NTclustered | gi|1145258288|ref|XM_012906887.2| | 5854 | g9163 | i0 | 94.595 | 1.64685314685315 | 37 | 2 | 13 | 0 | 105 | 141 | 646 | 682 | Plasmodium reichenowi hypothetical protein partial mRNA | blastn | 471 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 19054001 | 19054001 | PRJNA756891_P_NODE_8155_length_304_cov_1.333333_g8086_i0 | PRJNA756891 | 8155 | 304 | 1.333333 | 4.05333232 | Plasmodium vinckei petteri | 138298 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 8.88e-46 | NR | EUD71171.1 | 138298 | g8086 | i0 | 70.3 | 3.98684210526316 | 101 | 30 | 99.7 | 0 | 303 | 1 | 12 | 112 | EUD71171.1 eukaryotic translation initiation factor 5A-2 [Plasmodium vinckei petteri] | diamond | 1212 | 154 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 19859047 | 19859047 | PRJNA756891_P_NODE_2236_length_557_cov_1.681818_g2168_i0 | PRJNA756891 | 2236 | 557 | 1.681818 | 9.36772626 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.004 | NTclustered | gi|82540450|ref|XM_719449.1| | 5861 | g2168 | i0 | 96.97 | 0.059245960502693 | 33 | 1 | 6 | 0 | 185 | 217 | 496 | 464 | Plasmodium yoelii PUB domain-containing protein, putative (PY17X_1426000), partial mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 19859075 | 19859075 | PRJNA756891_P_NODE_7156_length_322_cov_1.236948_g7087_i0 | PRJNA756891 | 7156 | 322 | 1.236948 | 3.98297256 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|2795620672|ref|XM_068064366.1| | 483139 | g7087 | i0 | 100 | 5.40062111801242 | 29 | 0 | 9 | 0 | 62 | 90 | 484 | 456 | Cystoisospora suis spc97 spc98 family protein (CSUI_004173), mRNA | blastn | 1739 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 21604435 | 21604435 | PRJNA756891_P_NODE_6817_length_329_cov_0.863281_g6748_i0 | PRJNA756891 | 6817 | 329 | 0.863281 | 2.84019449 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.009 | NTclustered | gi|296004811|ref|XM_002808712.1| | 36329 | g6748 | i0 | 100 | 0.279635258358663 | 29 | 0 | 9 | 0 | 137 | 165 | 3459 | 3431 | Plasmodium falciparum 3D7 importin-7, putative (PF3D7_0706000), partial mRNA | blastn | 92 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 26619553 | 26619553 | PRJNA756891_P_NODE_2541_length_524_cov_1.241685_g2473_i0 | PRJNA756891 | 2541 | 524 | 1.241685 | 6.5064294 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 170 | 7.03e-50 | NR | EDL42590.1 | 5855 | g2473 | i0 | 57.4 | 7.09351145038168 | 136 | 57 | 77.9 | 1 | 101 | 508 | 15 | 149 | EDL42590.1 cyclophilin, putative [Plasmodium vivax] | diamond | 3717 | 171 | 0.994152046783626 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 26768087 | 26768087 | PRJNA756891_P_NODE_12141_length_251_cov_0.865169_g12072_i0 | PRJNA756891 | 12141 | 251 | 0.865169 | 2.17157419 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 3.12e-44 | NR | UKK02294.2 | 68886 | g12072 | i0 | 90.4 | 4.9601593625498 | 83 | 8 | 99.2 | 0 | 2 | 250 | 73 | 155 | UKK02294.2 putative ADP/ATP transporter [Theileria orientalis] | diamond | 1245 | 154 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 26967764 | 26967764 | PRJNA756891_P_NODE_7202_length_321_cov_1.552419_g7133_i0 | PRJNA756891 | 7202 | 321 | 1.552419 | 4.98326499 | root | 1 | Root_unresolved | Root_unresolved | 124 | 2.9799999999999997e-30 | NR | XP_029220325.1 | 94643 | g7133 | i0 | 51 | 8.75700934579439 | 104 | 51 | 97.2 | 0 | 2 | 313 | 134 | 237 | XP_029220325.1 hypothetical protein BESB_045080 [Besnoitia besnoiti] | diamond | 2811 | 125 | 0.992 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 27053018 | 27053018 | PRJNA756891_P_NODE_3042_length_479_cov_6.793103_g2974_i0 | PRJNA756891 | 3042 | 479 | 6.793103 | 32.53896337 | Babesia sp. Xinjiang | 462227 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 0.00623 | NR | XP_028872201.1 | 462227 | g2974 | i0 | 29.2 | 0.707724425887265 | 113 | 58 | 65.8 | 5 | 358 | 44 | 265 | 363 | XP_028872201.1 Ubiquitin fusion degradation protein 1 -like protein [Babesia sp. Xinjiang] | diamond | 339 | 47.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia sp. Xinjiang | ||
| 27874171 | 27874171 | PRJNA756891_P_NODE_11385_length_259_cov_1.650538_g11316_i0 | PRJNA756891 | 11385 | 259 | 1.650538 | 4.27489342 | Cryptosporidium felis | 83540 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 1.11e-11 | NR | KAF7455933.1 | 83540 | g11316 | i0 | 49.3 | 0.822393822393822 | 71 | 36 | 82.2 | 0 | 235 | 23 | 1 | 71 | KAF7455933.1 U3 small nucleolar RNA-associated protein 6 [Cryptosporidium felis] | diamond | 213 | 70.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium felis | ||
| 27874176 | 27874176 | PRJNA756891_P_NODE_14605_length_245_cov_0.895349_g14536_i0 | PRJNA756891 | 14605 | 245 | 0.895349 | 2.19360505 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 9.36e-4 | NR | XP_028867159.1 | 189622 | g14536 | i0 | 35.7 | 4.78775510204082 | 56 | 35 | 68.6 | 1 | 70 | 237 | 107 | 161 | XP_028867159.1 Polyubiqutin 1, putative [Babesia ovata] | diamond | 1173 | 46.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 28221343 | 28221343 | PRJNA756891_P_NODE_10546_length_269_cov_3.556122_g10477_i0 | PRJNA756891 | 10546 | 269 | 3.556122 | 9.56596818 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 1.1e-29 | NR | XP_013435839.1 | 51315 | g10477 | i0 | 70.2 | 0.936802973977695 | 84 | 24 | 93.7 | 1 | 18 | 269 | 15 | 97 | XP_013435839.1 lactoylglutathione lyase, putative [Eimeria necatrix] | diamond | 252 | 117 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 30757941 | 30757941 | PRJNA756891_P_NODE_3734_length_434_cov_2.011080_g3665_i0 | PRJNA756891 | 3734 | 434 | 2.01108 | 8.7280872 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 1.31e-32 | NR | XP_067182875.1 | 310047 | g3665 | i0 | 48.3 | 3.00691244239631 | 145 | 72 | 99.5 | 3 | 434 | 3 | 71 | 213 | XP_067182875.1 7 pass integral membrane with FLHWFHH motif shared with fatty-acyl elongase [Cryptosporidium bovis] | diamond | 1305 | 127 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis | ||
| 30811217 | 30811217 | PRJNA756891_P_NODE_8654_length_295_cov_1.387387_g8585_i0 | PRJNA756891 | 8654 | 295 | 1.387387 | 4.09279165 | Babesia gibsoni | 33632 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 1.82e-7 | NR | KAK1444879.1 | 33632 | g8585 | i0 | 39.3 | 0.854237288135593 | 84 | 45 | 85.4 | 3 | 253 | 2 | 43 | 120 | KAK1444879.1 creatinase/aminopeptidase like protein [Babesia gibsoni] | diamond | 252 | 58.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia gibsoni |
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);;