contig_metadata
16 rows where bioproject = "PRJNA685607" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2451774 | 2451774 | PRJNA685607_P_NODE_8302_length_536_cov_1.976242_g7947_i0 | PRJNA685607 | 8302 | 536 | 1.976242 | 10.59265712 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 221 | 1.53e-70 | NR | XP_013233901.1 | 5802 | g7947 | i0 | 65.2 | 2.87686567164179 | 178 | 46 | 90.7 | 1 | 5 | 490 | 3 | 180 | XP_013233901.1 40S ribosomal protein S9, putative [Eimeria tenella] | diamond | 1542 | 221 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 7045012 | 7045012 | PRJNA685607_P_NODE_55646_length_267_cov_1.587629_g55287_i0 | PRJNA685607 | 55646 | 267 | 1.587629 | 4.23896943 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 1.97e-32 | NR | XP_001615922.1 | 5855 | g55287 | i0 | 70.5 | 26.7303370786517 | 88 | 23 | 98.9 | 1 | 266 | 3 | 49 | 133 | XP_001615922.1 40S ribosomal protein S2, putative [Plasmodium vivax] | diamond | 7137 | 124 | 0.991935483870968 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 8829408 | 8829408 | PRJNA685607_P_NODE_72007_length_249_cov_0.875000_g71648_i0 | PRJNA685607 | 72007 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 7.55e-52 | NTclustered | gi|6138832|emb|AJ133813.1| | 36329 | g71648 | i0 | 90.741 | 98.421686746988 | 162 | 15 | 65 | 0 | 83 | 244 | 982 | 821 | Plasmodium falciparum pub gene, exons 1-2 | blastn | 24507 | 217 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 13420210 | 13420210 | PRJNA685607_P_NODE_2031_length_1130_cov_3.278146_g1810_i0 | PRJNA685607 | 2031 | 1130 | 3.278146 | 37.0430498 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 771 | 0 | NTclustered | gi|124806844|ref|XM_001350811.1| | 36329 | g1810 | i0 | 79.412 | 92.0132743362832 | 1122 | 207 | 98 | 20 | 21 | 1130 | 9 | 1118 | Plasmodium falciparum 3D7 actin I (PF3D7_1246200), partial mRNA | blastn | 103975 | 771 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 14695275 | 14695275 | PRJNA685607_P_NODE_44032_length_290_cov_1.419355_g43673_i0 | PRJNA685607 | 44032 | 290 | 1.419355 | 4.1161295 | Plasmodium ovale curtisi | 864141 | SAR_Eukaryotes | SAR_Eukaryotes | 166 | 1.52e-45 | NR | SBS86654.1 | 864141 | g43673 | i0 | 83.2 | 3.93103448275862 | 95 | 16 | 98.3 | 0 | 290 | 6 | 309 | 403 | SBS86654.1 elongation factor 2, putative (eEF2) [Plasmodium ovale curtisi] | diamond | 1140 | 166 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 18518512 | 18518512 | PRJNA685607_P_NODE_74375_length_248_cov_0.880000_g74016_i0 | PRJNA685607 | 74375 | 248 | 0.88 | 2.1824 | Eimeria necatrix | 51315 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|921124553|ref|XM_013581433.1| | 51315 | g74016 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 169 | 196 | 2078 | 2105 | Eimeria necatrix hypothetical protein, conserved partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria necatrix | ||
| 19793316 | 19793316 | PRJNA685607_P_NODE_66276_length_251_cov_0.865169_g65917_i0 | PRJNA685607 | 66276 | 251 | 0.865169 | 2.17157419 | Theileria equi | 5872 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 2.26e-7 | NTclustered | gi|510907572|ref|XM_004831870.1| | 1537102 | g65917 | i0 | 93.478 | 0.183266932270916 | 46 | 3 | 18 | 0 | 1 | 46 | 441 | 486 | Theileria equi strain WA 60S ribosomal protein L19, putative (BEWA_049420), mRNA | blastn | 46 | 69.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 26892591 | 26892591 | PRJNA685607_P_NODE_53661_length_271_cov_1.358586_g53302_i0 | PRJNA685607 | 53661 | 271 | 1.358586 | 3.68176806 | Gregarina niphandrodes | 110365 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 6.79e-14 | NR | XP_011129685.1 | 110365 | g53302 | i0 | 43.6 | 2.03690036900369 | 94 | 47 | 99.6 | 2 | 271 | 2 | 11 | 102 | XP_011129685.1 putative 3-oxo-5-alpha-steroid 4-dehydrogenase [Gregarina niphandrodes] | diamond | 552 | 75.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina niphandrodes | ||
| 29292691 | 29292691 | PRJNA685607_P_NODE_74189_length_248_cov_0.880000_g73830_i0 | PRJNA685607 | 74189 | 248 | 0.88 | 2.1824 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.35e-9 | NR | XP_067921921.1 | 483139 | g73830 | i0 | 70.7 | 0.495967741935484 | 41 | 12 | 49.6 | 0 | 123 | 1 | 72 | 112 | XP_067921921.1 polyadenylate binding protein [Cystoisospora suis] | diamond | 123 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 29513567 | 29513567 | PRJNA685607_P_NODE_60970_length_257_cov_2.923913_g60611_i0 | PRJNA685607 | 60970 | 257 | 2.923913 | 7.51445641 | Cryptosporidium ryanae | 515981 | SAR_Eukaryotes | SAR_Eukaryotes | 56.2 | 1.44e-7 | NR | XP_067195571.1 | 515981 | g60611 | i0 | 45.3 | 0.875486381322957 | 75 | 38 | 86.4 | 2 | 224 | 3 | 6 | 78 | XP_067195571.1 uncharacterized protein FG386_001935 [Cryptosporidium ryanae] | diamond | 225 | 56.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae | ||
| 29904345 | 29904345 | PRJNA685607_P_NODE_84571_length_245_cov_0.895349_g84212_i0 | PRJNA685607 | 84571 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 3.32e-14 | NR | XP_013246550.1 | 5801 | g84212 | i0 | 52.7 | 3.7469387755102 | 74 | 30 | 90.6 | 1 | 245 | 24 | 171 | 239 | XP_013246550.1 40S ribosomal protein S0-A, putative [Eimeria acervulina] | diamond | 918 | 76.6 | 0.990861618798956 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 30524539 | 30524539 | PRJNA685607_P_NODE_49233_length_280_cov_1.111111_g48874_i0 | PRJNA685607 | 49233 | 280 | 1.111111 | 3.1111108 | Cryptosporidium muris RN66 | 441375 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 1.03e-33 | NR | XP_002141581.1 | 441375 | g48874 | i0 | 60.2 | 6.95357142857143 | 93 | 37 | 99.6 | 0 | 280 | 2 | 3 | 95 | XP_002141581.1 40S ribosomal protein S18, putative [Cryptosporidium muris RN66] | diamond | 1947 | 123 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 30935406 | 30935406 | PRJNA685607_P_NODE_59374_length_260_cov_1.973262_g59015_i0 | PRJNA685607 | 59374 | 260 | 1.973262 | 5.1304812 | Toxoplasma gondii ME49 | 508771 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 6.19e-17 | NR | XP_018635543.1 | 508771 | g59015 | i0 | 58.8 | 2.36538461538462 | 68 | 27 | 77.3 | 1 | 60 | 260 | 83 | 150 | XP_018635543.1 vacuolar atp synthase subunit f, putative [Toxoplasma gondii ME49] | diamond | 615 | 81.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 31042001 | 31042001 | PRJNA685607_P_NODE_60495_length_258_cov_1.664865_g60136_i0 | PRJNA685607 | 60495 | 258 | 1.664865 | 4.2953517 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 7.49e-12 | NR | ETW58926.1 | 5835 | g60136 | i0 | 66.7 | 24.0232558139535 | 45 | 15 | 52.3 | 0 | 135 | 1 | 3 | 47 | ETW58926.1 serine/threonine-protein phosphatase PP1-gamma catalytic subunit [Plasmodium falciparum CAMP/Malaysia] | diamond | 6198 | 69.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 32516967 | 32516967 | PRJNA685607_P_NODE_97099_length_241_cov_0.892857_g96740_i0 | PRJNA685607 | 97099 | 241 | 0.892857 | 2.15178537 | Porospora cf. gigantea A | 2853593 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 9.57e-13 | NR | XP_067812164.1 | 2853593 | g96740 | i0 | 46.3 | 0.995850622406639 | 80 | 42 | 99.6 | 1 | 2 | 241 | 661 | 739 | XP_067812164.1 MAG: uncharacterized protein KVP18_004473 [Porospora cf. gigantea A] | diamond | 240 | 72.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea A | ||
| 32717459 | 32717459 | PRJNA685607_P_NODE_31560_length_325_cov_0.801587_g31201_i0 | PRJNA685607 | 31560 | 325 | 0.801587 | 2.60515775 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 5.71e-28 | NR | CDJ51277.1 | 51314 | g31201 | i0 | 60.2 | 11.9538461538462 | 98 | 38 | 89.5 | 1 | 3 | 293 | 625 | 722 | CDJ51277.1 heat shock protein 90, putative [Eimeria brunetti] | diamond | 3885 | 118 | 0.991525423728814 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria brunetti |
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);;