contig_metadata
20 rows where bioproject = "PRJEB81327", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140171 | 140171 | PRJEB81327_P_NODE_62661_length_242_cov_1.366864_g62053_i0 | PRJEB81327 | 62661 | 242 | 1.366864 | 3.30781088 | Cryptosporidium ryanae | 515981 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 3.5399999999999997e-37 | NR | XP_067196179.1 | 515981 | g62053 | i0 | 78.8 | 9.91735537190083 | 80 | 17 | 99.2 | 0 | 242 | 3 | 116 | 195 | XP_067196179.1 glyceraldehyde 3-phosphate dehydrogenase [Cryptosporidium ryanae] | diamond | 2400 | 137 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium ryanae | ||
| 6517792 | 6517792 | PRJEB81327_P_NODE_18226_length_316_cov_2.666667_g17618_i0 | PRJEB81327 | 18226 | 316 | 2.666667 | 8.42666772 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 1.68e-39 | NTclustered | gi|66359883|ref|XM_627120.1| | 353152 | g17618 | i0 | 80.083 | 8.38924050632911 | 241 | 44 | 76 | 4 | 5 | 243 | 305 | 67 | Cryptosporidium parvum Iowa II histone H2A (cgd8_2170) mRNA, complete cds | blastn | 2651 | 176 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 13750715 | 13750715 | PRJEB81327_P_NODE_9611_length_443_cov_2.370270_g9003_i0 | PRJEB81327 | 9611 | 443 | 2.37027 | 10.5002961 | Babesia sp. Xinjiang | 462227 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 6.97e-45 | NR | XP_028869867.1 | 462227 | g9003 | i0 | 53.4 | 18.4198645598194 | 146 | 65 | 96.8 | 1 | 14 | 442 | 4 | 149 | XP_028869867.1 Eukaryotic translation initiation factor 5A [Babesia sp. Xinjiang] | diamond | 8160 | 154 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia sp. Xinjiang | ||
| 16299667 | 16299667 | PRJEB81327_P_NODE_35013_length_269_cov_2.586735_g34405_i0 | PRJEB81327 | 35013 | 269 | 2.586735 | 6.95831715 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.93e-61 | NTclustered | gi|2785765936|ref|XM_067218065.1| | 5824 | g34405 | i0 | 83.271 | 172.758364312268 | 269 | 45 | 100 | 0 | 1 | 269 | 597 | 329 | Plasmodium brasilianum polyubiquitin (MKS88_004855), partial mRNA | blastn | 46472 | 248 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 21816777 | 21816777 | PRJEB81327_P_NODE_52278_length_248_cov_0.880000_g51670_i0 | PRJEB81327 | 52278 | 248 | 0.88 | 2.1824 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.01e-25 | NTclustered | gi|1620182152|ref|XM_028684617.1| | 880535 | g51670 | i0 | 79.888 | 6.77822580645161 | 179 | 35 | 72 | 1 | 1 | 178 | 400 | 222 | Plasmodium sp. gorilla clade G2 calmodulin (PADL01_1434200), partial mRNA | blastn | 1681 | 130 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 21816837 | 21816837 | PRJEB81327_P_NODE_57118_length_245_cov_1.215116_g56510_i0 | PRJEB81327 | 57118 | 245 | 1.215116 | 2.9770342 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 5.98e-23 | NTclustered | gi|1620112010|ref|XM_028670755.1| | 5849 | g56510 | i0 | 91.86 | 5.71428571428571 | 86 | 7 | 35 | 0 | 1 | 86 | 299 | 384 | Plasmodium gallinaceum 60S ribosomal protein L11a, putative (PGAL8A_00082800), partial mRNA | blastn | 1400 | 121 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 23091990 | 23091990 | PRJEB81327_P_NODE_55239_length_246_cov_1.341040_g54631_i0 | PRJEB81327 | 55239 | 246 | 1.34104 | 3.2989584 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.33e-4 | NTclustered | gi|2795629872|ref|XM_068068966.1| | 483139 | g54631 | i0 | 100 | 0.833333333333333 | 32 | 0 | 13 | 0 | 27 | 58 | 1158 | 1127 | Cystoisospora suis uncharacterized protein (CSUI_008844), mRNA | blastn | 205 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 24365917 | 24365917 | PRJEB81327_P_NODE_5680_length_605_cov_2.466165_g5099_i0 | PRJEB81327 | 5680 | 605 | 2.466165 | 14.92029825 | Cryptosporidium sp. chipmunk genotype I | 1280935 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 1.98e-61 | NTclustered | gi|2787704165|ref|XM_067344148.1| | 1280935 | g5099 | i0 | 80.48 | 74.0462809917355 | 333 | 59 | 55 | 6 | 226 | 555 | 330 | 1 | Cryptosporidium sp. chipmunk genotype I 60S ribosomal L40 (ELE39_001109), partial mRNA | blastn | 44798 | 250 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. chipmunk genotype I | ||
| 26900497 | 26900497 | PRJEB81327_P_NODE_58281_length_245_cov_0.877907_g57673_i0 | PRJEB81327 | 58281 | 245 | 0.877907 | 2.15087215 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 86.7 | 7.67e-18 | NR | XP_067922978.1 | 483139 | g57673 | i0 | 53.1 | 5.93877551020408 | 81 | 37 | 98 | 1 | 4 | 243 | 119 | 199 | XP_067922978.1 methionine aminopeptidase [Cystoisospora suis] | diamond | 1455 | 86.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 27248228 | 27248228 | PRJEB81327_P_NODE_9483_length_447_cov_2.120321_g8875_i0 | PRJEB81327 | 9483 | 447 | 2.120321 | 9.47783487 | Piroplasmida | 5863 | SAR_Eukaryotes | SAR_Eukaryotes | 92 | 1.64e-20 | NR | XP_067802475.1 | 323732 | g8875 | i0 | 73.1 | 1.74496644295302 | 52 | 14 | 34.9 | 0 | 2 | 157 | 96 | 147 | XP_067802475.1 bifunctional Ribosomal protein S19-S15 [Babesia duncani] | diamond | 780 | 92.4 | 0.995670995670996 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 28132576 | 28132576 | PRJEB81327_P_NODE_21725_length_298_cov_1.364444_g21117_i0 | PRJEB81327 | 21725 | 298 | 1.364444 | 4.06604312 | root | 1 | Root_unresolved | Root_unresolved | 106 | 2.57e-27 | NR | OEH74079.1 | 88456 | g21117 | i0 | 57.3 | 3.30201342281879 | 82 | 35 | 82.6 | 0 | 2 | 247 | 1 | 82 | OEH74079.1 ribosomal protein rps27 [Cyclospora cayetanensis] | diamond | 984 | 107 | 0.990654205607477 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 28479821 | 28479821 | PRJEB81327_P_NODE_52446_length_248_cov_0.880000_g51838_i0 | PRJEB81327 | 52446 | 248 | 0.88 | 2.1824 | Eimeria | 5800 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 6.22e-14 | NR | XP_013231775.1 | 5802 | g51838 | i0 | 42.5 | 5.75806451612903 | 80 | 46 | 96.8 | 0 | 3 | 242 | 44 | 123 | XP_013231775.1 uncharacterized protein ETH_00036250 [Eimeria tenella] | diamond | 1428 | 74.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 28771163 | 28771163 | PRJEB81327_P_NODE_21207_length_301_cov_1.662281_g20599_i0 | PRJEB81327 | 21207 | 301 | 1.662281 | 5.00346581 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 1.72e-10 | NR | XP_029217338.1 | 94643 | g20599 | i0 | 36 | 2.93023255813953 | 100 | 62 | 98.7 | 2 | 297 | 1 | 208 | 306 | XP_029217338.1 putative oxidoreductase [Besnoitia besnoiti] | diamond | 882 | 67 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 28795258 | 28795258 | PRJEB81327_P_NODE_58907_length_244_cov_1.391813_g58299_i0 | PRJEB81327 | 58907 | 244 | 1.391813 | 3.39602372 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 2.21e-18 | NR | XP_067072191.1 | 5824 | g58299 | i0 | 61.9 | 10.3647540983607 | 63 | 24 | 77.5 | 0 | 244 | 56 | 215 | 277 | XP_067072191.1 40S ribosomal protein S5 [Plasmodium brasilianum] | diamond | 2529 | 87.4 | 0.995423340961098 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 29079751 | 29079751 | PRJEB81327_P_NODE_20628_length_306_cov_1.137339_g20020_i0 | PRJEB81327 | 20628 | 306 | 1.137339 | 3.48025734 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 95.1 | 2.45e-22 | NR | AET50468.1 | 5802 | g20020 | i0 | 79.2 | 14.8529411764706 | 53 | 11 | 52 | 0 | 2 | 160 | 101 | 153 | AET50468.1 hypothetical protein [Eimeria tenella] | diamond | 4545 | 95.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 29869059 | 29869059 | PRJEB81327_P_NODE_59931_length_244_cov_0.900585_g59323_i0 | PRJEB81327 | 59931 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 6.09e-24 | NR | BAN65741.1 | 5865 | g59323 | i0 | 69.7 | 8.22540983606557 | 66 | 20 | 81.1 | 0 | 1 | 198 | 392 | 457 | BAN65741.1 eIF-4A-like DEAD family RNA helicase, putative [Babesia bovis] | diamond | 2007 | 104 | 0.990384615384615 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 30090034 | 30090034 | PRJEB81327_P_NODE_17912_length_319_cov_3.821138_g17304_i0 | PRJEB81327 | 17912 | 319 | 3.821138 | 12.18943022 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 2.66e-41 | NR | AFJ45055.1 | 5874 | g17304 | i0 | 67.3 | 7.84326018808777 | 104 | 34 | 97.8 | 0 | 312 | 1 | 1 | 104 | AFJ45055.1 ribosomal protein S8, partial [Theileria annulata] | diamond | 2502 | 145 | 0.993103448275862 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 30153093 | 30153093 | PRJEB81327_P_NODE_38072_length_264_cov_2.015707_g37464_i0 | PRJEB81327 | 38072 | 264 | 2.015707 | 5.32146648 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 1.02e-7 | NR | EWC86765.1 | 5843 | g37464 | i0 | 45.1 | 4.84090909090909 | 71 | 36 | 79.5 | 2 | 262 | 53 | 220 | 288 | EWC86765.1 hypothetical protein PFNF54_04318 [Plasmodium falciparum NF54] | diamond | 1278 | 58.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 30792529 | 30792529 | PRJEB81327_P_NODE_64934_length_241_cov_0.916667_g64326_i0 | PRJEB81327 | 64934 | 241 | 0.916667 | 2.20916747 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 1.6900000000000003e-27 | NR | XP_067925209.1 | 483139 | g64326 | i0 | 68.4 | 1.96680497925311 | 79 | 25 | 98.3 | 0 | 239 | 3 | 440 | 518 | XP_067925209.1 signal recognition particle receptor alpha subunit [Cystoisospora suis] | diamond | 474 | 114 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 31298130 | 31298130 | PRJEB81327_P_NODE_22055_length_296_cov_2.973094_g21447_i0 | PRJEB81327 | 22055 | 296 | 2.973094 | 8.80035824 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 2.17e-5 | NR | XP_026191486.1 | 88456 | g21447 | i0 | 78.6 | 0.283783783783784 | 28 | 6 | 28.4 | 0 | 86 | 3 | 404 | 431 | XP_026191486.1 box A-binding factor-like [Cyclospora cayetanensis] | diamond | 84 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis |
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);;