contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA744060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8376320 | 8376320 | PRJNA744060_P_NODE_16687_length_394_cov_2.311526_g16358_i0 | PRJNA744060 | 16687 | 394 | 2.311526 | 9.10741244 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 1.03e-17 | NTclustered | gi|820694606|tpe|LN714487.1| | 572307 | g16358 | i0 | 83.333 | 1.27664974619289 | 114 | 18 | 29 | 1 | 282 | 394 | 2817447 | 2817334 | TPA_asm: Neospora caninum Liverpool, chromosome chrXII, complete genome | blastn | 503 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 10927480 | 10927480 | PRJNA744060_P_NODE_43969_length_253_cov_0.866667_g43640_i0 | PRJNA744060 | 43969 | 253 | 0.866667 | 2.19266751 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.03e-25 | NTclustered | gi|1620132367|ref|XM_028674542.1| | 5849 | g43640 | i0 | 83.333 | 2.93675889328063 | 144 | 20 | 56 | 4 | 3 | 144 | 315 | 174 | Plasmodium gallinaceum tyrosine--tRNA ligase, putative (PGAL8A_00052200), partial mRNA | blastn | 743 | 130 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 10927534 | 10927534 | PRJNA744060_P_NODE_47349_length_247_cov_3.603448_g47020_i0 | PRJNA744060 | 47349 | 247 | 3.603448 | 8.90051656 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 1.31e-19 | NTclustered | gi|1620183899|ref|XM_028684863.1| | 880535 | g47020 | i0 | 88.298 | 3.0080971659919 | 94 | 7 | 37 | 4 | 138 | 229 | 2066 | 1975 | Plasmodium sp. gorilla clade G2 V-type H(+)-translocating pyrophosphatase, putative (PADL01_1456800), partial mRNA | blastn | 743 | 110 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 | ||
| 16025714 | 16025714 | PRJNA744060_P_NODE_21753_length_347_cov_1.631387_g21424_i0 | PRJNA744060 | 21753 | 347 | 1.631387 | 5.66091289 | Eimeria tenella | 5802 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.033 | NTclustered | gi|916423607|ref|XM_013377581.1| | 5802 | g21424 | i0 | 100 | 0.0806916426512968 | 28 | 0 | 8 | 0 | 238 | 265 | 2593 | 2566 | Eimeria tenella 4-hydroxy-3-methylbut-2-en-1-yl diphosphate synthase, putative (ETH_00001880), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria tenella | ||
| 17301662 | 17301662 | PRJNA744060_P_NODE_48214_length_246_cov_1.705202_g47885_i0 | PRJNA744060 | 48214 | 246 | 1.705202 | 4.19479692 | Cryptosporidium baileyi | 27987 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 5.639999999999999e-68 | NTclustered | gi|193075908|gb|EU741857.1| | 27987 | g47885 | i0 | 86.64 | 92.7560975609756 | 247 | 30 | 99 | 2 | 1 | 244 | 613 | 367 | Cryptosporidium baileyi strain ZJJHN27 heart shock protein 70 (HSP70) gene, partial cds | blastn | 22818 | 270 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium baileyi | ||
| 20324969 | 20324969 | PRJNA744060_P_NODE_47896_length_247_cov_0.896552_g47567_i0 | PRJNA744060 | 47896 | 247 | 0.896552 | 2.21448344 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|915137323|ref|XM_013481274.1| | 5804 | g47567 | i0 | 100 | 4.1336032388664 | 29 | 0 | 12 | 0 | 36 | 64 | 855 | 883 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 1021 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 21125624 | 21125624 | PRJNA744060_P_NODE_18957_length_371_cov_1.697987_g18628_i0 | PRJNA744060 | 18957 | 371 | 1.697987 | 6.29953177 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 8.39e-113 | NTclustered | gi|82914870|ref|XM_723786.1| | 5861 | g18628 | i0 | 87.131 | 94.1832884097035 | 373 | 44 | 100 | 4 | 1 | 371 | 869 | 1239 | Plasmodium yoelii tubulin subunit alpha (PY17X_0420500), partial mRNA | blastn | 34942 | 420 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 21600680 | 21600680 | PRJNA744060_P_NODE_32217_length_289_cov_3.041667_g31888_i0 | PRJNA744060 | 32217 | 289 | 3.041667 | 8.79041763 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|2785765588|ref|XM_067217874.1| | 5824 | g31888 | i0 | 94.444 | 0.519031141868512 | 36 | 2 | 12 | 0 | 59 | 94 | 259 | 294 | Plasmodium brasilianum uncharacterized protein (MKS88_004678), partial mRNA | blastn | 150 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 22400991 | 22400991 | PRJNA744060_P_NODE_46858_length_248_cov_1.782857_g46529_i0 | PRJNA744060 | 46858 | 248 | 1.782857 | 4.42148536 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|1249167577|ref|XM_022732348.1| | 88456 | g46529 | i0 | 94.444 | 0.145161290322581 | 36 | 2 | 15 | 0 | 211 | 246 | 1823 | 1788 | PREDICTED: Cyclospora cayetanensis ABC transporter E family member 2 (LOC34619037), mRNA | blastn | 36 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 22401220 | 22401220 | PRJNA744060_P_NODE_9558_length_517_cov_7.173423_g9231_i0 | PRJNA744060 | 9558 | 517 | 7.173423 | 37.08659691 | Cryptosporidium parvum | 5807 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 7.9e-50 | NTclustered | gi|66359883|ref|XM_627120.1| | 353152 | g9231 | i0 | 78.997 | 5.77562862669246 | 319 | 59 | 61 | 8 | 76 | 390 | 67 | 381 | Cryptosporidium parvum Iowa II histone H2A (cgd8_2170) mRNA, complete cds | blastn | 2986 | 211 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium parvum | ||
| 24949688 | 24949688 | PRJNA744060_P_NODE_25420_length_322_cov_2.666667_g25091_i0 | PRJNA744060 | 25420 | 322 | 2.666667 | 8.58666774 | Plasmodium sp. gorilla clade G2 | 880535 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 3.88e-6 | NTclustered | gi|1620165617|ref|XM_028685640.1| | 880535 | g25091 | i0 | 93.182 | 1.91304347826087 | 44 | 3 | 14 | 0 | 199 | 242 | 972 | 929 | Plasmodium sp. gorilla clade G2 Hsc70-interacting protein (PADL01_0526500), partial mRNA | blastn | 616 | 65.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium sp. gorilla clade G2 |
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);;