contig_metadata
12 rows where bioproject = "PRJNA853194" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 840031 | 840031 | PRJNA853194_S_NODE_26201_length_402_cov_3.577508_g25110_i0 | PRJNA853194 | 26201 | 402 | 3.577508 | 14.38158216 | Dinema validum | 2704078 | Euglenozoa | other_Eukaryota | 52.8 | 0.039 | NTclustered | gi|1803019085|gb|MT007857.1| | 2704078 | g25110 | i0 | 100 | 0.0696517412935323 | 28 | 0 | 7 | 0 | 373 | 400 | 35 | 8 | Dinema validum isolate AB2_2 small subunit ribosomal RNA gene, partial sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Dinema | Dinema validum | ||
| 11044561 | 11044561 | PRJNA853194_S_NODE_69169_length_264_cov_1.460733_g68078_i0 | PRJNA853194 | 69169 | 264 | 1.460733 | 3.85633512 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|290997461|ref|XM_002681254.1| | 5762 | g68078 | i0 | 100 | 0.109848484848485 | 29 | 0 | 11 | 0 | 65 | 93 | 4483 | 4455 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_56974), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 16143852 | 16143852 | PRJNA853194_S_NODE_76713_length_251_cov_0.865169_g75622_i0 | PRJNA853194 | 76713 | 251 | 0.865169 | 2.17157419 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2119429064|ref|XM_044701777.1| | 5763 | g75622 | i0 | 100 | 0.223107569721116 | 28 | 0 | 11 | 0 | 58 | 85 | 643 | 670 | Naegleria fowleri uncharacterized protein (FDP41_011376), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 18692254 | 18692254 | PRJNA853194_S_NODE_695_length_1626_cov_44.938184_g464_i1 | PRJNA853194 | 695 | 1626 | 44.938184 | 730.69487184 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 77.4 | 2.29e-12 | NR | KAL0490624.1 | 1008807 | g464 | i1 | 38.1 | 0.208487084870849 | 113 | 63 | 19.6 | 3 | 1528 | 1211 | 6 | 118 | KAL0490624.1 DR1 [Acrasis kona] | diamond | 339 | 77.4 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 19967539 | 19967539 | PRJNA853194_S_NODE_736_length_1595_cov_45.541393_g464_i2 | PRJNA853194 | 736 | 1595 | 45.541393 | 726.38521835 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 77.4 | 2.23e-12 | NR | KAL0490624.1 | 1008807 | g464 | i2 | 38.1 | 0.212539184952978 | 113 | 63 | 19.9 | 3 | 99 | 416 | 6 | 118 | KAL0490624.1 DR1 [Acrasis kona] | diamond | 339 | 77.4 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27663625 | 27663625 | PRJNA853194_S_NODE_9104_length_621_cov_2.556569_g8083_i0 | PRJNA853194 | 9104 | 621 | 2.556569 | 15.87629349 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 88.2 | 2e-16 | NR | XP_044568463.1 | 5763 | g8083 | i0 | 32 | 12.3864734299517 | 200 | 111 | 86.5 | 5 | 7 | 543 | 67 | 262 | XP_044568463.1 uncharacterized protein FDP41_007665 [Naegleria fowleri] | diamond | 7692 | 89 | 0.991011235955056 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 28642419 | 28642419 | PRJNA853194_S_NODE_3867_length_891_cov_61.440098_g3129_i0 | PRJNA853194 | 3867 | 891 | 61.440098 | 547.43127318 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 49.7 | 0.011 | NR | XP_002675654.1 | 5762 | g3129 | i0 | 43.4 | 1.12457912457912 | 53 | 30 | 17.8 | 0 | 607 | 765 | 450 | 502 | XP_002675654.1 uncharacterized protein NAEGRDRAFT_80282 [Naegleria gruberi] | diamond | 1002 | 50.1 | 0.992015968063872 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28737011 | 28737011 | PRJNA853194_S_NODE_17827_length_468_cov_14.789873_g16738_i0 | PRJNA853194 | 17827 | 468 | 14.789873 | 69.21660564 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 108 | 2.3599999999999997e-25 | NR | KAG8339691.1 | 5699 | g16738 | i0 | 43.8 | 4.30769230769231 | 112 | 63 | 71.8 | 0 | 1 | 336 | 202 | 313 | KAG8339691.1 putative GDP-L-fucose synthetase [Trypanosoma vivax] | diamond | 2016 | 109 | 0.990825688073395 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma vivax | ||
| 28791726 | 28791726 | PRJNA853194_S_NODE_11807_length_556_cov_2.906832_g10744_i0 | PRJNA853194 | 11807 | 556 | 2.906832 | 16.16198592 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 52 | 4.42e-4 | NR | XP_002673421.1 | 5762 | g10744 | i0 | 47.3 | 0.296762589928058 | 55 | 29 | 29.7 | 0 | 392 | 556 | 398 | 452 | XP_002673421.1 rabGTPase-activating protein [Naegleria gruberi] | diamond | 165 | 52 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29494764 | 29494764 | PRJNA853194_S_NODE_3670_length_911_cov_10.426014_g2951_i0 | PRJNA853194 | 3670 | 911 | 10.426014 | 94.98098754 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 96.7 | 1.05e-18 | NR | XP_044561128.1 | 5763 | g2951 | i0 | 35.1 | 3.75411635565313 | 154 | 90 | 47.4 | 1 | 631 | 200 | 220 | 373 | XP_044561128.1 uncharacterized protein FDP41_004314 [Naegleria fowleri] | diamond | 3420 | 97.4 | 0.992813141683778 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 32236714 | 32236714 | PRJNA853194_S_NODE_6238_length_733_cov_68.833333_g5330_i0 | PRJNA853194 | 6238 | 733 | 68.833333 | 504.54833089 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 190 | 1.71e-52 | NR | KAJ9461372.1 | 91374 | g5330 | i0 | 42.4 | 0.859481582537517 | 210 | 121 | 85.9 | 0 | 3 | 632 | 420 | 629 | KAJ9461372.1 Proline dehydrogenase 1 [Diplonema papillatum] | diamond | 630 | 190 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 32836114 | 32836114 | PRJNA853194_S_NODE_7360_length_682_cov_9.034483_g6394_i0 | PRJNA853194 | 7360 | 682 | 9.034483 | 61.61517406 | Phytomonas sp. Hart1 | 223615 | Euglenozoa | other_Eukaryota | 47 | 0.0418 | NR | CCW67193.1 | 223615 | g6394 | i0 | 21.7 | 0.708211143695015 | 161 | 119 | 70.8 | 3 | 169 | 651 | 220 | 373 | CCW67193.1 unnamed protein product [Phytomonas sp. Hart1] | diamond | 483 | 47 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Phytomonas | Phytomonas sp. Hart1 |
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);;