contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA285816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14400887 | 14400887 | PRJNA285816_S_NODE_1412_length_550_cov_11.429142_g1315_i0 | PRJNA285816 | 1412 | 550 | 11.429142 | 62.860281 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 186 | 5.259999999999998e-54 | NR | AAP88974.1 | 5775 | g1315 | i0 | 77.5 | 3.72 | 111 | 25 | 60.5 | 0 | 2 | 334 | 278 | 388 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 2046 | 187 | 0.994652406417112 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 24011083 | 24011083 | PRJNA285816_S_NODE_379_length_954_cov_20.555801_g331_i0 | PRJNA285816 | 379 | 954 | 20.555801 | 196.10234154 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 283 | 9.82e-92 | NR | AAY21191.1 | 5778 | g331 | i0 | 63.6 | 0.742138364779874 | 236 | 85 | 74.2 | 1 | 111 | 818 | 12 | 246 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 708 | 283 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24598167 | 24598167 | PRJNA285816_S_NODE_25480_length_167_cov_0.881356_g25378_i0 | PRJNA285816 | 25480 | 167 | 0.881356 | 1.47186452 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 97.1 | 9.89e-22 | NR | AKT93973.1 | 5778 | g25378 | i0 | 78.8 | 1.86826347305389 | 52 | 11 | 93.4 | 0 | 1 | 156 | 114 | 165 | AKT93973.1 NADH dehydrogenase subunit 11 [Vermamoeba vermiformis] | diamond | 312 | 97.1 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26947475 | 26947475 | PRJNA285816_S_NODE_29222_length_162_cov_1.345133_g29120_i0 | PRJNA285816 | 29222 | 162 | 1.345133 | 2.17911546 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 64.7 | 2.27e-10 | NR | AKN09691.1 | 5775 | g29120 | i0 | 50 | 2 | 54 | 27 | 100 | 0 | 162 | 1 | 754 | 807 | AKN09691.1 Tom70 [Amoeba proteus] | diamond | 324 | 64.7 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 27168740 | 27168740 | PRJNA285816_S_NODE_14082_length_204_cov_2.012903_g13980_i0 | PRJNA285816 | 14082 | 204 | 2.012903 | 4.10632212 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 104 | 3.3e-24 | NR | ABD62815.1 | 5778 | g13980 | i0 | 77.6 | 0.985294117647059 | 67 | 15 | 98.5 | 0 | 203 | 3 | 714 | 780 | ABD62815.1 mitochondrial single-subunit RNA polymerase [Vermamoeba vermiformis] | diamond | 201 | 104 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 28053172 | 28053172 | PRJNA285816_S_NODE_2045_length_463_cov_1.425121_g1943_i0 | PRJNA285816 | 2045 | 463 | 1.425121 | 6.59831023 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 229 | 3.23e-73 | NR | ABD46560.1 | 5778 | g1943 | i0 | 75.2 | 0.965442764578834 | 149 | 37 | 96.5 | 0 | 15 | 461 | 1 | 149 | ABD46560.1 lactate dehydrogenase-like protein, partial [Vermamoeba vermiformis] | diamond | 447 | 229 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 28084761 | 28084761 | PRJNA285816_S_NODE_29265_length_162_cov_1.168142_g29163_i0 | PRJNA285816 | 29265 | 162 | 1.168142 | 1.89239004 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 88.2 | 1.03e-18 | NR | BAN33737.1 | 931554 | g29163 | i0 | 81.1 | 19.6296296296296 | 53 | 10 | 98.1 | 0 | 160 | 2 | 11 | 63 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 3180 | 88.2 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 30422082 | 30422082 | PRJNA285816_S_NODE_493_length_859_cov_6.423457_g439_i0 | PRJNA285816 | 493 | 859 | 6.423457 | 55.17749563 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 190 | 3.6999999999999994e-57 | NR | ABD72565.1 | 5778 | g439 | i0 | 64.2 | 0.478463329452852 | 137 | 49 | 47.8 | 0 | 127 | 537 | 1 | 137 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 411 | 190 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 31622714 | 31622714 | PRJNA285816_S_NODE_30656_length_152_cov_2.019417_g30554_i0 | PRJNA285816 | 30656 | 152 | 2.019417 | 3.06951384 | Saccamoeba lacustris | 704142 | Tubulinea | other_Eukaryota | 53.9 | 1.05e-6 | NR | AFX73097.1 | 704142 | g30554 | i0 | 58.1 | 2.54605263157895 | 43 | 18 | 84.9 | 0 | 129 | 1 | 145 | 187 | AFX73097.1 elongation factor 2 alpha, partial [Saccamoeba lacustris] | diamond | 387 | 53.9 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba lacustris | ||
| 31717636 | 31717636 | PRJNA285816_S_NODE_1117_length_615_cov_20.628975_g1030_i0 | PRJNA285816 | 1117 | 615 | 20.628975 | 126.86819625 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 172 | 3.14e-51 | NR | ABD72565.1 | 5778 | g1030 | i0 | 59 | 0.678048780487805 | 139 | 55 | 67.8 | 1 | 118 | 534 | 1 | 137 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 417 | 172 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 32445595 | 32445595 | PRJNA285816_S_NODE_7759_length_255_cov_1.975728_g7657_i0 | PRJNA285816 | 7759 | 255 | 1.975728 | 5.0381064 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 126 | 2.66e-34 | NR | ABD46563.1 | 5778 | g7657 | i0 | 69.9 | 1.95294117647059 | 83 | 24 | 97.6 | 1 | 6 | 254 | 46 | 127 | ABD46563.1 succinyl-diaminopimelate desuccinylase-like protein A, partial [Vermamoeba vermiformis] | diamond | 498 | 126 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 32872750 | 32872750 | PRJNA285816_S_NODE_10160_length_229_cov_2.772222_g10058_i0 | PRJNA285816 | 10160 | 229 | 2.772222 | 6.34838838 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 132 | 5.469999999999999e-38 | NR | AAX57202.1 | 5778 | g10058 | i0 | 91.4 | 6.74672489082969 | 70 | 6 | 91.7 | 0 | 229 | 20 | 59 | 128 | AAX57202.1 vacuolar protein sorting protein 26, partial [Vermamoeba vermiformis] | diamond | 1545 | 132 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis |
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);;