contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA493827" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3023303 | 3023303 | PRJNA493827_P_NODE_238983_length_226_cov_2.078431_g236784_i0 | PRJNA493827 | 238983 | 226 | 2.078431 | 4.69725406 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 150 | 3.7e-42 | NR | AAP88974.1 | 5775 | g236784 | i0 | 92 | 0.995575221238938 | 75 | 6 | 99.6 | 0 | 2 | 226 | 5 | 79 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 225 | 150 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 5574655 | 5574655 | PRJNA493827_P_NODE_17465_length_950_cov_2.150513_g15783_i0 | PRJNA493827 | 17465 | 950 | 2.150513 | 20.4298735 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 528 | 3.81e-185 | NR | BAN33737.1 | 931554 | g15783 | i0 | 82.5 | 0.994736842105263 | 315 | 52 | 98.5 | 1 | 14 | 949 | 1 | 315 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 945 | 528 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 8124266 | 8124266 | PRJNA493827_P_NODE_179107_length_255_cov_1.197802_g176909_i0 | PRJNA493827 | 179107 | 255 | 1.197802 | 3.0543951 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 166 | 3.2799999999999996e-47 | NR | BAN33737.1 | 931554 | g176909 | i0 | 95.3 | 7 | 85 | 4 | 100 | 0 | 1 | 255 | 50 | 134 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 1785 | 166 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 18321523 | 18321523 | PRJNA493827_P_NODE_119595_length_312_cov_2.150628_g117397_i0 | PRJNA493827 | 119595 | 312 | 2.150628 | 6.70995936 | Chaos carolinense | 160823 | Tubulinea | other_Eukaryota | 169 | 1.09e-51 | NR | AFX73058.1 | 160823 | g117397 | i0 | 86.9 | 0.951923076923077 | 99 | 12 | 94.2 | 1 | 295 | 2 | 1 | 99 | AFX73058.1 14-3-3 protein, partial [Chaos carolinense] | diamond | 297 | 169 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 26855594 | 26855594 | PRJNA493827_P_NODE_80821_length_383_cov_1.487097_g78623_i0 | PRJNA493827 | 80821 | 383 | 1.487097 | 5.69558151 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 223 | 2.66e-68 | NR | BAN33737.1 | 931554 | g78623 | i0 | 84.3 | 0.994778067885117 | 127 | 20 | 99.5 | 0 | 2 | 382 | 249 | 375 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 381 | 223 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 26934264 | 26934264 | PRJNA493827_P_NODE_206162_length_246_cov_2.439306_g203964_i0 | PRJNA493827 | 206162 | 246 | 2.439306 | 6.00069276 | root | 1 | Root_unresolved | Root_unresolved | 96.7 | 1.3e-22 | NR | ABD46563.1 | 5778 | g203964 | i0 | 50 | 5 | 82 | 41 | 100 | 0 | 246 | 1 | 103 | 184 | ABD46563.1 succinyl-diaminopimelate desuccinylase-like protein A, partial [Vermamoeba vermiformis] | diamond | 1230 | 97.4 | 0.992813141683778 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 28434962 | 28434962 | PRJNA493827_P_NODE_78846_length_388_cov_1.707937_g76648_i0 | PRJNA493827 | 78846 | 388 | 1.707937 | 6.62679556 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 224 | 1.15e-72 | NR | AAW58116.1 | 5775 | g76648 | i0 | 83.1 | 0.958762886597938 | 124 | 21 | 95.9 | 0 | 387 | 16 | 50 | 173 | AAW58116.1 peroxiredoxin, partial [Amoeba proteus] | diamond | 372 | 224 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 28576736 | 28576736 | PRJNA493827_P_NODE_180207_length_254_cov_1.276243_g178009_i0 | PRJNA493827 | 180207 | 254 | 1.276243 | 3.24165722 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.2 | 9.89e-8 | NR | AAY21191.1 | 5778 | g178009 | i0 | 45.5 | 3.16535433070866 | 66 | 36 | 78 | 0 | 1 | 198 | 173 | 238 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 804 | 58.2 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 29066475 | 29066475 | PRJNA493827_P_NODE_25528_length_753_cov_1.035294_g23591_i0 | PRJNA493827 | 25528 | 753 | 1.035294 | 7.79576382 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 318 | 5.329999999999999e-104 | NR | AAD37351.1 | 5775 | g23591 | i0 | 76.6 | 0.832669322709163 | 209 | 48 | 83.3 | 1 | 61 | 687 | 3 | 210 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 627 | 318 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 29318804 | 29318804 | PRJNA493827_P_NODE_207529_length_246_cov_0.890173_g205331_i0 | PRJNA493827 | 207529 | 246 | 0.890173 | 2.18982558 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 154 | 3.099999999999999e-43 | NR | AAP88974.1 | 5775 | g205331 | i0 | 90.1 | 0.98780487804878 | 81 | 8 | 98.8 | 0 | 3 | 245 | 284 | 364 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 243 | 154 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 29823854 | 29823854 | PRJNA493827_P_NODE_175371_length_258_cov_1.248649_g173173_i0 | PRJNA493827 | 175371 | 258 | 1.248649 | 3.22151442 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 166 | 4.8e-47 | NR | BAN33737.1 | 931554 | g173173 | i0 | 89.5 | 1 | 86 | 9 | 100 | 0 | 1 | 258 | 315 | 400 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 258 | 166 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 30361691 | 30361691 | PRJNA493827_P_NODE_76372_length_395_cov_2.447205_g74174_i0 | PRJNA493827 | 76372 | 395 | 2.447205 | 9.66645975 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 230 | 3.18e-71 | NR | BAN33737.1 | 931554 | g74174 | i0 | 90.3 | 0.941772151898734 | 124 | 12 | 94.2 | 0 | 2 | 373 | 341 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 372 | 230 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 30424792 | 30424792 | PRJNA493827_P_NODE_191413_length_250_cov_0.870056_g189215_i0 | PRJNA493827 | 191413 | 250 | 0.870056 | 2.17514 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 66.2 | 2.09e-10 | NR | ABD16178.1 | 5775 | g189215 | i0 | 60.3 | 0.816 | 68 | 27 | 81.6 | 0 | 245 | 42 | 135 | 202 | ABD16178.1 110 kDa actin binding protein interacting with anti-filamin antibody [Amoeba proteus] | diamond | 204 | 66.2 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 30835055 | 30835055 | PRJNA493827_P_NODE_181594_length_253_cov_1.155556_g179396_i0 | PRJNA493827 | 181594 | 253 | 1.155556 | 2.92355668 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 63.9 | 1.46e-9 | NR | AAZ06403.1 | 5778 | g179396 | i0 | 42.9 | 0.74703557312253 | 63 | 36 | 74.7 | 0 | 190 | 2 | 519 | 581 | AAZ06403.1 mitochondrial helicase twinkle [Vermamoeba vermiformis] | diamond | 189 | 63.9 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 30850710 | 30850710 | PRJNA493827_P_NODE_11694_length_1209_cov_2.279930_g10325_i0 | PRJNA493827 | 11694 | 1209 | 2.27993 | 27.5643537 | root | 1 | Root_unresolved | Root_unresolved | 307 | 1.14e-97 | NR | AKT93936.1 | 5778 | g10325 | i0 | 54.1 | 1.3970223325062 | 281 | 125 | 69.7 | 2 | 34 | 876 | 124 | 400 | AKT93936.1 translation elongation factor Tu [Vermamoeba vermiformis] | diamond | 1689 | 310 | 0.990322580645161 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 32416537 | 32416537 | PRJNA493827_P_NODE_78339_length_389_cov_3.528481_g76141_i0 | PRJNA493827 | 78339 | 389 | 3.528481 | 13.72579109 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 222 | 5.7499999999999985e-68 | NR | BAN33737.1 | 931554 | g76141 | i0 | 89.1 | 0.917737789203085 | 119 | 13 | 91.8 | 0 | 389 | 33 | 344 | 462 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 357 | 222 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 32605987 | 32605987 | PRJNA493827_P_NODE_154920_length_275_cov_1.698020_g152722_i0 | PRJNA493827 | 154920 | 275 | 1.69802 | 4.669555 | Chaos carolinense | 160823 | Tubulinea | other_Eukaryota | 152 | 9.13e-44 | NR | AFX73090.1 | 160823 | g152722 | i0 | 81.3 | 1.98545454545455 | 91 | 17 | 99.3 | 0 | 274 | 2 | 99 | 189 | AFX73090.1 elongation factor 2 alpha, partial [Chaos carolinense] | diamond | 546 | 152 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense |
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);;