contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA715462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 706235 | 706235 | PRJNA715462_P_NODE_54341_length_249_cov_0.875000_g53545_i0 | PRJNA715462 | 54341 | 249 | 0.875 | 2.17875 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 2.24e-7 | NTclustered | gi|916503126|ref|XM_013496860.1| | 44415 | g53545 | i0 | 97.561 | 14.6987951807229 | 41 | 0 | 16 | 1 | 200 | 240 | 225 | 186 | Eimeria mitis uncharacterized protein (EMH_0052280), partial mRNA | blastn | 3660 | 69.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 1982149 | 1982149 | PRJNA715462_P_NODE_49662_length_253_cov_1.305556_g48866_i0 | PRJNA715462 | 49662 | 253 | 1.305556 | 3.30305668 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.81e-5 | NTclustered | gi|2795618946|ref|XM_068063503.1| | 483139 | g48866 | i0 | 100 | 12.8853754940711 | 33 | 0 | 13 | 0 | 9 | 41 | 3408 | 3376 | Cystoisospora suis uncharacterized protein (CSUI_003305), mRNA | blastn | 3260 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 2467588 | 2467588 | PRJNA715462_P_NODE_23702_length_372_cov_2.357860_g22906_i0 | PRJNA715462 | 23702 | 372 | 2.35786 | 8.7712392 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 4.54e-6 | NTclustered | gi|1673122061|ref|XM_029366880.1| | 94643 | g22906 | i0 | 93.182 | 4.1989247311828 | 44 | 3 | 12 | 0 | 256 | 299 | 571 | 614 | Besnoitia besnoiti nuclear factor NF3 (BESB_085300), partial mRNA | blastn | 1562 | 65.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 3744000 | 3744000 | PRJNA715462_P_NODE_48563_length_256_cov_1.366120_g47767_i0 | PRJNA715462 | 48563 | 256 | 1.36612 | 3.4972672 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|1620137813|ref|XM_028678278.1| | 85471 | g47767 | i0 | 96.875 | 0.25 | 32 | 1 | 13 | 0 | 99 | 130 | 887 | 856 | Plasmodium relictum origin recognition complex subunit 2, putative (ORC2), partial mRNA | blastn | 64 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 5020592 | 5020592 | PRJNA715462_P_NODE_61384_length_245_cov_0.895349_g60588_i0 | PRJNA715462 | 61384 | 245 | 0.895349 | 2.19360505 | root | 1 | Root_unresolved | Root_unresolved | 65.8 | 2.84e-6 | NTclustered | gi|237833922|ref|XM_002366218.1| | 508771 | g60588 | i0 | 93.182 | 4.77551020408163 | 44 | 3 | 18 | 0 | 110 | 153 | 7502 | 7459 | Toxoplasma gondii ME49 STE kinase partial mRNA | blastn | 1170 | 65.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 7084352 | 7084352 | PRJNA715462_P_NODE_28626_length_334_cov_2.003831_g27830_i0 | PRJNA715462 | 28626 | 334 | 2.003831 | 6.69279554 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 6.49e-34 | NTclustered | gi|237832786|ref|XM_002365650.1| | 508771 | g27830 | i0 | 85.43 | 3.77245508982036 | 151 | 22 | 45 | 0 | 184 | 334 | 350 | 200 | Toxoplasma gondii ME49 splicing factor DIM1, putative (DIM1), partial mRNA | blastn | 1260 | 158 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 7570109 | 7570109 | PRJNA715462_P_NODE_34846_length_299_cov_2.008850_g34050_i0 | PRJNA715462 | 34846 | 299 | 2.00885 | 6.0064615 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.28e-5 | NTclustered | gi|1624464859|ref|XM_029005993.1| | 5858 | g34050 | i0 | 100 | 9.41471571906355 | 34 | 0 | 11 | 0 | 198 | 231 | 1679 | 1646 | Plasmodium malariae SET domain protein, putative (PmUG01_11033900), partial mRNA | blastn | 2815 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium malariae | ||
| 9634270 | 9634270 | PRJNA715462_P_NODE_30788_length_321_cov_1.241935_g29992_i0 | PRJNA715462 | 30788 | 321 | 1.241935 | 3.98661135 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 2.99e-7 | NTclustered | gi|1084813209|ref|XM_018784818.1| | 647221 | g29992 | i0 | 90.385 | 4.76323987538941 | 52 | 5 | 16 | 0 | 51 | 102 | 3520 | 3469 | Plasmodium gaboni putative tyrosine kinase-like protein partial mRNA | blastn | 1529 | 69.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 10910369 | 10910369 | PRJNA715462_P_NODE_59449_length_246_cov_0.890173_g58653_i0 | PRJNA715462 | 59449 | 246 | 0.890173 | 2.18982558 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|921129645|ref|XM_013583904.1| | 51315 | g58653 | i0 | 100 | 0.752032520325203 | 30 | 0 | 12 | 0 | 54 | 83 | 1409 | 1380 | Eimeria necatrix hypothetical protein, conserved partial mRNA | blastn | 185 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 11395834 | 11395834 | PRJNA715462_P_NODE_31649_length_316_cov_1.547325_g30853_i0 | PRJNA715462 | 31649 | 316 | 1.547325 | 4.889547 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|1145264097|ref|XR_002204104.1| | 5854 | g30853 | i0 | 100 | 0.367088607594937 | 29 | 0 | 9 | 0 | 233 | 261 | 922 | 950 | Plasmodium reichenowi unknown | blastn | 116 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 12185424 | 12185424 | PRJNA715462_P_NODE_48490_length_256_cov_1.612022_g47694_i0 | PRJNA715462 | 48490 | 256 | 1.612022 | 4.12677632 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 2.26e-22 | NTclustered | gi|1624694595|ref|XM_029012169.1| | 189622 | g47694 | i0 | 83.465 | 24.90625 | 127 | 21 | 50 | 0 | 113 | 239 | 202 | 328 | Babesia ovata 60S ribosomal protein L22 (BOVATA_032520), partial mRNA | blastn | 6376 | 119 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 17283682 | 17283682 | PRJNA715462_P_NODE_26114_length_352_cov_1.641577_g25318_i0 | PRJNA715462 | 26114 | 352 | 1.641577 | 5.77835104 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.009 | NTclustered | gi|915126452|ref|XM_013478871.1| | 5804 | g25318 | i0 | 92.105 | 0.375 | 38 | 3 | 11 | 0 | 87 | 124 | 408 | 445 | Eimeria maxima hypothetical protein partial mRNA | blastn | 132 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima |
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);;