contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax_phylum = "Ciliophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27904809 | 27904809 | PRJNA724039_S_NODE_13385_length_175_cov_1.688406_g13178_i0 | PRJNA724039 | 13385 | 175 | 1.688406 | 2.9547105 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 1.98e-10 | NR | CAD8127098.1 | 65129 | g13178 | i0 | 71.7 | 0.788571428571429 | 46 | 13 | 78.9 | 0 | 1 | 138 | 91 | 136 | CAD8127098.1 unnamed protein product [Paramecium sonneborni] | diamond | 138 | 62.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 28126166 | 28126166 | PRJNA724039_S_NODE_14825_length_166_cov_0.899225_g14618_i0 | PRJNA724039 | 14825 | 166 | 0.899225 | 1.4927135 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 8.37e-14 | NR | TNV71297.1 | 5974 | g14618 | i0 | 63.6 | 0.993975903614458 | 55 | 20 | 99.4 | 0 | 166 | 2 | 158 | 212 | TNV71297.1 hypothetical protein FGO68_gene13476 [Halteria grandinella] | diamond | 165 | 72.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 28578555 | 28578555 | PRJNA724039_S_NODE_13707_length_173_cov_1.279412_g13500_i0 | PRJNA724039 | 13707 | 173 | 1.279412 | 2.21338276 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.57e-5 | NR | XP_004035553.1 | 5932 | g13500 | i0 | 50 | 2.20231213872832 | 44 | 22 | 76.3 | 0 | 170 | 39 | 76 | 119 | XP_004035553.1 hypothetical protein IMG5_097440 [Ichthyophthirius multifiliis] | diamond | 381 | 49.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 29736118 | 29736118 | PRJNA724039_S_NODE_17690_length_152_cov_1.260870_g17483_i0 | PRJNA724039 | 17690 | 152 | 1.26087 | 1.9165224 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 7.19e-16 | NR | KRX10691.1 | 266149 | g17483 | i0 | 64 | 0.986842105263158 | 50 | 18 | 98.7 | 0 | 150 | 1 | 36 | 85 | KRX10691.1 Translation protein SH3-like domain [Pseudocohnilembus persalinus] | diamond | 150 | 75.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 30463384 | 30463384 | PRJNA724039_S_NODE_17713_length_152_cov_1.069565_g17506_i0 | PRJNA724039 | 17713 | 152 | 1.069565 | 1.6257388 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 1.99e-14 | NR | CDW79023.1 | 5949 | g17506 | i0 | 76 | 2.96052631578947 | 50 | 12 | 98.7 | 0 | 152 | 3 | 34 | 83 | CDW79023.1 ribosomal protein 11a 60s large ribosomal subunit [Stylonychia lemnae] | diamond | 450 | 73.2 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 32360441 | 32360441 | PRJNA724039_S_NODE_6659_length_264_cov_1.647577_g6452_i0 | PRJNA724039 | 6659 | 264 | 1.647577 | 4.34960328 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 1.74e-17 | NR | KRX06453.1 | 266149 | g6452 | i0 | 50.6 | 0.875 | 77 | 38 | 87.5 | 0 | 1 | 231 | 89 | 165 | KRX06453.1 Ribosomal protein L11, N-terminal [Pseudocohnilembus persalinus] | diamond | 231 | 82.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 32875188 | 32875188 | PRJNA724039_S_NODE_6100_length_278_cov_1.410788_g5893_i0 | PRJNA724039 | 6100 | 278 | 1.410788 | 3.92199064 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 87.8 | 5.45e-20 | NR | CAD8057916.1 | 5886 | g5893 | i0 | 56.7 | 3.61510791366906 | 67 | 29 | 72.3 | 0 | 266 | 66 | 33 | 99 | CAD8057916.1 unnamed protein product [Paramecium primaurelia] | diamond | 1005 | 87.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia |
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);;