contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJEB50332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9046745 | 9046745 | PRJEB50332_P_NODE_7388_length_239_cov_1.494382_g7306_i0 | PRJEB50332 | 7388 | 239 | 1.494382 | 3.57157298 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 135 | 4.33e-35 | NR | GKT19677.1 | 2918883 | g7306 | i0 | 76.9 | 7.8326359832636 | 78 | 18 | 97.9 | 0 | 238 | 5 | 65 | 142 | GKT19677.1 Phenylalanine--tRNA ligase alpha subunit, partial [Aduncisulcus paluster] | diamond | 1872 | 135 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 26907019 | 26907019 | PRJEB50332_P_NODE_7702_length_237_cov_1.914773_g7620_i0 | PRJEB50332 | 7702 | 237 | 1.914773 | 4.53801201 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 49.3 | 1.24e-4 | NR | KAG9394972.1 | 201153 | g7620 | i0 | 43.6 | 2.62025316455696 | 55 | 28 | 65.8 | 1 | 27 | 182 | 24 | 78 | KAG9394972.1 Thioredoxin [Carpediemonas membranifera] | diamond | 621 | 49.3 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27381381 | 27381381 | PRJEB50332_P_NODE_14383_length_208_cov_0.884354_g14301_i0 | PRJEB50332 | 14383 | 208 | 0.884354 | 1.83945632 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52 | 1.3e-5 | NR | XP_067733310.1 | 2049356 | g14301 | i0 | 43.5 | 2.09134615384615 | 69 | 31 | 99.5 | 1 | 207 | 1 | 63 | 123 | XP_067733310.1 putative Calcium/calmodulin-dependent protein kinase kinase 1 [Monocercomonoides exilis] | diamond | 435 | 52 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 28675879 | 28675879 | PRJEB50332_P_NODE_3807_length_302_cov_1.875519_g3725_i0 | PRJEB50332 | 3807 | 302 | 1.875519 | 5.66406738 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 57.8 | 3.74e-7 | NR | KAJ3437795.1 | 1746091 | g3725 | i0 | 50 | 1.85761589403974 | 56 | 28 | 55.6 | 0 | 3 | 170 | 191 | 246 | KAJ3437795.1 lipase [Anaeramoeba flamelloides] | diamond | 561 | 57.8 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 29615937 | 29615937 | PRJEB50332_P_NODE_4210_length_290_cov_12.676856_g4128_i0 | PRJEB50332 | 4210 | 290 | 12.676856 | 36.7628824 | root | 1 | Root_unresolved | Root_unresolved | 113 | 1.8e-30 | NR | KAA6379614.1 | 222440 | g4128 | i0 | 58.1 | 3.70344827586207 | 93 | 39 | 96.2 | 0 | 4 | 282 | 1 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 1074 | 113 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29685794 | 29685794 | PRJEB50332_P_NODE_1490_length_453_cov_1.903061_g1409_i0 | PRJEB50332 | 1490 | 453 | 1.903061 | 8.62086633 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 82 | 1.36e-15 | NR | KAA6375409.1 | 222440 | g1409 | i0 | 41.8 | 0.728476821192053 | 110 | 61 | 71.5 | 3 | 444 | 121 | 9 | 117 | KAA6375409.1 MAG: putative autophagy protein 3 [Streblomastix strix] | diamond | 330 | 82 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29685799 | 29685799 | PRJEB50332_P_NODE_930_length_557_cov_6.145161_g852_i0 | PRJEB50332 | 930 | 557 | 6.145161 | 34.22854677 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 199 | 1.34e-61 | NR | XP_068360038.1 | 1144522 | g852 | i0 | 57.2 | 7.49730700179533 | 173 | 74 | 93.2 | 0 | 533 | 15 | 5 | 177 | XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus] | diamond | 4176 | 199 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 30665422 | 30665422 | PRJEB50332_P_NODE_6473_length_246_cov_3.118919_g6391_i0 | PRJEB50332 | 6473 | 246 | 3.118919 | 7.67254074 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 55.5 | 8.03e-7 | NR | GIQ82228.1 | 797122 | g6391 | i0 | 35.3 | 2.41463414634146 | 85 | 45 | 92.7 | 2 | 18 | 245 | 124 | 207 | GIQ82228.1 peptidase C1A, partial [Kipferlia bialata] | diamond | 594 | 55.5 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 31202105 | 31202105 | PRJEB50332_P_NODE_13575_length_209_cov_1.317568_g13493_i0 | PRJEB50332 | 13575 | 209 | 1.317568 | 2.75371712 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 52 | 1.28e-5 | NR | XP_068353791.1 | 1144522 | g13493 | i0 | 46.4 | 1.60765550239234 | 56 | 28 | 80.4 | 1 | 194 | 27 | 246 | 299 | XP_068353791.1 uncharacterized protein TRFO_32625 [Tritrichomonas foetus] | diamond | 336 | 52 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus | |||
| 31645226 | 31645226 | PRJEB50332_P_NODE_11137_length_218_cov_1.624204_g11055_i0 | PRJEB50332 | 11137 | 218 | 1.624204 | 3.54076472 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 44.7 | 0.00386 | NR | KAJ4455307.1 | 342808 | g11055 | i0 | 28.6 | 1.89908256880734 | 70 | 50 | 96.3 | 0 | 213 | 4 | 70 | 139 | KAJ4455307.1 putative calcyphosin protein [Paratrimastix pyriformis] | diamond | 414 | 44.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32625770 | 32625770 | PRJEB50332_P_NODE_4020_length_296_cov_1.089362_g3938_i0 | PRJEB50332 | 4020 | 296 | 1.089362 | 3.22451152 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 72 | 1.48e-12 | NR | XP_068361206.1 | 1144522 | g3938 | i0 | 45.3 | 0.648648648648649 | 64 | 35 | 64.9 | 0 | 295 | 104 | 87 | 150 | XP_068361206.1 Ubiquitin-conjugating enzyme E2 6 [Tritrichomonas foetus] | diamond | 192 | 72 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Tritrichomonadidae | Tritrichomonas | Tritrichomonas foetus |
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);;