contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA876641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2128560 | 2128560 | PRJNA876641_P_NODE_2322_length_462_cov_1.532134_g2248_i0 | PRJNA876641 | 2322 | 462 | 1.532134 | 7.07845908 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 1.1e-62 | NR | XP_029215449.1 | 94643 | g2248 | i0 | 80.1 | 16.6948051948052 | 136 | 26 | 88.3 | 1 | 55 | 462 | 192 | 326 | XP_029215449.1 uncharacterized protein BESB_028750 [Besnoitia besnoiti] | diamond | 7713 | 221 | 0.990950226244344 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 3404065 | 3404065 | PRJNA876641_P_NODE_4543_length_362_cov_1.961938_g4469_i0 | PRJNA876641 | 4543 | 362 | 1.961938 | 7.10221556 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.17e-33 | NR | KAK1936904.1 | 32595 | g4469 | i0 | 68.6 | 50.8011049723757 | 86 | 27 | 71.3 | 0 | 361 | 104 | 135 | 220 | KAK1936904.1 putative 40S ribosomal protein S5 [Babesia divergens] | diamond | 18390 | 127 | 0.992125984251969 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia divergens | ||
| 3790356 | 3790356 | PRJNA876641_P_NODE_16383_length_250_cov_1.305085_g16309_i0 | PRJNA876641 | 16383 | 250 | 1.305085 | 3.2627125 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 122 | 2.46e-33 | NR | XP_002367420.1 | 508771 | g16309 | i0 | 74 | 5.544 | 77 | 20 | 92.4 | 0 | 234 | 4 | 1 | 77 | XP_002367420.1 translation initiation factor eIF-5A, putative [Toxoplasma gondii ME49] | diamond | 1386 | 122 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 5066535 | 5066535 | PRJNA876641_P_NODE_4324_length_369_cov_1.418919_g4250_i0 | PRJNA876641 | 4324 | 369 | 1.418919 | 5.23581111 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 3.549999999999999e-23 | NR | XP_011132110.1 | 110365 | g4250 | i0 | 59.5 | 1.90243902439024 | 84 | 33 | 67.5 | 1 | 369 | 121 | 439 | 522 | XP_011132110.1 DEAD-box RNA helicase [Gregarina niphandrodes] | diamond | 702 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 5956451 | 5956451 | PRJNA876641_P_NODE_19585_length_246_cov_0.890173_g19511_i0 | PRJNA876641 | 19585 | 246 | 0.890173 | 2.18982558 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 9.59e-37 | NR | WBY58514.1 | 73239 | g19511 | i0 | 78.2 | 11.5609756097561 | 78 | 17 | 95.1 | 0 | 13 | 246 | 2 | 79 | WBY58514.1 ras-related protein Rab-1B [Plasmodium yoelii yoelii] | diamond | 2844 | 129 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 21255304 | 21255304 | PRJNA876641_P_NODE_2477_length_450_cov_6.007958_g2403_i0 | PRJNA876641 | 2477 | 450 | 6.007958 | 27.035811 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 236 | 1.53e-77 | NR | XP_013332946.1 | 5804 | g2403 | i0 | 87.9 | 54.5666666666667 | 132 | 16 | 88 | 0 | 447 | 52 | 5 | 136 | XP_013332946.1 ribosomal protein S23, putative [Eimeria maxima] | diamond | 24555 | 237 | 0.9957805907173 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 26841996 | 26841996 | PRJNA876641_P_NODE_4541_length_362_cov_2.051903_g4467_i0 | PRJNA876641 | 4541 | 362 | 2.051903 | 7.42788886 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 1.13e-32 | NR | CDI80419.1 | 51316 | g4467 | i0 | 53.3 | 3.4060773480663 | 105 | 49 | 87 | 0 | 319 | 5 | 49 | 153 | CDI80419.1 thioredoxin, putative [Eimeria praecox] | diamond | 1233 | 124 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria praecox | ||
| 26897198 | 26897198 | PRJNA876641_P_NODE_12661_length_267_cov_1.268041_g12587_i0 | PRJNA876641 | 12661 | 267 | 1.268041 | 3.38566947 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 2.27e-12 | NR | KAF8822793.1 | 476202 | g12587 | i0 | 58.6 | 1.29213483146067 | 58 | 24 | 65.2 | 0 | 93 | 266 | 195 | 252 | KAF8822793.1 bystin protein [Cardiosporidium cionae] | diamond | 345 | 72 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 27086926 | 27086926 | PRJNA876641_P_NODE_10322_length_280_cov_1.487923_g10248_i0 | PRJNA876641 | 10322 | 280 | 1.487923 | 4.1661844 | Babesia bovis | 5865 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 1.77e-8 | NR | BAN64614.1 | 5865 | g10248 | i0 | 42.6 | 0.728571428571429 | 68 | 38 | 71.8 | 1 | 201 | 1 | 31 | 98 | BAN64614.1 cyclin, N-terminal domain containing protein [Babesia bovis] | diamond | 204 | 61.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 27624111 | 27624111 | PRJNA876641_P_NODE_15344_length_252_cov_1.720670_g15270_i0 | PRJNA876641 | 15344 | 252 | 1.72067 | 4.3360884 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 1.81e-6 | NR | XP_026194385.1 | 88456 | g15270 | i0 | 84 | 1.19047619047619 | 25 | 4 | 29.8 | 0 | 250 | 176 | 467 | 491 | XP_026194385.1 dihydrolipoyl dehydrogenase 1, mitochondrial [Cyclospora cayetanensis] | diamond | 300 | 55.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 28918251 | 28918251 | PRJNA876641_P_NODE_16148_length_251_cov_0.865169_g16074_i0 | PRJNA876641 | 16148 | 251 | 0.865169 | 2.17157419 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 67.8 | 6.03e-11 | NR | CAL7858638.1 | 1344799 | g16074 | i0 | 40.2 | 4.57768924302789 | 92 | 43 | 95.6 | 2 | 5 | 244 | 124 | 215 | CAL7858638.1 unnamed protein product [Sarcocystis calchasi] | diamond | 1149 | 67.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 28989919 | 28989919 | PRJNA876641_P_NODE_19648_length_246_cov_0.890173_g19574_i0 | PRJNA876641 | 19648 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 2.38e-11 | NR | KAK1442351.1 | 33632 | g19574 | i0 | 48.8 | 8.07317073170732 | 82 | 40 | 100 | 1 | 1 | 246 | 676 | 755 | KAK1442351.1 putative phospholipid-transporting ATPase [Babesia gibsoni] | diamond | 1986 | 69.3 | 0.994227994227994 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia gibsoni | ||
| 29084484 | 29084484 | PRJNA876641_P_NODE_17308_length_249_cov_0.875000_g17234_i0 | PRJNA876641 | 17308 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0254 | NR | P84152.1 | 5850 | g17234 | i0 | 42.3 | 1.92771084337349 | 52 | 30 | 62.7 | 0 | 207 | 52 | 63 | 114 | P84152.1 RecName: Full=Translationally-controlled tumor protein homolog; Short=TCTP [Plasmodium knowlesi] | diamond | 480 | 42.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 29486539 | 29486539 | PRJNA876641_P_NODE_19450_length_246_cov_0.890173_g19376_i0 | PRJNA876641 | 19450 | 246 | 0.890173 | 2.18982558 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 1.05e-7 | NR | XP_013247443.1 | 5801 | g19376 | i0 | 42.6 | 0.829268292682927 | 68 | 39 | 82.9 | 0 | 205 | 2 | 1285 | 1352 | XP_013247443.1 cGMP-inhibited 3',5'-cyclic phosphodiesterase, putative [Eimeria acervulina] | diamond | 204 | 58.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 30884773 | 30884773 | PRJNA876641_P_NODE_15194_length_253_cov_1.561111_g15120_i0 | PRJNA876641 | 15194 | 253 | 1.561111 | 3.94961083 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 3.65e-8 | NR | XP_067924047.1 | 483139 | g15120 | i0 | 37.8 | 1.70750988142292 | 74 | 39 | 79.4 | 2 | 53 | 253 | 23 | 96 | XP_067924047.1 ran-specific gtpase-activating [Cystoisospora suis] | diamond | 432 | 58.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 32812898 | 32812898 | PRJNA876641_P_NODE_4800_length_356_cov_2.583039_g4726_i0 | PRJNA876641 | 4800 | 356 | 2.583039 | 9.19561884 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.5199999999999998e-31 | NR | BAN64285.1 | 5865 | g4726 | i0 | 68 | 11.3511235955056 | 75 | 24 | 63.2 | 0 | 352 | 128 | 73 | 147 | BAN64285.1 40S ribosomal protein S15, putative [Babesia bovis] | diamond | 4041 | 120 | 0.991666666666667 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis |
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);;