contig_metadata
5 rows where bioproject = "PRJNA811725" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22486856 | 22486856 | PRJNA811725_P_NODE_29958_length_285_cov_0.834906_g29712_i0 | PRJNA811725 | 29958 | 285 | 0.834906 | 2.3794821 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 427 | 3.74e-115 | NTclustered | gi|262262907|gb|FJ766450.1| | 472931 | g29712 | i0 | 97.967 | 60.3719298245614 | 246 | 5 | 86 | 0 | 1 | 246 | 246 | 1 | Protostelium mycophagum strain HI06-9a-2 small subunit ribosomal RNA gene, partial sequence | blastn | 17206 | 427 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 28191054 | 28191054 | PRJNA811725_P_NODE_19766_length_341_cov_1.436567_g19520_i0 | PRJNA811725 | 19766 | 341 | 1.436567 | 4.89869347 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 126 | 6.1e-31 | NR | PRP85597.1 | 1890364 | g19520 | i0 | 61.5 | 0.914956011730205 | 104 | 38 | 89.7 | 2 | 2 | 307 | 39 | 142 | PRP85597.1 hypothetical protein PROFUN_06386 [Planoprotostelium fungivorum] | diamond | 312 | 126 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28633523 | 28633523 | PRJNA811725_P_NODE_19167_length_346_cov_2.923077_g18921_i0 | PRJNA811725 | 19167 | 346 | 2.923077 | 10.11384642 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 99 | 9.19e-22 | NR | PRP82315.1 | 1890364 | g18921 | i0 | 52.4 | 0.910404624277457 | 105 | 48 | 91 | 2 | 1 | 315 | 49 | 151 | PRP82315.1 hypothetical protein PROFUN_10387 [Planoprotostelium fungivorum] | diamond | 315 | 99 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28822464 | 28822464 | PRJNA811725_P_NODE_8308_length_511_cov_19.847032_g8065_i0 | PRJNA811725 | 8308 | 511 | 19.847032 | 101.41833352 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 312 | 7.48e-103 | NR | PRP86571.1 | 1890364 | g8065 | i0 | 88.8 | 0.992172211350294 | 169 | 19 | 99.2 | 0 | 1 | 507 | 190 | 358 | PRP86571.1 Rab GDP dissociation inhibitor alpha [Planoprotostelium fungivorum] | diamond | 507 | 312 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32267421 | 32267421 | PRJNA811725_P_NODE_6118_length_591_cov_13.938224_g5879_i0 | PRJNA811725 | 6118 | 591 | 13.938224 | 82.37490384 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 148 | 3.11e-39 | NR | PRP82315.1 | 1890364 | g5879 | i0 | 47.9 | 0.741116751269036 | 146 | 62 | 67.5 | 4 | 591 | 193 | 155 | 299 | PRP82315.1 hypothetical protein PROFUN_10387 [Planoprotostelium fungivorum] | diamond | 438 | 148 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum |
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);;