contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA763243" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020163 | 2020163 | PRJNA763243_P_NODE_8022_length_518_cov_2.644944_g7681_i0 | PRJNA763243 | 8022 | 518 | 2.644944 | 13.70080992 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 1.22e-102 | NTclustered | gi|1843568304|ref|XM_034563737.1| | 5823 | g7681 | i0 | 85.052 | 98.6602316602317 | 388 | 49 | 75 | 6 | 132 | 518 | 1 | 380 | Plasmodium berghei ANKA polyubiquitin, putative (PBANKA_0610300), partial mRNA | blastn | 51106 | 387 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 3294782 | 3294782 | PRJNA763243_P_NODE_49303_length_256_cov_1.071038_g48957_i0 | PRJNA763243 | 49303 | 256 | 1.071038 | 2.74185728 | Cryptosporidium bovis | 310047 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|2787666010|ref|XM_067327603.1| | 310047 | g48957 | i0 | 92.308 | 0.265625 | 39 | 3 | 15 | 0 | 146 | 184 | 823 | 861 | Cryptosporidium bovis uncharacterized protein (FG379_002000), partial mRNA | blastn | 68 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis | ||
| 5847482 | 5847482 | PRJNA763243_P_NODE_6705_length_557_cov_9.803719_g6369_i0 | PRJNA763243 | 6705 | 557 | 9.803719 | 54.60671483 | Cystoisospora felis | 482539 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 1.88e-36 | NTclustered | gi|3323386|gb|U85705.1|IFU85705 | 482539 | g6369 | i0 | 92.982 | 20.4631956912029 | 114 | 8 | 20 | 0 | 41 | 154 | 2037 | 1924 | Isospora felis 28S large subunit ribosomal RNA gene, complete sequence | blastn | 11398 | 167 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora felis | ||
| 9672297 | 9672297 | PRJNA763243_P_NODE_64728_length_239_cov_2.126506_g64382_i0 | PRJNA763243 | 64728 | 239 | 2.126506 | 5.08234934 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.021 | NTclustered | gi|1620172169|ref|XM_028682118.1| | 880535 | g64382 | i0 | 92.308 | 0.163179916317992 | 39 | 0 | 16 | 2 | 7 | 44 | 9249 | 9213 | Plasmodium sp. gorilla clade G2 conserved Plasmodium protein, unknown function (PADL01_1006600), partial mRNA | blastn | 39 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 12684889 | 12684889 | PRJNA763243_P_NODE_35730_length_288_cov_4.451163_g35384_i0 | PRJNA763243 | 35730 | 288 | 4.451163 | 12.81934944 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 9.51e-7 | NTclustered | gi|527046689|tpe|HG323591.1| | 5807 | g35384 | i0 | 93.333 | 0.3125 | 45 | 3 | 16 | 0 | 176 | 220 | 156 | 200 | TPA: Cryptosporidium parvum SRP RNA for signal recognition particle RNA | blastn | 90 | 67.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 13497086 | 13497086 | PRJNA763243_P_NODE_43011_length_269_cov_19.755102_g42665_i0 | PRJNA763243 | 43011 | 269 | 19.755102 | 53.14122438 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.3e-4 | NTclustered | gi|820698945|tpe|LN714498.1| | 432359 | g42665 | i0 | 85.714 | 1.51301115241636 | 56 | 6 | 20 | 2 | 54 | 108 | 2293519 | 2293465 | TPA_asm: Toxoplasma gondii VEG, chromosome chrVIII, complete genome | blastn | 407 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 17320933 | 17320933 | PRJNA763243_P_NODE_11334_length_449_cov_3.050532_g10991_i0 | PRJNA763243 | 11334 | 449 | 3.050532 | 13.69688868 | Babesia microti | 5868 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.18e-17 | NTclustered | gi|1206245954|ref|XR_002459985.1| | 1133968 | g10991 | i0 | 83.784 | 17.6503340757238 | 111 | 16 | 24 | 2 | 192 | 301 | 3504 | 3613 | Babesia microti strain RI 28S ribosomal RNA rRNA | blastn | 7925 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 21607402 | 21607402 | PRJNA763243_P_NODE_39337_length_278_cov_10.526829_g38991_i0 | PRJNA763243 | 39337 | 278 | 10.526829 | 29.26458462 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.5e-4 | NTclustered | gi|527046684|tpe|HG323586.1| | 5833 | g38991 | i0 | 100 | 1.40647482014388 | 31 | 0 | 11 | 0 | 181 | 211 | 159 | 189 | TPA: Plasmodium falciparum SRP RNA for signal recognition particle RNA | blastn | 391 | 58.4 | 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);;