contig_metadata
13 rows where bioproject = "PRJNA807347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7184579 | 7184579 | PRJNA807347_P_NODE_1966_length_596_cov_2.397706_g1865_i0 | PRJNA807347 | 1966 | 596 | 2.397706 | 14.29032776 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 985 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1865 | i0 | 96.477 | 67.3406040268456 | 596 | 21 | 100 | 0 | 1 | 596 | 605 | 10 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 40135 | 985 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 7184600 | 7184600 | PRJNA807347_P_NODE_6926_length_311_cov_1.903361_g6823_i0 | PRJNA807347 | 6926 | 311 | 1.903361 | 5.91945271 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 1.7699999999999996e-47 | NR | CDW86855.1 | 5949 | g6823 | i0 | 74.5 | 10.8327974276527 | 102 | 26 | 98.4 | 0 | 310 | 5 | 30 | 131 | CDW86855.1 nucleoside diphosphate kinase [Stylonychia lemnae] | diamond | 3369 | 159 | 0.993710691823899 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 8875790 | 8875790 | PRJNA807347_P_NODE_7987_length_290_cov_1.755760_g7884_i0 | PRJNA807347 | 7987 | 290 | 1.75576 | 5.091704 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 520 | 6.119999999999998e-143 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g7884 | i0 | 98.966 | 22.944827586206905 | 290 | 3 | 100 | 0 | 1 | 290 | 1165 | 1454 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 6654 | 520 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 16108696 | 16108696 | PRJNA807347_P_NODE_1193_length_750_cov_2.819793_g1099_i0 | PRJNA807347 | 1193 | 750 | 2.819793 | 21.1484475 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 1256 | 0 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g1099 | i0 | 96.929 | 50.1866666666667 | 749 | 23 | 99 | 0 | 2 | 750 | 2293 | 1545 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 37640 | 1256 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 18657752 | 18657752 | PRJNA807347_P_NODE_9975_length_268_cov_1.553846_g9872_i0 | PRJNA807347 | 9975 | 268 | 1.553846 | 4.16430728 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 5.52e-40 | NR | OMJ67736.1 | 5963 | g9872 | i0 | 71.6 | 3.95149253731343 | 88 | 25 | 98.5 | 0 | 268 | 5 | 143 | 230 | OMJ67736.1 hypothetical protein SteCoe_35015 [Stentor coeruleus] | diamond | 1059 | 142 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 22483194 | 22483194 | PRJNA807347_P_NODE_2778_length_504_cov_1.287703_g2675_i0 | PRJNA807347 | 2778 | 504 | 1.287703 | 6.49002312 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 116 | 1.14e-26 | NR | XP_001427897.1 | 5888 | g2675 | i0 | 40.1 | 2.88690476190476 | 162 | 93 | 94.6 | 2 | 477 | 1 | 1997 | 2157 | XP_001427897.1 uncharacterized protein GSPATT00005249001 [Paramecium tetraurelia] | diamond | 1455 | 116 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 26936411 | 26936411 | PRJNA807347_P_NODE_8642_length_282_cov_1.861244_g8539_i0 | PRJNA807347 | 8642 | 282 | 1.861244 | 5.24870808 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 85.1 | 1.81e-18 | NR | XP_004037566.1 | 5932 | g8539 | i0 | 46.8 | 3.75531914893617 | 94 | 49 | 98.9 | 1 | 282 | 4 | 6 | 99 | XP_004037566.1 transcription factor btf3, putative [Ichthyophthirius multifiliis] | diamond | 1059 | 85.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 27915728 | 27915728 | PRJNA807347_P_NODE_3865_length_423_cov_1.514286_g3762_i0 | PRJNA807347 | 3865 | 423 | 1.514286 | 6.40542978 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 2.7299999999999998e-40 | NR | XP_004027231.1 | 5932 | g3762 | i0 | 51.4 | 6.5177304964539 | 142 | 65 | 97.9 | 1 | 417 | 4 | 11 | 152 | XP_004027231.1 hypothetical protein IMG5_187300 [Ichthyophthirius multifiliis] | diamond | 2757 | 142 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 28137061 | 28137061 | PRJNA807347_P_NODE_8925_length_279_cov_1.475728_g8822_i0 | PRJNA807347 | 8925 | 279 | 1.475728 | 4.11728112 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 82.8 | 4.34e-16 | NR | CAD8146100.1 | 43138 | g8822 | i0 | 48.1 | 1.6989247311828 | 79 | 41 | 84.9 | 0 | 2 | 238 | 414 | 492 | CAD8146100.1 unnamed protein product [Paramecium pentaurelia] | diamond | 474 | 83.2 | 0.995192307692308 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 29485453 | 29485453 | PRJNA807347_P_NODE_12050_length_252_cov_0.871508_g11947_i0 | PRJNA807347 | 12050 | 252 | 0.871508 | 2.19620016 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 114 | 3.03e-27 | NR | CAG9311497.1 | 1481888 | g11947 | i0 | 50.5 | 4.35714285714286 | 95 | 35 | 98.8 | 2 | 4 | 252 | 474 | 568 | CAG9311497.1 unnamed protein product [Blepharisma stoltei] | diamond | 1098 | 114 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 29801332 | 29801332 | PRJNA807347_P_NODE_16591_length_243_cov_0.911765_g16488_i0 | PRJNA807347 | 16591 | 243 | 0.911765 | 2.21558895 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 1.22e-6 | NR | CAD8067693.1 | 65129 | g16488 | i0 | 40.6 | 0.851851851851852 | 69 | 41 | 85.2 | 0 | 242 | 36 | 750 | 818 | CAD8067693.1 unnamed protein product [Paramecium sonneborni] | diamond | 207 | 55.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 31136993 | 31136993 | PRJNA807347_P_NODE_7455_length_299_cov_1.367257_g7352_i0 | PRJNA807347 | 7455 | 299 | 1.367257 | 4.08809843 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 3.79e-15 | NR | CAD8206115.1 | 43137 | g7352 | i0 | 50 | 4.90635451505017 | 80 | 39 | 79.3 | 1 | 299 | 63 | 29 | 108 | CAD8206115.1 unnamed protein product [Paramecium octaurelia] | diamond | 1467 | 76.6 | 0.996083550913838 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 31674766 | 31674766 | PRJNA807347_P_NODE_14617_length_246_cov_2.346821_g14514_i0 | PRJNA807347 | 14617 | 246 | 2.346821 | 5.77317966 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 63.5 | 1.79e-9 | NR | TNV74080.1 | 5974 | g14514 | i0 | 42.3 | 6.30487804878049 | 78 | 44 | 93.9 | 1 | 8 | 238 | 202 | 279 | TNV74080.1 hypothetical protein FGO68_gene9822 [Halteria grandinella] | diamond | 1551 | 63.5 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella |
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);;