contig_metadata
11 rows where bioproject = "PRJNA854078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11045325 | 11045325 | PRJNA854078_P_NODE_13749_length_253_cov_1.972222_g13537_i0 | PRJNA854078 | 13749 | 253 | 1.972222 | 4.98972166 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 1.18e-25 | NR | CAG9315503.1 | 1481888 | g13537 | i0 | 60.5 | 1.0197628458498 | 86 | 31 | 99.6 | 2 | 1 | 252 | 471 | 555 | CAG9315503.1 unnamed protein product [Blepharisma stoltei] | diamond | 258 | 109 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 13595411 | 13595411 | PRJNA854078_P_NODE_13651_length_254_cov_1.723757_g13439_i0 | PRJNA854078 | 13651 | 254 | 1.723757 | 4.37834278 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 1.4e-28 | NR | CAI2368680.1 | 5936 | g13439 | i0 | 66.7 | 1.91338582677165 | 81 | 27 | 95.7 | 0 | 252 | 10 | 147 | 227 | CAI2368680.1 unnamed protein product [Moneuplotes crassus] | diamond | 486 | 116 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 14869588 | 14869588 | PRJNA854078_P_NODE_10972_length_284_cov_2.189573_g10760_i0 | PRJNA854078 | 10972 | 284 | 2.189573 | 6.21838732 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 177 | 1.22e-52 | NR | TNV77769.1 | 5974 | g10760 | i0 | 86.2 | 137.514084507042 | 94 | 13 | 99.3 | 0 | 282 | 1 | 17 | 110 | TNV77769.1 hypothetical protein FGO68_gene430 [Halteria grandinella] | diamond | 39054 | 177 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 14869647 | 14869647 | PRJNA854078_P_NODE_16232_length_242_cov_1.449704_g16020_i0 | PRJNA854078 | 16232 | 242 | 1.449704 | 3.50828368 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.11e-114 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g16020 | i0 | 98.347 | 100.252066115702 | 242 | 4 | 100 | 0 | 1 | 242 | 1042 | 1283 | Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 24261 | 425 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 27402802 | 27402802 | PRJNA854078_P_NODE_15023_length_247_cov_0.885057_g14811_i0 | PRJNA854078 | 15023 | 247 | 0.885057 | 2.18609079 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 57.4 | 2.62e-7 | NR | CAI2359579.1 | 5936 | g14811 | i0 | 38.4 | 1.04453441295547 | 86 | 47 | 97.2 | 2 | 6 | 245 | 551 | 636 | CAI2359579.1 unnamed protein product [Moneuplotes crassus] | diamond | 258 | 57.4 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 27497516 | 27497516 | PRJNA854078_P_NODE_9403_length_307_cov_1.316239_g9191_i0 | PRJNA854078 | 9403 | 307 | 1.316239 | 4.04085373 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 3.65e-10 | NR | KRX02789.1 | 266149 | g9191 | i0 | 35 | 0.977198697068404 | 100 | 65 | 97.7 | 0 | 8 | 307 | 15 | 114 | KRX02789.1 hypothetical protein PPERSA_02279 [Pseudocohnilembus persalinus] | diamond | 300 | 64.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 28223455 | 28223455 | PRJNA854078_P_NODE_10526_length_290_cov_1.364055_g10314_i0 | PRJNA854078 | 10526 | 290 | 1.364055 | 3.9557595 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 41.6 | 0.0477 | NR | CAD8182443.1 | 43137 | g10314 | i0 | 41.3 | 0.475862068965517 | 46 | 26 | 47.6 | 1 | 196 | 59 | 28 | 72 | CAD8182443.1 unnamed protein product [Paramecium octaurelia] | diamond | 138 | 41.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 28444804 | 28444804 | PRJNA854078_P_NODE_2406_length_617_cov_1.400735_g2203_i0 | PRJNA854078 | 2406 | 617 | 1.400735 | 8.64253495 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 1.48e-26 | NR | XP_001019547.3 | 312017 | g2203 | i0 | 44.7 | 4.82333873581848 | 150 | 80 | 71.5 | 3 | 444 | 4 | 24 | 173 | XP_001019547.3 papain family cysteine protease [Tetrahymena thermophila SB210] | diamond | 2976 | 115 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 28579243 | 28579243 | PRJNA854078_P_NODE_5227_length_414_cov_2.302053_g5015_i0 | PRJNA854078 | 5227 | 414 | 2.302053 | 9.53049942 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 0.00111 | NR | XP_004035812.1 | 5932 | g5015 | i0 | 26.3 | 3.40579710144928 | 118 | 79 | 80.4 | 3 | 49 | 381 | 258 | 374 | XP_004035812.1 protein kinase domain protein [Ichthyophthirius multifiliis] | diamond | 1410 | 49.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 29234077 | 29234077 | PRJNA854078_P_NODE_14389_length_250_cov_0.870056_g14177_i0 | PRJNA854078 | 14389 | 250 | 0.870056 | 2.17514 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 5.74e-8 | NR | CAD8110744.1 | 65129 | g14177 | i0 | 39.5 | 4.884 | 81 | 47 | 97.2 | 1 | 8 | 250 | 307 | 385 | CAD8110744.1 unnamed protein product [Paramecium sonneborni] | diamond | 1221 | 59.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 31698548 | 31698548 | PRJNA854078_P_NODE_7257_length_350_cov_1.079422_g7045_i0 | PRJNA854078 | 7257 | 350 | 1.079422 | 3.777977 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 1.59e-13 | NR | CAD8086221.1 | 65129 | g7045 | i0 | 35 | 0.882857142857143 | 103 | 67 | 88.3 | 0 | 10 | 318 | 205 | 307 | CAD8086221.1 unnamed protein product [Paramecium sonneborni] | diamond | 309 | 76.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni |
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);;