contig_metadata
17 rows where bioproject = "PRJNA438572", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10638850 | 10638850 | PRJNA438572_P_NODE_15349_length_265_cov_2.833333_g15230_i0 | PRJNA438572 | 15349 | 265 | 2.833333 | 7.50833245 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 6.55e-23 | NTclustered | gi|916507643|ref|XM_013498674.1| | 44415 | g15230 | i0 | 82.836 | 0.822641509433962 | 134 | 23 | 51 | 0 | 26 | 159 | 197 | 330 | Eimeria mitis uncharacterized protein (EMH_0067880), partial mRNA | blastn | 218 | 121 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 17012509 | 17012509 | PRJNA438572_P_NODE_6734_length_387_cov_1.187898_g6615_i0 | PRJNA438572 | 6734 | 387 | 1.187898 | 4.59716526 | Plasmodium gonderi | 77519 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 1.32e-6 | NTclustered | gi|1620953318|ref|XM_028688720.1| | 77519 | g6615 | i0 | 88.889 | 0.13953488372093 | 54 | 6 | 14 | 0 | 131 | 184 | 697 | 750 | Plasmodium gonderi ornithine aminotransferase (PGO_113860), partial mRNA | blastn | 54 | 67.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gonderi | ||
| 20217309 | 20217309 | PRJNA438572_P_NODE_6096_length_405_cov_4.650602_g5977_i0 | PRJNA438572 | 6096 | 405 | 4.650602 | 18.8349381 | Babesia sp. Xinjiang | 462227 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 3.2599999999999995e-42 | NR | XP_028869867.1 | 462227 | g5977 | i0 | 59.7 | 3.41481481481481 | 119 | 48 | 88.1 | 0 | 11 | 367 | 4 | 122 | XP_028869867.1 Eukaryotic translation initiation factor 5A [Babesia sp. Xinjiang] | diamond | 1383 | 147 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia sp. Xinjiang | ||
| 26727392 | 26727392 | PRJNA438572_P_NODE_18561_length_251_cov_0.876404_g18442_i0 | PRJNA438572 | 18561 | 251 | 0.876404 | 2.19977404 | Neospora caninum Liverpool | 572307 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 6.37e-28 | NR | XP_003884403.1 | 572307 | g18442 | i0 | 59 | 3.9681274900398402 | 83 | 34 | 99.2 | 0 | 250 | 2 | 23 | 105 | XP_003884403.1 hypothetical protein NCLIV_048030 [Neospora caninum Liverpool] | diamond | 996 | 107 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 28671435 | 28671435 | PRJNA438572_P_NODE_16507_length_255_cov_1.631868_g16388_i0 | PRJNA438572 | 16507 | 255 | 1.631868 | 4.1612634 | Eimeria | 5800 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 3.32e-10 | NR | XP_013251045.1 | 5801 | g16388 | i0 | 40.3 | 6.22352941176471 | 72 | 43 | 84.7 | 0 | 216 | 1 | 886 | 957 | XP_013251045.1 thrombospondin type 1 domain-containing protein, putative [Eimeria acervulina] | diamond | 1587 | 65.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 29160471 | 29160471 | PRJNA438572_P_NODE_21969_length_245_cov_1.360465_g21850_i0 | PRJNA438572 | 21969 | 245 | 1.360465 | 3.33313925 | Cryptosporidium felis | 83540 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 8.14e-4 | NR | KAF7457130.1 | 83540 | g21850 | i0 | 36.5 | 0.771428571428571 | 63 | 37 | 77.1 | 1 | 242 | 54 | 80 | 139 | KAF7457130.1 sybindin family protein [Cryptosporidium felis] | diamond | 189 | 46.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium felis | ||
| 29208264 | 29208264 | PRJNA438572_P_NODE_11389_length_305_cov_1.004310_g11270_i0 | PRJNA438572 | 11389 | 305 | 1.00431 | 3.0631455 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.02e-32 | NR | XP_029218259.1 | 94643 | g11270 | i0 | 58.8 | 37.0918032786885 | 102 | 41 | 99.3 | 1 | 2 | 304 | 250 | 351 | XP_029218259.1 DEAD (Asp-Glu-Ala-Asp) box polypeptide DDX6 [Besnoitia besnoiti] | diamond | 11313 | 129 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 29271049 | 29271049 | PRJNA438572_P_NODE_9709_length_328_cov_2.019608_g9590_i0 | PRJNA438572 | 9709 | 328 | 2.019608 | 6.62431424 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 1.98e-14 | NR | KAF4644999.1 | 5811 | g9590 | i0 | 85.4 | 3 | 41 | 6 | 37.5 | 0 | 328 | 206 | 504 | 544 | KAF4644999.1 putative TCP-1 chaperonin [Toxoplasma gondii] | diamond | 984 | 79 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 29618188 | 29618188 | PRJNA438572_P_NODE_17590_length_252_cov_0.871508_g17471_i0 | PRJNA438572 | 17590 | 252 | 0.871508 | 2.19620016 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 1.3199999999999998e-32 | NR | XP_012770089.1 | 5866 | g17471 | i0 | 72.3 | 5.95238095238095 | 83 | 23 | 98.8 | 0 | 252 | 4 | 413 | 495 | XP_012770089.1 serine/threonine protein phosphatase 5, putative [Babesia bigemina] | diamond | 1500 | 129 | 0.992248062015504 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 30771268 | 30771268 | PRJNA438572_P_NODE_11894_length_298_cov_1.346667_g11775_i0 | PRJNA438572 | 11894 | 298 | 1.346667 | 4.01306766 | Hepatocystis sp. ex Piliocolobus tephrosceles | 2600580 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 5.51e-32 | NR | VWU51230.1 | 2600580 | g11775 | i0 | 68.8 | 1.81208053691275 | 93 | 27 | 91.6 | 2 | 296 | 24 | 6 | 98 | VWU51230.1 60S ribosomal protein L44 [Hepatocystis sp. ex Piliocolobus tephrosceles] | diamond | 540 | 117 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Hepatocystis | Hepatocystis sp. ex Piliocolobus tephrosceles | ||
| 31134622 | 31134622 | PRJNA438572_P_NODE_3135_length_555_cov_8.829876_g3017_i0 | PRJNA438572 | 3135 | 555 | 8.829876 | 49.0058118 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 4.39e-60 | NR | XP_028525792.1 | 5849 | g3017 | i0 | 54 | 19.8594594594595 | 176 | 81 | 95.1 | 0 | 6 | 533 | 1 | 176 | XP_028525792.1 40S ribosomal protein S9, putative [Plasmodium gallinaceum] | diamond | 11022 | 196 | 0.994897959183674 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 31624578 | 31624578 | PRJNA438572_P_NODE_9676_length_329_cov_1.132812_g9557_i0 | PRJNA438572 | 9676 | 329 | 1.132812 | 3.72695148 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 5.65e-15 | NR | CAL7864417.1 | 1344799 | g9557 | i0 | 43.7 | 2.790273556231 | 103 | 50 | 91.2 | 3 | 29 | 328 | 42 | 139 | CAL7864417.1 unnamed protein product [Sarcocystis calchasi] | diamond | 918 | 79.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 31909331 | 31909331 | PRJNA438572_P_NODE_6257_length_401_cov_1.426829_g6138_i0 | PRJNA438572 | 6257 | 401 | 1.426829 | 5.72158429 | Cryptosporidium xiaoi | 659607 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 6.22e-16 | NR | KAK6588730.1 | 659607 | g6138 | i0 | 50 | 0.763092269326683 | 102 | 47 | 76.3 | 1 | 401 | 96 | 62 | 159 | KAK6588730.1 hypothetical protein RS030_333721, partial [Cryptosporidium xiaoi] | diamond | 306 | 80.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium xiaoi | ||
| 32099114 | 32099114 | PRJNA438572_P_NODE_9478_length_332_cov_1.204633_g9359_i0 | PRJNA438572 | 9478 | 332 | 1.204633 | 3.99938156 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 8.85e-5 | NR | XP_067926860.1 | 483139 | g9359 | i0 | 32.6 | 1.33734939759036 | 89 | 57 | 77.7 | 1 | 301 | 44 | 5 | 93 | XP_067926860.1 uncharacterized protein CSUI_000969 [Cystoisospora suis] | diamond | 444 | 49.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 32447440 | 32447440 | PRJNA438572_P_NODE_2979_length_568_cov_10.230303_g2861_i0 | PRJNA438572 | 2979 | 568 | 10.230303 | 58.10812104 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 4.79e-64 | NR | OEH76901.1 | 88456 | g2861 | i0 | 60.7 | 3.77112676056338 | 183 | 72 | 96.7 | 0 | 563 | 15 | 29 | 211 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 2142 | 206 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 32699557 | 32699557 | PRJNA438572_P_NODE_16360_length_256_cov_2.131148_g16241_i0 | PRJNA438572 | 16360 | 256 | 2.131148 | 5.45573888 | Theileria parva strain Muguga | 333668 | SAR_Eukaryotes | SAR_Eukaryotes | 92 | 1.2e-19 | NR | XP_764530.1 | 333668 | g16241 | i0 | 64.1 | 0.75 | 64 | 23 | 75 | 0 | 2 | 193 | 333 | 396 | XP_764530.1 methionine adenosyltransferase [Theileria parva strain Muguga] | diamond | 192 | 92 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria parva | ||
| 32715932 | 32715932 | PRJNA438572_P_NODE_11180_length_307_cov_2.307692_g11061_i0 | PRJNA438572 | 11180 | 307 | 2.307692 | 7.08461444 | Eimeriidae | 5799 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 3.97e-24 | NR | CAC20153.1 | 5802 | g11061 | i0 | 48 | 2.99022801302932 | 102 | 50 | 98.7 | 2 | 3 | 305 | 324 | 423 | CAC20153.1 aspartyl proteinase (eimepsin) [Eimeria tenella] | diamond | 918 | 105 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella |
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);;