contig_metadata
13 rows where bioproject = "PRJNA1150539", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2851870 | 2851870 | PRJNA1150539_S_NODE_108263_length_229_cov_2.807692_g107667_i0 | PRJNA1150539 | 108263 | 229 | 2.807692 | 6.42961468 | Theileria equi | 5872 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.02 | NTclustered | gi|510899745|ref|XM_004828559.1| | 1537102 | g107667 | i0 | 94.286 | 0.152838427947598 | 35 | 1 | 15 | 1 | 84 | 118 | 378 | 411 | Theileria equi strain WA hypothetical protein (BEWA_017910), partial mRNA | blastn | 35 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 4128369 | 4128369 | PRJNA1150539_S_NODE_56824_length_299_cov_4.247788_g56228_i0 | PRJNA1150539 | 56824 | 299 | 4.247788 | 12.70088612 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.66e-4 | NTclustered | gi|1145256581|ref|XM_012905840.2| | 5854 | g56228 | i0 | 94.737 | 1.10367892976589 | 38 | 2 | 13 | 0 | 244 | 281 | 519 | 482 | Plasmodium reichenowi diacylglycerol O-acyltransferase, putative partial mRNA | blastn | 330 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 5404401 | 5404401 | PRJNA1150539_S_NODE_47305_length_316_cov_1.403292_g46709_i0 | PRJNA1150539 | 47305 | 316 | 1.403292 | 4.43440272 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|820693866|tpe|LN714486.1| | 572307 | g46709 | i0 | 96.875 | 0.455696202531646 | 32 | 1 | 10 | 0 | 25 | 56 | 1007453 | 1007422 | TPA_asm: Neospora caninum Liverpool, chromosome chrXI, complete genome | blastn | 144 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 6678965 | 6678965 | PRJNA1150539_S_NODE_2746_length_743_cov_3.934328_g2215_i0 | PRJNA1150539 | 2746 | 743 | 3.934328 | 29.23205704 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 959 | 0 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g2215 | i0 | 96.088 | 1117.08613728129 | 588 | 23 | 79 | 0 | 156 | 743 | 1914 | 1327 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 829995 | 959 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 9229662 | 9229662 | PRJNA1150539_S_NODE_78988_length_267_cov_2.340206_g78392_i0 | PRJNA1150539 | 78988 | 267 | 2.340206 | 6.24835002 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 453 | 5.73e-123 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g78392 | i0 | 97.048 | 1276.59176029963 | 271 | 4 | 100 | 1 | 1 | 267 | 1290 | 1560 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 340850 | 453 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 11240071 | 11240071 | PRJNA1150539_S_NODE_5649_length_524_cov_9.328160_g5060_i0 | PRJNA1150539 | 5649 | 524 | 9.32816 | 48.8795584 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 880 | 0 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g5060 | i0 | 96.947 | 1146.15839694656 | 524 | 16 | 100 | 0 | 1 | 524 | 552 | 29 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 600587 | 880 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 12515600 | 12515600 | PRJNA1150539_S_NODE_81750_length_263_cov_14.031579_g81154_i0 | PRJNA1150539 | 81750 | 263 | 14.031579 | 36.90305277 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|2785762273|ref|XM_067216043.1| | 5824 | g81154 | i0 | 96.875 | 4.01520912547528 | 32 | 1 | 12 | 0 | 144 | 175 | 3030 | 2999 | Plasmodium brasilianum uncharacterized protein (MKS88_002988), partial mRNA | blastn | 1056 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 12515624 | 12515624 | PRJNA1150539_S_NODE_8750_length_455_cov_4.010471_g8156_i0 | PRJNA1150539 | 8750 | 455 | 4.010471 | 18.24764305 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 606 | 7.509999999999996e-169 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g8156 | i0 | 90.632 | 1022.26153846154 | 459 | 39 | 100 | 3 | 1 | 455 | 87 | 545 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 465129 | 612 | 0.990196078431373 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 15603917 | 15603917 | PRJNA1150539_S_NODE_24733_length_367_cov_2.972789_g24137_i0 | PRJNA1150539 | 24733 | 367 | 2.972789 | 10.91013563 | Babesia bigemina | 5866 | SAR_Eukaryotes | SAR_Eukaryotes | 568 | 2.7999999999999995e-157 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g24137 | i0 | 94.55 | 1213.98910081744 | 367 | 20 | 100 | 0 | 1 | 367 | 379 | 13 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 445534 | 568 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 20702808 | 20702808 | PRJNA1150539_S_NODE_52537_length_307_cov_0.987179_g51941_i0 | PRJNA1150539 | 52537 | 307 | 0.987179 | 3.03063953 | Babesia bigemina | 5866 | SAR_Eukaryotes | SAR_Eukaryotes | 422 | 1.8999999999999996e-113 | NTclustered | gi|833494855|ref|XM_012915027.1| | 5866 | g51941 | i0 | 91.64 | 885.804560260586 | 311 | 16 | 98 | 4 | 1 | 302 | 396 | 87 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 271942 | 422 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 20703277 | 20703277 | PRJNA1150539_S_NODE_98557_length_245_cov_0.895349_g97961_i0 | PRJNA1150539 | 98557 | 245 | 0.895349 | 2.19360505 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|820699808|tpe|LN714499.1| | 432359 | g97961 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 10 | 37 | 5699983 | 5700010 | TPA_asm: Toxoplasma gondii VEG, chromosome chrIX, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 21977788 | 21977788 | PRJNA1150539_S_NODE_13518_length_412_cov_2.867257_g12923_i0 | PRJNA1150539 | 13518 | 412 | 2.867257 | 11.81309884 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 405 | 2.64e-108 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g12923 | i0 | 96.341 | 404.449029126214 | 246 | 9 | 60 | 0 | 1 | 246 | 827 | 582 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 166633 | 405 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 30028256 | 30028256 | PRJNA1150539_S_NODE_71291_length_278_cov_1.126829_g70695_i0 | PRJNA1150539 | 71291 | 278 | 1.126829 | 3.13258462 | root | 1 | Root_unresolved | Root_unresolved | 44.3 | 0.0158 | NR | XP_011133534.1 | 110365 | g70695 | i0 | 34.9 | 3.05395683453237 | 63 | 39 | 65.8 | 1 | 84 | 266 | 252 | 314 | XP_011133534.1 hypothetical protein GNI_182630 [Gregarina niphandrodes] | diamond | 849 | 44.3 | 1 | 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);;