contig_metadata
8 rows where bioproject = "PRJNA904835", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7625549 | 7625549 | PRJNA904835_P_NODE_46486_length_269_cov_1.515306_g46230_i0 | PRJNA904835 | 46486 | 269 | 1.515306 | 4.07617314 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 1.91e-29 | NR | XP_004039325.1 | 5932 | g46230 | i0 | 62.5 | 7.6728624535316 | 88 | 33 | 98.1 | 0 | 1 | 264 | 326 | 413 | XP_004039325.1 papain family cysteine protease, putative [Ichthyophthirius multifiliis] | diamond | 2064 | 120 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 14910595 | 14910595 | PRJNA904835_P_NODE_23272_length_415_cov_0.801170_g23017_i0 | PRJNA904835 | 23272 | 415 | 0.80117 | 3.3248555 | Isotricha intestinalis | 47897 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 2.6000000000000003e-123 | NTclustered | gi|92790153|emb|AJ965262.1| | 47897 | g23017 | i0 | 86.779 | 198.265060240964 | 416 | 46 | 99 | 9 | 5 | 414 | 538 | 126 | Isotricha intestinalis partial mRNA for Polyubiqutin 2 (polyubiqutin 2 gene) | blastn | 82280 | 455 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Isotricha | Isotricha intestinalis | ||
| 14910966 | 14910966 | PRJNA904835_P_NODE_34872_length_328_cov_0.905882_g34616_i0 | PRJNA904835 | 34872 | 328 | 0.905882 | 2.97129296 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 2.99e-37 | NR | XP_004034912.1 | 5932 | g34616 | i0 | 60.6 | 3.71341463414634 | 104 | 40 | 95.1 | 1 | 313 | 2 | 2 | 104 | XP_004034912.1 hypothetical protein IMG5_109970 [Ichthyophthirius multifiliis] | diamond | 1218 | 134 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 17461756 | 17461756 | PRJNA904835_P_NODE_51614_length_250_cov_0.870056_g51358_i0 | PRJNA904835 | 51614 | 250 | 0.870056 | 2.17514 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 2.59e-32 | NR | XP_001024675.2 | 312017 | g51358 | i0 | 68.7 | 1.992 | 83 | 26 | 99.6 | 0 | 2 | 250 | 230 | 312 | XP_001024675.2 aspartyl-tRNA synthetase protein [Tetrahymena thermophila SB210] | diamond | 498 | 127 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 25109069 | 25109069 | PRJNA904835_P_NODE_34940_length_327_cov_1.515748_g34684_i0 | PRJNA904835 | 34940 | 327 | 1.515748 | 4.95649596 | Oxytricha trifallax | 1172189 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.031 | NTclustered | gi|612176406|gb|KJ573500.1| | 1172189 | g34684 | i0 | 100 | 0.0856269113149847 | 28 | 0 | 9 | 0 | 230 | 257 | 775 | 802 | Oxytricha trifallax strain JRB310 TEBPalpha gene, complete sequence; micronuclear | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Oxytricha | Oxytricha trifallax | ||
| 28635209 | 28635209 | PRJNA904835_P_NODE_8587_length_736_cov_1.613876_g8357_i0 | PRJNA904835 | 8587 | 736 | 1.613876 | 11.87812736 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 2.9e-13 | NR | CDW86772.1 | 5949 | g8357 | i0 | 42.6 | 0.525815217391304 | 129 | 65 | 50.5 | 5 | 654 | 283 | 15 | 139 | CDW86772.1 UNKNOWN [Stylonychia lemnae] | diamond | 387 | 76.3 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 28950895 | 28950895 | PRJNA904835_P_NODE_56548_length_244_cov_0.900585_g56292_i0 | PRJNA904835 | 56548 | 244 | 0.900585 | 2.1974274 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 2.54e-25 | NR | XP_004040108.1 | 5932 | g56292 | i0 | 62 | 1.94262295081967 | 79 | 30 | 97.1 | 0 | 239 | 3 | 108 | 186 | XP_004040108.1 hypothetical protein IMG5_001810 [Ichthyophthirius multifiliis] | diamond | 474 | 108 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 30537388 | 30537388 | PRJNA904835_P_NODE_44513_length_278_cov_1.497561_g44257_i0 | PRJNA904835 | 44513 | 278 | 1.497561 | 4.16321958 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 7.21e-35 | NR | CAD8077690.1 | 5886 | g44257 | i0 | 67.8 | 3.82014388489209 | 90 | 29 | 97.1 | 0 | 273 | 4 | 147 | 236 | CAD8077690.1 unnamed protein product [Paramecium primaurelia] | diamond | 1062 | 130 | 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);;