contig_metadata
7 rows where bioproject = "PRJNA554794" and tax_clade = "Metamonada"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3674782 | 3674782 | PRJNA554794_P_NODE_19563_length_208_cov_1.245283_g15634_i0 | PRJNA554794 | 19563 | 208 | 1.245283 | 2.59018864 | Monocercomonoides | 302781 | Preaxostyla | other_Eukaryota | 167 | 6.24e-37 | NTclustered | gi|156708135|gb|EF474125.1| | 302782 | g15634 | i0 | 81.429 | 76.9663461538462 | 210 | 33 | 99 | 3 | 1 | 207 | 750 | 956 | Monocercomonoides sp. PA clone 1/2 translation elongation factor-1 alpha mRNA, complete cds | blastn | 16009 | 167 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides sp. PA | |||
| 28404684 | 28404684 | PRJNA554794_P_NODE_13666_length_239_cov_1.931579_g9737_i0 | PRJNA554794 | 13666 | 239 | 1.931579 | 4.61647381 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 61.2 | 1.08e-8 | NR | XP_067766864.1 | 348837 | g9737 | i0 | 48.3 | 0.753138075313807 | 60 | 30 | 74.1 | 1 | 194 | 18 | 442 | 501 | XP_067766864.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 180 | 61.2 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 29414955 | 29414955 | PRJNA554794_P_NODE_20909_length_187_cov_0.949275_g16980_i0 | PRJNA554794 | 20909 | 187 | 0.949275 | 1.77514425 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 54.7 | 1.08e-6 | NR | KAJ6235358.1 | 1746091 | g16980 | i0 | 54.5 | 1.41176470588235 | 44 | 20 | 70.6 | 0 | 55 | 186 | 18 | 61 | KAJ6235358.1 glutamate dehydrogenase 1 [Anaeramoeba flamelloides] | diamond | 264 | 54.7 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 29698807 | 29698807 | PRJNA554794_P_NODE_20150_length_199_cov_0.813333_g16221_i0 | PRJNA554794 | 20150 | 199 | 0.813333 | 1.61853267 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 112 | 7.97e-30 | NR | XP_067763597.1 | 348837 | g16221 | i0 | 76.9 | 0.979899497487437 | 65 | 15 | 98 | 0 | 3 | 197 | 14 | 78 | XP_067763597.1 Nucleoside diphosphate kinase [Spironucleus salmonicida] | diamond | 195 | 112 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 29983469 | 29983469 | PRJNA554794_P_NODE_20791_length_189_cov_0.792857_g16862_i0 | PRJNA554794 | 20791 | 189 | 0.792857 | 1.49849973 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 50.8 | 2.28e-5 | NR | CAK8775660.1 | 28002 | g16862 | i0 | 51 | 0.777777777777778 | 49 | 19 | 77.8 | 2 | 167 | 21 | 143 | 186 | CAK8775660.1 HINF_040625 [Hexamita inflata] | diamond | 147 | 50.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31831042 | 31831042 | PRJNA554794_P_NODE_21957_length_174_cov_1.304000_g18028_i0 | PRJNA554794 | 21957 | 174 | 1.304 | 2.26896 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.5 | 8.38e-9 | NR | ESU40633.1 | 5741 | g18028 | i0 | 56.5 | 3.48275862068966 | 46 | 17 | 79.3 | 1 | 28 | 165 | 356 | 398 | ESU40633.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 606 | 60.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 32228133 | 32228133 | PRJNA554794_P_NODE_14558_length_218_cov_1.461538_g10629_i0 | PRJNA554794 | 14558 | 218 | 1.461538 | 3.18615284 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 77.4 | 2.14e-16 | NR | KAJ5073591.1 | 1746090 | g10629 | i0 | 60.3 | 0.86697247706422 | 63 | 25 | 86.7 | 0 | 29 | 217 | 8 | 70 | KAJ5073591.1 ribosomal protein L35A [Anaeramoeba ignava] | diamond | 189 | 77.4 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava |
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);;