contig_metadata
13 rows where bioproject = "PRJNA340009", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1069964 | 1069964 | PRJNA340009_P_NODE_24281_length_248_cov_6.703518_g23974_i0 | PRJNA340009 | 24281 | 248 | 6.703518 | 16.62472464 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.34e-4 | NTclustered | gi|1280184590|gb|MG584560.1| | 27996 | g23974 | i0 | 94.737 | 1.99193548387097 | 38 | 2 | 15 | 0 | 143 | 180 | 994 | 1031 | Cytauxzoon felis isolate 10b internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 494 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Cytauxzoon | Cytauxzoon felis | ||
| 11871001 | 11871001 | PRJNA340009_P_NODE_55750_length_175_cov_1.539683_g55443_i0 | PRJNA340009 | 55750 | 175 | 1.539683 | 2.69444525 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 3.17e-4 | NTclustered | gi|1145258426|ref|XM_020114704.1| | 5854 | g55443 | i0 | 94.595 | 0.211428571428571 | 37 | 2 | 21 | 0 | 17 | 53 | 1165 | 1201 | Plasmodium reichenowi putative membrane protein partial mRNA | blastn | 37 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 14421326 | 14421326 | PRJNA340009_P_NODE_75292_length_161_cov_2.732143_g74985_i0 | PRJNA340009 | 75292 | 161 | 2.732143 | 4.39875023 | Cryptosporidium ryanae | 515981 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 2.22e-5 | NTclustered | gi|2787713731|ref|XM_067342684.1| | 515981 | g74985 | i0 | 94.872 | 0.242236024844721 | 39 | 2 | 24 | 0 | 13 | 51 | 558 | 596 | Cryptosporidium ryanae 40S ribosomal protein S8 (FG386_003370), partial mRNA | blastn | 39 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae | ||
| 21471821 | 21471821 | PRJNA340009_P_NODE_54517_length_176_cov_14.275591_g54210_i0 | PRJNA340009 | 54517 | 176 | 14.275591 | 25.12504016 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 87.9 | 4.07e-13 | NTclustered | gi|820701449|tpe|LN714501.1| | 432359 | g54210 | i0 | 81.308 | 1.21590909090909 | 107 | 20 | 61 | 0 | 62 | 168 | 2409441 | 2409547 | TPA_asm: Toxoplasma gondii VEG, chromosome chrXI, complete genome | blastn | 214 | 87.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 23344230 | 23344230 | PRJNA340009_P_NODE_50579_length_182_cov_5.120301_g50272_i0 | PRJNA340009 | 50579 | 182 | 5.120301 | 9.31894782 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 5.41e-22 | NTclustered | gi|1027950138|ref|XM_016797486.1| | 31271 | g50272 | i0 | 85.088 | 8.14835164835165 | 114 | 17 | 100 | 0 | 69 | 182 | 751 | 864 | Plasmodium chabaudi chabaudi polyubiquitin (PCHAS_0612000), partial mRNA | blastn | 1483 | 117 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 24618056 | 24618056 | PRJNA340009_P_NODE_18900_length_277_cov_0.864035_g18593_i0 | PRJNA340009 | 18900 | 277 | 0.864035 | 2.39337695 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 3.649999999999999e-110 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g18593 | i0 | 94.096 | 28.3682310469314 | 271 | 15 | 100 | 1 | 1 | 271 | 301604 | 301873 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 7858 | 411 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 26662923 | 26662923 | PRJNA340009_P_NODE_9821_length_365_cov_2.044304_g9514_i0 | PRJNA340009 | 9821 | 365 | 2.044304 | 7.4617096 | Porospora cf. gigantea B | 2853592 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 2.06e-6 | NR | XP_068376260.1 | 2853592 | g9514 | i0 | 38.4 | 1.2 | 73 | 44 | 59.2 | 1 | 148 | 363 | 717 | 789 | XP_068376260.1 MAG: uncharacterized protein KVP17_002002 [Porospora cf. gigantea B] | diamond | 438 | 56.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea B | ||
| 26807152 | 26807152 | PRJNA340009_P_NODE_20661_length_266_cov_3.129032_g20354_i0 | PRJNA340009 | 20661 | 266 | 3.129032 | 8.32322512 | root | 1 | Root_unresolved | Root_unresolved | 46.2 | 0.00285 | NR | GFE55414.1 | 5869 | g20354 | i0 | 65.6 | 4.38721804511278 | 32 | 11 | 36.1 | 0 | 265 | 170 | 276 | 307 | GFE55414.1 ethanolamine-phosphate cytidylyltransferase [Babesia ovis] | diamond | 1167 | 46.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 26996869 | 26996869 | PRJNA340009_P_NODE_44842_length_191_cov_7.126761_g44535_i0 | PRJNA340009 | 44842 | 191 | 7.126761 | 13.61211351 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 3.08e-4 | NR | XP_028860367.1 | 5858 | g44535 | i0 | 45.8 | 2.26178010471204 | 48 | 26 | 75.4 | 0 | 145 | 2 | 199 | 246 | XP_028860367.1 dicarboxylate/tricarboxylate carrier, putative [Plasmodium malariae] | diamond | 432 | 47.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium malariae | ||
| 27376710 | 27376710 | PRJNA340009_P_NODE_50143_length_183_cov_2.097015_g49836_i0 | PRJNA340009 | 50143 | 183 | 2.097015 | 3.83753745 | Piroplasmida | 5863 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 1.51e-18 | NR | XP_067803689.1 | 323732 | g49836 | i0 | 64.4 | 3.83606557377049 | 59 | 21 | 96.7 | 0 | 182 | 6 | 15 | 73 | XP_067803689.1 bifunctional RNA recognition motif domain/RNA-binding domain superfamily/Nucleotide-binding alpha-beta plait domain superfamily [Babesia duncani] | diamond | 702 | 85.1 | 0.990599294947121 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 29600644 | 29600644 | PRJNA340009_P_NODE_20590_length_266_cov_9.285714_g20283_i0 | PRJNA340009 | 20590 | 266 | 9.285714 | 24.69999924 | Theileria equi strain WA | 1537102 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.00756 | NR | XP_004832617.1 | 1537102 | g20283 | i0 | 95 | 0.225563909774436 | 20 | 1 | 22.6 | 0 | 205 | 264 | 106 | 125 | XP_004832617.1 hypothetical protein BEWA_052190 [Theileria equi strain WA] | diamond | 60 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 31813134 | 31813134 | PRJNA340009_P_NODE_67357_length_165_cov_0.879310_g67050_i0 | PRJNA340009 | 67357 | 165 | 0.87931 | 1.4508615 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.00164 | NR | XP_013234134.1 | 5802 | g67050 | i0 | 68 | 0.963636363636364 | 25 | 8 | 45.5 | 0 | 49 | 123 | 6 | 30 | XP_013234134.1 cytochrome c, putative [Eimeria tenella] | diamond | 159 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 32572677 | 32572677 | PRJNA340009_P_NODE_32519_length_219_cov_25.876471_g32212_i0 | PRJNA340009 | 32519 | 219 | 25.876471 | 56.66947149 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.028 | NR | OEH79025.1 | 88456 | g32212 | i0 | 44.7 | 0.643835616438356 | 47 | 26 | 64.4 | 0 | 43 | 183 | 491 | 537 | OEH79025.1 endomembrane protein 70 subfamily protein [Cyclospora cayetanensis] | diamond | 141 | 42.7 | 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);;