contig_metadata
11 rows where bioproject = "PRJNA879314", tax_phylum = "Ciliophora" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2133265 | 2133265 | PRJNA879314_P_NODE_8862_length_246_cov_0.901734_g8812_i0 | PRJNA879314 | 8862 | 246 | 0.901734 | 2.21826564 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 6.77e-25 | NR | CDW90126.1 | 5949 | g8812 | i0 | 62.8 | 1.92682926829268 | 78 | 29 | 95.1 | 0 | 3 | 236 | 993 | 1070 | CDW90126.1 UNKNOWN [Stylonychia lemnae] | diamond | 474 | 107 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 2133271 | 2133271 | PRJNA879314_P_NODE_9062_length_246_cov_0.861272_g9012_i0 | PRJNA879314 | 9062 | 246 | 0.861272 | 2.11872912 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 95.1 | 1.43e-20 | NR | CAI2369615.1 | 5936 | g9012 | i0 | 61.7 | 50.3780487804878 | 81 | 31 | 98.8 | 0 | 2 | 244 | 832 | 912 | CAI2369615.1 unnamed protein product [Moneuplotes crassus] | diamond | 12393 | 95.9 | 0.991657977059437 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 5961139 | 5961139 | PRJNA879314_P_NODE_7525_length_248_cov_0.891429_g7475_i0 | PRJNA879314 | 7525 | 248 | 0.891429 | 2.21074392 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 3.59e-41 | NR | CAI2371497.1 | 5936 | g7475 | i0 | 87.8 | 0.991935483870968 | 82 | 10 | 99.2 | 0 | 1 | 246 | 134 | 215 | CAI2371497.1 unnamed protein product [Moneuplotes crassus] | diamond | 246 | 149 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 17817877 | 17817877 | PRJNA879314_P_NODE_3154_length_283_cov_1.090476_g3104_i0 | PRJNA879314 | 3154 | 283 | 1.090476 | 3.08604708 | Entodinium | 40635 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 3.739999999999999e-110 | NTclustered | gi|2643596937|gb|PP067609.1| | 47911 | g3104 | i0 | 92.908 | 81.1236749116608 | 282 | 20 | 99 | 0 | 1 | 282 | 1955 | 2236 | Entodinium caudatum isolate SAG3_0_NT_6493 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 22958 | 414 | 0.992753623188406 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Entodinium | Entodinium caudatum | ||
| 19984563 | 19984563 | PRJNA879314_P_NODE_5716_length_251_cov_0.876404_g5666_i0 | PRJNA879314 | 5716 | 251 | 0.876404 | 2.19977404 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 1.63e-18 | NR | CAG9311558.1 | 1481888 | g5666 | i0 | 52 | 1.8406374501992 | 75 | 36 | 89.6 | 0 | 233 | 9 | 169 | 243 | CAG9311558.1 unnamed protein product [Blepharisma stoltei] | diamond | 462 | 89 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 27537301 | 27537301 | PRJNA879314_P_NODE_9203_length_245_cov_0.906977_g9153_i0 | PRJNA879314 | 9203 | 245 | 0.906977 | 2.22209365 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 5.29e-5 | NR | KRW98726.1 | 266149 | g9153 | i0 | 40.5 | 4.60408163265306 | 79 | 33 | 79.6 | 2 | 1 | 195 | 322 | 400 | KRW98726.1 WD40-repeat-containing domain [Pseudocohnilembus persalinus] | diamond | 1128 | 51.2 | 0.9921875 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 27939846 | 27939846 | PRJNA879314_P_NODE_9145_length_245_cov_0.906977_g9095_i0 | PRJNA879314 | 9145 | 245 | 0.906977 | 2.22209365 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 2.47e-22 | NR | CAG9326741.1 | 1481888 | g9095 | i0 | 58.2 | 0.96734693877551 | 79 | 33 | 96.7 | 0 | 237 | 1 | 11 | 89 | CAG9326741.1 unnamed protein product [Blepharisma stoltei] | diamond | 237 | 98.6 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 28137355 | 28137355 | PRJNA879314_P_NODE_11385_length_242_cov_0.899408_g11335_i0 | PRJNA879314 | 11385 | 242 | 0.899408 | 2.17656736 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 8.88e-30 | NR | CAD8115536.1 | 5886 | g11335 | i0 | 69.6 | 2.87603305785124 | 79 | 23 | 96.7 | 1 | 241 | 8 | 592 | 670 | CAD8115536.1 unnamed protein product [Paramecium primaurelia] | diamond | 696 | 121 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 31920255 | 31920255 | PRJNA879314_P_NODE_6897_length_249_cov_0.886364_g6847_i0 | PRJNA879314 | 6897 | 249 | 0.886364 | 2.20704636 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 3.27e-21 | NR | TNV85598.1 | 5974 | g6847 | i0 | 59.7 | 5.66265060240964 | 77 | 31 | 92.8 | 0 | 237 | 7 | 67 | 143 | TNV85598.1 hypothetical protein FGO68_gene9158 [Halteria grandinella] | diamond | 1410 | 97.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 32686902 | 32686902 | PRJNA879314_P_NODE_5480_length_251_cov_0.876404_g5430_i0 | PRJNA879314 | 5480 | 251 | 0.876404 | 2.19977404 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 3.14e-33 | NR | AAB81612.1 | 5911 | g5430 | i0 | 78 | 7.88844621513944 | 82 | 18 | 98 | 0 | 4 | 249 | 332 | 413 | AAB81612.1 cytoplasmic dynein heavy chain 1a, partial [Tetrahymena thermophila] | diamond | 1980 | 132 | 0.992424242424242 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32773412 | 32773412 | PRJNA879314_P_NODE_6560_length_250_cov_0.881356_g6510_i0 | PRJNA879314 | 6560 | 250 | 0.881356 | 2.20339 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 2.53e-35 | NR | XP_004023914.1 | 5932 | g6510 | i0 | 82.9 | 4.908 | 82 | 14 | 98.4 | 0 | 3 | 248 | 20 | 101 | XP_004023914.1 hypothetical protein IMG5_202680 [Ichthyophthirius multifiliis] | diamond | 1227 | 134 | 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);;