contig_metadata
25 rows where bioproject = "PRJNA699078", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3233021 | 3233021 | PRJNA699078_S_NODE_31083_length_309_cov_2.826923_g30134_i0 | PRJNA699078 | 31083 | 309 | 2.826923 | 8.73519207 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 5.939999999999999e-34 | NTclustered | gi|471218831|ref|XM_004023902.1| | 5932 | g30134 | i0 | 80.465 | 1.042071197411 | 215 | 34 | 68 | 8 | 72 | 282 | 230 | 20 | Ichthyophthirius multifiliis hypothetical protein (IMG5_202480) mRNA, complete cds | blastn | 322 | 158 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 3233068 | 3233068 | PRJNA699078_S_NODE_34243_length_296_cov_0.886640_g33294_i0 | PRJNA699078 | 34243 | 296 | 0.88664 | 2.6244544 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g33294 | i0 | 100 | 0.192567567567568 | 29 | 0 | 10 | 0 | 1 | 29 | 9 | 37 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 8335524 | 8335524 | PRJNA699078_S_NODE_49607_length_243_cov_1.587629_g48658_i0 | PRJNA699078 | 49607 | 243 | 1.587629 | 3.85793847 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g48658 | i0 | 100 | 0.234567901234568 | 29 | 0 | 12 | 0 | 1 | 29 | 9 | 37 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 9610601 | 9610601 | PRJNA699078_S_NODE_36708_length_286_cov_0.877637_g35759_i0 | PRJNA699078 | 36708 | 286 | 0.877637 | 2.51004182 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g35759 | i0 | 100 | 0.199300699300699 | 29 | 0 | 10 | 0 | 1 | 29 | 9 | 37 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 57 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 9611456 | 9611456 | PRJNA699078_S_NODE_91348_length_175_cov_1.126984_g90399_i0 | PRJNA699078 | 91348 | 175 | 1.126984 | 1.972222 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 61.2 | 4.49e-9 | NR | CAI2358852.1 | 5936 | g90399 | i0 | 76.3 | 1.01142857142857 | 59 | 3 | 99.4 | 2 | 1 | 174 | 651 | 699 | CAI2358852.1 unnamed protein product [Moneuplotes crassus] | diamond | 177 | 61.2 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 12160973 | 12160973 | PRJNA699078_S_NODE_12930_length_438_cov_4.452442_g12001_i0 | PRJNA699078 | 12930 | 438 | 4.452442 | 19.50169596 | Boveria subcylindrica | 693871 | SAR_Eukaryotes | SAR_Eukaryotes | 359 | 2.23e-94 | NTclustered | gi|759083259|gb|KM221954.1| | 693871 | g12001 | i0 | 83.333 | 53.8013698630137 | 390 | 63 | 89 | 2 | 37 | 425 | 437 | 49 | Boveria subcylindrica voucher FXP2009030301 alpha-tubulin gene, partial cds | blastn | 23565 | 359 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Thigmotrichida | Hemispeiridae | Boveria | Boveria subcylindrica | ||
| 12162159 | 12162159 | PRJNA699078_S_NODE_94230_length_172_cov_1.186992_g93281_i0 | PRJNA699078 | 94230 | 172 | 1.186992 | 2.04162624 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 90.9 | 8.76e-20 | NR | OMJ95975.1 | 5963 | g93281 | i0 | 71.4 | 9.34883720930233 | 56 | 16 | 97.7 | 0 | 171 | 4 | 260 | 315 | OMJ95975.1 hypothetical protein SteCoe_534 [Stentor coeruleus] | diamond | 1608 | 90.9 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 13435813 | 13435813 | PRJNA699078_S_NODE_29231_length_318_cov_3.579926_g28282_i0 | PRJNA699078 | 29231 | 318 | 3.579926 | 11.38416468 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 6.380000000000001e-27 | NR | XP_001443967.1 | 5888 | g28282 | i0 | 50 | 4.80188679245283 | 104 | 52 | 98.1 | 0 | 313 | 2 | 79 | 182 | XP_001443967.1 uncharacterized protein GSPATT00012122001 [Paramecium tetraurelia] | diamond | 1527 | 107 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 23635406 | 23635406 | PRJNA699078_S_NODE_57879_length_223_cov_1.833333_g56930_i0 | PRJNA699078 | 57879 | 223 | 1.833333 | 4.08833259 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g56930 | i0 | 100 | 0.130044843049327 | 29 | 0 | 13 | 0 | 1 | 29 | 11 | 39 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 26670902 | 26670902 | PRJNA699078_S_NODE_23281_length_352_cov_2.059406_g22332_i0 | PRJNA699078 | 23281 | 352 | 2.059406 | 7.24910912 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 53.1 | 2.81e-5 | NR | OMJ85159.1 | 5963 | g22332 | i0 | 39.3 | 0.715909090909091 | 84 | 41 | 63.1 | 4 | 47 | 268 | 258 | 341 | OMJ85159.1 hypothetical protein SteCoe_13549 [Stentor coeruleus] | diamond | 252 | 53.1 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 27030668 | 27030668 | PRJNA699078_S_NODE_46782_length_251_cov_1.287129_g45833_i0 | PRJNA699078 | 46782 | 251 | 1.287129 | 3.23069379 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 7.17e-34 | NR | OMJ76211.1 | 5963 | g45833 | i0 | 71.1 | 14.808764940239 | 83 | 24 | 99.2 | 0 | 251 | 3 | 31 | 113 | OMJ76211.1 hypothetical protein SteCoe_24467 [Stentor coeruleus] | diamond | 3717 | 130 | 0.992307692307692 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 27367497 | 27367497 | PRJNA699078_S_NODE_38123_length_280_cov_1.926407_g37174_i0 | PRJNA699078 | 38123 | 280 | 1.926407 | 5.3939396 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 1.7e-10 | NR | CDW78064.1 | 5949 | g37174 | i0 | 40 | 4.46785714285714 | 75 | 45 | 80.4 | 0 | 8 | 232 | 491 | 565 | CDW78064.1 glutamyl-trna synthetase [Stylonychia lemnae] | diamond | 1251 | 67 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 27883515 | 27883515 | PRJNA699078_S_NODE_25265_length_340_cov_1.072165_g24316_i0 | PRJNA699078 | 25265 | 340 | 1.072165 | 3.645361 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 53.9 | 1.21e-5 | NR | KAL4456914.1 | 5901 | g24316 | i0 | 28.6 | 4.69411764705882 | 98 | 66 | 82.9 | 1 | 339 | 58 | 37 | 134 | KAL4456914.1 hypothetical protein ABPG74_014552 [Tetrahymena malaccensis] | diamond | 1596 | 54.3 | 0.992633517495396 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 28219469 | 28219469 | PRJNA699078_S_NODE_38846_length_277_cov_3.214912_g37897_i0 | PRJNA699078 | 38846 | 277 | 3.214912 | 8.90530624 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 50.4 | 1.08e-4 | NR | OMJ75279.1 | 5963 | g37897 | i0 | 37.1 | 0.75812274368231 | 70 | 44 | 75.8 | 0 | 7 | 216 | 461 | 530 | OMJ75279.1 hypothetical protein SteCoe_25593 [Stentor coeruleus] | diamond | 210 | 50.4 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 28452099 | 28452099 | PRJNA699078_S_NODE_54446_length_231_cov_1.428571_g53497_i0 | PRJNA699078 | 54446 | 231 | 1.428571 | 3.29999901 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 90.1 | 6.66e-19 | NR | CDW78400.1 | 5949 | g53497 | i0 | 58.7 | 18.4545454545455 | 75 | 25 | 97.4 | 2 | 6 | 230 | 976 | 1044 | CDW78400.1 dna-directed rna polymerase ii subunit rpb2-like [Stylonychia lemnae] | diamond | 4263 | 90.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 28736131 | 28736131 | PRJNA699078_S_NODE_106947_length_163_cov_0.859649_g105998_i0 | PRJNA699078 | 106947 | 163 | 0.859649 | 1.40122787 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 1.65e-14 | NR | CAD8095649.1 | 65129 | g105998 | i0 | 64.8 | 63.6073619631902 | 54 | 19 | 99.4 | 0 | 1 | 162 | 300 | 353 | CAD8095649.1 unnamed protein product [Paramecium sonneborni] | diamond | 10368 | 77 | 0.990909090909091 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni | ||
| 29640209 | 29640209 | PRJNA699078_S_NODE_43950_length_260_cov_1.251185_g43001_i0 | PRJNA699078 | 43950 | 260 | 1.251185 | 3.253081 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 50.1 | 1.2e-4 | NR | CAI2359381.1 | 5936 | g43001 | i0 | 36.3 | 0.923076923076923 | 80 | 51 | 92.3 | 0 | 17 | 256 | 416 | 495 | CAI2359381.1 unnamed protein product [Moneuplotes crassus] | diamond | 240 | 50.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 30240748 | 30240748 | PRJNA699078_S_NODE_7592_length_528_cov_14.939457_g6719_i0 | PRJNA699078 | 7592 | 528 | 14.939457 | 78.88033296 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 4.74e-53 | NR | CAI2385291.1 | 5936 | g6719 | i0 | 58.1 | 1.76136363636364 | 160 | 67 | 90.9 | 0 | 1 | 480 | 110 | 269 | CAI2385291.1 unnamed protein product [Moneuplotes crassus] | diamond | 930 | 189 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 30556453 | 30556453 | PRJNA699078_S_NODE_101533_length_166_cov_1.307692_g100584_i0 | PRJNA699078 | 101533 | 166 | 1.307692 | 2.17076872 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 85.1 | 1.55e-17 | NR | CAI2383536.1 | 5936 | g100584 | i0 | 93.2 | 0.795180722891566 | 44 | 3 | 79.5 | 0 | 166 | 35 | 714 | 757 | CAI2383536.1 unnamed protein product [Moneuplotes crassus] | diamond | 132 | 85.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 30588114 | 30588114 | PRJNA699078_S_NODE_71933_length_199_cov_0.880000_g70984_i0 | PRJNA699078 | 71933 | 199 | 0.88 | 1.7512 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00316 | NR | CAI2364564.1 | 5936 | g70984 | i0 | 100 | 0.301507537688442 | 20 | 0 | 30.2 | 0 | 197 | 138 | 3 | 22 | CAI2364564.1 unnamed protein product [Moneuplotes crassus] | diamond | 60 | 45.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 31789262 | 31789262 | PRJNA699078_S_NODE_107917_length_162_cov_1.168142_g106968_i0 | PRJNA699078 | 107917 | 162 | 1.168142 | 1.89239004 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 7.13e-20 | NR | CAI2385550.1 | 5936 | g106968 | i0 | 100 | 0.759259259259259 | 41 | 0 | 75.9 | 0 | 125 | 3 | 34 | 74 | CAI2385550.1 unnamed protein product [Moneuplotes crassus] | diamond | 123 | 91.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 32011005 | 32011005 | PRJNA699078_S_NODE_62618_length_214_cov_1.066667_g61669_i0 | PRJNA699078 | 62618 | 214 | 1.066667 | 2.28266738 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 136 | 1.94e-35 | NR | CAI2358746.1 | 5936 | g61669 | i0 | 100 | 0.981308411214953 | 70 | 0 | 98.1 | 0 | 212 | 3 | 7 | 76 | CAI2358746.1 unnamed protein product [Moneuplotes crassus] | diamond | 210 | 136 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 32327778 | 32327778 | PRJNA699078_S_NODE_69279_length_203_cov_0.857143_g68330_i0 | PRJNA699078 | 69279 | 203 | 0.857143 | 1.74000029 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 2.72e-33 | NR | CAI2361783.1 | 5936 | g68330 | i0 | 97 | 0.990147783251232 | 67 | 2 | 99 | 0 | 1 | 201 | 4 | 70 | CAI2361783.1 unnamed protein product [Moneuplotes crassus] | diamond | 201 | 129 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 32560362 | 32560362 | PRJNA699078_S_NODE_37599_length_282_cov_2.304721_g36650_i0 | PRJNA699078 | 37599 | 282 | 2.304721 | 6.49931322 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 7.08e-32 | NR | CAI2379855.1 | 5936 | g36650 | i0 | 70.5 | 65.5531914893617 | 78 | 23 | 83 | 0 | 1 | 234 | 76 | 153 | CAI2379855.1 unnamed protein product [Moneuplotes crassus] | diamond | 18486 | 119 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 32895161 | 32895161 | PRJNA699078_S_NODE_73420_length_196_cov_3.000000_g72471_i0 | PRJNA699078 | 73420 | 196 | 3 | 5.88 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 1.5e-5 | NR | AAP88262.1 | 5908 | g72471 | i0 | 46.2 | 3.97959183673469 | 65 | 24 | 99.5 | 2 | 195 | 1 | 477 | 530 | AAP88262.1 CCT delta subunit [Tetrahymena pyriformis] | diamond | 780 | 51.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis |
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);;