contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJEB43370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11538441 | 11538441 | PRJEB43370_P_NODE_7530_length_169_cov_0.866667_g7487_i0 | PRJEB43370 | 7530 | 169 | 0.866667 | 1.46466723 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 93.2 | 9.83e-22 | NR | AAC33578.1 | 5722 | g7487 | i0 | 64.3 | 15.8520710059172 | 56 | 20 | 99.4 | 0 | 168 | 1 | 41 | 96 | AAC33578.1 cytosolic heat shock protein 70, partial [Trichomonas vaginalis] | diamond | 2679 | 93.6 | 0.995726495726496 | Eukaryota | Metamonada | Parabasalia | Trichomonadida | Trichomonadidae | Trichomonas | Trichomonas vaginalis | |||
| 27349794 | 27349794 | PRJEB43370_P_NODE_823_length_481_cov_36.925926_g780_i0 | PRJEB43370 | 823 | 481 | 36.925926 | 177.61370406 | Giardia intestinalis assemblage B | 1394984 | Fornicata | other_Eukaryota | 47.8 | 0.00719 | NR | KWX13038.1 | 1394984 | g780 | i0 | 37 | 0.455301455301455 | 73 | 42 | 43 | 2 | 114 | 320 | 103 | 175 | KWX13038.1 Variant-specific surface protein [Giardia intestinalis assemblage B] | diamond | 219 | 47.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28454869 | 28454869 | PRJEB43370_P_NODE_9226_length_165_cov_1.344828_g9183_i0 | PRJEB43370 | 9226 | 165 | 1.344828 | 2.2189662 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 84.7 | 5.37e-19 | NR | KAJ3435612.1 | 1746091 | g9183 | i0 | 68.1 | 1.70909090909091 | 47 | 15 | 85.5 | 0 | 11 | 151 | 117 | 163 | KAJ3435612.1 e3 ubiquitin-protein ligase rbx1 [Anaeramoeba flamelloides] | diamond | 282 | 84.7 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 28675815 | 28675815 | PRJEB43370_P_NODE_6227_length_184_cov_1.155556_g6184_i0 | PRJEB43370 | 6227 | 184 | 1.155556 | 2.12622304 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 106 | 5.15e-25 | NR | KAJ5078034.1 | 1746090 | g6184 | i0 | 81.7 | 5.85326086956522 | 60 | 11 | 97.8 | 0 | 3 | 182 | 487 | 546 | KAJ5078034.1 major vault protein [Anaeramoeba ignava] | diamond | 1077 | 106 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 28707366 | 28707366 | PRJEB43370_P_NODE_2787_length_259_cov_3.280952_g2744_i0 | PRJEB43370 | 2787 | 259 | 3.280952 | 8.49766568 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 79 | 1e-16 | NR | KAJ4453711.1 | 342808 | g2744 | i0 | 53.8 | 1.49420849420849 | 65 | 29 | 75.3 | 1 | 233 | 39 | 2 | 65 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 387 | 79 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28865096 | 28865096 | PRJEB43370_P_NODE_9148_length_166_cov_0.888889_g9105_i0 | PRJEB43370 | 9148 | 166 | 0.888889 | 1.47555574 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 69.7 | 4.01e-12 | NR | GKT23767.1 | 2918883 | g9105 | i0 | 54.5 | 0.993975903614458 | 55 | 25 | 99.4 | 0 | 166 | 2 | 285 | 339 | GKT23767.1 Zinc finger protein ZPR1 [Aduncisulcus paluster] | diamond | 165 | 69.7 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 28896584 | 28896584 | PRJEB43370_P_NODE_6608_length_178_cov_2.279070_g6565_i0 | PRJEB43370 | 6608 | 178 | 2.27907 | 4.0567446 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 85.1 | 1.84e-17 | NR | GKT31530.1 | 2918883 | g6565 | i0 | 66.1 | 0.99438202247191 | 59 | 20 | 99.4 | 0 | 1 | 177 | 95 | 153 | GKT31530.1 Diphthamide synthesis DPH1/DPH2 like protein [Aduncisulcus paluster] | diamond | 177 | 85.1 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 29338839 | 29338839 | PRJEB43370_P_NODE_3869_length_225_cov_1.181818_g3826_i0 | PRJEB43370 | 3869 | 225 | 1.181818 | 2.6590905 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 83.6 | 2.4e-18 | NR | KAJ5077557.1 | 1746090 | g3826 | i0 | 50.7 | 0.973333333333333 | 73 | 34 | 97.3 | 1 | 219 | 1 | 50 | 120 | KAJ5077557.1 duf614 family protein-related [Anaeramoeba ignava] | diamond | 219 | 83.6 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 29433150 | 29433150 | PRJEB43370_P_NODE_4270_length_216_cov_0.976048_g4227_i0 | PRJEB43370 | 4270 | 216 | 0.976048 | 2.10826368 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 59.7 | 2.12e-9 | NR | KAJ4453711.1 | 342808 | g4227 | i0 | 50 | 2.52777777777778 | 58 | 26 | 80.6 | 1 | 2 | 175 | 18 | 72 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 546 | 59.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30033593 | 30033593 | PRJEB43370_P_NODE_9691_length_164_cov_1.356522_g9648_i0 | PRJEB43370 | 9691 | 164 | 1.356522 | 2.22469608 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 53.1 | 2.71e-6 | NR | KAJ5070782.1 | 1746090 | g9648 | i0 | 50 | 0.951219512195122 | 52 | 26 | 95.1 | 0 | 5 | 160 | 96 | 147 | KAJ5070782.1 hypothetical protein M0811_01763 [Anaeramoeba ignava] | diamond | 156 | 53.1 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 30412925 | 30412925 | PRJEB43370_P_NODE_5873_length_188_cov_1.863309_g5830_i0 | PRJEB43370 | 5873 | 188 | 1.863309 | 3.50302092 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 43.9 | 0.00415 | NR | KAG9392754.1 | 201153 | g5830 | i0 | 40.4 | 1.42021276595745 | 47 | 28 | 75 | 0 | 23 | 163 | 102 | 148 | KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera] | diamond | 267 | 43.9 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 30949886 | 30949886 | PRJEB43370_P_NODE_1614_length_345_cov_1.858108_g1571_i0 | PRJEB43370 | 1614 | 345 | 1.858108 | 6.4104726 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 129 | 4.21e-36 | NR | KAG9393782.1 | 201153 | g1571 | i0 | 64.4 | 3.64347826086957 | 104 | 36 | 90.4 | 1 | 3 | 314 | 1 | 103 | KAG9393782.1 Ribosomal protein L44e [Carpediemonas membranifera] | diamond | 1257 | 129 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 31423860 | 31423860 | PRJEB43370_P_NODE_10716_length_162_cov_0.920354_g10673_i0 | PRJEB43370 | 10716 | 162 | 0.920354 | 1.49097348 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 43.5 | 0.00662 | NR | ESU38684.1 | 5741 | g10673 | i0 | 42 | 3.66666666666667 | 50 | 27 | 88.9 | 1 | 151 | 8 | 528 | 577 | ESU38684.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 594 | 43.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31866549 | 31866549 | PRJEB43370_P_NODE_5497_length_194_cov_1.075862_g5454_i0 | PRJEB43370 | 5497 | 194 | 1.075862 | 2.08717228 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 73.2 | 5.59e-15 | NR | XP_067760069.1 | 348837 | g5454 | i0 | 64.4 | 7.45360824742268 | 59 | 21 | 91.2 | 0 | 18 | 194 | 18 | 76 | XP_067760069.1 Histone H4 [Spironucleus salmonicida] | diamond | 1446 | 73.2 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 31898377 | 31898377 | PRJEB43370_P_NODE_3697_length_229_cov_1.155556_g3654_i0 | PRJEB43370 | 3697 | 229 | 1.155556 | 2.64622324 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 44.3 | 0.00898 | NR | GIQ82786.1 | 797122 | g3654 | i0 | 33.3 | 2.62008733624454 | 72 | 47 | 94.3 | 1 | 229 | 14 | 486 | 556 | GIQ82786.1 hypothetical protein KIPB_003984 [Kipferlia bialata] | diamond | 600 | 44.3 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 32056541 | 32056541 | PRJEB43370_P_NODE_6038_length_186_cov_1.518248_g5995_i0 | PRJEB43370 | 6038 | 186 | 1.518248 | 2.82394128 | Anaeramoeba ignava | 1746090 | Root_unresolved | Root_unresolved | 60.1 | 1.38e-8 | NR | KAJ5073429.1 | 1746090 | g5995 | i0 | 52.7 | 6.20967741935484 | 55 | 26 | 88.7 | 0 | 22 | 186 | 287 | 341 | KAJ5073429.1 alpha-actinin-2 [Anaeramoeba ignava] | diamond | 1155 | 60.1 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba ignava | |||||
| 32531370 | 32531370 | PRJEB43370_P_NODE_819_length_482_cov_3.473441_g776_i0 | PRJEB43370 | 819 | 482 | 3.473441 | 16.74198562 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 189 | 6.51e-58 | NR | XP_068360038.1 | 1144522 | g776 | i0 | 60.1 | 2.91286307053942 | 153 | 61 | 95.2 | 0 | 459 | 1 | 5 | 157 | XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus] | diamond | 1404 | 189 | 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);;