contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA690592" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1947886 | 1947886 | PRJNA690592_S_NODE_6002_length_1117_cov_2.328544_g5442_i0 | PRJNA690592 | 6002 | 1117 | 2.328544 | 26.00983648 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 513 | 1.66e-179 | NR | AAP88974.1 | 5775 | g5442 | i0 | 74.9 | 5.23992837958818 | 323 | 81 | 86.8 | 0 | 1 | 969 | 66 | 388 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 5853 | 516 | 0.994186046511628 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 1948154 | 1948154 | PRJNA690592_S_NODE_9762_length_918_cov_8.375148_g9029_i0 | PRJNA690592 | 9762 | 918 | 8.375148 | 76.88385864 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 280 | 1.4799999999999999e-90 | NR | AAY21191.1 | 5778 | g9029 | i0 | 61.8 | 0.777777777777778 | 238 | 88 | 77.8 | 2 | 796 | 83 | 12 | 246 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 714 | 280 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 8325215 | 8325215 | PRJNA690592_S_NODE_9167_length_942_cov_5.329114_g8454_i0 | PRJNA690592 | 9167 | 942 | 5.329114 | 50.20025388 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 283 | 1.25e-91 | NR | AAY21191.1 | 5778 | g8454 | i0 | 63.1 | 0.751592356687898 | 236 | 86 | 75.2 | 1 | 121 | 828 | 12 | 246 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 708 | 283 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 9600416 | 9600416 | PRJNA690592_S_NODE_72788_length_374_cov_1.279070_g71774_i0 | PRJNA690592 | 72788 | 374 | 1.27907 | 4.7837218 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 198 | 1.1199999999999999e-60 | NR | AFX84545.1 | 5778 | g71774 | i0 | 75 | 10.9171122994652 | 124 | 31 | 99.5 | 0 | 372 | 1 | 22 | 145 | AFX84545.1 alpha tubulin, partial [Vermamoeba vermiformis] | diamond | 4083 | 199 | 0.994974874371859 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21073976 | 21073976 | PRJNA690592_S_NODE_2117_length_1606_cov_8.810176_g1821_i0 | PRJNA690592 | 2117 | 1606 | 8.810176 | 141.49142656 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 769 | 2.4e-276 | NR | BAN33737.1 | 931554 | g1821 | i0 | 81.2 | 2.57036114570361 | 463 | 81 | 85.4 | 1 | 1572 | 202 | 1 | 463 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 4128 | 769 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 22348143 | 22348143 | PRJNA690592_S_NODE_11898_length_843_cov_3.467532_g11095_i0 | PRJNA690592 | 11898 | 843 | 3.467532 | 29.23129476 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 423 | 2.439999999999999e-145 | NR | AAP88974.1 | 5775 | g11095 | i0 | 78.2 | 0.9644128113879 | 271 | 56 | 96.1 | 2 | 841 | 32 | 122 | 390 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 813 | 423 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 28345716 | 28345716 | PRJNA690592_S_NODE_173866_length_259_cov_1.241935_g172852_i0 | PRJNA690592 | 173866 | 259 | 1.241935 | 3.21661165 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 117 | 1.61e-30 | NR | ABD46545.1 | 5778 | g172852 | i0 | 72.7 | 0.891891891891892 | 77 | 21 | 89.2 | 0 | 28 | 258 | 116 | 192 | ABD46545.1 aldehyde dehydrogenase, partial [Vermamoeba vermiformis] | diamond | 231 | 117 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 28377163 | 28377163 | PRJNA690592_S_NODE_11066_length_869_cov_4.407035_g10282_i0 | PRJNA690592 | 11066 | 869 | 4.407035 | 38.29713415 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 191 | 2.03e-57 | NR | ABD72565.1 | 5778 | g10282 | i0 | 65 | 0.472957422324511 | 137 | 48 | 47.3 | 0 | 729 | 319 | 1 | 137 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 411 | 191 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 28472218 | 28472218 | PRJNA690592_S_NODE_23806_length_615_cov_2.872694_g22818_i0 | PRJNA690592 | 23806 | 615 | 2.872694 | 17.6670681 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 163 | 6.789999999999998e-48 | NR | ABD72565.1 | 5778 | g22818 | i0 | 56.1 | 0.678048780487805 | 139 | 59 | 67.8 | 1 | 139 | 555 | 1 | 137 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 417 | 163 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 29103707 | 29103707 | PRJNA690592_S_NODE_214788_length_241_cov_1.226190_g213774_i0 | PRJNA690592 | 214788 | 241 | 1.22619 | 2.9551179 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 47.8 | 5.48e-4 | NR | AKN09692.1 | 5775 | g213774 | i0 | 32.9 | 0.983402489626556 | 79 | 51 | 95.9 | 1 | 6 | 236 | 149 | 227 | AKN09692.1 Tom40 [Amoeba proteus] | diamond | 237 | 47.8 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 29135362 | 29135362 | PRJNA690592_S_NODE_194849_length_248_cov_0.880000_g193835_i0 | PRJNA690592 | 194849 | 248 | 0.88 | 2.1824 | Arcella hemisphaerica | 497998 | Tubulinea | other_Eukaryota | 120 | 1.71e-31 | NR | ADM22175.1 | 497998 | g193835 | i0 | 74.6 | 0.858870967741935 | 71 | 18 | 85.9 | 0 | 35 | 247 | 154 | 224 | ADM22175.1 actin, partial [Arcella hemisphaerica] | diamond | 213 | 120 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella hemisphaerica | ||
| 29956043 | 29956043 | PRJNA690592_S_NODE_105811_length_320_cov_1.870445_g104797_i0 | PRJNA690592 | 105811 | 320 | 1.870445 | 5.985424 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 117 | 1.48e-28 | NR | BAN33737.1 | 931554 | g104797 | i0 | 89.1 | 1.2375 | 64 | 7 | 60 | 0 | 5 | 196 | 401 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 396 | 117 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 32169150 | 32169150 | PRJNA690592_S_NODE_194338_length_248_cov_1.320000_g193324_i0 | PRJNA690592 | 194338 | 248 | 1.32 | 3.2736 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 114 | 2.6e-27 | NR | AKN09691.1 | 5775 | g193324 | i0 | 59.3 | 1.97177419354839 | 81 | 32 | 98 | 1 | 5 | 247 | 594 | 673 | AKN09691.1 Tom70 [Amoeba proteus] | diamond | 489 | 114 | 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);;