contig_metadata
6 rows where bioproject = "PRJNA1159911", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2313155 | 2313155 | PRJNA1159911_P_NODE_101442_length_241_cov_0.916667_g100900_i0 | PRJNA1159911 | 101442 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.3e-4 | NTclustered | gi|1145256367|ref|XM_012905716.2| | 5854 | g100900 | i0 | 97.143 | 6.29460580912863 | 35 | 1 | 15 | 0 | 158 | 192 | 773 | 739 | Plasmodium reichenowi SECIS-binding protein 2, putative partial mRNA | blastn | 1517 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 2859297 | 2859297 | PRJNA1159911_P_NODE_76263_length_270_cov_1.472081_g75721_i0 | PRJNA1159911 | 76263 | 270 | 1.472081 | 3.9746187 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.28e-36 | NR | BAN65408.1 | 5865 | g75721 | i0 | 73.6 | 15.4777777777778 | 87 | 23 | 96.7 | 0 | 2 | 262 | 3 | 89 | BAN65408.1 40S ribosomal protein S5, putative [Babesia bovis] | diamond | 4179 | 130 | 0.992307692307692 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 24533803 | 24533803 | PRJNA1159911_P_NODE_43700_length_379_cov_1.228758_g43158_i0 | PRJNA1159911 | 43700 | 379 | 1.228758 | 4.65699282 | Plasmodium vivax | 5855 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 4.64e-6 | NTclustered | gi|156102560|ref|XM_001616923.1| | 5855 | g43158 | i0 | 100 | 1.07915567282322 | 35 | 0 | 9 | 0 | 236 | 270 | 422 | 388 | Plasmodium vivax hypothetical protein, conserved (PVX_122050), partial mRNA | blastn | 409 | 65.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 28986311 | 28986311 | PRJNA1159911_P_NODE_42468_length_386_cov_1.805112_g41926_i0 | PRJNA1159911 | 42468 | 386 | 1.805112 | 6.96773232 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 1.08e-18 | NR | XP_013229976.1 | 5802 | g41926 | i0 | 64.5 | 10.7487046632124 | 62 | 22 | 48.2 | 0 | 385 | 200 | 44 | 105 | XP_013229976.1 60S ribosomal protein L31, putative [Eimeria tenella] | diamond | 4149 | 86.3 | 0.995365005793743 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 30514312 | 30514312 | PRJNA1159911_P_NODE_69933_length_284_cov_1.146919_g69391_i0 | PRJNA1159911 | 69933 | 284 | 1.146919 | 3.2572499600000002 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 1.09e-4 | NR | UKK02333.1 | 68886 | g69391 | i0 | 54.1 | 0.390845070422535 | 37 | 17 | 39.1 | 0 | 284 | 174 | 172 | 208 | UKK02333.1 60S ribosomal protein L10 [Theileria orientalis] | diamond | 111 | 50.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 32821608 | 32821608 | PRJNA1159911_P_NODE_92520_length_247_cov_0.885057_g91978_i0 | PRJNA1159911 | 92520 | 247 | 0.885057 | 2.18609079 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 2.3e-9 | NR | CAL7860154.1 | 1344799 | g91978 | i0 | 54.8 | 0.510121457489879 | 42 | 19 | 51 | 0 | 126 | 1 | 136 | 177 | CAL7860154.1 unnamed protein product [Sarcocystis calchasi] | diamond | 126 | 63.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi |
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);;