contig_metadata
11 rows where bioproject = "PRJNA274362" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4886502 | 4886502 | PRJNA274362_S_NODE_18644_length_212_cov_1.276074_g18524_i0 | PRJNA274362 | 18644 | 212 | 1.276074 | 2.70527688 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 1.84e-12 | NTclustered | gi|833484291|ref|XM_012911757.1| | 5866 | g18524 | i0 | 96.154 | 10.8301886792453 | 52 | 2 | 25 | 0 | 88 | 139 | 228 | 279 | Babesia bigemina 60S ribosomal L22e protein, putative partial mRNA | blastn | 2296 | 86.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 27217944 | 27217944 | PRJNA274362_S_NODE_21062_length_202_cov_1.019608_g20942_i0 | PRJNA274362 | 21062 | 202 | 1.019608 | 2.05960816 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 9.37e-16 | NR | XP_067067485.1 | 117008 | g20942 | i0 | 63.9 | 2.73267326732673 | 61 | 20 | 87.6 | 1 | 177 | 1 | 7 | 67 | XP_067067485.1 60s ribosomal protein L35A [Cryptosporidium andersoni] | diamond | 552 | 75.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 27344854 | 27344854 | PRJNA274362_S_NODE_24903_length_189_cov_0.871429_g24783_i0 | PRJNA274362 | 24903 | 189 | 0.871429 | 1.64700081 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 3.19e-20 | NR | BAN66151.1 | 5865 | g24783 | i0 | 69.4 | 12.8571428571429 | 62 | 19 | 98.4 | 0 | 187 | 2 | 3 | 64 | BAN66151.1 40S ribosomal protein S8 [Babesia bovis] | diamond | 2430 | 89 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 29063677 | 29063677 | PRJNA274362_S_NODE_25368_length_187_cov_1.130435_g25248_i0 | PRJNA274362 | 25368 | 187 | 1.130435 | 2.11391345 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 1.93e-13 | NR | XP_029221480.1 | 94643 | g25248 | i0 | 59 | 2.93582887700535 | 61 | 25 | 97.9 | 0 | 3 | 185 | 115 | 175 | XP_029221480.1 ribosomal protein RPP0 [Besnoitia besnoiti] | diamond | 549 | 73.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 29112933 | 29112933 | PRJNA274362_S_NODE_36868_length_163_cov_0.903509_g36748_i0 | PRJNA274362 | 36868 | 163 | 0.903509 | 1.47271967 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 1.69e-17 | NR | XP_067924711.1 | 483139 | g36748 | i0 | 72.5 | 8.39263803680982 | 51 | 14 | 93.9 | 0 | 9 | 161 | 99 | 149 | XP_067924711.1 60s ribosomal protein [Cystoisospora suis] | diamond | 1368 | 80.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 30642628 | 30642628 | PRJNA274362_S_NODE_1893_length_585_cov_2.395522_g1784_i0 | PRJNA274362 | 1893 | 585 | 2.395522 | 14.0138037 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 8.84e-64 | NR | OEH76901.1 | 88456 | g1784 | i0 | 61 | 3.65128205128205 | 182 | 71 | 93.3 | 0 | 585 | 40 | 30 | 211 | OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] | diamond | 2136 | 206 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 31482551 | 31482551 | PRJNA274362_S_NODE_35776_length_164_cov_0.904348_g35656_i0 | PRJNA274362 | 35776 | 164 | 0.904348 | 1.48313072 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 4.57e-6 | NR | XP_067917819.1 | 483139 | g35656 | i0 | 43.6 | 5.96341463414634 | 55 | 30 | 98.8 | 1 | 3 | 164 | 200 | 254 | XP_067917819.1 translation initiation factor sui1 protein [Cystoisospora suis] | diamond | 978 | 52.8 | 0.992424242424242 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 31717559 | 31717559 | PRJNA274362_S_NODE_37477_length_162_cov_0.920354_g37357_i0 | PRJNA274362 | 37477 | 162 | 0.920354 | 1.49097348 | Eimeria brunetti | 51314 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 9.89e-8 | NR | CDJ52797.1 | 51314 | g37357 | i0 | 60.4 | 4.61111111111111 | 48 | 18 | 87 | 1 | 146 | 6 | 27 | 74 | CDJ52797.1 translationally-controlled tumor protein, putative [Eimeria brunetti] | diamond | 747 | 55.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria brunetti | ||
| 32336629 | 32336629 | PRJNA274362_S_NODE_33979_length_166_cov_1.333333_g33859_i0 | PRJNA274362 | 33979 | 166 | 1.333333 | 2.21333278 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 82 | 5.78e-18 | NR | XP_952618.1 | 5874 | g33859 | i0 | 63 | 8.7289156626506 | 54 | 20 | 97.6 | 0 | 162 | 1 | 9 | 62 | XP_952618.1 60S ribosomal protein l21, putative [Theileria annulata] | diamond | 1449 | 82 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 32413729 | 32413729 | PRJNA274362_S_NODE_38439_length_152_cov_2.233010_g38319_i0 | PRJNA274362 | 38439 | 152 | 2.23301 | 3.3941752 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 40.4 | 0.0301 | NR | CAL7860540.1 | 1344799 | g38319 | i0 | 54.3 | 0.690789473684211 | 35 | 16 | 69.1 | 0 | 151 | 47 | 73 | 107 | CAL7860540.1 unnamed protein product [Sarcocystis calchasi] | diamond | 105 | 40.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 32760681 | 32760681 | PRJNA274362_S_NODE_35140_length_165_cov_0.896552_g35020_i0 | PRJNA274362 | 35140 | 165 | 0.896552 | 1.4793108 | Theileria orientalis strain Shintoku | 869250 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 2.57e-5 | NR | XP_009690404.1 | 869250 | g35020 | i0 | 53.5 | 4.30909090909091 | 43 | 20 | 78.2 | 0 | 1 | 129 | 73 | 115 | XP_009690404.1 uncharacterized protein TOT_020000366 [Theileria orientalis strain Shintoku] | diamond | 711 | 48.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis |
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);;