contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA867519" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1236998 | 1236998 | PRJNA867519_P_NODE_33961_length_240_cov_2.658683_g33807_i0 | PRJNA867519 | 33961 | 240 | 2.658683 | 6.3808392 | Haemosporida | 5819 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 3.46e-30 | NTclustered | gi|1372150206|gb|MF508347.1| | 379413 | g33807 | i0 | 86.822 | 21.8458333333333 | 129 | 17 | 54 | 0 | 6 | 134 | 129 | 1 | Leucocytozoon majoris isolate 25104 putative eukaryotic translation initiation factor 2 gamma subunit gene, partial cds | blastn | 5243 | 145 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Leucocytozoidae | Leucocytozoon | Leucocytozoon majoris | ||
| 2123526 | 2123526 | PRJNA867519_P_NODE_31822_length_243_cov_1.358824_g31668_i0 | PRJNA867519 | 31822 | 243 | 1.358824 | 3.30194232 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|915004916|ref|XM_013394120.1| | 5801 | g31668 | i0 | 94.444 | 0.148148148148148 | 36 | 2 | 15 | 0 | 88 | 123 | 195 | 230 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 36 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 3398777 | 3398777 | PRJNA867519_P_NODE_13583_length_317_cov_1.487705_g13429_i0 | PRJNA867519 | 13583 | 317 | 1.487705 | 4.71602485 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 4.93e-5 | NTclustered | gi|914997481|ref|XM_013391813.1| | 5801 | g13429 | i0 | 100 | 10.0788643533123 | 33 | 0 | 10 | 0 | 284 | 316 | 2646 | 2614 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 3195 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 3398793 | 3398793 | PRJNA867519_P_NODE_16143_length_294_cov_2.877828_g15989_i0 | PRJNA867519 | 16143 | 294 | 2.877828 | 8.46081432 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.027 | NTclustered | gi|916423511|ref|XM_013377533.1| | 5802 | g15989 | i0 | 100 | 0.0952380952380952 | 28 | 0 | 10 | 0 | 42 | 69 | 784 | 757 | Eimeria tenella uncharacterized protein (ETH_00011435), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 3398952 | 3398952 | PRJNA867519_P_NODE_5143_length_475_cov_2.052239_g4989_i0 | PRJNA867519 | 5143 | 475 | 2.052239 | 9.74813525 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.001 | NTclustered | gi|916426765|ref|XM_013379160.1| | 5802 | g4989 | i0 | 100 | 0.134736842105263 | 31 | 0 | 7 | 0 | 85 | 115 | 396 | 366 | Eimeria tenella Wee kinase, putative (ETH_00018110), partial mRNA | blastn | 64 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 4676473 | 4676473 | PRJNA867519_P_NODE_17164_length_288_cov_1.432558_g17010_i0 | PRJNA867519 | 17164 | 288 | 1.432558 | 4.12576704 | Plasmodium gonderi | 77519 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|1620955315|ref|XM_028689718.1| | 77519 | g17010 | i0 | 100 | 0.392361111111111 | 29 | 0 | 10 | 0 | 149 | 177 | 1031 | 1003 | Plasmodium gonderi hypothetical protein, conserved (PGO_132020), partial mRNA | blastn | 113 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gonderi | ||
| 5065018 | 5065018 | PRJNA867519_P_NODE_10444_length_352_cov_2.118280_g10290_i0 | PRJNA867519 | 10444 | 352 | 2.11828 | 7.4563456 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 6.949999999999999e-24 | NTclustered | gi|363586005|gb|JN391431.1| | 5865 | g10290 | i0 | 83.846 | 35.4147727272727 | 130 | 21 | 37 | 0 | 207 | 336 | 2360 | 2489 | Babesia bovis isolate Shanxian 28S ribosomal RNA gene, partial sequence | blastn | 12466 | 124 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 9776048 | 9776048 | PRJNA867519_P_NODE_17888_length_285_cov_1.292453_g17734_i0 | PRJNA867519 | 17888 | 285 | 1.292453 | 3.68349105 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|1145259236|ref|XM_012907465.2| | 5854 | g17734 | i0 | 100 | 0.0982456140350877 | 28 | 0 | 10 | 0 | 7 | 34 | 4139 | 4112 | Plasmodium reichenowi hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 11051851 | 11051851 | PRJNA867519_P_NODE_28149_length_248_cov_0.880000_g27995_i0 | PRJNA867519 | 28149 | 248 | 0.88 | 2.1824 | Cryptosporidium andersoni | 117008 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 2.21e-12 | NTclustered | gi|2785772012|ref|XM_067212671.1| | 117008 | g27995 | i0 | 90.625 | 0.576612903225806 | 64 | 6 | 26 | 0 | 185 | 248 | 392 | 329 | Cryptosporidium andersoni 60s ribosomal protein L23 (cand_024410), partial mRNA | blastn | 143 | 86.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 12327303 | 12327303 | PRJNA867519_P_NODE_33990_length_239_cov_3.180723_g33836_i0 | PRJNA867519 | 33990 | 239 | 3.180723 | 7.60192797 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.28e-4 | NTclustered | gi|749158316|ref|XM_011132485.1| | 110365 | g33836 | i0 | 100 | 0.133891213389121 | 32 | 0 | 13 | 0 | 207 | 238 | 530 | 499 | Gregarina niphandrodes 40S ribosomal protein S6 partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 12716536 | 12716536 | PRJNA867519_P_NODE_1170_length_874_cov_5.524345_g1037_i0 | PRJNA867519 | 1170 | 874 | 5.524345 | 48.2827753 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 481 | 9.48e-131 | NTclustered | gi|1843568304|ref|XM_034563737.1| | 5823 | g1037 | i0 | 85.56 | 99.9050343249428 | 464 | 62 | 53 | 5 | 312 | 772 | 690 | 229 | Plasmodium berghei ANKA polyubiquitin, putative (PBANKA_0610300), partial mRNA | blastn | 87317 | 483 | 0.995859213250518 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 17426248 | 17426248 | PRJNA867519_P_NODE_14534_length_308_cov_3.429787_g14380_i0 | PRJNA867519 | 14534 | 308 | 3.429787 | 10.56374396 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.029 | NTclustered | gi|915014753|ref|XM_013396939.1| | 5801 | g14380 | i0 | 100 | 0.0909090909090909 | 28 | 0 | 9 | 0 | 279 | 306 | 5911 | 5884 | Eimeria acervulina Midasin, related partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 17426405 | 17426405 | PRJNA867519_P_NODE_5154_length_474_cov_32.441397_g5000_i0 | PRJNA867519 | 5154 | 474 | 32.441397 | 153.77222178 | uncultured Eimeriidae | 404735 | SAR_Eukaryotes | SAR_Eukaryotes | 577 | 6.15e-160 | NTclustered | gi|134021988|gb|EF023338.1| | 404735 | g5000 | i0 | 88.75 | 77.2257383966245 | 480 | 43 | 100 | 11 | 1 | 474 | 1318 | 1792 | Eimeriidae environmental sample clone Amb_18S_660 18S ribosomal RNA gene, partial sequence | blastn | 36605 | 577 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 17814414 | 17814414 | PRJNA867519_P_NODE_20314_length_274_cov_1.532338_g20160_i0 | PRJNA867519 | 20314 | 274 | 1.532338 | 4.19860612 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 3.1400000000000003e-26 | NTclustered | gi|1673113747|ref|XM_029362122.1| | 94643 | g20160 | i0 | 78.641 | 24.7700729927007 | 206 | 38 | 74 | 6 | 72 | 274 | 10 | 212 | Besnoitia besnoiti putative small GTP binding protein rab1a (BESB_035360), partial mRNA | blastn | 6787 | 132 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 21250285 | 21250285 | PRJNA867519_P_NODE_2577_length_632_cov_4.962433_g2428_i0 | PRJNA867519 | 2577 | 632 | 4.962433 | 31.36257656 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.6399999999999998e-47 | NTclustered | gi|66359883|ref|XM_627120.1| | 353152 | g2428 | i0 | 78.616 | 4.67405063291139 | 318 | 60 | 50 | 8 | 195 | 508 | 67 | 380 | Cryptosporidium parvum Iowa II histone H2A (cgd8_2170) mRNA, complete cds | blastn | 2954 | 204 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 22524808 | 22524808 | PRJNA867519_P_NODE_23098_length_262_cov_1.222222_g22944_i0 | PRJNA867519 | 23098 | 262 | 1.222222 | 3.20222164 | Plasmodium gonderi | 77519 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 4.8200000000000004e-49 | NTclustered | gi|1620952608|ref|XM_028688365.1| | 77519 | g22944 | i0 | 82.041 | 43.3549618320611 | 245 | 42 | 93 | 2 | 19 | 262 | 503 | 260 | Plasmodium gonderi 26S proteasome regulatory subunit RPN11 (PGO_110260), partial mRNA | blastn | 11359 | 207 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gonderi | ||
| 22914676 | 22914676 | PRJNA867519_P_NODE_33818_length_241_cov_0.916667_g33664_i0 | PRJNA867519 | 33818 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1371546918|ref|XM_001348824.3| | 36329 | g33664 | i0 | 100 | 0.377593360995851 | 30 | 0 | 12 | 0 | 176 | 205 | 4817 | 4846 | Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_1471900), partial mRNA | blastn | 91 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 25074107 | 25074107 | PRJNA867519_P_NODE_11880_length_335_cov_1.469466_g11726_i0 | PRJNA867519 | 11880 | 335 | 1.469466 | 4.9227111 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|914995928|ref|XM_013391335.1| | 5801 | g11726 | i0 | 100 | 0.373134328358209 | 30 | 0 | 9 | 0 | 193 | 222 | 530 | 501 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 125 | 56.5 | 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);;