contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA799842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 793265 | 793265 | PRJNA799842_P_NODE_130641_length_255_cov_1.456044_g129068_i0 | PRJNA799842 | 130641 | 255 | 1.456044 | 3.7129122 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|820691464|tpe|LN714483.1| | 572307 | g129068 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 211 | 238 | 6699572 | 6699599 | TPA_asm: Neospora caninum Liverpool, chromosome chrVIII, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 5896964 | 5896964 | PRJNA799842_P_NODE_134665_length_251_cov_1.286517_g133092_i0 | PRJNA799842 | 134665 | 251 | 1.286517 | 3.22915767 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 5.41e-113 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g133092 | i0 | 96.813 | 5.01195219123506 | 251 | 8 | 100 | 0 | 1 | 251 | 117468 | 117218 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 1258 | 420 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 7172972 | 7172972 | PRJNA799842_P_NODE_33166_length_501_cov_1.733645_g31597_i0 | PRJNA799842 | 33166 | 501 | 1.733645 | 8.68556145 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.004 | NTclustered | gi|916416283|ref|XM_013373919.1| | 5802 | g31597 | i0 | 100 | 0.171656686626747 | 30 | 0 | 6 | 0 | 389 | 418 | 594 | 623 | Eimeria tenella uncharacterized protein (ETH_00000385), partial mRNA | blastn | 86 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 8447189 | 8447189 | PRJNA799842_P_NODE_178187_length_243_cov_0.905882_g176614_i0 | PRJNA799842 | 178187 | 243 | 0.905882 | 2.20129326 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.6599999999999998e-46 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g176614 | i0 | 89.308 | 7.41975308641975 | 159 | 15 | 83 | 2 | 82 | 239 | 300552 | 300395 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 1803 | 198 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 8449090 | 8449090 | PRJNA799842_P_NODE_95687_length_297_cov_1.040179_g94114_i0 | PRJNA799842 | 95687 | 297 | 1.040179 | 3.08933163 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|669199778|ref|XM_008626677.1| | 54757 | g94114 | i0 | 100 | 0.0976430976430976 | 29 | 0 | 10 | 0 | 101 | 129 | 2858 | 2886 | Plasmodium vinckei vinckei condensin-2 complex subunit D3, putative (PVVCY_0903410), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 10996787 | 10996787 | PRJNA799842_P_NODE_106729_length_283_cov_1.100000_g105156_i0 | PRJNA799842 | 106729 | 283 | 1.1 | 3.113 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 4.34e-5 | NTclustered | gi|124506090|ref|XM_001351607.1| | 36329 | g105156 | i0 | 91.111 | 0.597173144876325 | 45 | 4 | 16 | 0 | 185 | 229 | 4915 | 4871 | Plasmodium falciparum 3D7 guanidine nucleotide exchange factor (PF3D7_0508500), partial mRNA | blastn | 169 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 10997591 | 10997591 | PRJNA799842_P_NODE_150809_length_248_cov_0.880000_g149236_i0 | PRJNA799842 | 150809 | 248 | 0.88 | 2.1824 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1620139090|ref|XM_028675237.1| | 85471 | g149236 | i0 | 100 | 0.120967741935484 | 30 | 0 | 12 | 0 | 117 | 146 | 655 | 684 | Plasmodium relictum conserved Plasmodium protein, unknown function (PRELSG_0418700), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 12274541 | 12274541 | PRJNA799842_P_NODE_50610_length_399_cov_1.809816_g49037_i0 | PRJNA799842 | 50610 | 399 | 1.809816 | 7.22116584 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 4.61e-51 | NTclustered | gi|66359883|ref|XM_627120.1| | 353152 | g49037 | i0 | 79.245 | 7.9749373433584 | 318 | 58 | 79 | 8 | 5 | 318 | 380 | 67 | Cryptosporidium parvum Iowa II histone H2A (cgd8_2170) mRNA, complete cds | blastn | 3182 | 215 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 16095258 | 16095258 | PRJNA799842_P_NODE_101873_length_289_cov_0.782407_g100300_i0 | PRJNA799842 | 101873 | 289 | 0.782407 | 2.26115623 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 1.06e-115 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g100300 | i0 | 93.728 | 40.5570934256055 | 287 | 17 | 100 | 1 | 1 | 287 | 300648 | 300933 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 11721 | 429 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 19071199 | 19071199 | PRJNA799842_P_NODE_55995_length_379_cov_3.911765_g54422_i0 | PRJNA799842 | 55995 | 379 | 3.911765 | 14.82558935 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.5499999999999996e-55 | NTclustered | gi|34923223|gb|AY283870.1| | 241650 | g54422 | i0 | 78.272 | 98.9287598944591 | 382 | 66 | 99 | 13 | 4 | 378 | 905 | 1276 | Atoxoplasma sp. MS-2003 large subunit ribosomal RNA gene, partial sequence | blastn | 37494 | 230 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Atoxoplasma | Atoxoplasma sp. MS-2003 | ||
| 21197241 | 21197241 | PRJNA799842_P_NODE_40657_length_448_cov_0.773333_g39086_i0 | PRJNA799842 | 40657 | 448 | 0.773333 | 3.46453184 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.043 | NTclustered | gi|1270523205|ref|XM_022957141.1| | 5861 | g39086 | i0 | 100 | 0.0625 | 28 | 0 | 6 | 0 | 412 | 439 | 7169 | 7142 | Plasmodium yoelii conserved Plasmodium protein, unknown function (PY17X_1332600), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 22470939 | 22470939 | PRJNA799842_P_NODE_163478_length_246_cov_0.890173_g161905_i0 | PRJNA799842 | 163478 | 246 | 0.890173 | 2.18982558 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.03e-5 | NTclustered | gi|1084843273|ref|XM_018785548.1| | 647221 | g161905 | i0 | 97.297 | 14.4105691056911 | 37 | 1 | 15 | 0 | 71 | 107 | 1167 | 1203 | Plasmodium gaboni hypothetical protein partial mRNA | blastn | 3545 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 23746206 | 23746206 | PRJNA799842_P_NODE_140619_length_250_cov_0.870056_g139046_i0 | PRJNA799842 | 140619 | 250 | 0.870056 | 2.17514 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 2.62e-81 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g139046 | i0 | 89.516 | 12.372 | 248 | 26 | 99 | 0 | 3 | 250 | 116227 | 116474 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 3093 | 315 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 24171164 | 24171164 | PRJNA799842_P_NODE_65639_length_352_cov_1.103943_g64066_i0 | PRJNA799842 | 65639 | 352 | 1.103943 | 3.88587936 | root | 1 | Root_unresolved | Root_unresolved | 634 | 2.5999999999999988e-177 | NTclustered | gi|749164626|ref|XM_011135640.1| | 110365 | g64066 | i0 | 99.148 | 62.3579545454545 | 352 | 3 | 100 | 0 | 1 | 352 | 709 | 358 | Gregarina niphandrodes IS4 family transposase partial mRNA | blastn | 21950 | 640 | 0.990625 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes |
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);;