contig_metadata
17 rows where bioproject = "PRJNA758398", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26641512 | 26641512 | PRJNA758398_S_NODE_6641_length_370_cov_4.180685_g6500_i0 | PRJNA758398 | 6641 | 370 | 4.180685 | 15.4685345 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 51.6 | 1.29e-4 | NR | CAK8813343.1 | 28002 | g6500 | i0 | 34.3 | 0.567567567567568 | 70 | 44 | 56.8 | 1 | 23 | 232 | 866 | 933 | CAK8813343.1 HINF_000064 [Hexamita inflata] | diamond | 210 | 51.6 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 26831612 | 26831612 | PRJNA758398_S_NODE_51261_length_162_cov_1.353982_g51120_i0 | PRJNA758398 | 51261 | 162 | 1.353982 | 2.19345084 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 45.8 | 0.00104 | NR | CAK8814461.1 | 28002 | g51120 | i0 | 48 | 0.925925925925926 | 50 | 21 | 88.9 | 3 | 159 | 16 | 59 | 105 | CAK8814461.1 HINF_019355 [Hexamita inflata] | diamond | 150 | 45.8 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 28253108 | 28253108 | PRJNA758398_S_NODE_14546_length_259_cov_1.680952_g14405_i0 | PRJNA758398 | 14546 | 259 | 1.680952 | 4.35366568 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 58.2 | 1.72e-7 | NR | ESU42912.1 | 5741 | g14405 | i0 | 47.7 | 3.16216216216216 | 65 | 32 | 74.1 | 2 | 5 | 196 | 746 | 809 | ESU42912.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 819 | 58.2 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 28789822 | 28789822 | PRJNA758398_S_NODE_25827_length_206_cov_0.974522_g25686_i0 | PRJNA758398 | 25827 | 206 | 0.974522 | 2.00751532 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 56.2 | 4.03e-7 | NR | XP_067766864.1 | 348837 | g25686 | i0 | 37.9 | 1.26699029126214 | 87 | 35 | 99 | 4 | 205 | 2 | 454 | 540 | XP_067766864.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida] | diamond | 261 | 56.2 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 28925888 | 28925888 | PRJNA758398_S_NODE_11788_length_284_cov_1.476596_g11647_i0 | PRJNA758398 | 11788 | 284 | 1.476596 | 4.19353264 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 46.6 | 0.00267 | NR | ESU40539.1 | 5741 | g11647 | i0 | 39.2 | 2.52464788732394 | 51 | 29 | 53.9 | 1 | 6 | 158 | 218 | 266 | ESU40539.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 717 | 47 | 0.991489361702128 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 29579048 | 29579048 | PRJNA758398_S_NODE_26550_length_203_cov_2.506494_g26409_i0 | PRJNA758398 | 26550 | 203 | 2.506494 | 5.08818282 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 43.5 | 0.012 | NR | CAK8769425.1 | 28002 | g26409 | i0 | 31.9 | 1.83251231527094 | 72 | 39 | 91.6 | 1 | 1 | 186 | 906 | 977 | CAK8769425.1 HINF_059257 [Hexamita inflata] | diamond | 372 | 43.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 30021614 | 30021614 | PRJNA758398_S_NODE_451_length_1175_cov_5.645648_g399_i0 | PRJNA758398 | 451 | 1175 | 5.6456480000000004 | 66.336364 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 270 | 1.49e-83 | NR | CAK8746233.1 | 28002 | g399 | i0 | 43.2 | 0.998297872340426 | 391 | 193 | 99.8 | 3 | 1173 | 1 | 3 | 364 | CAK8746233.1 HINF_020048 [Hexamita inflata] | diamond | 1173 | 270 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 30179330 | 30179330 | PRJNA758398_S_NODE_48852_length_164_cov_0.886957_g48711_i0 | PRJNA758398 | 48852 | 164 | 0.886957 | 1.45460948 | Giardia intestinalis ATCC 5 | 5741 | Fornicata | other_Eukaryota | 43.5 | 0.00694 | NR | EES99242.1 | 598745 | g48711 | i0 | 38.6 | 3.4390243902439 | 44 | 27 | 80.5 | 0 | 134 | 3 | 1070 | 1113 | EES99242.1 High cysteine membrane protein Group 1 [Giardia intestinalis ATCC 50581] | diamond | 564 | 43.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia duodenalis | |||
| 30189097 | 30189097 | PRJNA758398_S_NODE_42252_length_167_cov_0.864407_g42111_i0 | PRJNA758398 | 42252 | 167 | 0.864407 | 1.44355969 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 82.4 | 4.19e-18 | NR | GIQ89663.1 | 797122 | g42111 | i0 | 67.3 | 1.88622754491018 | 52 | 17 | 93.4 | 0 | 8 | 163 | 61 | 112 | GIQ89663.1 tubulin-tyrosine ligase/Tubulin polyglutamylase [Kipferlia bialata] | diamond | 315 | 82.4 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 30242725 | 30242725 | PRJNA758398_S_NODE_23632_length_213_cov_1.237805_g23491_i0 | PRJNA758398 | 23632 | 213 | 1.237805 | 2.63652465 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 42.7 | 0.0258 | NR | GIQ80334.1 | 797122 | g23491 | i0 | 43.1 | 1.01408450704225 | 72 | 35 | 95.8 | 4 | 3 | 206 | 2577 | 2646 | GIQ80334.1 hypothetical protein KIPB_001114, partial [Kipferlia bialata] | diamond | 216 | 42.7 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 30284384 | 30284384 | PRJNA758398_S_NODE_11832_length_283_cov_2.974359_g11691_i0 | PRJNA758398 | 11832 | 283 | 2.974359 | 8.41743597 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.9 | 3.89e-4 | NR | TNJ28141.1 | 5742 | g11691 | i0 | 60 | 0.848056537102474 | 35 | 14 | 37.1 | 0 | 104 | 208 | 54 | 88 | TNJ28141.1 High cysteine protein [Giardia muris] | diamond | 240 | 49.3 | 0.991886409736308 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Giardia | Giardia muris | |||
| 30316077 | 30316077 | PRJNA758398_S_NODE_39952_length_171_cov_1.254098_g39811_i0 | PRJNA758398 | 39952 | 171 | 1.254098 | 2.14450758 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.5 | 1.34e-13 | NR | XP_067764835.1 | 348837 | g39811 | i0 | 72.3 | 1.66666666666667 | 47 | 13 | 82.5 | 0 | 171 | 31 | 94 | 140 | XP_067764835.1 Ribosomal protein L23 [Spironucleus salmonicida] | diamond | 285 | 70.5 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 30716426 | 30716426 | PRJNA758398_S_NODE_21294_length_222_cov_0.884393_g21153_i0 | PRJNA758398 | 21294 | 222 | 0.884393 | 1.96335246 | Kipferlia bialata | 797122 | Fornicata | other_Eukaryota | 77.4 | 1.05e-15 | NR | GIQ83861.1 | 797122 | g21153 | i0 | 48.6 | 1.90540540540541 | 70 | 36 | 94.6 | 0 | 13 | 222 | 25 | 94 | GIQ83861.1 adenylate kinase/UMP-CMP kinase [Kipferlia bialata] | diamond | 423 | 77.4 | 1 | Eukaryota | Metamonada | Fornicata | Kipferlia | Kipferlia bialata | |||||
| 31105302 | 31105302 | PRJNA758398_S_NODE_15695_length_251_cov_1.262376_g15554_i0 | PRJNA758398 | 15695 | 251 | 1.262376 | 3.16856376 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 49.3 | 2.07e-4 | NR | CAK8815357.1 | 28002 | g15554 | i0 | 30.8 | 2.22310756972112 | 91 | 48 | 92 | 3 | 232 | 2 | 1279 | 1368 | CAK8815357.1 HINF_013567 [Hexamita inflata] | diamond | 558 | 49.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31475219 | 31475219 | PRJNA758398_S_NODE_10556_length_299_cov_1.156000_g10415_i0 | PRJNA758398 | 10556 | 299 | 1.156 | 3.45644 | Spironucleus salmonicida | 348837 | Fornicata | other_Eukaryota | 46.2 | 0.00404 | NR | XP_067761231.1 | 348837 | g10415 | i0 | 40.7 | 0.54180602006689 | 54 | 29 | 54.2 | 1 | 109 | 270 | 89 | 139 | XP_067761231.1 Protein phosphatase 2C [Spironucleus salmonicida] | diamond | 162 | 46.2 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Spironucleus | Spironucleus salmonicida | |||
| 32234704 | 32234704 | PRJNA758398_S_NODE_39878_length_171_cov_1.254098_g39737_i0 | PRJNA758398 | 39878 | 171 | 1.254098 | 2.14450758 | Carpediemonas membranifera | 201153 | Fornicata | other_Eukaryota | 42.4 | 0.0109 | NR | KAG9391164.1 | 201153 | g39737 | i0 | 53.6 | 1.82456140350877 | 28 | 13 | 49.1 | 0 | 3 | 86 | 51 | 78 | KAG9391164.1 hypothetical protein J8273_7438 [Carpediemonas membranifera] | diamond | 312 | 42.4 | 1 | Eukaryota | Metamonada | Fornicata | Carpediemonas | Carpediemonas membranifera | |||||
| 32897029 | 32897029 | PRJNA758398_S_NODE_24940_length_209_cov_0.956250_g24799_i0 | PRJNA758398 | 24940 | 209 | 0.95625 | 1.9985625 | Giardia intestinalis | 5741 | Fornicata | other_Eukaryota | 50.1 | 6.24e-5 | NR | ESU40250.1 | 5741 | g24799 | i0 | 36.6 | 1.01913875598086 | 71 | 41 | 96.2 | 2 | 6 | 206 | 563 | 633 | ESU40250.1 Variant-specific surface protein [Giardia intestinalis] | diamond | 213 | 50.1 | 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);;