contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1120771" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26753228 | 26753228 | PRJNA1120771_S_NODE_19261_length_265_cov_1.175676_g18861_i0 | PRJNA1120771 | 19261 | 265 | 1.175676 | 3.1155414 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 47 | 0.00132 | NR | KAJ4459753.1 | 342808 | g18861 | i0 | 37.7 | 0.690566037735849 | 61 | 38 | 69.1 | 0 | 250 | 68 | 126 | 186 | KAJ4459753.1 putative SNF7 family protein [Paratrimastix pyriformis] | diamond | 183 | 47 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27006697 | 27006697 | PRJNA1120771_S_NODE_18022_length_272_cov_1.414847_g17622_i0 | PRJNA1120771 | 18022 | 272 | 1.414847 | 3.84838384 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 92.4 | 2.08e-21 | NR | KAJ4461579.1 | 342808 | g17622 | i0 | 47.1 | 0.959558823529412 | 87 | 44 | 96 | 1 | 6 | 266 | 59 | 143 | KAJ4461579.1 hypothetical protein PAPYR_2178 [Paratrimastix pyriformis] | diamond | 261 | 92.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30923401 | 30923401 | PRJNA1120771_S_NODE_15694_length_286_cov_2.843621_g15294_i0 | PRJNA1120771 | 15694 | 286 | 2.843621 | 8.13275606 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 43.1 | 0.0485 | NR | KAJ3439615.1 | 1746091 | g15294 | i0 | 29.1 | 0.576923076923077 | 55 | 39 | 57.7 | 0 | 1 | 165 | 3509 | 3563 | KAJ3439615.1 beige/beach-related [Anaeramoeba flamelloides] | diamond | 165 | 43.1 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 31650126 | 31650126 | PRJNA1120771_S_NODE_16277_length_282_cov_4.368201_g15877_i0 | PRJNA1120771 | 16277 | 282 | 4.368201 | 12.31832682 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 86.7 | 2.27e-17 | NR | KAJ5080783.1 | 1746090 | g15877 | i0 | 47.1 | 1.80851063829787 | 85 | 45 | 90.4 | 0 | 282 | 28 | 911 | 995 | KAJ5080783.1 alpha-actinin-2 [Anaeramoeba ignava] | diamond | 510 | 86.7 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 31713604 | 31713604 | PRJNA1120771_S_NODE_5197_length_424_cov_6.377953_g4797_i0 | PRJNA1120771 | 5197 | 424 | 6.377953 | 27.04252072 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 62.4 | 2.94e-8 | NR | KAJ5080539.1 | 1746090 | g4797 | i0 | 65.9 | 1.25943396226415 | 41 | 14 | 29 | 0 | 423 | 301 | 295 | 335 | KAJ5080539.1 guanine nucleotide-binding protein g(o) subunit alpha [Anaeramoeba ignava] | diamond | 534 | 62.4 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 31808507 | 31808507 | PRJNA1120771_S_NODE_26777_length_232_cov_2.608466_g26377_i0 | PRJNA1120771 | 26777 | 232 | 2.608466 | 6.05164112 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 50.1 | 8.78e-5 | NR | KAJ3426080.1 | 1746091 | g26377 | i0 | 64.9 | 0.478448275862069 | 37 | 13 | 47.8 | 0 | 232 | 122 | 824 | 860 | KAJ3426080.1 hypothetical protein M0812_28528 [Anaeramoeba flamelloides] | diamond | 111 | 50.1 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 31934910 | 31934910 | PRJNA1120771_S_NODE_37997_length_197_cov_2.259740_g37597_i0 | PRJNA1120771 | 37997 | 197 | 2.25974 | 4.4516878 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 52.8 | 5.13e-6 | NR | KAJ5075624.1 | 1746090 | g37597 | i0 | 40.6 | 1.88832487309645 | 64 | 35 | 92.9 | 1 | 11 | 193 | 212 | 275 | KAJ5075624.1 hypothetical protein M0811_07194 [Anaeramoeba ignava] | diamond | 372 | 52.8 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 32693712 | 32693712 | PRJNA1120771_S_NODE_18880_length_267_cov_1.553571_g18480_i0 | PRJNA1120771 | 18880 | 267 | 1.553571 | 4.14803457 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 53.9 | 5.53e-6 | NR | KAJ5076591.1 | 1746090 | g18480 | i0 | 30.2 | 1.07865168539326 | 96 | 57 | 98.9 | 3 | 3 | 266 | 348 | 441 | KAJ5076591.1 beta-12-xylosyltransferase [Anaeramoeba ignava] | diamond | 288 | 53.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);;