contig_metadata
20 rows where bioproject = "PRJNA758087", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 733470 | 733470 | PRJNA758087_P_NODE_32601_length_370_cov_2.047138_g31281_i0 | PRJNA758087 | 32601 | 370 | 2.047138 | 7.5744106 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.01 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g31281 | i0 | 100 | 0.381081081081081 | 29 | 0 | 8 | 0 | 1 | 29 | 10 | 38 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 141 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 2008997 | 2008997 | PRJNA758087_P_NODE_12102_length_895_cov_26.131387_g10954_i0 | PRJNA758087 | 12102 | 895 | 26.131387 | 233.87591365 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.025 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g10954 | i0 | 100 | 0.0324022346368715 | 29 | 0 | 3 | 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 | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 3284757 | 3284757 | PRJNA758087_P_NODE_29123_length_426_cov_3.464589_g27803_i0 | PRJNA758087 | 29123 | 426 | 3.464589 | 14.75914914 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.011 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g27803 | i0 | 100 | 0.330985915492958 | 29 | 0 | 7 | 0 | 1 | 29 | 10 | 38 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 141 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 3285024 | 3285024 | PRJNA758087_P_NODE_39923_length_273_cov_2.310000_g38603_i0 | PRJNA758087 | 39923 | 273 | 2.31 | 6.3063 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g38603 | i0 | 100 | 0.208791208791209 | 29 | 0 | 11 | 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 | |||
| 4561987 | 4561987 | PRJNA758087_P_NODE_32724_length_368_cov_2.254237_g31404_i0 | PRJNA758087 | 32724 | 368 | 2.254237 | 8.29559216 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 525 | 1.7099999999999993e-144 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g31404 | i0 | 94.203 | 40.2173913043478 | 345 | 18 | 93 | 2 | 1 | 344 | 344 | 1 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 14800 | 525 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 4562059 | 4562059 | PRJNA758087_P_NODE_35664_length_327_cov_2.102362_g34344_i0 | PRJNA758087 | 35664 | 327 | 2.102362 | 6.87472374 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.009 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g34344 | i0 | 100 | 0.174311926605505 | 29 | 0 | 9 | 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 | |||
| 4562119 | 4562119 | PRJNA758087_P_NODE_37884_length_298_cov_1.368889_g36564_i0 | PRJNA758087 | 37884 | 298 | 1.368889 | 4.07928922 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g36564 | i0 | 100 | 0.191275167785235 | 29 | 0 | 10 | 0 | 270 | 298 | 37 | 9 | 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 | |||
| 5836881 | 5836881 | PRJNA758087_P_NODE_24745_length_507_cov_22.815668_g23425_i0 | PRJNA758087 | 24745 | 507 | 22.815668 | 115.67543676 | Remanella sp. 1 BS-2022 | 2930476 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.004 | NTclustered | gi|2261269021|emb|OX095846.1| | 2930476 | g23425 | i0 | 100 | 0.226824457593688 | 30 | 0 | 6 | 0 | 1 | 30 | 12 | 41 | Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) | blastn | 115 | 56.5 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Loxodida | Loxodidae | Remanella | Remanella sp. 1 BS-2022 | ||
| 7112392 | 7112392 | PRJNA758087_P_NODE_36506_length_315_cov_6.537190_g35186_i0 | PRJNA758087 | 36506 | 315 | 6.53719 | 20.5921485 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 6.34e-4 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g35186 | i0 | 100 | 0.453968253968254 | 31 | 0 | 10 | 0 | 285 | 315 | 40 | 10 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 143 | 58.4 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 10937535 | 10937535 | PRJNA758087_P_NODE_29649_length_417_cov_2.133721_g28329_i0 | PRJNA758087 | 29649 | 417 | 2.133721 | 8.89761657 | Paramecium primaurelia | 5886 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 1.28e-32 | NR | CAD8050985.1 | 5886 | g28329 | i0 | 53.4 | 1.82014388489209 | 133 | 52 | 89.2 | 5 | 386 | 15 | 1 | 132 | CAD8050985.1 unnamed protein product [Paramecium primaurelia] | diamond | 759 | 129 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 10937657 | 10937657 | PRJNA758087_P_NODE_34189_length_347_cov_6.021898_g32869_i0 | PRJNA758087 | 34189 | 347 | 6.021898 | 20.89598606 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 549 | 9.559999999999996e-152 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g32869 | i0 | 97.799 | 91.5504322766571 | 318 | 7 | 92 | 0 | 1 | 318 | 1304 | 987 | Vorticella sp. 4 JG-2011 clone 2 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 | 31768 | 549 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 13487043 | 13487043 | PRJNA758087_P_NODE_21531_length_577_cov_4.198413_g20218_i0 | PRJNA758087 | 21531 | 577 | 4.198413 | 24.22484301 | Remanella sp. 1 BS-2022 | 2930476 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.004 | NTclustered | gi|2261269021|emb|OX095846.1| | 2930476 | g20218 | i0 | 100 | 0.0519930675909879 | 30 | 0 | 5 | 0 | 548 | 577 | 42 | 13 | Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Loxodida | Loxodidae | Remanella | Remanella sp. 1 BS-2022 | ||
| 14762091 | 14762091 | PRJNA758087_P_NODE_17652_length_679_cov_45.711221_g16373_i0 | PRJNA758087 | 17652 | 679 | 45.711221 | 310.37919059 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.019 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g16373 | i0 | 100 | 0.0427098674521355 | 29 | 0 | 4 | 0 | 651 | 679 | 37 | 9 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 16036378 | 16036378 | PRJNA758087_P_NODE_40993_length_259_cov_2.166667_g39673_i0 | PRJNA758087 | 40993 | 259 | 2.166667 | 5.61166753 | Remanella sp. 1 BS-2022 | 2930476 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|2261269021|emb|OX095846.1| | 2930476 | g39673 | i0 | 100 | 0.444015444015444 | 30 | 0 | 12 | 0 | 230 | 259 | 41 | 12 | Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) | blastn | 115 | 56.5 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Loxodida | Loxodidae | Remanella | Remanella sp. 1 BS-2022 | ||
| 19860332 | 19860332 | PRJNA758087_P_NODE_24856_length_505_cov_32.384259_g23536_i0 | PRJNA758087 | 24856 | 505 | 32.384259 | 163.54050795 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 2.28e-5 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g23536 | i0 | 97.368 | 0.2 | 38 | 0 | 8 | 1 | 468 | 505 | 41 | 5 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 101 | 63.9 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 22411154 | 22411154 | PRJNA758087_P_NODE_43218_length_243_cov_2.911765_g41898_i0 | PRJNA758087 | 43218 | 243 | 2.911765 | 7.07558895 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.31e-4 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g41898 | i0 | 100 | 0.131687242798354 | 32 | 0 | 13 | 0 | 212 | 243 | 41 | 10 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 32 | 60.2 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 24959802 | 24959802 | PRJNA758087_P_NODE_21280_length_583_cov_4.917647_g19968_i0 | PRJNA758087 | 21280 | 583 | 4.917647 | 28.66988201 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.001 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g19968 | i0 | 97.143 | 0.0600343053173242 | 35 | 0 | 6 | 1 | 1 | 35 | 4 | 37 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 35 | 58.4 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 24960317 | 24960317 | PRJNA758087_P_NODE_42420_length_247_cov_1.770115_g41100_i0 | PRJNA758087 | 42420 | 247 | 1.770115 | 4.37218405 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g41100 | i0 | 100 | 0.57085020242915 | 29 | 0 | 12 | 0 | 1 | 29 | 10 | 38 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 141 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 27621785 | 27621785 | PRJNA758087_P_NODE_10664_length_977_cov_6.725664_g9576_i0 | PRJNA758087 | 10664 | 977 | 6.725664 | 65.70973728 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.859999999999999e-31 | NR | XP_012656464.1 | 312017 | g9576 | i0 | 30.9 | 0.844421699078813 | 275 | 179 | 83.5 | 6 | 916 | 101 | 1 | 267 | XP_012656464.1 golgi-to-ER traffic-like protein, putative [Tetrahymena thermophila SB210] | diamond | 825 | 128 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29673654 | 29673654 | PRJNA758087_P_NODE_21590_length_575_cov_11.563745_g20276_i0 | PRJNA758087 | 21590 | 575 | 11.563745 | 66.49153375 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 3.08e-14 | NR | XP_004039736.1 | 5932 | g20276 | i0 | 29.9 | 1.22086956521739 | 117 | 82 | 61 | 0 | 490 | 140 | 4 | 120 | XP_004039736.1 hypothetical protein IMG5_011820 [Ichthyophthirius multifiliis] | diamond | 702 | 80.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis |
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);;