contig_metadata
6 rows where bioproject = "PRJNA1098727" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2761803 | 2761803 | PRJNA1098727_P_NODE_14523_length_165_cov_0.896552_g14282_i0 | PRJNA1098727 | 14523 | 165 | 0.896552 | 1.4793108 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 5.98e-51 | NTclustered | gi|829194196|ref|XM_001025062.3| | 312017 | g14282 | i0 | 90.244 | 0.993939393939394 | 164 | 15 | 99 | 1 | 2 | 164 | 253 | 90 | Tetrahymena thermophila SB210 40S ribosomal protein S24 partial mRNA | blastn | 164 | 213 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 6589194 | 6589194 | PRJNA1098727_P_NODE_10806_length_184_cov_1.525926_g10565_i0 | PRJNA1098727 | 10806 | 184 | 1.525926 | 2.80770384 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 8.430000000000001e-80 | NTclustered | gi|829174498|ref|XM_001017626.3| | 312017 | g10565 | i0 | 97.253 | 7.92391304347826 | 182 | 5 | 99 | 0 | 2 | 183 | 511 | 330 | Tetrahymena thermophila SB210 ubiquitin/ribosomal fusion protein, putative partial mRNA | blastn | 1458 | 309 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 6589212 | 6589212 | PRJNA1098727_P_NODE_13846_length_166_cov_1.384615_g13605_i0 | PRJNA1098727 | 13846 | 166 | 1.384615 | 2.2984609 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 7.91e-40 | NTclustered | gi|829160192|ref|XM_001012283.3| | 312017 | g13605 | i0 | 89.362 | 1.36746987951807 | 141 | 13 | 84 | 2 | 2 | 141 | 68 | 207 | Tetrahymena thermophila SB210 40S ribosomal protein S28e, putative partial mRNA | blastn | 227 | 176 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 7397623 | 7397623 | PRJNA1098727_P_NODE_13706_length_167_cov_0.881356_g13465_i0 | PRJNA1098727 | 13706 | 167 | 0.881356 | 1.47186452 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 307 | 2.71e-79 | NTclustered | gi|1621572405|gb|MH051920.1| | 5893 | g13465 | i0 | 100 | 99.4011976047904 | 166 | 0 | 99 | 0 | 2 | 167 | 1280 | 1445 | Tetrahymena borealis strain 1630/5A small subunit ribosomal RNA gene, partial sequence | blastn | 16600 | 307 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena borealis | ||
| 12498631 | 12498631 | PRJNA1098727_P_NODE_14190_length_165_cov_2.189655_g13949_i0 | PRJNA1098727 | 14190 | 165 | 2.189655 | 3.61293075 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 2.69e-74 | NTclustered | gi|115353907|gb|DQ868347.1| | 77619 | g13949 | i0 | 98.773 | 99.2181818181818 | 163 | 2 | 99 | 0 | 2 | 164 | 625 | 787 | Vorticella microstoma 18S small subunit ribosomal RNA gene, partial sequence | blastn | 16371 | 291 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella microstoma | ||
| 31647700 | 31647700 | PRJNA1098727_P_NODE_11877_length_175_cov_1.325397_g11636_i0 | PRJNA1098727 | 11877 | 175 | 1.325397 | 2.31944475 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 41.6 | 0.04 | NR | XP_001006991.2 | 312017 | g11636 | i0 | 36.2 | 0.994285714285714 | 58 | 37 | 99.4 | 0 | 175 | 2 | 2464 | 2521 | XP_001006991.2 bowman-birk serine protease inhibitor family protein [Tetrahymena thermophila SB210] | diamond | 174 | 41.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila |
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);;