contig_metadata
21 rows where bioproject = "PRJNA541476", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3059457 | 3059457 | PRJNA541476_P_NODE_20083_length_282_cov_0.861244_g19877_i0 | PRJNA541476 | 20083 | 282 | 0.861244 | 2.42870808 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 5.93e-36 | NR | XP_067918035.1 | 483139 | g19877 | i0 | 67 | 14 | 94 | 31 | 100 | 0 | 282 | 1 | 6 | 99 | XP_067918035.1 p-loop containing nucleoside triphosphate hydrolase protein [Cystoisospora suis] | diamond | 3948 | 139 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 9436960 | 9436960 | PRJNA541476_P_NODE_25208_length_262_cov_1.634921_g25002_i0 | PRJNA541476 | 25208 | 262 | 1.634921 | 4.28349302 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.97e-5 | NTclustered | gi|82705688|ref|XM_721979.1| | 5861 | g25002 | i0 | 97.222 | 1.51908396946565 | 36 | 1 | 14 | 0 | 227 | 262 | 1172 | 1137 | Plasmodium yoelii conserved Plasmodium protein, unknown function (PY17X_0912100), partial mRNA | blastn | 398 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 10712569 | 10712569 | PRJNA541476_P_NODE_1529_length_960_cov_3.632469_g1381_i0 | PRJNA541476 | 1529 | 960 | 3.632469 | 34.8717024 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.027 | NTclustered | gi|916505125|ref|XM_013497709.1| | 44415 | g1381 | i0 | 96.875 | 0.0333333333333333 | 32 | 1 | 3 | 0 | 316 | 347 | 820 | 851 | Eimeria mitis uncharacterized protein (EMH_0059720), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 11987575 | 11987575 | PRJNA541476_P_NODE_29530_length_251_cov_1.443820_g29324_i0 | PRJNA541476 | 29530 | 251 | 1.44382 | 3.6239882 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.28e-49 | NTclustered | gi|1084892469|ref|XM_018787044.1| | 647221 | g29324 | i0 | 82.041 | 32.808764940239 | 245 | 44 | 98 | 0 | 4 | 248 | 505 | 749 | Plasmodium gaboni putative 26S protease regulatory subunit 8 partial mRNA | blastn | 8235 | 209 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 13263144 | 13263144 | PRJNA541476_P_NODE_9811_length_364_cov_1.549828_g9605_i0 | PRJNA541476 | 9811 | 364 | 1.549828 | 5.64137392 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.68e-36 | NR | XP_029217377.1 | 94643 | g9605 | i0 | 55.8 | 0.989010989010989 | 120 | 53 | 98.9 | 0 | 362 | 3 | 189 | 308 | XP_029217377.1 putative adenylosuccinate synthetase [Besnoitia besnoiti] | diamond | 360 | 139 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 14537192 | 14537192 | PRJNA541476_P_NODE_12452_length_331_cov_1.732558_g12246_i0 | PRJNA541476 | 12452 | 331 | 1.732558 | 5.73476698 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|916498997|ref|XM_013494864.1| | 44415 | g12246 | i0 | 100 | 8.52567975830816 | 30 | 0 | 9 | 0 | 280 | 309 | 432 | 461 | Eimeria mitis uncharacterized protein (EMH_0034390), partial mRNA | blastn | 2822 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 14537691 | 14537691 | PRJNA541476_P_NODE_32132_length_249_cov_0.880682_g31926_i0 | PRJNA541476 | 32132 | 249 | 0.880682 | 2.19289818 | Cryptosporidium muris | 5808 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|209877626|ref|XM_002140219.1| | 441375 | g31926 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 50 | 77 | 366 | 393 | Cryptosporidium muris RN66 uncharacterized protein (CMU_016560), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 17086140 | 17086140 | PRJNA541476_P_NODE_23134_length_269_cov_3.943878_g22928_i0 | PRJNA541476 | 23134 | 269 | 3.943878 | 10.60903182 | Plasmodium brasilianum | 5824 | SAR_Eukaryotes | SAR_Eukaryotes | 89.8 | 1.88e-13 | NTclustered | gi|2785757340|ref|XM_067215922.1| | 5824 | g22928 | i0 | 83.505 | 1.44981412639405 | 97 | 15 | 36 | 1 | 15 | 111 | 1208 | 1303 | Plasmodium brasilianum 50S ribosomal protein L1 (MKS88_000484), partial mRNA | blastn | 390 | 89.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 17696508 | 17696508 | PRJNA541476_P_NODE_6394_length_447_cov_1.248663_g6191_i0 | PRJNA541476 | 6394 | 447 | 1.248663 | 5.58152361 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.001 | NTclustered | gi|2785763772|ref|XM_067216866.1| | 5824 | g6191 | i0 | 97.143 | 1.98434004474273 | 35 | 0 | 8 | 1 | 349 | 382 | 2231 | 2197 | Plasmodium brasilianum uncharacterized protein (MKS88_003745), partial mRNA | blastn | 887 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 24735144 | 24735144 | PRJNA541476_P_NODE_40880_length_237_cov_4.908537_g40674_i0 | PRJNA541476 | 40880 | 237 | 4.908537 | 11.63323269 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 5.14e-27 | NR | XP_003881363.1 | 572307 | g40674 | i0 | 65.8 | 1.9620253164557 | 76 | 26 | 96.2 | 0 | 6 | 233 | 360 | 435 | XP_003881363.1 hypothetical protein NCLIV_043950 [Neospora caninum Liverpool] | diamond | 465 | 112 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 27377509 | 27377509 | PRJNA541476_P_NODE_37143_length_244_cov_0.982456_g36937_i0 | PRJNA541476 | 37143 | 244 | 0.982456 | 2.39719264 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00317 | NR | XP_029219765.1 | 94643 | g36937 | i0 | 52.4 | 0.885245901639344 | 42 | 20 | 51.6 | 0 | 237 | 112 | 769 | 810 | XP_029219765.1 hypothetical protein BESB_054070 [Besnoitia besnoiti] | diamond | 216 | 45.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 27535150 | 27535150 | PRJNA541476_P_NODE_23583_length_268_cov_1.333333_g23377_i0 | PRJNA541476 | 23583 | 268 | 1.333333 | 3.57333244 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 4.02e-33 | NR | SOV79628.1 | 5854 | g23377 | i0 | 69.7 | 41.8432835820896 | 89 | 27 | 99.6 | 0 | 268 | 2 | 1158 | 1246 | SOV79628.1 U5 small nuclear ribonuclear protein, putative [Plasmodium reichenowi] | diamond | 11214 | 131 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 27583285 | 27583285 | PRJNA541476_P_NODE_16304_length_301_cov_1.368421_g16098_i0 | PRJNA541476 | 16304 | 301 | 1.368421 | 4.11894721 | Toxoplasma gondii GT1 | 507601 | SAR_Eukaryotes | SAR_Eukaryotes | 94.4 | 9e-21 | NR | EPR61882.1 | 507601 | g16098 | i0 | 41.6 | 2.86046511627907 | 101 | 53 | 98.7 | 3 | 299 | 3 | 167 | 263 | EPR61882.1 hypothetical protein TGGT1_234507 [Toxoplasma gondii GT1] | diamond | 861 | 94.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 27741599 | 27741599 | PRJNA541476_P_NODE_6524_length_442_cov_5.192412_g6320_i0 | PRJNA541476 | 6524 | 442 | 5.192412 | 22.95046104 | Cryptosporidium xiaoi | 659607 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 7.58e-15 | NR | KAK6588730.1 | 659607 | g6320 | i0 | 50 | 0.678733031674208 | 100 | 46 | 67.9 | 1 | 441 | 142 | 64 | 159 | KAK6588730.1 hypothetical protein RS030_333721, partial [Cryptosporidium xiaoi] | diamond | 300 | 77.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium xiaoi | ||
| 28657032 | 28657032 | PRJNA541476_P_NODE_12267_length_333_cov_1.750000_g12061_i0 | PRJNA541476 | 12267 | 333 | 1.75 | 5.8275 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 2.98e-10 | NR | XP_029215085.1 | 94643 | g12061 | i0 | 49.3 | 1.27027027027027 | 73 | 30 | 59.5 | 2 | 17 | 214 | 367 | 439 | XP_029215085.1 aspartyl protease [Besnoitia besnoiti] | diamond | 423 | 67 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 29492692 | 29492692 | PRJNA541476_P_NODE_26890_length_256_cov_2.612022_g26684_i0 | PRJNA541476 | 26890 | 256 | 2.612022 | 6.68677632 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 9.54e-26 | NR | XP_013229976.1 | 5802 | g26684 | i0 | 63.2 | 9.69140625 | 76 | 28 | 89.1 | 0 | 228 | 1 | 7 | 82 | XP_013229976.1 60S ribosomal protein L31, putative [Eimeria tenella] | diamond | 2481 | 103 | 0.990291262135922 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 30140659 | 30140659 | PRJNA541476_P_NODE_41992_length_223_cov_4.086667_g41786_i0 | PRJNA541476 | 41992 | 223 | 4.086667 | 9.11326741 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 3.36e-12 | NR | CAL7864463.1 | 1344799 | g41786 | i0 | 43.2 | 0.995515695067265 | 74 | 41 | 98.2 | 1 | 3 | 221 | 324 | 397 | CAL7864463.1 unnamed protein product [Sarcocystis calchasi] | diamond | 222 | 70.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 31278470 | 31278470 | PRJNA541476_P_NODE_6175_length_455_cov_4.609948_g5972_i0 | PRJNA541476 | 6175 | 455 | 4.609948 | 20.9752634 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 6.489999999999999e-23 | NR | XP_026190971.1 | 88456 | g5972 | i0 | 47.4 | 1.27912087912088 | 97 | 48 | 63.3 | 2 | 6 | 293 | 334 | 428 | XP_026190971.1 phytepsin-like [Cyclospora cayetanensis] | diamond | 582 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 32227785 | 32227785 | PRJNA541476_P_NODE_9338_length_372_cov_1.725753_g9132_i0 | PRJNA541476 | 9338 | 372 | 1.725753 | 6.41980116 | Hepatocystis sp. ex Piliocolobus tephrosceles | 2600580 | SAR_Eukaryotes | SAR_Eukaryotes | 79.7 | 4.89e-15 | NR | VWU51121.1 | 2600580 | g9132 | i0 | 41 | 0.806451612903226 | 100 | 49 | 73.4 | 3 | 273 | 1 | 136 | 234 | VWU51121.1 conserved protein, unknown function [Hepatocystis sp. ex Piliocolobus tephrosceles] | diamond | 300 | 79.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Hepatocystis | Hepatocystis sp. ex Piliocolobus tephrosceles | ||
| 32291283 | 32291283 | PRJNA541476_P_NODE_10819_length_350_cov_0.953069_g10613_i0 | PRJNA541476 | 10819 | 350 | 0.953069 | 3.3357415 | Cryptosporidium muris RN66 | 441375 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 6.97e-30 | NR | XP_002141413.1 | 441375 | g10613 | i0 | 51 | 4.25142857142857 | 100 | 48 | 84.9 | 1 | 344 | 48 | 49 | 148 | XP_002141413.1 eukaryotic translation initiation factor 5, putative [Cryptosporidium muris RN66] | diamond | 1488 | 121 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 32827536 | 32827536 | PRJNA541476_P_NODE_5240_length_497_cov_1.087264_g5038_i0 | PRJNA541476 | 5240 | 497 | 1.087264 | 5.40370208 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.42e-33 | NR | XP_018637379.1 | 508771 | g5038 | i0 | 41.3 | 2.96981891348089 | 160 | 68 | 96.6 | 1 | 490 | 11 | 114 | 247 | XP_018637379.1 zinc carboxypeptidase superfamily protein [Toxoplasma gondii ME49] | diamond | 1476 | 130 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii |
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);;