contig_metadata
18 rows where bioproject = "PRJNA335774", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2941521 | 2941521 | PRJNA335774_P_NODE_623_length_1329_cov_4.363854_g577_i0 | PRJNA335774 | 623 | 1329 | 4.363854 | 57.99561966 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.038 | NTclustered | gi|829186935|ref|XM_001022570.3| | 312017 | g577 | i0 | 100 | 0.0218209179834462 | 29 | 0 | 2 | 0 | 1246 | 1274 | 1636 | 1608 | Tetrahymena thermophila SB210 Serine/Threonine kinase domain protein partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 19516467 | 19516467 | PRJNA335774_P_NODE_39816_length_250_cov_0.870056_g39664_i0 | PRJNA335774 | 39816 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 144 | 4.18e-40 | NR | OMJ75230.1 | 5963 | g39664 | i0 | 78 | 102.336 | 82 | 18 | 98.4 | 0 | 3 | 248 | 20 | 101 | OMJ75230.1 hypothetical protein SteCoe_25669 [Stentor coeruleus] | diamond | 25584 | 144 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 27043062 | 27043062 | PRJNA335774_P_NODE_8342_length_496_cov_0.903073_g8190_i0 | PRJNA335774 | 8342 | 496 | 0.903073 | 4.47924208 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 80.1 | 3.94e-14 | NR | CDW83009.1 | 5949 | g8190 | i0 | 33.6 | 0.828629032258065 | 137 | 85 | 80.4 | 4 | 22 | 420 | 204 | 338 | CDW83009.1 fbox domain containing protein [Stylonychia lemnae] | diamond | 411 | 80.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 27154715 | 27154715 | PRJNA335774_P_NODE_5642_length_586_cov_1.329435_g5493_i0 | PRJNA335774 | 5642 | 586 | 1.329435 | 7.7904891 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 0.0041 | NR | OMJ67872.1 | 5963 | g5493 | i0 | 25.7 | 5.20136518771331 | 183 | 105 | 82.9 | 7 | 564 | 79 | 213 | 385 | OMJ67872.1 hypothetical protein SteCoe_34848 [Stentor coeruleus] | diamond | 3048 | 49.7 | 0.991951710261569 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 27390892 | 27390892 | PRJNA335774_P_NODE_30983_length_283_cov_1.276190_g30831_i0 | PRJNA335774 | 30983 | 283 | 1.27619 | 3.6116177 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 51.6 | 1.57e-5 | NR | CAG9330569.1 | 1481888 | g30831 | i0 | 63.3 | 0.318021201413428 | 30 | 11 | 31.8 | 0 | 65 | 154 | 4 | 33 | CAG9330569.1 unnamed protein product [Blepharisma stoltei] | diamond | 90 | 51.6 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 29207900 | 29207900 | PRJNA335774_P_NODE_44669_length_245_cov_0.895349_g44517_i0 | PRJNA335774 | 44669 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 76.6 | 1.4e-14 | NR | CDW86686.1 | 5949 | g44517 | i0 | 50.6 | 1.82448979591837 | 79 | 38 | 95.5 | 1 | 245 | 12 | 115 | 193 | CDW86686.1 dephospho-kinase domain-containing [Stylonychia lemnae] | diamond | 447 | 76.6 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 29348418 | 29348418 | PRJNA335774_P_NODE_42709_length_247_cov_0.885057_g42557_i0 | PRJNA335774 | 42709 | 247 | 0.885057 | 2.18609079 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 95.9 | 1.9900000000000003e-21 | NR | CAI2375377.1 | 5936 | g42557 | i0 | 63.5 | 0.898785425101215 | 74 | 27 | 89.9 | 0 | 224 | 3 | 106 | 179 | CAI2375377.1 unnamed protein product [Moneuplotes crassus] | diamond | 222 | 95.9 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 29442804 | 29442804 | PRJNA335774_P_NODE_48450_length_241_cov_0.916667_g48298_i0 | PRJNA335774 | 48450 | 241 | 0.916667 | 2.20916747 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 6.78e-10 | NR | CDW87295.1 | 5949 | g48298 | i0 | 38.3 | 5.850622406639 | 81 | 48 | 98.3 | 1 | 5 | 241 | 745 | 825 | CDW87295.1 nucleolar rna helicase 2 [Stylonychia lemnae] | diamond | 1410 | 64.7 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 30074462 | 30074462 | PRJNA335774_P_NODE_32032_length_279_cov_1.014563_g31880_i0 | PRJNA335774 | 32032 | 279 | 1.014563 | 2.83063077 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 5.74e-10 | NR | CAI2382727.1 | 5936 | g31880 | i0 | 46.3 | 2.81720430107527 | 54 | 29 | 58.1 | 0 | 3 | 164 | 36 | 89 | CAI2382727.1 unnamed protein product [Moneuplotes crassus] | diamond | 786 | 65.5 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 30485449 | 30485449 | PRJNA335774_P_NODE_46873_length_242_cov_1.366864_g46721_i0 | PRJNA335774 | 46873 | 242 | 1.366864 | 3.30781088 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 73.2 | 4.46e-14 | NR | KRW98677.1 | 266149 | g46721 | i0 | 41.8 | 0.979338842975207 | 79 | 42 | 93 | 1 | 242 | 18 | 73 | 151 | KRW98677.1 Endonuclease/exonuclease/phosphatase [Pseudocohnilembus persalinus] | diamond | 237 | 73.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 30927879 | 30927879 | PRJNA335774_P_NODE_40134_length_250_cov_0.870056_g39982_i0 | PRJNA335774 | 40134 | 250 | 0.870056 | 2.17514 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 6.89e-4 | NR | KAL4468966.1 | 5901 | g39982 | i0 | 32.5 | 1.86 | 77 | 47 | 91.2 | 2 | 241 | 14 | 278 | 350 | KAL4468966.1 hypothetical protein ABPG73_019734 [Tetrahymena malaccensis] | diamond | 465 | 47.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 30991014 | 30991014 | PRJNA335774_P_NODE_14434_length_392_cov_1.097179_g14282_i0 | PRJNA335774 | 14434 | 392 | 1.097179 | 4.30094168 | Tetrahymena malaccensis | 5901 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 1.98e-11 | NR | KAL4462567.1 | 5901 | g14282 | i0 | 39.3 | 7.36224489795918 | 89 | 50 | 65.8 | 2 | 67 | 324 | 122 | 209 | KAL4462567.1 hypothetical protein ABPG74_000397 [Tetrahymena malaccensis] | diamond | 2886 | 70.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 31798478 | 31798478 | PRJNA335774_P_NODE_13457_length_404_cov_1.135952_g13305_i0 | PRJNA335774 | 13457 | 404 | 1.135952 | 4.58924608 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 85.9 | 6.63e-17 | NR | OMJ92638.1 | 5963 | g13305 | i0 | 35 | 1.7970297029703 | 120 | 78 | 89.1 | 0 | 362 | 3 | 6 | 125 | OMJ92638.1 hypothetical protein SteCoe_4509 [Stentor coeruleus] | diamond | 726 | 85.9 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 31971192 | 31971192 | PRJNA335774_P_NODE_34198_length_270_cov_0.888325_g34046_i0 | PRJNA335774 | 34198 | 270 | 0.888325 | 2.3984775 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 2.82e-8 | NR | TNV84984.1 | 5974 | g34046 | i0 | 37.6 | 2.97777777777778 | 93 | 46 | 96.7 | 3 | 270 | 10 | 104 | 190 | TNV84984.1 hypothetical protein FGO68_gene2013 [Halteria grandinella] | diamond | 804 | 60.5 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 32097698 | 32097698 | PRJNA335774_P_NODE_11518_length_432_cov_1.047354_g11366_i0 | PRJNA335774 | 11518 | 432 | 1.047354 | 4.52456928 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 64.7 | 6.46e-9 | NR | CAG9333893.1 | 1481888 | g11366 | i0 | 39.1 | 0.604166666666667 | 87 | 53 | 60.4 | 0 | 264 | 4 | 718 | 804 | CAG9333893.1 unnamed protein product [Blepharisma stoltei] | diamond | 261 | 64.7 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 32368460 | 32368460 | PRJNA335774_P_NODE_2139_length_864_cov_3.194690_g2022_i0 | PRJNA335774 | 2139 | 864 | 3.19469 | 27.6021216 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 2.12e-9 | NR | KAL4454048.1 | 5901 | g2022 | i0 | 26.6 | 4.59722222222222 | 301 | 172 | 92.4 | 14 | 806 | 9 | 2157 | 2443 | KAL4454048.1 hypothetical protein ABPG73_009847 [Tetrahymena malaccensis] | diamond | 3972 | 70.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 32621003 | 32621003 | PRJNA335774_P_NODE_32240_length_278_cov_0.995122_g32088_i0 | PRJNA335774 | 32240 | 278 | 0.995122 | 2.76643916 | root | 1 | Root_unresolved | Root_unresolved | 62.4 | 6.5e-9 | NR | CAG9318571.1 | 1481888 | g32088 | i0 | 50 | 2.75179856115108 | 62 | 24 | 59.4 | 2 | 166 | 2 | 146 | 207 | CAG9318571.1 unnamed protein product [Blepharisma stoltei] | diamond | 765 | 62.4 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 32824272 | 32824272 | PRJNA335774_P_NODE_10380_length_452_cov_1.126649_g10228_i0 | PRJNA335774 | 10380 | 452 | 1.126649 | 5.09245348 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 9.07e-49 | NR | CDW90419.1 | 5949 | g10228 | i0 | 53 | 0.988938053097345 | 149 | 64 | 98.9 | 1 | 450 | 4 | 212 | 354 | CDW90419.1 calpain family cysteine protease containing protein [Stylonychia lemnae] | diamond | 447 | 178 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae |
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);;