contig_metadata
16 rows where bioproject = "PRJEB10320", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13550 | 13550 | PRJEB10320_P_NODE_28261_length_151_cov_1.448276_g28003_i0 | PRJEB10320 | 28261 | 151 | 1.448276 | 2.18689676 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 1.5299999999999999e-31 | NTclustered | gi|1027960071|ref|XM_735127.2| | 31271 | g28003 | i0 | 86.131 | 70.9801324503311 | 137 | 19 | 91 | 0 | 3 | 139 | 1112 | 976 | Plasmodium chabaudi chabaudi actin I, putative (PCHAS_1461600), partial mRNA | blastn | 10718 | 148 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 13551 | 13551 | PRJEB10320_P_NODE_28541_length_150_cov_1.600000_g28283_i0 | PRJEB10320 | 28541 | 150 | 1.6 | 2.4 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 7.3e-5 | NTclustered | gi|1145257018|ref|XM_012906115.2| | 5854 | g28283 | i0 | 94.737 | 0.446666666666667 | 38 | 2 | 25 | 0 | 13 | 50 | 5677 | 5714 | Plasmodium reichenowi trafficking protein particle complex subunit 8, putative partial mRNA | blastn | 67 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 982431 | 982431 | PRJEB10320_P_NODE_23921_length_169_cov_1.305970_g23663_i0 | PRJEB10320 | 23921 | 169 | 1.30597 | 2.2070893 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 2.34e-5 | NTclustered | gi|916501459|ref|XM_013496090.1| | 44415 | g23663 | i0 | 100 | 5.80473372781065 | 33 | 0 | 20 | 0 | 120 | 152 | 146 | 178 | Eimeria mitis uncharacterized protein (EMH_0045670), partial mRNA | blastn | 981 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 1287775 | 1287775 | PRJEB10320_P_NODE_14522_length_241_cov_1.553398_g14264_i0 | PRJEB10320 | 14522 | 241 | 1.553398 | 3.74368918 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|401407051|ref|XM_003882926.1| | 572307 | g14264 | i0 | 96.97 | 10.8755186721992 | 33 | 1 | 14 | 0 | 135 | 167 | 428 | 396 | Neospora caninum Liverpool conserved hypothetical protein (NCLIV_027320), partial mRNA | blastn | 2621 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 3839755 | 3839755 | PRJEB10320_P_NODE_5384_length_455_cov_9.404762_g5135_i0 | PRJEB10320 | 5384 | 455 | 9.404762 | 42.7916671 | Plasmodium cynomolgi | 5827 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|457871854|ref|XM_004222799.1| | 1120755 | g5135 | i0 | 90.476 | 0.232967032967033 | 42 | 4 | 9 | 0 | 375 | 416 | 699 | 658 | Plasmodium cynomolgi strain B transcription factor with AP2 domain(s) (PCYB_102500) mRNA, complete cds | blastn | 106 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium cynomolgi | ||
| 7665767 | 7665767 | PRJEB10320_P_NODE_20107_length_192_cov_1.496815_g19849_i0 | PRJEB10320 | 20107 | 192 | 1.496815 | 2.8738848 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 2.66e-19 | NR | SBS81362.1 | 5858 | g19849 | i0 | 73.8 | 8.640625 | 61 | 15 | 95.3 | 1 | 5 | 187 | 134 | 193 | SBS81362.1 heat shock protein 90, putative (HSP90), partial [Plasmodium malariae] | diamond | 1659 | 90.5 | 0.995580110497237 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium malariae | ||
| 9910643 | 9910643 | PRJEB10320_P_NODE_8868_length_335_cov_2.170000_g8610_i0 | PRJEB10320 | 8868 | 335 | 2.17 | 7.2695 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 153 | 3.8e-45 | NR | EUD71171.1 | 138298 | g8610 | i0 | 66.7 | 9.45671641791045 | 105 | 35 | 94 | 0 | 21 | 335 | 7 | 111 | EUD71171.1 eukaryotic translation initiation factor 5A-2 [Plasmodium vinckei petteri] | diamond | 3168 | 153 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vinckei | ||
| 10216298 | 10216298 | PRJEB10320_P_NODE_20369_length_190_cov_1.548387_g20111_i0 | PRJEB10320 | 20369 | 190 | 1.548387 | 2.9419353 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 2.71e-5 | NTclustered | gi|1085116469|ref|XM_018779636.1| | 508771 | g20111 | i0 | 90 | 9.51578947368421 | 50 | 2 | 25 | 3 | 107 | 153 | 5910 | 5861 | Toxoplasma gondii ME49 Dopey, N-terminal domain-containing protein mRNA | blastn | 1808 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 20414173 | 20414173 | PRJEB10320_P_NODE_27077_length_155_cov_1.666667_g26819_i0 | PRJEB10320 | 27077 | 155 | 1.666667 | 2.58333385 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 7.62e-5 | NTclustered | gi|1620114166|ref|XM_028670251.1| | 5849 | g26819 | i0 | 97.222 | 2.66451612903226 | 36 | 0 | 23 | 1 | 68 | 103 | 3155 | 3121 | Plasmodium gallinaceum conserved protein, unknown function (PGAL8A_00390500), partial mRNA | blastn | 413 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 21690172 | 21690172 | PRJEB10320_P_NODE_24818_length_165_cov_1.230769_g24560_i0 | PRJEB10320 | 24818 | 165 | 1.230769 | 2.03076885 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 3.73e-23 | NTclustered | gi|1270522599|ref|XM_721458.2| | 5861 | g24560 | i0 | 91.011 | 19.2242424242424 | 89 | 8 | 54 | 0 | 75 | 163 | 1712 | 1624 | Plasmodium yoelii uncharacterized protein (PY17X_1242900), partial mRNA | blastn | 3172 | 121 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 26994729 | 26994729 | PRJEB10320_P_NODE_8182_length_353_cov_1.575472_g7924_i0 | PRJEB10320 | 8182 | 353 | 1.575472 | 5.56141616 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 7.3e-6 | NR | XP_953348.1 | 5874 | g7924 | i0 | 38.9 | 2.99150141643059 | 72 | 40 | 61.2 | 2 | 14 | 229 | 9 | 76 | XP_953348.1 60S ribosomal protein P1, putative [Theileria annulata] | diamond | 1056 | 52.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 30222233 | 30222233 | PRJEB10320_P_NODE_17912_length_208_cov_1.485549_g17654_i0 | PRJEB10320 | 17912 | 208 | 1.485549 | 3.08994192 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 67.4 | 2.32e-11 | NR | OEH77243.1 | 88456 | g17654 | i0 | 53.6 | 3.98076923076923 | 69 | 31 | 99.5 | 1 | 207 | 1 | 99 | 166 | OEH77243.1 DNA-directed RNA polymerase II rpb5 [Cyclospora cayetanensis] | diamond | 828 | 67.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 30311497 | 30311497 | PRJEB10320_P_NODE_17632_length_211_cov_0.943182_g17374_i0 | PRJEB10320 | 17632 | 211 | 0.943182 | 1.99011402 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 2.9e-28 | NR | AAZ06362.1 | 5811 | g17374 | i0 | 72.5 | 26.7867298578199 | 69 | 19 | 98.1 | 0 | 210 | 4 | 22 | 90 | AAZ06362.1 ATP-binding cassette sub-family E member 1 [Toxoplasma gondii] | diamond | 5652 | 116 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 30349250 | 30349250 | PRJEB10320_P_NODE_21172_length_185_cov_1.140000_g20914_i0 | PRJEB10320 | 21172 | 185 | 1.14 | 2.109 | Cryptosporidium andersoni | 117008 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 1.34e-8 | NR | XP_067069864.1 | 117008 | g20914 | i0 | 54.4 | 2.77297297297297 | 57 | 26 | 92.4 | 0 | 185 | 15 | 26 | 82 | XP_067069864.1 60s ribosomal protein L13A [Cryptosporidium andersoni] | diamond | 513 | 58.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium andersoni | ||
| 32150817 | 32150817 | PRJEB10320_P_NODE_18818_length_201_cov_1.445783_g18560_i0 | PRJEB10320 | 18818 | 201 | 1.445783 | 2.90602383 | Theileria orientalis | 68886 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 2.97e-8 | NR | UKK02333.1 | 68886 | g18560 | i0 | 61.5 | 0.582089552238806 | 39 | 15 | 58.2 | 0 | 1 | 117 | 168 | 206 | UKK02333.1 60S ribosomal protein L10 [Theileria orientalis] | diamond | 117 | 58.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria orientalis | ||
| 32246006 | 32246006 | PRJEB10320_P_NODE_26318_length_158_cov_1.609756_g26060_i0 | PRJEB10320 | 26318 | 158 | 1.609756 | 2.54341448 | Cryptosporidium parvum Iowa II | 353152 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 3.63e-14 | NR | XP_626159.1 | 353152 | g26060 | i0 | 66 | 8.44936708860759 | 50 | 17 | 94.9 | 0 | 158 | 9 | 100 | 149 | XP_626159.1 40S ribosomal protein S13, partial [Cryptosporidium parvum Iowa II] | diamond | 1335 | 72 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum |
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);;