contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3524253 | 3524253 | PRJNA986481_P_NODE_43443_length_260_cov_0.957346_g42918_i0 | PRJNA986481 | 43443 | 260 | 0.957346 | 2.4890996 | Plasmodium brasilianum | 5824 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|2785761570|ref|XM_067215664.1| | 5824 | g42918 | i0 | 100 | 0.111538461538462 | 29 | 0 | 11 | 0 | 133 | 161 | 281 | 253 | Plasmodium brasilianum uncharacterized protein (MKS88_002638), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 4801312 | 4801312 | PRJNA986481_P_NODE_25904_length_322_cov_3.666667_g25379_i0 | PRJNA986481 | 25904 | 322 | 3.666667 | 11.80666774 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.31e-50 | NTclustered | gi|1620144238|ref|XM_028677584.1| | 85471 | g25379 | i0 | 80.496 | 20.1739130434783 | 282 | 52 | 87 | 3 | 39 | 319 | 387 | 108 | Plasmodium relictum histone H3 variant, putative (H3.3), partial mRNA | blastn | 6496 | 213 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 4801744 | 4801744 | PRJNA986481_P_NODE_53904_length_248_cov_1.015075_g53379_i0 | PRJNA986481 | 53904 | 248 | 1.015075 | 2.517386 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|916506671|ref|XM_013498301.1| | 44415 | g53379 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 76 | 103 | 1073 | 1046 | Eimeria mitis uncharacterized protein (EMH_0008300), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 5100463 | 5100463 | PRJNA986481_P_NODE_58004_length_243_cov_1.608247_g57479_i0 | PRJNA986481 | 58004 | 243 | 1.608247 | 3.90804021 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 4.579999999999999e-24 | NTclustered | gi|400365274|gb|JQ684659.1| | 5833 | g57479 | i0 | 89.796 | 38.5020576131687 | 98 | 8 | 40 | 2 | 103 | 199 | 1546 | 1642 | Plasmodium falciparum isolate LF3 28S ribosomal RNA gene, partial sequence | blastn | 9356 | 124 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 10200813 | 10200813 | PRJNA986481_P_NODE_60748_length_239_cov_3.347368_g60223_i0 | PRJNA986481 | 60748 | 239 | 3.347368 | 8.00020952 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2785765564|ref|XM_067217861.1| | 5824 | g60223 | i0 | 100 | 1.56066945606695 | 29 | 0 | 12 | 0 | 1 | 29 | 4418 | 4390 | Plasmodium brasilianum serine/threonine protein kinase (MKS88_004665), partial mRNA | blastn | 373 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 16276850 | 16276850 | PRJNA986481_P_NODE_61513_length_234_cov_2.389189_g60988_i0 | PRJNA986481 | 61513 | 234 | 2.389189 | 5.59070226 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 2.53e-51 | NTclustered | gi|82704988|ref|XM_721689.1| | 5861 | g60988 | i0 | 83.262 | 7.63247863247863 | 233 | 39 | 99 | 0 | 2 | 234 | 547 | 779 | Plasmodium yoelii 26S proteasome subunit 4 protein (PY17X_1209800), partial mRNA | blastn | 1786 | 215 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 17551280 | 17551280 | PRJNA986481_P_NODE_2354_length_954_cov_3.013260_g2038_i0 | PRJNA986481 | 2354 | 954 | 3.01326 | 28.7465004 | Legerella nova | 3081637 | SAR_Eukaryotes | SAR_Eukaryotes | 76.8 | 5.73e-9 | NTclustered | gi|2699878143|gb|OR693319.1| | 3081637 | g2038 | i0 | 91.228 | 8.06603773584906 | 57 | 4 | 6 | 1 | 15 | 70 | 19940 | 19884 | Legerella nova apicoplast, complete genome | blastn | 7695 | 76.8 | 1 | Eukaryota | Sar | Apicomplexa | Legerellidae | Legerella | Legerella nova | ||||
| 18825203 | 18825203 | PRJNA986481_P_NODE_2755_length_896_cov_2.399055_g2414_i0 | PRJNA986481 | 2755 | 896 | 2.399055 | 21.4955328 | Plasmodium falciparum | 5833 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.002 | NTclustered | gi|124809687|ref|XM_001348618.1| | 36329 | g2414 | i0 | 77.778 | 0.392857142857143 | 108 | 15 | 12 | 6 | 130 | 235 | 2598 | 2498 | Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_1450500), partial mRNA | blastn | 352 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium falciparum | ||
| 19123487 | 19123487 | PRJNA986481_P_NODE_5055_length_703_cov_2.822630_g4624_i0 | PRJNA986481 | 5055 | 703 | 2.82263 | 19.8430889 | Cryptosporidium | 5806 | SAR_Eukaryotes | SAR_Eukaryotes | 84.2 | 2.49e-11 | NTclustered | gi|1227113057|gb|KY657285.1| | 90962 | g4624 | i0 | 77.852 | 2.75533428165007 | 149 | 24 | 21 | 9 | 391 | 535 | 203 | 60 | Cryptosporidium sp. isolate 20055-Miar-EU actin gene, partial cds | blastn | 1937 | 84.2 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. | ||
| 20099653 | 20099653 | PRJNA986481_P_NODE_11576_length_481_cov_9.379630_g11053_i0 | PRJNA986481 | 11576 | 481 | 9.37963 | 45.1160203 | Legerella nova | 3081637 | SAR_Eukaryotes | SAR_Eukaryotes | 75 | 1e-8 | NTclustered | gi|2699878143|gb|OR693319.1| | 3081637 | g11053 | i0 | 91.071 | 15.7214137214137 | 56 | 4 | 11 | 1 | 427 | 481 | 19940 | 19885 | Legerella nova apicoplast, complete genome | blastn | 7562 | 75 | 1 | Eukaryota | Sar | Apicomplexa | Legerellidae | Legerella | Legerella nova | ||||
| 21376095 | 21376095 | PRJNA986481_P_NODE_59737_length_241_cov_2.166667_g59212_i0 | PRJNA986481 | 59737 | 241 | 2.166667 | 5.22166747 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 5.82e-28 | NTclustered | gi|1673116849|ref|XM_029363787.1| | 94643 | g59212 | i0 | 81.548 | 3.22406639004149 | 168 | 29 | 69 | 2 | 11 | 177 | 241 | 407 | Besnoitia besnoiti ribosomal protein RPS13 (BESB_053520), partial mRNA | blastn | 777 | 137 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 22650996 | 22650996 | PRJNA986481_P_NODE_56998_length_244_cov_2.476923_g56473_i0 | PRJNA986481 | 56998 | 244 | 2.476923 | 6.04369212 | Echinomera hispida | 3139261 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 7.86e-7 | NTclustered | gi|2716959877|gb|PP657469.1| | 3139261 | g56473 | i0 | 93.333 | 15.2909836065574 | 45 | 3 | 18 | 0 | 199 | 243 | 2827 | 2871 | Echinomera hispida isolate ZBS ribotype 1 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 3731 | 67.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Arthrogregarida | Dactylophoridae | Echinomera | Echinomera hispida | ||
| 22949739 | 22949739 | PRJNA986481_P_NODE_19878_length_367_cov_5.830189_g19353_i0 | PRJNA986481 | 19878 | 367 | 5.830189 | 21.39679363 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.035 | NTclustered | gi|260233916|dbj|AK318321.1| | 5811 | g19353 | i0 | 100 | 0.228882833787466 | 28 | 0 | 8 | 0 | 287 | 314 | 536 | 509 | Toxoplasma gondii cDNA, clone: XTG07019.2, full cDNA, XTG Sugano cDNA library | blastn | 84 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 25498627 | 25498627 | PRJNA986481_P_NODE_49000_length_253_cov_1.274510_g48475_i0 | PRJNA986481 | 49000 | 253 | 1.27451 | 3.2245103 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.023 | NTclustered | gi|156098874|ref|XM_001615403.1| | 5855 | g48475 | i0 | 100 | 0.33201581027668 | 28 | 0 | 11 | 0 | 116 | 143 | 1672 | 1699 | Plasmodium vivax hypothetical protein, conserved (PVX_092305), partial mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax |
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);;