contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1214993" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7983855 | 7983855 | PRJNA1214993_P_NODE_9627_length_352_cov_1.813620_g9441_i0 | PRJNA1214993 | 9627 | 352 | 1.81362 | 6.3839424 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 5.25e-37 | NR | XP_011132759.1 | 110365 | g9441 | i0 | 60.4 | 0.946022727272727 | 111 | 44 | 94.6 | 0 | 333 | 1 | 353 | 463 | XP_011132759.1 putative transport Sec61 alpha subunit [Gregarina niphandrodes] | diamond | 333 | 140 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 17623103 | 17623103 | PRJNA1214993_P_NODE_16194_length_277_cov_1.911765_g16008_i0 | PRJNA1214993 | 16194 | 277 | 1.911765 | 5.29558905 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 3.92e-35 | NR | XP_029219843.1 | 94643 | g16008 | i0 | 69.9 | 3.82310469314079 | 93 | 24 | 96.4 | 1 | 6 | 272 | 219 | 311 | XP_029219843.1 putative serine hydroxymethyltransferase 2 [Besnoitia besnoiti] | diamond | 1059 | 135 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 22007120 | 22007120 | PRJNA1214993_P_NODE_22638_length_248_cov_0.880000_g22452_i0 | PRJNA1214993 | 22638 | 248 | 0.88 | 2.1824 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 2.22e-24 | NR | XP_011134380.1 | 110365 | g22452 | i0 | 64.2 | 2.96370967741935 | 81 | 28 | 96.8 | 1 | 248 | 9 | 54 | 134 | XP_011134380.1 DEAD-box ATP-dependent RNA helicase [Gregarina niphandrodes] | diamond | 735 | 105 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 26851408 | 26851408 | PRJNA1214993_P_NODE_7121_length_404_cov_1.712991_g6936_i0 | PRJNA1214993 | 7121 | 404 | 1.712991 | 6.92048364 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 5.12e-18 | NR | XP_028865997.1 | 189622 | g6936 | i0 | 37.5 | 1.06930693069307 | 144 | 71 | 96.5 | 4 | 8 | 397 | 1 | 139 | XP_028865997.1 translationally-controlled tumor protein [Babesia ovata] | diamond | 432 | 85.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 27470829 | 27470829 | PRJNA1214993_P_NODE_26243_length_242_cov_0.911243_g26057_i0 | PRJNA1214993 | 26243 | 242 | 0.911243 | 2.20520806 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 1.88e-15 | NR | XP_013249147.1 | 5801 | g26057 | i0 | 75 | 3.85537190082645 | 52 | 13 | 64.5 | 0 | 156 | 1 | 116 | 167 | XP_013249147.1 polyadenylate-binding protein, putative [Eimeria acervulina] | diamond | 933 | 80.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 28228232 | 28228232 | PRJNA1214993_P_NODE_4606_length_496_cov_2.330969_g4421_i0 | PRJNA1214993 | 4606 | 496 | 2.330969 | 11.56160624 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 181 | 1.3899999999999998e-54 | NR | OEH76901.1 | 88456 | g4421 | i0 | 61 | 6.47177419354839 | 159 | 62 | 96.2 | 0 | 3 | 479 | 47 | 205 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 3210 | 181 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 28746413 | 28746413 | PRJNA1214993_P_NODE_19227_length_255_cov_1.681319_g19041_i0 | PRJNA1214993 | 19227 | 255 | 1.681319 | 4.28736345 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 1.89e-11 | NR | XP_067715491.1 | 5871 | g19041 | i0 | 43.7 | 2.55294117647059 | 71 | 38 | 81.2 | 1 | 255 | 49 | 132 | 202 | XP_067715491.1 translation initiation factor E4, putative [Babesia caballi] | diamond | 651 | 69.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 28828222 | 28828222 | PRJNA1214993_P_NODE_24908_length_244_cov_0.912281_g24722_i0 | PRJNA1214993 | 24908 | 244 | 0.912281 | 2.22596564 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 3.95e-13 | NR | XP_953957.1 | 5874 | g24722 | i0 | 45 | 5.86475409836066 | 80 | 44 | 98.4 | 0 | 4 | 243 | 833 | 912 | XP_953957.1 phosphatidylinositol 4-kinase, putative [Theileria annulata] | diamond | 1431 | 74.3 | 0.994616419919246 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 28935923 | 28935923 | PRJNA1214993_P_NODE_17608_length_267_cov_1.231959_g17422_i0 | PRJNA1214993 | 17608 | 267 | 1.231959 | 3.28933053 | Plasmodium ovale curtisi | 864141 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00217 | NR | SBS84641.1 | 864141 | g17422 | i0 | 44.2 | 0.48314606741573 | 43 | 24 | 48.3 | 0 | 1 | 129 | 57 | 99 | SBS84641.1 small ubiquitin-related modifier, putative [Plasmodium ovale curtisi] | diamond | 129 | 44.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 29365217 | 29365217 | PRJNA1214993_P_NODE_24689_length_244_cov_0.912281_g24503_i0 | PRJNA1214993 | 24689 | 244 | 0.912281 | 2.22596564 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 4.64e-4 | NR | CAL7862139.1 | 1344799 | g24503 | i0 | 40.3 | 2.91393442622951 | 77 | 43 | 94.7 | 1 | 12 | 242 | 726 | 799 | CAL7862139.1 unnamed protein product [Sarcocystis calchasi] | diamond | 711 | 48.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 30546589 | 30546589 | PRJNA1214993_P_NODE_12253_length_315_cov_1.280992_g12067_i0 | PRJNA1214993 | 12253 | 315 | 1.280992 | 4.0351248 | Plasmodium ovale | 36330 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 0.00109 | NR | SBT77329.1 | 36330 | g12067 | i0 | 44.9 | 0.866666666666667 | 49 | 26 | 45.7 | 1 | 293 | 150 | 662 | 710 | SBT77329.1 dynamin-like protein, putative [Plasmodium ovale] | diamond | 273 | 48.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 30546599 | 30546599 | PRJNA1214993_P_NODE_19213_length_255_cov_1.714286_g19027_i0 | PRJNA1214993 | 19213 | 255 | 1.714286 | 4.3714293 | Babesia gibsoni | 33632 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 7.72e-17 | NR | KAK1443386.1 | 33632 | g19027 | i0 | 53.4 | 4.44705882352941 | 73 | 33 | 84.7 | 1 | 234 | 19 | 30 | 102 | KAK1443386.1 hypothetical protein BgAZ_202620 [Babesia gibsoni] | diamond | 1134 | 79 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia gibsoni | ||
| 31671665 | 31671665 | PRJNA1214993_P_NODE_18417_length_261_cov_1.244681_g18231_i0 | PRJNA1214993 | 18417 | 261 | 1.244681 | 3.24861741 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 7.539999999999999e-31 | NR | XP_013332946.1 | 5804 | g18231 | i0 | 90.2 | 133.919540229885 | 61 | 6 | 70.1 | 0 | 259 | 77 | 77 | 137 | XP_013332946.1 ribosomal protein S23, putative [Eimeria maxima] | diamond | 34953 | 115 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 31811087 | 31811087 | PRJNA1214993_P_NODE_23757_length_246_cov_0.890173_g23571_i0 | PRJNA1214993 | 23757 | 246 | 0.890173 | 2.18982558 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.9e-4 | NR | CAL7858741.1 | 1344799 | g23571 | i0 | 57.5 | 0.48780487804878 | 40 | 17 | 48.8 | 0 | 7 | 126 | 399 | 438 | CAL7858741.1 unnamed protein product [Sarcocystis calchasi] | diamond | 120 | 49.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 31842538 | 31842538 | PRJNA1214993_P_NODE_5057_length_475_cov_2.335821_g4872_i0 | PRJNA1214993 | 5057 | 475 | 2.335821 | 11.09514975 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 4.86e-7 | NR | AET50831.1 | 5802 | g4872 | i0 | 43.5 | 0.783157894736842 | 62 | 33 | 39.2 | 1 | 7 | 192 | 18 | 77 | AET50831.1 hypothetical protein [Eimeria tenella] | diamond | 372 | 58.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 32064077 | 32064077 | PRJNA1214993_P_NODE_21238_length_250_cov_0.881356_g21052_i0 | PRJNA1214993 | 21238 | 250 | 0.881356 | 2.20339 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 1.15e-20 | NR | UKJ88711.2 | 68886 | g21052 | i0 | 53.2 | 6.408 | 77 | 35 | 92.4 | 1 | 235 | 5 | 6 | 81 | UKJ88711.2 60S ribosomal protein L35a [Theileria orientalis] | diamond | 1602 | 89 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 32759358 | 32759358 | PRJNA1214993_P_NODE_9900_length_348_cov_1.134545_g9714_i0 | PRJNA1214993 | 9900 | 348 | 1.134545 | 3.9482166 | Babesia microti strain RI | 1133968 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 8.989999999999999e-28 | NR | XP_021337160.1 | 1133968 | g9714 | i0 | 50.4 | 3.89655172413793 | 113 | 49 | 97.4 | 1 | 339 | 1 | 1 | 106 | XP_021337160.1 large subunit ribosomal protein L18e [Babesia microti strain RI] | diamond | 1356 | 110 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti |
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);;