contig_metadata
19 rows where bioproject = "PRJNA781196" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 759117 | 759117 | PRJNA781196_P_NODE_28201_length_328_cov_1.835294_g27824_i0 | PRJNA781196 | 28201 | 328 | 1.835294 | 6.01976432 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1084939551|ref|XM_018788273.1| | 647221 | g27824 | i0 | 100 | 5.76524390243902 | 30 | 0 | 9 | 0 | 252 | 281 | 778 | 749 | Plasmodium gaboni hypothetical protein partial mRNA | blastn | 1891 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 2035394 | 2035394 | PRJNA781196_P_NODE_43482_length_272_cov_1.000000_g43105_i0 | PRJNA781196 | 43482 | 272 | 1 | 2.72 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 2.48e-7 | NTclustered | gi|1620130862|ref|XM_028673722.1| | 5849 | g43105 | i0 | 93.617 | 0.408088235294118 | 47 | 1 | 17 | 2 | 54 | 99 | 1383 | 1428 | Plasmodium gallinaceum RNA polymerase II-associated protein 1, putative (PGAL8A_00492300), partial mRNA | blastn | 111 | 69.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 4587160 | 4587160 | PRJNA781196_P_NODE_11944_length_469_cov_3.537879_g11568_i0 | PRJNA781196 | 11944 | 469 | 3.537879 | 16.59265251 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 2.56e-49 | NTclustered | gi|66359883|ref|XM_627120.1| | 353152 | g11568 | i0 | 78.997 | 6.35820895522388 | 319 | 57 | 67 | 10 | 54 | 367 | 380 | 67 | Cryptosporidium parvum Iowa II histone H2A (cgd8_2170) mRNA, complete cds | blastn | 2982 | 209 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 6315272 | 6315272 | PRJNA781196_P_NODE_36725_length_293_cov_1.922727_g36348_i0 | PRJNA781196 | 36725 | 293 | 1.922727 | 5.63359011 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 1.13e-38 | NR | XP_067197041.1 | 515981 | g36348 | i0 | 81.3 | 8.31399317406143 | 80 | 15 | 81.9 | 0 | 245 | 6 | 1 | 80 | XP_067197041.1 uncharacterized protein FG386_000852 [Cryptosporidium ryanae] | diamond | 2436 | 143 | 0.993006993006993 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae | ||
| 12239270 | 12239270 | PRJNA781196_P_NODE_58010_length_248_cov_0.891429_g57633_i0 | PRJNA781196 | 58010 | 248 | 0.891429 | 2.21074392 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|915128576|ref|XM_013479404.1| | 5804 | g57633 | i0 | 100 | 0.362903225806452 | 30 | 0 | 12 | 0 | 95 | 124 | 2618 | 2589 | Eimeria maxima RNA-binding protein, putative partial mRNA | blastn | 90 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 14788355 | 14788355 | PRJNA781196_P_NODE_67372_length_242_cov_0.893491_g66995_i0 | PRJNA781196 | 67372 | 242 | 0.893491 | 2.16224822 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 6.9e-92 | NTclustered | gi|1843573164|ref|XM_034566431.1| | 5823 | g66995 | i0 | 99.479 | 3.96694214876033 | 192 | 1 | 79 | 0 | 3 | 194 | 195 | 4 | Plasmodium berghei ANKA U6 snRNA-associated Sm-like protein LSm2, putative (PBANKA_1235100), partial mRNA | blastn | 960 | 350 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 16061796 | 16061796 | PRJNA781196_P_NODE_37853_length_290_cov_1.009217_g37476_i0 | PRJNA781196 | 37853 | 290 | 1.009217 | 2.9267293 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 8.49e-29 | NR | OEH73979.1 | 88456 | g37476 | i0 | 68.8 | 0.827586206896552 | 80 | 24 | 82.8 | 1 | 241 | 2 | 218 | 296 | OEH73979.1 iron-sulfur subunit of succinate [Cyclospora cayetanensis] | diamond | 240 | 115 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 17337552 | 17337552 | PRJNA781196_P_NODE_39794_length_283_cov_4.209524_g39417_i0 | PRJNA781196 | 39794 | 283 | 4.209524 | 11.91295292 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.02e-26 | NR | XP_067802537.1 | 323732 | g39417 | i0 | 58.9 | 2.93639575971731 | 95 | 37 | 98.6 | 1 | 281 | 3 | 3 | 97 | XP_067802537.1 Ribosomal protein S25 [Babesia duncani] | diamond | 831 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 19885744 | 19885744 | PRJNA781196_P_NODE_11436_length_478_cov_3.320988_g11060_i0 | PRJNA781196 | 11436 | 478 | 3.320988 | 15.87432264 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 258 | 3.08e-82 | NR | XP_003881929.1 | 572307 | g11060 | i0 | 80.5 | 6.7907949790795 | 154 | 30 | 96.7 | 0 | 16 | 477 | 12 | 165 | XP_003881929.1 S-adenosylmethionine synthetase,related [Neospora caninum Liverpool] | diamond | 3246 | 259 | 0.996138996138996 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 21613564 | 21613564 | PRJNA781196_P_NODE_65277_length_243_cov_0.917647_g64900_i0 | PRJNA781196 | 65277 | 243 | 0.917647 | 2.22988221 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 8.629999999999999e-37 | NR | XP_003881929.1 | 572307 | g64900 | i0 | 82.9 | 24.8024691358025 | 76 | 13 | 93.8 | 0 | 228 | 1 | 12 | 87 | XP_003881929.1 S-adenosylmethionine synthetase,related [Neospora caninum Liverpool] | diamond | 6027 | 137 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 23711819 | 23711819 | PRJNA781196_P_NODE_14579_length_430_cov_2.532213_g14202_i0 | PRJNA781196 | 14579 | 430 | 2.532213 | 10.8885159 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 8.25e-59 | NTclustered | gi|401402052|ref|XM_003881109.1| | 572307 | g14202 | i0 | 78.307 | 63.2116279069767 | 378 | 78 | 87 | 4 | 1 | 376 | 3 | 378 | Neospora caninum Liverpool putative ubiquitin / ribosomal protein CEP52 fusion protein (NCLIV_042000), partial mRNA | blastn | 27181 | 241 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 23712152 | 23712152 | PRJNA781196_P_NODE_39419_length_285_cov_1.103774_g39042_i0 | PRJNA781196 | 39419 | 285 | 1.103774 | 3.1457559 | Plasmodium mackerrasae | 2138133 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.5099999999999996e-37 | NTclustered | gi|1372150144|gb|MF508315.1| | 2138133 | g39042 | i0 | 84.94 | 3.33684210526316 | 166 | 25 | 58 | 0 | 78 | 243 | 1 | 166 | Plasmodium mackerrasae isolate 1-26-11 putative 26S proteasome regulatory subunit 7 gene, partial cds | blastn | 951 | 169 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium mackerrasae | ||
| 24163059 | 24163059 | PRJNA781196_P_NODE_64819_length_243_cov_0.917647_g64442_i0 | PRJNA781196 | 64819 | 243 | 0.917647 | 2.22988221 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.71e-4 | NTclustered | gi|915009362|ref|XM_013395395.1| | 5801 | g64442 | i0 | 100 | 7.51851851851852 | 31 | 0 | 13 | 0 | 98 | 128 | 130 | 100 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 1827 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 27315950 | 27315950 | PRJNA781196_P_NODE_53943_length_251_cov_0.876404_g53566_i0 | PRJNA781196 | 53943 | 251 | 0.876404 | 2.19977404 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 2.95e-40 | NR | AET50562.1 | 5802 | g53566 | i0 | 76.8 | 6.8605577689243 | 82 | 19 | 98 | 0 | 251 | 6 | 78 | 159 | AET50562.1 hypothetical protein [Eimeria tenella] | diamond | 1722 | 140 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 27663288 | 27663288 | PRJNA781196_P_NODE_29764_length_321_cov_1.572581_g29387_i0 | PRJNA781196 | 29764 | 321 | 1.572581 | 5.04798501 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 3.78e-10 | NR | CDI74584.1 | 51316 | g29387 | i0 | 40 | 4.31775700934579 | 90 | 48 | 84.1 | 2 | 27 | 296 | 163 | 246 | CDI74584.1 thioredoxin, putative [Eimeria praecox] | diamond | 1386 | 67 | 0.994029850746269 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria praecox | ||
| 28862832 | 28862832 | PRJNA781196_P_NODE_64008_length_244_cov_0.912281_g63631_i0 | PRJNA781196 | 64008 | 244 | 0.912281 | 2.22596564 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 6.62e-7 | NR | XP_034422903.1 | 5823 | g63631 | i0 | 32.1 | 3.98360655737705 | 81 | 49 | 99.6 | 1 | 1 | 243 | 344 | 418 | XP_034422903.1 plasmepsin X, putative [Plasmodium berghei ANKA] | diamond | 972 | 56.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 29611077 | 29611077 | PRJNA781196_P_NODE_64950_length_243_cov_0.917647_g64573_i0 | PRJNA781196 | 64950 | 243 | 0.917647 | 2.22988221 | Theileria equi strain WA | 1537102 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00263 | NR | XP_004828991.1 | 1537102 | g64573 | i0 | 30.9 | 1 | 81 | 55 | 100 | 1 | 243 | 1 | 149 | 228 | XP_004828991.1 signal peptide-containing protein [Theileria equi strain WA] | diamond | 243 | 45.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 31706389 | 31706389 | PRJNA781196_P_NODE_59257_length_247_cov_0.896552_g58880_i0 | PRJNA781196 | 59257 | 247 | 0.896552 | 2.21448344 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0151 | NR | KOB87390.1 | 57267 | g58880 | i0 | 43.2 | 1.60323886639676 | 44 | 21 | 48.6 | 1 | 213 | 94 | 352 | 395 | KOB87390.1 hypothetical protein PFDG_03457 [Plasmodium falciparum Dd2] | diamond | 396 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 32117776 | 32117776 | PRJNA781196_P_NODE_26558_length_336_cov_1.779468_g26181_i0 | PRJNA781196 | 26558 | 336 | 1.779468 | 5.97901248 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 3.66e-15 | NR | XP_028533357.1 | 85471 | g26181 | i0 | 53.5 | 12.4732142857143 | 86 | 36 | 73.2 | 2 | 255 | 10 | 2187 | 2272 | XP_028533357.1 formin 1, putative [Plasmodium relictum] | diamond | 4191 | 81.6 | 0.996323529411765 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum |
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);;