contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA541476" 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 | ||
| 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 | ||
| 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);;