contig_metadata
20 rows where bioproject = "PRJNA800090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2074343 | 2074343 | PRJNA800090_P_NODE_199002_length_212_cov_7.258741_g196817_i0 | PRJNA800090 | 199002 | 212 | 7.258741 | 15.38853092 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.019 | NTclustered | gi|916515633|ref|XM_013502263.1| | 44415 | g196817 | i0 | 100 | 0.132075471698113 | 28 | 0 | 13 | 0 | 77 | 104 | 277 | 250 | Eimeria mitis uncharacterized protein (EMH_0071680), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 3772429 | 3772429 | PRJNA800090_P_NODE_189983_length_229_cov_0.912500_g187798_i0 | PRJNA800090 | 189983 | 229 | 0.9125 | 2.089625 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.02 | NTclustered | gi|124015288|gb|EF158096.1| | 5833 | g187798 | i0 | 100 | 0.379912663755459 | 28 | 0 | 12 | 0 | 179 | 206 | 3162 | 3135 | Plasmodium falciparum erythrocyte membrane protein 1 (IT4_var54) gene, complete cds | blastn | 87 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 5048058 | 5048058 | PRJNA800090_P_NODE_102164_length_322_cov_1.142292_g99979_i0 | PRJNA800090 | 102164 | 322 | 1.142292 | 3.67818024 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 4.65e-60 | NTclustered | gi|17028074|gb|L40815.1|PFAHSP70 | 5821 | g99979 | i0 | 80.495 | 51.416149068323 | 323 | 59 | 99 | 4 | 2 | 322 | 1946 | 2266 | Plasmodium berghei heat shock protein 70 (hsp70) gene, complete cds | blastn | 16556 | 244 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 5048778 | 5048778 | PRJNA800090_P_NODE_182324_length_232_cov_0.883436_g180139_i0 | PRJNA800090 | 182324 | 232 | 0.883436 | 2.04957152 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 91.6 | 4.4e-14 | NTclustered | gi|833484291|ref|XM_012911757.1| | 5866 | g180139 | i0 | 98.077 | 10.5948275862069 | 52 | 1 | 22 | 0 | 58 | 109 | 228 | 279 | Babesia bigemina 60S ribosomal L22e protein, putative partial mRNA | blastn | 2458 | 91.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 5902935 | 5902935 | PRJNA800090_P_NODE_59665_length_451_cov_5.557592_g57481_i0 | PRJNA800090 | 59665 | 451 | 5.557592 | 25.06473992 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 2.470000000000001e-44 | NTclustered | gi|1620142820|ref|XM_028677298.1| | 85471 | g57481 | i0 | 82.648 | 33.8558758314856 | 219 | 36 | 48 | 2 | 1 | 218 | 7 | 224 | Plasmodium relictum ubiquitin-60S ribosomal protein L40, putative (PRELSG_1104600), partial mRNA | blastn | 15269 | 193 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 8449906 | 8449906 | PRJNA800090_P_NODE_124427_length_285_cov_4.157407_g122242_i0 | PRJNA800090 | 124427 | 285 | 4.157407 | 11.84860995 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 8.699999999999999e-62 | NTclustered | gi|1620122625|ref|XM_028672062.1| | 5849 | g122242 | i0 | 83.212 | 7.37543859649123 | 274 | 44 | 96 | 2 | 10 | 282 | 16 | 288 | Plasmodium gallinaceum calmodulin, putative (CAM), partial mRNA | blastn | 2102 | 250 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 10148610 | 10148610 | PRJNA800090_P_NODE_122708_length_288_cov_1.333333_g120523_i0 | PRJNA800090 | 122708 | 288 | 1.333333 | 3.83999904 | Haemosporida | 5819 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 2.39e-33 | NR | ETW57274.1 | 57270 | g120523 | i0 | 66 | 11.9166666666667 | 94 | 30 | 95.8 | 1 | 1 | 276 | 155 | 248 | ETW57274.1 hypothetical protein PFUGPA_00763 [Plasmodium falciparum Palo Alto/Uganda] | diamond | 3432 | 127 | 0.992125984251969 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 13551239 | 13551239 | PRJNA800090_P_NODE_159011_length_247_cov_3.269663_g156826_i0 | PRJNA800090 | 159011 | 247 | 3.269663 | 8.07606761 | Hepatozoon canis | 110120 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 9.68e-51 | NTclustered | gi|1584069862|gb|MH615006.1| | 110120 | g156826 | i0 | 88.268 | 73.7692307692308 | 179 | 19 | 72 | 1 | 12 | 190 | 4487 | 4311 | Hepatozoon canis isolate 9992 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 18221 | 213 | 1 | Eukaryota | Sar | Apicomplexa | Hepatozoidae | Hepatozoon | Hepatozoon canis | ||||
| 17376044 | 17376044 | PRJNA800090_P_NODE_159414_length_247_cov_1.617978_g157229_i0 | PRJNA800090 | 159414 | 247 | 1.617978 | 3.99640566 | Plasmodium vivax | 5855 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|156100752|ref|XM_001616020.1| | 5855 | g157229 | i0 | 100 | 0.11336032388664 | 28 | 0 | 11 | 0 | 195 | 222 | 7668 | 7641 | Plasmodium vivax hypothetical protein, conserved (PVX_113390), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 18649625 | 18649625 | PRJNA800090_P_NODE_180635_length_233_cov_0.878049_g178450_i0 | PRJNA800090 | 180635 | 233 | 0.878049 | 2.04585417 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.46e-5 | NTclustered | gi|915122834|ref|XM_013477227.1| | 5804 | g178450 | i0 | 97.222 | 2.90987124463519 | 36 | 1 | 15 | 0 | 167 | 202 | 4495 | 4460 | Eimeria maxima zinc finger (C3HC4 RING finger) protein, putative partial mRNA | blastn | 678 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 22474611 | 22474611 | PRJNA800090_P_NODE_152238_length_254_cov_1.459459_g150053_i0 | PRJNA800090 | 152238 | 254 | 1.459459 | 3.70702586 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 7.32e-33 | NR | XP_029219060.1 | 94643 | g150053 | i0 | 81.1 | 11.244094488189 | 74 | 14 | 87.4 | 0 | 31 | 252 | 8 | 81 | XP_029219060.1 ribosomal protein RPL3 [Besnoitia besnoiti] | diamond | 2856 | 127 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 23749373 | 23749373 | PRJNA800090_P_NODE_116759_length_297_cov_1.171053_g114574_i0 | PRJNA800090 | 116759 | 297 | 1.171053 | 3.47802741 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 6.859999999999999e-48 | NR | XP_011128572.1 | 110365 | g114574 | i0 | 78.6 | 30.6363636363636 | 98 | 21 | 99 | 0 | 3 | 296 | 38 | 135 | XP_011128572.1 putative serine/threonine-protein kinase/mitogen-activated protein kinase [Gregarina niphandrodes] | diamond | 9099 | 168 | 0.994047619047619 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 23752660 | 23752660 | PRJNA800090_P_NODE_87079_length_355_cov_1.020979_g84894_i0 | PRJNA800090 | 87079 | 355 | 1.020979 | 3.62447545 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 147 | 1.5e-30 | NTclustered | gi|1620152429|ref|XM_028679675.1| | 85471 | g84894 | i0 | 78.448 | 2.01408450704225 | 232 | 44 | 65 | 6 | 1 | 229 | 10 | 238 | Plasmodium relictum 40S ribosomal protein S17, putative (PRELSG_1457800), partial mRNA | blastn | 715 | 147 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 23753441 | 23753441 | PRJNA800090_S_NODE_30819_length_234_cov_0.872727_g30707_i0 | PRJNA800090 | 30819 | 234 | 0.872727 | 2.04218118 | Plasmodium vivax | 5855 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.021 | NTclustered | gi|156100752|ref|XM_001616020.1| | 5855 | g30707 | i0 | 100 | 0.11965811965812 | 28 | 0 | 12 | 0 | 26 | 53 | 7641 | 7668 | Plasmodium vivax hypothetical protein, conserved (PVX_113390), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 28199828 | 28199828 | PRJNA800090_P_NODE_151166_length_255_cov_1.456989_g148981_i0 | PRJNA800090 | 151166 | 255 | 1.456989 | 3.71532195 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 94.4 | 2.01e-20 | NR | XP_028861612.1 | 5858 | g148981 | i0 | 54.9 | 6.74117647058824 | 82 | 37 | 96.5 | 0 | 250 | 5 | 1 | 82 | XP_028861612.1 AP-4 complex subunit mu, putative [Plasmodium malariae] | diamond | 1719 | 94.7 | 0.996832101372756 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium malariae | ||
| 29052668 | 29052668 | PRJNA800090_P_NODE_42628_length_561_cov_2.534553_g40461_i0 | PRJNA800090 | 42628 | 561 | 2.534553 | 14.21884233 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 4.42e-72 | NR | XP_013233901.1 | 5802 | g40461 | i0 | 65.9 | 7.5668449197861 | 179 | 60 | 95.7 | 1 | 538 | 2 | 1 | 178 | XP_013233901.1 40S ribosomal protein S9, putative [Eimeria tenella] | diamond | 4245 | 228 | 0.991228070175439 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 29210572 | 29210572 | PRJNA800090_P_NODE_169069_length_238_cov_2.159763_g166884_i0 | PRJNA800090 | 169069 | 238 | 2.159763 | 5.14023594 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 3.66e-10 | NR | XP_009690801.1 | 869250 | g166884 | i0 | 44.9 | 1.85294117647059 | 78 | 40 | 98.3 | 2 | 236 | 3 | 23 | 97 | XP_009690801.1 60S ribosomal protein L18 [Theileria orientalis strain Shintoku] | diamond | 441 | 63.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 30031506 | 30031506 | PRJNA800090_P_NODE_98531_length_329_cov_1.123077_g96346_i0 | PRJNA800090 | 98531 | 329 | 1.123077 | 3.69492333 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 1.7899999999999995e-31 | NR | KAF8820025.1 | 476202 | g96346 | i0 | 56.1 | 3.87537993920973 | 107 | 43 | 96.7 | 3 | 325 | 8 | 197 | 300 | KAF8820025.1 putative glyoxalase I [Cardiosporidium cionae] | diamond | 1275 | 124 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 31318001 | 31318001 | PRJNA800090_P_NODE_174095_length_235_cov_0.879518_g171910_i0 | PRJNA800090 | 174095 | 235 | 0.879518 | 2.0668673 | Babesia bigemina | 5866 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 1.18e-14 | NR | XP_012769770.1 | 5866 | g171910 | i0 | 52.9 | 0.868085106382979 | 68 | 32 | 86.8 | 0 | 5 | 208 | 6 | 73 | XP_012769770.1 hypothetical protein, conserved [Babesia bigemina] | diamond | 204 | 76.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 32898067 | 32898067 | PRJNA800090_P_NODE_104980_length_316_cov_2.554656_g102795_i0 | PRJNA800090 | 104980 | 316 | 2.554656 | 8.07271296 | Plasmodium chabaudi chabaudi | 31271 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 1.66e-24 | NR | SCM25146.1 | 31271 | g102795 | i0 | 53.4 | 0.977848101265823 | 103 | 45 | 94.9 | 2 | 302 | 3 | 1 | 103 | SCM25146.1 Ribosomal Proteins L2, RNA binding domain/Ribosomal Proteins L2, C-terminal domain containing protein, putative [Plasmodium chabaudi chabaudi] | diamond | 309 | 100 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi |
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);;