contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1108487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9141037 | 9141037 | PRJNA1108487_P_NODE_3028_length_390_cov_2.397476_g2962_i0 | PRJNA1108487 | 3028 | 390 | 2.397476 | 9.3501564 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 92.4 | 2.51e-21 | NR | KAJ4453711.1 | 342808 | g2962 | i0 | 62.1 | 0.507692307692308 | 66 | 25 | 50.8 | 0 | 344 | 147 | 2 | 67 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 198 | 92.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 12499414 | 12499414 | PRJNA1108487_P_NODE_10190_length_246_cov_0.901734_g10124_i0 | PRJNA1108487 | 10190 | 246 | 0.901734 | 2.21826564 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 88.6 | 2.81e-18 | NR | KAK2964795.1 | 2049346 | g10124 | i0 | 51.8 | 4.08536585365854 | 85 | 37 | 98.8 | 2 | 244 | 2 | 303 | 387 | KAK2964795.1 putative CCR4-NOT transcription complex subunit 8 [Blattamonas nauphoetae] | diamond | 1005 | 89 | 0.995505617977528 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 14242235 | 14242235 | PRJNA1108487_P_NODE_6712_length_278_cov_1.141463_g6646_i0 | PRJNA1108487 | 6712 | 278 | 1.141463 | 3.17326714 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 93.6 | 6.48e-20 | NR | XP_001316272.1 | 412133 | g6646 | i0 | 49.5 | 4.01438848920863 | 93 | 46 | 99.3 | 1 | 1 | 276 | 86 | 178 | XP_001316272.1 protein serine/threonine kinase protein [Trichomonas vaginalis G3] | diamond | 1116 | 94 | 0.995744680851064 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 27447195 | 27447195 | PRJNA1108487_P_NODE_2563_length_423_cov_2.708571_g2497_i0 | PRJNA1108487 | 2563 | 423 | 2.708571 | 11.45725533 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 116 | 1.8e-30 | NR | KAJ3430170.1 | 1746091 | g2497 | i0 | 52.7 | 1.93617021276596 | 91 | 43 | 64.5 | 0 | 74 | 346 | 28 | 118 | KAJ3430170.1 duf614 family protein-related [Anaeramoeba flamelloides] | diamond | 819 | 116 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 28710090 | 28710090 | PRJNA1108487_P_NODE_8307_length_253_cov_0.866667_g8241_i0 | PRJNA1108487 | 8307 | 253 | 0.866667 | 2.19266751 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 82.4 | 4e-16 | NR | XP_068349810.1 | 1144522 | g8241 | i0 | 50.6 | 3.80632411067194 | 79 | 35 | 93.7 | 1 | 2 | 238 | 244 | 318 | XP_068349810.1 uncharacterized protein TRFO_09829 [Tritrichomonas foetus] | diamond | 963 | 82.4 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 28827289 | 28827289 | PRJNA1108487_P_NODE_4688_length_323_cov_5.640000_g4622_i0 | PRJNA1108487 | 4688 | 323 | 5.64 | 18.2172 | root | 1 | Root_unresolved | Root_unresolved | 111 | 1.59e-29 | NR | KAA6379614.1 | 222440 | g4622 | i0 | 58.2 | 3.3343653250774 | 91 | 38 | 84.5 | 0 | 320 | 48 | 3 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 1077 | 111 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 28962742 | 28962742 | PRJNA1108487_P_NODE_11088_length_243_cov_0.917647_g11022_i0 | PRJNA1108487 | 11088 | 243 | 0.917647 | 2.22988221 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 98.6 | 8.39e-22 | NR | KAJ5069913.1 | 1746090 | g11022 | i0 | 57 | 0.975308641975309 | 79 | 31 | 97.5 | 3 | 2 | 238 | 1470 | 1545 | KAJ5069913.1 calpain [Anaeramoeba ignava] | diamond | 237 | 98.6 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 29751602 | 29751602 | PRJNA1108487_P_NODE_9411_length_249_cov_0.886364_g9345_i0 | PRJNA1108487 | 9411 | 249 | 0.886364 | 2.20704636 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 94.4 | 1.97e-20 | NR | CAK8765639.1 | 28002 | g9345 | i0 | 60.6 | 3.21686746987952 | 66 | 26 | 79.5 | 0 | 249 | 52 | 211 | 276 | CAK8765639.1 HINF_099101 [Hexamita inflata] | diamond | 801 | 94.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 29837778 | 29837778 | PRJNA1108487_P_NODE_4471_length_330_cov_1.214008_g4405_i0 | PRJNA1108487 | 4471 | 330 | 1.214008 | 4.0062264 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 112 | 2.6600000000000003e-27 | NR | KAJ3428892.1 | 1746091 | g4405 | i0 | 51.5 | 4.7 | 103 | 50 | 93.6 | 0 | 323 | 15 | 244 | 346 | KAJ3428892.1 guanine nucleotide-binding protein g(o) subunit alpha [Anaeramoeba flamelloides] | diamond | 1551 | 112 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 30099168 | 30099168 | PRJNA1108487_P_NODE_4652_length_324_cov_2.254980_g4586_i0 | PRJNA1108487 | 4652 | 324 | 2.25498 | 7.3061352 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 83.2 | 3.98e-17 | NR | KAJ3452455.1 | 1746091 | g4586 | i0 | 43.2 | 6.71296296296296 | 95 | 52 | 88 | 2 | 14 | 298 | 1 | 93 | KAJ3452455.1 40S ribosomal protein S10 [Anaeramoeba flamelloides] | diamond | 2175 | 83.2 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 30193985 | 30193985 | PRJNA1108487_P_NODE_9712_length_248_cov_0.891429_g9646_i0 | PRJNA1108487 | 9712 | 248 | 0.891429 | 2.21074392 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 57.8 | 1.92e-7 | NR | CAK8810875.1 | 28002 | g9646 | i0 | 40.3 | 1.77822580645161 | 67 | 39 | 79.8 | 1 | 50 | 247 | 288 | 354 | CAK8810875.1 HINF_009343 [Hexamita inflata] | diamond | 441 | 57.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31521594 | 31521594 | PRJNA1108487_P_NODE_10576_length_244_cov_1.426901_g10510_i0 | PRJNA1108487 | 10576 | 244 | 1.426901 | 3.48163844 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 82 | 5.21e-16 | NR | KAJ3452515.1 | 1746091 | g10510 | i0 | 51.9 | 0.995901639344262 | 81 | 38 | 98.4 | 1 | 4 | 243 | 217 | 297 | KAJ3452515.1 lipopolysaccharide assembly protein b [Anaeramoeba flamelloides] | diamond | 243 | 82 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 31806130 | 31806130 | PRJNA1108487_P_NODE_857_length_698_cov_2.364800_g796_i0 | PRJNA1108487 | 857 | 698 | 2.3648 | 16.506304 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 152 | 1.1e-41 | NR | KAA6375409.1 | 222440 | g796 | i0 | 40.6 | 0.962750716332378 | 224 | 120 | 95 | 7 | 25 | 687 | 5 | 218 | KAA6375409.1 MAG: putative autophagy protein 3 [Streblomastix strix] | diamond | 672 | 152 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32375754 | 32375754 | PRJNA1108487_P_NODE_1839_length_498_cov_2.251765_g1773_i0 | PRJNA1108487 | 1839 | 498 | 2.251765 | 11.2137897 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 190 | 2.7600000000000003e-58 | NR | XP_068360038.1 | 1144522 | g1773 | i0 | 58.8 | 3.86144578313253 | 160 | 66 | 96.4 | 0 | 17 | 496 | 5 | 164 | XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus] | diamond | 1923 | 190 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 32407355 | 32407355 | PRJNA1108487_P_NODE_11179_length_242_cov_0.923077_g11113_i0 | PRJNA1108487 | 11179 | 242 | 0.923077 | 2.23384634 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 120 | 1.22e-29 | NR | KAJ4456816.1 | 342808 | g11113 | i0 | 67.5 | 1.98347107438017 | 80 | 26 | 99.2 | 0 | 2 | 241 | 91 | 170 | KAJ4456816.1 putative Ribosome biogenesis protein BMS1 [Paratrimastix pyriformis] | diamond | 480 | 120 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32407357 | 32407357 | PRJNA1108487_P_NODE_4939_length_316_cov_2.888889_g4873_i0 | PRJNA1108487 | 4939 | 316 | 2.888889 | 9.12888924 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 64.7 | 1.52e-9 | NR | KAJ5066588.1 | 1746090 | g4873 | i0 | 41.1 | 0.854430379746835 | 90 | 41 | 82.6 | 3 | 55 | 315 | 6 | 86 | KAJ5066588.1 beta-site app-cleaving enzyme isoform a-related [Anaeramoeba ignava] | diamond | 270 | 64.7 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 32565776 | 32565776 | PRJNA1108487_P_NODE_9879_length_247_cov_0.896552_g9813_i0 | PRJNA1108487 | 9879 | 247 | 0.896552 | 2.21448344 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 55.5 | 1.26e-6 | NR | KAJ3448098.1 | 1746091 | g9813 | i0 | 29.3 | 1.7004048582996 | 75 | 53 | 91.1 | 0 | 22 | 246 | 242 | 316 | KAJ3448098.1 lipase [Anaeramoeba flamelloides] | diamond | 420 | 55.5 | 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);;