contig_metadata
12 rows where bioproject = "PRJNA1005695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21830253 | 21830253 | PRJNA1005695_P_NODE_20778_length_331_cov_1.054264_g19926_i0 | PRJNA1005695 | 20778 | 331 | 1.054264 | 3.48961384 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 108 | 8.26e-25 | NR | KAJ5066873.1 | 1746090 | g19926 | i0 | 52 | 4.44108761329305 | 98 | 47 | 88.8 | 0 | 3 | 296 | 1037 | 1134 | KAJ5066873.1 alpha-actinin [Anaeramoeba ignava] | diamond | 1470 | 108 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 26590996 | 26590996 | PRJNA1005695_P_NODE_24261_length_305_cov_1.275862_g23409_i0 | PRJNA1005695 | 24261 | 305 | 1.275862 | 3.8913791 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 114 | 7.810000000000001e-27 | NR | KAJ5066874.1 | 1746090 | g23409 | i0 | 53.5 | 2.96065573770492 | 101 | 47 | 99.3 | 0 | 2 | 304 | 1134 | 1234 | KAJ5066874.1 alpha-actinin [Anaeramoeba ignava] | diamond | 903 | 114 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 26615324 | 26615324 | PRJNA1005695_P_NODE_30041_length_272_cov_2.216080_g29189_i0 | PRJNA1005695 | 30041 | 272 | 2.21608 | 6.0277376 | root | 1 | Root_unresolved | Root_unresolved | 75.9 | 1.18e-13 | NR | KAJ5078559.1 | 1746090 | g29189 | i0 | 42.7 | 3.59558823529412 | 82 | 47 | 90.4 | 0 | 2 | 247 | 762 | 843 | KAJ5078559.1 alpha-actinin sarcomeric-like protein [Anaeramoeba ignava] | diamond | 978 | 75.9 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 26622860 | 26622860 | PRJNA1005695_P_NODE_8401_length_540_cov_1.389722_g7556_i0 | PRJNA1005695 | 8401 | 540 | 1.389722 | 7.5044988 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 56.2 | 1.43e-5 | NR | KAJ5075787.1 | 1746090 | g7556 | i0 | 61.5 | 0.216666666666667 | 39 | 14 | 21.7 | 1 | 241 | 125 | 436 | 473 | KAJ5075787.1 fad-dependent oxidoreductase [Anaeramoeba ignava] | diamond | 117 | 56.2 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 28645222 | 28645222 | PRJNA1005695_P_NODE_16247_length_376_cov_1.544554_g15395_i0 | PRJNA1005695 | 16247 | 376 | 1.544554 | 5.80752304 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 69.3 | 8.83e-11 | NR | KAJ5078494.1 | 1746090 | g15395 | i0 | 35.8 | 2.97606382978723 | 123 | 73 | 95.7 | 3 | 372 | 13 | 970 | 1089 | KAJ5078494.1 alpha-actinin sarcomeric-like protein [Anaeramoeba ignava] | diamond | 1119 | 69.3 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 29908293 | 29908293 | PRJNA1005695_P_NODE_4911_length_718_cov_2.203101_g4127_i0 | PRJNA1005695 | 4911 | 718 | 2.203101 | 15.81826518 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 229 | 1.49e-65 | NR | KAJ5076917.1 | 1746090 | g4127 | i0 | 53.8 | 5.6949860724234 | 238 | 109 | 99.4 | 1 | 716 | 3 | 235 | 471 | KAJ5076917.1 alpha-actinin-2 [Anaeramoeba ignava] | diamond | 4089 | 229 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 30192384 | 30192384 | PRJNA1005695_P_NODE_33232_length_258_cov_2.464865_g32380_i0 | PRJNA1005695 | 33232 | 258 | 2.464865 | 6.3593517 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 52 | 2.19e-5 | NR | KAJ3425756.1 | 1746091 | g32380 | i0 | 29.4 | 6.03488372093023 | 85 | 59 | 97.7 | 1 | 257 | 6 | 169 | 253 | KAJ3425756.1 rhomboid-like protein [Anaeramoeba flamelloides] | diamond | 1557 | 52 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 30287632 | 30287632 | PRJNA1005695_P_NODE_2572_length_993_cov_4.177174_g2012_i0 | PRJNA1005695 | 2572 | 993 | 4.177174 | 41.47933782 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 89.4 | 1.37e-15 | NR | KAJ3452070.1 | 1746091 | g2012 | i0 | 26.5 | 3.01510574018127 | 162 | 114 | 47.4 | 3 | 869 | 399 | 299 | 460 | KAJ3452070.1 hypothetical protein M0812_03833 [Anaeramoeba flamelloides] | diamond | 2994 | 89.4 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 30319379 | 30319379 | PRJNA1005695_P_NODE_12992_length_426_cov_2.577904_g12140_i0 | PRJNA1005695 | 12992 | 426 | 2.577904 | 10.98187104 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 85.9 | 2.43e-16 | NR | KAJ5066873.1 | 1746090 | g12140 | i0 | 39.4 | 1.86619718309859 | 132 | 80 | 93 | 0 | 26 | 421 | 753 | 884 | KAJ5066873.1 alpha-actinin [Anaeramoeba ignava] | diamond | 795 | 85.9 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 31804364 | 31804364 | PRJNA1005695_P_NODE_35317_length_251_cov_2.764045_g34465_i0 | PRJNA1005695 | 35317 | 251 | 2.764045 | 6.93775295 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 73.9 | 4.3e-13 | NR | KAJ5072076.1 | 1746090 | g34465 | i0 | 45.1 | 5.8804780876494 | 82 | 45 | 98 | 0 | 246 | 1 | 49 | 130 | KAJ5072076.1 alpha-actinin-2 [Anaeramoeba ignava] | diamond | 1476 | 73.9 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 31962619 | 31962619 | PRJNA1005695_P_NODE_22538_length_316_cov_2.218107_g21686_i0 | PRJNA1005695 | 22538 | 316 | 2.218107 | 7.00921812 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 140 | 6.17e-36 | NR | KAJ5073429.1 | 1746090 | g21686 | i0 | 62.9 | 4.98417721518987 | 105 | 39 | 99.7 | 0 | 315 | 1 | 137 | 241 | KAJ5073429.1 alpha-actinin-2 [Anaeramoeba ignava] | diamond | 1575 | 140 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 32564096 | 32564096 | PRJNA1005695_P_NODE_23499_length_310_cov_1.708861_g22647_i0 | PRJNA1005695 | 23499 | 310 | 1.708861 | 5.2974691 | Tritrichomonas musculus | 1915356 | Parabasalia | other_Eukaryota | 67.4 | 1.59e-10 | NR | KAK8834263.1 | 1915356 | g22647 | i0 | 52.6 | 1.08387096774194 | 57 | 27 | 55.2 | 0 | 172 | 2 | 176 | 232 | KAK8834263.1 hypothetical protein M9Y10_032070 [Tritrichomonas musculus] | diamond | 336 | 67.4 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas musculus |
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);;