contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJEB7366" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3961325 | 3961325 | PRJEB7366_P_NODE_11584_length_239_cov_1.436275_g11150_i0 | PRJEB7366 | 11584 | 239 | 1.436275 | 3.43269725 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 152 | 1.12e-42 | NR | AAP88974.1 | 5775 | g11150 | i0 | 89.9 | 0.99163179916318 | 79 | 8 | 99.2 | 0 | 238 | 2 | 92 | 170 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 237 | 152 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 3961385 | 3961385 | PRJEB7366_P_NODE_5044_length_405_cov_1.581081_g4611_i0 | PRJEB7366 | 5044 | 405 | 1.581081 | 6.40337805 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 246 | 1.95e-78 | NR | AAP88974.1 | 5775 | g4611 | i0 | 88.1 | 0.992592592592593 | 134 | 16 | 99.3 | 0 | 3 | 404 | 203 | 336 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 402 | 246 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 26907576 | 26907576 | PRJEB7366_P_NODE_2462_length_616_cov_3.280551_g2080_i0 | PRJEB7366 | 2462 | 616 | 3.280551 | 20.20819416 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 375 | 8.38e-127 | NR | BAN33737.1 | 931554 | g2080 | i0 | 89.5 | 0.974025974025974 | 200 | 21 | 97.4 | 0 | 615 | 16 | 263 | 462 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 600 | 375 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 27152903 | 27152903 | PRJEB7366_P_NODE_9062_length_280_cov_1.795918_g8628_i0 | PRJEB7366 | 9062 | 280 | 1.795918 | 5.0285704 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 140 | 4.03e-37 | NR | BAN33737.1 | 931554 | g8628 | i0 | 83.5 | 3.675 | 79 | 13 | 84.6 | 0 | 238 | 2 | 244 | 322 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 1029 | 141 | 0.99290780141844 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 27160287 | 27160287 | PRJEB7366_P_NODE_23982_length_153_cov_1.355932_g23548_i0 | PRJEB7366 | 23982 | 153 | 1.355932 | 2.07457596 | Chaos carolinense | 160823 | Tubulinea | other_Eukaryota | 100 | 2.5399999999999998e-24 | NR | AFX73090.1 | 160823 | g23548 | i0 | 96 | 0.980392156862745 | 50 | 2 | 98 | 0 | 2 | 151 | 197 | 246 | AFX73090.1 elongation factor 2 alpha, partial [Chaos carolinense] | diamond | 150 | 100 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 27192036 | 27192036 | PRJEB7366_P_NODE_9482_length_272_cov_1.734177_g9048_i0 | PRJEB7366 | 9482 | 272 | 1.734177 | 4.71696144 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 172 | 2.48e-49 | NR | BAN33737.1 | 931554 | g9048 | i0 | 87.8 | 0.992647058823529 | 90 | 11 | 99.3 | 0 | 272 | 3 | 321 | 410 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 270 | 172 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 27350472 | 27350472 | PRJEB7366_P_NODE_16023_length_194_cov_1.962264_g15589_i0 | PRJEB7366 | 16023 | 194 | 1.962264 | 3.80679216 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 120 | 2.68e-30 | NR | BAN33737.1 | 931554 | g15589 | i0 | 88.9 | 0.974226804123711 | 63 | 7 | 97.4 | 0 | 2 | 190 | 340 | 402 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 189 | 120 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 28013492 | 28013492 | PRJEB7366_P_NODE_22325_length_159_cov_3.032258_g21891_i0 | PRJEB7366 | 22325 | 159 | 3.032258 | 4.82129022 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 98.6 | 1.79e-22 | NR | BAN33737.1 | 931554 | g21891 | i0 | 90.4 | 0.981132075471698 | 52 | 5 | 98.1 | 0 | 157 | 2 | 408 | 459 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 156 | 98.6 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 28297388 | 28297388 | PRJEB7366_P_NODE_11886_length_235_cov_1.400000_g11452_i0 | PRJEB7366 | 11886 | 235 | 1.4 | 3.29 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 135 | 4.05e-36 | NR | AAD37351.1 | 5775 | g11452 | i0 | 84.2 | 0.970212765957447 | 76 | 12 | 97 | 0 | 231 | 4 | 133 | 208 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 228 | 135 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 28297394 | 28297394 | PRJEB7366_P_NODE_22286_length_160_cov_0.960000_g21852_i0 | PRJEB7366 | 22286 | 160 | 0.96 | 1.536 | Chaos carolinense | 160823 | Tubulinea | other_Eukaryota | 98.2 | 2.31e-24 | NR | AFX73058.1 | 160823 | g21852 | i0 | 86.5 | 0.975 | 52 | 7 | 97.5 | 0 | 158 | 3 | 63 | 114 | AFX73058.1 14-3-3 protein, partial [Chaos carolinense] | diamond | 156 | 98.2 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 28771021 | 28771021 | PRJEB7366_P_NODE_1787_length_733_cov_1.871060_g1452_i0 | PRJEB7366 | 1787 | 733 | 1.87106 | 13.7148698 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 401 | 2.8e-136 | NR | BAN33737.1 | 931554 | g1452 | i0 | 77.7 | 1.01091405184175 | 247 | 52 | 99.9 | 1 | 1 | 732 | 167 | 413 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 741 | 401 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 29181720 | 29181720 | PRJEB7366_P_NODE_20289_length_169_cov_1.179104_g19855_i0 | PRJEB7366 | 20289 | 169 | 1.179104 | 1.99268576 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 106 | 2.43e-25 | NR | BAN33737.1 | 931554 | g19855 | i0 | 91.1 | 1.97041420118343 | 56 | 5 | 99.4 | 0 | 2 | 169 | 123 | 178 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 333 | 106 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 30697548 | 30697548 | PRJEB7366_P_NODE_22214_length_160_cov_1.280000_g21780_i0 | PRJEB7366 | 22214 | 160 | 1.28 | 2.048 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 41.2 | 0.0415 | NR | AAY21191.1 | 5778 | g21780 | i0 | 45.5 | 1.65 | 44 | 24 | 82.5 | 0 | 159 | 28 | 199 | 242 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 264 | 41.2 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 30824036 | 30824036 | PRJEB7366_P_NODE_5954_length_365_cov_1.678788_g5521_i0 | PRJEB7366 | 5954 | 365 | 1.678788 | 6.1275762 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 167 | 5.16e-47 | NR | BAN33737.1 | 931554 | g5521 | i0 | 66.1 | 1.98082191780822 | 124 | 39 | 99.5 | 1 | 363 | 1 | 141 | 264 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 723 | 167 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 31076928 | 31076928 | PRJEB7366_P_NODE_21095_length_165_cov_1.230769_g20661_i0 | PRJEB7366 | 21095 | 165 | 1.230769 | 2.03076885 | Chaos carolinense | 160823 | Tubulinea | other_Eukaryota | 94.4 | 9.78e-22 | NR | AFX73090.1 | 160823 | g20661 | i0 | 79.6 | 0.981818181818182 | 54 | 11 | 98.2 | 0 | 164 | 3 | 131 | 184 | AFX73090.1 elongation factor 2 alpha, partial [Chaos carolinense] | diamond | 162 | 94.4 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 31322395 | 31322395 | PRJEB7366_P_NODE_23095_length_156_cov_1.661157_g22661_i0 | PRJEB7366 | 23095 | 156 | 1.661157 | 2.59140492 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 9.49e-24 | NR | BAN33737.1 | 931554 | g22661 | i0 | 96.1 | 5.88461538461539 | 51 | 2 | 98.1 | 0 | 2 | 154 | 80 | 130 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 918 | 102 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 32373799 | 32373799 | PRJEB7366_P_NODE_21779_length_162_cov_1.244094_g21345_i0 | PRJEB7366 | 21779 | 162 | 1.244094 | 2.01543228 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 92.8 | 1.86e-20 | NR | AAD37351.1 | 5775 | g21345 | i0 | 79.6 | 1 | 54 | 11 | 100 | 0 | 1 | 162 | 108 | 161 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 162 | 92.8 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus |
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);;