contig_metadata
13 rows where bioproject = "PRJNA1105232", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 212574 | 212574 | PRJNA1105232_S_NODE_3681_length_299_cov_1.628000_g3465_i0 | PRJNA1105232 | 3681 | 299 | 1.628 | 4.86772 | Plasmodium cynomolgi | 5827 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 2.0299999999999993e-43 | NTclustered | gi|457872809|ref|XM_004223276.1| | 1120755 | g3465 | i0 | 79.137 | 2.42809364548495 | 278 | 54 | 92 | 4 | 14 | 289 | 342 | 67 | Plasmodium cynomolgi strain B histone H2A (PCYB_113970) mRNA, complete cds | blastn | 726 | 189 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium cynomolgi | ||
| 7865314 | 7865314 | PRJNA1105232_S_NODE_1987_length_377_cov_3.326220_g1771_i0 | PRJNA1105232 | 1987 | 377 | 3.32622 | 12.5398494 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 9.3e-53 | NTclustered | gi|1027955952|ref|XM_016798456.1| | 31271 | g1771 | i0 | 77.6 | 19.790450928382 | 375 | 76 | 98 | 8 | 5 | 375 | 917 | 547 | Plasmodium chabaudi chabaudi rRNA 2'-O-methyltransferase fibrillarin, putative (PCHAS_1035900), partial mRNA | blastn | 7461 | 220 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 9140208 | 9140208 | PRJNA1105232_S_NODE_6348_length_241_cov_2.369792_g6132_i0 | PRJNA1105232 | 6348 | 241 | 2.369792 | 5.71119872 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 4.4399999999999997e-39 | NTclustered | gi|124804503|ref|XM_001347986.1| | 36329 | g6132 | i0 | 84.659 | 48.6182572614108 | 176 | 25 | 73 | 1 | 37 | 212 | 1551 | 1378 | Plasmodium falciparum 3D7 heat shock protein 70 (PF3D7_1134000), partial mRNA | blastn | 11717 | 174 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 10416001 | 10416001 | PRJNA1105232_S_NODE_14309_length_173_cov_2.088710_g14093_i0 | PRJNA1105232 | 14309 | 173 | 2.08871 | 3.6134683 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 69.3 | 6.06e-12 | NR | KAF8819103.1 | 476202 | g14093 | i0 | 53.4 | 6.8150289017341 | 58 | 26 | 98.8 | 1 | 173 | 3 | 500 | 557 | KAF8819103.1 putative Methylenetetrahydrofolate reductase 1 [Cardiosporidium cionae] | diamond | 1179 | 69.7 | 0.994261119081779 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Nephromycida | Cardiosporidium | Cardiosporidium cionae | |||
| 12966418 | 12966418 | PRJNA1105232_S_NODE_1531_length_414_cov_6.084932_g1316_i0 | PRJNA1105232 | 1531 | 414 | 6.084932 | 25.19161848 | Sarcocystis aucheniae | 65407 | SAR_Eukaryotes | SAR_Eukaryotes | 194 | 2.579999999999999e-55 | NR | WXH59476.1 | 65407 | g1316 | i0 | 73.6 | 20.5652173913043 | 129 | 34 | 93.5 | 0 | 403 | 17 | 567 | 695 | WXH59476.1 heat shock protein 90 [Sarcocystis aucheniae] | diamond | 8514 | 194 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis aucheniae | ||
| 27825928 | 27825928 | PRJNA1105232_S_NODE_6304_length_242_cov_1.787565_g6088_i0 | PRJNA1105232 | 6304 | 242 | 1.787565 | 4.3259073 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 2.57e-15 | NR | CAL7866155.1 | 1344799 | g6088 | i0 | 56 | 5.13223140495868 | 84 | 32 | 99.2 | 3 | 2 | 241 | 771 | 853 | CAL7866155.1 unnamed protein product [Sarcocystis calchasi] | diamond | 1242 | 80.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi | ||
| 30027536 | 30027536 | PRJNA1105232_S_NODE_311_length_850_cov_8.556804_g130_i0 | PRJNA1105232 | 311 | 850 | 8.556804 | 72.732834 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 5.39e-59 | NR | UKJ90114.1 | 68886 | g130 | i0 | 57.5 | 2.53058823529412 | 174 | 66 | 59.6 | 2 | 849 | 343 | 95 | 265 | UKJ90114.1 60S ribosomal protein L5 [Theileria orientalis] | diamond | 2151 | 202 | 0.99009900990099 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 30478536 | 30478536 | PRJNA1105232_S_NODE_15073_length_169_cov_3.575000_g14857_i0 | PRJNA1105232 | 15073 | 169 | 3.575 | 6.04175 | Porospora cf. gigantea B | 2853592 | SAR_Eukaryotes | SAR_Eukaryotes | 71.6 | 7.61e-13 | NR | XP_068379002.1 | 2853592 | g14857 | i0 | 57.1 | 0.994082840236686 | 56 | 24 | 99.4 | 0 | 169 | 2 | 138 | 193 | XP_068379002.1 MAG: uncharacterized protein KVP17_005105 [Porospora cf. gigantea B] | diamond | 168 | 71.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea B | ||
| 30690826 | 30690826 | PRJNA1105232_S_NODE_16033_length_166_cov_1.777778_g15817_i0 | PRJNA1105232 | 16033 | 166 | 1.777778 | 2.95111148 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 2.02e-14 | NR | XP_013248971.1 | 5801 | g15817 | i0 | 61.8 | 5.6566265060241 | 55 | 21 | 99.4 | 0 | 166 | 2 | 465 | 519 | XP_013248971.1 endonuclease III-like protein 1, putative [Eimeria acervulina] | diamond | 939 | 76.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 31015556 | 31015556 | PRJNA1105232_S_NODE_895_length_506_cov_20.096280_g683_i0 | PRJNA1105232 | 895 | 506 | 20.09628 | 101.6871768 | Porospora cf. gigantea A | 2853593 | SAR_Eukaryotes | SAR_Eukaryotes | 223 | 2.21e-71 | NR | XP_067813754.1 | 2853593 | g683 | i0 | 68 | 6.3498023715415 | 153 | 49 | 90.7 | 0 | 505 | 47 | 19 | 171 | XP_067813754.1 MAG: uncharacterized protein KVP18_001803 [Porospora cf. gigantea A] | diamond | 3213 | 223 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Porosporidae | Porospora | Porospora cf. gigantea A | ||
| 31038755 | 31038755 | PRJNA1105232_S_NODE_16035_length_166_cov_1.777778_g15819_i0 | PRJNA1105232 | 16035 | 166 | 1.777778 | 2.95111148 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 1.41e-6 | NR | TRY53264.1 | 756076 | g15819 | i0 | 49 | 7.33734939759036 | 49 | 25 | 88.6 | 0 | 19 | 165 | 7 | 55 | TRY53264.1 60S ribosomal protein L36 [Cryptosporidium tyzzeri] | diamond | 1218 | 52 | 0.992307692307692 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium tyzzeri | ||
| 32650970 | 32650970 | PRJNA1105232_S_NODE_3520_length_305_cov_1.464844_g3304_i0 | PRJNA1105232 | 3520 | 305 | 1.464844 | 4.4677742 | Eimeria | 5800 | SAR_Eukaryotes | SAR_Eukaryotes | 47 | 0.00102 | NR | XP_013230120.1 | 5802 | g3304 | i0 | 42.4 | 1.16065573770492 | 59 | 32 | 58 | 2 | 224 | 48 | 12 | 68 | XP_013230120.1 AN1-like Zinc finger-containing protein, putative [Eimeria tenella] | diamond | 354 | 47 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 32817332 | 32817332 | PRJNA1105232_S_NODE_11960_length_187_cov_1.507246_g11744_i0 | PRJNA1105232 | 11960 | 187 | 1.507246 | 2.81855002 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 2.94e-4 | NR | XP_067918059.1 | 483139 | g11744 | i0 | 46.2 | 0.834224598930481 | 52 | 26 | 83.4 | 1 | 30 | 185 | 573 | 622 | XP_067918059.1 nucleolar phosphoprotein [Cystoisospora suis] | diamond | 156 | 47.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis |
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);;