contig_metadata
14 rows where bioproject = "PRJNA977246", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2226159 | 2226159 | PRJNA977246_S_NODE_11902_length_436_cov_4752.034398_g10940_i0 | PRJNA977246 | 11902 | 436 | 4752.034398 | 20718.86997528 | Lamtostyla gui | 2678605 | SAR_Eukaryotes | SAR_Eukaryotes | 383 | 1.3099999999999995e-101 | NTclustered | gi|1778223994|gb|MN733822.1| | 2678605 | g10940 | i0 | 91.489 | 35.5389908256881 | 282 | 19 | 64 | 4 | 159 | 436 | 4112 | 4392 | Lamtostyla gui isolate LWY2015111409 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15495 | 383 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Stichotrichida | Amphisiellidae | Lamtostyla | Lamtostyla gui | ||
| 6054722 | 6054722 | PRJNA977246_S_NODE_34365_length_204_cov_3.308571_g33373_i0 | PRJNA977246 | 34365 | 204 | 3.308571 | 6.74948484 | uncultured Hypotrichia | 305490 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 5.72e-82 | NTclustered | gi|1859609753|gb|MT641063.1| | 305490 | g33373 | i0 | 94.608 | 55.3235294117647 | 204 | 11 | 100 | 0 | 1 | 204 | 223 | 426 | Uncultured Hypotrichia clone OTU84.7 large subunit ribosomal RNA gene, partial sequence | blastn | 11286 | 316 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | uncultured Hypotrichia | |||||
| 7329151 | 7329151 | PRJNA977246_S_NODE_33166_length_209_cov_10397.600000_g32174_i0 | PRJNA977246 | 33166 | 209 | 10397.6 | 21730.984 | Isotricha prostoma | 5987 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.36e-33 | NTclustered | gi|2643596954|gb|PP067626.1| | 5987 | g32174 | i0 | 91.228 | 54.1722488038277 | 114 | 10 | 55 | 0 | 1 | 114 | 3844 | 3731 | Isotricha prostoma isolate 03.MDA03 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 11322 | 156 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Isotricha | Isotricha prostoma | ||
| 7646729 | 7646729 | PRJNA977246_S_NODE_12206_length_430_cov_28.800499_g11241_i0 | PRJNA977246 | 12206 | 430 | 28.800499 | 123.8421457 | Spirotrichea | 33829 | SAR_Eukaryotes | SAR_Eukaryotes | 686 | 0 | NTclustered | gi|220966760|gb|FJ545743.1| | 94289 | g11241 | i0 | 95.571 | 85.8325581395349 | 429 | 17 | 99 | 2 | 3 | 430 | 5947 | 5520 | Sterkiella histriomuscorum 17S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; macronuclear | blastn | 36908 | 691 | 0.992764109985528 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 8604003 | 8604003 | PRJNA977246_S_NODE_21627_length_292_cov_6.482890_g20635_i0 | PRJNA977246 | 21627 | 292 | 6.48289 | 18.9300388 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g20635 | i0 | 96.97 | 0.212328767123288 | 33 | 1 | 11 | 0 | 260 | 292 | 41 | 9 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 62 | 56.5 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 9879898 | 9879898 | PRJNA977246_S_NODE_6528_length_624_cov_15.421849_g5760_i0 | PRJNA977246 | 6528 | 624 | 15.421849 | 96.23233776 | Lamtostyla gui | 2678605 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 9.06e-95 | NTclustered | gi|1778223994|gb|MN733822.1| | 2678605 | g5760 | i0 | 85.593 | 22.3333333333333 | 354 | 39 | 56 | 8 | 276 | 624 | 4046 | 4392 | Lamtostyla gui isolate LWY2015111409 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 13936 | 361 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Stichotrichida | Amphisiellidae | Lamtostyla | Lamtostyla gui | ||
| 10197664 | 10197664 | PRJNA977246_S_NODE_42468_length_173_cov_4.180556_g41476_i0 | PRJNA977246 | 42468 | 173 | 4.180556 | 7.23236188 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 76.8 | 8.62e-10 | NTclustered | gi|118500778|gb|EF094960.1| | 36767 | g41476 | i0 | 100 | 23.6011560693642 | 41 | 0 | 24 | 0 | 45 | 85 | 118 | 158 | Euplotes focardii strain 95 small subunit ribosomal RNA gene, partial sequence | blastn | 4083 | 76.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes focardii | ||
| 12431119 | 12431119 | PRJNA977246_S_NODE_8470_length_535_cov_6.156126_g7609_i0 | PRJNA977246 | 8470 | 535 | 6.156126 | 32.9352741 | Trachelocercidae sp. 3 BS-2022 | 2930473 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.004 | NTclustered | gi|2261268975|emb|OX095823.1| | 2930473 | g7609 | i0 | 100 | 0.0560747663551402 | 30 | 0 | 6 | 0 | 1 | 30 | 9 | 38 | Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) | blastn | 30 | 56.5 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Trachelocercidae | Trachelocercidae sp. 3 BS-2022 | |||
| 12748206 | 12748206 | PRJNA977246_S_NODE_43750_length_169_cov_7.078571_g42758_i0 | PRJNA977246 | 43750 | 169 | 7.078571 | 11.96278499 | Amphisiellidae | 99916 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 5.95e-71 | NTclustered | gi|751363249|gb|KP266659.1| | 1071703 | g42758 | i0 | 98.726 | 92.6390532544379 | 157 | 2 | 93 | 0 | 13 | 169 | 1293 | 1449 | Parabistichella variabilis isolate B102 28S ribosomal RNA gene, partial sequence | blastn | 15656 | 279 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Parabistichella | Parabistichella variabilis | ||||
| 13704984 | 13704984 | PRJNA977246_S_NODE_32791_length_211_cov_927.445055_g31799_i0 | PRJNA977246 | 32791 | 211 | 927.445055 | 1956.90906605 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.001 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g31799 | i0 | 100 | 0.672985781990521 | 30 | 0 | 14 | 0 | 9 | 38 | 10 | 39 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 142 | 56.5 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 15296715 | 15296715 | PRJNA977246_S_NODE_20352_length_305_cov_6.539855_g19360_i0 | PRJNA977246 | 20352 | 305 | 6.539855 | 19.94655775 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 3.959999999999999e-130 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g19360 | i0 | 95.05 | 75.1770491803279 | 303 | 15 | 99 | 0 | 1 | 303 | 2660 | 2962 | Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 22929 | 477 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 15296983 | 15296983 | PRJNA977246_S_NODE_48652_length_157_cov_2.242188_g47660_i0 | PRJNA977246 | 48652 | 157 | 2.242188 | 3.52023516 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 2.52e-74 | NTclustered | gi|1802599796|gb|MT001205.1| | 41631 | g47660 | i0 | 100 | 100.859872611465 | 157 | 0 | 100 | 0 | 1 | 157 | 232 | 76 | Colpoda sp. strain HFCC864 small subunit ribosomal RNA gene, partial sequence | blastn | 15835 | 291 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 22628372 | 22628372 | PRJNA977246_S_NODE_29258_length_231_cov_3.490099_g28266_i0 | PRJNA977246 | 29258 | 231 | 3.490099 | 8.06212869 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.006 | NTclustered | gi|471219142|ref|XM_004024053.1| | 5932 | g28266 | i0 | 96.875 | 0.138528138528139 | 32 | 1 | 14 | 0 | 88 | 119 | 594 | 625 | Ichthyophthirius multifiliis protein kinase domain protein (IMG5_200040) mRNA, complete cds | blastn | 32 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 24220601 | 24220601 | PRJNA977246_S_NODE_35499_length_199_cov_3.000000_g34507_i0 | PRJNA977246 | 35499 | 199 | 3 | 5.97 | Sessilida | 1974272 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 3.2899999999999996e-89 | NTclustered | gi|1251948965|gb|KY675198.1| | 2042498 | g34507 | i0 | 97.487 | 93.3768844221105 | 199 | 5 | 100 | 0 | 1 | 199 | 80 | 278 | Epistylis sp. 1 JI2016080701 large subunit ribosomal RNA gene, partial sequence | blastn | 18582 | 340 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Epistylidae | Epistylis | Epistylis sp. 1 JI2016080701 |
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);;