RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA689790" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA689790 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
11381587 11381587 PRJNA689790_S_NODE_15229_length_156_cov_1.310924_g15114_i0 PRJNA689790 15229 156 1.310924 2.04504144 Oxytricha sp. LPJ-2 99928 SAR_Eukaryotes SAR_Eukaryotes 97.4 1.98e-22   NR AAY67879.1 329142 g15114 i0 100 0.980769230769231 51 0 98.1 0 154 2 251 301 AAY67879.1 heat shock protein 70, partial [Oxytricha sp. LPJ-2005] diamond 153 97.4 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha sp. LPJ-2005
26797507 26797507 PRJNA689790_S_NODE_16321_length_152_cov_1.313043_g16206_i0 PRJNA689790 16321 152 1.313043 1.99582536 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 89.4 9.6e-21   NR CAG9318382.1 1481888 g16206 i0 78 0.986842105263158 50 11 98.7 0 151 2 42 91 CAG9318382.1 unnamed protein product [Blepharisma stoltei] diamond 150 89.4 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
27145141 27145141 PRJNA689790_S_NODE_4182_length_298_cov_2.697318_g4067_i0 PRJNA689790 4182 298 2.697318 8.03800764 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 57.8 3.81e-8   NR CDW88910.1 5949 g4067 i0 57.1 1.10738255033557 56 20 52.3 1 2 157 30 85 CDW88910.1 60s acidic ribosomal protein p1 [Stylonychia lemnae] diamond 330 57.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
27461717 27461717 PRJNA689790_S_NODE_14303_length_160_cov_1.268293_g14188_i0 PRJNA689790 14303 160 1.268293 2.0292688 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.8e-5   NR CAD8078148.1 65129 g14188 i0 50 0.7125 38 19 71.3 0 160 47 119 156 CAD8078148.1 unnamed protein product [Paramecium sonneborni] diamond 114 49.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
27567665 27567665 PRJNA689790_S_NODE_13264_length_165_cov_1.210938_g13149_i0 PRJNA689790 13264 165 1.210938 1.9980477 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 80.9 4.79e-16   NR XP_001432968.1 5888 g13149 i0 57.4 3.92727272727273 54 23 98.2 0 165 4 386 439 XP_001432968.1 uncharacterized protein GSPATT00035051001 [Paramecium tetraurelia] diamond 648 80.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
27726041 27726041 PRJNA689790_S_NODE_9784_length_189_cov_1.796053_g9669_i0 PRJNA689790 9784 189 1.796053 3.39454017 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 90.1 4.860000000000001e-21   NR XP_001449603.1 5888 g9669 i0 66.7 9.3650793650793709 60 20 95.2 0 189 10 18 77 XP_001449603.1 uncharacterized protein GSPATT00002335001 [Paramecium tetraurelia] diamond 1770 90.9 0.991199119911991 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
27935262 27935262 PRJNA689790_S_NODE_7905_length_210_cov_1.994220_g7790_i0 PRJNA689790 7905 210 1.99422 4.187862 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00102   NR CDW81400.1 5949 g7790 i0 90 1.64285714285714 20 2 28.6 0 209 150 332 351 CDW81400.1 cathepsin h [Stylonychia lemnae] diamond 345 46.6 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
28345608 28345608 PRJNA689790_S_NODE_7806_length_211_cov_2.666667_g7691_i0 PRJNA689790 7806 211 2.666667 5.62666737 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 58.9 4.57e-9   NR CDW88910.1 5949 g7691 i0 53.4 0.824644549763033 58 27 82.5 0 3 176 28 85 CDW88910.1 60s acidic ribosomal protein p1 [Stylonychia lemnae] diamond 174 58.9 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
28767520 28767520 PRJNA689790_S_NODE_6747_length_229_cov_1.166667_g6632_i0 PRJNA689790 6747 229 1.166667 2.67166743 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 57.4 2.09e-8   NR OMJ69995.1 5963 g6632 i0 51.2 1.06113537117904 43 21 56.3 0 23 151 3 45 OMJ69995.1 hypothetical protein SteCoe_32124 [Stentor coeruleus] diamond 243 57.4 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28798952 28798952 PRJNA689790_S_NODE_6547_length_233_cov_1.790816_g6432_i0 PRJNA689790 6547 233 1.790816 4.17260128 Euplotida 33831 SAR_Eukaryotes SAR_Eukaryotes 54.7 6.26e-7   NR CAI2380433.1 5936 g6432 i0 52.1 1.82832618025751 48 23 61.8 0 233 90 115 162 CAI2380433.1 unnamed protein product [Moneuplotes crassus] diamond 426 54.7 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
28893727 28893727 PRJNA689790_S_NODE_3488_length_333_cov_2.729730_g3373_i0 PRJNA689790 3488 333 2.72973 9.0900009 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 122 1.36e-33   NR CDW83169.1 5949 g3373 i0 67.4 1.59459459459459 92 30 82.9 0 8 283 25 116 CDW83169.1 UNKNOWN [Stylonychia lemnae] diamond 531 122 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29619667 29619667 PRJNA689790_S_NODE_16530_length_151_cov_1.710526_g16415_i0 PRJNA689790 16530 151 1.710526 2.58289426 root 1 Root_unresolved Root_unresolved 66.6 3.98e-11   NR CAG9322292.1 1481888 g16415 i0 57.4 6.6953642384106 47 20 93.4 0 150 10 264 310 CAG9322292.1 unnamed protein product [Blepharisma stoltei] diamond 1011 66.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
30714202 30714202 PRJNA689790_S_NODE_5534_length_255_cov_2.311927_g5419_i0 PRJNA689790 5534 255 2.311927 5.89541385 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00374   NR CAG9331979.1 1481888 g5419 i0 58.5 1.4 41 16 48.2 1 1 123 1726 1765 CAG9331979.1 unnamed protein product [Blepharisma stoltei] diamond 357 45.8 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
31073376 31073376 PRJNA689790_S_NODE_11395_length_176_cov_1.827338_g11280_i0 PRJNA689790 11395 176 1.827338 3.21611488 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 54.7 8.8e-7   NR CDW79417.1 5949 g11280 i0 42 3.51136363636364 50 29 85.2 0 176 27 143 192 CDW79417.1 UNKNOWN [Stylonychia lemnae] diamond 618 55.1 0.992740471869329 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31389598 31389598 PRJNA689790_S_NODE_9836_length_189_cov_1.026316_g9721_i0 PRJNA689790 9836 189 1.026316 1.93973724 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 57.4 1.26e-7   NR XP_001025134.3 312017 g9721 i0 41.9 1.93650793650794 62 36 98.4 0 1 186 242 303 XP_001025134.3 DEAD/DEAH-box helicase [Tetrahymena thermophila SB210] diamond 366 57.8 0.993079584775087 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31421080 31421080 PRJNA689790_S_NODE_14696_length_158_cov_1.611570_g14581_i0 PRJNA689790 14696 158 1.61157 2.5462806 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 80.9 3.29e-17   NR XP_004034690.1 5932 g14581 i0 69.2 7.84177215189873 52 16 98.7 0 3 158 3 54 XP_004034690.1 hypothetical protein IMG5_115900 [Ichthyophthirius multifiliis] diamond 1239 81.6 0.991421568627451 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
31673973 31673973 PRJNA689790_S_NODE_5177_length_265_cov_1.118421_g5062_i0 PRJNA689790 5177 265 1.118421 2.96381565 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 56.2 8.25e-7   NR CAD8213039.1 43137 g5062 i0 36.9 4.26792452830189 65 41 73.6 0 262 68 86 150 CAD8213039.1 unnamed protein product [Paramecium octaurelia] diamond 1131 56.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
31725787 31725787 PRJNA689790_S_NODE_9717_length_190_cov_1.267974_g9602_i0 PRJNA689790 9717 190 1.267974 2.4091506 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00228   NR CAI2380433.1 5936 g9602 i0 64.5 0.489473684210526 31 11 48.9 0 186 94 132 162 CAI2380433.1 unnamed protein product [Moneuplotes crassus] diamond 93 44.7 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
32148715 32148715 PRJNA689790_S_NODE_7398_length_217_cov_2.666667_g7283_i0 PRJNA689790 7398 217 2.666667 5.78666739 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 82.4 6.34e-18   NR XP_004027550.1 5932 g7283 i0 58.6 5.72350230414747 70 28 96.8 1 214 5 3 71 XP_004027550.1 hypothetical protein IMG5_181340 [Ichthyophthirius multifiliis] diamond 1242 82.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
32370318 32370318 PRJNA689790_S_NODE_13379_length_164_cov_1.842520_g13264_i0 PRJNA689790 13379 164 1.84252 3.0217328 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 42 0.0241   NR CDW75025.1 5949 g13264 i0 51.3 3.80487804878049 39 19 71.3 0 39 155 376 414 CDW75025.1 rh type b glycoprotein [Stylonychia lemnae] diamond 624 42 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);;