contig_metadata
20 rows where bioproject = "PRJNA1086823", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193656 | 193656 | PRJNA1086823_P_NODE_12341_length_253_cov_0.866667_g12224_i0 | PRJNA1086823 | 12341 | 253 | 0.866667 | 2.19266751 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 468 | 1.92e-127 | NTclustered | gi|258597881|ref|XM_001348714.2| | 36329 | g12224 | i0 | 100 | 3.39130434782609 | 253 | 0 | 100 | 0 | 1 | 253 | 436 | 688 | Plasmodium falciparum 3D7 ubiquitin carboxyl-terminal hydrolase isozyme L3 (PF3D7_1460400), partial mRNA | blastn | 858 | 468 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 4020202 | 4020202 | PRJNA1086823_P_NODE_10284_length_270_cov_1.187817_g10167_i0 | PRJNA1086823 | 10284 | 270 | 1.187817 | 3.2071059 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 499 | 7.349999999999998e-137 | NTclustered | gi|124506184|ref|XM_001351654.1| | 36329 | g10167 | i0 | 100 | 5.61111111111111 | 270 | 0 | 100 | 0 | 1 | 270 | 81 | 350 | Plasmodium falciparum 3D7 purine nucleoside phosphorylase (PF3D7_0513300), partial mRNA | blastn | 1515 | 499 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 5296637 | 5296637 | PRJNA1086823_P_NODE_4325_length_377_cov_1.098684_g4208_i0 | PRJNA1086823 | 4325 | 377 | 1.098684 | 4.14203868 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|669195891|ref|XM_008624735.1| | 54757 | g4208 | i0 | 87.755 | 0.204244031830239 | 49 | 4 | 13 | 2 | 62 | 109 | 1523 | 1570 | Plasmodium vinckei vinckei ABC1 family, putative (PVVCY_1402920), partial mRNA | blastn | 77 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 6120483 | 6120483 | PRJNA1086823_P_NODE_10585_length_267_cov_1.206186_g10468_i0 | PRJNA1086823 | 10585 | 267 | 1.206186 | 3.22051662 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 494 | 3.38e-135 | NTclustered | gi|116014810|gb|DQ874471.1| | 5833 | g10468 | i0 | 100 | 22 | 267 | 0 | 100 | 0 | 1 | 267 | 657 | 391 | Plasmodium falciparum strain Ph1 fructose 1,6-biphosphate aldolase gene, partial cds | blastn | 5874 | 494 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 6571561 | 6571561 | PRJNA1086823_P_NODE_12826_length_252_cov_0.871508_g12709_i0 | PRJNA1086823 | 12826 | 252 | 0.871508 | 2.19620016 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.5e-118 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g12709 | i0 | 98.016 | 23.9801587301587 | 252 | 5 | 100 | 0 | 1 | 252 | 96795 | 97046 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 6043 | 438 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 6571759 | 6571759 | PRJNA1086823_P_NODE_5186_length_350_cov_1.689531_g5069_i0 | PRJNA1086823 | 5186 | 350 | 1.689531 | 5.9133585 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 6.37e-34 | NR | GFE54039.1 | 5869 | g5069 | i0 | 58.8 | 5.81142857142857 | 114 | 45 | 96.9 | 2 | 347 | 9 | 1 | 113 | GFE54039.1 60S ribosomal protein L31 [Babesia ovis] | diamond | 2034 | 125 | 0.992 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 10397195 | 10397195 | PRJNA1086823_P_NODE_4489_length_371_cov_1.191275_g4372_i0 | PRJNA1086823 | 4489 | 371 | 1.191275 | 4.41963025 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|669195891|ref|XM_008624735.1| | 54757 | g4372 | i0 | 90.698 | 0.115902964959569 | 43 | 2 | 11 | 2 | 70 | 111 | 1570 | 1529 | Plasmodium vinckei vinckei ABC1 family, putative (PVVCY_1402920), partial mRNA | blastn | 43 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 11672422 | 11672422 | PRJNA1086823_P_NODE_16970_length_245_cov_0.906977_g16853_i0 | PRJNA1086823 | 16970 | 245 | 0.906977 | 2.22209365 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 453 | 5.1900000000000006e-123 | NTclustered | gi|124506414|ref|XM_001351769.1| | 36329 | g16853 | i0 | 100 | 3.66530612244898 | 245 | 0 | 100 | 0 | 1 | 245 | 1699 | 1943 | Plasmodium falciparum 3D7 S-adenosyl-L-methionine-dependent tRNA 4-demethylwyosine synthase, putative (PF3D7_0524900), partial mRNA | blastn | 898 | 453 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 12496228 | 12496228 | PRJNA1086823_P_NODE_9150_length_281_cov_1.500000_g9033_i0 | PRJNA1086823 | 9150 | 281 | 1.5 | 4.215 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 520 | 5.909999999999999e-143 | NTclustered | gi|8918237|dbj|AB023579.1| | 5833 | g9033 | i0 | 100 | 22.3701067615658 | 281 | 0 | 100 | 0 | 1 | 281 | 1309 | 1029 | Plasmodium falciparum gene for elongation factor 2, partial cds | blastn | 6286 | 520 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 15496278 | 15496278 | PRJNA1086823_P_NODE_10673_length_266_cov_1.316062_g10556_i0 | PRJNA1086823 | 10673 | 266 | 1.316062 | 3.50072492 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 492 | 1.2099999999999999e-134 | NTclustered | gi|124804771|ref|XM_001348071.1| | 36329 | g10556 | i0 | 100 | 3 | 266 | 0 | 100 | 0 | 1 | 266 | 385 | 120 | Plasmodium falciparum 3D7 60S ribosomal protein L35ae, putative (PF3D7_1142600), partial mRNA | blastn | 798 | 492 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 19319362 | 19319362 | PRJNA1086823_P_NODE_10696_length_266_cov_1.036269_g10579_i0 | PRJNA1086823 | 10696 | 266 | 1.036269 | 2.75647554 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 4.7e-79 | NTclustered | gi|18076408|emb|AJ290926.2| | 36329 | g10579 | i0 | 100 | 2.49624060150376 | 166 | 0 | 62 | 0 | 101 | 266 | 1 | 166 | Plasmodium falciparum partial mRNA for early transcribed membrane protein 11.1 (etramp11.1) | blastn | 664 | 307 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 19319398 | 19319398 | PRJNA1086823_P_NODE_12496_length_253_cov_0.866667_g12379_i0 | PRJNA1086823 | 12496 | 253 | 0.866667 | 2.19266751 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 468 | 1.92e-127 | NTclustered | gi|124804187|ref|XM_001347892.1| | 36329 | g12379 | i0 | 100 | 5.9802371541502 | 253 | 0 | 100 | 0 | 1 | 253 | 183 | 435 | Plasmodium falciparum 3D7 ethanolamine kinase (PF3D7_1124600), partial mRNA | blastn | 1513 | 468 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 21870751 | 21870751 | PRJNA1086823_P_NODE_7398_length_303_cov_1.260870_g7281_i0 | PRJNA1086823 | 7398 | 303 | 1.26087 | 3.8204361 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 457 | 5.12e-124 | NTclustered | gi|124800696|ref|XM_001349500.1| | 36329 | g7281 | i0 | 100 | 4.04620462046205 | 247 | 0 | 100 | 0 | 1 | 247 | 511 | 757 | Plasmodium falciparum 3D7 EMP1-trafficking protein (PF3D7_0202200), partial mRNA | blastn | 1226 | 457 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 28235809 | 28235809 | PRJNA1086823_P_NODE_16466_length_246_cov_0.901734_g16349_i0 | PRJNA1086823 | 16466 | 246 | 0.901734 | 2.21826564 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 4.33e-24 | NR | CAL7865639.1 | 1344799 | g16349 | i0 | 61 | 4 | 82 | 32 | 100 | 0 | 246 | 1 | 531 | 612 | CAL7865639.1 unnamed protein product [Sarcocystis calchasi] | diamond | 984 | 105 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 29341282 | 29341282 | PRJNA1086823_P_NODE_18609_length_243_cov_0.917647_g18492_i0 | PRJNA1086823 | 18609 | 243 | 0.917647 | 2.22988221 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 1.74e-9 | NR | CAL7865402.1 | 1344799 | g18492 | i0 | 54.1 | 0.753086419753086 | 61 | 28 | 75.3 | 0 | 201 | 19 | 12 | 72 | CAL7865402.1 unnamed protein product [Sarcocystis calchasi] | diamond | 183 | 63.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 29616466 | 29616466 | PRJNA1086823_P_NODE_3670_length_405_cov_2.319277_g3553_i0 | PRJNA1086823 | 3670 | 405 | 2.319277 | 9.39307185 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.38e-45 | NR | XP_028525792.1 | 5849 | g3553 | i0 | 57.6 | 16.3703703703704 | 132 | 56 | 97.8 | 0 | 397 | 2 | 1 | 132 | XP_028525792.1 40S ribosomal protein S9, putative [Plasmodium gallinaceum] | diamond | 6630 | 157 | 0.993630573248408 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 31544416 | 31544416 | PRJNA1086823_P_NODE_9956_length_273_cov_1.255000_g9839_i0 | PRJNA1086823 | 9956 | 273 | 1.255 | 3.42615 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 2.28e-22 | NR | XP_001616658.1 | 5855 | g9839 | i0 | 57.3 | 13.032967032967 | 82 | 35 | 90.1 | 0 | 248 | 3 | 95 | 176 | XP_001616658.1 ATP-specific succinyl-CoA synthetase beta subunit, putative [Plasmodium vivax] | diamond | 3558 | 101 | 0.99009900990099 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 32303876 | 32303876 | PRJNA1086823_P_NODE_19559_length_232_cov_2.012579_g19442_i0 | PRJNA1086823 | 19559 | 232 | 2.012579 | 4.66918328 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 4.17e-31 | NR | AET50562.1 | 5802 | g19442 | i0 | 69.7 | 3.93103448275862 | 76 | 23 | 98.3 | 0 | 229 | 2 | 73 | 148 | AET50562.1 hypothetical protein [Eimeria tenella] | diamond | 912 | 117 | 0.991452991452991 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 32312439 | 32312439 | PRJNA1086823_P_NODE_11619_length_256_cov_1.704918_g11502_i0 | PRJNA1086823 | 11619 | 256 | 1.704918 | 4.36459008 | Plasmodium gonderi | 77519 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 8.67e-13 | NR | XP_028546223.1 | 77519 | g11502 | i0 | 43.4 | 4.81640625 | 83 | 46 | 96.1 | 1 | 249 | 4 | 1024 | 1106 | XP_028546223.1 ubiquitin-activating enzyme E1 [Plasmodium gonderi] | diamond | 1233 | 73.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gonderi | ||
| 32848606 | 32848606 | PRJNA1086823_P_NODE_2300_length_498_cov_6.658824_g2183_i0 | PRJNA1086823 | 2300 | 498 | 6.658824 | 33.16094352 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 201 | 3.76e-62 | NR | OEH76901.1 | 88456 | g2183 | i0 | 65 | 3.92168674698795 | 163 | 57 | 98.2 | 0 | 493 | 5 | 29 | 191 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 1953 | 201 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis |
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);;