contig_metadata
17 rows where bioproject = "PRJNA853194", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8494067 | 8494067 | PRJNA853194_S_NODE_81507_length_245_cov_1.924419_g80416_i0 | PRJNA853194 | 81507 | 245 | 1.924419 | 4.71482655 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 5.229999999999999e-118 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g80416 | i0 | 98.776 | 1517.41632653061 | 245 | 3 | 100 | 0 | 1 | 245 | 1653 | 1897 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 371767 | 436 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 10162980 | 10162980 | PRJNA853194_S_NODE_24988_length_410_cov_3.074184_g23897_i0 | PRJNA853194 | 24988 | 410 | 3.074184 | 12.6041544 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.039 | NTclustered | gi|1620132018|ref|XM_028674360.1| | 5849 | g23897 | i0 | 96.774 | 0.14390243902439 | 31 | 1 | 8 | 0 | 50 | 80 | 1061 | 1031 | Plasmodium gallinaceum aspartate--tRNA ligase, putative (PGAL8A_00035800), partial mRNA | blastn | 59 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 11438307 | 11438307 | PRJNA853194_S_NODE_59649_length_283_cov_3.404762_g58558_i0 | PRJNA853194 | 59649 | 283 | 3.404762 | 9.63547646 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 2.4e-62 | NTclustered | gi|833494891|ref|XM_012915035.1| | 5866 | g58558 | i0 | 96.129 | 182.540636042403 | 155 | 5 | 54 | 1 | 1 | 154 | 869 | 715 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 51659 | 252 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 14868351 | 14868351 | PRJNA853194_S_NODE_41672_length_333_cov_1.600000_g40581_i0 | PRJNA853194 | 41672 | 333 | 1.6 | 5.328 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.031 | NTclustered | gi|2287638987|gb|CP102586.1| | 68886 | g40581 | i0 | 96.774 | 0.0930930930930931 | 31 | 1 | 9 | 0 | 200 | 230 | 22403 | 22373 | Theileria orientalis strain Fish Creek apicoplast, complete genome | blastn | 31 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 16143809 | 16143809 | PRJNA853194_S_NODE_74393_length_254_cov_3.657459_g73302_i0 | PRJNA853194 | 74393 | 254 | 3.657459 | 9.28994586 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|1843423010|dbj|LC541821.1| | 5823 | g73302 | i0 | 100 | 0.110236220472441 | 28 | 0 | 11 | 0 | 86 | 113 | 23963 | 23936 | Plasmodium berghei ANKA chromosome 1 telomere region, partial sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 18691445 | 18691445 | PRJNA853194_S_NODE_29795_length_382_cov_3.472492_g28704_i0 | PRJNA853194 | 29795 | 382 | 3.472492 | 13.26491944 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.036 | NTclustered | gi|1027953362|ref|XM_735395.2| | 31271 | g28704 | i0 | 100 | 0.0732984293193717 | 28 | 0 | 7 | 0 | 304 | 331 | 2342 | 2369 | Plasmodium chabaudi chabaudi conserved Plasmodium protein, unknown function (PCHAS_0624300), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 18691768 | 18691768 | PRJNA853194_S_NODE_45135_length_322_cov_0.891566_g44044_i0 | PRJNA853194 | 45135 | 322 | 0.891566 | 2.87084252 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|669201108|ref|XM_008627331.1| | 54757 | g44044 | i0 | 96.97 | 0.102484472049689 | 33 | 1 | 10 | 0 | 72 | 104 | 1549 | 1581 | Plasmodium vinckei vinckei ATP-dependent RNA helicase DBP7, putative (PVVCY_0601910), partial mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 19967296 | 19967296 | PRJNA853194_S_NODE_61816_length_279_cov_1.053398_g60725_i0 | PRJNA853194 | 61816 | 279 | 1.053398 | 2.93898042 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1620184436|ref|XM_028680379.1| | 880535 | g60725 | i0 | 92.5 | 0.14336917562724 | 40 | 1 | 14 | 2 | 57 | 94 | 348 | 387 | Plasmodium sp. gorilla clade G2 Plasmodium exported protein (PHISTa), unknown function (PADL01_0013800), partial mRNA | blastn | 40 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 23792099 | 23792099 | PRJNA853194_S_NODE_16359_length_486_cov_1.002421_g15270_i0 | PRJNA853194 | 16359 | 486 | 1.002421 | 4.87176606 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.047 | NTclustered | gi|1145257067|ref|XM_012906141.2| | 5854 | g15270 | i0 | 100 | 0.0576131687242798 | 28 | 0 | 6 | 0 | 431 | 458 | 1655 | 1628 | Plasmodium reichenowi hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 27379535 | 27379535 | PRJNA853194_S_NODE_343_length_1966_cov_12.753830_g225_i0 | PRJNA853194 | 343 | 1966 | 12.75383 | 250.7402978 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 3.77e-4 | NR | ETW55751.1 | 57270 | g225 | i0 | 23.3 | 8.35757884028484 | 580 | 337 | 79.3 | 28 | 1822 | 263 | 1347 | 1878 | ETW55751.1 hypothetical protein PFUGPA_02256, partial [Plasmodium falciparum Palo Alto/Uganda] | diamond | 16431 | 57 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 27907563 | 27907563 | PRJNA853194_S_NODE_13105_length_531_cov_54.844978_g12030_i0 | PRJNA853194 | 13105 | 531 | 54.844978 | 291.22683318 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 160 | 4.38e-44 | NR | XP_028536015.1 | 85471 | g12030 | i0 | 47.4 | 1.74011299435028 | 154 | 81 | 87 | 0 | 530 | 69 | 260 | 413 | XP_028536015.1 glycylpeptide N-tetradecanoyltransferase, putative [Plasmodium relictum] | diamond | 924 | 160 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 28191772 | 28191772 | PRJNA853194_S_NODE_76426_length_251_cov_1.337079_g75335_i0 | PRJNA853194 | 76426 | 251 | 1.337079 | 3.35606829 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0225 | NR | XP_026193722.1 | 88456 | g75335 | i0 | 39.3 | 0.669322709163347 | 56 | 33 | 65.7 | 1 | 199 | 35 | 884 | 939 | XP_026193722.1 uncharacterized protein LOC34623461 [Cyclospora cayetanensis] | diamond | 168 | 43.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 29044684 | 29044684 | PRJNA853194_S_NODE_25088_length_409_cov_6.181548_g23997_i0 | PRJNA853194 | 25088 | 409 | 6.181548 | 25.28253132 | Cryptosporidium muris RN66 | 441375 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 4.35e-9 | NR | XP_002140823.1 | 441375 | g23997 | i0 | 36.1 | 2.30317848410758 | 108 | 53 | 69.7 | 5 | 5 | 289 | 284 | 388 | XP_002140823.1 uncharacterized protein CMU_009660 [Cryptosporidium muris RN66] | diamond | 942 | 64.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 29139534 | 29139534 | PRJNA853194_S_NODE_4569_length_833_cov_45.030263_g3769_i0 | PRJNA853194 | 4569 | 833 | 45.030263 | 375.10209079 | Toxoplasma gondii GT1 | 507601 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 1.7599999999999998e-24 | NR | EPR61646.1 | 507601 | g3769 | i0 | 30.3 | 1.57022809123649 | 218 | 150 | 77.8 | 1 | 62 | 709 | 125 | 342 | EPR61646.1 N-methyl-D-aspartate receptor-associated protein [Toxoplasma gondii GT1] | diamond | 1308 | 111 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 30979658 | 30979658 | PRJNA853194_S_NODE_12454_length_543_cov_6.980851_g11384_i0 | PRJNA853194 | 12454 | 543 | 6.980851 | 37.90602093 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 1.0799999999999999e-32 | NR | SCP05393.1 | 36330 | g11384 | i0 | 53 | 13.2099447513812 | 134 | 60 | 74 | 3 | 3 | 404 | 560 | 690 | SCP05393.1 exoribonuclease, putative [Plasmodium ovale] | diamond | 7173 | 135 | 0.992592592592593 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 31011021 | 31011021 | PRJNA853194_S_NODE_3574_length_921_cov_20.770047_g2866_i0 | PRJNA853194 | 3574 | 921 | 20.770047 | 191.29213287 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 2.4799999999999994e-48 | NR | ETW54969.1 | 57270 | g2866 | i0 | 54.3 | 2.15960912052117 | 164 | 75 | 53.4 | 0 | 811 | 320 | 26 | 189 | ETW54969.1 hypothetical protein PFUGPA_02792 [Plasmodium falciparum Palo Alto/Uganda] | diamond | 1989 | 172 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 32141473 | 32141473 | PRJNA853194_S_NODE_36098_length_353_cov_3.292857_g35007_i0 | PRJNA853194 | 36098 | 353 | 3.292857 | 11.62378521 | Plasmodium malariae | 5858 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 0.00212 | NR | XP_028860370.1 | 5858 | g35007 | i0 | 39.7 | 1.24079320113314 | 73 | 42 | 60.3 | 2 | 18 | 230 | 244 | 316 | XP_028860370.1 lipoate-protein ligase B, putative [Plasmodium malariae] | diamond | 438 | 47.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium malariae |
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);;