contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1022139" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161663 | 161663 | PRJNA1022139_P_NODE_32601_length_257_cov_1.255435_g32496_i0 | PRJNA1022139 | 32601 | 257 | 1.255435 | 3.22646795 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|1939226152|ref|XM_038022161.1| | 44415 | g32496 | i0 | 100 | 0.334630350194553 | 29 | 0 | 11 | 0 | 51 | 79 | 3550 | 3522 | Eimeria mitis uncharacterized protein (EMH_0084130), partial mRNA | blastn | 86 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 1436581 | 1436581 | PRJNA1022139_P_NODE_6882_length_500_cov_1.311475_g6777_i0 | PRJNA1022139 | 6882 | 500 | 1.311475 | 6.557375 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.001 | NTclustered | gi|921132301|ref|XM_013585232.1| | 51315 | g6777 | i0 | 97.059 | 0.37 | 34 | 1 | 7 | 0 | 326 | 359 | 985 | 952 | Eimeria necatrix hypothetical protein, conserved partial mRNA | blastn | 185 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 2278759 | 2278759 | PRJNA1022139_P_NODE_37382_length_248_cov_0.880000_g37277_i0 | PRJNA1022139 | 37382 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.34e-4 | NTclustered | gi|1145256490|ref|XM_012905786.2| | 5854 | g37277 | i0 | 97.143 | 1.00806451612903 | 35 | 1 | 14 | 0 | 12 | 46 | 927 | 961 | Plasmodium reichenowi E3 ubiquitin-protein ligase, putative partial mRNA | blastn | 250 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 4831591 | 4831591 | PRJNA1022139_P_NODE_22804_length_294_cov_1.393665_g22699_i0 | PRJNA1022139 | 22804 | 294 | 1.393665 | 4.0973751 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 7.169999999999998e-43 | NTclustered | gi|260323800|dbj|AK318085.1| | 5811 | g22699 | i0 | 83.5 | 9.26190476190476 | 200 | 33 | 68 | 0 | 81 | 280 | 482 | 283 | Toxoplasma gondii cDNA, clone: XTG04568.2, full cDNA, XTG Sugano cDNA library | blastn | 2723 | 187 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 5264571 | 5264571 | PRJNA1022139_P_NODE_31465_length_261_cov_1.638298_g31360_i0 | PRJNA1022139 | 31465 | 261 | 1.638298 | 4.27595778 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.024 | NTclustered | gi|820690367|tpe|LN714481.1| | 572307 | g31360 | i0 | 100 | 0.10727969348659 | 28 | 0 | 11 | 0 | 168 | 195 | 2686868 | 2686895 | TPA_asm: Neospora caninum Liverpool, chromosome chrVIIa, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 6539755 | 6539755 | PRJNA1022139_P_NODE_12446_length_382_cov_1.663430_g12341_i0 | PRJNA1022139 | 12446 | 382 | 1.66343 | 6.3543026 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.01 | NTclustered | gi|915010228|ref|XM_013395633.1| | 5801 | g12341 | i0 | 96.875 | 0.0837696335078534 | 32 | 1 | 8 | 0 | 27 | 58 | 5690 | 5659 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 7814129 | 7814129 | PRJNA1022139_P_NODE_12047_length_387_cov_2.694268_g11942_i0 | PRJNA1022139 | 12047 | 387 | 2.694268 | 10.42681716 | Cryptosporidium bovis | 310047 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|2787666010|ref|XM_067327603.1| | 310047 | g11942 | i0 | 92.308 | 0.175710594315245 | 39 | 3 | 10 | 0 | 145 | 183 | 823 | 861 | Cryptosporidium bovis uncharacterized protein (FG379_002000), partial mRNA | blastn | 68 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis | ||
| 10364773 | 10364773 | PRJNA1022139_P_NODE_19489_length_316_cov_1.781893_g19384_i0 | PRJNA1022139 | 19489 | 316 | 1.781893 | 5.63078188 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.37e-5 | NTclustered | gi|916500213|ref|XM_013495467.1| | 44415 | g19384 | i0 | 88.889 | 54.0854430379747 | 54 | 2 | 17 | 4 | 244 | 296 | 178 | 228 | Eimeria mitis uncharacterized protein (EMH_0040120), partial mRNA | blastn | 17091 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 11206896 | 11206896 | PRJNA1022139_P_NODE_44029_length_203_cov_4.215385_g43924_i0 | PRJNA1022139 | 44029 | 203 | 4.215385 | 8.55723155 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.06e-4 | NTclustered | gi|1620130826|ref|XM_028673702.1| | 5849 | g43924 | i0 | 97.143 | 0.344827586206897 | 35 | 1 | 17 | 0 | 60 | 94 | 373 | 407 | Plasmodium gallinaceum MORN repeat-containing protein 1 (MORN1), partial mRNA | blastn | 70 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 11640264 | 11640264 | PRJNA1022139_P_NODE_33130_length_255_cov_1.291209_g33025_i0 | PRJNA1022139 | 33130 | 255 | 1.291209 | 3.29258295 | Babesia motasi | 237580 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 2.3e-7 | NTclustered | gi|1013181534|gb|KT819635.1| | 237580 | g33025 | i0 | 89.091 | 0.215686274509804 | 55 | 6 | 22 | 0 | 3 | 57 | 658 | 712 | Babesia motasi strain Tianzhu ribosomal protein S5 (RPS5) gene, partial cds | blastn | 55 | 69.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia motasi | ||
| 17581385 | 17581385 | PRJNA1022139_P_NODE_31654_length_260_cov_2.080214_g31549_i0 | PRJNA1022139 | 31654 | 260 | 2.080214 | 5.4085564 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.007 | NTclustered | gi|331264576|gb|JF827031.1| | 383379 | g31549 | i0 | 100 | 3.59615384615385 | 29 | 0 | 11 | 0 | 109 | 137 | 6804 | 6776 | Toxoplasma gondii RH GCN2-like eIF2 kinase (IF2K-D) mRNA, complete cds | blastn | 935 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 18013421 | 18013421 | PRJNA1022139_P_NODE_20775_length_307_cov_1.645299_g20670_i0 | PRJNA1022139 | 20775 | 307 | 1.645299 | 5.05106793 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 6.16e-4 | NTclustered | gi|1472913795|ref|XM_026337366.1| | 88456 | g20670 | i0 | 94.737 | 0.123778501628664 | 38 | 1 | 12 | 1 | 149 | 185 | 1613 | 1650 | PREDICTED: Cyclospora cayetanensis uncharacterized LOC34622722 (LOC34622722), mRNA | blastn | 38 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 18013606 | 18013606 | PRJNA1022139_P_NODE_43835_length_227_cov_3.844156_g43730_i0 | PRJNA1022139 | 43835 | 227 | 3.844156 | 8.72623412 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.35e-4 | NTclustered | gi|915144870|ref|XM_013482763.1| | 5804 | g43730 | i0 | 97.143 | 0.154185022026432 | 35 | 0 | 15 | 1 | 43 | 77 | 6149 | 6116 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 35 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 19287356 | 19287356 | PRJNA1022139_P_NODE_30856_length_263_cov_2.636842_g30751_i0 | PRJNA1022139 | 30856 | 263 | 2.636842 | 6.93489446 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.024 | NTclustered | gi|921120726|ref|XM_013579527.1| | 51315 | g30751 | i0 | 100 | 0.106463878326996 | 28 | 0 | 11 | 0 | 208 | 235 | 97 | 124 | Eimeria necatrix hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 22680381 | 22680381 | PRJNA1022139_P_NODE_2678_length_758_cov_2.007299_g2588_i0 | PRJNA1022139 | 2678 | 758 | 2.007299 | 15.21532642 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 6.69e-92 | NTclustered | gi|669199686|ref|XM_008626631.1| | 54757 | g2588 | i0 | 79.492 | 42.4630606860158 | 512 | 92 | 67 | 13 | 252 | 758 | 1266 | 763 | Plasmodium vinckei vinckei 26S protease regulatory subunit 6A, putative (PVVCY_0902920), partial mRNA | blastn | 32187 | 353 | 0.994334277620397 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 23113817 | 23113817 | PRJNA1022139_P_NODE_12579_length_381_cov_0.961039_g12474_i0 | PRJNA1022139 | 12579 | 381 | 0.961039 | 3.66155859 | Plasmodium vivax | 5855 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.01 | NTclustered | gi|156100080|ref|XM_001615718.1| | 5855 | g12474 | i0 | 100 | 0.223097112860892 | 29 | 0 | 8 | 0 | 37 | 65 | 5361 | 5333 | Plasmodium vivax hypothetical protein (PVX_117365), partial mRNA | blastn | 85 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 23114016 | 23114016 | PRJNA1022139_P_NODE_40179_length_244_cov_0.900585_g40074_i0 | PRJNA1022139 | 40179 | 244 | 0.900585 | 2.1974274 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|124512817|ref|XM_001349729.1| | 36329 | g40074 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 159 | 186 | 10820 | 10793 | Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_1303800), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum |
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);;