contig_metadata
17 rows where bioproject = "PRJNA763243", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020163 | 2020163 | PRJNA763243_P_NODE_8022_length_518_cov_2.644944_g7681_i0 | PRJNA763243 | 8022 | 518 | 2.644944 | 13.70080992 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 1.22e-102 | NTclustered | gi|1843568304|ref|XM_034563737.1| | 5823 | g7681 | i0 | 85.052 | 98.6602316602317 | 388 | 49 | 75 | 6 | 132 | 518 | 1 | 380 | Plasmodium berghei ANKA polyubiquitin, putative (PBANKA_0610300), partial mRNA | blastn | 51106 | 387 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 3294782 | 3294782 | PRJNA763243_P_NODE_49303_length_256_cov_1.071038_g48957_i0 | PRJNA763243 | 49303 | 256 | 1.071038 | 2.74185728 | Cryptosporidium bovis | 310047 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|2787666010|ref|XM_067327603.1| | 310047 | g48957 | i0 | 92.308 | 0.265625 | 39 | 3 | 15 | 0 | 146 | 184 | 823 | 861 | Cryptosporidium bovis uncharacterized protein (FG379_002000), partial mRNA | blastn | 68 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis | ||
| 5847482 | 5847482 | PRJNA763243_P_NODE_6705_length_557_cov_9.803719_g6369_i0 | PRJNA763243 | 6705 | 557 | 9.803719 | 54.60671483 | Cystoisospora felis | 482539 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 1.88e-36 | NTclustered | gi|3323386|gb|U85705.1|IFU85705 | 482539 | g6369 | i0 | 92.982 | 20.4631956912029 | 114 | 8 | 20 | 0 | 41 | 154 | 2037 | 1924 | Isospora felis 28S large subunit ribosomal RNA gene, complete sequence | blastn | 11398 | 167 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora felis | ||
| 7122179 | 7122179 | PRJNA763243_P_NODE_47246_length_260_cov_1.486631_g46900_i0 | PRJNA763243 | 47246 | 260 | 1.486631 | 3.8652406 | root | 1 | Root_unresolved | Root_unresolved | 125 | 3.25e-31 | NR | XP_951965.1 | 5874 | g46900 | i0 | 89.6 | 9 | 67 | 7 | 77.3 | 0 | 204 | 4 | 59 | 125 | XP_951965.1 heat shock protein HSP70 homologue, putative [Theileria annulata] | diamond | 2340 | 126 | 0.992063492063492 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 8396193 | 8396193 | PRJNA763243_P_NODE_25627_length_320_cov_2.052632_g25281_i0 | PRJNA763243 | 25627 | 320 | 2.052632 | 6.5684224 | root | 1 | Root_unresolved | Root_unresolved | 125 | 5.309999999999999e-31 | NR | XP_951965.1 | 5874 | g25281 | i0 | 89.6 | 10.865625 | 67 | 7 | 62.8 | 0 | 115 | 315 | 59 | 125 | XP_951965.1 heat shock protein HSP70 homologue, putative [Theileria annulata] | diamond | 3477 | 126 | 0.992063492063492 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 9672297 | 9672297 | PRJNA763243_P_NODE_64728_length_239_cov_2.126506_g64382_i0 | PRJNA763243 | 64728 | 239 | 2.126506 | 5.08234934 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.021 | NTclustered | gi|1620172169|ref|XM_028682118.1| | 880535 | g64382 | i0 | 92.308 | 0.163179916317992 | 39 | 0 | 16 | 2 | 7 | 44 | 9249 | 9213 | 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 | ||
| 12684889 | 12684889 | PRJNA763243_P_NODE_35730_length_288_cov_4.451163_g35384_i0 | PRJNA763243 | 35730 | 288 | 4.451163 | 12.81934944 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 9.51e-7 | NTclustered | gi|527046689|tpe|HG323591.1| | 5807 | g35384 | i0 | 93.333 | 0.3125 | 45 | 3 | 16 | 0 | 176 | 220 | 156 | 200 | TPA: Cryptosporidium parvum SRP RNA for signal recognition particle RNA | blastn | 90 | 67.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 13497086 | 13497086 | PRJNA763243_P_NODE_43011_length_269_cov_19.755102_g42665_i0 | PRJNA763243 | 43011 | 269 | 19.755102 | 53.14122438 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.3e-4 | NTclustered | gi|820698945|tpe|LN714498.1| | 432359 | g42665 | i0 | 85.714 | 1.51301115241636 | 56 | 6 | 20 | 2 | 54 | 108 | 2293519 | 2293465 | TPA_asm: Toxoplasma gondii VEG, chromosome chrVIII, complete genome | blastn | 407 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 16508185 | 16508185 | PRJNA763243_P_NODE_61333_length_243_cov_0.905882_g60987_i0 | PRJNA763243 | 61333 | 243 | 0.905882 | 2.20129326 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 4.14e-12 | NR | XP_013249403.1 | 5801 | g60987 | i0 | 72.1 | 0.530864197530864 | 43 | 12 | 53.1 | 0 | 190 | 62 | 218 | 260 | XP_013249403.1 glycylpeptide N-tetradecanoyltransferase, putative [Eimeria acervulina] | diamond | 129 | 70.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 17320933 | 17320933 | PRJNA763243_P_NODE_11334_length_449_cov_3.050532_g10991_i0 | PRJNA763243 | 11334 | 449 | 3.050532 | 13.69688868 | Babesia microti | 5868 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.18e-17 | NTclustered | gi|1206245954|ref|XR_002459985.1| | 1133968 | g10991 | i0 | 83.784 | 17.6503340757238 | 111 | 16 | 24 | 2 | 192 | 301 | 3504 | 3613 | Babesia microti strain RI 28S ribosomal RNA rRNA | blastn | 7925 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 21607402 | 21607402 | PRJNA763243_P_NODE_39337_length_278_cov_10.526829_g38991_i0 | PRJNA763243 | 39337 | 278 | 10.526829 | 29.26458462 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.5e-4 | NTclustered | gi|527046684|tpe|HG323586.1| | 5833 | g38991 | i0 | 100 | 1.40647482014388 | 31 | 0 | 11 | 0 | 181 | 211 | 159 | 189 | TPA: Plasmodium falciparum SRP RNA for signal recognition particle RNA | blastn | 391 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 27315850 | 27315850 | PRJNA763243_P_NODE_48323_length_258_cov_1.064865_g47977_i0 | PRJNA763243 | 48323 | 258 | 1.064865 | 2.7473517 | Piroplasmida | 5863 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 1.31e-22 | NR | XP_012766668.1 | 5866 | g47977 | i0 | 52.4 | 5.76744186046512 | 84 | 40 | 97.7 | 0 | 6 | 257 | 18 | 101 | XP_012766668.1 ribosomal protein S25, putative [Babesia bigemina] | diamond | 1488 | 93.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 28515644 | 28515644 | PRJNA763243_P_NODE_54647_length_248_cov_3.605714_g54301_i0 | PRJNA763243 | 54647 | 248 | 3.605714 | 8.94217072 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 7.22e-26 | NR | XP_004828633.1 | 1537102 | g54301 | i0 | 61.4 | 7.88709677419355 | 83 | 28 | 95.6 | 1 | 10 | 246 | 134 | 216 | XP_004828633.1 60S ribosomal protein L5e, putative [Theileria equi strain WA] | diamond | 1956 | 107 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 28537699 | 28537699 | PRJNA763243_P_NODE_38727_length_280_cov_1.826087_g38381_i0 | PRJNA763243 | 38727 | 280 | 1.826087 | 5.1130436 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 1.7e-7 | NR | KAF8817676.1 | 476202 | g38381 | i0 | 41.6 | 0.825 | 77 | 43 | 80.4 | 1 | 45 | 269 | 80 | 156 | KAF8817676.1 hypothetical protein IE077_004244, partial [Cardiosporidium cionae] | diamond | 231 | 58.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 29484417 | 29484417 | PRJNA763243_P_NODE_14550_length_403_cov_2.463636_g14205_i0 | PRJNA763243 | 14550 | 403 | 2.463636 | 9.92845308 | Porospora cf. gigantea B | 2853592 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 2.17e-8 | NR | XP_068375068.1 | 2853592 | g14205 | i0 | 35.6 | 4.24317617866005 | 118 | 69 | 87.8 | 4 | 10 | 363 | 400 | 510 | XP_068375068.1 MAG: uncharacterized protein KVP17_004656 [Porospora cf. gigantea B] | diamond | 1710 | 62.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea B | ||
| 30189119 | 30189119 | PRJNA763243_P_NODE_35492_length_289_cov_1.763889_g35146_i0 | PRJNA763243 | 35492 | 289 | 1.763889 | 5.09763921 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 1.38e-17 | NR | AAF00541.1 | 5811 | g35146 | i0 | 52.4 | 4.28719723183391 | 82 | 39 | 85.1 | 0 | 4 | 249 | 346 | 427 | AAF00541.1 mitochondrial processing peptidase alpha subunit homolog, partial [Toxoplasma gondii] | diamond | 1239 | 87.8 | 0.990888382687927 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 31475374 | 31475374 | PRJNA763243_P_NODE_62536_length_242_cov_0.911243_g62190_i0 | PRJNA763243 | 62536 | 242 | 0.911243 | 2.20520806 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 2.18e-24 | NR | XP_026194393.1 | 88456 | g62190 | i0 | 57.9 | 15.1115702479339 | 76 | 32 | 94.2 | 0 | 236 | 9 | 35 | 110 | XP_026194393.1 malignant T-cell-amplified sequence 1 homolog [Cyclospora cayetanensis] | diamond | 3657 | 100 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis |
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);;