contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192648 | 192648 | PRJNA1078753_P_NODE_40361_length_243_cov_0.905882_g40165_i0 | PRJNA1078753 | 40361 | 243 | 0.905882 | 2.20129326 | Plasmodium berghei | 5821 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 5.88e-28 | NTclustered | gi|1843573692|ref|XM_034566721.1| | 5823 | g40165 | i0 | 81.818 | 63.3868312757202 | 176 | 20 | 70 | 10 | 1 | 170 | 455 | 286 | Plasmodium berghei ANKA signal recognition particle subunit SRP54, putative (PBANKA_1313800), partial mRNA | blastn | 15403 | 137 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 1467153 | 1467153 | PRJNA1078753_P_NODE_28962_length_250_cov_0.870056_g28766_i0 | PRJNA1078753 | 28962 | 250 | 0.870056 | 2.17514 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.05e-5 | NTclustered | gi|915144374|ref|XM_013482691.1| | 5804 | g28766 | i0 | 85.714 | 2.164 | 63 | 6 | 24 | 3 | 190 | 249 | 825 | 887 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 541 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 5295330 | 5295330 | PRJNA1078753_P_NODE_24645_length_260_cov_1.272727_g24449_i0 | PRJNA1078753 | 24645 | 260 | 1.272727 | 3.3090902 | Plasmodium malariae | 5858 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 8.049999999999997e-42 | NTclustered | gi|1624461025|ref|XM_029003878.1| | 5858 | g24449 | i0 | 80.567 | 53.0846153846154 | 247 | 40 | 93 | 7 | 18 | 260 | 1307 | 1065 | Plasmodium malariae alpha tubulin 1, putative (PmUG01_07015200), partial mRNA | blastn | 13802 | 183 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium malariae | ||
| 5295492 | 5295492 | PRJNA1078753_P_NODE_6285_length_426_cov_2.759207_g6089_i0 | PRJNA1078753 | 6285 | 426 | 2.759207 | 11.75422182 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 4.95e-51 | NTclustered | gi|1620144605|ref|XM_028677665.1| | 85471 | g6089 | i0 | 83.197 | 47.8755868544601 | 244 | 31 | 56 | 9 | 188 | 426 | 402 | 164 | Plasmodium relictum histone H3, putative (H3), partial mRNA | blastn | 20395 | 215 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 6570476 | 6570476 | PRJNA1078753_P_NODE_25206_length_257_cov_2.489130_g25010_i0 | PRJNA1078753 | 25206 | 257 | 2.48913 | 6.3970641 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.31e-49 | NTclustered | gi|1620139207|ref|XM_028675299.1| | 85471 | g25010 | i0 | 82.773 | 55.3968871595331 | 238 | 37 | 92 | 2 | 22 | 257 | 1583 | 1348 | Plasmodium relictum heat shock protein 70, putative (HSP70), partial mRNA | blastn | 14237 | 209 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 9120087 | 9120087 | PRJNA1078753_P_NODE_14128_length_313_cov_3.500000_g13932_i0 | PRJNA1078753 | 14128 | 313 | 3.5 | 10.955 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 3.53e-51 | NTclustered | gi|66356967|ref|XM_625662.1| | 353152 | g13932 | i0 | 83.122 | 41.3226837060703 | 237 | 38 | 75 | 2 | 78 | 313 | 85 | 320 | Cryptosporidium parvum Iowa II ubiquitin-conjugating enzyme (cgd4_570) mRNA, partial cds | blastn | 12934 | 215 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 16769493 | 16769493 | PRJNA1078753_P_NODE_23454_length_264_cov_4.329843_g23258_i0 | PRJNA1078753 | 23454 | 264 | 4.329843 | 11.43078552 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.05e-50 | NTclustered | gi|1620175208|ref|XM_028683076.1| | 880535 | g23258 | i0 | 81.89 | 74.8106060606061 | 254 | 44 | 96 | 2 | 12 | 264 | 457 | 709 | Plasmodium sp. gorilla clade G2 polyubiquitin (PADL01_1212200), partial mRNA | blastn | 19750 | 213 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 17594611 | 17594611 | PRJNA1078753_P_NODE_15614_length_301_cov_5.938596_g15418_i0 | PRJNA1078753 | 15614 | 301 | 5.938596 | 17.87517396 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 3.1900000000000003e-91 | NTclustered | gi|2785765936|ref|XM_067218065.1| | 5824 | g15418 | i0 | 87.667 | 130.428571428571 | 300 | 35 | 99 | 2 | 2 | 300 | 229 | 527 | Plasmodium brasilianum polyubiquitin (MKS88_004855), partial mRNA | blastn | 39259 | 348 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 18044262 | 18044262 | PRJNA1078753_P_NODE_19335_length_281_cov_1.471154_g19139_i0 | PRJNA1078753 | 19335 | 281 | 1.471154 | 4.13394274 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|2795627686|ref|XM_068067873.1| | 483139 | g19139 | i0 | 100 | 0.099644128113879 | 28 | 0 | 10 | 0 | 4 | 31 | 1666 | 1639 | Cystoisospora suis f-box domain-containing (CSUI_007729), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 23144742 | 23144742 | PRJNA1078753_P_NODE_24439_length_261_cov_1.228723_g24243_i0 | PRJNA1078753 | 24439 | 261 | 1.228723 | 3.20696703 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|916501425|ref|XM_013496073.1| | 44415 | g24243 | i0 | 100 | 0.540229885057471 | 29 | 0 | 11 | 0 | 127 | 155 | 2753 | 2781 | Eimeria mitis uncharacterized protein (EMH_0045490), partial mRNA | blastn | 141 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis |
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);;