contig_metadata
22 rows where bioproject = "PRJNA493244" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4284176 | 4284176 | PRJNA493244_P_NODE_515904_length_713_cov_13.671779_g495507_i0 | PRJNA493244 | 515904 | 713 | 13.671779 | 97.47978427 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 4.03e-44 | NTclustered | gi|2560612139|gb|OR419798.1| | 5807 | g495507 | i0 | 84.422 | 24.741935483871 | 199 | 27 | 28 | 4 | 8 | 204 | 3983 | 3787 | Cryptosporidium parvum small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 17641 | 193 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 6203130 | 6203130 | PRJNA493244_P_NODE_1684865_length_205_cov_4.625000_g1661740_i0 | PRJNA493244 | 1684865 | 205 | 4.625 | 9.48125 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.018 | NTclustered | gi|1145260673|ref|XM_012908331.2| | 5854 | g1661740 | i0 | 100 | 0.712195121951219 | 28 | 0 | 14 | 0 | 121 | 148 | 1156 | 1129 | Plasmodium reichenowi protein phosphatase 2C partial mRNA | blastn | 146 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 6833877 | 6833877 | PRJNA493244_P_NODE_1660706_length_208_cov_2.612245_g1637581_i0 | PRJNA493244 | 1660706 | 208 | 2.612245 | 5.4334696 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 2.32e-11 | NTclustered | gi|2592695277|gb|CP131979.1| | 5833 | g1637581 | i0 | 87.5 | 43.2307692307692 | 72 | 7 | 34 | 2 | 93 | 163 | 26351 | 26281 | Plasmodium falciparum strain W2 apicoplast, complete genome | blastn | 8992 | 82.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 7478227 | 7478227 | PRJNA493244_P_NODE_915726_length_446_cov_1.974026_g892747_i0 | PRJNA493244 | 915726 | 446 | 1.974026 | 8.80415596 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 2.4899999999999996e-29 | NTclustered | gi|1270519481|ref|XM_022955661.1| | 5861 | g892747 | i0 | 75.155 | 4.17264573991031 | 322 | 70 | 71 | 8 | 130 | 446 | 2087 | 1771 | Plasmodium yoelii heat shock protein 90, putative (PY17X_0808800), partial mRNA | blastn | 1861 | 143 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 10658755 | 10658755 | PRJNA493244_P_NODE_115269_length_1459_cov_19.281116_g107485_i0 | PRJNA493244 | 115269 | 1459 | 19.281116 | 281.31148244 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 6.87e-10 | NTclustered | gi|1270518705|ref|XM_022955346.1| | 5861 | g107485 | i0 | 84.706 | 0.337217272104181 | 85 | 7 | 6 | 3 | 865 | 946 | 1263 | 1182 | Plasmodium yoelii high mobility group protein B3, putative (PY17X_0607000), partial mRNA | blastn | 492 | 80.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 10661065 | 10661065 | PRJNA493244_P_NODE_637629_length_612_cov_3.343013_g615761_i0 | PRJNA493244 | 637629 | 612 | 3.343013 | 20.45923956 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.017 | NTclustered | gi|1084792884|ref|XM_018784333.1| | 647221 | g615761 | i0 | 96.97 | 0.053921568627451 | 33 | 0 | 5 | 1 | 373 | 404 | 1181 | 1149 | Plasmodium gaboni UDP-N-acetyl glucosamine:UMP antiporter partial mRNA | blastn | 33 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 11934147 | 11934147 | PRJNA493244_P_NODE_1395670_length_269_cov_3.403846_g1372545_i0 | PRJNA493244 | 1395670 | 269 | 3.403846 | 9.15634574 | Anthozoaphila gnarlus | 2783686 | SAR_Eukaryotes | SAR_Eukaryotes | 71.3 | 6.8e-8 | NTclustered | gi|2887160894|gb|PQ872229.1| | 2783686 | g1372545 | i0 | 88.333 | 13.1338289962825 | 60 | 6 | 22 | 1 | 207 | 265 | 316 | 375 | Anthozoaphila gnarlus isolate GZ0315 large subunit ribosomal RNA gene, partial sequence | blastn | 3533 | 71.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Corallicolida | Corallicolidae | Anthozoaphila | Anthozoaphila gnarlus | ||
| 11934550 | 11934550 | PRJNA493244_P_NODE_1553790_length_230_cov_5.763314_g1530665_i0 | PRJNA493244 | 1553790 | 230 | 5.763314 | 13.2556222 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.021 | NTclustered | gi|916512336|ref|XM_013500880.1| | 44415 | g1530665 | i0 | 100 | 0.121739130434783 | 28 | 0 | 12 | 0 | 182 | 209 | 824 | 851 | Eimeria mitis SWI/SNF-related matrix-associated actin-dependent regulator of chromatin, putative (EMH_0084120), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 13209018 | 13209018 | PRJNA493244_P_NODE_1278551_length_303_cov_2.867769_g1255427_i0 | PRJNA493244 | 1278551 | 303 | 2.867769 | 8.68934007 | Theileria parva | 5875 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.028 | NTclustered | gi|2626849155|ref|XM_759803.2| | 333668 | g1255427 | i0 | 100 | 0.0924092409240924 | 28 | 0 | 9 | 0 | 205 | 232 | 766 | 739 | Theileria parva strain Muguga emp24/gp25L/p24 family/GOLD family protein (TpMuguga_02g00330), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria parva | ||
| 13853596 | 13853596 | PRJNA493244_P_NODE_1718331_length_201_cov_15.285714_g1695206_i0 | PRJNA493244 | 1718331 | 201 | 15.285714 | 30.72428514 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.04e-4 | NTclustered | gi|187936413|gb|EU676365.1| | 526370 | g1695206 | i0 | 100 | 202.039800995025 | 32 | 0 | 16 | 0 | 1 | 32 | 227 | 258 | Cryptosporidium sp. cat104 18S ribosomal RNA gene, partial sequence | blastn | 40610 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. cat104 | ||
| 16402693 | 16402693 | PRJNA493244_P_NODE_685273_length_578_cov_6.791103_g663081_i0 | PRJNA493244 | 685273 | 578 | 6.791103 | 39.25257534 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 6.93e-46 | NTclustered | gi|505337|gb|L34027.1|PFAHSP86A | 5833 | g663081 | i0 | 81.452 | 6.5795847750865 | 248 | 40 | 43 | 5 | 2 | 247 | 2955 | 2712 | Plasmodium falciparum (clone Dd2) heat shock protein 86 gene, complete cds | blastn | 3803 | 198 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 18951524 | 18951524 | PRJNA493244_P_NODE_1717215_length_202_cov_0.907801_g1694090_i0 | PRJNA493244 | 1717215 | 202 | 0.907801 | 1.83375802 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|1084885422|ref|XM_018786694.1| | 647221 | g1694090 | i0 | 90.698 | 0.356435643564356 | 43 | 1 | 20 | 1 | 130 | 169 | 1378 | 1336 | Plasmodium gaboni putative zinc finger protein partial mRNA | blastn | 72 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 19582263 | 19582263 | PRJNA493244_P_NODE_1714736_length_202_cov_0.907801_g1691611_i0 | PRJNA493244 | 1714736 | 202 | 0.907801 | 1.83375802 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 187 | 4.62e-43 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g1691611 | i0 | 83.663 | 10.6633663366337 | 202 | 30 | 100 | 2 | 1 | 202 | 146 | 344 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 2154 | 187 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 19582476 | 19582476 | PRJNA493244_P_NODE_211756_length_1153_cov_25.962454_g199538_i0 | PRJNA493244 | 211756 | 1153 | 25.962454 | 299.34709462 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 1766 | 0 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g199538 | i0 | 95.963 | 1486.73547267997 | 1090 | 40 | 94 | 4 | 67 | 1153 | 1914 | 826 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 1714206 | 1766 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 20858491 | 20858491 | PRJNA493244_P_NODE_316697_length_952_cov_9.815937_g300747_i0 | PRJNA493244 | 316697 | 952 | 9.815937 | 93.44772024 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.027 | NTclustered | gi|915138890|ref|XM_013481593.1| | 5804 | g300747 | i0 | 94.286 | 0.0367647058823529 | 35 | 2 | 4 | 0 | 295 | 329 | 1932 | 1898 | Eimeria maxima Tyrosine kinase-like (TKL) protein, putative partial mRNA | blastn | 35 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 22132435 | 22132435 | PRJNA493244_P_NODE_1547958_length_232_cov_1.421053_g1524833_i0 | PRJNA493244 | 1547958 | 232 | 1.421053 | 3.29684296 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 6.66e-82 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g1524833 | i0 | 92.105 | 23.9655172413793 | 228 | 13 | 98 | 4 | 1 | 228 | 68 | 290 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 5560 | 316 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 22133214 | 22133214 | PRJNA493244_P_NODE_257538_length_1055_cov_7.849095_g199538_i1 | PRJNA493244 | 257538 | 1055 | 7.849095 | 82.80795225 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 1757 | 0 | NTclustered | gi|1624698158|ref|XM_029013947.1| | 189622 | g199538 | i1 | 96.78 | 926.789573459716 | 1056 | 29 | 99 | 3 | 1 | 1053 | 1217 | 164 | Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA | blastn | 977763 | 1757 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 24682103 | 24682103 | PRJNA493244_P_NODE_1621040_length_216_cov_1.522581_g1597915_i0 | PRJNA493244 | 1621040 | 216 | 1.522581 | 3.28877496 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 2.83e-85 | NTclustered | gi|1624698156|ref|XM_029013946.1| | 189622 | g1597915 | i0 | 94.419 | 30.4537037037037 | 215 | 9 | 99 | 3 | 1 | 215 | 490 | 279 | Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA | blastn | 6578 | 327 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 24683249 | 24683249 | PRJNA493244_P_NODE_619780_length_625_cov_10.097518_g598063_i0 | PRJNA493244 | 619780 | 625 | 10.097518 | 63.1094875 | Cystoisospora felis | 482539 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 9.879999999999999e-35 | NTclustered | gi|3323386|gb|U85705.1|IFU85705 | 482539 | g598063 | i0 | 92.105 | 18.2336 | 114 | 9 | 18 | 0 | 191 | 304 | 2037 | 1924 | Isospora felis 28S large subunit ribosomal RNA gene, complete sequence | blastn | 11396 | 161 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora felis | ||
| 27313856 | 27313856 | PRJNA493244_P_NODE_446403_length_783_cov_53.458449_g427242_i0 | PRJNA493244 | 446403 | 783 | 53.458449 | 418.57965567 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 2.41e-20 | NR | OLQ18173.1 | 237895 | g427242 | i0 | 44.2 | 4.95785440613027 | 120 | 60 | 43.3 | 1 | 750 | 412 | 1 | 120 | OLQ18173.1 ribosomal protein S10 [Cryptosporidium hominis] | diamond | 3882 | 97.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium hominis | ||
| 27992555 | 27992555 | PRJNA493244_P_NODE_1345345_length_283_cov_5.009009_g1322221_i0 | PRJNA493244 | 1345345 | 283 | 5.009009 | 14.17549547 | Cryptosporidium bovis | 310047 | SAR_Eukaryotes | SAR_Eukaryotes | 43.9 | 0.0238 | NR | XP_067181760.1 | 310047 | g1322221 | i0 | 46.2 | 0.551236749116608 | 52 | 26 | 53 | 1 | 159 | 10 | 370 | 421 | XP_067181760.1 interaptin [Cryptosporidium bovis] | diamond | 156 | 43.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium bovis | ||
| 32115701 | 32115701 | PRJNA493244_P_NODE_1325238_length_289_cov_2.570175_g1302114_i0 | PRJNA493244 | 1325238 | 289 | 2.570175 | 7.42780575 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 4.28e-9 | NR | XP_067924299.1 | 483139 | g1302114 | i0 | 58.2 | 5.06574394463668 | 55 | 20 | 54 | 1 | 194 | 39 | 121 | 175 | XP_067924299.1 ribosomal protein rpl23a [Cystoisospora suis] | diamond | 1464 | 61.2 | 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);;