contig_metadata
6 rows where bioproject = "PRJNA1122875", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8681918 | 8681918 | PRJNA1122875_P_NODE_27367_length_315_cov_2.884298_g27143_i0 | PRJNA1122875 | 27367 | 315 | 2.884298 | 9.0855387 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 582 | 8.459999999999998e-162 | NTclustered | gi|11527302|gb|AF293895.1|AF293895 | 136450 | g27143 | i0 | 100 | 85.4095238095238 | 315 | 0 | 100 | 0 | 1 | 315 | 701 | 1015 | Echinamoeba exundans small subunit ribosomal RNA gene, complete sequence | blastn | 26904 | 582 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba exundans | |||
| 20155024 | 20155024 | PRJNA1122875_P_NODE_11016_length_500_cov_3.882904_g10795_i0 | PRJNA1122875 | 11016 | 500 | 3.882904 | 19.41452 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 268 | 4.459999999999999e-67 | NTclustered | gi|49356809|gb|AY605213.1| | 282480 | g10795 | i0 | 85.551 | 40.662 | 263 | 30 | 60 | 6 | 147 | 407 | 649 | 905 | Uncultured Lobosea clone Sey078 small subunit ribosomal RNA gene, partial sequence | blastn | 20331 | 270 | 0.992592592592593 | Eukaryota | Amoebozoa | Tubulinea | uncultured Lobosea | ||||||
| 28670090 | 28670090 | PRJNA1122875_P_NODE_38847_length_266_cov_1.766839_g38623_i0 | PRJNA1122875 | 38847 | 266 | 1.766839 | 4.69979174 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.1 | 2.15e-6 | NR | AAD37351.1 | 5775 | g38623 | i0 | 48.1 | 1.46616541353383 | 54 | 28 | 60.9 | 0 | 104 | 265 | 10 | 63 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 390 | 55.1 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 29817288 | 29817288 | PRJNA1122875_P_NODE_51311_length_243_cov_1.129412_g51087_i0 | PRJNA1122875 | 51311 | 243 | 1.129412 | 2.74447116 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 55.5 | 2.13e-7 | NR | ABD72565.1 | 5778 | g51087 | i0 | 63.9 | 0.864197530864197 | 36 | 13 | 44.4 | 0 | 242 | 135 | 66 | 101 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 210 | 55.5 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 30765232 | 30765232 | PRJNA1122875_P_NODE_24794_length_333_cov_2.707692_g24570_i0 | PRJNA1122875 | 24794 | 333 | 2.707692 | 9.01661436 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 114 | 7.43e-29 | NR | AAY21191.1 | 5778 | g24570 | i0 | 62.2 | 1.76576576576577 | 98 | 37 | 88.3 | 0 | 1 | 294 | 149 | 246 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 588 | 114 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 31797539 | 31797539 | PRJNA1122875_P_NODE_32177_length_289_cov_1.069444_g31953_i0 | PRJNA1122875 | 32177 | 289 | 1.069444 | 3.09069316 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 2.12e-23 | NR | AAD37351.1 | 5775 | g31953 | i0 | 66.3 | 4.77508650519031 | 80 | 26 | 82 | 1 | 51 | 287 | 274 | 353 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 1380 | 103 | 0.990291262135922 | 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);;