contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1158727" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 304150 | 304150 | PRJNA1158727_P_NODE_150661_length_245_cov_1.726744_g143199_i0 | PRJNA1158727 | 150661 | 245 | 1.726744 | 4.2305228 | Opercularia sp. ZhW-2019a | 2582953 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 5.45e-88 | NTclustered | gi|2304601486|gb|OP458307.1| | 2582953 | g143199 | i0 | 91.463 | 61.269387755102 | 246 | 19 | 100 | 2 | 1 | 245 | 404 | 648 | Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence | blastn | 15011 | 337 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Operculariidae | Opercularia | Opercularia sp. ZhW-2019a | ||
| 4131267 | 4131267 | PRJNA1158727_P_NODE_161684_length_241_cov_1.833333_g154222_i0 | PRJNA1158727 | 161684 | 241 | 1.833333 | 4.41833253 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.91e-92 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g154222 | i0 | 92.946 | 48.4896265560166 | 241 | 17 | 100 | 0 | 1 | 241 | 2080 | 1840 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 11686 | 351 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 6681132 | 6681132 | PRJNA1158727_P_NODE_109146_length_280_cov_2.260870_g101685_i0 | PRJNA1158727 | 109146 | 280 | 2.26087 | 6.330436 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 8.769999999999996e-42 | NTclustered | gi|829188477|ref|XM_001023087.3| | 312017 | g101685 | i0 | 82.192 | 18.4607142857143 | 219 | 33 | 77 | 6 | 45 | 260 | 1050 | 835 | Tetrahymena thermophila SB210 S-adenosyl-L-homocysteine hydrolase partial mRNA | blastn | 5169 | 183 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 10507950 | 10507950 | PRJNA1158727_P_NODE_152389_length_245_cov_0.895349_g144927_i0 | PRJNA1158727 | 152389 | 245 | 0.895349 | 2.19360505 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 453 | 5.1900000000000006e-123 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g144927 | i0 | 100 | 53.2816326530612 | 245 | 0 | 100 | 0 | 1 | 245 | 3257 | 3013 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 13054 | 453 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 11782240 | 11782240 | PRJNA1158727_P_NODE_122330_length_264_cov_3.099476_g114869_i0 | PRJNA1158727 | 122330 | 264 | 3.099476 | 8.1826166400000009 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 1.5499999999999999e-133 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g114869 | i0 | 100 | 98.3825757575758 | 264 | 0 | 100 | 0 | 1 | 264 | 2332 | 2069 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 25973 | 488 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 12516171 | 12516171 | PRJNA1158727_P_NODE_123650_length_263_cov_1.610526_g116189_i0 | PRJNA1158727 | 123650 | 263 | 1.610526 | 4.23568338 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 6.22e-53 | NTclustered | gi|10792|emb|X12768.1| | 5908 | g116189 | i0 | 85.714 | 75.2965779467681 | 210 | 29 | 80 | 1 | 8 | 217 | 334 | 126 | Tetrahymena pyriformis beta-tubulin gene 1 (beta-TT1) | blastn | 19803 | 222 | 0.990990990990991 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 20164184 | 20164184 | PRJNA1158727_P_NODE_87036_length_320_cov_2.360324_g79575_i0 | PRJNA1158727 | 87036 | 320 | 2.360324 | 7.5530368 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 580 | 3.099999999999999e-161 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g79575 | i0 | 99.375 | 15.7 | 320 | 2 | 100 | 0 | 1 | 320 | 1549 | 1868 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 5024 | 580 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 20164201 | 20164201 | PRJNA1158727_P_NODE_93236_length_306_cov_2.948498_g85775_i0 | PRJNA1158727 | 93236 | 306 | 2.948498 | 9.02240388 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 566 | 8.239999999999998e-157 | NTclustered | gi|10853|emb|X56168.1| | 5912 | g85775 | i0 | 100 | 100 | 306 | 0 | 100 | 0 | 1 | 306 | 605 | 910 | T.tropicalis gene for small subunit ribosomal RNA (16S like rRNA) | blastn | 30600 | 566 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena tropicalis | ||
| 20704984 | 20704984 | PRJNA1158727_P_NODE_125077_length_261_cov_2.414894_g117616_i0 | PRJNA1158727 | 125077 | 261 | 2.414894 | 6.30287334 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.0499999999999999e-40 | NTclustered | gi|829100487|ref|XM_001007447.3| | 312017 | g117616 | i0 | 79.31 | 4.90421455938697 | 261 | 50 | 99 | 4 | 3 | 261 | 580 | 838 | Tetrahymena thermophila SB210 transitional endoplasmic reticulum ATPase, putative partial mRNA | blastn | 1280 | 180 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 23256320 | 23256320 | PRJNA1158727_P_NODE_146959_length_247_cov_0.885057_g139497_i0 | PRJNA1158727 | 146959 | 247 | 0.885057 | 2.18609079 | Metopus es | 392813 | SAR_Eukaryotes | SAR_Eukaryotes | 346 | 9.14e-91 | NTclustered | gi|110645073|gb|DQ665935.1| | 392813 | g139497 | i0 | 92.245 | 98.6761133603239 | 245 | 18 | 99 | 1 | 4 | 247 | 561 | 317 | Metopus es clone 1 actin gene, partial cds; macronuclear | blastn | 24373 | 346 | 1 | Eukaryota | Sar | Ciliophora | Armophorea | Metopida | Metopidae | Metopus | Metopus es | ||
| 24529314 | 24529314 | PRJNA1158727_P_NODE_111980_length_277_cov_1.313725_g104519_i0 | PRJNA1158727 | 111980 | 277 | 1.313725 | 3.63901825 | Philasterides dicentrarchi | 282688 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 5.14e-49 | NTclustered | gi|49616744|gb|AY643504.1| | 282688 | g104519 | i0 | 85.222 | 45.3718411552347 | 203 | 29 | 73 | 1 | 2 | 203 | 269 | 67 | Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence | blastn | 12568 | 207 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Philasteridae | Philasterides | Philasterides dicentrarchi | ||
| 25263669 | 25263669 | PRJNA1158727_P_NODE_102040_length_289_cov_2.384259_g94579_i0 | PRJNA1158727 | 102040 | 289 | 2.384259 | 6.89050851 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 446 | 1.05e-120 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g94579 | i0 | 94.483 | 79.8269896193772 | 290 | 14 | 100 | 2 | 1 | 289 | 177 | 465 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 23070 | 446 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola |
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);;