contig_metadata
13 rows where bioproject = "PRJNA770361", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022492 | 2022492 | PRJNA770361_P_NODE_7442_length_344_cov_1.439114_g7347_i0 | PRJNA770361 | 7442 | 344 | 1.439114 | 4.95055216 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 9.509999999999999e-39 | NR | XP_001452550.1 | 5888 | g7347 | i0 | 56.6 | 2.93895348837209 | 113 | 49 | 98.5 | 0 | 344 | 6 | 135 | 247 | XP_001452550.1 uncharacterized protein GSPATT00002553001 [Paramecium tetraurelia] | diamond | 1011 | 143 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 19873043 | 19873043 | PRJNA770361_P_NODE_12816_length_261_cov_1.436170_g12721_i0 | PRJNA770361 | 12816 | 261 | 1.43617 | 3.7484037 | Dasytricha ruminantium | 40806 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 6.209999999999999e-48 | NTclustered | gi|92790147|emb|AJ965259.1| | 40806 | g12721 | i0 | 90.323 | 89.9846743295019 | 155 | 15 | 59 | 0 | 1 | 155 | 328 | 174 | Dasytricha ruminantium partial mRNA for Polyubiqutin 3 (polyubiqutin 3 gene) | blastn | 23486 | 204 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Dasytricha | Dasytricha ruminantium | ||
| 26809726 | 26809726 | PRJNA770361_P_NODE_661_length_1110_cov_2.739634_g605_i0 | PRJNA770361 | 661 | 1110 | 2.739634 | 30.4099374 | Sporadotrichida | 693921 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 9.67e-124 | NR | CDW71733.1 | 5949 | g605 | i0 | 54.7 | 2.02702702702703 | 371 | 162 | 99.7 | 4 | 2 | 1108 | 1209 | 1575 | CDW71733.1 glycosyl group 1 family protein [Stylonychia lemnae] | diamond | 2250 | 407 | 0.99017199017199 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 27337817 | 27337817 | PRJNA770361_P_NODE_16763_length_247_cov_0.896552_g16668_i0 | PRJNA770361 | 16763 | 247 | 0.896552 | 2.21448344 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 4.08e-20 | NR | TNV79705.1 | 5974 | g16668 | i0 | 56.1 | 7.96761133603239 | 82 | 34 | 97.2 | 2 | 243 | 4 | 90 | 171 | TNV79705.1 hypothetical protein FGO68_gene12357 [Halteria grandinella] | diamond | 1968 | 93.6 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 27337832 | 27337832 | PRJNA770361_P_NODE_7143_length_351_cov_1.122302_g7048_i0 | PRJNA770361 | 7143 | 351 | 1.122302 | 3.93928002 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 1.32e-23 | NR | CDW83169.1 | 5949 | g7048 | i0 | 49.5 | 0.931623931623932 | 109 | 54 | 93.2 | 1 | 22 | 348 | 8 | 115 | CDW83169.1 UNKNOWN [Stylonychia lemnae] | diamond | 327 | 97.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 27401031 | 27401031 | PRJNA770361_P_NODE_16603_length_247_cov_0.896552_g16508_i0 | PRJNA770361 | 16603 | 247 | 0.896552 | 2.21448344 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.0017 | NR | KRX04237.1 | 266149 | g16508 | i0 | 40.6 | 0.777327935222672 | 64 | 37 | 76.5 | 1 | 23 | 211 | 200 | 263 | KRX04237.1 hypothetical protein PPERSA_11361 [Pseudocohnilembus persalinus] | diamond | 192 | 46.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 27568250 | 27568250 | PRJNA770361_P_NODE_11484_length_278_cov_1.521951_g11389_i0 | PRJNA770361 | 11484 | 278 | 1.521951 | 4.23102378 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 2.42e-6 | NR | OMJ70979.1 | 5963 | g11389 | i0 | 30.6 | 19.9748201438849 | 85 | 59 | 91.7 | 0 | 267 | 13 | 40 | 124 | OMJ70979.1 hypothetical protein SteCoe_30929 [Stentor coeruleus] | diamond | 5553 | 55.5 | 0.992792792792793 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 29241807 | 29241807 | PRJNA770361_P_NODE_3049_length_540_cov_1.441113_g2955_i0 | PRJNA770361 | 3049 | 540 | 1.441113 | 7.7820102 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 8.05e-26 | NR | CAD8090783.1 | 65129 | g2955 | i0 | 36 | 2.17777777777778 | 197 | 91 | 99.4 | 5 | 537 | 1 | 402 | 581 | CAD8090783.1 unnamed protein product [Paramecium sonneborni] | diamond | 1176 | 114 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 30432749 | 30432749 | PRJNA770361_P_NODE_15953_length_248_cov_0.891429_g15858_i0 | PRJNA770361 | 15953 | 248 | 0.891429 | 2.21074392 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 8.25e-6 | NR | OMJ66319.1 | 5963 | g15858 | i0 | 38 | 2.87903225806452 | 79 | 48 | 94.4 | 1 | 236 | 3 | 44 | 122 | OMJ66319.1 hypothetical protein SteCoe_36864 [Stentor coeruleus] | diamond | 714 | 53.1 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 30568074 | 30568074 | PRJNA770361_P_NODE_7713_length_338_cov_1.766038_g7618_i0 | PRJNA770361 | 7713 | 338 | 1.766038 | 5.96920844 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 2.18e-5 | NR | CDW85742.1 | 5949 | g7618 | i0 | 33.7 | 1.59763313609467 | 92 | 45 | 72.8 | 2 | 1 | 246 | 154 | 239 | CDW85742.1 protein kinase [Stylonychia lemnae] | diamond | 540 | 53.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30568075 | 30568075 | PRJNA770361_P_NODE_8193_length_329_cov_0.914062_g8098_i0 | PRJNA770361 | 8193 | 329 | 0.914062 | 3.00726398 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.0208 | NR | CDW88435.1 | 5949 | g8098 | i0 | 44.4 | 3.75683890577508 | 45 | 25 | 41 | 0 | 101 | 235 | 89 | 133 | CDW88435.1 protein kinase domain containing protein [Stylonychia lemnae] | diamond | 1236 | 44.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30906519 | 30906519 | PRJNA770361_P_NODE_9894_length_300_cov_1.374449_g9799_i0 | PRJNA770361 | 9894 | 300 | 1.374449 | 4.123347 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 57.8 | 3.35e-8 | NR | KAL4463804.1 | 5901 | g9799 | i0 | 50 | 0.54 | 54 | 27 | 54 | 0 | 253 | 92 | 40 | 93 | KAL4463804.1 hypothetical protein ABPG74_005741 [Tetrahymena malaccensis] | diamond | 162 | 57.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 30947705 | 30947705 | PRJNA770361_P_NODE_2794_length_567_cov_1.408907_g2700_i0 | PRJNA770361 | 2794 | 567 | 1.408907 | 7.98850269 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 2.63e-11 | NR | TNV83925.1 | 5974 | g2700 | i0 | 30.6 | 7.41798941798942 | 157 | 106 | 81.5 | 3 | 75 | 536 | 86 | 242 | TNV83925.1 hypothetical protein FGO68_gene17221 [Halteria grandinella] | diamond | 4206 | 73.2 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella |
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);;