contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA743294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 721903 | 721903 | PRJNA743294_P_NODE_15441_length_408_cov_7.501493_g14985_i0 | PRJNA743294 | 15441 | 408 | 7.501493 | 30.60609144 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 4.6199999999999994e-66 | NTclustered | gi|832028945|ref|XM_012906466.1| | 5854 | g14985 | i0 | 78.713 | 21.1299019607843 | 404 | 81 | 99 | 4 | 1 | 403 | 400 | 1 | Plasmodium reichenowi histone H3, putative partial mRNA | blastn | 8621 | 265 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 1198346 | 1198346 | PRJNA743294_P_NODE_51641_length_247_cov_0.896552_g51185_i0 | PRJNA743294 | 51641 | 247 | 0.896552 | 2.21448344 | Eimeria | 5800 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|914995848|ref|XM_013391307.1| | 5801 | g51185 | i0 | 96.97 | 1.08906882591093 | 33 | 1 | 13 | 0 | 135 | 167 | 4091 | 4123 | Eimeria acervulina transcription regulatory protein SNF2, putative partial mRNA | blastn | 269 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 1998070 | 1998070 | PRJNA743294_P_NODE_34142_length_287_cov_2.593458_g33686_i0 | PRJNA743294 | 34142 | 287 | 2.593458 | 7.44322446 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|915009122|ref|XM_013395330.1| | 5801 | g33686 | i0 | 100 | 0.522648083623693 | 29 | 0 | 10 | 0 | 255 | 283 | 3142 | 3170 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 150 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 8375466 | 8375466 | PRJNA743294_P_NODE_47287_length_252_cov_0.871508_g46831_i0 | PRJNA743294 | 47287 | 252 | 0.871508 | 2.19620016 | Babesia ovata | 189622 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|1624689438|ref|XM_029009594.1| | 189622 | g46831 | i0 | 96.875 | 0.126984126984127 | 32 | 1 | 13 | 0 | 23 | 54 | 851 | 820 | Babesia ovata RNA recognition motif-containing protein (BOVATA_006770), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovata | ||
| 10925958 | 10925958 | PRJNA743294_P_NODE_31949_length_295_cov_2.810811_g31493_i0 | PRJNA743294 | 31949 | 295 | 2.810811 | 8.29189245 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 8.98e-67 | NTclustered | gi|1084839774|ref|XM_018785426.1| | 647221 | g31493 | i0 | 83.448 | 89.1728813559322 | 290 | 44 | 98 | 3 | 1 | 288 | 507 | 794 | Plasmodium gaboni heat shock protein 70 partial mRNA | blastn | 26306 | 267 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 10926029 | 10926029 | PRJNA743294_P_NODE_39769_length_269_cov_2.540816_g39313_i0 | PRJNA743294 | 39769 | 269 | 2.540816 | 6.83479504 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 8.8e-7 | NTclustered | gi|1844516988|ref|XM_719929.3| | 5861 | g39313 | i0 | 100 | 0.241635687732342 | 36 | 0 | 13 | 0 | 41 | 76 | 1767 | 1732 | Plasmodium yoelii uncharacterized protein (PY17X_1224000), partial mRNA | blastn | 65 | 67.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 12677957 | 12677957 | PRJNA743294_P_NODE_55070_length_243_cov_1.741176_g54614_i0 | PRJNA743294 | 55070 | 243 | 1.741176 | 4.23105768 | Haemosporida | 5819 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 1.66e-18 | NTclustered | gi|1372150224|gb|MF508356.1| | 27989 | g54614 | i0 | 81.203 | 6.19753086419753 | 133 | 23 | 54 | 2 | 40 | 171 | 507 | 376 | Plasmodium mexicanum isolate 23003 putative eukaryotic translation initiation factor 2 gamma subunit gene, partial cds | blastn | 1506 | 106 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium mexicanum | ||
| 12677978 | 12677978 | PRJNA743294_P_NODE_9930_length_501_cov_4.144860_g9474_i0 | PRJNA743294 | 9930 | 501 | 4.14486 | 20.7657486 | Gregarina | 35089 | SAR_Eukaryotes | SAR_Eukaryotes | 673 | 0 | NTclustered | gi|241739987|gb|FJ459741.1| | 650275 | g9474 | i0 | 96.35 | 80.686626746507 | 411 | 11 | 82 | 4 | 92 | 500 | 676 | 1084 | Gregarina blattarum small subunit ribosomal RNA gene, partial sequence | blastn | 40424 | 678 | 0.992625368731563 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eugregarinorida | Gregarinidae | Gregarina | Gregarina blattarum | ||
| 14751037 | 14751037 | PRJNA743294_P_NODE_4492_length_717_cov_2.925466_g4078_i0 | PRJNA743294 | 4492 | 717 | 2.925466 | 20.97559122 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 3.29e-10 | NTclustered | gi|1472918735|ref|XM_026334853.1| | 88456 | g4078 | i0 | 89.231 | 0.0906555090655509 | 65 | 6 | 9 | 1 | 327 | 391 | 687 | 624 | PREDICTED: Cyclospora cayetanensis vacuolar protein sorting-associated protein 26 (LOC34622685), mRNA | blastn | 65 | 80.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 14751044 | 14751044 | PRJNA743294_P_NODE_45472_length_254_cov_3.729282_g45016_i0 | PRJNA743294 | 45472 | 254 | 3.729282 | 9.47237628 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|1673125596|ref|XM_029365635.1| | 94643 | g45016 | i0 | 100 | 0.110236220472441 | 28 | 0 | 11 | 0 | 179 | 206 | 526 | 553 | Besnoitia besnoiti uncharacterized protein (BESB_072620), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 17300314 | 17300314 | PRJNA743294_P_NODE_48914_length_250_cov_0.881356_g48458_i0 | PRJNA743294 | 48914 | 250 | 0.881356 | 2.20339 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.76e-5 | NTclustered | gi|1027955510|ref|XM_732195.2| | 31271 | g48458 | i0 | 92.857 | 0.168 | 42 | 3 | 17 | 0 | 209 | 250 | 413 | 372 | Plasmodium chabaudi chabaudi calmodulin, putative (PCHAS_1011500), partial mRNA | blastn | 42 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 17776061 | 17776061 | PRJNA743294_P_NODE_35914_length_281_cov_2.581731_g35458_i0 | PRJNA743294 | 35914 | 281 | 2.581731 | 7.25466411 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 9.06e-22 | NTclustered | gi|5679691|emb|AJ245475.1| | 5827 | g35458 | i0 | 86.916 | 10.3416370106762 | 107 | 11 | 38 | 3 | 174 | 280 | 1526 | 1423 | Plasmodium cynomolgi gene for RNA helicase-1 | blastn | 2906 | 117 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium cynomolgi | ||
| 18573637 | 18573637 | PRJNA743294_P_NODE_17195_length_389_cov_1.240506_g16739_i0 | PRJNA743294 | 17195 | 389 | 1.240506 | 4.82556834 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.01 | NTclustered | gi|915130008|ref|XM_013479769.1| | 5804 | g16739 | i0 | 94.286 | 0.089974293059126 | 35 | 2 | 9 | 0 | 184 | 218 | 439 | 405 | Eimeria maxima hypothetical protein partial mRNA | blastn | 35 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 18573770 | 18573770 | PRJNA743294_P_NODE_36235_length_280_cov_2.347826_g35779_i0 | PRJNA743294 | 36235 | 280 | 2.347826 | 6.5739128 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.54e-4 | NTclustered | gi|915142449|ref|XM_013482316.1| | 5804 | g35779 | i0 | 90.909 | 1.575 | 44 | 4 | 16 | 0 | 237 | 280 | 709 | 752 | Eimeria maxima exosome complex exonuclease, putative partial mRNA | blastn | 441 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 20324756 | 20324756 | PRJNA743294_P_NODE_30776_length_300_cov_2.850220_g30320_i0 | PRJNA743294 | 30776 | 300 | 2.85022 | 8.55066 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 9.69e-27 | NTclustered | gi|1673113373|ref|XM_029361935.1| | 94643 | g30320 | i0 | 91.667 | 13.5633333333333 | 96 | 8 | 32 | 0 | 41 | 136 | 1031 | 1126 | Besnoitia besnoiti ribonucleoside-diphosphate reductase small subunit (BESB_033490), partial mRNA | blastn | 4069 | 134 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 21124460 | 21124460 | PRJNA743294_P_NODE_13677_length_432_cov_1.434540_g13221_i0 | PRJNA743294 | 13677 | 432 | 1.43454 | 6.1972128 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.042 | NTclustered | gi|1673125596|ref|XM_029365635.1| | 94643 | g13221 | i0 | 100 | 0.0648148148148148 | 28 | 0 | 6 | 0 | 39 | 66 | 553 | 526 | Besnoitia besnoiti uncharacterized protein (BESB_072620), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 22399509 | 22399509 | PRJNA743294_P_NODE_33058_length_291_cov_1.885321_g32602_i0 | PRJNA743294 | 33058 | 291 | 1.885321 | 5.48628411 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.027 | NTclustered | gi|1620113768|ref|XM_028670030.1| | 5849 | g32602 | i0 | 100 | 0.0962199312714777 | 28 | 0 | 10 | 0 | 141 | 168 | 3240 | 3213 | Plasmodium gallinaceum conserved Plasmodium protein, unknown function (PGAL8A_00170900), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 22399532 | 22399532 | PRJNA743294_P_NODE_36538_length_279_cov_2.441748_g36082_i0 | PRJNA743294 | 36538 | 279 | 2.441748 | 6.81247692 | Plasmodium fragile | 5857 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.4499999999999997e-37 | NTclustered | gi|817740972|ref|XM_012480018.1| | 5857 | g36082 | i0 | 78.947 | 16.3835125448029 | 247 | 52 | 89 | 0 | 13 | 259 | 139 | 385 | Plasmodium fragile ubiquitin-60S ribosomal protein L40 (AK88_02387), partial mRNA | blastn | 4571 | 169 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium fragile | ||
| 22399740 | 22399740 | PRJNA743294_P_NODE_8638_length_535_cov_26.958874_g8182_i0 | PRJNA743294 | 8638 | 535 | 26.958874 | 144.2299759 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 3.78e-53 | NTclustered | gi|1027956776|ref|XM_016798718.1| | 31271 | g8182 | i0 | 77.632 | 32.8635514018692 | 380 | 75 | 70 | 10 | 160 | 534 | 379 | 5 | Plasmodium chabaudi chabaudi ubiquitin-60S ribosomal protein L40, putative (PCHAS_1141200), partial mRNA | blastn | 17582 | 222 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 23675004 | 23675004 | PRJNA743294_P_NODE_27319_length_316_cov_3.967078_g26863_i0 | PRJNA743294 | 27319 | 316 | 3.967078 | 12.53596648 | Theileria equi | 5872 | SAR_Eukaryotes | SAR_Eukaryotes | 75 | 6.32e-9 | NTclustered | gi|510907572|ref|XM_004831870.1| | 1537102 | g26863 | i0 | 93.878 | 0.15506329113924 | 49 | 3 | 16 | 0 | 20 | 68 | 438 | 486 | Theileria equi strain WA 60S ribosomal protein L19, putative (BEWA_049420), mRNA | blastn | 49 | 75 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria equi | ||
| 24948487 | 24948487 | PRJNA743294_P_NODE_27880_length_314_cov_0.850622_g27424_i0 | PRJNA743294 | 27880 | 314 | 0.850622 | 2.67095308 | Cryptosporidium sp. chipmunk genotype I | 1280935 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.76e-4 | NTclustered | gi|2787704753|ref|XM_067344307.1| | 1280935 | g27424 | i0 | 100 | 0.101910828025478 | 32 | 0 | 10 | 0 | 97 | 128 | 313 | 344 | Cryptosporidium sp. chipmunk genotype I kinase domain-containing (ELE39_001268), partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. chipmunk genotype I |
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);;