contig_metadata
8 rows where bioproject = "PRJNA753704", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12210570 | 12210570 | PRJNA753704_P_NODE_24690_length_250_cov_1.322034_g24329_i0 | PRJNA753704 | 24690 | 250 | 1.322034 | 3.305085 | Plasmodium gonderi | 77519 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 3.63e-30 | NTclustered | gi|1620954688|ref|XM_028689405.1| | 77519 | g24329 | i0 | 79.147 | 2.44 | 211 | 42 | 84 | 2 | 2 | 211 | 474 | 265 | Plasmodium gonderi 40S ribosomal protein S5 (PGO_126150), partial mRNA | blastn | 610 | 145 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gonderi | ||
| 14759896 | 14759896 | PRJNA753704_P_NODE_15432_length_305_cov_2.400862_g15071_i0 | PRJNA753704 | 15432 | 305 | 2.400862 | 7.3226291 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 3.43e-51 | NTclustered | gi|1620184857|ref|XM_028680586.1| | 880535 | g15071 | i0 | 79.344 | 15.1081967213115 | 305 | 63 | 100 | 0 | 1 | 305 | 669 | 365 | Plasmodium sp. gorilla clade G2 serine/threonine protein phosphatase PP1, putative (PADL01_0035300), partial mRNA | blastn | 4608 | 215 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 17779766 | 17779766 | PRJNA753704_P_NODE_22074_length_260_cov_1.668449_g21713_i0 | PRJNA753704 | 22074 | 260 | 1.668449 | 4.3379674 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|915002776|ref|XM_013393443.1| | 5801 | g21713 | i0 | 100 | 2.63076923076923 | 30 | 0 | 12 | 0 | 1 | 30 | 20019 | 19990 | Eimeria acervulina UBA/TS-N domain-containing protein, putative partial mRNA | blastn | 684 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 19858220 | 19858220 | PRJNA753704_P_NODE_7076_length_435_cov_24.511050_g6715_i0 | PRJNA753704 | 7076 | 435 | 24.51105 | 106.6230675 | uncultured Eimeriidae | 404735 | SAR_Eukaryotes | SAR_Eukaryotes | 776 | 0 | NTclustered | gi|166083980|gb|EF024503.1| | 404735 | g6715 | i0 | 98.851 | 70.8091954022989 | 435 | 5 | 100 | 0 | 1 | 435 | 661 | 1095 | Eimeriidae environmental sample clone Elev_18S_807 18S ribosomal RNA gene, partial sequence | blastn | 30802 | 776 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 22879704 | 22879704 | PRJNA753704_P_NODE_7778_length_417_cov_2.997093_g7417_i0 | PRJNA753704 | 7778 | 417 | 2.997093 | 12.49787781 | Eimeria | 5800 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|915125310|ref|XM_013478465.1| | 5804 | g7417 | i0 | 92.5 | 0.522781774580336 | 40 | 2 | 10 | 1 | 246 | 285 | 909 | 871 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 218 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 24957559 | 24957559 | PRJNA753704_P_NODE_18440_length_282_cov_0.928230_g18079_i0 | PRJNA753704 | 18440 | 282 | 0.92823 | 2.6176086 | Plasmodium malariae | 5858 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1624462269|ref|XM_029004567.1| | 5858 | g18079 | i0 | 100 | 0.106382978723404 | 30 | 0 | 11 | 0 | 103 | 132 | 1230 | 1201 | Plasmodium malariae conserved Plasmodium protein, unknown function (PmUG01_08039700), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium malariae | ||
| 24957618 | 24957618 | PRJNA753704_P_NODE_23960_length_252_cov_0.871508_g23599_i0 | PRJNA753704 | 23960 | 252 | 0.871508 | 2.19620016 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 5.7999999999999984e-68 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g23599 | i0 | 86.111 | 1.96031746031746 | 252 | 33 | 100 | 2 | 1 | 252 | 80739 | 80490 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 494 | 270 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 32875363 | 32875363 | PRJNA753704_P_NODE_11120_length_355_cov_1.170213_g10759_i0 | PRJNA753704 | 11120 | 355 | 1.170213 | 4.15425615 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 2.09e-46 | NR | AFJ45055.1 | 5874 | g10759 | i0 | 64.7 | 20.712676056338 | 116 | 41 | 98 | 0 | 2 | 349 | 2 | 117 | AFJ45055.1 ribosomal protein S8, partial [Theileria annulata] | diamond | 7353 | 157 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata |
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);;