contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA781196" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6315272 | 6315272 | PRJNA781196_P_NODE_36725_length_293_cov_1.922727_g36348_i0 | PRJNA781196 | 36725 | 293 | 1.922727 | 5.63359011 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 1.13e-38 | NR | XP_067197041.1 | 515981 | g36348 | i0 | 81.3 | 8.31399317406143 | 80 | 15 | 81.9 | 0 | 245 | 6 | 1 | 80 | XP_067197041.1 uncharacterized protein FG386_000852 [Cryptosporidium ryanae] | diamond | 2436 | 143 | 0.993006993006993 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae | ||
| 16061796 | 16061796 | PRJNA781196_P_NODE_37853_length_290_cov_1.009217_g37476_i0 | PRJNA781196 | 37853 | 290 | 1.009217 | 2.9267293 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 8.49e-29 | NR | OEH73979.1 | 88456 | g37476 | i0 | 68.8 | 0.827586206896552 | 80 | 24 | 82.8 | 1 | 241 | 2 | 218 | 296 | OEH73979.1 iron-sulfur subunit of succinate [Cyclospora cayetanensis] | diamond | 240 | 115 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 17337552 | 17337552 | PRJNA781196_P_NODE_39794_length_283_cov_4.209524_g39417_i0 | PRJNA781196 | 39794 | 283 | 4.209524 | 11.91295292 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.02e-26 | NR | XP_067802537.1 | 323732 | g39417 | i0 | 58.9 | 2.93639575971731 | 95 | 37 | 98.6 | 1 | 281 | 3 | 3 | 97 | XP_067802537.1 Ribosomal protein S25 [Babesia duncani] | diamond | 831 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 19885744 | 19885744 | PRJNA781196_P_NODE_11436_length_478_cov_3.320988_g11060_i0 | PRJNA781196 | 11436 | 478 | 3.320988 | 15.87432264 | Sarcocystidae | 5809 | SAR_Eukaryotes | SAR_Eukaryotes | 258 | 3.08e-82 | NR | XP_003881929.1 | 572307 | g11060 | i0 | 80.5 | 6.7907949790795 | 154 | 30 | 96.7 | 0 | 16 | 477 | 12 | 165 | XP_003881929.1 S-adenosylmethionine synthetase,related [Neospora caninum Liverpool] | diamond | 3246 | 259 | 0.996138996138996 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 21613564 | 21613564 | PRJNA781196_P_NODE_65277_length_243_cov_0.917647_g64900_i0 | PRJNA781196 | 65277 | 243 | 0.917647 | 2.22988221 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 8.629999999999999e-37 | NR | XP_003881929.1 | 572307 | g64900 | i0 | 82.9 | 24.8024691358025 | 76 | 13 | 93.8 | 0 | 228 | 1 | 12 | 87 | XP_003881929.1 S-adenosylmethionine synthetase,related [Neospora caninum Liverpool] | diamond | 6027 | 137 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 27315950 | 27315950 | PRJNA781196_P_NODE_53943_length_251_cov_0.876404_g53566_i0 | PRJNA781196 | 53943 | 251 | 0.876404 | 2.19977404 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 2.95e-40 | NR | AET50562.1 | 5802 | g53566 | i0 | 76.8 | 6.8605577689243 | 82 | 19 | 98 | 0 | 251 | 6 | 78 | 159 | AET50562.1 hypothetical protein [Eimeria tenella] | diamond | 1722 | 140 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 27663288 | 27663288 | PRJNA781196_P_NODE_29764_length_321_cov_1.572581_g29387_i0 | PRJNA781196 | 29764 | 321 | 1.572581 | 5.04798501 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 3.78e-10 | NR | CDI74584.1 | 51316 | g29387 | i0 | 40 | 4.31775700934579 | 90 | 48 | 84.1 | 2 | 27 | 296 | 163 | 246 | CDI74584.1 thioredoxin, putative [Eimeria praecox] | diamond | 1386 | 67 | 0.994029850746269 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria praecox | ||
| 28862832 | 28862832 | PRJNA781196_P_NODE_64008_length_244_cov_0.912281_g63631_i0 | PRJNA781196 | 64008 | 244 | 0.912281 | 2.22596564 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 6.62e-7 | NR | XP_034422903.1 | 5823 | g63631 | i0 | 32.1 | 3.98360655737705 | 81 | 49 | 99.6 | 1 | 1 | 243 | 344 | 418 | XP_034422903.1 plasmepsin X, putative [Plasmodium berghei ANKA] | diamond | 972 | 56.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 29611077 | 29611077 | PRJNA781196_P_NODE_64950_length_243_cov_0.917647_g64573_i0 | PRJNA781196 | 64950 | 243 | 0.917647 | 2.22988221 | Theileria equi strain WA | 1537102 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00263 | NR | XP_004828991.1 | 1537102 | g64573 | i0 | 30.9 | 1 | 81 | 55 | 100 | 1 | 243 | 1 | 149 | 228 | XP_004828991.1 signal peptide-containing protein [Theileria equi strain WA] | diamond | 243 | 45.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 31706389 | 31706389 | PRJNA781196_P_NODE_59257_length_247_cov_0.896552_g58880_i0 | PRJNA781196 | 59257 | 247 | 0.896552 | 2.21448344 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0151 | NR | KOB87390.1 | 57267 | g58880 | i0 | 43.2 | 1.60323886639676 | 44 | 21 | 48.6 | 1 | 213 | 94 | 352 | 395 | KOB87390.1 hypothetical protein PFDG_03457 [Plasmodium falciparum Dd2] | diamond | 396 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 32117776 | 32117776 | PRJNA781196_P_NODE_26558_length_336_cov_1.779468_g26181_i0 | PRJNA781196 | 26558 | 336 | 1.779468 | 5.97901248 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 3.66e-15 | NR | XP_028533357.1 | 85471 | g26181 | i0 | 53.5 | 12.4732142857143 | 86 | 36 | 73.2 | 2 | 255 | 10 | 2187 | 2272 | XP_028533357.1 formin 1, putative [Plasmodium relictum] | diamond | 4191 | 81.6 | 0.996323529411765 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum |
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);;