contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA758398" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6308452 | 6308452 | PRJNA758398_S_NODE_46145_length_165_cov_0.879310_g46004_i0 | PRJNA758398 | 46145 | 165 | 0.87931 | 1.4508615 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.001 | NTclustered | gi|2785758969|ref|XM_067214238.1| | 5824 | g46004 | i0 | 100 | 1.93939393939394 | 30 | 0 | 18 | 0 | 136 | 165 | 16185 | 16156 | Plasmodium brasilianum HECT-like E3 ubiquitin ligase (MKS88_001321), partial mRNA | blastn | 320 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 7118724 | 7118724 | PRJNA758398_S_NODE_4586_length_443_cov_2.375635_g4445_i0 | PRJNA758398 | 4586 | 443 | 2.375635 | 10.52406305 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 8.52e-59 | NTclustered | gi|82596053|ref|XM_721011.1| | 5861 | g4445 | i0 | 78.228 | 4.627539503386 | 395 | 72 | 88 | 13 | 56 | 443 | 993 | 606 | Plasmodium yoelii 26s protease regulatory subunit 6a (PY17X_0919400), partial mRNA | blastn | 2050 | 241 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 7582378 | 7582378 | PRJNA758398_S_NODE_7446_length_351_cov_4.821192_g7305_i0 | PRJNA758398 | 7446 | 351 | 4.821192 | 16.92238392 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.033 | NTclustered | gi|915132969|ref|XM_013480396.1| | 5804 | g7305 | i0 | 100 | 1.20797720797721 | 28 | 0 | 8 | 0 | 87 | 114 | 864 | 891 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 424 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 9668322 | 9668322 | PRJNA758398_S_NODE_36208_length_179_cov_1.176923_g36067_i0 | PRJNA758398 | 36208 | 179 | 1.176923 | 2.10669217 | Plasmodium brasilianum | 5824 | SAR_Eukaryotes | SAR_Eukaryotes | 76.8 | 9e-10 | NTclustered | gi|2785757340|ref|XM_067215922.1| | 5824 | g36067 | i0 | 89.831 | 3.16759776536313 | 59 | 6 | 57 | 0 | 121 | 179 | 1210 | 1268 | Plasmodium brasilianum 50S ribosomal protein L1 (MKS88_000484), partial mRNA | blastn | 567 | 76.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 10944100 | 10944100 | PRJNA758398_S_NODE_51749_length_162_cov_0.902655_g51608_i0 | PRJNA758398 | 51749 | 162 | 0.902655 | 1.4623011 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 1.33e-12 | NTclustered | gi|1673117903|ref|XM_029364352.1| | 94643 | g51608 | i0 | 77.241 | 3.16049382716049 | 145 | 33 | 90 | 0 | 1 | 145 | 524 | 668 | Besnoitia besnoiti ribosomal protein RPL3 (BESB_059380), partial mRNA | blastn | 512 | 86.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 10944113 | 10944113 | PRJNA758398_S_NODE_53049_length_161_cov_1.723214_g52908_i0 | PRJNA758398 | 53049 | 161 | 1.723214 | 2.77437454 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.013 | NTclustered | gi|915124746|ref|XM_013478183.1| | 5804 | g52908 | i0 | 100 | 0.173913043478261 | 28 | 0 | 17 | 0 | 81 | 108 | 1226 | 1199 | Eimeria maxima elongation factor Tu GTP-binding domain-containing protein, putative partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 12219625 | 12219625 | PRJNA758398_S_NODE_510_length_1133_cov_7.559963_g456_i0 | PRJNA758398 | 510 | 1133 | 7.559963 | 85.65438079 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 6.9e-4 | NTclustered | gi|1931713688|ref|XM_008628303.2| | 54757 | g456 | i0 | 100 | 2.75375110326567 | 32 | 0 | 3 | 0 | 1101 | 1132 | 1760 | 1729 | Plasmodium vinckei vinckei GAF domain-related protein, putative (PVVCY_0300930), partial mRNA | blastn | 3120 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 13493669 | 13493669 | PRJNA758398_S_NODE_43031_length_167_cov_0.864407_g42890_i0 | PRJNA758398 | 43031 | 167 | 0.864407 | 1.44355969 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 3.76e-28 | NTclustered | gi|1931716463|ref|XM_037634615.1| | 54757 | g42890 | i0 | 81.548 | 26.9760479041916 | 168 | 29 | 100 | 2 | 1 | 167 | 761 | 927 | Plasmodium vinckei vinckei 26S protease regulatory subunit 4, putative (PVVCY_1200740), partial mRNA | blastn | 4505 | 137 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 14768909 | 14768909 | PRJNA758398_S_NODE_53352_length_161_cov_1.169643_g53211_i0 | PRJNA758398 | 53352 | 161 | 1.169643 | 1.88312523 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 6.18e-6 | NTclustered | gi|1843575349|ref|XM_034567642.1| | 5823 | g53211 | i0 | 81.25 | 0.496894409937888 | 80 | 14 | 49 | 1 | 83 | 161 | 255 | 176 | Plasmodium berghei ANKA dynein light chain 1, putative (PBANKA_1429400), partial mRNA | blastn | 80 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 17318159 | 17318159 | PRJNA758398_S_NODE_45414_length_165_cov_1.758621_g45273_i0 | PRJNA758398 | 45414 | 165 | 1.758621 | 2.90172465 | Plasmodium gonderi | 77519 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 4.93e-7 | NTclustered | gi|1620953318|ref|XM_028688720.1| | 77519 | g45273 | i0 | 88.889 | 0.327272727272727 | 54 | 6 | 33 | 0 | 102 | 155 | 697 | 750 | Plasmodium gonderi ornithine aminotransferase (PGO_113860), partial mRNA | blastn | 54 | 67.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gonderi | ||
| 19866586 | 19866586 | PRJNA758398_S_NODE_27396_length_201_cov_1.342105_g27255_i0 | PRJNA758398 | 27396 | 201 | 1.342105 | 2.69763105 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.3e-33 | NTclustered | gi|209880180|ref|XM_002141494.1| | 441375 | g27255 | i0 | 80.597 | 5.64676616915423 | 201 | 39 | 100 | 0 | 1 | 201 | 4938 | 4738 | Cryptosporidium muris RN66 Mov34/MPN/PAD-1 family protein (CMU_000510), partial mRNA | blastn | 1135 | 156 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 19866735 | 19866735 | PRJNA758398_S_NODE_38616_length_174_cov_1.064000_g38475_i0 | PRJNA758398 | 38616 | 174 | 1.064 | 1.85136 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|1620113398|ref|XM_028675070.1| | 5849 | g38475 | i0 | 94.444 | 0.206896551724138 | 36 | 0 | 20 | 2 | 47 | 81 | 615 | 581 | Plasmodium gallinaceum conserved Plasmodium protein, unknown function (PGAL8A_00152600), partial mRNA | blastn | 36 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum |
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);;