contig_metadata
20 rows where bioproject = "PRJNA495391", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 476749 | 476749 | PRJNA495391_S_NODE_48261_length_178_cov_1.111888_g47209_i0 | PRJNA495391 | 48261 | 178 | 1.111888 | 1.97916064 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 1.4e-52 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g47209 | i0 | 88.764 | 87.7359550561798 | 178 | 20 | 100 | 0 | 1 | 178 | 227 | 404 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 15617 | 219 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 6210587 | 6210587 | PRJNA495391_S_NODE_24865_length_241_cov_8.223301_g23813_i0 | PRJNA495391 | 24865 | 241 | 8.223301 | 19.81815541 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 435 | 1.84e-117 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g23813 | i0 | 99.17 | 80.0331950207469 | 241 | 2 | 100 | 0 | 1 | 241 | 3189 | 2949 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 19288 | 435 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 8128851 | 8128851 | PRJNA495391_S_NODE_15907_length_300_cov_2.460377_g14855_i0 | PRJNA495391 | 15907 | 300 | 2.460377 | 7.381131 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 7.389999999999999e-32 | NR | CAD8069000.1 | 65129 | g14855 | i0 | 66 | 3.99 | 100 | 32 | 100 | 1 | 300 | 1 | 48 | 145 | CAD8069000.1 unnamed protein product [Paramecium sonneborni] | diamond | 1197 | 124 | 0.991935483870968 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 10679293 | 10679293 | PRJNA495391_S_NODE_10289_length_375_cov_5.641176_g9237_i0 | PRJNA495391 | 10289 | 375 | 5.641176 | 21.15441 | Epistylis sp. 6 | 2979169 | SAR_Eukaryotes | SAR_Eukaryotes | 676 | 0 | NTclustered | gi|2304601482|gb|OP458303.1| | 2979169 | g9237 | i0 | 99.2 | 98.8933333333333 | 375 | 3 | 100 | 0 | 1 | 375 | 410 | 36 | Epistylis sp. 6 large subunit ribosomal RNA gene, partial sequence | blastn | 37085 | 676 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Epistylidae | Epistylis | Epistylis sp. 6 | ||
| 15779168 | 15779168 | PRJNA495391_S_NODE_42273_length_189_cov_1.448052_g41221_i0 | PRJNA495391 | 42273 | 189 | 1.448052 | 2.73681828 | Sterkiella nova | 200597 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 9.49e-20 | NTclustered | gi|405113127|gb|JX441317.1| | 200597 | g41221 | i0 | 81.159 | 4.33333333333333 | 138 | 24 | 72 | 2 | 15 | 151 | 368 | 504 | Sterkiella nova macronuclear nanochromosome, complete sequence | blastn | 819 | 110 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella nova | ||
| 19601804 | 19601804 | PRJNA495391_S_NODE_18676_length_277_cov_2.586777_g17624_i0 | PRJNA495391 | 18676 | 277 | 2.586777 | 7.16537229 | Philasterida sp. | 2006707 | SAR_Eukaryotes | SAR_Eukaryotes | 172 | 1.87e-38 | NTclustered | gi|2354193480|gb|OP896969.1| | 2006707 | g17624 | i0 | 79.273 | 55.4729241877256 | 275 | 36 | 97 | 17 | 3 | 270 | 1239 | 979 | Philasterida sp. strain tDaCF9_52 large subunit ribosomal RNA gene, partial sequence | blastn | 15366 | 172 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasterida sp. | ||||
| 27108357 | 27108357 | PRJNA495391_S_NODE_49602_length_175_cov_2.585714_g48550_i0 | PRJNA495391 | 49602 | 175 | 2.585714 | 4.5249995 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0113 | NR | TNV87635.1 | 5974 | g48550 | i0 | 47.5 | 0.685714285714286 | 40 | 21 | 68.6 | 0 | 17 | 136 | 919 | 958 | TNV87635.1 hypothetical protein FGO68_gene9300 [Halteria grandinella] | diamond | 120 | 43.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 27234988 | 27234988 | PRJNA495391_S_NODE_22203_length_255_cov_1.609091_g21151_i0 | PRJNA495391 | 22203 | 255 | 1.609091 | 4.10318205 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 5.7e-7 | NR | KRX07656.1 | 266149 | g21151 | i0 | 39.7 | 2.87058823529412 | 63 | 36 | 71.8 | 1 | 250 | 68 | 2211 | 2273 | KRX07656.1 Ubiquitin-conjugating enzyme/RWD-like protein [Pseudocohnilembus persalinus] | diamond | 732 | 56.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 27424853 | 27424853 | PRJNA495391_S_NODE_11723_length_350_cov_1.863492_g10671_i0 | PRJNA495391 | 11723 | 350 | 1.863492 | 6.522222 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 3.27e-30 | NR | XP_001031847.2 | 312017 | g10671 | i0 | 48.3 | 1.98857142857143 | 116 | 42 | 99.4 | 2 | 349 | 2 | 138 | 235 | XP_001031847.2 60S ribosomal protein L7 [Tetrahymena thermophila SB210] | diamond | 696 | 118 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 27772132 | 27772132 | PRJNA495391_S_NODE_47464_length_179_cov_1.708333_g46412_i0 | PRJNA495391 | 47464 | 179 | 1.708333 | 3.05791607 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 4.97e-8 | NR | CAG9319528.1 | 1481888 | g46412 | i0 | 63.9 | 3.53631284916201 | 36 | 13 | 60.3 | 0 | 179 | 72 | 262 | 297 | CAG9319528.1 unnamed protein product [Blepharisma stoltei] | diamond | 633 | 58.2 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 30092337 | 30092337 | PRJNA495391_S_NODE_19132_length_274_cov_2.150628_g18080_i0 | PRJNA495391 | 19132 | 274 | 2.150628 | 5.89272072 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 88.2 | 5.77e-18 | NR | KRX08632.1 | 266149 | g18080 | i0 | 58.2 | 1.5 | 67 | 28 | 73.4 | 0 | 274 | 74 | 60 | 126 | KRX08632.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] | diamond | 411 | 88.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 30692750 | 30692750 | PRJNA495391_S_NODE_17553_length_286_cov_2.047809_g16501_i0 | PRJNA495391 | 17553 | 286 | 2.047809 | 5.85673374 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 82.8 | 1.31e-18 | NR | XP_004023838.1 | 5932 | g16501 | i0 | 79.6 | 1.12237762237762 | 54 | 10 | 55.6 | 1 | 2 | 160 | 15 | 68 | XP_004023838.1 ribosomal protein, putative [Ichthyophthirius multifiliis] | diamond | 321 | 82.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 31056747 | 31056747 | PRJNA495391_S_NODE_25055_length_240_cov_4.209756_g24003_i0 | PRJNA495391 | 25055 | 240 | 4.209756 | 10.1034144 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.5e-25 | NR | CAD8050189.1 | 65129 | g24003 | i0 | 62.5 | 3.8875 | 80 | 29 | 98.8 | 1 | 2 | 238 | 61 | 140 | CAD8050189.1 unnamed protein product [Paramecium sonneborni] | diamond | 933 | 102 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 31245998 | 31245998 | PRJNA495391_S_NODE_28655_length_226_cov_1.445026_g27603_i0 | PRJNA495391 | 28655 | 226 | 1.445026 | 3.26575876 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 66.6 | 1.14e-10 | NR | CAD8188981.1 | 43137 | g27603 | i0 | 52.5 | 0.783185840707965 | 59 | 27 | 78.3 | 1 | 2 | 178 | 503 | 560 | CAD8188981.1 unnamed protein product [Paramecium octaurelia] | diamond | 177 | 66.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 31340936 | 31340936 | PRJNA495391_S_NODE_18216_length_280_cov_4.077551_g17164_i0 | PRJNA495391 | 18216 | 280 | 4.077551 | 11.4171428 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 1.02e-22 | NR | CAG9335557.1 | 1481888 | g17164 | i0 | 83.1 | 0.632142857142857 | 59 | 10 | 63.2 | 0 | 103 | 279 | 11 | 69 | CAG9335557.1 unnamed protein product [Blepharisma stoltei] | diamond | 177 | 99.4 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 31499248 | 31499248 | PRJNA495391_S_NODE_36816_length_201_cov_2.222892_g35764_i0 | PRJNA495391 | 36816 | 201 | 2.222892 | 4.46801292 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 98.2 | 8.419999999999999e-23 | NR | KRW99550.1 | 266149 | g35764 | i0 | 65.8 | 1.08955223880597 | 73 | 18 | 98.5 | 2 | 200 | 3 | 165 | 237 | KRW99550.1 hypothetical protein PPERSA_02408 [Pseudocohnilembus persalinus] | diamond | 219 | 98.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 32163562 | 32163562 | PRJNA495391_S_NODE_26438_length_234_cov_3.105528_g25386_i0 | PRJNA495391 | 26438 | 234 | 3.105528 | 7.26693552 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 2.48e-9 | NR | CAG9312301.1 | 1481888 | g25386 | i0 | 50.9 | 2.1025641025641 | 55 | 26 | 70.5 | 1 | 176 | 12 | 132 | 185 | CAG9312301.1 unnamed protein product [Blepharisma stoltei] | diamond | 492 | 61.6 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 32226853 | 32226853 | PRJNA495391_S_NODE_34118_length_208_cov_3.167630_g33066_i0 | PRJNA495391 | 34118 | 208 | 3.16763 | 6.5886704 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 1.42e-13 | NR | OMJ72236.1 | 5963 | g33066 | i0 | 54.4 | 0.980769230769231 | 68 | 31 | 98.1 | 0 | 206 | 3 | 13 | 80 | OMJ72236.1 hypothetical protein SteCoe_29375 [Stentor coeruleus] | diamond | 204 | 69.7 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 32495522 | 32495522 | PRJNA495391_S_NODE_46439_length_181_cov_1.506849_g45387_i0 | PRJNA495391 | 46439 | 181 | 1.506849 | 2.72739669 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 5.93e-16 | NR | XP_001454088.1 | 5888 | g45387 | i0 | 63.8 | 4.87292817679558 | 58 | 21 | 96.1 | 0 | 8 | 181 | 506 | 563 | XP_001454088.1 uncharacterized protein GSPATT00020363001 [Paramecium tetraurelia] | diamond | 882 | 80.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 32763587 | 32763587 | PRJNA495391_S_NODE_54640_length_168_cov_1.526316_g53588_i0 | PRJNA495391 | 54640 | 168 | 1.526316 | 2.56421088 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 1.77e-5 | NR | XP_004035127.1 | 5932 | g53588 | i0 | 38.9 | 2.96428571428571 | 54 | 32 | 96.4 | 1 | 6 | 167 | 224 | 276 | XP_004035127.1 hypothetical protein IMG5_105540 [Ichthyophthirius multifiliis] | diamond | 498 | 50.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis |
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);;