contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA438111" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4260790 | 4260790 | PRJNA438111_P_NODE_14524_length_274_cov_6.146939_g13899_i0 | PRJNA438111 | 14524 | 274 | 6.146939 | 16.84261286 | Cardiosporidium cionae | 476202 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 2.38e-16 | NR | KAF8822879.1 | 476202 | g13899 | i0 | 71.2 | 2.27737226277372 | 52 | 15 | 56.9 | 0 | 274 | 119 | 262 | 313 | KAF8822879.1 putative serine/threonine protein phosphatase [Cardiosporidium cionae] | diamond | 624 | 82.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 8087849 | 8087849 | PRJNA438111_P_NODE_7507_length_366_cov_3.391691_g6893_i0 | PRJNA438111 | 7507 | 366 | 3.391691 | 12.41358906 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 179 | 5.69e-50 | NR | XP_067717375.1 | 5871 | g6893 | i0 | 74.6 | 8.0327868852459 | 122 | 30 | 99.2 | 1 | 364 | 2 | 261 | 382 | XP_067717375.1 ATP-dependent zinc metalloprotease FTSH, putative [Babesia caballi] | diamond | 2940 | 179 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi | ||
| 15737477 | 15737477 | PRJNA438111_P_NODE_9913_length_324_cov_7.945763_g9292_i0 | PRJNA438111 | 9913 | 324 | 7.945763 | 25.74427212 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 133 | 2.41e-38 | NR | XP_029221429.1 | 94643 | g9292 | i0 | 72.5 | 3.65740740740741 | 80 | 22 | 74.1 | 0 | 265 | 26 | 1 | 80 | XP_029221429.1 ribosomal protein RPS27 [Besnoitia besnoiti] | diamond | 1185 | 133 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 22110417 | 22110417 | PRJNA438111_P_NODE_1358_length_808_cov_6.163030_g1036_i0 | PRJNA438111 | 1358 | 808 | 6.16303 | 49.7972824 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 290 | 2.57e-90 | NR | XP_013250267.1 | 5801 | g1036 | i0 | 65.7 | 20.7438118811881 | 216 | 71 | 79.5 | 2 | 806 | 165 | 138 | 352 | XP_013250267.1 CMGC kinase, MAPK family TgMAPK2, putative [Eimeria acervulina] | diamond | 16761 | 292 | 0.993150684931507 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 23386036 | 23386036 | PRJNA438111_P_NODE_19059_length_244_cov_10.013953_g18434_i0 | PRJNA438111 | 19059 | 244 | 10.013953 | 24.43404532 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 8.28e-34 | NR | XP_013228667.1 | 5802 | g18434 | i0 | 74.3 | 9.06147540983607 | 74 | 19 | 91 | 0 | 242 | 21 | 297 | 370 | XP_013228667.1 developmentally regulated GTP-binding protein 1, putative [Eimeria tenella] | diamond | 2211 | 130 | 0.992307692307692 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 24660346 | 24660346 | PRJNA438111_P_NODE_34760_length_205_cov_10.301136_g34135_i0 | PRJNA438111 | 34760 | 205 | 10.301136 | 21.1173288 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 93.2 | 1.54e-20 | NR | XP_067927548.1 | 483139 | g34135 | i0 | 65.7 | 1.9609756097561 | 67 | 23 | 98 | 0 | 202 | 2 | 21 | 87 | XP_067927548.1 fructose- -bisphosphate [Cystoisospora suis] | diamond | 402 | 93.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 27265695 | 27265695 | PRJNA438111_P_NODE_58163_length_173_cov_2.798611_g57538_i0 | PRJNA438111 | 58163 | 173 | 2.798611 | 4.84159703 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 79 | 2.48e-15 | NR | XP_011134498.1 | 110365 | g57538 | i0 | 69.6 | 14.3757225433526 | 56 | 16 | 97.1 | 1 | 172 | 5 | 120 | 174 | XP_011134498.1 putative translation initiation factor if-2, partial [Gregarina niphandrodes] | diamond | 2487 | 79 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 27455327 | 27455327 | PRJNA438111_P_NODE_20123_length_239_cov_3.333333_g19498_i0 | PRJNA438111 | 20123 | 239 | 3.333333 | 7.96666587 | Plasmodium berghei ANKA | 5823 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 6.72e-11 | NR | XP_034422851.1 | 5823 | g19498 | i0 | 55.1 | 5.8744769874477 | 69 | 24 | 86.6 | 1 | 238 | 32 | 339 | 400 | XP_034422851.1 UDP-N-acetylglucosamine--dolichyl-phosphate N-acetylglucosaminephosphotransferase, putative [Plasmodium berghei ANKA] | diamond | 1404 | 67.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 27549807 | 27549807 | PRJNA438111_P_NODE_84804_length_154_cov_3.376000_g84179_i0 | PRJNA438111 | 84804 | 154 | 3.376 | 5.19904 | Cryptosporidium ryanae | 515981 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 4.68e-4 | NR | XP_067196263.1 | 515981 | g84179 | i0 | 52.5 | 0.779220779220779 | 40 | 13 | 77.9 | 1 | 33 | 152 | 534 | 567 | XP_067196263.1 uncharacterized protein FG386_000002 [Cryptosporidium ryanae] | diamond | 120 | 46.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae | ||
| 28023548 | 28023548 | PRJNA438111_P_NODE_23805_length_222_cov_2.937824_g23180_i0 | PRJNA438111 | 23805 | 222 | 2.937824 | 6.52196928 | Plasmodium vivax Brazil I | 1033975 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 4.02e-5 | NR | KMZ85061.1 | 1033975 | g23180 | i0 | 41.5 | 1.10810810810811 | 82 | 32 | 89.2 | 3 | 221 | 24 | 865 | 946 | KMZ85061.1 hypothetical protein PVBG_01460 [Plasmodium vivax Brazil I] | diamond | 246 | 50.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 28166217 | 28166217 | PRJNA438111_P_NODE_4345_length_473_cov_14.698198_g3802_i0 | PRJNA438111 | 4345 | 473 | 14.698198 | 69.52247654 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 218 | 1.22e-69 | NR | XP_067925688.1 | 483139 | g3802 | i0 | 73.2 | 2.70190274841438 | 142 | 38 | 90.1 | 0 | 453 | 28 | 50 | 191 | XP_067925688.1 40s ribosomal protein s16 [Cystoisospora suis] | diamond | 1278 | 219 | 0.995433789954338 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 29286324 | 29286324 | PRJNA438111_P_NODE_36309_length_201_cov_4.069767_g35684_i0 | PRJNA438111 | 36309 | 201 | 4.069767 | 8.18023167 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.00888 | NR | CAL7866800.1 | 1344799 | g35684 | i0 | 32.8 | 7.13432835820895 | 64 | 40 | 95.5 | 1 | 1 | 192 | 1616 | 1676 | CAL7866800.1 unnamed protein product [Sarcocystis calchasi] | diamond | 1434 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 30265790 | 30265790 | PRJNA438111_P_NODE_36592_length_200_cov_5.602339_g35967_i0 | PRJNA438111 | 36592 | 200 | 5.602339 | 11.204678 | Theileria equi strain WA | 1537102 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 4.27e-25 | NR | XP_004831355.1 | 1537102 | g35967 | i0 | 79.1 | 2.01 | 67 | 13 | 99 | 1 | 199 | 2 | 19 | 85 | XP_004831355.1 uncharacterized protein family UPF0160 domain-containing protein [Theileria equi strain WA] | diamond | 402 | 103 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 30377067 | 30377067 | PRJNA438111_P_NODE_7972_length_356_cov_5.339450_g7357_i0 | PRJNA438111 | 7972 | 356 | 5.33945 | 19.008442 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 3.63e-21 | NR | XP_028875455.1 | 857276 | g7357 | i0 | 72.7 | 4.43258426966292 | 66 | 18 | 55.6 | 0 | 354 | 157 | 201 | 266 | XP_028875455.1 Mis3 Dribble KH domain-containing protein [Cryptosporidium ubiquitum] | diamond | 1578 | 97.4 | 0.996919917864476 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ubiquitum | ||
| 31023826 | 31023826 | PRJNA438111_P_NODE_25295_length_217_cov_1.505319_g24670_i0 | PRJNA438111 | 25295 | 217 | 1.505319 | 3.26654223 | Cryptosporidium canis | 195482 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 7.89e-9 | NR | KAJ1609316.1 | 195482 | g24670 | i0 | 37.1 | 3.87096774193548 | 70 | 43 | 95.4 | 1 | 212 | 6 | 1747 | 1816 | KAJ1609316.1 Dop1p-like protein [Cryptosporidium canis] | diamond | 840 | 61.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium canis | ||
| 31798878 | 31798878 | PRJNA438111_P_NODE_4257_length_477_cov_18.754464_g3722_i0 | PRJNA438111 | 4257 | 477 | 18.754464 | 89.45879328 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 216 | 3.73e-69 | NR | XP_029221789.1 | 94643 | g3722 | i0 | 70.9 | 3.63522012578616 | 148 | 39 | 90.6 | 1 | 459 | 28 | 1 | 148 | XP_029221789.1 ribosomal protein RPS16 [Besnoitia besnoiti] | diamond | 1734 | 218 | 0.990825688073395 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 32400380 | 32400380 | PRJNA438111_P_NODE_6099_length_401_cov_8.803763_g5510_i0 | PRJNA438111 | 6099 | 401 | 8.803763 | 35.30308963 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 186 | 1.01e-57 | NR | XP_029221789.1 | 94643 | g5510 | i0 | 72.9 | 3.53117206982544 | 118 | 32 | 88.3 | 0 | 3 | 356 | 31 | 148 | XP_029221789.1 ribosomal protein RPS16 [Besnoitia besnoiti] | diamond | 1416 | 187 | 0.994652406417112 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 32825576 | 32825576 | PRJNA438111_P_NODE_18980_length_245_cov_3.078704_g18355_i0 | PRJNA438111 | 18980 | 245 | 3.078704 | 7.5428248 | Babesia microti strain RI | 1133968 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 7.36e-5 | NR | XP_012647814.1 | 1133968 | g18355 | i0 | 34.6 | 2.90204081632653 | 81 | 50 | 98 | 2 | 1 | 240 | 670 | 748 | XP_012647814.1 histidyl-tRNA synthetase [Babesia microti strain RI] | diamond | 711 | 50.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti |
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);;