contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA879221" and tax_clade = "Sar"
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 | ||
| 28255333 | 28255333 | PRJNA879221_P_NODE_51386_length_248_cov_0.880000_g51246_i0 | PRJNA879221 | 51386 | 248 | 0.88 | 2.1824 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 2.04e-8 | NR | KAL4451154.1 | 5901 | g51246 | i0 | 100 | 0.314516129032258 | 26 | 0 | 31.5 | 0 | 117 | 194 | 3 | 28 | KAL4451154.1 hypothetical protein ABPG74_021476 [Tetrahymena malaccensis] | diamond | 78 | 59.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 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 | ||
| 29802495 | 29802495 | PRJNA879221_P_NODE_52831_length_247_cov_0.885057_g52691_i0 | PRJNA879221 | 52831 | 247 | 0.885057 | 2.18609079 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 7.83e-19 | NR | CDW73391.1 | 5949 | g52691 | i0 | 52.5 | 0.97165991902834 | 80 | 38 | 97.2 | 0 | 6 | 245 | 87 | 166 | CDW73391.1 exodeoxyribonuclease iii family protein [Stylonychia lemnae] | diamond | 240 | 90.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 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 | ||
| 30718711 | 30718711 | PRJNA879221_P_NODE_46814_length_251_cov_0.865169_g46674_i0 | PRJNA879221 | 46814 | 251 | 0.865169 | 2.17157419 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0208 | NR | GLD97309.1 | 114742 | g46674 | i0 | 38.8 | 0.585657370517928 | 49 | 27 | 58.6 | 1 | 168 | 22 | 6 | 51 | GLD97309.1 hypothetical protein PINS_up005993 [Pythium insidiosum] | diamond | 147 | 42.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 30813534 | 30813534 | PRJNA879221_P_NODE_54094_length_247_cov_0.885057_g53954_i0 | PRJNA879221 | 54094 | 247 | 0.885057 | 2.18609079 | Tetrahymena utriculariae | 2486642 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 2.14e-13 | NR | KAL4466677.1 | 2486642 | g53954 | i0 | 65.6 | 0.777327935222672 | 64 | 22 | 77.7 | 0 | 24 | 215 | 78 | 141 | KAL4466677.1 hypothetical protein ABPG72_016794 [Tetrahymena utriculariae] | diamond | 192 | 74.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena utriculariae | ||
| 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);;