contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1195374" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 321222 | 321222 | PRJNA1195374_P_NODE_22341_length_480_cov_8.542998_g21997_i0 | PRJNA1195374 | 22341 | 480 | 8.542998 | 41.0063904 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 9.04e-79 | NTclustered | gi|401402052|ref|XM_003881109.1| | 572307 | g21997 | i0 | 81.316 | 69.6833333333333 | 380 | 69 | 79 | 2 | 88 | 466 | 379 | 1 | Neospora caninum Liverpool putative ubiquitin / ribosomal protein CEP52 fusion protein (NCLIV_042000), partial mRNA | blastn | 33448 | 307 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 1042647 | 1042647 | PRJNA1195374_P_NODE_33921_length_387_cov_1.417197_g33577_i0 | PRJNA1195374 | 33921 | 387 | 1.417197 | 5.48455239 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 84.2 | 1.31e-11 | NTclustered | gi|9981|emb|X16075.1| | 5833 | g33577 | i0 | 87.013 | 2.21447028423773 | 77 | 7 | 19 | 1 | 2 | 75 | 1966 | 2042 | Plasmodium falciparum beta-tubulin gene | blastn | 857 | 84.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 1597098 | 1597098 | PRJNA1195374_P_NODE_8822_length_739_cov_1.699700_g8511_i0 | PRJNA1195374 | 8822 | 739 | 1.6997 | 12.560783 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.021 | NTclustered | gi|1472911719|ref|XM_026336290.1| | 88456 | g8511 | i0 | 100 | 0.039242219215155603 | 29 | 0 | 4 | 0 | 46 | 74 | 3547 | 3575 | PREDICTED: Cyclospora cayetanensis uncharacterized LOC34618198 (LOC34618198), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 3593433 | 3593433 | PRJNA1195374_P_NODE_83103_length_242_cov_1.349112_g82759_i0 | PRJNA1195374 | 83103 | 242 | 1.349112 | 3.26485104 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|921130381|ref|XM_013584272.1| | 51315 | g82759 | i0 | 100 | 1.33057851239669 | 29 | 0 | 14 | 0 | 192 | 220 | 600 | 628 | Eimeria necatrix hypothetical protein partial mRNA | blastn | 322 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 4149289 | 4149289 | PRJNA1195374_P_NODE_80284_length_244_cov_1.350877_g79940_i0 | PRJNA1195374 | 80284 | 244 | 1.350877 | 3.29613988 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|915132202|ref|XM_013480242.1| | 5804 | g79940 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 165 | 192 | 504 | 477 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 5424343 | 5424343 | PRJNA1195374_P_NODE_20105_length_506_cov_0.951501_g19762_i0 | PRJNA1195374 | 20105 | 506 | 0.951501 | 4.81459506 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 2.96e-4 | NTclustered | gi|1673124000|ref|XM_029360743.1| | 94643 | g19762 | i0 | 97.143 | 0.0691699604743083 | 35 | 1 | 7 | 0 | 64 | 98 | 6770 | 6804 | Besnoitia besnoiti uncharacterized protein (BESB_020340), partial mRNA | blastn | 35 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 6699505 | 6699505 | PRJNA1195374_P_NODE_43786_length_336_cov_0.863118_g43442_i0 | PRJNA1195374 | 43786 | 336 | 0.863118 | 2.90007648 | Babesia bigemina | 5866 | SAR_Eukaryotes | SAR_Eukaryotes | 494 | 4.38e-135 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g43442 | i0 | 94.172 | 1112.30654761905 | 326 | 15 | 97 | 1 | 1 | 326 | 198 | 519 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 373735 | 494 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 7420581 | 7420581 | PRJNA1195374_P_NODE_37646_length_365_cov_3.106164_g37302_i0 | PRJNA1195374 | 37646 | 365 | 3.106164 | 11.3374986 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 9.1e-43 | NTclustered | gi|1620128357|ref|XM_028673401.1| | 5849 | g37302 | i0 | 82.488 | 5.24657534246575 | 217 | 34 | 59 | 4 | 147 | 361 | 266 | 52 | Plasmodium gallinaceum 40S ribosomal protein S17, putative (PGAL8A_00463400), partial mRNA | blastn | 1915 | 187 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 7975276 | 7975276 | PRJNA1195374_P_NODE_58707_length_283_cov_1.366667_g58363_i0 | PRJNA1195374 | 58707 | 283 | 1.366667 | 3.86766761 | Eimeria bovis | 5803 | SAR_Eukaryotes | SAR_Eukaryotes | 93.5 | 1.54e-14 | NTclustered | gi|493664993|dbj|AB769731.1| | 5803 | g58363 | i0 | 93.548 | 24.5512367491166 | 62 | 4 | 22 | 0 | 222 | 283 | 870 | 809 | Eimeria bovis genes for internal transcribed spacer 1, 5.8S rRNA, internal transcribed spacer 2 and 28S rRNA, partial and complete sequence, isolate: 6-1 | blastn | 6948 | 93.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria bovis | ||
| 7975573 | 7975573 | PRJNA1195374_P_NODE_74167_length_249_cov_0.875000_g73823_i0 | PRJNA1195374 | 74167 | 249 | 0.875 | 2.17875 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.84e-4 | NTclustered | gi|1620165617|ref|XM_028685640.1| | 880535 | g73823 | i0 | 100 | 0.244979919678715 | 31 | 0 | 12 | 0 | 201 | 231 | 972 | 942 | Plasmodium sp. gorilla clade G2 Hsc70-interacting protein (PADL01_0526500), partial mRNA | blastn | 61 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 11799516 | 11799516 | PRJNA1195374_P_NODE_10390_length_687_cov_7.644951_g10071_i0 | PRJNA1195374 | 10390 | 687 | 7.644951 | 52.52081337 | Plasmodium vivax | 5855 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 6.81e-7 | NTclustered | gi|156099327|ref|XM_001615616.1| | 5855 | g10071 | i0 | 93.478 | 0.0669577874818049 | 46 | 3 | 7 | 0 | 117 | 162 | 173 | 128 | Plasmodium vivax hypothetical protein, conserved (PVX_116860), partial mRNA | blastn | 46 | 69.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 19447723 | 19447723 | PRJNA1195374_P_NODE_46676_length_323_cov_2.648000_g46332_i0 | PRJNA1195374 | 46676 | 323 | 2.648 | 8.55304 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 7.969999999999999e-43 | NTclustered | gi|1620175242|ref|XM_028683095.1| | 880535 | g46332 | i0 | 87.578 | 11.0557275541796 | 161 | 20 | 50 | 0 | 122 | 282 | 115 | 275 | Plasmodium sp. gorilla clade G2 dynein light chain 1, putative (PADL01_1214100), partial mRNA | blastn | 3571 | 187 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 19448435 | 19448435 | PRJNA1195374_P_NODE_81536_length_243_cov_1.788235_g81192_i0 | PRJNA1195374 | 81536 | 243 | 1.788235 | 4.34541105 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.6200000000000002e-33 | NTclustered | gi|669195517|ref|XM_008624548.1| | 54757 | g81192 | i0 | 82.857 | 8.61316872427984 | 175 | 28 | 72 | 2 | 69 | 242 | 111 | 284 | Plasmodium vinckei vinckei mitosis protein dim1, putative (PVVCY_1404830), partial mRNA | blastn | 2093 | 156 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 20168774 | 20168774 | PRJNA1195374_P_NODE_13776_length_606_cov_1.429644_g13438_i0 | PRJNA1195374 | 13776 | 606 | 1.429644 | 8.66364264 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.001 | NTclustered | gi|915142093|ref|XM_013482243.1| | 5804 | g13438 | i0 | 100 | 2.86633663366337 | 31 | 0 | 5 | 0 | 393 | 423 | 1212 | 1182 | Eimeria maxima hypothetical protein partial mRNA | blastn | 1737 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 20169262 | 20169262 | PRJNA1195374_P_NODE_83916_length_242_cov_0.911243_g83572_i0 | PRJNA1195374 | 83916 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.002 | NTclustered | gi|820699808|tpe|LN714499.1| | 432359 | g83572 | i0 | 100 | 2.90495867768595 | 30 | 0 | 12 | 0 | 22 | 51 | 4781890 | 4781919 | TPA_asm: Toxoplasma gondii VEG, chromosome chrIX, complete genome | blastn | 703 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 20723274 | 20723274 | PRJNA1195374_P_NODE_57117_length_287_cov_1.439252_g56773_i0 | PRJNA1195374 | 57117 | 287 | 1.439252 | 4.13065324 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|915015087|ref|XM_013397049.1| | 5801 | g56773 | i0 | 96.97 | 0.114982578397213 | 33 | 1 | 11 | 0 | 254 | 286 | 915 | 947 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 22719485 | 22719485 | PRJNA1195374_P_NODE_32458_length_396_cov_2.012384_g32114_i0 | PRJNA1195374 | 32458 | 396 | 2.012384 | 7.96904064 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.64e-50 | NTclustered | gi|2794945628|ref|XM_067860250.1| | 5871 | g32114 | i0 | 80.866 | 71.2373737373737 | 277 | 47 | 69 | 6 | 103 | 376 | 424 | 151 | Babesia caballi 40S ribosomal protein S11, putative (BcabD6B2_37170), partial mRNA | blastn | 28210 | 215 | 0.990697674418605 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi |
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);;