contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA169559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26725327 | 26725327 | PRJNA169559_P_NODE_26261_length_289_cov_2.226923_g24185_i0 | PRJNA169559 | 26261 | 289 | 2.226923 | 6.43580747 | Histomonas meleagridis | 135588 | Parabasalia | other_Eukaryota | 52.4 | 8.31e-6 | NR | XP_067773928.1 | 135588 | g24185 | i0 | 33.7 | 1.57785467128028 | 89 | 57 | 90.3 | 1 | 289 | 29 | 25 | 113 | XP_067773928.1 centrin [Histomonas meleagridis] | diamond | 456 | 52.4 | 1 | Eukaryota | Metamonada | Parabasalia | Tritrichomonadida | Dientamoebidae | Histomonas | Histomonas meleagridis | |||
| 27737632 | 27737632 | PRJNA169559_P_NODE_7624_length_615_cov_5.858362_g6055_i0 | PRJNA169559 | 7624 | 615 | 5.858362 | 36.0289263 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 46.6 | 0.0365 | NR | ESU41510.1 | 5741 | g6055 | i0 | 30.6 | 0.590243902439024 | 121 | 59 | 47.3 | 4 | 54 | 344 | 239 | 358 | ESU41510.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 363 | 46.6 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28084521 | 28084521 | PRJNA169559_P_NODE_11925_length_487_cov_24.792576_g10079_i0 | PRJNA169559 | 11925 | 487 | 24.792576 | 120.73984512 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 83.2 | 2.37e-16 | NR | KAJ3452455.1 | 1746091 | g10079 | i0 | 43.2 | 5.55030800821355 | 95 | 52 | 58.5 | 2 | 473 | 189 | 1 | 93 | KAJ3452455.1 40S ribosomal protein S10 [Anaeramoeba flamelloides] | diamond | 2703 | 83.2 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 28210750 | 28210750 | PRJNA169559_P_NODE_8786_length_573_cov_9.672794_g7118_i0 | PRJNA169559 | 8786 | 573 | 9.672794 | 55.42510962 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 112 | 1.1e-27 | NR | KAG9392754.1 | 201153 | g7118 | i0 | 39.7 | 0.910994764397906 | 174 | 90 | 89 | 7 | 572 | 63 | 1 | 163 | KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera] | diamond | 522 | 112 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 28242335 | 28242335 | PRJNA169559_P_NODE_29546_length_267_cov_2.025210_g27470_i0 | PRJNA169559 | 29546 | 267 | 2.02521 | 5.4073107 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 47 | 0.00147 | NR | XP_067762644.1 | 348837 | g27470 | i0 | 45.2 | 0.471910112359551 | 42 | 23 | 47.2 | 0 | 266 | 141 | 54 | 95 | XP_067762644.1 Cysteine-rich membrane protein 1 [Spironucleus salmonicida] | diamond | 126 | 47 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 28242339 | 28242339 | PRJNA169559_P_NODE_44326_length_221_cov_2.088542_g42249_i0 | PRJNA169559 | 44326 | 221 | 2.088542 | 4.61567782 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 46.2 | 0.0016 | NR | KAK2961441.1 | 2049346 | g42249 | i0 | 58.8 | 0.461538461538462 | 34 | 14 | 46.2 | 0 | 192 | 91 | 267 | 300 | KAK2961441.1 putative protein kinase [Blattamonas nauphoetae] | diamond | 102 | 46.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28526867 | 28526867 | PRJNA169559_P_NODE_547_length_2339_cov_5.006494_g230_i0 | PRJNA169559 | 547 | 2339 | 5.006494 | 117.10189466 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 52.8 | 0.00961 | NR | GIQ80334.1 | 797122 | g230 | i0 | 26.3 | 0.262932877297991 | 205 | 131 | 24 | 7 | 1684 | 1124 | 719 | 921 | GIQ80334.1 hypothetical protein KIPB_001114, partial [Kipferlia bialata] | diamond | 615 | 52.8 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 30136735 | 30136735 | PRJNA169559_P_NODE_45332_length_211_cov_2.159341_g43255_i0 | PRJNA169559 | 45332 | 211 | 2.159341 | 4.55620951 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 50.1 | 3.31e-5 | NR | KAA6365191.1 | 222440 | g43255 | i0 | 54.1 | 0.5260663507109 | 37 | 17 | 52.6 | 0 | 84 | 194 | 70 | 106 | KAA6365191.1 MAG: hypothetical protein EZS28_039282, partial [Streblomastix strix] | diamond | 111 | 50.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 30200084 | 30200084 | PRJNA169559_P_NODE_8852_length_571_cov_4.339483_g7183_i0 | PRJNA169559 | 8852 | 571 | 4.339483 | 24.77844793 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 47.8 | 0.0117 | NR | GIQ83316.1 | 797122 | g7183 | i0 | 33.7 | 0.45183887915937 | 86 | 46 | 45.2 | 2 | 268 | 11 | 45 | 119 | GIQ83316.1 hypothetical protein KIPB_004620 [Kipferlia bialata] | diamond | 258 | 47.8 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 31401332 | 31401332 | PRJNA169559_P_NODE_20436_length_367_cov_2.032544_g18390_i0 | PRJNA169559 | 20436 | 367 | 2.032544 | 7.45943648 | Anaeramoeba flamelloides | 1746091 | Root_unresolved | Root_unresolved | 97.1 | 1.07e-21 | NR | KAJ3423361.1 | 1746091 | g18390 | i0 | 44.7 | 1.00544959128065 | 123 | 63 | 99.7 | 3 | 2 | 367 | 115 | 233 | KAJ3423361.1 proteasome subunit alpha type-1 [Anaeramoeba flamelloides] | diamond | 369 | 97.1 | 1 | Eukaryota | Metamonada | Anaeramoebidae | Anaeramoeba | Anaeramoeba flamelloides | |||||
| 32381903 | 32381903 | PRJNA169559_P_NODE_19639_length_379_cov_1.397143_g17607_i0 | PRJNA169559 | 19639 | 379 | 1.397143 | 5.29517197 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 51.6 | 1.32e-4 | NR | TNJ26588.1 | 5742 | g17607 | i0 | 48.8 | 0.688654353562005 | 43 | 22 | 34 | 0 | 116 | 244 | 147 | 189 | TNJ26588.1 pVSP [Giardia muris] | diamond | 261 | 51.6 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 32603163 | 32603163 | PRJNA169559_P_NODE_33400_length_252_cov_1.937220_g31323_i0 | PRJNA169559 | 33400 | 252 | 1.93722 | 4.8817944 | Tritrichomonas foetus | 1144522 | Parabasalia | other_Eukaryota | 60.1 | 1.04e-8 | NR | XP_068346228.1 | 1144522 | g31323 | i0 | 49.2 | 2.75 | 61 | 31 | 72.6 | 0 | 18 | 200 | 111 | 171 | XP_068346228.1 small GTP-binding protein [Tritrichomonas foetus] | diamond | 693 | 60.1 | 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);;