contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJEB75230" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 137327 | 137327 | PRJEB75230_P_NODE_53121_length_308_cov_1.153191_g52939_i0 | PRJEB75230 | 53121 | 308 | 1.153191 | 3.55182828 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 322 | 1.98e-83 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g52939 | i0 | 86.288 | 22.3246753246753 | 299 | 38 | 99 | 3 | 3 | 298 | 299865 | 299567 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 6876 | 322 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 995879 | 995879 | PRJEB75230_P_NODE_155201_length_245_cov_0.895349_g155019_i0 | PRJEB75230 | 155201 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|124804711|ref|XM_001348052.1| | 36329 | g155019 | i0 | 96.97 | 0.840816326530612 | 33 | 1 | 13 | 0 | 177 | 209 | 1786 | 1754 | Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_1140700), partial mRNA | blastn | 206 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 1410966 | 1410966 | PRJEB75230_P_NODE_149482_length_246_cov_0.890173_g149300_i0 | PRJEB75230 | 149482 | 246 | 0.890173 | 2.18982558 | Theileria annulata | 5874 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|84995970|ref|XM_947614.1| | 5874 | g149300 | i0 | 100 | 0.117886178861789 | 29 | 0 | 12 | 0 | 148 | 176 | 672 | 700 | Theileria annulata Theileria-specific sub-telomeric protein, SVSP family, putative (TA17125), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 1411355 | 1411355 | PRJEB75230_P_NODE_179182_length_241_cov_1.375000_g179000_i0 | PRJEB75230 | 179182 | 241 | 1.375 | 3.31375 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 9.95e-11 | NTclustered | gi|160044|gb|M63819.1|PFA7H87 | 5833 | g179000 | i0 | 80.734 | 2.10373443983402 | 109 | 15 | 44 | 5 | 116 | 220 | 261 | 367 | P.falciparum malaria antigen (7H8/7) gene, 3' end | blastn | 507 | 80.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 1412397 | 1412397 | PRJEB75230_P_NODE_80282_length_279_cov_1.868932_g80100_i0 | PRJEB75230 | 80282 | 279 | 1.868932 | 5.21432028 | Plasmodium knowlesi | 5850 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|221056653|ref|XM_002259429.1| | 5851 | g80100 | i0 | 100 | 0.100358422939068 | 28 | 0 | 10 | 0 | 130 | 157 | 402 | 429 | Plasmodium knowlesi strain H conserved Plasmodium protein, unknown function (PKNH_0944200), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 2687643 | 2687643 | PRJEB75230_P_NODE_63503_length_295_cov_2.081081_g63321_i0 | PRJEB75230 | 63503 | 295 | 2.081081 | 6.13918895 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 4.45e-20 | NTclustered | gi|921122118|ref|XM_013580223.1| | 51315 | g63321 | i0 | 87.5 | 1.85423728813559 | 96 | 12 | 33 | 0 | 41 | 136 | 207 | 112 | Eimeria necatrix 40S ribosomal protein S28, putative partial mRNA | blastn | 547 | 111 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 3546687 | 3546687 | PRJEB75230_P_NODE_43123_length_322_cov_2.730924_g42941_i0 | PRJEB75230 | 43123 | 322 | 2.730924 | 8.79357528 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|915142657|ref|XM_013482357.1| | 5804 | g42941 | i0 | 100 | 9.41304347826087 | 29 | 0 | 9 | 0 | 134 | 162 | 339 | 311 | Eimeria maxima hypothetical protein partial mRNA | blastn | 3031 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 3961943 | 3961943 | PRJEB75230_P_NODE_1084_length_1196_cov_10.619768_g974_i0 | PRJEB75230 | 1084 | 1196 | 10.619768 | 127.01242528 | Rhytidocystis dobrovolskiji | 2719951 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 5.29e-50 | NTclustered | gi|1823682786|gb|MT231947.1| | 2719951 | g974 | i0 | 84.581 | 13.6897993311037 | 227 | 22 | 23 | 9 | 821 | 1046 | 3525 | 3311 | Rhytidocystis dobrovolskiji isolate OL_MBS2015 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 16373 | 213 | 1 | Eukaryota | Sar | Apicomplexa | Marosporida | Agamococcidiorida | Rhytidocystidae | Rhytidocystis | Rhytidocystis dobrovolskiji | ||
| 3964094 | 3964094 | PRJEB75230_P_NODE_8764_length_493_cov_1.066667_g8582_i0 | PRJEB75230 | 8764 | 493 | 1.066667 | 5.25866831 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 1.22e-67 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g8582 | i0 | 77.115 | 24.6937119675456 | 520 | 85 | 100 | 16 | 6 | 493 | 96630 | 96113 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 12174 | 270 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 7373263 | 7373263 | PRJEB75230_P_NODE_109766_length_256_cov_1.595628_g109584_i0 | PRJEB75230 | 109766 | 256 | 1.595628 | 4.08480768 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|820697327|tpe|LN714495.1| | 432359 | g109584 | i0 | 100 | 6.44140625 | 30 | 0 | 12 | 0 | 61 | 90 | 2878735 | 2878706 | TPA_asm: Toxoplasma gondii VEG, chromosome chrVI, complete genome | blastn | 1649 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 7789945 | 7789945 | PRJEB75230_P_NODE_70447_length_288_cov_1.432558_g70265_i0 | PRJEB75230 | 70447 | 288 | 1.432558 | 4.12576704 | Plasmodium cynomolgi | 5827 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.027 | NTclustered | gi|457876564|ref|XM_004227901.1| | 1120755 | g70265 | i0 | 96.774 | 0.107638888888889 | 31 | 1 | 11 | 0 | 20 | 50 | 765 | 795 | Plasmodium cynomolgi strain B hypothetical protein (PCYB_004800) mRNA, complete cds | blastn | 31 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium cynomolgi | ||
| 10339074 | 10339074 | PRJEB75230_P_NODE_122409_length_250_cov_2.197740_g122227_i0 | PRJEB75230 | 122409 | 250 | 2.19774 | 5.49435 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 9.61e-66 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g122227 | i0 | 85.6 | 20.476 | 250 | 36 | 100 | 0 | 1 | 250 | 300457 | 300706 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 5119 | 263 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 10339190 | 10339190 | PRJEB75230_P_NODE_130789_length_249_cov_0.875000_g130607_i0 | PRJEB75230 | 130789 | 249 | 0.875 | 2.17875 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|916426731|ref|XM_013379143.1| | 5802 | g130607 | i0 | 92.5 | 0.160642570281124 | 40 | 1 | 15 | 1 | 145 | 182 | 525 | 564 | Eimeria tenella uncharacterized protein (ETH_00012025), partial mRNA | blastn | 40 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 10339880 | 10339880 | PRJEB75230_P_NODE_186129_length_226_cov_2.013072_g185947_i0 | PRJEB75230 | 186129 | 226 | 2.013072 | 4.54954272 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.02 | NTclustered | gi|2795622010|ref|XM_068065035.1| | 483139 | g185947 | i0 | 100 | 0.123893805309735 | 28 | 0 | 12 | 0 | 1 | 28 | 7762 | 7735 | Cystoisospora suis uncharacterized protein (CSUI_004854), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 10340030 | 10340030 | PRJEB75230_P_NODE_26569_length_360_cov_0.829268_g26387_i0 | PRJEB75230 | 26569 | 360 | 0.829268 | 2.9853648 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 1.41e-85 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g26387 | i0 | 94.393 | 28.4583333333333 | 214 | 12 | 100 | 0 | 112 | 325 | 299993 | 299780 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 10245 | 329 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 10340640 | 10340640 | PRJEB75230_P_NODE_65829_length_293_cov_1.050000_g65647_i0 | PRJEB75230 | 65829 | 293 | 1.05 | 3.0765 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|401408268|ref|XM_003883534.1| | 572307 | g65647 | i0 | 100 | 0.204778156996587 | 30 | 0 | 10 | 0 | 1 | 30 | 2401 | 2430 | Neospora caninum Liverpool hypothetical protein (NCLIV_033380), partial mRNA | blastn | 60 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 12890291 | 12890291 | PRJEB75230_P_NODE_176871_length_242_cov_0.911243_g176689_i0 | PRJEB75230 | 176871 | 242 | 0.911243 | 2.20520806 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|296005414|ref|XM_001349947.2| | 36329 | g176689 | i0 | 100 | 0.119834710743802 | 29 | 0 | 12 | 0 | 144 | 172 | 14465 | 14437 | Plasmodium falciparum 3D7 conserved Plasmodium membrane protein, unknown function (PF3D7_1324300), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 14164891 | 14164891 | PRJEB75230_P_NODE_15912_length_408_cov_1.038806_g15730_i0 | PRJEB75230 | 15912 | 408 | 1.038806 | 4.23832848 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 704 | 0 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g15730 | i0 | 97.794 | 5.18872549019608 | 408 | 9 | 100 | 0 | 1 | 408 | 117705 | 117298 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 2117 | 704 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 15440302 | 15440302 | PRJEB75230_P_NODE_84053_length_276_cov_1.517241_g83871_i0 | PRJEB75230 | 84053 | 276 | 1.517241 | 4.18758516 | Cryptosporidium andersoni | 117008 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.025 | NTclustered | gi|2785774618|ref|XM_067210691.1| | 117008 | g83871 | i0 | 100 | 0.101449275362319 | 28 | 0 | 10 | 0 | 148 | 175 | 396 | 423 | Cryptosporidium andersoni uncharacterized protein (cand_004480), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 17988430 | 17988430 | PRJEB75230_P_NODE_22895_length_372_cov_1.474916_g22713_i0 | PRJEB75230 | 22895 | 372 | 1.474916 | 5.48668752 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.035 | NTclustered | gi|820693866|tpe|LN714486.1| | 572307 | g22713 | i0 | 96.875 | 0.0860215053763441 | 32 | 0 | 8 | 1 | 38 | 68 | 2853276 | 2853307 | TPA_asm: Neospora caninum Liverpool, chromosome chrXI, complete genome | blastn | 32 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 20536940 | 20536940 | PRJEB75230_P_NODE_124517_length_250_cov_0.870056_g124335_i0 | PRJEB75230 | 124517 | 250 | 0.870056 | 2.17514 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|916500131|ref|XM_013495426.1| | 44415 | g124335 | i0 | 100 | 0.116 | 29 | 0 | 12 | 0 | 133 | 161 | 4446 | 4474 | Eimeria mitis uncharacterized protein (EMH_0001040), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 23948607 | 23948607 | PRJEB75230_P_NODE_50039_length_312_cov_1.288703_g49857_i0 | PRJEB75230 | 50039 | 312 | 1.288703 | 4.02075336 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|2785770428|ref|XM_067211806.1| | 117008 | g49857 | i0 | 100 | 0.448717948717949 | 29 | 0 | 9 | 0 | 64 | 92 | 778 | 806 | Cryptosporidium andersoni uncharacterized protein (cand_015710), partial mRNA | blastn | 140 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 24361909 | 24361909 | PRJEB75230_P_NODE_129440_length_249_cov_1.312500_g129258_i0 | PRJEB75230 | 129440 | 249 | 1.3125 | 3.268125 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 9.5e-71 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g129258 | i0 | 87.2 | 2.0281124497992 | 250 | 27 | 100 | 5 | 2 | 249 | 80579 | 80333 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 505 | 279 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 24363828 | 24363828 | PRJEB75230_P_NODE_94860_length_267_cov_1.690722_g94678_i0 | PRJEB75230 | 94860 | 267 | 1.690722 | 4.51422774 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 494 | 3.38e-135 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g94678 | i0 | 100 | 24.8089887640449 | 267 | 0 | 100 | 0 | 1 | 267 | 299400 | 299666 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 6624 | 494 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum |
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);;