contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1059246" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 177061 | 177061 | PRJNA1059246_P_NODE_37181_length_352_cov_1.394265_g36555_i0 | PRJNA1059246 | 37181 | 352 | 1.394265 | 4.9078128 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 6.18e-8 | NR | OEH75044.1 | 88456 | g36555 | i0 | 57.6 | 2.08806818181818 | 59 | 23 | 48.6 | 1 | 2 | 172 | 74 | 132 | OEH75044.1 40s ribosomal protein [Cyclospora cayetanensis] | diamond | 735 | 58.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 4003767 | 4003767 | PRJNA1059246_P_NODE_59984_length_256_cov_1.704918_g59358_i0 | PRJNA1059246 | 59984 | 256 | 1.704918 | 4.36459008 | Theileria equi strain WA | 1537102 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 4.389999999999999e-40 | NR | XP_004831211.1 | 1537102 | g59358 | i0 | 84.7 | 0.99609375 | 85 | 13 | 99.6 | 0 | 256 | 2 | 307 | 391 | XP_004831211.1 enolase, putative [Theileria equi strain WA] | diamond | 255 | 147 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 12930890 | 12930890 | PRJNA1059246_P_NODE_50451_length_288_cov_1.079070_g49825_i0 | PRJNA1059246 | 50451 | 288 | 1.07907 | 3.1077216 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 86.3 | 3.1e-17 | NR | XP_002367122.1 | 508771 | g49825 | i0 | 69.6 | 0.71875 | 69 | 18 | 69.8 | 2 | 6 | 206 | 507 | 574 | XP_002367122.1 heat shock protein HSP60 [Toxoplasma gondii ME49] | diamond | 207 | 86.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 15480266 | 15480266 | PRJNA1059246_P_NODE_69913_length_243_cov_1.358824_g69287_i0 | PRJNA1059246 | 69913 | 243 | 1.358824 | 3.30194232 | Porospora | 947096 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 2.55e-38 | NR | XP_068371470.1 | 2853592 | g69287 | i0 | 83.5 | 4.87654320987654 | 79 | 13 | 97.5 | 0 | 243 | 7 | 5 | 83 | XP_068371470.1 MAG: uncharacterized protein KVP17_002356, partial [Porospora cf. gigantea B] | diamond | 1185 | 139 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea B | ||
| 25237773 | 25237773 | PRJNA1059246_P_NODE_48740_length_294_cov_1.742081_g48114_i0 | PRJNA1059246 | 48740 | 294 | 1.742081 | 5.12171814 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 3.94e-41 | NR | XP_067066750.1 | 117008 | g48114 | i0 | 67.7 | 35.3571428571429 | 99 | 31 | 100 | 1 | 294 | 1 | 61 | 159 | XP_067066750.1 RAS family protein Rab-6A [Cryptosporidium andersoni] | diamond | 10395 | 145 | 0.993103448275862 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 26710336 | 26710336 | PRJNA1059246_P_NODE_63041_length_250_cov_0.870056_g62415_i0 | PRJNA1059246 | 63041 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 3.4899999999999997e-35 | NR | XP_022592141.1 | 88456 | g62415 | i0 | 77.1 | 32.76 | 83 | 19 | 99.6 | 0 | 249 | 1 | 321 | 403 | XP_022592141.1 ATP-dependent RNA helicase DDX39A [Cyclospora cayetanensis] | diamond | 8190 | 135 | 0.992592592592593 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 26741919 | 26741919 | PRJNA1059246_P_NODE_45861_length_308_cov_1.310638_g45235_i0 | PRJNA1059246 | 45861 | 308 | 1.310638 | 4.03676504 | Eimeriidae | 5799 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 9.57e-11 | NR | XP_013352611.1 | 44415 | g45235 | i0 | 31 | 1.94805194805195 | 100 | 69 | 97.4 | 0 | 300 | 1 | 35 | 134 | XP_013352611.1 p23 co-chaperone, putative [Eimeria mitis] | diamond | 600 | 67 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 28109133 | 28109133 | PRJNA1059246_P_NODE_34885_length_366_cov_1.051195_g34259_i0 | PRJNA1059246 | 34885 | 366 | 1.051195 | 3.8473737 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 3e-5 | NR | OEH80400.1 | 88456 | g34259 | i0 | 37.7 | 0.631147540983607 | 77 | 48 | 63.1 | 0 | 236 | 6 | 106 | 182 | OEH80400.1 tetratricopeptide repeat-containing protein [Cyclospora cayetanensis] | diamond | 231 | 53.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 28203835 | 28203835 | PRJNA1059246_P_NODE_70046_length_243_cov_0.905882_g69420_i0 | PRJNA1059246 | 70046 | 243 | 0.905882 | 2.20129326 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 8.65e-4 | NR | OEH79529.1 | 88456 | g69420 | i0 | 35.1 | 1.40740740740741 | 57 | 37 | 70.4 | 0 | 173 | 3 | 650 | 706 | OEH79529.1 kelch repeat protein [Cyclospora cayetanensis] | diamond | 342 | 47.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 28416990 | 28416990 | PRJNA1059246_P_NODE_24626_length_451_cov_1.812169_g24002_i0 | PRJNA1059246 | 24626 | 451 | 1.812169 | 8.17288219 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 2.7e-42 | NR | XP_067802062.1 | 323732 | g24002 | i0 | 57.8 | 10.9223946784922 | 128 | 50 | 84.5 | 2 | 2 | 382 | 7 | 131 | XP_067802062.1 bifunctional Translation initiation factor 1A (eIF-1A) [Babesia duncani] | diamond | 4926 | 147 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 30121862 | 30121862 | PRJNA1059246_P_NODE_33032_length_378_cov_1.009836_g32406_i0 | PRJNA1059246 | 33032 | 378 | 1.009836 | 3.81718008 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 1.69e-25 | NR | GFE54824.1 | 5869 | g32406 | i0 | 38.3 | 6.57936507936508 | 120 | 74 | 95.2 | 0 | 19 | 378 | 96 | 215 | GFE54824.1 subunit of proteaseome activator [Babesia ovis] | diamond | 2487 | 106 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 30161585 | 30161585 | PRJNA1059246_P_NODE_59752_length_257_cov_1.597826_g59126_i0 | PRJNA1059246 | 59752 | 257 | 1.597826 | 4.10641282 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 4.52e-19 | NR | CAL7859083.1 | 1344799 | g59126 | i0 | 90.2 | 2.70817120622568 | 51 | 5 | 59.5 | 0 | 85 | 237 | 75 | 125 | CAL7859083.1 unnamed protein product [Sarcocystis calchasi] | diamond | 696 | 87.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 31394370 | 31394370 | PRJNA1059246_P_NODE_46896_length_303_cov_1.439130_g46270_i0 | PRJNA1059246 | 46896 | 303 | 1.43913 | 4.3605639 | Plasmodium falciparum Tanzania (2 | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 66.2 | 4.33e-10 | NR | ETW37318.1 | 1036725 | g46270 | i0 | 37.6 | 0.920792079207921 | 93 | 56 | 92.1 | 1 | 302 | 24 | 2347 | 2437 | ETW37318.1 dynein heavy chain-like protein [Plasmodium falciparum Tanzania (2000708)] | diamond | 279 | 66.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 31489357 | 31489357 | PRJNA1059246_P_NODE_55516_length_272_cov_1.266332_g54890_i0 | PRJNA1059246 | 55516 | 272 | 1.266332 | 3.44442304 | Neospora caninum Liverpool | 572307 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 1.5399999999999999e-24 | NR | XP_003883642.1 | 572307 | g54890 | i0 | 57 | 3.05514705882353 | 93 | 36 | 99.3 | 2 | 271 | 2 | 3 | 94 | XP_003883642.1 Acetyl-CoA acetyltransferase,related [Neospora caninum Liverpool] | diamond | 831 | 105 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 31520897 | 31520897 | PRJNA1059246_P_NODE_62516_length_250_cov_1.305085_g61890_i0 | PRJNA1059246 | 62516 | 250 | 1.305085 | 3.2627125 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 1.62e-8 | NR | XP_011129737.1 | 110365 | g61890 | i0 | 50.8 | 0.78 | 65 | 29 | 78 | 1 | 248 | 54 | 144 | 205 | XP_011129737.1 aspartyl-tRNA synthetase [Gregarina niphandrodes] | diamond | 195 | 60.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 32058470 | 32058470 | PRJNA1059246_P_NODE_51658_length_284_cov_1.379147_g51032_i0 | PRJNA1059246 | 51658 | 284 | 1.379147 | 3.91677748 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 0.00105 | NR | CAL7860855.1 | 1344799 | g51032 | i0 | 54.3 | 0.485915492957746 | 46 | 21 | 48.6 | 0 | 178 | 41 | 55 | 100 | CAL7860855.1 unnamed protein product [Sarcocystis calchasi] | diamond | 138 | 47.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 32375072 | 32375072 | PRJNA1059246_P_NODE_71579_length_242_cov_0.911243_g70953_i0 | PRJNA1059246 | 71579 | 242 | 0.911243 | 2.20520806 | Porospora cf. gigantea B | 2853592 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 4.49e-13 | NR | XP_068374196.1 | 2853592 | g70953 | i0 | 48.8 | 1.98347107438017 | 80 | 40 | 99.2 | 1 | 241 | 2 | 53 | 131 | XP_068374196.1 MAG: uncharacterized protein KVP17_000540 [Porospora cf. gigantea B] | diamond | 480 | 72.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea B | ||
| 32565084 | 32565084 | PRJNA1059246_P_NODE_60139_length_256_cov_1.262295_g59513_i0 | PRJNA1059246 | 60139 | 256 | 1.262295 | 3.2314752 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 2.0199999999999998e-24 | NR | XP_067713564.1 | 5871 | g59513 | i0 | 50.6 | 3.984375 | 85 | 42 | 99.6 | 0 | 256 | 2 | 96 | 180 | XP_067713564.1 vacuolar ATP synthase subunit A, putative [Babesia caballi] | diamond | 1020 | 106 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi |
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);;