RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA1249535" 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

  • PRJNA1249535 · 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
26996621 26996621 PRJNA1249535_S_NODE_158382_length_330_cov_2.299611_g154999_i0 PRJNA1249535 158382 330 2.299611 7.5887163 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0214   NR CDW85359.1 5949 g154999 i0 54.8 0.554545454545455 31 14 28.2 0 257 165 876 906 CDW85359.1 protein kinase domain containing protein [Stylonychia lemnae] diamond 183 45.1 0.991130820399113 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
27768985 27768985 PRJNA1249535_S_NODE_4224_length_1110_cov_37.269045_g2178_i1 PRJNA1249535 4224 1110 37.269045 413.6863995 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 78.6 6.86e-12   NR CAD8116839.1 5886 g2178 i1 29.4 0.524324324324324 194 113 46.8 10 276 794 225 415 CAD8116839.1 unnamed protein product [Paramecium primaurelia] diamond 582 78.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
29207642 29207642 PRJNA1249535_S_NODE_22549_length_633_cov_5.051786_g19418_i0 PRJNA1249535 22549 633 5.051786 31.97780538 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 50.8 0.00177   NR CAD8176653.1 43137 g19418 i0 52.6 0.364928909952607 38 18 18 0 260 373 392 429 CAD8176653.1 unnamed protein product [Paramecium octaurelia] diamond 231 51.2 0.9921875 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
29410377 29410377 PRJNA1249535_S_NODE_10569_length_816_cov_19.523553_g8179_i0 PRJNA1249535 10569 816 19.523553 159.31219248 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 53.1 8.78e-4   NR CAD8120276.1 65129 g8179 i0 35.5 1.96691176470588 107 55 34.2 2 223 501 2752 2858 CAD8120276.1 unnamed protein product [Paramecium sonneborni] diamond 1605 53.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
29459766 29459766 PRJNA1249535_S_NODE_282990_length_262_cov_2.380952_g279607_i0 PRJNA1249535 282990 262 2.380952 6.23809424 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0336   NR CAD8074113.1 5886 g279607 i0 57.1 0.801526717557252 35 15 40.1 0 262 158 332 366 CAD8074113.1 unnamed protein product [Paramecium primaurelia] diamond 210 43.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
29617587 29617587 PRJNA1249535_S_NODE_239090_length_285_cov_11.325472_g235707_i0 PRJNA1249535 239090 285 11.325472 32.2775952 root 1 Root_unresolved Root_unresolved 43.5 0.0341   NR XP_001031017.2 312017 g235707 i0 40.7 1.34736842105263 59 34 61.1 1 79 252 4 62 XP_001031017.2 tubulin-tyrosine ligase family protein [Tetrahymena thermophila SB210] diamond 384 43.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29662733 29662733 PRJNA1249535_S_NODE_225050_length_293_cov_2.490909_g221667_i0 PRJNA1249535 225050 293 2.490909 7.29836337 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.0106   NR CAD8119580.1 65129 g221667 i0 43.1 0.522184300341297 51 28 52.2 1 88 240 142 191 CAD8119580.1 unnamed protein product [Paramecium sonneborni] diamond 153 45.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
30073564 30073564 PRJNA1249535_S_NODE_209532_length_301_cov_3.149123_g206149_i0 PRJNA1249535 209532 301 3.149123 9.47886023 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 47.4 0.00177   NR XP_001016023.2 312017 g206149 i0 47.2 0.528239202657807 53 27 51.8 1 12 167 11 63 XP_001016023.2 tetratricopeptide repeat protein [Tetrahymena thermophila SB210] diamond 159 47.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30105188 30105188 PRJNA1249535_S_NODE_124352_length_353_cov_3.025000_g120969_i0 PRJNA1249535 124352 353 3.025 10.67825 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 47.4 0.00278   NR OMJ94943.1 5963 g120969 i0 41.1 0.475920679886686 56 32 47.6 1 207 40 130 184 OMJ94943.1 hypothetical protein SteCoe_1803 [Stentor coeruleus] diamond 168 47.4 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
30831956 30831956 PRJNA1249535_S_NODE_235554_length_287_cov_5.074766_g232171_i0 PRJNA1249535 235554 287 5.074766 14.56457842 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0462   NR KAL4456616.1 5901 g232171 i0 53.3 0.313588850174216 30 14 31.4 0 158 69 198 227 KAL4456616.1 hypothetical protein ABPG74_000723 [Tetrahymena malaccensis] diamond 90 43.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30926998 30926998 PRJNA1249535_S_NODE_185194_length_314_cov_4.207469_g181811_i0 PRJNA1249535 185194 314 4.207469 13.21145266 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0285   NR XP_001008410.2 312017 g181811 i0 52.9 0.32484076433121 34 16 32.5 0 25 126 11 44 XP_001008410.2 hypothetical protein TTHERM_00016300 [Tetrahymena thermophila SB210] diamond 102 41.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31179289 31179289 PRJNA1249535_S_NODE_3295_length_1204_cov_36.678161_g2178_i0 PRJNA1249535 3295 1204 36.678161 441.60505844 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 82.8 3.63e-13   NR CAD8116839.1 5886 g2178 i0 28.8 1.02408637873754 215 127 47.8 11 276 851 225 436 CAD8116839.1 unnamed protein product [Paramecium primaurelia] diamond 1233 82.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
31956542 31956542 PRJNA1249535_S_NODE_271397_length_268_cov_3.882051_g268014_i0 PRJNA1249535 271397 268 3.882051 10.40389668 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 55.8 1.25e-6   NR XP_001454496.1 5888 g268014 i0 71.4 9.82835820895522 42 12 47 0 2 127 288 329 XP_001454496.1 uncharacterized protein GSPATT00020752001 [Paramecium tetraurelia] diamond 2634 55.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
32476733 32476733 PRJNA1249535_S_NODE_271019_length_268_cov_6.194872_g267636_i0 PRJNA1249535 271019 268 6.194872 16.60225696 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.00654   NR XP_001008410.2 312017 g267636 i0 53.1 0.358208955223881 32 15 35.8 0 98 193 13 44 XP_001008410.2 hypothetical protein TTHERM_00016300 [Tetrahymena thermophila SB210] diamond 96 42.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32886203 32886203 PRJNA1249535_S_NODE_5680_length_1006_cov_7.628081_g2668_i2 PRJNA1249535 5680 1006 7.628081 76.73849486 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 75.1 6.32e-11   NR OMJ84054.1 5963 g2668 i2 35.1 0.450298210735586 151 89 43.2 4 1 435 82 229 OMJ84054.1 hypothetical protein SteCoe_14925 [Stentor coeruleus] diamond 453 75.1 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus

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