contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6853204 | 6853204 | PRJNA494251_P_NODE_5246_length_556_cov_4.070393_g4952_i0 | PRJNA494251 | 5246 | 556 | 4.070393 | 22.63138508 | Legerella nova | 3081637 | SAR_Eukaryotes | SAR_Eukaryotes | 76.8 | 3.25e-9 | NTclustered | gi|2699878143|gb|OR693319.1| | 3081637 | g4952 | i0 | 91.228 | 13.6528776978417 | 57 | 4 | 10 | 1 | 368 | 423 | 19940 | 19884 | Legerella nova apicoplast, complete genome | blastn | 7591 | 76.8 | 1 | Eukaryota | Sar | Apicomplexa | Legerellidae | Legerella | Legerella nova | ||||
| 8128361 | 8128361 | PRJNA494251_P_NODE_30627_length_269_cov_3.729592_g30313_i0 | PRJNA494251 | 30627 | 269 | 3.729592 | 10.03260248 | Porospora cf. gigantea A | 2853593 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 6.61e-28 | NTclustered | gi|2794688989|ref|XM_067949899.1| | 2853593 | g30313 | i0 | 84.672 | 5.35315985130112 | 137 | 21 | 51 | 0 | 1 | 137 | 215 | 79 | MAG: Porospora cf. gigantea A uncharacterized protein (KVP18_000638), partial mRNA | blastn | 1440 | 137 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea A | ||
| 9403286 | 9403286 | PRJNA494251_P_NODE_2808_length_726_cov_2.473201_g2540_i0 | PRJNA494251 | 2808 | 726 | 2.473201 | 17.95543926 | Plasmodium brasilianum | 5824 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 2.59e-6 | NTclustered | gi|2785762771|ref|XM_067216320.1| | 5824 | g2540 | i0 | 91.667 | 0.176308539944904 | 48 | 4 | 7 | 0 | 77 | 124 | 336 | 289 | Plasmodium brasilianum inositol polyphosphate multikinase (MKS88_003245), partial mRNA | blastn | 128 | 67.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 10678797 | 10678797 | PRJNA494251_P_NODE_19909_length_318_cov_1.257143_g19595_i0 | PRJNA494251 | 19909 | 318 | 1.257143 | 3.99771474 | Plasmodium giganteum | 195938 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 7.83e-43 | NTclustered | gi|702072950|emb|LN482948.1| | 195938 | g19595 | i0 | 78.521 | 10.1792452830189 | 284 | 61 | 89 | 0 | 12 | 295 | 370 | 653 | Plasmodium giganteum partial RPN7 gene for putative 26S proteasome regulatory subunit 7 | blastn | 3237 | 187 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium giganteum | ||
| 11953989 | 11953989 | PRJNA494251_P_NODE_24070_length_295_cov_1.792793_g23756_i0 | PRJNA494251 | 24070 | 295 | 1.792793 | 5.28873935 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.64e-4 | NTclustered | gi|1027955884|ref|XM_016798434.1| | 31271 | g23756 | i0 | 87.037 | 1.54237288135593 | 54 | 5 | 18 | 2 | 29 | 81 | 668 | 616 | Plasmodium chabaudi chabaudi conserved Plasmodium protein, unknown function (PCHAS_1031800), partial mRNA | blastn | 455 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 15778203 | 15778203 | PRJNA494251_P_NODE_5893_length_531_cov_1.934498_g5594_i0 | PRJNA494251 | 5893 | 531 | 1.934498 | 10.27218438 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.014 | NTclustered | gi|916510754|ref|XM_013500151.1| | 44415 | g5594 | i0 | 100 | 0.0546139359698682 | 29 | 0 | 5 | 0 | 395 | 423 | 162 | 190 | Eimeria mitis uncharacterized protein (EMH_0079630), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 19601032 | 19601032 | PRJNA494251_P_NODE_14536_length_362_cov_2.024221_g14225_i0 | PRJNA494251 | 14536 | 362 | 2.024221 | 7.32768002 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 3.97e-81 | NTclustered | gi|401402052|ref|XM_003881109.1| | 572307 | g14225 | i0 | 84.259 | 84.6602209944751 | 324 | 49 | 89 | 2 | 6 | 328 | 57 | 379 | Neospora caninum Liverpool putative ubiquitin / ribosomal protein CEP52 fusion protein (NCLIV_042000), partial mRNA | blastn | 30647 | 315 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 19601066 | 19601066 | PRJNA494251_P_NODE_17956_length_331_cov_10.903101_g17642_i0 | PRJNA494251 | 17956 | 331 | 10.903101 | 36.08926431 | Eimeria nieschulzi | 44416 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 5.18e-5 | NTclustered | gi|684155934|gb|KJ939342.1| | 44416 | g17642 | i0 | 97.222 | 1.03323262839879 | 36 | 1 | 11 | 0 | 49 | 84 | 767 | 802 | Eimeria nieschulzi gametocyte protein mRNA, complete cds | blastn | 342 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria nieschulzi | ||
| 20877138 | 20877138 | PRJNA494251_P_NODE_3377_length_675_cov_3.340532_g3100_i0 | PRJNA494251 | 3377 | 675 | 3.340532 | 22.548591 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 1.74e-52 | NTclustered | gi|2794943265|ref|XM_067859656.1| | 5871 | g3100 | i0 | 80.546 | 36.2474074074074 | 293 | 51 | 43 | 4 | 265 | 554 | 419 | 130 | Babesia caballi histone H2A variant, putative (BcabD6B2_31230), partial mRNA | blastn | 24467 | 220 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 20877241 | 20877241 | PRJNA494251_P_NODE_41757_length_247_cov_0.885057_g41443_i0 | PRJNA494251 | 41757 | 247 | 0.885057 | 2.18609079 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|124512261|ref|XM_001349228.1| | 36329 | g41443 | i0 | 100 | 1.94331983805668 | 29 | 0 | 12 | 0 | 112 | 140 | 15777 | 15805 | Plasmodium falciparum 3D7 HECT-like E3 ubiquitin ligase, putative (PF3D7_0826100), partial mRNA | blastn | 480 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 21508932 | 21508932 | PRJNA494251_S_NODE_157_length_500_cov_42.292740_g142_i0 | PRJNA494251 | 157 | 500 | 42.29274 | 211.4637 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 9.85e-49 | NTclustered | gi|8927036|gb|AF076872.1|AF076872 | 482539 | g142 | i0 | 92.414 | 29.062 | 145 | 11 | 29 | 0 | 301 | 445 | 432 | 576 | Isospora felis large subunit ribosomal RNA gene, partial sequence | blastn | 14531 | 207 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora felis | ||
| 22151768 | 22151768 | PRJNA494251_P_NODE_1978_length_847_cov_2.691214_g1744_i0 | PRJNA494251 | 1978 | 847 | 2.691214 | 22.79458258 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 2.32e-17 | NTclustered | gi|160358922|gb|EU252544.1| | 88456 | g1744 | i0 | 78.035 | 1.98229043683589 | 173 | 33 | 20 | 5 | 68 | 240 | 1507 | 1674 | Cyclospora cayetanensis 28S large subunit ribosomal RNA gene, partial sequence | blastn | 1679 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 22783950 | 22783950 | PRJNA494251_P_NODE_20138_length_316_cov_2.366255_g19824_i0 | PRJNA494251 | 20138 | 316 | 2.366255 | 7.4773658 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.03 | NTclustered | gi|14329719|emb|AJ301624.1| | 5821 | g19824 | i0 | 100 | 4.51898734177215 | 28 | 0 | 9 | 0 | 99 | 126 | 3499 | 3526 | Plasmodium berghei 28S rRNA gene, strain ANKA | blastn | 1428 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei |
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);;