contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA489308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1724924 | 1724924 | PRJNA489308_P_NODE_29562_length_254_cov_1.342541_g29486_i0 | PRJNA489308 | 29562 | 254 | 1.342541 | 3.41005414 | Cryptosporidium baileyi | 27987 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.3e-44 | NTclustered | gi|193075908|gb|EU741857.1| | 27987 | g29486 | i0 | 80.8 | 63.9173228346457 | 250 | 44 | 98 | 4 | 7 | 254 | 432 | 185 | Cryptosporidium baileyi strain ZJJHN27 heart shock protein 70 (HSP70) gene, partial cds | blastn | 16235 | 193 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium baileyi | ||
| 3001034 | 3001034 | PRJNA489308_P_NODE_38163_length_242_cov_0.911243_g38087_i0 | PRJNA489308 | 38163 | 242 | 0.911243 | 2.20520806 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|258597514|ref|XM_001350636.2| | 36329 | g38087 | i0 | 100 | 1.05785123966942 | 30 | 0 | 12 | 0 | 60 | 89 | 2331 | 2360 | Plasmodium falciparum 3D7 protein SOC2, putative (PF3D7_1227500), partial mRNA | blastn | 256 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 4277194 | 4277194 | PRJNA489308_P_NODE_18784_length_292_cov_2.109589_g18708_i0 | PRJNA489308 | 18784 | 292 | 2.109589 | 6.15999988 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 4.5e-5 | NTclustered | gi|915124666|ref|XM_013478143.1| | 5804 | g18708 | i0 | 94.872 | 4.56849315068493 | 39 | 2 | 13 | 0 | 196 | 234 | 3095 | 3133 | Eimeria maxima Tyrosine kinase-like (TKL) protein, putative partial mRNA | blastn | 1334 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 10026394 | 10026394 | PRJNA489308_P_NODE_17508_length_298_cov_2.675556_g17432_i0 | PRJNA489308 | 17508 | 298 | 2.675556 | 7.97315688 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.95e-4 | NTclustered | gi|2785757780|ref|XM_067218361.1| | 5824 | g17432 | i0 | 100 | 4.74832214765101 | 31 | 0 | 10 | 0 | 121 | 151 | 1222 | 1252 | Plasmodium brasilianum uncharacterized protein (MKS88_000710), partial mRNA | blastn | 1415 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 11928903 | 11928903 | PRJNA489308_P_NODE_3350_length_547_cov_4.702532_g3274_i0 | PRJNA489308 | 3350 | 547 | 4.702532 | 25.72285004 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.015 | NTclustered | gi|915122858|ref|XM_013477239.1| | 5804 | g3274 | i0 | 100 | 0.0530164533820841 | 29 | 0 | 5 | 0 | 206 | 234 | 2137 | 2109 | Eimeria maxima SET domain-containing protein / Bromodomain-containing protein, putative partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 13203902 | 13203902 | PRJNA489308_P_NODE_31_length_2732_cov_7.765325_g25_i0 | PRJNA489308 | 31 | 2732 | 7.765325 | 212.148679 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 1.01e-5 | NTclustered | gi|1084781811|ref|XM_018784108.1| | 647221 | g25 | i0 | 95.238 | 0.409224011713031 | 42 | 2 | 2 | 0 | 2032 | 2073 | 561 | 602 | Plasmodium gaboni hypothetical protein partial mRNA | blastn | 1118 | 67.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 14478780 | 14478780 | PRJNA489308_P_NODE_27952_length_258_cov_2.497297_g27876_i0 | PRJNA489308 | 27952 | 258 | 2.497297 | 6.44302626 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|915016625|ref|XM_013397533.1| | 5801 | g27876 | i0 | 96.774 | 0.12015503875969 | 31 | 1 | 12 | 0 | 160 | 190 | 876 | 906 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 14478818 | 14478818 | PRJNA489308_P_NODE_33672_length_247_cov_1.551724_g33596_i0 | PRJNA489308 | 33672 | 247 | 1.551724 | 3.83275828 | Parahaemoproteus sp. CP-2014 | 1539139 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 2.1399999999999998e-32 | NTclustered | gi|702072930|emb|LN482938.1| | 1539139 | g33596 | i0 | 79.372 | 7.7085020242915 | 223 | 40 | 89 | 6 | 19 | 238 | 2 | 221 | Parahaemoproteus sp. CP-2014 partial CDC48 gene for cell division cycle protein 48 homologue | blastn | 1904 | 152 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Haemoproteidae | Parahaemoproteus | Parahaemoproteus sp. CP-2014 | ||
| 15752925 | 15752925 | PRJNA489308_P_NODE_38373_length_241_cov_2.267857_g38297_i0 | PRJNA489308 | 38373 | 241 | 2.267857 | 5.46553537 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 9.47e-46 | NTclustered | gi|1620166421|ref|XM_028681107.1| | 880535 | g38297 | i0 | 81.633 | 48.1701244813278 | 245 | 37 | 99 | 6 | 1 | 239 | 588 | 346 | Plasmodium sp. gorilla clade G2 heat shock protein 90 (PADL01_0707200), partial mRNA | blastn | 11609 | 196 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 16400654 | 16400654 | PRJNA489308_P_NODE_37353_length_243_cov_0.905882_g37277_i0 | PRJNA489308 | 37353 | 243 | 0.905882 | 2.20129326 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|33329883|gb|AF533700.1| | 5833 | g37277 | i0 | 100 | 0.864197530864197 | 30 | 0 | 12 | 0 | 209 | 238 | 2872 | 2843 | Plasmodium falciparum 3D7 normocyte-binding protein 1 (NBP1) gene, complete cds | blastn | 210 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 24049996 | 24049996 | PRJNA489308_P_NODE_17019_length_301_cov_1.513158_g16943_i0 | PRJNA489308 | 17019 | 301 | 1.513158 | 4.55460558 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 2.48e-87 | NTclustered | gi|1027950138|ref|XM_016797486.1| | 31271 | g16943 | i0 | 86.799 | 135.797342192691 | 303 | 36 | 100 | 4 | 1 | 301 | 323 | 23 | Plasmodium chabaudi chabaudi polyubiquitin (PCHAS_0612000), partial mRNA | blastn | 40875 | 335 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 24676126 | 24676126 | PRJNA489308_P_NODE_17480_length_299_cov_1.022124_g17404_i0 | PRJNA489308 | 17480 | 299 | 1.022124 | 3.05615076 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|66358725|ref|XM_626541.1| | 353152 | g17404 | i0 | 100 | 0.096989966555184 | 29 | 0 | 10 | 0 | 88 | 116 | 6998 | 6970 | Cryptosporidium parvum Iowa II 4x PHD domain containing protein (cgd2_3540) partial mRNA | blastn | 29 | 54.7 | 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);;