contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1174234" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1040939 | 1040939 | PRJNA1174234_P_NODE_22981_length_287_cov_2.509346_g22785_i0 | PRJNA1174234 | 22981 | 287 | 2.509346 | 7.20182302 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|915006518|ref|XM_013394613.1| | 5801 | g22785 | i0 | 100 | 0.411149825783972 | 30 | 0 | 10 | 0 | 93 | 122 | 1517 | 1546 | Eimeria acervulina hypothetical protein, conserved partial mRNA | blastn | 118 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 2866912 | 2866912 | PRJNA1174234_P_NODE_18003_length_325_cov_0.873016_g17807_i0 | PRJNA1174234 | 18003 | 325 | 0.873016 | 2.837302 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 8.31e-18 | NTclustered | gi|1085173560|ref|XM_002366958.2| | 508771 | g17807 | i0 | 77.647 | 0.523076923076923 | 170 | 38 | 52 | 0 | 126 | 295 | 1958 | 1789 | Toxoplasma gondii ME49 phosphatidylinositol-4-phosphate 5-kinase, putative mRNA | blastn | 170 | 104 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 5419128 | 5419128 | PRJNA1174234_P_NODE_14825_length_358_cov_1.042105_g14629_i0 | PRJNA1174234 | 14825 | 358 | 1.042105 | 3.7307359 | Plasmodium gonderi | 77519 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 2.03e-4 | NTclustered | gi|1620949869|ref|XM_028686997.1| | 77519 | g14629 | i0 | 100 | 0.980446927374302 | 32 | 0 | 9 | 0 | 1 | 32 | 1036 | 1005 | Plasmodium gonderi hypothetical protein, conserved (PGO_071240), partial mRNA | blastn | 351 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gonderi | ||
| 13794214 | 13794214 | PRJNA1174234_P_NODE_10051_length_435_cov_1.350829_g9855_i0 | PRJNA1174234 | 10051 | 435 | 1.350829 | 5.87610615 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|2785766016|ref|XM_067218109.1| | 5824 | g9855 | i0 | 100 | 0.137931034482759 | 30 | 0 | 7 | 0 | 3 | 32 | 11438 | 11467 | Plasmodium brasilianum dynein-related AAA-type ATPase (MKS88_004895), partial mRNA | blastn | 60 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 16343482 | 16343482 | PRJNA1174234_P_NODE_2293_length_841_cov_2.575521_g2131_i0 | PRJNA1174234 | 2293 | 841 | 2.575521 | 21.66013161 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.007 | NTclustered | gi|2785759221|ref|XM_067214378.1| | 5824 | g2131 | i0 | 100 | 0.0713436385255648 | 30 | 0 | 4 | 0 | 71 | 100 | 4997 | 5026 | Plasmodium brasilianum uncharacterized protein (MKS88_001453), partial mRNA | blastn | 60 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 16893146 | 16893146 | PRJNA1174234_P_NODE_1494_length_981_cov_9.009912_g1364_i0 | PRJNA1174234 | 1494 | 981 | 9.009912 | 88.38723672 | Plasmodium knowlesi | 5850 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 5.94e-4 | NTclustered | gi|1976646724|ref|XM_002259993.2| | 5851 | g1364 | i0 | 100 | 0.0326197757390418 | 32 | 0 | 3 | 0 | 65 | 96 | 1715 | 1684 | Plasmodium knowlesi strain H RNA-binding protein, putative (PKNH_1269600), partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 21992692 | 21992692 | PRJNA1174234_P_NODE_17958_length_325_cov_1.222222_g17762_i0 | PRJNA1174234 | 17958 | 325 | 1.222222 | 3.9722215 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 1.06e-26 | NTclustered | gi|1673114865|ref|XM_029362681.1| | 94643 | g17762 | i0 | 79.082 | 4.70153846153846 | 196 | 39 | 60 | 2 | 18 | 212 | 327 | 133 | Besnoitia besnoiti histone H2AZ (BESB_040950), partial mRNA | blastn | 1528 | 134 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 25267215 | 25267215 | PRJNA1174234_P_NODE_36120_length_232_cov_2.547170_g35924_i0 | PRJNA1174234 | 36120 | 232 | 2.54717 | 5.9094344 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.99e-32 | NTclustered | gi|2794932840|ref|XM_067857025.1| | 5871 | g35924 | i0 | 88.889 | 17.5991379310345 | 126 | 10 | 53 | 4 | 53 | 176 | 901 | 778 | Babesia caballi syntaxin 5 (BcabD6B2_04900), partial mRNA | blastn | 4083 | 152 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi |
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);;