contig_metadata
7 rows where bioproject = "PRJNA839281" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11434097 | 11434097 | PRJNA839281_S_NODE_18889_length_190_cov_1.446809_g18620_i0 | PRJNA839281 | 18889 | 190 | 1.446809 | 2.7489371 | Tintinnida | 200604 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 3.34e-39 | NTclustered | gi|23957291|gb|AF399167.1| | 1513492 | g18620 | i0 | 83.158 | 97.8421052631579 | 190 | 32 | 100 | 0 | 1 | 190 | 509 | 320 | Schmidingerella sp. LAK-2008 clone Fehr99atub_3 alpha-tubulin gene, partial cds | blastn | 18590 | 174 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Tintinnida | Rhabdonellidae | Schmidingerella | Schmidingerella sp. LAK-2008 | ||
| 27623558 | 27623558 | PRJNA839281_S_NODE_9084_length_264_cov_0.986047_g8815_i0 | PRJNA839281 | 9084 | 264 | 0.986047 | 2.60316408 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 1.27e-27 | NR | CAG9318382.1 | 1481888 | g8815 | i0 | 64.8 | 0.806818181818182 | 71 | 20 | 80.7 | 1 | 2 | 214 | 79 | 144 | CAG9318382.1 unnamed protein product [Blepharisma stoltei] | diamond | 213 | 108 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 29549182 | 29549182 | PRJNA839281_S_NODE_35770_length_162_cov_0.902655_g35501_i0 | PRJNA839281 | 35770 | 162 | 0.902655 | 1.4623011 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 1.06e-5 | NR | XP_004039664.1 | 5932 | g35501 | i0 | 45.3 | 2.94444444444444 | 53 | 29 | 98.1 | 0 | 161 | 3 | 31 | 83 | XP_004039664.1 papain family cysteine protease, putative, partial [Ichthyophthirius multifiliis] | diamond | 477 | 50.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 31421977 | 31421977 | PRJNA839281_S_NODE_26976_length_167_cov_0.864407_g26707_i0 | PRJNA839281 | 26976 | 167 | 0.864407 | 1.44355969 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 53.9 | 1.52e-6 | NR | KRX04769.1 | 266149 | g26707 | i0 | 43.6 | 1.97604790419162 | 55 | 31 | 98.8 | 0 | 166 | 2 | 1858 | 1912 | KRX04769.1 Transcription factor, MADS-box [Pseudocohnilembus persalinus] | diamond | 330 | 53.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 31856246 | 31856246 | PRJNA839281_S_NODE_32437_length_164_cov_0.886957_g32168_i0 | PRJNA839281 | 32437 | 164 | 0.886957 | 1.45460948 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0177 | NR | CDW75269.1 | 5949 | g32168 | i0 | 37.8 | 0.823170731707317 | 45 | 28 | 82.3 | 0 | 27 | 161 | 504 | 548 | CDW75269.1 e3 ubiquitin-protein ligase [Stylonychia lemnae] | diamond | 135 | 42.4 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 32529474 | 32529474 | PRJNA839281_S_NODE_31879_length_164_cov_0.886957_g31610_i0 | PRJNA839281 | 31879 | 164 | 0.886957 | 1.45460948 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 1.29e-5 | NR | CAD8100483.1 | 5886 | g31610 | i0 | 47.5 | 3.71341463414634 | 40 | 21 | 73.2 | 0 | 164 | 45 | 206 | 245 | CAD8100483.1 unnamed protein product [Paramecium primaurelia] | diamond | 609 | 51.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 32898681 | 32898681 | PRJNA839281_S_NODE_18180_length_193_cov_1.472222_g17911_i0 | PRJNA839281 | 18180 | 193 | 1.472222 | 2.84138846 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 81.3 | 2.1e-16 | NR | OMJ79982.1 | 5963 | g17911 | i0 | 54.8 | 0.963730569948187 | 62 | 23 | 96.4 | 1 | 188 | 3 | 207 | 263 | OMJ79982.1 hypothetical protein SteCoe_19853 [Stentor coeruleus] | diamond | 186 | 81.3 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus |
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);;