contig_metadata
21 rows where bioproject = "PRJDB3785", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4809097 | 4809097 | PRJDB3785_S_NODE_17984_length_186_cov_1.116788_g17831_i0 | PRJDB3785 | 17984 | 186 | 1.116788 | 2.07722568 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 1.53e-27 | NTclustered | gi|505337|gb|L34027.1|PFAHSP86A | 5833 | g17831 | i0 | 82.278 | 19.6720430107527 | 158 | 26 | 84 | 2 | 28 | 184 | 4595 | 4439 | Plasmodium falciparum (clone Dd2) heat shock protein 86 gene, complete cds | blastn | 3659 | 135 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 6387003 | 6387003 | PRJDB3785_S_NODE_13106_length_212_cov_1.564417_g12953_i0 | PRJDB3785 | 13106 | 212 | 1.564417 | 3.31656404 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 6.379999999999999e-37 | NTclustered | gi|1027960071|ref|XM_735127.2| | 31271 | g12953 | i0 | 85.897 | 57.4198113207547 | 156 | 22 | 74 | 0 | 35 | 190 | 1131 | 976 | Plasmodium chabaudi chabaudi actin I, putative (PCHAS_1461600), partial mRNA | blastn | 12173 | 167 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 6387019 | 6387019 | PRJDB3785_S_NODE_14366_length_204_cov_1.638710_g14213_i0 | PRJDB3785 | 14366 | 204 | 1.6387100000000001 | 3.3429684 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 8.050000000000001e-21 | NTclustered | gi|1620141318|ref|XM_028676575.1| | 85471 | g14213 | i0 | 86.408 | 21.2794117647059 | 103 | 14 | 50 | 0 | 101 | 203 | 40 | 142 | Plasmodium relictum GTP-binding nuclear protein RAN/TC4, putative (RAN), partial mRNA | blastn | 4341 | 113 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 10211794 | 10211794 | PRJDB3785_S_NODE_5329_length_328_cov_1.261649_g5176_i0 | PRJDB3785 | 5329 | 328 | 1.261649 | 4.13820872 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.031 | NTclustered | gi|124806941|ref|XM_001350835.1| | 36329 | g5176 | i0 | 100 | 0.0853658536585366 | 28 | 0 | 9 | 0 | 166 | 193 | 1770 | 1743 | Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_1248700), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 17860584 | 17860584 | PRJDB3785_S_NODE_15615_length_197_cov_1.587838_g15462_i0 | PRJDB3785 | 15615 | 197 | 1.587838 | 3.12804086 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 1.11e-15 | NR | KAF8817721.1 | 476202 | g15462 | i0 | 76 | 10.751269035533 | 50 | 11 | 76.1 | 1 | 150 | 1 | 17 | 65 | KAF8817721.1 putative proteasome subunit alpha2, protease of the acylase family and NTN hydrolase fold [Cardiosporidium cionae] | diamond | 2118 | 78.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 24234548 | 24234548 | PRJDB3785_S_NODE_10840_length_230_cov_1.685083_g10687_i0 | PRJDB3785 | 10840 | 230 | 1.685083 | 3.8756909 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 1.22e-29 | NR | XP_067070022.1 | 117008 | g10687 | i0 | 85.9 | 4.17391304347826 | 64 | 9 | 83.5 | 0 | 38 | 229 | 1 | 64 | XP_067070022.1 60s ribosomal protein L3 [Cryptosporidium andersoni] | diamond | 960 | 119 | 0.991596638655462 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 26810945 | 26810945 | PRJDB3785_S_NODE_26641_length_162_cov_0.902655_g26488_i0 | PRJDB3785 | 26641 | 162 | 0.902655 | 1.4623011 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 60.1 | 9.25e-9 | NR | KAF8817917.1 | 476202 | g26488 | i0 | 76.3 | 0.703703703703704 | 38 | 9 | 70.4 | 0 | 115 | 2 | 130 | 167 | KAF8817917.1 sarco/endoplasmic reticulum Ca2+-ATPase, partial [Cardiosporidium cionae] | diamond | 114 | 60.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 27247803 | 27247803 | PRJDB3785_S_NODE_17943_length_186_cov_1.240876_g17790_i0 | PRJDB3785 | 17943 | 186 | 1.240876 | 2.30802936 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 5.86e-4 | NR | KEG00995.1 | 54757 | g17790 | i0 | 42.9 | 6.41935483870968 | 56 | 32 | 90.3 | 0 | 183 | 16 | 5682 | 5737 | KEG00995.1 hypothetical protein YYE_04028 [Plasmodium vinckei vinckei] | diamond | 1194 | 47 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 27974146 | 27974146 | PRJDB3785_S_NODE_16485_length_193_cov_1.395833_g16332_i0 | PRJDB3785 | 16485 | 193 | 1.395833 | 2.69395769 | Piroplasmida | 5863 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00152 | NR | AAK07769.1 | 5865 | g16332 | i0 | 43.6 | 4.72538860103627 | 55 | 30 | 85.5 | 1 | 165 | 1 | 116 | 169 | AAK07769.1 putative N-methyl-aspartate receptor [Babesia bovis] | diamond | 912 | 45.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 28043198 | 28043198 | PRJDB3785_S_NODE_1845_length_589_cov_10.568519_g1707_i0 | PRJDB3785 | 1845 | 589 | 10.568519 | 62.24857691 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 3.2200000000000005e-64 | NR | OEH76901.1 | 88456 | g1707 | i0 | 60.7 | 3.65704584040747 | 183 | 72 | 93.2 | 0 | 5 | 553 | 29 | 211 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 2154 | 207 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 28106214 | 28106214 | PRJDB3785_S_NODE_26365_length_162_cov_1.132743_g26212_i0 | PRJDB3785 | 26365 | 162 | 1.132743 | 1.83504366 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 7.18e-19 | NR | CAL7860658.1 | 1344799 | g26212 | i0 | 66.7 | 12.9259259259259 | 54 | 18 | 100 | 0 | 162 | 1 | 57 | 110 | CAL7860658.1 unnamed protein product [Sarcocystis calchasi] | diamond | 2094 | 83.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 28289719 | 28289719 | PRJDB3785_S_NODE_3486_length_412_cov_1.322314_g3333_i0 | PRJDB3785 | 3486 | 412 | 1.322314 | 5.44793368 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 2.8499999999999995e-35 | NR | XP_012337879.1 | 5857 | g3333 | i0 | 51.4 | 4.07766990291262 | 142 | 60 | 97.6 | 3 | 405 | 4 | 114 | 254 | XP_012337879.1 asparagine-tRNA ligase [Plasmodium fragile] | diamond | 1680 | 139 | 0.992805755395683 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium fragile | ||
| 28390469 | 28390469 | PRJDB3785_S_NODE_15786_length_196_cov_1.734694_g15633_i0 | PRJDB3785 | 15786 | 196 | 1.734694 | 3.40000024 | Hepatocystis sp. ex Piliocolobus tephrosceles | 2600580 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 3.81e-24 | NR | VWU50564.1 | 2600580 | g15633 | i0 | 76.9 | 2.98469387755102 | 65 | 15 | 99.5 | 0 | 195 | 1 | 274 | 338 | VWU50564.1 S-adenosylmethionine synthetase, putative [Hepatocystis sp. ex Piliocolobus tephrosceles] | diamond | 585 | 103 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Hepatocystis | Hepatocystis sp. ex Piliocolobus tephrosceles | ||
| 28479385 | 28479385 | PRJDB3785_S_NODE_23786_length_166_cov_0.914530_g23633_i0 | PRJDB3785 | 23786 | 166 | 0.91453 | 1.5181198 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 2.03e-14 | NR | XP_067717277.1 | 5871 | g23633 | i0 | 69.2 | 16.5542168674699 | 52 | 16 | 94 | 0 | 157 | 2 | 605 | 656 | XP_067717277.1 26S proteasome regulatory subunit [Babesia caballi] | diamond | 2748 | 77 | 0.990909090909091 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 28548586 | 28548586 | PRJDB3785_S_NODE_5307_length_328_cov_8.397849_g5154_i0 | PRJDB3785 | 5307 | 328 | 8.397849 | 27.54494472 | Babesia duncani | 323732 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 4.78e-41 | NR | XP_067804708.1 | 323732 | g5154 | i0 | 69.4 | 9.89634146341463 | 98 | 30 | 89.6 | 0 | 315 | 22 | 1 | 98 | XP_067804708.1 bifunctional Ribosomal protein S8e/Ribosomal protein S8e [Babesia duncani] | diamond | 3246 | 144 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 29116866 | 29116866 | PRJDB3785_S_NODE_24049_length_166_cov_0.871795_g23896_i0 | PRJDB3785 | 24049 | 166 | 0.871795 | 1.4471797 | Babesia bovis T2Bo | 484906 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 8.92e-9 | NR | XP_001609795.1 | 484906 | g23896 | i0 | 50.9 | 2.98192771084337 | 55 | 27 | 99.4 | 0 | 165 | 1 | 64 | 118 | XP_001609795.1 Proteasome subunit beta type-1 family protein [Babesia bovis T2Bo] | diamond | 495 | 59.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 29148704 | 29148704 | PRJDB3785_S_NODE_7629_length_272_cov_1.130045_g7476_i0 | PRJDB3785 | 7629 | 272 | 1.130045 | 3.0737224 | Theileria parva strain Muguga | 333668 | SAR_Eukaryotes | SAR_Eukaryotes | 94.7 | 1.51e-20 | NR | XP_764530.1 | 333668 | g7476 | i0 | 64.6 | 1.46691176470588 | 65 | 23 | 71.7 | 0 | 2 | 196 | 332 | 396 | XP_764530.1 methionine adenosyltransferase [Theileria parva strain Muguga] | diamond | 399 | 94.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria parva | ||
| 29369340 | 29369340 | PRJDB3785_S_NODE_25209_length_164_cov_0.886957_g25056_i0 | PRJDB3785 | 25209 | 164 | 0.886957 | 1.45460948 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 6.39e-13 | NR | OEH74043.1 | 88456 | g25056 | i0 | 59.6 | 8.61585365853658 | 52 | 21 | 95.1 | 0 | 161 | 6 | 158 | 209 | OEH74043.1 ribosomal protein rpp0 [Cyclospora cayetanensis] | diamond | 1413 | 70.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 31486371 | 31486371 | PRJDB3785_S_NODE_6716_length_290_cov_1.692946_g6563_i0 | PRJDB3785 | 6716 | 290 | 1.692946 | 4.9095434 | Neospora caninum Liverpool | 572307 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0368 | NR | XP_003880431.1 | 572307 | g6563 | i0 | 28.3 | 1.02413793103448 | 99 | 65 | 96.2 | 1 | 283 | 5 | 1155 | 1253 | XP_003880431.1 putative adenylate and guanylate cyclase catalytic domain-containing protein [Neospora caninum Liverpool] | diamond | 297 | 43.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 32461102 | 32461102 | PRJDB3785_S_NODE_8719_length_255_cov_2.029126_g8566_i0 | PRJDB3785 | 8719 | 255 | 2.029126 | 5.1742713 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.86e-28 | NR | OEH76901.1 | 88456 | g8566 | i0 | 74.7 | 9.76470588235294 | 75 | 19 | 88.2 | 0 | 1 | 225 | 99 | 173 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 2490 | 111 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 32845178 | 32845178 | PRJDB3785_S_NODE_11340_length_226_cov_1.231638_g11187_i0 | PRJDB3785 | 11340 | 226 | 1.231638 | 2.78350188 | Cryptosporidium felis | 83540 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 7.48e-6 | NR | KAF7459076.1 | 83540 | g11187 | i0 | 55.6 | 1.18141592920354 | 45 | 19 | 59.7 | 1 | 90 | 224 | 10 | 53 | KAF7459076.1 ribosomal protein RPL35A [Cryptosporidium felis] | diamond | 267 | 50.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium felis |
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);;