contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA1204310" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 329687 | 329687 | PRJNA1204310_P_NODE_60781_length_244_cov_0.912281_g60484_i0 | PRJNA1204310 | 60781 | 244 | 0.912281 | 2.22596564 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 3.48e-40 | NTclustered | gi|1027954050|ref|XM_736288.2| | 31271 | g60484 | i0 | 83.854 | 21.9426229508197 | 192 | 25 | 77 | 6 | 21 | 209 | 1044 | 856 | Plasmodium chabaudi chabaudi heat shock protein 90, putative (PCHAS_0806000), partial mRNA | blastn | 5354 | 178 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 1045067 | 1045067 | PRJNA1204310_P_NODE_44341_length_278_cov_1.141463_g44044_i0 | PRJNA1204310 | 44341 | 278 | 1.141463 | 3.17326714 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.007 | NTclustered | gi|915122814|ref|XM_013477217.1| | 5804 | g44044 | i0 | 100 | 0.244604316546763 | 29 | 0 | 10 | 0 | 139 | 167 | 2273 | 2245 | Eimeria maxima hypothetical protein partial mRNA | blastn | 68 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 1603820 | 1603820 | PRJNA1204310_P_NODE_30242_length_338_cov_2.626415_g29945_i0 | PRJNA1204310 | 30242 | 338 | 2.626415 | 8.8772827 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 4.97e-50 | NTclustered | gi|1843572353|ref|XM_034565981.1| | 5823 | g29945 | i0 | 82.213 | 56.414201183432 | 253 | 37 | 74 | 8 | 90 | 338 | 348 | 100 | Plasmodium berghei ANKA ubiquitin-60S ribosomal protein L40, putative (PBANKA_1141700), partial mRNA | blastn | 19068 | 211 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 2320334 | 2320334 | PRJNA1204310_P_NODE_30202_length_339_cov_1.000000_g29905_i0 | PRJNA1204310 | 30202 | 339 | 1 | 3.39 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|915011464|ref|XM_013395973.1| | 5801 | g29905 | i0 | 100 | 8.49262536873156 | 30 | 0 | 9 | 0 | 180 | 209 | 4123 | 4152 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 2879 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 2320429 | 2320429 | PRJNA1204310_P_NODE_882_length_1468_cov_9.222222_g774_i0 | PRJNA1204310 | 882 | 1468 | 9.222222 | 135.38221896 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 867 | 0 | NTclustered | gi|260323703|dbj|AK317816.1| | 5811 | g774 | i0 | 78.629 | 49.8780653950954 | 1357 | 255 | 91 | 27 | 121 | 1461 | 231 | 1568 | Toxoplasma gondii cDNA, clone: XTG00910.2, full cDNA, XTG Sugano cDNA library | blastn | 73221 | 867 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 2879525 | 2879525 | PRJNA1204310_P_NODE_12963_length_489_cov_4.391827_g12666_i0 | PRJNA1204310 | 12963 | 489 | 4.391827 | 21.47603403 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 3.36e-68 | NTclustered | gi|126649276|ref|XM_001388273.1| | 353152 | g12666 | i0 | 80.27 | 7.8118609406953 | 370 | 66 | 75 | 5 | 5 | 370 | 478 | 112 | Cryptosporidium parvum Iowa II ribosomal protein S23 (cgd6_1390) mRNA, partial cds | blastn | 3820 | 272 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 4873205 | 4873205 | PRJNA1204310_P_NODE_58104_length_246_cov_1.306358_g57807_i0 | PRJNA1204310 | 58104 | 246 | 1.306358 | 3.21364068 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 3.37e-70 | NTclustered | gi|67649700|gb|DQ070855.1| | 5821 | g57807 | i0 | 86.992 | 88.739837398374 | 246 | 32 | 100 | 0 | 1 | 246 | 4508 | 4263 | Plasmodium berghei alpha-tubulin I gene, complete cds | blastn | 21830 | 278 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 6707037 | 6707037 | PRJNA1204310_P_NODE_3726_length_859_cov_3.033079_g3489_i0 | PRJNA1204310 | 3726 | 859 | 3.033079 | 26.05414861 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 835 | 0 | NTclustered | gi|820690367|tpe|LN714481.1| | 572307 | g3489 | i0 | 84.744 | 94.419091967404 | 839 | 122 | 97 | 6 | 4 | 839 | 898356 | 897521 | TPA_asm: Neospora caninum Liverpool, chromosome chrVIIa, complete genome | blastn | 81106 | 835 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 6707205 | 6707205 | PRJNA1204310_P_NODE_44826_length_276_cov_1.256158_g44529_i0 | PRJNA1204310 | 44826 | 276 | 1.256158 | 3.46699608 | Plasmodium inui | 52288 | SAR_Eukaryotes | SAR_Eukaryotes | 182 | 3.1e-41 | NTclustered | gi|672193152|ref|XM_008817791.1| | 1237626 | g44529 | i0 | 78.777 | 3.67391304347826 | 278 | 53 | 99 | 6 | 1 | 275 | 1205 | 931 | Plasmodium inui San Antonio 1 26S proteasome regulatory subunit 4 like B partial mRNA | blastn | 1014 | 182 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium inui | ||
| 6707261 | 6707261 | PRJNA1204310_P_NODE_47186_length_267_cov_1.268041_g46889_i0 | PRJNA1204310 | 47186 | 267 | 1.268041 | 3.38566947 | Cryptosporidium baileyi | 27987 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 3.89e-35 | NTclustered | gi|20799266|gb|AF382346.1| | 27987 | g46889 | i0 | 80.569 | 49.310861423221 | 211 | 39 | 79 | 2 | 9 | 218 | 528 | 319 | Cryptosporidium baileyi isolate 764 actin gene, partial cds | blastn | 13166 | 161 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium baileyi | ||
| 7422941 | 7422941 | PRJNA1204310_P_NODE_44846_length_276_cov_1.192118_g44549_i0 | PRJNA1204310 | 44846 | 276 | 1.192118 | 3.29024568 | Eimeria | 5800 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|916414071|ref|XM_013372813.1| | 5802 | g44549 | i0 | 100 | 2.44202898550725 | 29 | 0 | 11 | 0 | 181 | 209 | 1676 | 1704 | Eimeria tenella uncharacterized protein (ETH_00021815), partial mRNA | blastn | 674 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 7982392 | 7982392 | PRJNA1204310_P_NODE_23347_length_378_cov_2.245902_g23050_i0 | PRJNA1204310 | 23347 | 378 | 2.245902 | 8.48950956 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 6.960000000000001e-79 | NTclustered | gi|2794942285|ref|XM_067859410.1| | 5871 | g23050 | i0 | 81.867 | 22.6666666666667 | 375 | 58 | 98 | 10 | 1 | 370 | 1011 | 642 | Babesia caballi histone deacetylase HDAC3 (BcabD6B2_28770), partial mRNA | blastn | 8568 | 307 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 8697929 | 8697929 | PRJNA1204310_P_NODE_27687_length_352_cov_1.060932_g27390_i0 | PRJNA1204310 | 27687 | 352 | 1.060932 | 3.73448064 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.009 | NTclustered | gi|915016507|ref|XM_013397494.1| | 5801 | g27390 | i0 | 100 | 8.96590909090909 | 29 | 0 | 8 | 0 | 242 | 270 | 2329 | 2357 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 3156 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 11248268 | 11248268 | PRJNA1204310_P_NODE_16629_length_438_cov_1.906849_g16332_i0 | PRJNA1204310 | 16629 | 438 | 1.906849 | 8.35199862 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 1.1e-52 | NTclustered | gi|1673116253|ref|XM_029363433.1| | 94643 | g16332 | i0 | 80.272 | 54.4132420091324 | 294 | 56 | 67 | 2 | 145 | 437 | 1300 | 1008 | Besnoitia besnoiti beta-tubulin (BESB_049820), partial mRNA | blastn | 23833 | 220 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 13082873 | 13082873 | PRJNA1204310_P_NODE_37231_length_305_cov_1.594828_g36934_i0 | PRJNA1204310 | 37231 | 305 | 1.594828 | 4.8642254 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.028 | NTclustered | gi|915147041|ref|XM_013483080.1| | 5804 | g36934 | i0 | 94.118 | 1.67213114754098 | 34 | 2 | 11 | 0 | 99 | 132 | 1029 | 996 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 510 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 14357717 | 14357717 | PRJNA1204310_P_NODE_16612_length_438_cov_4.767123_g16315_i0 | PRJNA1204310 | 16612 | 438 | 4.767123 | 20.87999874 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 2.37e-49 | NTclustered | gi|66359883|ref|XM_627120.1| | 353152 | g16315 | i0 | 78.997 | 7.16438356164384 | 319 | 57 | 72 | 10 | 44 | 357 | 380 | 67 | Cryptosporidium parvum Iowa II histone H2A (cgd8_2170) mRNA, complete cds | blastn | 3138 | 209 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 15072660 | 15072660 | PRJNA1204310_P_NODE_32932_length_325_cov_1.464286_g32635_i0 | PRJNA1204310 | 32932 | 325 | 1.464286 | 4.7589295 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|1843569182|ref|XM_034564222.1| | 5823 | g32635 | i0 | 100 | 0.350769230769231 | 29 | 0 | 9 | 0 | 143 | 171 | 4958 | 4930 | Plasmodium berghei ANKA DNA-directed RNA polymerase II subunit RPB1, putative (PBANKA_0807000), partial mRNA | blastn | 114 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 20730772 | 20730772 | PRJNA1204310_P_NODE_397_length_1843_cov_16.852542_g345_i0 | PRJNA1204310 | 397 | 1843 | 16.852542 | 310.59234906 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 1158 | 0 | NTclustered | gi|624291|gb|U19268.1|ETU19268 | 5802 | g345 | i0 | 82.586 | 66.5398806294086 | 1315 | 227 | 71 | 2 | 122 | 1435 | 143 | 1456 | Eimeria tenella beta-tubulin mRNA, complete cds | blastn | 122633 | 1158 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 20731070 | 20731070 | PRJNA1204310_P_NODE_53297_length_251_cov_0.876404_g53000_i0 | PRJNA1204310 | 53297 | 251 | 0.876404 | 2.19977404 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 7.9e-27 | NTclustered | gi|1843573240|ref|XM_034566472.1| | 5823 | g53000 | i0 | 78.037 | 2.0398406374502 | 214 | 45 | 85 | 2 | 39 | 251 | 142 | 354 | Plasmodium berghei ANKA ribosome-interacting GTPase 1, putative (PBANKA_1239200), partial mRNA | blastn | 512 | 134 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 22006360 | 22006360 | PRJNA1204310_P_NODE_53578_length_251_cov_0.876404_g53281_i0 | PRJNA1204310 | 53578 | 251 | 0.876404 | 2.19977404 | Plasmodium floridense | 31275 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|821389578|gb|KR477721.1| | 31275 | g53281 | i0 | 100 | 0.669322709163347 | 28 | 0 | 11 | 0 | 14 | 41 | 72 | 45 | Plasmodium floridense isolate REG2251 histone H3 (HisH3) gene, partial cds | blastn | 168 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium floridense | ||
| 22006620 | 22006620 | PRJNA1204310_P_NODE_7738_length_623_cov_1.796364_g7452_i0 | PRJNA1204310 | 7738 | 623 | 1.796364 | 11.19134772 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 1.64e-37 | NTclustered | gi|915004992|ref|XM_013394145.1| | 5801 | g7452 | i0 | 78.339 | 0.903691813804173 | 277 | 50 | 44 | 8 | 3 | 274 | 136 | 407 | Eimeria acervulina phosphatidylinositol-4-phosphate 5-kinase, putative partial mRNA | blastn | 563 | 171 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 22006622 | 22006622 | PRJNA1204310_P_NODE_778_length_1535_cov_3.513680_g685_i0 | PRJNA1204310 | 778 | 1535 | 3.51368 | 53.934988 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 1511 | 0 | NTclustered | gi|916427472|ref|XM_013379513.1| | 5802 | g685 | i0 | 84.858 | 100.237133550489 | 1519 | 208 | 98 | 19 | 28 | 1535 | 269 | 1776 | Eimeria tenella uncharacterized protein (ETH_00000210), partial mRNA | blastn | 153864 | 1511 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 23281196 | 23281196 | PRJNA1204310_P_NODE_30559_length_337_cov_1.178030_g30262_i0 | PRJNA1204310 | 30559 | 337 | 1.17803 | 3.9699611 | Cryptosporidium meleagridis | 93969 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 2.9399999999999995e-57 | NTclustered | gi|18152888|gb|AF221537.2|AF221537 | 93969 | g30262 | i0 | 81.188 | 87.2878338278932 | 303 | 47 | 88 | 10 | 40 | 337 | 1539 | 1242 | Cryptosporidium meleagridis heat shock protein 70 (HSP70) gene, partial cds | blastn | 29416 | 237 | 0.991561181434599 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium meleagridis |
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);;