contig_metadata
9 rows where bioproject = "PRJNA879221", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26770451 | 26770451 | PRJNA879221_P_NODE_46381_length_251_cov_0.865169_g46241_i0 | PRJNA879221 | 46381 | 251 | 0.865169 | 2.17157419 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 8.62e-9 | NR | SBT55340.1 | 864142 | g46241 | i0 | 50 | 0.812749003984064 | 68 | 32 | 78.9 | 1 | 232 | 35 | 317 | 384 | SBT55340.1 PIR Superfamily Protein [Plasmodium ovale wallikeri] | diamond | 204 | 61.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 27149670 | 27149670 | PRJNA879221_P_NODE_34182_length_301_cov_1.245614_g34042_i0 | PRJNA879221 | 34182 | 301 | 1.245614 | 3.74929814 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 46.2 | 0.00436 | NR | SBT55483.1 | 864142 | g34042 | i0 | 69 | 0.418604651162791 | 42 | 13 | 41.9 | 0 | 3 | 128 | 68 | 109 | SBT55483.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 126 | 46.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 27750498 | 27750498 | PRJNA879221_P_NODE_26364_length_343_cov_5.818519_g26224_i0 | PRJNA879221 | 26364 | 343 | 5.818519 | 19.95752017 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 8.23e-4 | NR | SBT59076.1 | 864142 | g26224 | i0 | 59.5 | 0.323615160349854 | 37 | 15 | 32.4 | 0 | 124 | 14 | 14 | 50 | SBT59076.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 111 | 48.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 27876524 | 27876524 | PRJNA879221_P_NODE_52785_length_247_cov_0.885057_g52645_i0 | PRJNA879221 | 52785 | 247 | 0.885057 | 2.18609079 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 2.44e-5 | NR | SBT55900.1 | 864142 | g52645 | i0 | 67.6 | 0.449392712550607 | 37 | 12 | 44.9 | 0 | 128 | 18 | 14 | 50 | SBT55900.1 PIR Superfamily Protein [Plasmodium ovale wallikeri] | diamond | 111 | 51.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 28886812 | 28886812 | PRJNA879221_P_NODE_55068_length_246_cov_0.890173_g54928_i0 | PRJNA879221 | 55068 | 246 | 0.890173 | 2.18982558 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 4.91e-12 | NR | SBT55483.1 | 864142 | g54928 | i0 | 50 | 1.76829268292683 | 70 | 35 | 85.4 | 0 | 34 | 243 | 37 | 106 | SBT55483.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 435 | 70.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 29644292 | 29644292 | PRJNA879221_P_NODE_18330_length_415_cov_1.450292_g18191_i0 | PRJNA879221 | 18330 | 415 | 1.450292 | 6.0187118 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 1.32e-8 | NR | SBT55483.1 | 864142 | g18191 | i0 | 63.6 | 0.397590361445783 | 55 | 20 | 39.8 | 0 | 130 | 294 | 46 | 100 | SBT55483.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 165 | 63.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 30655526 | 30655526 | PRJNA879221_P_NODE_47593_length_250_cov_0.887006_g47453_i0 | PRJNA879221 | 47593 | 250 | 0.887006 | 2.217515 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 7.05e-4 | NR | SBT55483.1 | 864142 | g47453 | i0 | 57.8 | 0.54 | 45 | 19 | 54 | 0 | 32 | 166 | 56 | 100 | SBT55483.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 135 | 47.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 31825120 | 31825120 | PRJNA879221_P_NODE_54497_length_246_cov_1.109827_g54357_i0 | PRJNA879221 | 54497 | 246 | 1.109827 | 2.73017442 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 1.16e-8 | NR | SBT55483.1 | 864142 | g54357 | i0 | 46 | 1.40243902439024 | 63 | 34 | 76.8 | 0 | 9 | 197 | 37 | 99 | SBT55483.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 345 | 61.2 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 32773393 | 32773393 | PRJNA879221_P_NODE_30480_length_320_cov_0.890688_g30340_i0 | PRJNA879221 | 30480 | 320 | 0.890688 | 2.8502016 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 3.02e-9 | NR | SBT55340.1 | 864142 | g30340 | i0 | 58.2 | 1.55625 | 55 | 23 | 51.6 | 0 | 11 | 175 | 304 | 358 | SBT55340.1 PIR Superfamily Protein [Plasmodium ovale wallikeri] | diamond | 498 | 63.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale |
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);;