contig_metadata
20 rows where bioproject = "PRJNA520845", tax_clade = "Metamonada" and tax_phylum = "Fornicata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26856025 | 26856025 | PRJNA520845_P_NODE_269621_length_229_cov_2.551282_g268122_i0 | PRJNA520845 | 269621 | 229 | 2.551282 | 5.84243578 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 53.1 | 6.7e-6 | NR | TNJ29081.1 | 5742 | g268122 | i0 | 40 | 0.655021834061135 | 50 | 26 | 60.3 | 1 | 53 | 190 | 522 | 571 | TNJ29081.1 pVSP [Giardia muris] | diamond | 150 | 53.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 26919100 | 26919100 | PRJNA520845_P_NODE_225542_length_249_cov_0.875000_g224043_i0 | PRJNA520845 | 225542 | 249 | 0.875 | 2.17875 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 52.4 | 1.6e-5 | NR | KAG9394939.1 | 201153 | g224043 | i0 | 37.7 | 0.831325301204819 | 69 | 40 | 83.1 | 1 | 249 | 43 | 7 | 72 | KAG9394939.1 Protein kinase domain [Carpediemonas membranifera] | diamond | 207 | 52.4 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 27013924 | 27013924 | PRJNA520845_P_NODE_186662_length_272_cov_1.934673_g185163_i0 | PRJNA520845 | 186662 | 272 | 1.934673 | 5.26231056 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 50.4 | 9.69e-5 | NR | XP_067765802.1 | 348837 | g185163 | i0 | 37.7 | 1.53308823529412 | 77 | 38 | 83.8 | 3 | 15 | 242 | 178 | 245 | XP_067765802.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 417 | 50.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 27598262 | 27598262 | PRJNA520845_P_NODE_16804_length_948_cov_2.448000_g15622_i0 | PRJNA520845 | 16804 | 948 | 2.448 | 23.20704 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 202 | 1.3999999999999999e-58 | NR | CAK8746233.1 | 28002 | g15622 | i0 | 50 | 1.19303797468354 | 198 | 91 | 62.7 | 2 | 947 | 354 | 49 | 238 | CAK8746233.1 HINF_020048 [Hexamita inflata] | diamond | 1131 | 202 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28119480 | 28119480 | PRJNA520845_P_NODE_181825_length_276_cov_1.517241_g180326_i0 | PRJNA520845 | 181825 | 276 | 1.517241 | 4.18758516 | Giardia lamblia P15 | 658858 | Fornicata | other_Eukaryota | 60.5 | 3.18e-8 | NR | EFO62738.1 | 658858 | g180326 | i0 | 41.6 | 0.83695652173913 | 77 | 37 | 76.1 | 2 | 275 | 66 | 304 | 379 | EFO62738.1 VSP [Giardia lamblia P15] | diamond | 231 | 60.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28309059 | 28309059 | PRJNA520845_P_NODE_213906_length_251_cov_0.865169_g212407_i0 | PRJNA520845 | 213906 | 251 | 0.865169 | 2.17157419 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 55.8 | 9.83e-7 | NR | CAK8816796.1 | 28002 | g212407 | i0 | 37 | 0.968127490039841 | 81 | 51 | 96.8 | 0 | 249 | 7 | 408 | 488 | CAK8816796.1 HINF_023665 [Hexamita inflata] | diamond | 243 | 55.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28435306 | 28435306 | PRJNA520845_P_NODE_151426_length_303_cov_1.673913_g149927_i0 | PRJNA520845 | 151426 | 303 | 1.673913 | 5.07195639 | Giardia muris | 5742 | Fornicata | other_Eukaryota | 54.3 | 6.34e-6 | NR | TNJ28923.1 | 5742 | g149927 | i0 | 43.4 | 0.524752475247525 | 53 | 28 | 51.5 | 2 | 9 | 164 | 39 | 90 | TNJ28923.1 High cysteine membrane protein [Giardia muris] | diamond | 159 | 54.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 28593232 | 28593232 | PRJNA520845_P_NODE_163107_length_291_cov_1.545872_g161608_i0 | PRJNA520845 | 163107 | 291 | 1.545872 | 4.49848752 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 46.2 | 0.00374 | NR | GKT29241.1 | 2918883 | g161608 | i0 | 35.1 | 1.62886597938144 | 74 | 46 | 76.3 | 1 | 290 | 69 | 316 | 387 | GKT29241.1 KRAB-A domain-containing protein, partial [Aduncisulcus paluster] | diamond | 474 | 46.2 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 28640237 | 28640237 | PRJNA520845_P_NODE_195387_length_265_cov_2.088542_g193888_i0 | PRJNA520845 | 195387 | 265 | 2.088542 | 5.5346363 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.9 | 3.26e-4 | NR | ESU38829.1 | 5741 | g193888 | i0 | 37.1 | 9.12452830188679 | 70 | 33 | 79.2 | 3 | 52 | 261 | 226 | 284 | ESU38829.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 2418 | 49.3 | 0.991886409736308 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29429177 | 29429177 | PRJNA520845_P_NODE_251929_length_244_cov_0.900585_g250430_i0 | PRJNA520845 | 251929 | 244 | 0.900585 | 2.1974274 | Giardia | 5740 | Fornicata | other_Eukaryota | 49.7 | 1.35e-4 | NR | ESU44889.1 | 5741 | g250430 | i0 | 36.1 | 2.02868852459016 | 83 | 36 | 87.3 | 3 | 231 | 19 | 264 | 341 | ESU44889.1 Variant-specific surface protein, partial [Giardia intestinalis] | diamond | 495 | 50.1 | 0.992015968063872 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29571798 | 29571798 | PRJNA520845_P_NODE_189230_length_270_cov_1.670051_g187731_i0 | PRJNA520845 | 189230 | 270 | 1.670051 | 4.5091377 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 46.2 | 0.00332 | NR | CAK8757251.1 | 28002 | g187731 | i0 | 39.7 | 1.5 | 63 | 23 | 56.7 | 3 | 213 | 61 | 1202 | 1261 | CAK8757251.1 HINF_008018 [Hexamita inflata] | diamond | 405 | 46.2 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 29982450 | 29982450 | PRJNA520845_P_NODE_176571_length_280_cov_1.859903_g175072_i0 | PRJNA520845 | 176571 | 280 | 1.859903 | 5.2077284 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 43.5 | 0.0307 | NR | XP_067767021.1 | 348837 | g175072 | i0 | 50 | 0.364285714285714 | 34 | 17 | 36.4 | 0 | 238 | 137 | 202 | 235 | XP_067767021.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 102 | 43.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 30582625 | 30582625 | PRJNA520845_P_NODE_57213_length_493_cov_1.719048_g55719_i0 | PRJNA520845 | 57213 | 493 | 1.719048 | 8.47490664 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 54.3 | 4.74e-5 | NR | CAK8813335.1 | 28002 | g55719 | i0 | 30.6 | 1.36916835699797 | 111 | 71 | 66.9 | 5 | 331 | 2 | 922 | 1027 | CAK8813335.1 HINF_000053 [Hexamita inflata] | diamond | 675 | 54.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 30709120 | 30709120 | PRJNA520845_P_NODE_50334_length_527_cov_2.211454_g48842_i0 | PRJNA520845 | 50334 | 527 | 2.211454 | 11.65436258 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 53.1 | 1.39e-4 | NR | XP_001705852.1 | 5741 | g48842 | i0 | 31.3 | 2.38519924098672 | 112 | 59 | 54.1 | 3 | 194 | 478 | 387 | 497 | XP_001705852.1 High cysteine membrane protein Group 6 [Giardia intestinalis] | diamond | 1257 | 53.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30724479 | 30724479 | PRJNA520845_P_NODE_72034_length_438_cov_1.227397_g70535_i0 | PRJNA520845 | 72034 | 438 | 1.227397 | 5.37599886 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 66.6 | 1.44e-9 | NR | ESU35350.1 | 5741 | g70535 | i0 | 36.3 | 4.23287671232877 | 124 | 68 | 78.1 | 5 | 63 | 404 | 751 | 873 | ESU35350.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 1854 | 67 | 0.994029850746269 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31025295 | 31025295 | PRJNA520845_P_NODE_93355_length_384_cov_2.083601_g91856_i0 | PRJNA520845 | 93355 | 384 | 2.083601 | 8.00102784 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 57 | 1.8e-6 | NR | ESU40193.1 | 5741 | g91856 | i0 | 33.6 | 0.90625 | 116 | 57 | 84.4 | 6 | 4 | 327 | 311 | 414 | ESU40193.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 348 | 57 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 31356695 | 31356695 | PRJNA520845_P_NODE_207336_length_256_cov_0.841530_g205837_i0 | PRJNA520845 | 207336 | 256 | 0.84153 | 2.1543168 | Kipferlia | 797121 | Fornicata | other_Eukaryota | 81.3 | 3.38e-16 | NR | GIQ81556.1 | 797122 | g205837 | i0 | 49.4 | 2.89453125 | 81 | 36 | 90.2 | 2 | 6 | 236 | 177 | 256 | GIQ81556.1 deoxyribonuclease II [Kipferlia bialata] | diamond | 741 | 81.3 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 32005559 | 32005559 | PRJNA520845_P_NODE_211658_length_252_cov_1.396648_g210159_i0 | PRJNA520845 | 211658 | 252 | 1.396648 | 3.51955296 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 45.4 | 0.00482 | NR | CAK8765299.1 | 28002 | g210159 | i0 | 30.9 | 1.88095238095238 | 81 | 52 | 92.9 | 3 | 234 | 1 | 432 | 511 | CAK8765299.1 HINF_084577 [Hexamita inflata] | diamond | 474 | 45.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 32163851 | 32163851 | PRJNA520845_P_NODE_1858_length_2504_cov_27.857672_g1582_i0 | PRJNA520845 | 1858 | 2504 | 27.857672 | 697.55610688 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 143 | 6.51e-34 | NR | KAG9391898.1 | 201153 | g1582 | i0 | 37 | 0.285143769968051 | 238 | 128 | 27.7 | 7 | 2054 | 1362 | 43 | 265 | KAG9391898.1 Geminivirus Rep catalytic domain [Carpediemonas membranifera] | diamond | 714 | 143 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 32258930 | 32258930 | PRJNA520845_P_NODE_10038_length_1235_cov_3.548193_g9131_i0 | PRJNA520845 | 10038 | 1235 | 3.548193 | 43.82018355 | Giardia lamblia P15 | 658858 | Fornicata | other_Eukaryota | 62.4 | 2.44e-6 | NR | EFO65169.1 | 658858 | g9131 | i0 | 31.7 | 0.738461538461539 | 164 | 72 | 31.8 | 7 | 1129 | 737 | 205 | 361 | EFO65169.1 VSP with INR [Giardia lamblia P15] | diamond | 912 | 62.4 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis |
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);;