contig_metadata
18 rows where bioproject = "PRJNA929522", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2180760 | 2180760 | PRJNA929522_S_NODE_8882_length_248_cov_1.760000_g8812_i0 | PRJNA929522 | 8882 | 248 | 1.76 | 4.3648 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|916498379|ref|XM_013494555.1| | 44415 | g8812 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 221 | 248 | 1163 | 1190 | Eimeria mitis NAD-dependent DNA ligase OB-fold domain containing protein, putative (EMH_0009570), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 2529107 | 2529107 | PRJNA929522_S_NODE_3742_length_349_cov_0.836957_g3672_i0 | PRJNA929522 | 3742 | 349 | 0.836957 | 2.92097993 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 6.4e-61 | NR | KAF4639249.1 | 5811 | g3672 | i0 | 75.9 | 87.730659025788 | 116 | 28 | 99.7 | 0 | 348 | 1 | 79 | 194 | KAF4639249.1 serine/threonine phosophatase PP1 [Toxoplasma gondii] | diamond | 30618 | 199 | 0.994974874371859 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 4733768 | 4733768 | PRJNA929522_S_NODE_1824_length_490_cov_1.911271_g1754_i0 | PRJNA929522 | 1824 | 490 | 1.911271 | 9.3652279 | Plasmodium vinckei | 5860 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.001 | NTclustered | gi|1931713813|ref|XM_037634927.1| | 54757 | g1754 | i0 | 100 | 0.253061224489796 | 31 | 0 | 6 | 0 | 20 | 50 | 1112 | 1082 | Plasmodium vinckei vinckei Plasmodium exported protein, unknown function (PVVCY_0301705), partial mRNA | blastn | 124 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 8906230 | 8906230 | PRJNA929522_S_NODE_2367_length_433_cov_3.950000_g2297_i0 | PRJNA929522 | 2367 | 433 | 3.95 | 17.1035 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 1.98e-65 | NR | XP_954382.1 | 5874 | g2297 | i0 | 66.2 | 8.79214780600462 | 142 | 48 | 98.4 | 0 | 432 | 7 | 29 | 170 | XP_954382.1 60S ribosomal protein l11a, putative [Theileria annulata] | diamond | 3807 | 206 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 9833227 | 9833227 | PRJNA929522_S_NODE_4248_length_332_cov_1.189189_g4178_i0 | PRJNA929522 | 4248 | 332 | 1.189189 | 3.94810748 | Plasmodium cynomolgi | 5827 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 8.219999999999999e-43 | NTclustered | gi|457872807|ref|XM_004223275.1| | 1120755 | g4178 | i0 | 80.753 | 58.5331325301205 | 239 | 46 | 72 | 0 | 3 | 241 | 133 | 371 | Plasmodium cynomolgi strain B histone H3 (PCYB_113960) mRNA, complete cds | blastn | 19433 | 187 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium cynomolgi | ||
| 11108943 | 11108943 | PRJNA929522_S_NODE_49_length_1930_cov_7.264405_g38_i0 | PRJNA929522 | 49 | 1930 | 7.264405 | 140.2030165 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.015 | NTclustered | gi|916420131|ref|XM_013375843.1| | 5802 | g38 | i0 | 100 | 0.0155440414507772 | 30 | 0 | 2 | 0 | 196 | 225 | 2316 | 2287 | Eimeria tenella protein kinase (incomplete catalytic triad), putative (ETH_00019920), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 17830934 | 17830934 | PRJNA929522_S_NODE_3434_length_362_cov_1.636678_g3364_i0 | PRJNA929522 | 3434 | 362 | 1.636678 | 5.92477436 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.92e-49 | NTclustered | gi|1084954590|ref|XM_018783222.1| | 647221 | g3364 | i0 | 78.035 | 8.08011049723757 | 346 | 66 | 94 | 9 | 22 | 362 | 759 | 1099 | Plasmodium gaboni heat shock protein 70 partial mRNA | blastn | 2925 | 209 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 19104874 | 19104874 | PRJNA929522_S_NODE_2315_length_437_cov_6.771978_g2245_i0 | PRJNA929522 | 2315 | 437 | 6.771978 | 29.59354386 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 5.02e-61 | NTclustered | gi|160318|gb|M86865.1|PFAH2AA | 5833 | g2245 | i0 | 83.456 | 8.91533180778032 | 272 | 40 | 62 | 5 | 5 | 274 | 353 | 85 | Plasmodium falciparum histone 2A (H2A) mRNA, complete cds | blastn | 3896 | 248 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 22582428 | 22582428 | PRJNA929522_S_NODE_1558_length_527_cov_1.372247_g1488_i0 | PRJNA929522 | 1558 | 527 | 1.372247 | 7.23174169 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 412 | 2.0599999999999994e-110 | NTclustered | gi|82704988|ref|XM_721689.1| | 5861 | g1488 | i0 | 81.071 | 25.2637571157495 | 523 | 93 | 99 | 5 | 1 | 520 | 1084 | 565 | Plasmodium yoelii 26S proteasome subunit 4 protein (PY17X_1209800), partial mRNA | blastn | 13314 | 412 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 25131484 | 25131484 | PRJNA929522_S_NODE_3300_length_369_cov_1.351351_g3230_i0 | PRJNA929522 | 3300 | 369 | 1.351351 | 4.98648519 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 192 | 4.8999999999999996e-55 | NR | KAL3126822.1 | 237895 | g3230 | i0 | 78.9 | 16 | 123 | 26 | 100 | 0 | 1 | 369 | 425 | 547 | KAL3126822.1 heat shock protein Hsp70 [Cryptosporidium hominis] | diamond | 5904 | 192 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium hominis | ||
| 25479988 | 25479988 | PRJNA929522_S_NODE_8140_length_255_cov_1.230769_g8070_i0 | PRJNA929522 | 8140 | 255 | 1.230769 | 3.13846095 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.2899999999999997e-54 | NTclustered | gi|1084892469|ref|XM_018787044.1| | 647221 | g8070 | i0 | 87.692 | 41.2156862745098 | 195 | 23 | 76 | 1 | 3 | 197 | 655 | 848 | Plasmodium gaboni putative 26S protease regulatory subunit 8 partial mRNA | blastn | 10510 | 228 | 0.991228070175439 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 27150860 | 27150860 | PRJNA929522_S_NODE_2542_length_419_cov_2.049133_g2472_i0 | PRJNA929522 | 2542 | 419 | 2.049133 | 8.58586727 | Babesia gibsoni | 33632 | SAR_Eukaryotes | SAR_Eukaryotes | 57 | 2.68e-6 | NR | KAK1443829.1 | 33632 | g2472 | i0 | 75 | 0.945107398568019 | 36 | 6 | 25.8 | 1 | 312 | 419 | 344 | 376 | KAK1443829.1 translation initiation factor IF- 2 [Babesia gibsoni] | diamond | 396 | 57 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia gibsoni | ||
| 27214349 | 27214349 | PRJNA929522_S_NODE_3322_length_368_cov_1.423729_g3252_i0 | PRJNA929522 | 3322 | 368 | 1.423729 | 5.23932272 | Eimeria brunetti | 51314 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.0198 | NR | CDJ51925.1 | 51314 | g3252 | i0 | 66.7 | 0.220108695652174 | 27 | 9 | 22 | 0 | 22 | 102 | 2 | 28 | CDJ51925.1 MORN repeat-containing protein, putative [Eimeria brunetti] | diamond | 81 | 45.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria brunetti | ||
| 27411519 | 27411519 | PRJNA929522_S_NODE_2523_length_420_cov_2.394813_g2453_i0 | PRJNA929522 | 2523 | 420 | 2.394813 | 10.0582146 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1.87e-22 | NR | XP_012769318.1 | 5866 | g2453 | i0 | 57 | 2.64285714285714 | 86 | 37 | 61.4 | 0 | 344 | 87 | 518 | 603 | XP_012769318.1 RNA recognition motif domain containing protein, putative [Babesia bigemina] | diamond | 1110 | 103 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 29424730 | 29424730 | PRJNA929522_S_NODE_6549_length_279_cov_1.495146_g6479_i0 | PRJNA929522 | 6549 | 279 | 1.495146 | 4.17145734 | Cryptosporidium muris RN66 | 441375 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0173 | NR | XP_002140808.1 | 441375 | g6479 | i0 | 55.8 | 0.924731182795699 | 43 | 19 | 46.2 | 0 | 257 | 129 | 37 | 79 | XP_002140808.1 uncharacterized protein CMU_009510 [Cryptosporidium muris RN66] | diamond | 258 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium muris | ||
| 29677119 | 29677119 | PRJNA929522_S_NODE_8870_length_248_cov_2.171429_g8800_i0 | PRJNA929522 | 8870 | 248 | 2.171429 | 5.38514392 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 2.69e-18 | NR | XP_067927548.1 | 483139 | g8800 | i0 | 76.4 | 0.665322580645161 | 55 | 13 | 66.5 | 0 | 81 | 245 | 10 | 64 | XP_067927548.1 fructose- -bisphosphate [Cystoisospora suis] | diamond | 165 | 87.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 31858044 | 31858044 | PRJNA929522_S_NODE_4317_length_330_cov_0.898833_g4247_i0 | PRJNA929522 | 4317 | 330 | 0.898833 | 2.9661489 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 2.75e-24 | NR | XP_725028.1 | 5861 | g4247 | i0 | 50 | 3.93636363636364 | 108 | 50 | 98.2 | 1 | 328 | 5 | 512 | 615 | XP_725028.1 serine/threonine protein phosphatase 5, putative [Plasmodium yoelii] | diamond | 1299 | 107 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 32687196 | 32687196 | PRJNA929522_S_NODE_1840_length_488_cov_8.453012_g1770_i0 | PRJNA929522 | 1840 | 488 | 8.453012 | 41.25069856 | Eucoccidiorida | 75739 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 4e-30 | NR | XP_013251421.1 | 5801 | g1770 | i0 | 53.7 | 4.67213114754098 | 108 | 48 | 66.4 | 1 | 144 | 467 | 16 | 121 | XP_013251421.1 60s ribosomal protein L33-A, putative [Eimeria acervulina] | diamond | 2280 | 117 | 0.991452991452991 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina |
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);;