contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA674308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5748449 | 5748449 | PRJNA674308_P_NODE_7165_length_355_cov_1.359477_g6930_i0 | PRJNA674308 | 7165 | 355 | 1.359477 | 4.82614335 | Babesia bigemina | 5866 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 4.03e-47 | NR | XP_012767707.1 | 5866 | g6930 | i0 | 62.4 | 4.90140845070423 | 117 | 44 | 98.9 | 0 | 1 | 351 | 92 | 208 | XP_012767707.1 thiodoxin reductase, putative [Babesia bigemina] | diamond | 1740 | 169 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 9573156 | 9573156 | PRJNA674308_P_NODE_18648_length_226_cov_3.005650_g18413_i0 | PRJNA674308 | 18648 | 226 | 3.00565 | 6.792769 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.919999999999999e-23 | NR | OEH75958.1 | 88456 | g18413 | i0 | 59.5 | 5.88053097345133 | 74 | 30 | 98.2 | 0 | 224 | 3 | 736 | 809 | OEH75958.1 putative prolyl-tRNA synthetase [Cyclospora cayetanensis] | diamond | 1329 | 102 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 26650333 | 26650333 | PRJNA674308_P_NODE_42241_length_166_cov_1.752137_g42006_i0 | PRJNA674308 | 42241 | 166 | 1.752137 | 2.90854742 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 1.31e-16 | NR | GFE54016.1 | 5869 | g42006 | i0 | 71.2 | 11.3313253012048 | 52 | 15 | 94 | 0 | 164 | 9 | 318 | 369 | GFE54016.1 polyadenylate binding protein [Babesia ovis] | diamond | 1881 | 82.8 | 0.995169082125604 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis | ||
| 27030396 | 27030396 | PRJNA674308_P_NODE_9662_length_306_cov_1.750973_g9427_i0 | PRJNA674308 | 9662 | 306 | 1.750973 | 5.35797738 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 4.75e-8 | NR | XP_034423527.1 | 5823 | g9427 | i0 | 32.6 | 5.1078431372549 | 92 | 59 | 90.2 | 1 | 1 | 276 | 438 | 526 | XP_034423527.1 splicing factor 1, putative [Plasmodium berghei ANKA] | diamond | 1563 | 60.8 | 0.995065789473684 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 27694218 | 27694218 | PRJNA674308_P_NODE_12064_length_276_cov_1.348018_g11829_i0 | PRJNA674308 | 12064 | 276 | 1.348018 | 3.72052968 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 9.22e-29 | NR | XP_002370798.1 | 508771 | g11829 | i0 | 57.6 | 8 | 92 | 39 | 100 | 0 | 1 | 276 | 68 | 159 | XP_002370798.1 small GTP binding protein rab1a, putative [Toxoplasma gondii ME49] | diamond | 2208 | 112 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 27776906 | 27776906 | PRJNA674308_P_NODE_28724_length_188_cov_1.496403_g28489_i0 | PRJNA674308 | 28724 | 188 | 1.496403 | 2.81323764 | Neospora caninum Liverpool | 572307 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 3.2e-5 | NR | CEL64732.1 | 572307 | g28489 | i0 | 39.7 | 2.74468085106383 | 58 | 35 | 92.6 | 0 | 176 | 3 | 240 | 297 | CEL64732.1 TPA: Ubiquitin, related [Neospora caninum Liverpool] | diamond | 516 | 50.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 27934708 | 27934708 | PRJNA674308_P_NODE_9725_length_305_cov_1.593750_g9490_i0 | PRJNA674308 | 9725 | 305 | 1.59375 | 4.8609375 | Babesia duncani | 323732 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 5.35e-24 | NR | XP_067803689.1 | 323732 | g9490 | i0 | 62.2 | 1.47540983606557 | 74 | 28 | 72.8 | 0 | 78 | 299 | 8 | 81 | XP_067803689.1 bifunctional RNA recognition motif domain/RNA-binding domain superfamily/Nucleotide-binding alpha-beta plait domain superfamily [Babesia duncani] | diamond | 450 | 100 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 28881744 | 28881744 | PRJNA674308_P_NODE_16088_length_242_cov_0.984456_g15853_i0 | PRJNA674308 | 16088 | 242 | 0.984456 | 2.38238352 | Porospora cf. gigantea A | 2853593 | SAR_Eukaryotes | SAR_Eukaryotes | 63.2 | 2.36e-9 | NR | XP_067813127.1 | 2853593 | g15853 | i0 | 57.1 | 1.21487603305785 | 49 | 21 | 60.7 | 0 | 3 | 149 | 153 | 201 | XP_067813127.1 MAG: uncharacterized protein KVP18_003657 [Porospora cf. gigantea A] | diamond | 294 | 63.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea A | ||
| 30018771 | 30018771 | PRJNA674308_P_NODE_36671_length_169_cov_0.866667_g36436_i0 | PRJNA674308 | 36671 | 169 | 0.866667 | 1.46466723 | Cryptosporidium canis | 195482 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 1.27e-7 | NR | KAJ1612632.1 | 195482 | g36436 | i0 | 56.5 | 1.63313609467456 | 46 | 20 | 81.7 | 0 | 144 | 7 | 106 | 151 | KAJ1612632.1 cryptopain-cysteine proteinase secreted [Cryptosporidium canis] | diamond | 276 | 57 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium canis | ||
| 30808513 | 30808513 | PRJNA674308_P_NODE_50574_length_163_cov_0.912281_g50339_i0 | PRJNA674308 | 50574 | 163 | 0.912281 | 1.48701803 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 6e-16 | NR | XP_011128544.1 | 110365 | g50339 | i0 | 62.3 | 0.975460122699387 | 53 | 20 | 97.5 | 0 | 3 | 161 | 161 | 213 | XP_011128544.1 casein kinase I [Gregarina niphandrodes] | diamond | 159 | 80.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 31041888 | 31041888 | PRJNA674308_P_NODE_17355_length_234_cov_0.870270_g17120_i0 | PRJNA674308 | 17355 | 234 | 0.87027 | 2.0364318 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 4.7e-5 | NR | CAD2095709.1 | 5860 | g17120 | i0 | 38.6 | 9.62820512820513 | 83 | 44 | 97.4 | 1 | 230 | 3 | 91 | 173 | CAD2095709.1 myosin-like protein, putative [Plasmodium vinckei] | diamond | 2253 | 50.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 31073232 | 31073232 | PRJNA674308_P_NODE_16595_length_238_cov_1.650794_g16360_i0 | PRJNA674308 | 16595 | 238 | 1.650794 | 3.92888972 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 6.69e-25 | NR | XP_028525792.1 | 5849 | g16360 | i0 | 66.7 | 6.35294117647059 | 72 | 24 | 90.8 | 0 | 217 | 2 | 1 | 72 | XP_028525792.1 40S ribosomal protein S9, putative [Plasmodium gallinaceum] | diamond | 1512 | 102 | 0.990196078431373 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 31282411 | 31282411 | PRJNA674308_P_NODE_4655_length_442_cov_2.562341_g4420_i0 | PRJNA674308 | 4655 | 442 | 2.562341 | 11.32554722 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 4.27e-12 | NR | XP_013438480.1 | 51315 | g4420 | i0 | 35.8 | 0.739819004524887 | 109 | 70 | 74 | 0 | 6 | 332 | 1201 | 1309 | XP_013438480.1 hypothetical protein ENH_00077430 [Eimeria necatrix] | diamond | 327 | 73.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 31883366 | 31883366 | PRJNA674308_P_NODE_24617_length_201_cov_1.368421_g24382_i0 | PRJNA674308 | 24617 | 201 | 1.368421 | 2.75052621 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 83.6 | 5.43e-17 | NR | XP_013233496.1 | 5802 | g24382 | i0 | 55.6 | 2.73134328358209 | 63 | 28 | 94 | 0 | 2 | 190 | 279 | 341 | XP_013233496.1 AT4g18900/F13C5_70, related [Eimeria tenella] | diamond | 549 | 83.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 32421435 | 32421435 | PRJNA674308_P_NODE_8119_length_334_cov_1.989474_g7884_i0 | PRJNA674308 | 8119 | 334 | 1.989474 | 6.64484316 | Hepatocystis sp. ex Piliocolobus tephrosceles | 2600580 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0285 | NR | VWU48884.1 | 2600580 | g7884 | i0 | 32.9 | 0.62874251497006 | 70 | 38 | 62.9 | 2 | 23 | 232 | 247 | 307 | VWU48884.1 RNA-binding protein musashi, putative [Hepatocystis sp. ex Piliocolobus tephrosceles] | diamond | 210 | 44.3 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Hepatocystis | Hepatocystis sp. ex Piliocolobus tephrosceles |
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);;