RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA1240805" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA1240805 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
3601057 3601057 PRJNA1240805_P_NODE_1883_length_353_cov_3.792763_g1834_i0 PRJNA1240805 1883 353 3.792763 13.38845339 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 197 3.19e-62   NR NP_049576.1 5908 g1834 i0 82.6 8.29461756373938 109 19 92.6 0 331 5 30 138 NP_049576.1 NADH dehydrogenase subunit 10 [Tetrahymena pyriformis] diamond 2928 198 0.994949494949495 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
28178740 28178740 PRJNA1240805_P_NODE_6906_length_175_cov_1.111111_g6857_i0 PRJNA1240805 6906 175 1.111111 1.94444425 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 65.9 1.02e-10   NR CAD8155076.1 43137 g6857 i0 75 2.05714285714286 40 10 68.6 0 51 170 1336 1375 CAD8155076.1 unnamed protein product [Paramecium octaurelia] diamond 360 65.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
29491559 29491559 PRJNA1240805_P_NODE_4050_length_229_cov_5.155556_g4001_i0 PRJNA1240805 4050 229 5.155556 11.80622324 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 97.8 1.25e-21   NR CAD8061913.1 5886 g4001 i0 65.2 3.45851528384279 66 23 86.5 0 24 221 106 171 CAD8061913.1 unnamed protein product [Paramecium primaurelia] diamond 792 97.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
29757547 29757547 PRJNA1240805_P_NODE_8611_length_158_cov_5.495413_g8562_i0 PRJNA1240805 8611 158 5.495413 8.68275254 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 69.3 4.9e-12   NR CAG9330851.1 1481888 g8562 i0 58 0.949367088607595 50 21 94.9 0 157 8 263 312 CAG9330851.1 unnamed protein product [Blepharisma stoltei] diamond 150 69.3 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
29838898 29838898 PRJNA1240805_P_NODE_2031_length_339_cov_3.924138_g1982_i0 PRJNA1240805 2031 339 3.924138 13.30282782 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 74.7 2.6e-14   NR XP_001025224.2 312017 g1982 i0 43.3 2.99115044247788 90 51 79.6 0 25 294 19 108 XP_001025224.2 S25 ribosomal protein [Tetrahymena thermophila SB210] diamond 1014 74.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29838899 29838899 PRJNA1240805_P_NODE_6151_length_184_cov_6.674074_g6102_i0 PRJNA1240805 6151 184 6.674074 12.28029616 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 53.5 2.17e-6   NR XP_001441516.1 5888 g6102 i0 55.3 2.29891304347826 47 20 76.6 1 22 162 47 92 XP_001441516.1 uncharacterized protein GSPATT00010353001 [Paramecium tetraurelia] diamond 423 53.9 0.992578849721707 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
29915761 29915761 PRJNA1240805_P_NODE_4471_length_216_cov_7.041916_g4422_i0 PRJNA1240805 4471 216 7.041916 15.21053856 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00254   NR KRX08303.1 266149 g4422 i0 39.1 0.958333333333333 69 26 73.6 2 29 187 176 244 KRX08303.1 hypothetical protein PPERSA_01764 [Pseudocohnilembus persalinus] diamond 207 45.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
30263413 30263413 PRJNA1240805_P_NODE_4732_length_210_cov_5.093168_g4683_i0 PRJNA1240805 4732 210 5.093168 10.6956528 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 51.6 1.8e-5   NR XP_001011524.1 312017 g4683 i0 44.9 1.4 49 27 70 0 8 154 540 588 XP_001011524.1 tubulin-tyrosine ligase family protein [Tetrahymena thermophila SB210] diamond 294 51.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30263416 30263416 PRJNA1240805_P_NODE_7992_length_164_cov_1.356522_g7943_i0 PRJNA1240805 7992 164 1.356522 2.22469608 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 62.4 1.49e-9   NR KAL4466847.1 5901 g7943 i0 59.5 0.768292682926829 42 17 76.8 0 27 152 1953 1994 KAL4466847.1 hypothetical protein ABPG74_010444 [Tetrahymena malaccensis] diamond 126 62.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30547494 30547494 PRJNA1240805_P_NODE_5953_length_187_cov_9.391304_g5904_i0 PRJNA1240805 5953 187 9.391304 17.56173848 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 56.6 2.21e-7   NR CAG9317361.1 1481888 g5904 i0 55.8 2.0855614973262 43 19 69 0 176 48 4166 4208 CAG9317361.1 unnamed protein product [Blepharisma stoltei] diamond 390 56.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
30673746 30673746 PRJNA1240805_P_NODE_6953_length_174_cov_3.008000_g6904_i0 PRJNA1240805 6953 174 3.008 5.23392 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 53.5 2.19e-6   NR CAI2373187.1 5936 g6904 i0 51 0.844827586206897 49 24 84.5 0 154 8 235 283 CAI2373187.1 unnamed protein product [Moneuplotes crassus] diamond 147 53.5 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
31843461 31843461 PRJNA1240805_P_NODE_6017_length_186_cov_5.642336_g5968_i0 PRJNA1240805 6017 186 5.642336 10.49474496 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 48.9 1.13e-4   NR XP_004030313.1 5932 g5968 i0 44.4 0.725806451612903 45 25 72.6 0 164 30 398 442 XP_004030313.1 26S proteasome protein, macropain, putative [Ichthyophthirius multifiliis] diamond 135 48.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
31893307 31893307 PRJNA1240805_P_NODE_5717_length_191_cov_2.781690_g5668_i0 PRJNA1240805 5717 191 2.78169 5.3130279 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 72 8.73e-13   NR XP_001452974.1 5888 g5668 i0 62 6.31413612565445 50 18 77 1 149 3 37 86 XP_001452974.1 uncharacterized protein GSPATT00019294001 [Paramecium tetraurelia] diamond 1206 72.4 0.994475138121547 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
32019931 32019931 PRJNA1240805_P_NODE_5358_length_197_cov_5.006757_g5309_i0 PRJNA1240805 5358 197 5.006757 9.86331129 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00151   NR CAD8123883.1 65129 g5309 i0 66.7 3.98984771573604 24 8 36.5 0 171 100 44 67 CAD8123883.1 unnamed protein product [Paramecium sonneborni] diamond 786 44.7 0.991051454138702 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
32160162 32160162 PRJNA1240805_P_NODE_3958_length_232_cov_3.213115_g3909_i0 PRJNA1240805 3958 232 3.213115 7.4544268 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 53.9 3.65e-6   NR CAG9316924.1 1481888 g3909 i0 45.5 0.711206896551724 55 29 69.8 1 185 24 175 229 CAG9316924.1 unnamed protein product [Blepharisma stoltei] diamond 165 53.9 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei

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