contig_metadata
6 rows where bioproject = "PRJNA330616", tax_clade = "Metamonada" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15692392 | 15692392 | PRJNA330616_P_NODE_25693_length_167_cov_0.864407_g25284_i0 | PRJNA330616 | 25693 | 167 | 0.864407 | 1.44355969 | Tritrichomonadida | 740972 | Parabasalia | other_Eukaryota | 87 | 2.75e-18 | NR | AIL82370.1 | 43352 | g25284 | i0 | 76.4 | 11.8562874251497 | 55 | 13 | 98.8 | 0 | 167 | 3 | 193 | 247 | AIL82370.1 beta-tubulin 1 [Dientamoeba fragilis] | diamond | 1980 | 87.8 | 0.990888382687927 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Dientamoeba | Dientamoeba fragilis | |||
| 28527561 | 28527561 | PRJNA330616_P_NODE_30907_length_162_cov_0.902655_g30498_i0 | PRJNA330616 | 30907 | 162 | 0.902655 | 1.4623011 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 43.1 | 0.00907 | NR | KAJ5079178.1 | 1746090 | g30498 | i0 | 55.9 | 0.62962962962963 | 34 | 15 | 63 | 0 | 60 | 161 | 265 | 298 | KAJ5079178.1 hypothetical protein M0811_14562 [Anaeramoeba ignava] | diamond | 102 | 43.1 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 30137392 | 30137392 | PRJNA330616_P_NODE_10432_length_256_cov_1.188406_g10023_i0 | PRJNA330616 | 10432 | 256 | 1.188406 | 3.04231936 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 60.1 | 6.9e-9 | NR | KAG9392754.1 | 201153 | g10023 | i0 | 42.4 | 0.7734375 | 66 | 33 | 77.3 | 1 | 255 | 58 | 103 | 163 | KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera] | diamond | 198 | 60.1 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 32002878 | 32002878 | PRJNA330616_P_NODE_24638_length_170_cov_1.264463_g24229_i0 | PRJNA330616 | 24638 | 170 | 1.264463 | 2.1495871 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 55.8 | 3.3e-7 | NR | KAJ5076917.1 | 1746090 | g24229 | i0 | 45.6 | 5.77058823529412 | 57 | 28 | 95.3 | 1 | 170 | 9 | 18 | 74 | KAJ5076917.1 alpha-actinin-2 [Anaeramoeba ignava] | diamond | 981 | 55.8 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 32002884 | 32002884 | PRJNA330616_P_NODE_4318_length_410_cov_2.141274_g3910_i0 | PRJNA330616 | 4318 | 410 | 2.141274 | 8.7792234 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 92.8 | 7.74e-19 | NR | KAJ5072076.1 | 1746090 | g3910 | i0 | 41.1 | 1.77073170731707 | 124 | 70 | 89.3 | 2 | 372 | 7 | 14 | 136 | KAJ5072076.1 alpha-actinin-2 [Anaeramoeba ignava] | diamond | 726 | 92.8 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 32509375 | 32509375 | PRJNA330616_P_NODE_16719_length_205_cov_1.301282_g16310_i0 | PRJNA330616 | 16719 | 205 | 1.301282 | 2.6676281 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 73.2 | 4.3e-13 | NR | KAJ4462635.1 | 342808 | g16310 | i0 | 50 | 0.995121951219512 | 68 | 34 | 99.5 | 0 | 204 | 1 | 313 | 380 | KAJ4462635.1 putative Lysosomal alpha-mannosidase [Paratrimastix pyriformis] | diamond | 204 | 73.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis |
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);;