contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA874604" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 852170 | 852170 | PRJNA874604_P_NODE_57141_length_271_cov_1.409091_g56789_i0 | PRJNA874604 | 57141 | 271 | 1.409091 | 3.81863661 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 5.88e-16 | NR | CDI74584.1 | 51316 | g56789 | i0 | 60 | 3.77490774907749 | 65 | 21 | 72 | 2 | 77 | 271 | 162 | 221 | CDI74584.1 thioredoxin, putative [Eimeria praecox] | diamond | 1023 | 82.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria praecox | ||
| 4679857 | 4679857 | PRJNA874604_P_NODE_19624_length_406_cov_1.387387_g19272_i0 | PRJNA874604 | 19624 | 406 | 1.387387 | 5.63279122 | Cryptosporidium andersoni | 117008 | SAR_Eukaryotes | SAR_Eukaryotes | 181 | 9.89e-54 | NR | XP_067068911.1 | 117008 | g19272 | i0 | 66.9 | 17.032019704433502 | 136 | 41 | 98.3 | 3 | 3 | 401 | 23 | 157 | XP_067068911.1 carrier protein [Cryptosporidium andersoni] | diamond | 6915 | 181 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 10166815 | 10166815 | PRJNA874604_P_NODE_7688_length_602_cov_1.062382_g7346_i0 | PRJNA874604 | 7688 | 602 | 1.062382 | 6.39553964 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 264 | 6.619999999999999e-87 | NR | XP_013233901.1 | 5802 | g7346 | i0 | 71.9 | 1.83887043189369 | 178 | 50 | 88.7 | 0 | 579 | 46 | 1 | 178 | XP_013233901.1 40S ribosomal protein S9, putative [Eimeria tenella] | diamond | 1107 | 265 | 0.99622641509434 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 14880584 | 14880584 | PRJNA874604_P_NODE_78632_length_248_cov_0.880000_g78280_i0 | PRJNA874604 | 78632 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 6.33e-39 | NR | XP_029219402.1 | 94643 | g78280 | i0 | 81.3 | 10.6451612903226 | 80 | 15 | 96.8 | 0 | 246 | 7 | 38 | 117 | XP_029219402.1 ribosomal protein RPS20 [Besnoitia besnoiti] | diamond | 2640 | 135 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 17815758 | 17815758 | PRJNA874604_P_NODE_78594_length_248_cov_0.880000_g78242_i0 | PRJNA874604 | 78594 | 248 | 0.88 | 2.1824 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 4.93e-37 | NR | KAF8822952.1 | 476202 | g78242 | i0 | 79.3 | 11.8306451612903 | 82 | 17 | 99.2 | 0 | 246 | 1 | 686 | 767 | KAF8822952.1 aconitate hydratase ACN/IRP [Cardiosporidium cionae] | diamond | 2934 | 142 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 23803534 | 23803534 | PRJNA874604_P_NODE_12179_length_496_cov_1.250591_g11828_i0 | PRJNA874604 | 12179 | 496 | 1.250591 | 6.20293136 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 212 | 1.74e-67 | NR | XP_002365714.1 | 508771 | g11828 | i0 | 81.5 | 6.62903225806452 | 130 | 24 | 78.6 | 0 | 418 | 29 | 22 | 151 | XP_002365714.1 ribosomal protein RPS13 [Toxoplasma gondii ME49] | diamond | 3288 | 212 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 27157794 | 27157794 | PRJNA874604_P_NODE_45242_length_294_cov_1.787330_g44890_i0 | PRJNA874604 | 45242 | 294 | 1.78733 | 5.2547502 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 3.5499999999999995e-31 | NR | XP_012766397.1 | 5866 | g44890 | i0 | 68.5 | 6.70408163265306 | 73 | 23 | 74.5 | 0 | 3 | 221 | 60 | 132 | XP_012766397.1 40S ribosomal protein S15, putative [Babesia bigemina] | diamond | 1971 | 117 | 0.991452991452991 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 28326443 | 28326443 | PRJNA874604_P_NODE_37366_length_317_cov_1.692623_g37014_i0 | PRJNA874604 | 37366 | 317 | 1.692623 | 5.36561491 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 1.63e-39 | NR | XP_665568.1 | 353151 | g37014 | i0 | 68.4 | 81.3312302839117 | 95 | 30 | 89.9 | 0 | 287 | 3 | 4 | 98 | XP_665568.1 Pfsec61 [Cryptosporidium hominis TU502] | diamond | 25782 | 147 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium hominis | ||
| 28958277 | 28958277 | PRJNA874604_P_NODE_18748_length_413_cov_2.247059_g18396_i0 | PRJNA874604 | 18748 | 413 | 2.247059 | 9.28035367 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 2.2e-26 | NR | XP_013231199.1 | 5802 | g18396 | i0 | 51.9 | 5.37530266343826 | 106 | 51 | 77 | 0 | 95 | 412 | 119 | 224 | XP_013231199.1 40S ribosomal protein S3a [Eimeria tenella] | diamond | 2220 | 110 | 0.990909090909091 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 29683944 | 29683944 | PRJNA874604_P_NODE_94690_length_243_cov_0.876471_g94338_i0 | PRJNA874604 | 94690 | 243 | 0.876471 | 2.12982453 | root | 1 | Root_unresolved | Root_unresolved | 43.9 | 0.0143 | NR | XP_001610481.1 | 484906 | g94338 | i0 | 45.7 | 2.40740740740741 | 35 | 19 | 43.2 | 0 | 239 | 135 | 146 | 180 | XP_001610481.1 mitogen-activated protein kinase family protein [Babesia bovis T2Bo] | diamond | 585 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 29802440 | 29802440 | PRJNA874604_P_NODE_38591_length_313_cov_2.045833_g38239_i0 | PRJNA874604 | 38591 | 313 | 2.045833 | 6.40345729 | Babesia duncani | 323732 | SAR_Eukaryotes | SAR_Eukaryotes | 146 | 4.8099999999999996e-42 | NR | XP_067804708.1 | 323732 | g38239 | i0 | 66.3 | 10.0063897763578 | 104 | 35 | 99.7 | 0 | 313 | 2 | 2 | 105 | XP_067804708.1 bifunctional Ribosomal protein S8e/Ribosomal protein S8e [Babesia duncani] | diamond | 3132 | 146 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 30466289 | 30466289 | PRJNA874604_P_NODE_87393_length_245_cov_0.895349_g87041_i0 | PRJNA874604 | 87393 | 245 | 0.895349 | 2.19360505 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 7.82e-6 | NR | XP_011133061.1 | 110365 | g87041 | i0 | 55.1 | 0.6 | 49 | 22 | 60 | 0 | 6 | 152 | 21 | 69 | XP_011133061.1 dihydrolipoamide succinyltransferase component of 2-oxoglutarate dehydrogenase [Gregarina niphandrodes] | diamond | 147 | 53.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 30600292 | 30600292 | PRJNA874604_P_NODE_84453_length_246_cov_0.890173_g84101_i0 | PRJNA874604 | 84453 | 246 | 0.890173 | 2.18982558 | root | 1 | Root_unresolved | Root_unresolved | 107 | 5.0399999999999995e-25 | NR | CAL7865137.1 | 1344799 | g84101 | i0 | 58.5 | 10.0609756097561 | 82 | 34 | 100 | 0 | 246 | 1 | 243 | 324 | CAL7865137.1 unnamed protein product [Sarcocystis calchasi] | diamond | 2475 | 107 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 30908431 | 30908431 | PRJNA874604_P_NODE_21094_length_395_cov_1.276398_g20742_i0 | PRJNA874604 | 21094 | 395 | 1.276398 | 5.0417721 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 0.00371 | NR | XP_029219892.1 | 94643 | g20742 | i0 | 33.3 | 1.56455696202532 | 96 | 47 | 70.6 | 5 | 100 | 378 | 988 | 1069 | XP_029219892.1 hypothetical protein BESB_055340 [Besnoitia besnoiti] | diamond | 618 | 47.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 31264008 | 31264008 | PRJNA874604_P_NODE_77615_length_248_cov_0.880000_g77263_i0 | PRJNA874604 | 77615 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 9.56e-33 | NR | EWC85773.1 | 5843 | g77263 | i0 | 67.5 | 21.9798387096774 | 83 | 26 | 99.2 | 1 | 247 | 2 | 2 | 84 | EWC85773.1 ADP-ribosylation factor 1 [Plasmodium falciparum NF54] | diamond | 5451 | 125 | 0.992 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 31666996 | 31666996 | PRJNA874604_P_NODE_84097_length_246_cov_0.890173_g83745_i0 | PRJNA874604 | 84097 | 246 | 0.890173 | 2.18982558 | Toxoplasma gondii GT1 | 507601 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00706 | NR | EPR60593.1 | 507601 | g83745 | i0 | 36.4 | 0.939024390243902 | 77 | 37 | 79.3 | 1 | 229 | 35 | 71 | 147 | EPR60593.1 MORN repeat-containing protein [Toxoplasma gondii GT1] | diamond | 231 | 44.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 32078315 | 32078315 | PRJNA874604_P_NODE_47318_length_289_cov_1.425926_g46966_i0 | PRJNA874604 | 47318 | 289 | 1.425926 | 4.12092614 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 6.21e-7 | NR | XP_011134038.1 | 110365 | g46966 | i0 | 45.3 | 2.58477508650519 | 64 | 35 | 66.4 | 0 | 83 | 274 | 58 | 121 | XP_011134038.1 putative multiprotein bridging factor type 1 [Gregarina niphandrodes] | diamond | 747 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 32244940 | 32244940 | PRJNA874604_P_NODE_73778_length_250_cov_0.870056_g73426_i0 | PRJNA874604 | 73778 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 2.4799999999999994e-23 | NR | XP_067801460.1 | 323732 | g73426 | i0 | 54.2 | 13.944 | 83 | 38 | 99.6 | 0 | 2 | 250 | 159 | 241 | XP_067801460.1 bifunctional eRF1 [Babesia duncani] | diamond | 3486 | 102 | 0.990196078431373 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani |
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);;