RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA1111082", 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 · 18 ✖

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA1111082 · 18 ✖

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
7868022 7868022 PRJNA1111082_P_NODE_12847_length_236_cov_2.355828_g12802_i0 PRJNA1111082 12847 236 2.355828 5.55975408 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 87.9 5.8e-13   NTclustered gi|145515744|ref|XM_001443735.1| 5888 g12802 i0 100 0.199152542372881 47 0 20 0 161 207 674 628 Paramecium tetraurelia uncharacterized protein (GSPATT00011949001), partial mRNA blastn 47 87.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
11694132 11694132 PRJNA1111082_P_NODE_9050_length_270_cov_1.761421_g9005_i0 PRJNA1111082 9050 270 1.761421 4.7558367 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 84.7 8.83e-17   NR CAI2381562.1 5936 g9005 i0 48.8 3.87777777777778 86 44 95.6 0 5 262 90 175 CAI2381562.1 unnamed protein product [Moneuplotes crassus] diamond 1047 84.7 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
14244310 14244310 PRJNA1111082_P_NODE_8192_length_283_cov_1.523810_g8147_i0 PRJNA1111082 8192 283 1.52381 4.3123823 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 523 4.5999999999999983e-144   NTclustered gi|10782|emb|X54004.1| 5908 g8147 i0 100 84.9010600706714 283 0 100 0 1 283 1924 1642 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 24027 523 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
20147632 20147632 PRJNA1111082_P_NODE_7376_length_297_cov_2.285714_g7331_i0 PRJNA1111082 7376 297 2.285714 6.78857058 root 1 Root_unresolved Root_unresolved 521 1.7499999999999996e-143   NTclustered gi|10782|emb|X54004.1| 5908 g7331 i0 98.322 61.9225589225589 298 4 100 1 1 297 2736 2439 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 18391 521 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
24441115 24441115 PRJNA1111082_P_NODE_10120_length_255_cov_2.142857_g10075_i0 PRJNA1111082 10120 255 2.142857 5.46428535 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 472 1.5e-128   NTclustered gi|11466252|ref|NC_000862.1| 5908 g10075 i0 100 19.7960784313725 255 0 100 0 1 255 2036 2290 Tetrahymena pyriformis mitochondrion, complete genome blastn 5048 472 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
27162384 27162384 PRJNA1111082_P_NODE_10422_length_253_cov_0.866667_g10377_i0 PRJNA1111082 10422 253 0.866667 2.19266751 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 48.9 2.85e-4   NR CDW86887.1 5949 g10377 i0 76.9 0.308300395256917 26 6 30.8 0 24 101 424 449 CDW86887.1 UNKNOWN [Stylonychia lemnae] diamond 78 48.9 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
27731477 27731477 PRJNA1111082_P_NODE_11044_length_250_cov_0.881356_g10999_i0 PRJNA1111082 11044 250 0.881356 2.20339 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 49.3 1.98e-4   NR CDW88287.1 5949 g10999 i0 74.1 0.324 27 7 32.4 0 183 103 364 390 CDW88287.1 major facilitator superfamily domain-containing protein 1 [Stylonychia lemnae] diamond 81 49.3 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
28772992 28772992 PRJNA1111082_P_NODE_10087_length_256_cov_1.218579_g10042_i0 PRJNA1111082 10087 256 1.218579 3.11956224 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 55.8 1.1e-6   NR CDW85435.1 5949 g10042 i0 33.3 0.984375 84 54 96.1 1 250 5 18 101 CDW85435.1 gamma-tubulin complex component 5 [Stylonychia lemnae] diamond 252 55.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
28836176 28836176 PRJNA1111082_P_NODE_12708_length_242_cov_0.905325_g12663_i0 PRJNA1111082 12708 242 0.905325 2.1908865 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 78.6 8.88e-15   NR CDW75826.1 5949 g12663 i0 41 0.966942148760331 78 46 96.7 0 234 1 71 148 CDW75826.1 UNKNOWN [Stylonychia lemnae] diamond 234 78.6 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29467404 29467404 PRJNA1111082_P_NODE_9330_length_266_cov_1.626943_g9285_i0 PRJNA1111082 9330 266 1.626943 4.32766838 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0353   NR CDW77453.1 5949 g9285 i0 86.4 0.24812030075188 22 2 24.8 1 196 131 269 289 CDW77453.1 UNKNOWN [Stylonychia lemnae] diamond 66 43.1 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30099224 30099224 PRJNA1111082_P_NODE_7752_length_290_cov_2.317972_g7707_i0 PRJNA1111082 7752 290 2.317972 6.7221188 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 119 1.13e-28   NR CDW90083.1 5949 g7707 i0 79.5 0.755172413793103 73 14 75.5 1 242 24 990 1061 CDW90083.1 lysosomal alpha-glucosidase precursor [Stylonychia lemnae] diamond 219 119 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30447091 30447091 PRJNA1111082_P_NODE_12313_length_243_cov_2.011765_g12268_i0 PRJNA1111082 12313 243 2.011765 4.88858895 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00166   NR CDW88387.1 5949 g12268 i0 87 0.283950617283951 23 3 28.4 0 111 43 1 23 CDW88387.1 UNKNOWN [Stylonychia lemnae] diamond 69 46.6 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30857576 30857576 PRJNA1111082_P_NODE_5754_length_330_cov_2.338521_g5709_i0 PRJNA1111082 5754 330 2.338521 7.7171193 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 90.1 2.64e-18   NR CDW90083.1 5949 g5709 i0 70.5 0.554545454545455 61 18 55.5 0 228 46 869 929 CDW90083.1 lysosomal alpha-glucosidase precursor [Stylonychia lemnae] diamond 183 90.1 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31047527 31047527 PRJNA1111082_P_NODE_9715_length_261_cov_1.526596_g9670_i0 PRJNA1111082 9715 261 1.526596 3.98441556 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 87 8.39e-18   NR CDW86109.1 5949 g9670 i0 87.2 0.540229885057471 47 6 54 0 261 121 140 186 CDW86109.1 UNKNOWN [Stylonychia lemnae] diamond 141 87 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31837629 31837629 PRJNA1111082_P_NODE_13057_length_227_cov_2.266234_g13012_i0 PRJNA1111082 13057 227 2.266234 5.14435118 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 78.6 7.13e-15   NR CAG9315140.1 1481888 g13012 i0 56.7 0.885462555066079 67 28 88.5 1 225 25 224 289 CAG9315140.1 unnamed protein product [Blepharisma stoltei] diamond 201 78.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
32407417 32407417 PRJNA1111082_P_NODE_8419_length_280_cov_1.492754_g8374_i0 PRJNA1111082 8419 280 1.492754 4.1797112 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 153 2.4999999999999993e-43   NR CDW71539.1 5949 g8374 i0 97.2 0.771428571428571 72 2 77.1 0 65 280 28 99 CDW71539.1 lem3 (ligand-effect modulator 3) family protein [Stylonychia lemnae] diamond 216 153 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32439243 32439243 PRJNA1111082_P_NODE_4159_length_383_cov_1.338710_g4114_i0 PRJNA1111082 4159 383 1.33871 5.1272593 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 138 5.069999999999998e-35   NR CDW84722.1 5949 g4114 i0 84.2 0.595300261096606 76 12 59.5 0 308 81 58 133 CDW84722.1 polyphosphoinositide phosphatase [Stylonychia lemnae] diamond 228 138 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32470822 32470822 PRJNA1111082_P_NODE_13039_length_228_cov_2.012903_g12994_i0 PRJNA1111082 13039 228 2.012903 4.5894188400000004 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 124 1.7599999999999998e-31   NR CAI2366548.1 5936 g12994 i0 77.3 0.986842105263158 75 17 98.7 0 1 225 316 390 CAI2366548.1 unnamed protein product [Moneuplotes crassus] diamond 225 124 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus

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