contig_metadata
10 rows where bioproject = "PRJDB12578", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6381500 | 6381500 | PRJDB12578_S_NODE_175146_length_181_cov_1.962121_g152088_i0 | PRJDB12578 | 175146 | 181 | 1.962121 | 3.55143901 | Plasmodium knowlesi | 5850 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.015 | NTclustered | gi|221060455|ref|XM_002260837.1| | 5851 | g152088 | i0 | 100 | 0.154696132596685 | 28 | 0 | 15 | 0 | 8 | 35 | 5944 | 5917 | Plasmodium knowlesi strain H conserved Plasmodium protein, unknown function (PKNH_1345900), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 11183998 | 11183998 | PRJDB12578_S_NODE_104309_length_278_cov_2.406114_g81251_i0 | PRJDB12578 | 104309 | 278 | 2.406114 | 6.68899692 | Toxoplasma | 5810 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 5.5e-4 | NTclustered | gi|820697327|tpe|LN714495.1| | 432359 | g81251 | i0 | 97.059 | 0.244604316546763 | 34 | 1 | 12 | 0 | 4 | 37 | 1298228 | 1298195 | TPA_asm: Toxoplasma gondii VEG, chromosome chrVI, complete genome | blastn | 68 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 11481738 | 11481738 | PRJDB12578_S_NODE_192450_length_169_cov_2.066667_g169392_i0 | PRJDB12578 | 192450 | 169 | 2.066667 | 3.49266723 | Goussia sp. | 2041156 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 2.34e-5 | NTclustered | gi|1707497512|gb|MN202591.1| | 2041156 | g169392 | i0 | 100 | 17.9763313609467 | 33 | 0 | 20 | 0 | 1 | 33 | 600 | 632 | Goussia sp. isolate BG28 small subunit ribosomal RNA gene, partial sequence | blastn | 3038 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia sp. | ||
| 11482486 | 11482486 | PRJDB12578_S_NODE_215190_length_161_cov_3.142857_g192132_i0 | PRJDB12578 | 215190 | 161 | 3.142857 | 5.05999977 | Plasmodium relictum | 85471 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|1620139553|ref|XM_028675492.1| | 85471 | g192132 | i0 | 100 | 0.180124223602484 | 29 | 0 | 18 | 0 | 80 | 108 | 2295 | 2267 | Plasmodium relictum conserved Plasmodium protein, unknown function (PRELSG_0604200), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium relictum | ||
| 16584393 | 16584393 | PRJDB12578_S_NODE_78014_length_410_cov_1.346260_g54959_i0 | PRJDB12578 | 78014 | 410 | 1.34626 | 5.519666 | Toxoplasma gondii | 5811 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.039 | NTclustered | gi|820702250|tpe|LN714502.1| | 432359 | g54959 | i0 | 100 | 0.0682926829268293 | 28 | 0 | 7 | 0 | 208 | 235 | 2713558 | 2713585 | TPA_asm: Toxoplasma gondii VEG, chromosome chrXII, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Toxoplasma | Toxoplasma gondii | ||
| 20404164 | 20404164 | PRJDB12578_S_NODE_185897_length_174_cov_1.032000_g162839_i0 | PRJDB12578 | 185897 | 174 | 1.032 | 1.79568 | Plasmodium chabaudi | 5825 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.015 | NTclustered | gi|1027958967|ref|XM_733927.2| | 31271 | g162839 | i0 | 100 | 0.160919540229885 | 28 | 0 | 16 | 0 | 133 | 160 | 549 | 576 | Plasmodium chabaudi chabaudi ABC transporter B family member 6, putative (PCHAS_1369400), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium chabaudi | ||
| 21683334 | 21683334 | PRJDB12578_S_NODE_60418_length_658_cov_2.441708_g38045_i0 | PRJDB12578 | 60418 | 658 | 2.441708 | 16.06643864 | Plasmodium reichenowi | 5854 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.018 | NTclustered | gi|1145259210|ref|XM_012907452.2| | 5854 | g38045 | i0 | 100 | 0.0440729483282675 | 29 | 0 | 4 | 0 | 348 | 376 | 82 | 54 | Plasmodium reichenowi perforin-like protein 3 partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium reichenowi | ||
| 24227683 | 24227683 | PRJDB12578_S_NODE_140160_length_213_cov_12.103659_g117102_i0 | PRJDB12578 | 140160 | 213 | 12.103659 | 25.78079367 | uncultured Eimeriidae | 404735 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 2.76e-90 | NTclustered | gi|134021988|gb|EF023338.1| | 404735 | g117102 | i0 | 95.775 | 99.9295774647887 | 213 | 9 | 100 | 0 | 1 | 213 | 1659 | 1447 | Eimeriidae environmental sample clone Amb_18S_660 18S ribosomal RNA gene, partial sequence | blastn | 21285 | 344 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 24234087 | 24234087 | PRJDB12578_S_NODE_92420_length_320_cov_3.033210_g69362_i0 | PRJDB12578 | 92420 | 320 | 3.03321 | 9.706272 | Babesia duncani | 323732 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.03 | NTclustered | gi|2794779121|ref|XM_067949009.1| | 323732 | g69362 | i0 | 96.774 | 0.096875 | 31 | 1 | 10 | 0 | 171 | 201 | 199 | 229 | Babesia duncani uncharacterized protein (BdWA1_004005), partial mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia duncani | ||
| 28200780 | 28200780 | PRJDB12578_S_NODE_175286_length_181_cov_1.689394_g152228_i0 | PRJDB12578 | 175286 | 181 | 1.689394 | 3.05780314 | Sarcocystis calchasi | 1344799 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 7e-4 | NR | CAL7863471.1 | 1344799 | g152228 | i0 | 46.3 | 0.679558011049724 | 41 | 22 | 68 | 0 | 57 | 179 | 1342 | 1382 | CAL7863471.1 unnamed protein product [Sarcocystis calchasi] | diamond | 123 | 46.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Sarcocystis | Sarcocystis calchasi |
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);;