RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA309466", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 16 ✖

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJNA309466 · 16 ✖

tax_kingdom 0

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
1651511 1651511 PRJNA309466_P_NODE_10102_length_199_cov_1.213333_g10045_i0 PRJNA309466 10102 199 1.213333 2.41453267 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 278 2.62e-70   NTclustered gi|2651357788|gb|PP174303.1| 41631 g10045 i0 93.158 91.1809045226131 190 12 95 1 2 191 3548 3736 Colpoda sp. isolate CIL1 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 18145 278 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
2338201 2338201 PRJNA309466_P_NODE_12582_length_183_cov_1.641791_g12525_i0 PRJNA309466 12582 183 1.641791 3.00447753 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 103 5.899999999999999e-26   NR CDW85556.1 5949 g12525 i0 76.3 29.7540983606557 59 14 96.7 0 3 179 9 67 CDW85556.1 arf family gtpase [Stylonychia lemnae] diamond 5445 103 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
2927418 2927418 PRJNA309466_P_NODE_10523_length_196_cov_1.414966_g10466_i0 PRJNA309466 10523 196 1.414966 2.77333336 Trithigmostoma cucullulus 1346499 SAR_Eukaryotes SAR_Eukaryotes 257 3.3500000000000004e-64   NTclustered gi|759083539|gb|KM222156.1| 1346499 g10466 i0 90.722 7.02551020408163 194 17 98 1 2 194 1553 1746 Trithigmostoma cucullulus voucher CXM08110902 large subunit ribosomal RNA gene, partial sequence blastn 1377 257 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Trithigmostoma Trithigmostoma cucullulus
2927422 2927422 PRJNA309466_P_NODE_10723_length_194_cov_12.048276_g10666_i0 PRJNA309466 10723 194 12.048276 23.37365544 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 270 4.2499999999999985e-68   NTclustered gi|2651357788|gb|PP174303.1| 41631 g10666 i0 92.632 85.4072164948454 190 11 97 2 2 189 3548 3360 Colpoda sp. isolate CIL1 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 16569 270 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
2927540 2927540 PRJNA309466_P_NODE_5883_length_241_cov_3.250000_g5826_i0 PRJNA309466 5883 241 3.25 7.8325 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 248 2.58e-61   NTclustered gi|2651357791|gb|PP174306.1| 41631 g5826 i0 99.27 47.9211618257261 137 1 99 0 2 138 3067 3203 Colpoda sp. isolate JGP15 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 11549 248 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
7441105 7441105 PRJNA309466_P_NODE_5666_length_245_cov_15.464286_g5609_i0 PRJNA309466 5666 245 15.464286 37.8875007 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 59.3 5.38e-8   NR CDW89887.1 5949 g5609 i0 46.3 0.979591836734694 80 36 93.1 2 244 17 311 387 CDW89887.1 UNKNOWN [Stylonychia lemnae] diamond 240 59.3 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
13130541 13130541 PRJNA309466_P_NODE_11351_length_190_cov_2.078014_g11294_i0 PRJNA309466 11351 190 2.078014 3.9482266 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 324 3.13e-84   NTclustered gi|1241841574|gb|KY273139.1| 5908 g11294 i0 97.368 22.0157894736842 190 5 100 0 1 190 196 7 Tetrahymena pyriformis isolate 1098-1 large subunit ribosomal RNA gene, partial sequence; macronuclear blastn 4183 324 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
13816643 13816643 PRJNA309466_P_NODE_9851_length_200_cov_30.549669_g9794_i0 PRJNA309466 9851 200 30.549669 61.099338 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 167 5.95e-37   NTclustered gi|1004125725|gb|KU761582.1| 153251 g9794 i0 85.185 84.05 162 24 81 0 2 163 6985 7146 Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence blastn 16810 167 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
14405746 14405746 PRJNA309466_P_NODE_14492_length_173_cov_3.322581_g14435_i0 PRJNA309466 14492 173 3.322581 5.74806513 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 189 1.06e-43   NTclustered gi|47176275|gb|AY617855.1| 94289 g14435 i0 86.55 0.988439306358382 171 23 99 0 3 173 364 194 Sterkiella histriomuscorum clone UGC1O0005_P18_F genomic sequence blastn 171 189 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
15679589 15679589 PRJNA309466_P_NODE_18533_length_160_cov_2.693694_g18476_i0 PRJNA309466 18533 160 2.693694 4.3099104 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 231 1.5899999999999998e-56   NTclustered gi|2651357788|gb|PP174303.1| 41631 g18476 i0 93.082 91.075 159 9 99 2 2 159 3356 3513 Colpoda sp. isolate CIL1 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 14572 231 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
16365503 16365503 PRJNA309466_P_NODE_16013_length_167_cov_7.872881_g15956_i0 PRJNA309466 16013 167 7.872881 13.14771127 Colpoda 5979 SAR_Eukaryotes SAR_Eukaryotes 300 4.53e-77   NTclustered gi|1802599794|gb|MT001203.1| 41631 g15956 i0 100 97.2155688622754 162 0 97 0 6 167 696 857 Colpoda sp. strain HFCC848 small subunit ribosomal RNA gene, partial sequence blastn 16235 300 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
16954146 16954146 PRJNA309466_P_NODE_14934_length_171_cov_2.540984_g14877_i0 PRJNA309466 14934 171 2.540984 4.34508264 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 305 9.96e-79   NTclustered gi|10782|emb|X54004.1| 5908 g14877 i0 98.83 93.5029239766082 171 2 100 0 1 171 1886 1716 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 15989 305 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
16954200 16954200 PRJNA309466_P_NODE_2074_length_474_cov_183560.150588_g2019_i0 PRJNA309466 2074 474 183560.150588 870075.11378712 Tetrahymena sp. KGE15 1200497 SAR_Eukaryotes SAR_Eukaryotes 754 0   NTclustered gi|523704203|emb|HE861887.1| 1200497 g2019 i0 99.048 66.9430379746835 420 4 89 0 55 474 504 85 Tetrahymena sp. KGE15 partial 28S rRNA gene, strain KGE15 blastn 31731 754 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena sp. KGE15
17640598 17640598 PRJNA309466_P_NODE_13454_length_178_cov_8.209302_g13397_i0 PRJNA309466 13454 178 8.209302 14.61255756 root 1 Root_unresolved Root_unresolved 322 1.04e-83   NTclustered gi|1837628855|gb|MN158348.1| 5909 g13397 i0 99.435 100.168539325843 177 1 99 0 2 178 5181 5357 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 17830 322 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
28716530 28716530 PRJNA309466_P_NODE_18227_length_162_cov_0.920354_g18170_i0 PRJNA309466 18227 162 0.920354 1.49097348 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 100 9.85e-25   NR CDW90439.1 5949 g18170 i0 86.5 0.962962962962963 52 7 96.3 0 158 3 23 74 CDW90439.1 UNKNOWN [Stylonychia lemnae] diamond 156 100 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32224064 32224064 PRJNA309466_P_NODE_19378_length_154_cov_7.523810_g19321_i0 PRJNA309466 19378 154 7.52381 11.5866674 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 66.6 3.48e-12   NR CDW82153.1 5949 g19321 i0 80.5 0.798701298701299 41 8 79.9 0 25 147 2 42 CDW82153.1 40s ribosomal protein s16-like [Stylonychia lemnae] diamond 123 66.6 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;