contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA631119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3154032 | 3154032 | PRJNA631119_P_NODE_14963_length_330_cov_1.774319_g14845_i0 | PRJNA631119 | 14963 | 330 | 1.774319 | 5.8552527 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 1.02e-66 | NTclustered | gi|401402052|ref|XM_003881109.1| | 572307 | g14845 | i0 | 82.943 | 82.9727272727273 | 299 | 47 | 90 | 4 | 33 | 329 | 384 | 88 | Neospora caninum Liverpool putative ubiquitin / ribosomal protein CEP52 fusion protein (NCLIV_042000), partial mRNA | blastn | 27381 | 267 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 3703564 | 3703564 | PRJNA631119_P_NODE_32543_length_249_cov_0.875000_g32425_i0 | PRJNA631119 | 32543 | 249 | 0.875 | 2.17875 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.35e-4 | NTclustered | gi|2785757388|ref|XM_067216191.1| | 5824 | g32425 | i0 | 97.143 | 0.55421686746988 | 35 | 1 | 14 | 0 | 1 | 35 | 2210 | 2244 | Plasmodium brasilianum kinesin-like protein (MKS88_000509), partial mRNA | blastn | 138 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 9531667 | 9531667 | PRJNA631119_P_NODE_15428_length_326_cov_2.166008_g15310_i0 | PRJNA631119 | 15428 | 326 | 2.166008 | 7.06118608 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.83e-4 | NTclustered | gi|2795613690|ref|XM_068060875.1| | 483139 | g15310 | i0 | 97.143 | 0.107361963190184 | 35 | 1 | 11 | 0 | 176 | 210 | 11893 | 11859 | Cystoisospora suis zinc finger (ccch type) motif-containing protein (CSUI_000642), mRNA | blastn | 35 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 9531713 | 9531713 | PRJNA631119_P_NODE_22848_length_283_cov_1.161905_g22730_i0 | PRJNA631119 | 22848 | 283 | 1.161905 | 3.28819115 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.56e-4 | NTclustered | gi|916420327|ref|XM_013375941.1| | 5802 | g22730 | i0 | 97.222 | 2.93639575971731 | 36 | 0 | 13 | 1 | 174 | 209 | 1035 | 1069 | Eimeria tenella protein kinase, putative (ETH_00040220), partial mRNA | blastn | 831 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 9531828 | 9531828 | PRJNA631119_P_NODE_7108_length_437_cov_3.288462_g6990_i0 | PRJNA631119 | 7108 | 437 | 3.288462 | 14.37057894 | Plasmodium floridense | 31275 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 4.95e-71 | NTclustered | gi|1372150214|gb|MF508351.1| | 31275 | g6990 | i0 | 82.263 | 14.8558352402746 | 327 | 56 | 75 | 2 | 88 | 413 | 1 | 326 | Plasmodium floridense isolate DR233 putative eukaryotic translation initiation factor 2 gamma subunit gene, partial cds | blastn | 6492 | 281 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium floridense | ||
| 11355240 | 11355240 | PRJNA631119_P_NODE_23869_length_278_cov_2.126829_g23751_i0 | PRJNA631119 | 23869 | 278 | 2.126829 | 5.91258462 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 2.52e-12 | NTclustered | gi|833484291|ref|XM_012911757.1| | 5866 | g23751 | i0 | 96.154 | 8.2589928057554 | 52 | 2 | 19 | 0 | 13 | 64 | 279 | 228 | Babesia bigemina 60S ribosomal L22e protein, putative partial mRNA | blastn | 2296 | 86.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 12082717 | 12082717 | PRJNA631119_P_NODE_35710_length_245_cov_0.895349_g35592_i0 | PRJNA631119 | 35710 | 245 | 0.895349 | 2.19360505 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|2795614724|ref|XM_068061392.1| | 483139 | g35592 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 172 | 199 | 2074 | 2047 | Cystoisospora suis group 1 family protein (CSUI_001186), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 15906041 | 15906041 | PRJNA631119_P_NODE_26153_length_268_cov_1.774359_g26035_i0 | PRJNA631119 | 26153 | 268 | 1.774359 | 4.75528212 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.13e-5 | NTclustered | gi|1145262431|ref|XM_012909360.2| | 5854 | g26035 | i0 | 93.182 | 0.477611940298507 | 44 | 1 | 16 | 1 | 13 | 56 | 1165 | 1206 | Plasmodium reichenowi lipoyl synthase, putative partial mRNA | blastn | 128 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 15906163 | 15906163 | PRJNA631119_P_NODE_7713_length_424_cov_1.717949_g7595_i0 | PRJNA631119 | 7713 | 424 | 1.717949 | 7.28410376 | Cryptosporidium bovis | 310047 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|2787666864|ref|XM_067327123.1| | 310047 | g7595 | i0 | 94.444 | 0.283018867924528 | 36 | 2 | 8 | 0 | 97 | 132 | 8953 | 8988 | Cryptosporidium bovis uncharacterized protein (FG379_001520), partial mRNA | blastn | 120 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis | ||
| 17729847 | 17729847 | PRJNA631119_P_NODE_8034_length_417_cov_2.959302_g7916_i0 | PRJNA631119 | 8034 | 417 | 2.959302 | 12.34028934 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 8.15e-44 | NTclustered | gi|291461364|dbj|AB513881.1| | 5807 | g7916 | i0 | 88.344 | 39.1822541966427 | 163 | 14 | 38 | 5 | 156 | 315 | 1444 | 1604 | Cryptosporidium parvum gene for 18S ribosomal RNA, partial sequence, isolate: Sakha212 | blastn | 16339 | 191 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 18455325 | 18455325 | PRJNA631119_P_NODE_31795_length_250_cov_0.870056_g31677_i0 | PRJNA631119 | 31795 | 250 | 0.870056 | 2.17514 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|916424863|ref|XM_013378209.1| | 5802 | g31677 | i0 | 100 | 0.224 | 28 | 0 | 11 | 0 | 156 | 183 | 1290 | 1263 | Eimeria tenella PHD-zinc finger (C3HC4 type) protein, putative (ETH_00009280), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 19729811 | 19729811 | PRJNA631119_P_NODE_23456_length_280_cov_1.487923_g23338_i0 | PRJNA631119 | 23456 | 280 | 1.487923 | 4.1661844 | Cryptosporidium bovis | 310047 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|2787666010|ref|XM_067327603.1| | 310047 | g23338 | i0 | 92.308 | 0.242857142857143 | 39 | 3 | 14 | 0 | 67 | 105 | 823 | 861 | Cryptosporidium bovis uncharacterized protein (FG379_002000), partial mRNA | blastn | 68 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis | ||
| 19729835 | 19729835 | PRJNA631119_P_NODE_27676_length_262_cov_1.629630_g27558_i0 | PRJNA631119 | 27676 | 262 | 1.62963 | 4.2696306 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|2794941198|ref|XM_067859134.1| | 5871 | g27558 | i0 | 100 | 0.110687022900763 | 29 | 0 | 11 | 0 | 1 | 29 | 207 | 235 | Babesia caballi GAP45 (BcabD6B2_26010), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 22829240 | 22829240 | PRJNA631119_P_NODE_17018_length_315_cov_1.268595_g16900_i0 | PRJNA631119 | 17018 | 315 | 1.268595 | 3.99607425 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.029 | NTclustered | gi|915126978|ref|XM_013479001.1| | 5804 | g16900 | i0 | 96.875 | 0.19047619047619 | 32 | 0 | 10 | 1 | 180 | 210 | 4805 | 4774 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 60 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 22829377 | 22829377 | PRJNA631119_P_NODE_39758_length_239_cov_2.198795_g39640_i0 | PRJNA631119 | 39758 | 239 | 2.198795 | 5.25512005 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2785765732|ref|XM_067217953.1| | 5824 | g39640 | i0 | 92.5 | 0.334728033472803 | 40 | 0 | 16 | 3 | 85 | 123 | 213 | 176 | Plasmodium brasilianum tryptophan-rich protein (MKS88_004751), partial mRNA | blastn | 80 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 24829489 | 24829489 | PRJNA631119_P_NODE_28180_length_260_cov_1.647059_g28062_i0 | PRJNA631119 | 28180 | 260 | 1.647059 | 4.2823534 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.024 | NTclustered | gi|914996027|ref|XM_013391368.1| | 5801 | g28062 | i0 | 100 | 0.107692307692308 | 28 | 0 | 11 | 0 | 78 | 105 | 238 | 211 | Eimeria acervulina hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 24829525 | 24829525 | PRJNA631119_P_NODE_33660_length_248_cov_0.880000_g33542_i0 | PRJNA631119 | 33660 | 248 | 0.88 | 2.1824 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|915014717|ref|XM_013396927.1| | 5801 | g33542 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 101 | 128 | 2653 | 2626 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina |
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);;