contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA1028258" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3992133 | 3992133 | PRJNA1028258_P_NODE_81764_length_285_cov_1.314815_g81201_i0 | PRJNA1028258 | 81764 | 285 | 1.314815 | 3.74722275 | Cryptosporidium sp. chipmunk genotype I | 1280935 | SAR_Eukaryotes | SAR_Eukaryotes | 91.6 | 5.58e-14 | NTclustered | gi|2787701993|ref|XM_067346770.1| | 1280935 | g81201 | i0 | 81.197 | 1.89122807017544 | 117 | 18 | 40 | 4 | 1 | 115 | 986 | 872 | Cryptosporidium sp. chipmunk genotype I CCT chaperonin gamma subunit (ELE39_003743), partial mRNA | blastn | 539 | 91.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. chipmunk genotype I | ||
| 5266807 | 5266807 | PRJNA1028258_P_NODE_161785_length_228_cov_1.339623_g161222_i0 | PRJNA1028258 | 161785 | 228 | 1.339623 | 3.05434044 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|1620166007|ref|XM_028680878.1| | 880535 | g161222 | i0 | 94.444 | 0.157894736842105 | 36 | 1 | 16 | 1 | 51 | 86 | 2360 | 2394 | Plasmodium sp. gorilla clade G2 conserved Plasmodium protein, unknown function (PADL01_0614700), partial mRNA | blastn | 36 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 5266976 | 5266976 | PRJNA1028258_P_NODE_174105_length_225_cov_1.820513_g173542_i0 | PRJNA1028258 | 174105 | 225 | 1.820513 | 4.09615425 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.3e-4 | NTclustered | gi|820693866|tpe|LN714486.1| | 572307 | g173542 | i0 | 100 | 8.14222222222222 | 31 | 0 | 14 | 0 | 28 | 58 | 1536455 | 1536485 | TPA_asm: Neospora caninum Liverpool, chromosome chrXI, complete genome | blastn | 1832 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 5268207 | 5268207 | PRJNA1028258_P_NODE_71045_length_305_cov_1.105932_g70482_i0 | PRJNA1028258 | 71045 | 305 | 1.105932 | 3.3730926 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.028 | NTclustered | gi|916512145|ref|XM_013500787.1| | 44415 | g70482 | i0 | 100 | 0.0918032786885246 | 28 | 0 | 9 | 0 | 102 | 129 | 85 | 112 | Eimeria mitis uncharacterized protein (EMH_0017060), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 9091322 | 9091322 | PRJNA1028258_P_NODE_146588_length_232_cov_0.871166_g146025_i0 | PRJNA1028258 | 146588 | 232 | 0.871166 | 2.02110512 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 3.3e-35 | NTclustered | gi|669196535|ref|XM_008625057.1| | 54757 | g146025 | i0 | 86 | 3.97844827586207 | 150 | 21 | 65 | 0 | 69 | 218 | 2877 | 3026 | Plasmodium vinckei vinckei regulator of nonsense transcripts 1, putative (PVVCY_1200440), partial mRNA | blastn | 923 | 161 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 9932733 | 9932733 | PRJNA1028258_P_NODE_140648_length_233_cov_0.865854_g140085_i0 | PRJNA1028258 | 140648 | 233 | 0.865854 | 2.01743982 | Conoidasida | 1280412 | SAR_Eukaryotes | SAR_Eukaryotes | 185 | 1.9699999999999998e-42 | NTclustered | gi|1673114745|ref|XM_029362621.1| | 94643 | g140085 | i0 | 81.304 | 7.43347639484979 | 230 | 41 | 98 | 2 | 5 | 233 | 793 | 1021 | Besnoitia besnoiti putative vacuolar ATP synthase subunit b (BESB_040350), partial mRNA | blastn | 1732 | 185 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 11208224 | 11208224 | PRJNA1028258_P_NODE_168529_length_227_cov_0.898734_g167966_i0 | PRJNA1028258 | 168529 | 227 | 0.898734 | 2.04012618 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|820698945|tpe|LN714498.1| | 432359 | g167966 | i0 | 100 | 0.255506607929515 | 29 | 0 | 13 | 0 | 19 | 47 | 1349574 | 1349602 | TPA_asm: Toxoplasma gondii VEG, chromosome chrVIII, complete genome | blastn | 58 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 14192667 | 14192667 | PRJNA1028258_P_NODE_167092_length_227_cov_0.898734_g166529_i0 | PRJNA1028258 | 167092 | 227 | 0.898734 | 2.04012618 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 5.58e-8 | NTclustered | gi|820688590|tpe|LN714475.1| | 572307 | g166529 | i0 | 93.617 | 0.819383259911894 | 47 | 3 | 21 | 0 | 161 | 207 | 1673095 | 1673141 | TPA_asm: Neospora caninum Liverpool, chromosome chrIb, complete genome | blastn | 186 | 71.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 14192868 | 14192868 | PRJNA1028258_P_NODE_180192_length_219_cov_2.326667_g179629_i0 | PRJNA1028258 | 180192 | 219 | 2.326667 | 5.09540073 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.019 | NTclustered | gi|915003258|ref|XM_013393585.1| | 5801 | g179629 | i0 | 100 | 0.127853881278539 | 28 | 0 | 13 | 0 | 82 | 109 | 884 | 857 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 15466580 | 15466580 | PRJNA1028258_P_NODE_150153_length_231_cov_0.876543_g149590_i0 | PRJNA1028258 | 150153 | 231 | 0.876543 | 2.02481433 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.17e-39 | NTclustered | gi|401402052|ref|XM_003881109.1| | 572307 | g149590 | i0 | 80.702 | 58.2077922077922 | 228 | 42 | 98 | 2 | 1 | 227 | 311 | 85 | Neospora caninum Liverpool putative ubiquitin / ribosomal protein CEP52 fusion protein (NCLIV_042000), partial mRNA | blastn | 13446 | 176 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 20565220 | 20565220 | PRJNA1028258_P_NODE_166117_length_227_cov_1.348101_g165554_i0 | PRJNA1028258 | 166117 | 227 | 1.348101 | 3.06018927 | Plasmodium vivax | 5855 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.17e-24 | NTclustered | gi|156101004|ref|XM_001616146.1| | 5855 | g165554 | i0 | 79.661 | 4.88105726872247 | 177 | 34 | 78 | 2 | 35 | 210 | 364 | 539 | Plasmodium vivax 60S ribosomal protein L27a, putative (PVX_114040), mRNA | blastn | 1108 | 126 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 20567035 | 20567035 | PRJNA1028258_P_NODE_96877_length_264_cov_1.312821_g96314_i0 | PRJNA1028258 | 96877 | 264 | 1.312821 | 3.46584744 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 2.36e-17 | NTclustered | gi|2794947469|ref|XM_067860723.1| | 5871 | g96314 | i0 | 81.25 | 2.31439393939394 | 128 | 22 | 48 | 2 | 39 | 165 | 1341 | 1467 | Babesia caballi uncharacterized protein (BcabD6B2_41900), partial mRNA | blastn | 611 | 102 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 23115834 | 23115834 | PRJNA1028258_P_NODE_137899_length_234_cov_0.860606_g137336_i0 | PRJNA1028258 | 137899 | 234 | 0.860606 | 2.01381804 | Theileria parva | 5875 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 5.79e-8 | NTclustered | gi|472824884|dbj|AB739690.1| | 5875 | g137336 | i0 | 83.544 | 1.04700854700855 | 79 | 9 | 33 | 3 | 26 | 102 | 3771 | 3695 | Theileria parva TP03_0861 gene for P150 microsphere antigen, complete cds, strain: BuffaloLAWR | blastn | 245 | 71.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria parva | ||
| 23956791 | 23956791 | PRJNA1028258_P_NODE_121939_length_242_cov_7.173410_g121376_i0 | PRJNA1028258 | 121939 | 242 | 7.17341 | 17.3596522 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1145260771|ref|XM_020114999.1| | 5854 | g121376 | i0 | 90.476 | 0.764462809917355 | 42 | 4 | 17 | 0 | 161 | 202 | 66 | 25 | Plasmodium reichenowi 60S ribosomal protein L41, putative partial mRNA | blastn | 185 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi |
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);;