contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA611476" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 589331 | 589331 | PRJNA611476_P_NODE_29701_length_377_cov_1.680921_g28910_i0 | PRJNA611476 | 29701 | 377 | 1.680921 | 6.33707217 | Babesia bigemina | 5866 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 7.72e-4 | NTclustered | gi|833484166|ref|XM_012911717.1| | 5866 | g28910 | i0 | 97.059 | 0.0901856763925729 | 34 | 1 | 9 | 0 | 230 | 263 | 169 | 136 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 34 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 1148137 | 1148137 | PRJNA611476_P_NODE_54501_length_296_cov_1.381166_g53710_i0 | PRJNA611476 | 54501 | 296 | 1.381166 | 4.08825136 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.027 | NTclustered | gi|915126338|ref|XM_013478842.1| | 5804 | g53710 | i0 | 96.774 | 0.199324324324324 | 31 | 1 | 10 | 0 | 32 | 62 | 3400 | 3430 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 59 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 1865241 | 1865241 | PRJNA611476_P_NODE_30902_length_371_cov_1.932886_g30111_i0 | PRJNA611476 | 30902 | 371 | 1.932886 | 7.17100706 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.01 | NTclustered | gi|914995110|ref|XM_013391076.1| | 5801 | g30111 | i0 | 94.444 | 0.0970350404312668 | 36 | 1 | 10 | 1 | 70 | 105 | 5102 | 5068 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 36 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 3699735 | 3699735 | PRJNA611476_P_NODE_65963_length_274_cov_1.388060_g65172_i0 | PRJNA611476 | 65963 | 274 | 1.38806 | 3.8032844 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 8.2e-72 | NTclustered | gi|457700|emb|X77914.1| | 5833 | g65172 | i0 | 86.207 | 19.0036496350365 | 261 | 36 | 95 | 0 | 12 | 272 | 968 | 708 | P.falciparum TBP mRNA | blastn | 5207 | 283 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 6967471 | 6967471 | PRJNA611476_P_NODE_17646_length_471_cov_1.160804_g16856_i0 | PRJNA611476 | 17646 | 471 | 1.160804 | 5.46738684 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.013 | NTclustered | gi|1620153122|ref|XM_028676834.1| | 85471 | g16856 | i0 | 100 | 0.0615711252653928 | 29 | 0 | 6 | 0 | 273 | 301 | 3649 | 3621 | Plasmodium relictum conserved Plasmodium protein, unknown function (PRELSG_0007300), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 8242336 | 8242336 | PRJNA611476_P_NODE_24387_length_409_cov_1.080357_g23596_i0 | PRJNA611476 | 24387 | 409 | 1.080357 | 4.41866013 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|921119015|ref|XM_013578673.1| | 51315 | g23596 | i0 | 90.698 | 0.17359413202934 | 43 | 2 | 10 | 2 | 69 | 110 | 2568 | 2527 | Eimeria necatrix Bud site selection-related protein, related partial mRNA | blastn | 71 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 8242472 | 8242472 | PRJNA611476_P_NODE_33727_length_359_cov_1.664336_g32936_i0 | PRJNA611476 | 33727 | 359 | 1.664336 | 5.97496624 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 2.03e-4 | NTclustered | gi|1673123540|ref|XM_029360495.1| | 94643 | g32936 | i0 | 100 | 0.0891364902506964 | 32 | 0 | 9 | 0 | 59 | 90 | 5834 | 5865 | Besnoitia besnoiti uncharacterized protein (BESB_017800), partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 8242819 | 8242819 | PRJNA611476_P_NODE_59387_length_286_cov_1.159624_g58596_i0 | PRJNA611476 | 59387 | 286 | 1.159624 | 3.31652464 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|916506316|ref|XM_013498164.1| | 44415 | g58596 | i0 | 100 | 0.104895104895105 | 30 | 0 | 10 | 0 | 40 | 69 | 624 | 653 | Eimeria mitis uncharacterized protein (EMH_0063620), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 8243202 | 8243202 | PRJNA611476_P_NODE_89087_length_248_cov_1.822857_g88296_i0 | PRJNA611476 | 89087 | 248 | 1.822857 | 4.52068536 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.04e-5 | NTclustered | gi|1145261285|ref|XM_012908689.2| | 5854 | g88296 | i0 | 93.023 | 28.4959677419355 | 43 | 3 | 17 | 0 | 117 | 159 | 2417 | 2375 | Plasmodium reichenowi cyclin partial mRNA | blastn | 7067 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 14618066 | 14618066 | PRJNA611476_P_NODE_14952_length_509_cov_1.116972_g14162_i0 | PRJNA611476 | 14952 | 509 | 1.116972 | 5.68538748 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.004 | NTclustered | gi|915017250|ref|XM_013397725.1| | 5801 | g14162 | i0 | 94.595 | 0.182711198428291 | 37 | 0 | 7 | 1 | 242 | 276 | 1992 | 1956 | Eimeria acervulina TBC domain-containing kinase (incomplete catalytic triad), putative partial mRNA | blastn | 93 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 17167380 | 17167380 | PRJNA611476_P_NODE_44934_length_322_cov_1.160643_g44143_i0 | PRJNA611476 | 44934 | 322 | 1.160643 | 3.73727046 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 2.29e-18 | NTclustered | gi|401397521|ref|XM_003880025.1| | 572307 | g44143 | i0 | 85.859 | 1.69875776397516 | 99 | 14 | 31 | 0 | 224 | 322 | 1324 | 1226 | Neospora caninum Liverpool hypothetical protein (NCLIV_005150), partial mRNA | blastn | 547 | 106 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 20274524 | 20274524 | PRJNA611476_P_NODE_57696_length_289_cov_1.222222_g56905_i0 | PRJNA611476 | 57696 | 289 | 1.222222 | 3.53222158 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.75e-4 | NTclustered | gi|1843568146|ref|XM_034568545.1| | 5823 | g56905 | i0 | 97.059 | 0.235294117647059 | 34 | 1 | 12 | 0 | 233 | 266 | 2558 | 2591 | Plasmodium berghei ANKA major facilitator superfamily domain-containing protein, putative (PBANKA_0602400), partial mRNA | blastn | 68 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 22266965 | 22266965 | PRJNA611476_P_NODE_66838_length_272_cov_2.683417_g66047_i0 | PRJNA611476 | 66838 | 272 | 2.683417 | 7.29889424 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|916422819|ref|XM_013377187.1| | 5802 | g66047 | i0 | 100 | 0.75 | 30 | 0 | 11 | 0 | 203 | 232 | 145 | 116 | Eimeria tenella uncharacterized protein (ETH_00022475), partial mRNA | blastn | 204 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 24099911 | 24099911 | PRJNA611476_P_NODE_57379_length_289_cov_2.287037_g56588_i0 | PRJNA611476 | 57379 | 289 | 2.287037 | 6.60953693 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 4.26e-35 | NTclustered | gi|260323800|dbj|AK318085.1| | 5811 | g56588 | i0 | 84.568 | 7.00692041522491 | 162 | 25 | 56 | 0 | 1 | 162 | 321 | 482 | Toxoplasma gondii cDNA, clone: XTG04568.2, full cDNA, XTG Sugano cDNA library | blastn | 2025 | 161 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 24816118 | 24816118 | PRJNA611476_P_NODE_68700_length_269_cov_1.209184_g67909_i0 | PRJNA611476 | 68700 | 269 | 1.209184 | 3.25270496 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.025 | NTclustered | gi|916507304|ref|XM_013498543.1| | 44415 | g67909 | i0 | 100 | 0.104089219330855 | 28 | 0 | 10 | 0 | 1 | 28 | 2043 | 2070 | Eimeria mitis uncharacterized protein (EMH_0066740), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis |
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);;