contig_metadata
18 rows where bioproject = "PRJNA692200", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 672939 | 672939 | PRJNA692200_S_NODE_5321_length_283_cov_2.846154_g5264_i0 | PRJNA692200 | 5321 | 283 | 2.846154 | 8.05461582 | Sarcocystis zamani | 137009 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.61e-4 | NTclustered | gi|1005651880|gb|KU244521.1| | 137009 | g5264 | i0 | 94.737 | 11.8374558303887 | 38 | 1 | 13 | 1 | 247 | 283 | 3304 | 3267 | Sarcocystis zamani voucher BJ no.1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 3350 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis zamani | ||
| 5776064 | 5776064 | PRJNA692200_S_NODE_1265_length_421_cov_969.602151_g1216_i0 | PRJNA692200 | 1265 | 421 | 969.602151 | 4082.02505571 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 3.049999999999999e-23 | NTclustered | gi|916497858|ref|XM_013494305.1| | 44415 | g1216 | i0 | 97.222 | 0.171021377672209 | 72 | 2 | 17 | 0 | 26 | 97 | 345 | 416 | Eimeria mitis uncharacterized protein (EMH_0029470), partial mRNA | blastn | 72 | 122 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 12152059 | 12152059 | PRJNA692200_S_NODE_3590_length_322_cov_2.527473_g3533_i0 | PRJNA692200 | 3590 | 322 | 2.527473 | 8.13846306 | Plasmodium coatneyi | 208452 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|1139863048|ref|XM_020059306.1| | 208452 | g3533 | i0 | 100 | 0.437888198757764 | 29 | 0 | 9 | 0 | 192 | 220 | 3823 | 3795 | Plasmodium coatneyi Uncharacterized protein partial mRNA | blastn | 141 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium coatneyi | ||
| 15975444 | 15975444 | PRJNA692200_S_NODE_18673_length_171_cov_1.229508_g18616_i0 | PRJNA692200 | 18673 | 171 | 1.229508 | 2.10245868 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 2.35e-15 | NTclustered | gi|820693004|tpe|LN714485.1| | 572307 | g18616 | i0 | 86.364 | 1.47953216374269 | 88 | 10 | 51 | 2 | 28 | 114 | 854667 | 854581 | TPA_asm: Neospora caninum Liverpool, chromosome chrX, complete genome | blastn | 253 | 95.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 19799600 | 19799600 | PRJNA692200_S_NODE_17756_length_174_cov_4.152000_g17699_i0 | PRJNA692200 | 17756 | 174 | 4.152 | 7.22448 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 5.23e-7 | NTclustered | gi|921123390|ref|XM_013580856.1| | 51315 | g17699 | i0 | 93.333 | 4.01149425287356 | 45 | 3 | 26 | 0 | 48 | 92 | 1112 | 1068 | Eimeria necatrix hypothetical protein, conserved partial mRNA | blastn | 698 | 67.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 27651378 | 27651378 | PRJNA692200_S_NODE_18124_length_173_cov_1.637097_g18067_i0 | PRJNA692200 | 18124 | 173 | 1.637097 | 2.83217781 | Babesia sp. Xinjiang | 462227 | SAR_Eukaryotes | SAR_Eukaryotes | 59.7 | 1.45e-8 | NR | XP_028872839.1 | 462227 | g18067 | i0 | 56.5 | 0.797687861271676 | 46 | 20 | 79.8 | 0 | 24 | 161 | 324 | 369 | XP_028872839.1 Actin-2 [Babesia sp. Xinjiang] | diamond | 138 | 59.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia sp. Xinjiang | ||
| 28357045 | 28357045 | PRJNA692200_S_NODE_13386_length_197_cov_2.864865_g13329_i0 | PRJNA692200 | 13386 | 197 | 2.864865 | 5.64378405 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 2.76e-9 | NR | XP_028865997.1 | 189622 | g13329 | i0 | 45.3 | 1.90355329949239 | 64 | 35 | 97.5 | 0 | 195 | 4 | 76 | 139 | XP_028865997.1 translationally-controlled tumor protein [Babesia ovata] | diamond | 375 | 60.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 28630237 | 28630237 | PRJNA692200_S_NODE_407_length_525_cov_24.602941_g374_i0 | PRJNA692200 | 407 | 525 | 24.602941 | 129.16544025 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 170 | 7.03e-50 | NR | OEH76901.1 | 88456 | g374 | i0 | 58 | 3.48571428571429 | 157 | 66 | 89.7 | 0 | 520 | 50 | 55 | 211 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 1830 | 170 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 29367643 | 29367643 | PRJNA692200_S_NODE_21329_length_163_cov_3.561404_g21272_i0 | PRJNA692200 | 21329 | 163 | 3.561404 | 5.80508852 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 2.21e-7 | NR | XP_013336974.1 | 5804 | g21272 | i0 | 53.7 | 1.91411042944785 | 54 | 24 | 97.5 | 1 | 2 | 160 | 58 | 111 | XP_013336974.1 60S ribosomal protein L31, putative [Eimeria maxima] | diamond | 312 | 55.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 29841174 | 29841174 | PRJNA692200_S_NODE_14651_length_189_cov_6.157143_g14594_i0 | PRJNA692200 | 14651 | 189 | 6.157143 | 11.63700027 | Theileria | 5873 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 2.74e-6 | NR | XP_764530.1 | 333668 | g14594 | i0 | 70 | 1.47619047619048 | 30 | 9 | 47.6 | 0 | 188 | 99 | 367 | 396 | XP_764530.1 methionine adenosyltransferase [Theileria parva strain Muguga] | diamond | 279 | 53.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria parva | ||
| 30145451 | 30145451 | PRJNA692200_S_NODE_21892_length_162_cov_1.831858_g21835_i0 | PRJNA692200 | 21892 | 162 | 1.831858 | 2.96760996 | Theileria orientalis strain Shintoku | 869250 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 4.7e-5 | NR | XP_009690404.1 | 869250 | g21835 | i0 | 52.3 | 4.33333333333333 | 44 | 21 | 81.5 | 0 | 3 | 134 | 72 | 115 | XP_009690404.1 uncharacterized protein TOT_020000366 [Theileria orientalis strain Shintoku] | diamond | 702 | 48.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 30473166 | 30473166 | PRJNA692200_S_NODE_4053_length_310_cov_5.816092_g3996_i0 | PRJNA692200 | 4053 | 310 | 5.816092 | 18.0298852 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.00463 | NR | XP_013334820.1 | 5804 | g3996 | i0 | 43.5 | 1.55806451612903 | 46 | 26 | 44.5 | 0 | 236 | 99 | 23 | 68 | XP_013334820.1 Ribosome associated membrane domain-containing protein, putative [Eimeria maxima] | diamond | 483 | 43.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 31073440 | 31073440 | PRJNA692200_S_NODE_16615_length_180_cov_1.435115_g16558_i0 | PRJNA692200 | 16615 | 180 | 1.435115 | 2.583207 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00177 | NR | CDJ48993.1 | 51314 | g16558 | i0 | 66.7 | 2 | 30 | 10 | 50 | 0 | 174 | 85 | 98 | 127 | CDJ48993.1 60S ribosomal protein L7a, putative [Eimeria brunetti] | diamond | 360 | 44.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria brunetti | ||
| 31124848 | 31124848 | PRJNA692200_S_NODE_7635_length_248_cov_4.135678_g7578_i0 | PRJNA692200 | 7635 | 248 | 4.135678 | 10.25648144 | Cryptosporidium ryanae | 515981 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 2e-12 | NR | XP_067195547.1 | 515981 | g7578 | i0 | 62.5 | 1.35483870967742 | 56 | 21 | 67.7 | 0 | 2 | 169 | 202 | 257 | XP_067195547.1 60S ribosomal protein L7A [Cryptosporidium ryanae] | diamond | 336 | 70.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae | ||
| 31547858 | 31547858 | PRJNA692200_S_NODE_9856_length_225_cov_2.323864_g9799_i0 | PRJNA692200 | 9856 | 225 | 2.323864 | 5.228694 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 2.65e-7 | NR | KNC37519.1 | 580058 | g9799 | i0 | 50 | 1.28 | 48 | 24 | 64 | 0 | 3 | 146 | 369 | 416 | KNC37519.1 sarcoplasmic and endoplasmic reticulum Ca-ATPase [Plasmodium falciparum RAJ116] | diamond | 288 | 57 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 32042496 | 32042496 | PRJNA692200_S_NODE_17038_length_178_cov_1.348837_g16981_i0 | PRJNA692200 | 17038 | 178 | 1.348837 | 2.40092986 | Hepatocystis sp. ex Piliocolobus tephrosceles | 2600580 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 2.28e-16 | NR | VWU50564.1 | 2600580 | g16981 | i0 | 71.7 | 0.893258426966292 | 53 | 15 | 89.3 | 0 | 170 | 12 | 295 | 347 | VWU50564.1 S-adenosylmethionine synthetase, putative [Hepatocystis sp. ex Piliocolobus tephrosceles] | diamond | 159 | 81.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Hepatocystis | Hepatocystis sp. ex Piliocolobus tephrosceles | ||
| 32117179 | 32117179 | PRJNA692200_S_NODE_2038_length_378_cov_3.048632_g1981_i0 | PRJNA692200 | 2038 | 378 | 3.048632 | 11.52382896 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 9.04e-7 | NR | XP_766466.1 | 333668 | g1981 | i0 | 33.1 | 4.82539682539683 | 124 | 74 | 98.4 | 2 | 6 | 377 | 176 | 290 | XP_766466.1 polyadenylate binding family protein [Theileria parva strain Muguga] | diamond | 1824 | 57.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria parva | ||
| 32611777 | 32611777 | PRJNA692200_S_NODE_13560_length_196_cov_2.088435_g13503_i0 | PRJNA692200 | 13560 | 196 | 2.088435 | 4.0933326 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.00436 | NR | CAL7858805.1 | 1344799 | g13503 | i0 | 43.5 | 0.704081632653061 | 46 | 24 | 70.4 | 1 | 31 | 168 | 31 | 74 | CAL7858805.1 unnamed protein product [Sarcocystis calchasi] | diamond | 138 | 42.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi |
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);;