contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA395690" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 411513 | 411513 | PRJNA395690_P_NODE_16981_length_197_cov_1.331081_g16829_i0 | PRJNA395690 | 16981 | 197 | 1.331081 | 2.62222957 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 9.039999999999999e-90 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g16829 | i0 | 97.97 | 48.4111675126904 | 197 | 4 | 100 | 0 | 1 | 197 | 565 | 761 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 9537 | 342 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 411559 | 411559 | PRJNA395690_P_NODE_2121_length_534_cov_2.441237_g1974_i0 | PRJNA395690 | 2121 | 534 | 2.441237 | 13.03620558 | Paramecium gigas | 2709424 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 1.82e-26 | NTclustered | gi|2120474459|ref|NC_058286.1| | 2709424 | g1974 | i0 | 92.473 | 32.4719101123596 | 93 | 7 | 17 | 0 | 207 | 299 | 1941 | 1849 | Paramecium gigas mitochondrion, complete genome | blastn | 17340 | 134 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium gigas | ||
| 5515193 | 5515193 | PRJNA395690_P_NODE_12405_length_231_cov_2.241758_g12253_i0 | PRJNA395690 | 12405 | 231 | 2.241758 | 5.17846098 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.6e-21 | NTclustered | gi|829192014|ref|XM_012799966.1| | 312017 | g12253 | i0 | 88.421 | 1.81818181818182 | 95 | 11 | 41 | 0 | 48 | 142 | 125 | 219 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 420 | 115 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 13832588 | 13832588 | PRJNA395690_P_NODE_7131_length_302_cov_31.268775_g6979_i0 | PRJNA395690 | 7131 | 302 | 31.268775 | 94.4317005 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 558 | 1.36e-154 | NTclustered | gi|158147318|gb|EU047813.1| | 151077 | g6979 | i0 | 100 | 58.7185430463576 | 302 | 0 | 100 | 0 | 1 | 302 | 357 | 56 | Chilodonella uncinata strain ATCC 50194 5.8S ribosomal RNA gene and internal transcribed spacer 2, partial sequence; macronuclear | blastn | 17733 | 558 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 13832591 | 13832591 | PRJNA395690_P_NODE_7611_length_292_cov_17.827160_g7459_i0 | PRJNA395690 | 7611 | 292 | 17.82716 | 52.0553072 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 538 | 1.6999999999999994e-148 | NTclustered | gi|530758434|gb|KF524393.1| | 60850 | g7459 | i0 | 100 | 97.791095890411 | 291 | 0 | 99 | 0 | 2 | 292 | 586 | 296 | Vorticella convallaria isolate Gzpop 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 28555 | 538 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria | ||
| 14440370 | 14440370 | PRJNA395690_P_NODE_15912_length_204_cov_0.987097_g15760_i0 | PRJNA395690 | 15912 | 204 | 0.987097 | 2.01367788 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 2.27e-11 | NTclustered | gi|829188944|ref|XM_001031587.2| | 312017 | g15760 | i0 | 80.952 | 0.514705882352941 | 105 | 18 | 51 | 2 | 8 | 111 | 179 | 76 | Tetrahymena thermophila SB210 60S ribosomal L7Ae-like protein partial mRNA | blastn | 105 | 82.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 14440600 | 14440600 | PRJNA395690_P_NODE_30872_length_165_cov_0.879310_g30720_i0 | PRJNA395690 | 30872 | 165 | 0.87931 | 1.4508615 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 4.619999999999999e-52 | NTclustered | gi|3550265|gb|AF079840.1|AF079840 | 5963 | g30720 | i0 | 90.361 | 1.00606060606061 | 166 | 14 | 100 | 2 | 1 | 165 | 237 | 73 | Stentor coeruleus G protein alpha GS-like subunit mRNA, partial cds | blastn | 166 | 217 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 14440759 | 14440759 | PRJNA395690_P_NODE_8092_length_284_cov_1.519149_g7940_i0 | PRJNA395690 | 8092 | 284 | 1.519149 | 4.31438316 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 436 | 6.2e-118 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g7940 | i0 | 94.366 | 1 | 284 | 16 | 100 | 0 | 1 | 284 | 410 | 693 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 284 | 436 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15106818 | 15106818 | PRJNA395690_P_NODE_6052_length_326_cov_4.653430_g5902_i0 | PRJNA395690 | 6052 | 326 | 4.65343 | 15.1701818 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 2.2399999999999992e-43 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5902 | i0 | 96.491 | 1.04907975460123 | 114 | 4 | 35 | 0 | 213 | 326 | 3082 | 2969 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 342 | 189 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 16989265 | 16989265 | PRJNA395690_P_NODE_5174_length_350_cov_1.355482_g5025_i0 | PRJNA395690 | 5174 | 350 | 1.355482 | 4.744187 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 625 | 1.5499999999999995e-174 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g5025 | i0 | 98.86 | 51.6942857142857 | 351 | 3 | 100 | 1 | 1 | 350 | 93 | 443 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 18093 | 625 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 17656640 | 17656640 | PRJNA395690_P_NODE_28974_length_167_cov_0.864407_g28822_i0 | PRJNA395690 | 28974 | 167 | 0.864407 | 1.44355969 | Vorticella | 60849 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 7.53e-80 | NTclustered | gi|363412153|gb|JN120227.1| | 60850 | g28822 | i0 | 100 | 100.011976047904 | 167 | 0 | 100 | 0 | 1 | 167 | 57 | 223 | Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence | blastn | 16702 | 309 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria | ||
| 18263122 | 18263122 | PRJNA395690_P_NODE_12775_length_228_cov_1.139665_g12623_i0 | PRJNA395690 | 12775 | 228 | 1.139665 | 2.5984362 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.9499999999999998e-32 | NTclustered | gi|1004125725|gb|KU761582.1| | 153251 | g12623 | i0 | 89.344 | 3.79385964912281 | 122 | 12 | 53 | 1 | 2 | 122 | 179 | 58 | Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence | blastn | 865 | 152 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 18263470 | 18263470 | PRJNA395690_P_NODE_495_length_1093_cov_1.757663_g414_i0 | PRJNA395690 | 495 | 1093 | 1.757663 | 19.21125659 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1709 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g414 | i0 | 96.777 | 28.4107959743824 | 1024 | 33 | 94 | 0 | 1 | 1024 | 182 | 1205 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 31053 | 1709 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 20205183 | 20205183 | PRJNA395690_P_NODE_25536_length_173_cov_1.645161_g25384_i0 | PRJNA395690 | 25536 | 173 | 1.645161 | 2.84612853 | Tetrahymenidae | 291294 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.015 | NTclustered | gi|296207|emb|X71349.1| | 5911 | g25384 | i0 | 100 | 0.664739884393064 | 28 | 0 | 16 | 0 | 27 | 54 | 62 | 89 | T.thermophila organelle RNA for U3 snRNA | blastn | 115 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 22088006 | 22088006 | PRJNA395690_P_NODE_15258_length_208_cov_1.283019_g15106_i0 | PRJNA395690 | 15258 | 208 | 1.283019 | 2.66867952 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 5.77e-92 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g15106 | i0 | 97.101 | 7.47596153846154 | 207 | 6 | 99 | 0 | 2 | 208 | 250 | 44 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 1555 | 350 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24030658 | 24030658 | PRJNA395690_P_NODE_14279_length_215_cov_1.602410_g14127_i0 | PRJNA395690 | 14279 | 215 | 1.60241 | 3.4451815 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 4.609999999999999e-98 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g14127 | i0 | 97.674 | 78.8837209302326 | 215 | 5 | 100 | 0 | 1 | 215 | 422 | 208 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 16960 | 370 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 24638245 | 24638245 | PRJNA395690_P_NODE_8960_length_272_cov_1.596413_g8808_i0 | PRJNA395690 | 8960 | 272 | 1.596413 | 4.34224336 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 405 | 1.66e-108 | NTclustered | gi|347439270|gb|JN111983.1| | 151077 | g8808 | i0 | 93.727 | 34.9852941176471 | 271 | 16 | 99 | 1 | 1 | 270 | 632 | 902 | Chilodonella uncinata strain USA_SC2 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 9516 | 405 | 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);;