contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA278119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1058882 | 1058882 | PRJNA278119_P_NODE_34641_length_169_cov_1.300000_g34392_i0 | PRJNA278119 | 34641 | 169 | 1.3 | 2.197 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.53e-78 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g34392 | i0 | 100 | 26.1656804733728 | 164 | 0 | 97 | 0 | 6 | 169 | 1397 | 1234 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 4422 | 303 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 1646139 | 1646139 | PRJNA278119_P_NODE_3562_length_642_cov_2.500843_g3326_i0 | PRJNA278119 | 3562 | 642 | 2.500843 | 16.05541206 | Tetrahymena chironomi | 3034767 | SAR_Eukaryotes | SAR_Eukaryotes | 1116 | 0 | NTclustered | gi|2459327221|gb|OQ626840.1| | 3034767 | g3326 | i0 | 97.981 | 70.2632398753894 | 644 | 11 | 100 | 2 | 1 | 642 | 1075 | 432 | Tetrahymena chironomi isolate LLH20220320 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 45109 | 1116 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena chironomi | ||
| 6748796 | 6748796 | PRJNA278119_P_NODE_18706_length_235_cov_0.817204_g18457_i0 | PRJNA278119 | 18706 | 235 | 0.817204 | 1.9204294 | Epidinium ecaudatum | 300017 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 5.46e-53 | NTclustered | gi|92790181|emb|AJ965276.1| | 300017 | g18457 | i0 | 85.99 | 123.034042553191 | 207 | 27 | 90 | 2 | 21 | 226 | 906 | 1111 | Epidinium ecaudatum partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene) | blastn | 28913 | 220 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Epidinium | Epidinium ecaudatum | ||
| 7436616 | 7436616 | PRJNA278119_P_NODE_10566_length_358_cov_1.996764_g10319_i0 | PRJNA278119 | 10566 | 358 | 1.996764 | 7.14841512 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.4599999999999995e-55 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g10319 | i0 | 97.059 | 1.13966480446927 | 136 | 4 | 38 | 0 | 1 | 136 | 2947 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 408 | 230 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 10575143 | 10575143 | PRJNA278119_P_NODE_2089_length_848_cov_2.147685_g1884_i0 | PRJNA278119 | 2089 | 848 | 2.147685 | 18.2123688 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 1434 | 0 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g1884 | i0 | 97.17 | 57.8396226415094 | 848 | 24 | 100 | 0 | 1 | 848 | 2363 | 1516 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 49048 | 1434 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 11849970 | 11849970 | PRJNA278119_P_NODE_3550_length_643_cov_6.244108_g3314_i0 | PRJNA278119 | 3550 | 643 | 6.244108 | 40.14961444 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 1062 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3314 | i0 | 96.568 | 63.0419906687403 | 641 | 22 | 99 | 0 | 2 | 642 | 650 | 10 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 40536 | 1062 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 11849984 | 11849984 | PRJNA278119_P_NODE_36270_length_168_cov_1.310924_g36021_i0 | PRJNA278119 | 36270 | 168 | 1.310924 | 2.20235232 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.34e-37 | NTclustered | gi|829197694|ref|XM_001029851.3| | 312017 | g36021 | i0 | 85.119 | 1 | 168 | 21 | 99 | 2 | 3 | 168 | 572 | 407 | Tetrahymena thermophila SB210 papain family cysteine protease partial mRNA | blastn | 168 | 169 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 12537354 | 12537354 | PRJNA278119_P_NODE_32910_length_173_cov_1.258065_g32661_i0 | PRJNA278119 | 32910 | 173 | 1.258065 | 2.17645245 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 3.71e-63 | NTclustered | gi|161734|gb|L01415.1|TETBTUBUA | 5911 | g32661 | i0 | 93.064 | 93.4913294797688 | 173 | 12 | 100 | 0 | 1 | 173 | 674 | 502 | Tetrahymena thermophila beta-tubulin (BTU1) gene, complete cds | blastn | 16174 | 254 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 13812166 | 13812166 | PRJNA278119_P_NODE_25451_length_196_cov_1.061224_g25202_i0 | PRJNA278119 | 25451 | 196 | 1.061224 | 2.07999904 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 2.64e-50 | NTclustered | gi|12744902|gb|AF331706.1|AF331706 | 5911 | g25202 | i0 | 86.154 | 1.98979591836735 | 195 | 27 | 99 | 0 | 2 | 196 | 1704 | 1898 | Tetrahymena thermophila Ndc1 protein (NDC1) gene, complete cds | blastn | 390 | 211 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 13812312 | 13812312 | PRJNA278119_P_NODE_7711_length_428_cov_2.781003_g7464_i0 | PRJNA278119 | 7711 | 428 | 2.781003 | 11.90269284 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 673 | 0 | NTclustered | gi|148362050|gb|EF428128.1| | 5912 | g7464 | i0 | 94.631 | 105.198598130841 | 447 | 2 | 100 | 8 | 1 | 428 | 732 | 289 | Tetrahymena tropicalis strain Lahorensis 18S ribosomal RNA gene, partial sequence | blastn | 45025 | 678 | 0.992625368731563 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena tropicalis | ||
| 15673737 | 15673737 | PRJNA278119_P_NODE_13473_length_304_cov_1.862745_g13225_i0 | PRJNA278119 | 13473 | 304 | 1.862745 | 5.6627448 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 470 | 6.6e-128 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g13225 | i0 | 94.062 | 53.9835526315789 | 320 | 2 | 99 | 1 | 1 | 303 | 2976 | 3295 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 16411 | 470 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 18910150 | 18910150 | PRJNA278119_P_NODE_19135_length_230_cov_1.784530_g18886_i0 | PRJNA278119 | 19135 | 230 | 1.78453 | 4.104419 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 1.7699999999999994e-107 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g18886 | i0 | 98.253 | 72.0304347826087 | 229 | 4 | 99 | 0 | 1 | 229 | 2425 | 2653 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 16567 | 401 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 19497267 | 19497267 | PRJNA278119_P_NODE_32096_length_175_cov_1.238095_g31847_i0 | PRJNA278119 | 32096 | 175 | 1.238095 | 2.16666625 | Tetrahymena rostrata | 5909 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 6.44e-46 | NTclustered | gi|1780512736|gb|MN025427.1| | 5909 | g31847 | i0 | 86.932 | 3.16571428571429 | 176 | 21 | 100 | 2 | 1 | 175 | 6707 | 6881 | Tetrahymena rostrata isolate TRAUS mitochondrion, complete genome | blastn | 554 | 196 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 21460502 | 21460502 | PRJNA278119_P_NODE_22157_length_210_cov_1.652174_g21908_i0 | PRJNA278119 | 22157 | 210 | 1.652174 | 3.4695654 | root | 1 | Root_unresolved | Root_unresolved | 364 | 2.0799999999999992e-96 | NTclustered | gi|345541658|gb|JN547815.1| | 5911 | g21908 | i0 | 98.086 | 8.37619047619048 | 209 | 4 | 99 | 0 | 2 | 210 | 3673 | 3465 | Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 1759 | 364 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 23323568 | 23323568 | PRJNA278119_P_NODE_5599_length_503_cov_2.222467_g5354_i0 | PRJNA278119 | 5599 | 503 | 2.222467 | 11.17900901 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 464 | 5.3299999999999997e-126 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g5354 | i0 | 99.222 | 50.9960238568588 | 257 | 2 | 93 | 0 | 247 | 503 | 1733 | 1477 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 25651 | 464 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 24010832 | 24010832 | PRJNA278119_P_NODE_47819_length_160_cov_2.342342_g47570_i0 | PRJNA278119 | 47819 | 160 | 2.342342 | 3.7477472 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 5.55e-76 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g47570 | i0 | 100 | 96.15625 | 160 | 0 | 100 | 0 | 1 | 160 | 978 | 1137 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 15385 | 296 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 24597337 | 24597337 | PRJNA278119_P_NODE_25900_length_194_cov_1.365517_g25651_i0 | PRJNA278119 | 25900 | 194 | 1.365517 | 2.64910298 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 9.39e-50 | NTclustered | gi|33327401|gb|AF527986.1| | 151077 | g25651 | i0 | 96.8 | 80.6649484536082 | 125 | 4 | 64 | 0 | 1 | 125 | 26 | 150 | Chilodonella uncinata clone 6 histone H4 (H4) gene, partial cds | blastn | 15649 | 209 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata |
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);;