contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA816047" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25739610 | 25739610 | PRJNA816047d_S_NODE_29498_length_392_cov_5.657817_g27666_i0 | PRJNA816047 | 29498 | 392 | 5.657817 | 22.17864264 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 233 | 4.26e-74 | NR | CAD8102823.1 | 5886 | g27666 | i0 | 86.8 | 474.076530612245 | 121 | 16 | 92.6 | 0 | 4 | 366 | 25 | 145 | CAD8102823.1 unnamed protein product [Paramecium primaurelia] | diamond | 185838 | 234 | 0.995726495726496 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 32924979 | 32924979 | PRJNA816047d_S_NODE_17161_length_542_cov_8.670757_g15421_i0 | PRJNA816047 | 17161 | 542 | 8.670757 | 46.99550294 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 6.57e-14 | NR | CAD8055348.1 | 5886 | g15421 | i0 | 31.3 | 3.01660516605166 | 134 | 92 | 74.2 | 0 | 541 | 140 | 31 | 164 | CAD8055348.1 unnamed protein product [Paramecium primaurelia] | diamond | 1635 | 77 | 0.994805194805195 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 32925065 | 32925065 | PRJNA816047d_S_NODE_76577_length_265_cov_1.136792_g74742_i0 | PRJNA816047 | 76577 | 265 | 1.136792 | 3.0124988 | root | 1 | Root_unresolved | Root_unresolved | 126 | 1.3499999999999999e-34 | NR | XP_001019714.4 | 312017 | g74742 | i0 | 75.7 | 5.13962264150943 | 74 | 18 | 83.8 | 0 | 1 | 222 | 110 | 183 | XP_001019714.4 methionine-R-sulfoxide reductase [Tetrahymena thermophila SB210] | diamond | 1362 | 127 | 0.992125984251969 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 32939142 | 32939142 | PRJNA816047d_S_NODE_44889_length_326_cov_1.461538_g43054_i0 | PRJNA816047 | 44889 | 326 | 1.461538 | 4.76461388 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 54.3 | 8.5e-6 | NR | CAG9315931.1 | 1481888 | g43054 | i0 | 41.7 | 1.37116564417178 | 72 | 34 | 58.9 | 3 | 133 | 324 | 388 | 459 | CAG9315931.1 unnamed protein product [Blepharisma stoltei] | diamond | 447 | 54.3 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 33024205 | 33024205 | PRJNA816047b_S_NODE_44596_length_257_cov_2.456522_g42284_i0 | PRJNA816047 | 44596 | 257 | 2.456522 | 6.31326154 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 3.18e-4 | NR | TNV78266.1 | 5974 | g42284 | i0 | 80.8 | 0.607003891050584 | 26 | 5 | 30.4 | 0 | 5 | 82 | 214 | 239 | TNV78266.1 hypothetical protein FGO68_gene9047 [Halteria grandinella] | diamond | 156 | 48.5 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 33041594 | 33041594 | PRJNA816047d_S_NODE_45772_length_323_cov_3.462963_g43937_i0 | PRJNA816047 | 45772 | 323 | 3.462963 | 11.18537049 | Paramecium pentaurelia | 43138 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 3.78e-9 | NR | CAD8205681.1 | 43138 | g43937 | i0 | 36.5 | 0.687306501547988 | 74 | 43 | 65 | 1 | 300 | 91 | 257 | 330 | CAD8205681.1 unnamed protein product [Paramecium pentaurelia] | diamond | 222 | 63.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 33061601 | 33061601 | PRJNA816047d_S_NODE_27429_length_407_cov_8.248588_g25599_i0 | PRJNA816047 | 27429 | 407 | 8.248588 | 33.57175316 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 131 | 9.76e-34 | NR | OMJ68875.1 | 5963 | g25599 | i0 | 63.5 | 7.0982800982801 | 96 | 35 | 70.8 | 0 | 405 | 118 | 295 | 390 | OMJ68875.1 hypothetical protein SteCoe_33545 [Stentor coeruleus] | diamond | 2889 | 131 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 33144048 | 33144048 | PRJNA816047d_S_NODE_62863_length_286_cov_2.085837_g61028_i0 | PRJNA816047 | 62863 | 286 | 2.085837 | 5.96549382 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 53.5 | 9.95e-6 | NR | XP_004037227.1 | 5932 | g61028 | i0 | 50 | 0.912587412587413 | 42 | 21 | 44.1 | 0 | 29 | 154 | 543 | 584 | XP_004037227.1 vacuolar sorting protein, putative [Ichthyophthirius multifiliis] | diamond | 261 | 53.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 33164003 | 33164003 | PRJNA816047d_S_NODE_65792_length_281_cov_2.070175_g63957_i0 | PRJNA816047 | 65792 | 281 | 2.070175 | 5.81719175 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 82.8 | 5e-16 | NR | CAD8082597.1 | 5886 | g63957 | i0 | 44.6 | 10.6975088967972 | 92 | 51 | 98.2 | 0 | 280 | 5 | 1438 | 1529 | CAD8082597.1 unnamed protein product [Paramecium primaurelia] | diamond | 3006 | 82.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia |
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);;