contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJEB10320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13550 | 13550 | PRJEB10320_P_NODE_28261_length_151_cov_1.448276_g28003_i0 | PRJEB10320 | 28261 | 151 | 1.448276 | 2.18689676 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 1.5299999999999999e-31 | NTclustered | gi|1027960071|ref|XM_735127.2| | 31271 | g28003 | i0 | 86.131 | 70.9801324503311 | 137 | 19 | 91 | 0 | 3 | 139 | 1112 | 976 | Plasmodium chabaudi chabaudi actin I, putative (PCHAS_1461600), partial mRNA | blastn | 10718 | 148 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 13551 | 13551 | PRJEB10320_P_NODE_28541_length_150_cov_1.600000_g28283_i0 | PRJEB10320 | 28541 | 150 | 1.6 | 2.4 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 7.3e-5 | NTclustered | gi|1145257018|ref|XM_012906115.2| | 5854 | g28283 | i0 | 94.737 | 0.446666666666667 | 38 | 2 | 25 | 0 | 13 | 50 | 5677 | 5714 | Plasmodium reichenowi trafficking protein particle complex subunit 8, putative partial mRNA | blastn | 67 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 982431 | 982431 | PRJEB10320_P_NODE_23921_length_169_cov_1.305970_g23663_i0 | PRJEB10320 | 23921 | 169 | 1.30597 | 2.2070893 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 2.34e-5 | NTclustered | gi|916501459|ref|XM_013496090.1| | 44415 | g23663 | i0 | 100 | 5.80473372781065 | 33 | 0 | 20 | 0 | 120 | 152 | 146 | 178 | Eimeria mitis uncharacterized protein (EMH_0045670), partial mRNA | blastn | 981 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 1287775 | 1287775 | PRJEB10320_P_NODE_14522_length_241_cov_1.553398_g14264_i0 | PRJEB10320 | 14522 | 241 | 1.553398 | 3.74368918 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|401407051|ref|XM_003882926.1| | 572307 | g14264 | i0 | 96.97 | 10.8755186721992 | 33 | 1 | 14 | 0 | 135 | 167 | 428 | 396 | Neospora caninum Liverpool conserved hypothetical protein (NCLIV_027320), partial mRNA | blastn | 2621 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 3839755 | 3839755 | PRJEB10320_P_NODE_5384_length_455_cov_9.404762_g5135_i0 | PRJEB10320 | 5384 | 455 | 9.404762 | 42.7916671 | Plasmodium cynomolgi | 5827 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.003 | NTclustered | gi|457871854|ref|XM_004222799.1| | 1120755 | g5135 | i0 | 90.476 | 0.232967032967033 | 42 | 4 | 9 | 0 | 375 | 416 | 699 | 658 | Plasmodium cynomolgi strain B transcription factor with AP2 domain(s) (PCYB_102500) mRNA, complete cds | blastn | 106 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium cynomolgi | ||
| 10216298 | 10216298 | PRJEB10320_P_NODE_20369_length_190_cov_1.548387_g20111_i0 | PRJEB10320 | 20369 | 190 | 1.548387 | 2.9419353 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 2.71e-5 | NTclustered | gi|1085116469|ref|XM_018779636.1| | 508771 | g20111 | i0 | 90 | 9.51578947368421 | 50 | 2 | 25 | 3 | 107 | 153 | 5910 | 5861 | Toxoplasma gondii ME49 Dopey, N-terminal domain-containing protein mRNA | blastn | 1808 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 20414173 | 20414173 | PRJEB10320_P_NODE_27077_length_155_cov_1.666667_g26819_i0 | PRJEB10320 | 27077 | 155 | 1.666667 | 2.58333385 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 7.62e-5 | NTclustered | gi|1620114166|ref|XM_028670251.1| | 5849 | g26819 | i0 | 97.222 | 2.66451612903226 | 36 | 0 | 23 | 1 | 68 | 103 | 3155 | 3121 | Plasmodium gallinaceum conserved protein, unknown function (PGAL8A_00390500), partial mRNA | blastn | 413 | 60.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 21690172 | 21690172 | PRJEB10320_P_NODE_24818_length_165_cov_1.230769_g24560_i0 | PRJEB10320 | 24818 | 165 | 1.230769 | 2.03076885 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 3.73e-23 | NTclustered | gi|1270522599|ref|XM_721458.2| | 5861 | g24560 | i0 | 91.011 | 19.2242424242424 | 89 | 8 | 54 | 0 | 75 | 163 | 1712 | 1624 | Plasmodium yoelii uncharacterized protein (PY17X_1242900), partial mRNA | blastn | 3172 | 121 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii |
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);;