contig_metadata
17 rows where bioproject = "PRJNA951810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27310292 | 27310292 | PRJNA951810_P_NODE_108403_length_288_cov_1.767442_g108059_i0 | PRJNA951810 | 108403 | 288 | 1.767442 | 5.09023296 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.047 | NR | XP_001022425.2 | 312017 | g108059 | i0 | 38.9 | 0.5625 | 54 | 33 | 56.3 | 0 | 52 | 213 | 283 | 336 | XP_001022425.2 cytoplasmic dynein intermediate chain [Tetrahymena thermophila SB210] | diamond | 162 | 43.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 27846840 | 27846840 | PRJNA951810_P_NODE_179624_length_232_cov_6.597484_g179279_i0 | PRJNA951810 | 179624 | 232 | 6.597484 | 15.30616288 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 3.63e-21 | NR | CAG9313846.1 | 1481888 | g179279 | i0 | 63.6 | 0.853448275862069 | 66 | 24 | 85.3 | 0 | 199 | 2 | 50 | 115 | CAG9313846.1 unnamed protein product [Blepharisma stoltei] | diamond | 198 | 90.1 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 29046851 | 29046851 | PRJNA951810_P_NODE_116888_length_282_cov_3.354067_g116544_i0 | PRJNA951810 | 116888 | 282 | 3.354067 | 9.45846894 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 94.7 | 3.12e-20 | NR | CDW76534.1 | 5949 | g116544 | i0 | 53.8 | 0.98936170212766 | 93 | 43 | 98.9 | 0 | 3 | 281 | 91 | 183 | CDW76534.1 UNKNOWN [Stylonychia lemnae] | diamond | 279 | 94.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 29614903 | 29614903 | PRJNA951810_P_NODE_81130_length_299_cov_3.699115_g80786_i0 | PRJNA951810 | 81130 | 299 | 3.699115 | 11.06035385 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 2.11e-5 | NR | OMJ71013.1 | 5963 | g80786 | i0 | 48.6 | 1.00334448160535 | 72 | 34 | 69.2 | 2 | 209 | 3 | 379 | 450 | OMJ71013.1 hypothetical protein SteCoe_30885 [Stentor coeruleus] | diamond | 300 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 29899454 | 29899454 | PRJNA951810_P_NODE_162551_length_248_cov_2.394286_g162206_i0 | PRJNA951810 | 162551 | 248 | 2.394286 | 5.93782928 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 1.71e-5 | NR | CAG9321912.1 | 1481888 | g162206 | i0 | 44.4 | 0.544354838709677 | 45 | 25 | 54.4 | 0 | 233 | 99 | 59 | 103 | CAG9321912.1 unnamed protein product [Blepharisma stoltei] | diamond | 135 | 51.2 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 29994179 | 29994179 | PRJNA951810_P_NODE_123031_length_278_cov_2.229268_g122686_i0 | PRJNA951810 | 123031 | 278 | 2.229268 | 6.19736504 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 1.07e-8 | NR | CAI2374946.1 | 5936 | g122686 | i0 | 43.1 | 0.776978417266187 | 72 | 40 | 76.6 | 1 | 45 | 257 | 191 | 262 | CAI2374946.1 unnamed protein product [Moneuplotes crassus] | diamond | 216 | 61.6 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 30057133 | 30057133 | PRJNA951810_P_NODE_172011_length_241_cov_0.916667_g171666_i0 | PRJNA951810 | 172011 | 241 | 0.916667 | 2.20916747 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 8.51e-9 | NR | CAG9324051.1 | 1481888 | g171666 | i0 | 64.6 | 1.15767634854772 | 48 | 16 | 59.8 | 1 | 3 | 146 | 41 | 87 | CAG9324051.1 unnamed protein product [Blepharisma stoltei] | diamond | 279 | 59.3 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 30348685 | 30348685 | PRJNA951810_P_NODE_58632_length_310_cov_3.793249_g58289_i0 | PRJNA951810 | 58632 | 310 | 3.793249 | 11.7590719 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.0173 | NR | OMJ68086.1 | 5963 | g58289 | i0 | 52.1 | 2.8741935483871 | 48 | 20 | 46.5 | 2 | 7 | 150 | 175 | 219 | OMJ68086.1 hypothetical protein SteCoe_34570 [Stentor coeruleus] | diamond | 891 | 44.7 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 30405281 | 30405281 | PRJNA951810_P_NODE_24593_length_405_cov_5.846386_g24253_i0 | PRJNA951810 | 24593 | 405 | 5.846386 | 23.6778633 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 1.02e-7 | NR | XP_001030543.2 | 312017 | g24253 | i0 | 61.7 | 0.348148148148148 | 47 | 18 | 34.8 | 0 | 9 | 149 | 253 | 299 | XP_001030543.2 male gamete fusion factor [Tetrahymena thermophila SB210] | diamond | 141 | 60.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30499600 | 30499600 | PRJNA951810_P_NODE_116933_length_282_cov_3.172249_g116589_i0 | PRJNA951810 | 116933 | 282 | 3.172249 | 8.94574218 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 74.7 | 5.65e-14 | NR | CDW87435.1 | 5949 | g116589 | i0 | 42.6 | 1.98936170212766 | 94 | 50 | 96.8 | 2 | 281 | 9 | 27 | 119 | CDW87435.1 60s ribosomal protein l10a-1 [Stylonychia lemnae] | diamond | 561 | 74.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30878652 | 30878652 | PRJNA951810_P_NODE_111254_length_286_cov_2.328638_g110910_i0 | PRJNA951810 | 111254 | 286 | 2.328638 | 6.65990468 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 3.89e-6 | NR | CAI2378409.1 | 5936 | g110910 | i0 | 30.9 | 0.986013986013986 | 94 | 65 | 98.6 | 0 | 285 | 4 | 223 | 316 | CAI2378409.1 unnamed protein product [Moneuplotes crassus] | diamond | 282 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 30885254 | 30885254 | PRJNA951810_P_NODE_57694_length_310_cov_3.945148_g57351_i0 | PRJNA951810 | 57694 | 310 | 3.945148 | 12.2299588 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 1.09e-11 | NR | OMJ93114.1 | 5963 | g57351 | i0 | 69.4 | 7.3258064516129 | 49 | 15 | 47.4 | 0 | 162 | 308 | 162 | 210 | OMJ93114.1 hypothetical protein SteCoe_3928 [Stentor coeruleus] | diamond | 2271 | 71.2 | 0.995786516853933 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 31511127 | 31511127 | PRJNA951810_P_NODE_124296_length_277_cov_2.901961_g123951_i0 | PRJNA951810 | 124296 | 277 | 2.901961 | 8.03843197 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.0156 | NR | CDW89469.1 | 5949 | g123951 | i0 | 60 | 0.324909747292419 | 30 | 12 | 32.5 | 0 | 91 | 2 | 369 | 398 | CDW89469.1 UNKNOWN [Stylonychia lemnae] | diamond | 90 | 44.3 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 31612428 | 31612428 | PRJNA951810_P_NODE_93836_length_296_cov_3.367713_g93492_i0 | PRJNA951810 | 93836 | 296 | 3.367713 | 9.96843048 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 55.5 | 2.36e-6 | NR | CDW76854.1 | 5949 | g93492 | i0 | 71 | 5.39189189189189 | 31 | 9 | 31.4 | 0 | 93 | 1 | 219 | 249 | CDW76854.1 protein kinase domain protein [Stylonychia lemnae] | diamond | 1596 | 55.8 | 0.99462365591397806 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 31732382 | 31732382 | PRJNA951810_P_NODE_94797_length_295_cov_6.959459_g94453_i0 | PRJNA951810 | 94797 | 295 | 6.959459 | 20.53040405 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 2.88e-5 | NR | XP_001443708.1 | 5888 | g94453 | i0 | 33 | 1.13898305084746 | 112 | 36 | 74.2 | 1 | 259 | 41 | 319 | 430 | XP_001443708.1 uncharacterized protein GSPATT00011884001 [Paramecium tetraurelia] | diamond | 336 | 52.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 31732383 | 31732383 | PRJNA951810_P_NODE_95117_length_295_cov_5.576577_g94773_i0 | PRJNA951810 | 95117 | 295 | 5.576577 | 16.45090215 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 75.9 | 2.05e-15 | NR | CAD8161800.1 | 43137 | g94773 | i0 | 41.4 | 0.884745762711864 | 87 | 51 | 88.5 | 0 | 295 | 35 | 18 | 104 | CAD8161800.1 unnamed protein product [Paramecium octaurelia] | diamond | 261 | 75.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 32555313 | 32555313 | PRJNA951810_P_NODE_146319_length_261_cov_2.069149_g145974_i0 | PRJNA951810 | 146319 | 261 | 2.069149 | 5.40047889 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 1.9099999999999998e-23 | NR | TNV82769.1 | 5974 | g145974 | i0 | 59.3 | 0.988505747126437 | 86 | 35 | 98.9 | 0 | 260 | 3 | 105 | 190 | TNV82769.1 hypothetical protein FGO68_gene8373 [Halteria grandinella] | diamond | 258 | 101 | 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);;