contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1103784" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1486882 | 1486882 | PRJNA1103784_P_NODE_8222_length_200_cov_4.078740_g8167_i0 | PRJNA1103784 | 8222 | 200 | 4.07874 | 8.15748 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 81.3 | 2.46e-17 | NR | KAG9390140.1 | 201153 | g8167 | i0 | 61.5 | 12.675 | 65 | 25 | 97.5 | 0 | 5 | 199 | 98 | 162 | KAG9390140.1 Ribosomal protein L22/L17 [Carpediemonas membranifera] | diamond | 2535 | 81.3 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27194002 | 27194002 | PRJNA1103784_P_NODE_7582_length_242_cov_0.911243_g7527_i0 | PRJNA1103784 | 7582 | 242 | 0.911243 | 2.20520806 | Trichomonas vaginalis | 5722 | Parabasalia | other_Eukaryota | 68.2 | 3.95e-11 | NR | AAT95875.1 | 5722 | g7527 | i0 | 53.6 | 2.36776859504132 | 56 | 26 | 69.4 | 0 | 181 | 14 | 223 | 278 | AAT95875.1 prolyl-tRNA synthetase, partial [Trichomonas vaginalis] | diamond | 573 | 68.2 | 1 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 28362447 | 28362447 | PRJNA1103784_P_NODE_7646_length_242_cov_0.911243_g7591_i0 | PRJNA1103784 | 7646 | 242 | 0.911243 | 2.20520806 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 82 | 4.17e-16 | NR | KAJ5076378.1 | 1746090 | g7591 | i0 | 56.4 | 0.966942148760331 | 78 | 24 | 96.7 | 2 | 235 | 2 | 190 | 257 | KAJ5076378.1 cyanophycinase [Anaeramoeba ignava] | diamond | 234 | 82 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 29499147 | 29499147 | PRJNA1103784_P_NODE_7970_length_236_cov_2.159509_g7915_i0 | PRJNA1103784 | 7970 | 236 | 2.159509 | 5.09644124 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 64.7 | 5.68e-10 | NR | KAJ5070569.1 | 1746090 | g7915 | i0 | 40.3 | 0.978813559322034 | 77 | 45 | 97.9 | 1 | 6 | 236 | 60 | 135 | KAJ5070569.1 adp-ribose glycohydrolase arh3 [Anaeramoeba ignava] | diamond | 231 | 64.7 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 31141564 | 31141564 | PRJNA1103784_P_NODE_2395_length_346_cov_1.128205_g2340_i0 | PRJNA1103784 | 2395 | 346 | 1.128205 | 3.9035893 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 100 | 9.68e-22 | NR | KAJ5066923.1 | 1746090 | g2340 | i0 | 44.4 | 3.02601156069364 | 117 | 63 | 99.7 | 1 | 1 | 345 | 165 | 281 | KAJ5066923.1 severin [Anaeramoeba ignava] | diamond | 1047 | 100 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 31204673 | 31204673 | PRJNA1103784_P_NODE_4815_length_266_cov_1.435233_g4760_i0 | PRJNA1103784 | 4815 | 266 | 1.435233 | 3.81771978 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 75.5 | 1.17e-13 | NR | KAJ4460207.1 | 342808 | g4760 | i0 | 43.2 | 0.992481203007519 | 88 | 50 | 99.2 | 0 | 3 | 266 | 73 | 160 | KAJ4460207.1 putative Ribose-phosphate pyrophosphokinase 4 [Paratrimastix pyriformis] | diamond | 264 | 75.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32027604 | 32027604 | PRJNA1103784_P_NODE_7098_length_244_cov_0.900585_g7043_i0 | PRJNA1103784 | 7098 | 244 | 0.900585 | 2.1974274 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 137 | 1.51e-39 | NR | KAJ5074353.1 | 1746090 | g7043 | i0 | 75.9 | 3.88524590163934 | 79 | 19 | 97.1 | 0 | 243 | 7 | 35 | 113 | KAJ5074353.1 hypothetical protein M0811_00982 [Anaeramoeba ignava] | diamond | 948 | 137 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 32090886 | 32090886 | PRJNA1103784_P_NODE_1798_length_388_cov_1.295238_g1743_i0 | PRJNA1103784 | 1798 | 388 | 1.295238 | 5.02552344 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 129 | 1.03e-32 | NR | KAJ3433740.1 | 1746091 | g1743 | i0 | 54.9 | 0.873711340206186 | 113 | 51 | 87.4 | 0 | 15 | 353 | 318 | 430 | KAJ3433740.1 serine carboxypeptidase-like 48-related [Anaeramoeba flamelloides] | diamond | 339 | 129 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 32785723 | 32785723 | PRJNA1103784_P_NODE_4260_length_277_cov_1.328431_g4205_i0 | PRJNA1103784 | 4260 | 277 | 1.328431 | 3.67975387 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 70.9 | 4.48e-12 | NR | KAJ5076044.1 | 1746090 | g4205 | i0 | 43.8 | 0.866425992779783 | 80 | 44 | 86.6 | 1 | 36 | 275 | 41 | 119 | KAJ5076044.1 cysteine protease rdl2-related [Anaeramoeba ignava] | diamond | 240 | 70.9 | 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);;