contig_metadata
4 rows where bioproject = "PRJNA846110" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7211151 | 7211151 | PRJNA846110_P_NODE_21406_length_256_cov_1.415301_g21161_i0 | PRJNA846110 | 21406 | 256 | 1.415301 | 3.62317056 | Frontonia depressa | 3042678 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 7.69e-62 | NTclustered | gi|2496410947|gb|OQ869835.1| | 3042678 | g21161 | i0 | 85.141 | 90.9296875 | 249 | 31 | 96 | 4 | 1 | 246 | 1549 | 1794 | Frontonia depressa isolate S229 large subunit ribosomal RNA gene, partial sequence | blastn | 23278 | 250 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Frontoniidae | Frontonia | Frontonia depressa | ||
| 28042361 | 28042361 | PRJNA846110_P_NODE_28305_length_243_cov_1.435294_g28060_i0 | PRJNA846110 | 28305 | 243 | 1.435294 | 3.48776442 | Tetrahymenidae | 291294 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 3.74e-29 | NR | XP_004035755.1 | 5932 | g28060 | i0 | 69.6 | 4.90123456790123 | 79 | 24 | 97.5 | 0 | 239 | 3 | 110 | 188 | XP_004035755.1 hypothetical protein IMG5_090680 [Ichthyophthirius multifiliis] | diamond | 1191 | 119 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 29336880 | 29336880 | PRJNA846110_P_NODE_30329_length_241_cov_0.916667_g30084_i0 | PRJNA846110 | 30329 | 241 | 0.916667 | 2.20916747 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 1.71e-33 | NR | XP_001024675.2 | 312017 | g30084 | i0 | 78.2 | 1.94190871369295 | 78 | 17 | 97.1 | 0 | 5 | 238 | 473 | 550 | XP_001024675.2 aspartyl-tRNA synthetase protein [Tetrahymena thermophila SB210] | diamond | 468 | 130 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29928548 | 29928548 | PRJNA846110_P_NODE_15231_length_286_cov_1.483568_g14986_i0 | PRJNA846110 | 15231 | 286 | 1.483568 | 4.24300448 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 8.91e-7 | NR | CAD8166097.1 | 43137 | g14986 | i0 | 36.3 | 2.21328671328671 | 102 | 53 | 96.5 | 4 | 278 | 3 | 11 | 110 | CAD8166097.1 unnamed protein product [Paramecium octaurelia] | diamond | 633 | 55.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia |
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);;