contig_metadata
10 rows where bioproject = "PRJNA312899", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 379374 | 379374 | PRJNA312899_P_NODE_31581_length_327_cov_3.413669_g31139_i0 | PRJNA312899 | 31581 | 327 | 3.413669 | 11.16269763 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 2.02e-118 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g31139 | i0 | 91.131 | 32.4954128440367 | 327 | 23 | 100 | 6 | 1 | 327 | 102 | 422 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 10626 | 438 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 15092654 | 15092654 | PRJNA312899_P_NODE_72812_length_189_cov_1.078571_g72370_i0 | PRJNA312899 | 72812 | 189 | 1.078571 | 2.03849919 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|916426793|ref|XM_013379174.1| | 5802 | g72370 | i0 | 100 | 2.34391534391534 | 29 | 0 | 15 | 0 | 146 | 174 | 142 | 170 | Eimeria tenella uncharacterized protein (ETH_00018000), partial mRNA | blastn | 443 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 15681775 | 15681775 | PRJNA312899_P_NODE_14613_length_494_cov_2.424719_g14180_i0 | PRJNA312899 | 14613 | 494 | 2.424719 | 11.97811186 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.004 | NTclustered | gi|261883347|gb|GQ282199.1| | 36329 | g14180 | i0 | 96.97 | 0.0668016194331984 | 33 | 1 | 7 | 0 | 31 | 63 | 20 | 52 | Plasmodium falciparum 3D7 Pfa-npcR6867, complete sequence | blastn | 33 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 18231749 | 18231749 | PRJNA312899_P_NODE_70975_length_191_cov_2.042254_g70533_i0 | PRJNA312899 | 70975 | 191 | 2.042254 | 3.90070514 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 5.66e-32 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g70533 | i0 | 86.331 | 4.93193717277487 | 139 | 17 | 100 | 2 | 54 | 191 | 96420 | 96557 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 942 | 150 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 20781560 | 20781560 | PRJNA312899_P_NODE_70417_length_192_cov_2.853147_g69975_i0 | PRJNA312899 | 70417 | 192 | 2.853147 | 5.47804224 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 8.759999999999999e-90 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g69975 | i0 | 98.958 | 13.0104166666667 | 192 | 1 | 99 | 1 | 1 | 191 | 301556 | 301365 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 2498 | 342 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 23331397 | 23331397 | PRJNA312899_P_NODE_29919_length_337_cov_19.611111_g29477_i0 | PRJNA312899 | 29919 | 337 | 19.611111 | 66.08944407 | Plasmodium coatneyi | 208452 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.032 | NTclustered | gi|1139859519|ref|XM_020057520.1| | 208452 | g29477 | i0 | 100 | 0.0830860534124629 | 28 | 0 | 8 | 0 | 80 | 107 | 9043 | 9070 | Plasmodium coatneyi Cysteine repeat modular protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium coatneyi | ||
| 24605251 | 24605251 | PRJNA312899_P_NODE_25240_length_372_cov_4.479876_g24798_i0 | PRJNA312899 | 25240 | 372 | 4.479876 | 16.66513872 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.01 | NTclustered | gi|921125473|ref|XM_013581892.1| | 51315 | g24798 | i0 | 100 | 0.153225806451613 | 29 | 0 | 8 | 0 | 81 | 109 | 1835 | 1807 | Eimeria necatrix zinc finger (C3HC4 RING finger) protein, putative partial mRNA | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 24605524 | 24605524 | PRJNA312899_P_NODE_39760_length_283_cov_11.384615_g39318_i0 | PRJNA312899 | 39760 | 283 | 11.384615 | 32.21846045 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 302 | 2.35e-77 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g39318 | i0 | 86.102 | 42.7279151943463 | 295 | 24 | 100 | 3 | 5 | 283 | 97085 | 96792 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 12092 | 302 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 26838908 | 26838908 | PRJNA312899_P_NODE_81201_length_176_cov_2.409449_g80759_i0 | PRJNA312899 | 81201 | 176 | 2.409449 | 4.24063024 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 1.26e-7 | NR | KAF8822859.1 | 476202 | g80759 | i0 | 69.7 | 10.4488636363636 | 33 | 10 | 56.3 | 0 | 9 | 107 | 121 | 153 | KAF8822859.1 ribosomal protein RPS18 [Cardiosporidium cionae] | diamond | 1839 | 55.8 | 0.99462365591397806 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 30042655 | 30042655 | PRJNA312899_P_NODE_29771_length_338_cov_15.934256_g29329_i0 | PRJNA312899 | 29771 | 338 | 15.934256 | 53.85778528 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 2.94e-5 | NR | XP_013234781.1 | 5802 | g29329 | i0 | 41.4 | 0.514792899408284 | 58 | 34 | 51.5 | 0 | 336 | 163 | 56 | 113 | XP_013234781.1 uncharacterized protein ETH_00032675 [Eimeria tenella] | diamond | 174 | 50.8 | 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);;