contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA756891" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008057 | 2008057 | PRJNA756891_P_NODE_5162_length_373_cov_1.000000_g5093_i0 | PRJNA756891 | 5162 | 373 | 1 | 3.73 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|1620174044|ref|XM_028682437.1| | 880535 | g5093 | i0 | 100 | 0.0804289544235925 | 30 | 0 | 8 | 0 | 157 | 186 | 994 | 965 | Plasmodium sp. gorilla clade G2 conserved Plasmodium protein, unknown function (PADL01_1035500), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 7110746 | 7110746 | PRJNA756891_P_NODE_7406_length_317_cov_2.274590_g7337_i0 | PRJNA756891 | 7406 | 317 | 2.27459 | 7.2104503 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 6.38e-4 | NTclustered | gi|1145258134|ref|XM_012906805.2| | 5854 | g7337 | i0 | 88.235 | 0.249211356466877 | 51 | 3 | 16 | 2 | 161 | 211 | 4380 | 4333 | Plasmodium reichenowi hypothetical protein partial mRNA | blastn | 79 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 14760974 | 14760974 | PRJNA756891_P_NODE_6392_length_338_cov_1.403774_g6323_i0 | PRJNA756891 | 6392 | 338 | 1.403774 | 4.74475612 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 3.8199999999999995e-56 | NTclustered | gi|1620150562|ref|XM_028678648.1| | 85471 | g6323 | i0 | 79.635 | 54.4940828402367 | 329 | 61 | 96 | 6 | 2 | 327 | 782 | 457 | Plasmodium relictum polyubiquitin, putative (PRELSG_1312500), partial mRNA | blastn | 18419 | 231 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 15230807 | 15230807 | PRJNA756891_P_NODE_9232_length_286_cov_1.920188_g9163_i0 | PRJNA756891 | 9232 | 286 | 1.920188 | 5.49173768 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.68e-4 | NTclustered | gi|1145258288|ref|XM_012906887.2| | 5854 | g9163 | i0 | 94.595 | 1.64685314685315 | 37 | 2 | 13 | 0 | 105 | 141 | 646 | 682 | Plasmodium reichenowi hypothetical protein partial mRNA | blastn | 471 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 19859047 | 19859047 | PRJNA756891_P_NODE_2236_length_557_cov_1.681818_g2168_i0 | PRJNA756891 | 2236 | 557 | 1.681818 | 9.36772626 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.004 | NTclustered | gi|82540450|ref|XM_719449.1| | 5861 | g2168 | i0 | 96.97 | 0.059245960502693 | 33 | 1 | 6 | 0 | 185 | 217 | 496 | 464 | Plasmodium yoelii PUB domain-containing protein, putative (PY17X_1426000), partial mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 19859075 | 19859075 | PRJNA756891_P_NODE_7156_length_322_cov_1.236948_g7087_i0 | PRJNA756891 | 7156 | 322 | 1.236948 | 3.98297256 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|2795620672|ref|XM_068064366.1| | 483139 | g7087 | i0 | 100 | 5.40062111801242 | 29 | 0 | 9 | 0 | 62 | 90 | 484 | 456 | Cystoisospora suis spc97 spc98 family protein (CSUI_004173), mRNA | blastn | 1739 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 21604435 | 21604435 | PRJNA756891_P_NODE_6817_length_329_cov_0.863281_g6748_i0 | PRJNA756891 | 6817 | 329 | 0.863281 | 2.84019449 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.009 | NTclustered | gi|296004811|ref|XM_002808712.1| | 36329 | g6748 | i0 | 100 | 0.279635258358663 | 29 | 0 | 9 | 0 | 137 | 165 | 3459 | 3431 | Plasmodium falciparum 3D7 importin-7, putative (PF3D7_0706000), partial mRNA | blastn | 92 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum |
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);;