contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1035005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 169180 | 169180 | PRJNA1035005_P_NODE_8721_length_380_cov_1.263844_g8319_i0 | PRJNA1035005 | 8721 | 380 | 1.263844 | 4.8026072 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 86.7 | 4.19e-19 | NR | KAJ4453711.1 | 342808 | g8319 | i0 | 56.8 | 1.22368421052632 | 81 | 29 | 61.6 | 2 | 16 | 249 | 2 | 79 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 465 | 86.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 23120845 | 23120845 | PRJNA1035005_P_NODE_10379_length_360_cov_1.425087_g9974_i0 | PRJNA1035005 | 10379 | 360 | 1.425087 | 5.1303132 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 120 | 2.6199999999999997e-30 | NR | KAJ5079679.1 | 1746090 | g9974 | i0 | 50.4 | 2.975 | 119 | 55 | 99.2 | 2 | 358 | 2 | 26 | 140 | KAJ5079679.1 cysteine protease rdl2-related [Anaeramoeba ignava] | diamond | 1071 | 120 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 29466348 | 29466348 | PRJNA1035005_P_NODE_10970_length_354_cov_1.387900_g10565_i0 | PRJNA1035005 | 10970 | 354 | 1.3879 | 4.913166 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 87.8 | 1.4e-17 | NR | KAJ5072157.1 | 1746090 | g10565 | i0 | 56.6 | 0.644067796610169 | 76 | 33 | 64.4 | 0 | 284 | 57 | 235 | 310 | KAJ5072157.1 nucleic acid binding protein [Anaeramoeba ignava] | diamond | 228 | 87.8 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 29521850 | 29521850 | PRJNA1035005_P_NODE_33470_length_278_cov_1.448780_g33064_i0 | PRJNA1035005 | 33470 | 278 | 1.44878 | 4.0276084 | Anaeramoeba | 2055135 | Root_unresolved | Root_unresolved | 105 | 6.779999999999998e-24 | NR | KAJ5068815.1 | 1746090 | g33064 | i0 | 56 | 2.76258992805755 | 84 | 35 | 90.6 | 1 | 277 | 26 | 641 | 722 | KAJ5068815.1 villin [Anaeramoeba ignava] | diamond | 768 | 105 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 29624109 | 29624109 | PRJNA1035005_P_NODE_56590_length_252_cov_0.871508_g56184_i0 | PRJNA1035005 | 56590 | 252 | 0.871508 | 2.19620016 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 53.5 | 6.28e-6 | NR | XP_067772619.1 | 135588 | g56184 | i0 | 60 | 0.476190476190476 | 40 | 16 | 47.6 | 0 | 250 | 131 | 407 | 446 | XP_067772619.1 vacuolar protein sorting-associated protein 4A [Histomonas meleagridis] | diamond | 120 | 53.5 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 30603779 | 30603779 | PRJNA1035005_P_NODE_52573_length_254_cov_1.237569_g52167_i0 | PRJNA1035005 | 52573 | 254 | 1.237569 | 3.14342526 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 81.3 | 1.2e-15 | NR | KAJ5066923.1 | 1746090 | g52167 | i0 | 52.4 | 0.968503937007874 | 82 | 36 | 96.9 | 1 | 8 | 253 | 201 | 279 | KAJ5066923.1 severin [Anaeramoeba ignava] | diamond | 246 | 81.3 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 30603786 | 30603786 | PRJNA1035005_P_NODE_6293_length_428_cov_1.318310_g5891_i0 | PRJNA1035005 | 6293 | 428 | 1.31831 | 5.6423668 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 162 | 2.42e-48 | NR | KAJ5077140.1 | 1746090 | g5891 | i0 | 63 | 3.56775700934579 | 127 | 47 | 89 | 0 | 383 | 3 | 1 | 127 | KAJ5077140.1 60S ribosomal protein L32 AND DNA-DIRECTED RNA polymerase II SUBUNIT N [Anaeramoeba ignava] | diamond | 1527 | 162 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 30983200 | 30983200 | PRJNA1035005_P_NODE_55154_length_253_cov_0.866667_g54748_i0 | PRJNA1035005 | 55154 | 253 | 0.866667 | 2.19266751 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 94.7 | 1.8899999999999998e-20 | NR | KAJ3452484.1 | 1746091 | g54748 | i0 | 49.4 | 6.90118577075099 | 83 | 42 | 98.4 | 0 | 1 | 249 | 32 | 114 | KAJ3452484.1 sterile20-like kinase isoform b-related [Anaeramoeba flamelloides] | diamond | 1746 | 94.7 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 31868306 | 31868306 | PRJNA1035005_P_NODE_78497_length_244_cov_1.502924_g78091_i0 | PRJNA1035005 | 78497 | 244 | 1.502924 | 3.66713456 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 84 | 7.32e-17 | NR | KAJ4460283.1 | 342808 | g78091 | i0 | 52.5 | 0.983606557377049 | 80 | 38 | 98.4 | 0 | 242 | 3 | 234 | 313 | KAJ4460283.1 putative SPFH domain/Band 7 family protein [Paratrimastix pyriformis] | diamond | 240 | 84 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32184932 | 32184932 | PRJNA1035005_P_NODE_52398_length_254_cov_1.464088_g51992_i0 | PRJNA1035005 | 52398 | 254 | 1.464088 | 3.71878352 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 66.2 | 4.87e-11 | NR | KAJ3450635.1 | 1746091 | g51992 | i0 | 66.7 | 1.2755905511811 | 51 | 17 | 60.2 | 0 | 1 | 153 | 132 | 182 | KAJ3450635.1 ras-like protein rasd [Anaeramoeba flamelloides] | diamond | 324 | 66.2 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 32525223 | 32525223 | PRJNA1035005_P_NODE_41459_length_268_cov_1.128205_g41053_i0 | PRJNA1035005 | 41459 | 268 | 1.128205 | 3.0235894 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.00755 | NR | KAJ6248791.1 | 1746091 | g41053 | i0 | 38.2 | 1.36567164179104 | 55 | 29 | 61.6 | 1 | 185 | 21 | 21 | 70 | KAJ6248791.1 hypothetical protein M0813_17282 [Anaeramoeba flamelloides] | diamond | 366 | 45.1 | 0.991130820399113 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 32690321 | 32690321 | PRJNA1035005_P_NODE_11320_length_351_cov_1.104317_g10915_i0 | PRJNA1035005 | 11320 | 351 | 1.104317 | 3.87615267 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 50.4 | 2.51e-4 | NR | KAJ5073099.1 | 1746090 | g10915 | i0 | 27 | 0.948717948717949 | 111 | 81 | 94.9 | 0 | 337 | 5 | 131 | 241 | KAJ5073099.1 alpha-actinin sarcomeric-like protein [Anaeramoeba ignava] | diamond | 333 | 50.4 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 32722006 | 32722006 | PRJNA1035005_P_NODE_30520_length_282_cov_1.153110_g30114_i0 | PRJNA1035005 | 30520 | 282 | 1.15311 | 3.2517702 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 72.4 | 2.1e-12 | NR | KAJ3437215.1 | 1746091 | g30114 | i0 | 39.5 | 4.86170212765957 | 86 | 52 | 91.5 | 0 | 263 | 6 | 161 | 246 | KAJ3437215.1 rho/rac/cdc gtpase-activating protein [Anaeramoeba flamelloides] | diamond | 1371 | 72.4 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides |
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);;