contig_metadata
13 rows where bioproject = "PRJNA352850", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 396883 | 396883 | PRJNA352850_P_NODE_8041_length_1289_cov_6.044355_g5967_i0 | PRJNA352850 | 8041 | 1289 | 6.044355 | 77.91173595 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 332 | 4.309999999999999e-104 | NR | KAJ1604973.1 | 195482 | g5967 | i0 | 44.8 | 2.64391000775795 | 375 | 198 | 86.8 | 3 | 1243 | 125 | 274 | 641 | KAJ1604973.1 glycyl-tRNA synthetase [Cryptosporidium canis] | diamond | 3408 | 333 | 0.996996996996997 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium canis | ||
| 4222101 | 4222101 | PRJNA352850_P_NODE_15204_length_794_cov_4.563758_g12584_i0 | PRJNA352850 | 15204 | 794 | 4.563758 | 36.23623852 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 465 | 6.37e-163 | NR | SBT72045.1 | 5858 | g12584 | i0 | 89.2 | 506.017632241814 | 277 | 12 | 97.9 | 1 | 778 | 2 | 57 | 333 | SBT72045.1 polyubiquitin, putative [Plasmodium malariae] | diamond | 401778 | 467 | 0.995717344753747 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium malariae | ||
| 27137603 | 27137603 | PRJNA352850_P_NODE_74362_length_260_cov_0.966825_g71529_i0 | PRJNA352850 | 74362 | 260 | 0.966825 | 2.513745 | Theileria equi strain WA | 1537102 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 1.77e-10 | NR | XP_004830166.1 | 1537102 | g71529 | i0 | 40.5 | 0.969230769230769 | 84 | 45 | 94.6 | 3 | 246 | 1 | 16 | 96 | XP_004830166.1 long-chain fatty acid CoA ligase, putative [Theileria equi strain WA] | diamond | 252 | 66.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 28071057 | 28071057 | PRJNA352850_P_NODE_61185_length_296_cov_1.186235_g58352_i0 | PRJNA352850 | 61185 | 296 | 1.186235 | 3.5112556 | Eimeria | 5800 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 2.09e-10 | NR | XP_013229976.1 | 5802 | g58352 | i0 | 65.9 | 3.59797297297297 | 41 | 14 | 41.6 | 0 | 296 | 174 | 68 | 108 | XP_013229976.1 60S ribosomal protein L31, putative [Eimeria tenella] | diamond | 1065 | 63.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 30502751 | 30502751 | PRJNA352850_P_NODE_42233_length_384_cov_3.979104_g39401_i0 | PRJNA352850 | 42233 | 384 | 3.979104 | 15.27975936 | root | 1 | Root_unresolved | Root_unresolved | 84.7 | 3.6e-16 | NR | XP_012766044.1 | 5866 | g39401 | i0 | 36.8 | 2.6796875 | 114 | 65 | 89.1 | 1 | 382 | 41 | 580 | 686 | XP_012766044.1 long-chain acyl-CoA synthetase, putative [Babesia bigemina] | diamond | 1029 | 85.5 | 0.990643274853801 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 30881790 | 30881790 | PRJNA352850_P_NODE_56934_length_311_cov_2.354962_g54101_i0 | PRJNA352850 | 56934 | 311 | 2.354962 | 7.32393182 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 79.3 | 1.23e-14 | NR | XP_037878197.1 | 44415 | g54101 | i0 | 37.4 | 15.4340836012862 | 99 | 57 | 93.6 | 2 | 293 | 3 | 2883 | 2978 | XP_037878197.1 Dynein heavy chain axonemal, related [Eimeria mitis] | diamond | 4800 | 80.1 | 0.990012484394507 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 30896462 | 30896462 | PRJNA352850_P_NODE_30814_length_479_cov_6.288372_g27985_i0 | PRJNA352850 | 30814 | 479 | 6.288372 | 30.12130188 | Cryptosporidium andersoni | 117008 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 4.2999999999999996e-33 | NR | XP_067070035.1 | 117008 | g27985 | i0 | 45.3 | 1.7160751565762 | 137 | 73 | 85.8 | 1 | 52 | 462 | 170 | 304 | XP_067070035.1 uncharacterized protein cand_035180 [Cryptosporidium andersoni] | diamond | 822 | 129 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 30991200 | 30991200 | PRJNA352850_P_NODE_44474_length_370_cov_2.753894_g41641_i0 | PRJNA352850 | 44474 | 370 | 2.753894 | 10.1894078 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 3e-12 | NR | SBT30408.1 | 864142 | g41641 | i0 | 35.1 | 3.17027027027027 | 94 | 61 | 76.2 | 0 | 292 | 11 | 192 | 285 | SBT30408.1 glutaredoxin-like protein [Plasmodium ovale wallikeri] | diamond | 1173 | 72.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 31008269 | 31008269 | PRJNA352850_P_NODE_15474_length_784_cov_4.693878_g12843_i0 | PRJNA352850 | 15474 | 784 | 4.693878 | 36.80000352 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 1.4e-32 | NR | SPJ09750.1 | 720590 | g12843 | i0 | 37.3 | 1.56122448979592 | 204 | 124 | 78.1 | 2 | 777 | 166 | 1433 | 1632 | SPJ09750.1 ferlin, putative [Plasmodium sp. DRC-Itaito] | diamond | 1224 | 137 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. DRC-Itaito | ||
| 31117203 | 31117203 | PRJNA352850_P_NODE_69855_length_269_cov_0.927273_g67022_i0 | PRJNA352850 | 69855 | 269 | 0.927273 | 2.49436437 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 1.91e-7 | NR | XP_067920668.1 | 483139 | g67022 | i0 | 44.3 | 1.77323420074349 | 79 | 44 | 88.1 | 0 | 7 | 243 | 539 | 617 | XP_067920668.1 dna replication licensing factor mcm7 [Cystoisospora suis] | diamond | 477 | 58.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 31243824 | 31243824 | PRJNA352850_P_NODE_48595_length_348_cov_2.434783_g45762_i0 | PRJNA352850 | 48595 | 348 | 2.434783 | 8.47304484 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 99.8 | 5.31e-24 | NR | UKK01874.1 | 68886 | g45762 | i0 | 46.1 | 2.63793103448276 | 102 | 55 | 87.9 | 0 | 21 | 326 | 48 | 149 | UKK01874.1 calmodulin [Theileria orientalis] | diamond | 918 | 99.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 32034719 | 32034719 | PRJNA352850_P_NODE_32758_length_459_cov_5.851220_g29928_i0 | PRJNA352850 | 32758 | 459 | 5.85122 | 26.8570998 | Cryptosporidium bovis | 310047 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 6.59e-6 | NR | XP_067185088.1 | 310047 | g29928 | i0 | 52.9 | 0.333333333333333 | 51 | 23 | 33.3 | 1 | 1 | 153 | 18 | 67 | XP_067185088.1 uncharacterized protein FG379_003289 [Cryptosporidium bovis] | diamond | 153 | 56.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis | ||
| 32414502 | 32414502 | PRJNA352850_P_NODE_17239_length_723_cov_4.824926_g14555_i0 | PRJNA352850 | 17239 | 723 | 4.824926 | 34.88421498 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 3.73e-4 | NR | XP_013251428.1 | 5801 | g14555 | i0 | 34.4 | 2.2655601659751 | 96 | 60 | 39.8 | 2 | 478 | 191 | 230 | 322 | XP_013251428.1 hypothetical protein, conserved [Eimeria acervulina] | diamond | 1638 | 53.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina |
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);;