contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA561212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1821015 | 1821015 | PRJNA561212_P_NODE_17442_length_272_cov_1.241206_g17231_i0 | PRJNA561212 | 17442 | 272 | 1.241206 | 3.37608032 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 8.86e-11 | NR | CAL7865699.1 | 1344799 | g17231 | i0 | 55.1 | 0.540441176470588 | 49 | 22 | 54 | 0 | 156 | 10 | 12 | 60 | CAL7865699.1 unnamed protein product [Sarcocystis calchasi] | diamond | 147 | 64.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 6234254 | 6234254 | PRJNA561212_P_NODE_1045_length_1040_cov_1.771458_g902_i0 | PRJNA561212 | 1045 | 1040 | 1.771458 | 18.4231632 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 358 | 8.229999999999998e-118 | NR | XP_011132759.1 | 110365 | g902 | i0 | 64.9 | 8.64807692307692 | 268 | 93 | 77 | 1 | 821 | 21 | 195 | 462 | XP_011132759.1 putative transport Sec61 alpha subunit [Gregarina niphandrodes] | diamond | 8994 | 358 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 22807831 | 22807831 | PRJNA561212_P_NODE_15098_length_289_cov_1.680556_g14887_i0 | PRJNA561212 | 15098 | 289 | 1.680556 | 4.85680684 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 3.6699999999999995e-30 | NR | SBS81330.1 | 864141 | g14887 | i0 | 70 | 4.67128027681661 | 90 | 25 | 93.4 | 1 | 280 | 11 | 792 | 879 | SBS81330.1 DNA-directed RNA polymerase II subunit RPB2, putative (RPB2) [Plasmodium ovale curtisi] | diamond | 1350 | 124 | 0.991935483870968 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 27155850 | 27155850 | PRJNA561212_P_NODE_18862_length_262_cov_1.190476_g18651_i0 | PRJNA561212 | 18862 | 262 | 1.190476 | 3.11904712 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 4.42e-4 | NR | XP_029222058.1 | 94643 | g18651 | i0 | 35.9 | 4.46564885496183 | 78 | 48 | 89.3 | 1 | 249 | 16 | 301 | 376 | XP_029222058.1 hypothetical protein BESB_003900 [Besnoitia besnoiti] | diamond | 1170 | 48.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 28658243 | 28658243 | PRJNA561212_P_NODE_16447_length_279_cov_1.436893_g16236_i0 | PRJNA561212 | 16447 | 279 | 1.436893 | 4.00893147 | Cryptosporidium ubiquitum | 857276 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 1.33e-5 | NR | XP_028875135.1 | 857276 | g16236 | i0 | 38.9 | 1.02150537634409 | 95 | 49 | 98.9 | 4 | 4 | 279 | 838 | 926 | XP_028875135.1 uncharacterized protein cubi_02717 [Cryptosporidium ubiquitum] | diamond | 285 | 53.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ubiquitum | ||
| 28847403 | 28847403 | PRJNA561212_P_NODE_19828_length_255_cov_1.241758_g19617_i0 | PRJNA561212 | 19828 | 255 | 1.241758 | 3.1664829 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 3.06e-5 | NR | XP_026190023.1 | 88456 | g19617 | i0 | 45.7 | 2.54117647058824 | 70 | 36 | 80 | 1 | 247 | 44 | 252 | 321 | XP_026190023.1 transcription elongation factor S-II [Cyclospora cayetanensis] | diamond | 648 | 51.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 29068772 | 29068772 | PRJNA561212_P_NODE_7428_length_403_cov_1.312121_g7217_i0 | PRJNA561212 | 7428 | 403 | 1.312121 | 5.28784763 | Babesia ovis | 5869 | SAR_Eukaryotes | SAR_Eukaryotes | 89.7 | 8.03e-18 | NR | GFE52985.1 | 5869 | g7217 | i0 | 52.1 | 1.39950372208437 | 73 | 34 | 54.3 | 1 | 132 | 350 | 219 | 290 | GFE52985.1 CW-type Zinc Finger protein [Babesia ovis] | diamond | 564 | 89.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 29131918 | 29131918 | PRJNA561212_P_NODE_8129_length_385_cov_0.948718_g7918_i0 | PRJNA561212 | 8129 | 385 | 0.948718 | 3.6525643 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 3.73e-9 | NR | XP_022587039.1 | 88456 | g7918 | i0 | 40.8 | 1.62857142857143 | 120 | 54 | 84.2 | 5 | 51 | 374 | 32 | 146 | XP_022587039.1 phosducin-like protein 3 [Cyclospora cayetanensis] | diamond | 627 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 29731381 | 29731381 | PRJNA561212_P_NODE_24630_length_244_cov_1.321637_g24419_i0 | PRJNA561212 | 24630 | 244 | 1.321637 | 3.22479428 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 1.23e-8 | NR | XP_011129458.1 | 110365 | g24419 | i0 | 44 | 0.922131147540984 | 75 | 35 | 92.2 | 1 | 11 | 235 | 13 | 80 | XP_011129458.1 dephospho-CoA kinase [Gregarina niphandrodes] | diamond | 225 | 60.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 30440702 | 30440702 | PRJNA561212_P_NODE_2753_length_663_cov_1.596610_g2548_i0 | PRJNA561212 | 2753 | 663 | 1.59661 | 10.5855243 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 2.96e-35 | NR | SBS83265.1 | 864141 | g2548 | i0 | 38.5 | 9.66968325791855 | 218 | 100 | 98.6 | 5 | 1 | 654 | 2431 | 2614 | SBS83265.1 CCR4-NOT transcription complex subunit 1, putative (NOT1) [Plasmodium ovale curtisi] | diamond | 6411 | 144 | 0.993055555555556 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 32653364 | 32653364 | PRJNA561212_P_NODE_14780_length_292_cov_1.100457_g14569_i0 | PRJNA561212 | 14780 | 292 | 1.100457 | 3.21333444 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 1.8899999999999998e-24 | NR | XP_067073601.1 | 5824 | g14569 | i0 | 56.7 | 18.4006849315068 | 90 | 36 | 92.5 | 1 | 278 | 9 | 1 | 87 | XP_067073601.1 translation initiation factor eIF-1A [Plasmodium brasilianum] | diamond | 5373 | 102 | 0.990196078431373 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum |
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);;