RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1240804" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA1240804 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
25276055 25276055 PRJNA1240804_P_NODE_116520_length_168_cov_0.873950_g116154_i0 PRJNA1240804 116520 168 0.87395 1.468236 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 79 1.86e-15   NR XP_001020279.2 312017 g116154 i0 67.3 0.928571428571429 52 17 92.9 0 157 2 159 210 XP_001020279.2 DEAD/DEAH-box helicase [Tetrahymena thermophila SB210] diamond 156 79 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
26743103 26743103 PRJNA1240804_P_NODE_124561_length_166_cov_0.888889_g124195_i0 PRJNA1240804 124561 166 0.888889 1.47555574 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00388   NR CAD8074567.1 5886 g124195 i0 55.6 1.26506024096386 36 16 65.1 0 121 14 1112 1147 CAD8074567.1 unnamed protein product [Paramecium primaurelia] diamond 210 44.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
27136281 27136281 PRJNA1240804_P_NODE_25482_length_283_cov_2.893162_g25116_i0 PRJNA1240804 25482 283 2.893162 8.18764846 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 49.7 3.66e-5   NR XP_012652362.1 312017 g25116 i0 50 1.01766784452297 48 24 50.9 0 50 193 24 71 XP_012652362.1 hypothetical protein TTHERM_000294739 [Tetrahymena thermophila SB210] diamond 288 49.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28544595 28544595 PRJNA1240804_P_NODE_133527_length_165_cov_0.896552_g133161_i0 PRJNA1240804 133527 165 0.896552 1.4793108 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 75.1 5.18e-14   NR XP_001015210.1 312017 g133161 i0 84.4 2.45454545454545 45 7 81.8 0 135 1 1694 1738 XP_001015210.1 hypothetical protein TTHERM_00509060 [Tetrahymena thermophila SB210] diamond 405 75.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29788996 29788996 PRJNA1240804_P_NODE_115531_length_168_cov_0.873950_g115165_i0 PRJNA1240804 115531 168 0.87395 1.468236 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 49.3 6.84e-5   NR XP_001021958.1 312017 g115165 i0 56.1 0.732142857142857 41 18 73.2 0 135 13 785 825 XP_001021958.1 hypothetical protein TTHERM_00859180 [Tetrahymena thermophila SB210] diamond 123 49.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30597056 30597056 PRJNA1240804_P_NODE_122033_length_167_cov_0.881356_g121667_i0 PRJNA1240804 122033 167 0.881356 1.47186452 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 82.4 1.36e-16   NR OMJ95737.1 5963 g121667 i0 79.6 1.76047904191617 49 10 88 0 152 6 487 535 OMJ95737.1 hypothetical protein SteCoe_808 [Stentor coeruleus] diamond 294 82.8 0.995169082125604 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
30926845 30926845 PRJNA1240804_P_NODE_97074_length_175_cov_1.523810_g96708_i0 PRJNA1240804 97074 175 1.52381 2.6666675 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 49.7 5.48e-5   NR CDW73481.1 5949 g96708 i0 43.9 0.977142857142857 57 28 90.9 1 16 174 4641 4697 CDW73481.1 ubiquitin-activating enzyme e1 family protein [Stylonychia lemnae] diamond 171 49.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31115884 31115884 PRJNA1240804_P_NODE_138935_length_164_cov_0.904348_g138569_i0 PRJNA1240804 138935 164 0.904348 1.48313072 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 55.8 8.23e-8   NR KRX03893.1 266149 g138569 i0 44.9 0.896341463414634 49 27 89.6 0 149 3 18 66 KRX03893.1 hypothetical protein PPERSA_04771 [Pseudocohnilembus persalinus] diamond 147 55.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
31369366 31369366 PRJNA1240804_P_NODE_96396_length_175_cov_6.206349_g96030_i0 PRJNA1240804 96396 175 6.206349 10.86111075 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00391   NR XP_012653513.1 312017 g96030 i0 38.5 0.891428571428571 52 32 89.1 0 19 174 57 108 XP_012653513.1 MFS transporter [Tetrahymena thermophila SB210] diamond 156 44.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32508179 32508179 PRJNA1240804_P_NODE_107999_length_169_cov_0.866667_g107633_i0 PRJNA1240804 107999 169 0.866667 1.46466723 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00157   NR OMJ73795.1 5963 g107633 i0 75 1.13609467455621 28 7 49.7 0 49 132 594 621 OMJ73795.1 hypothetical protein SteCoe_27437 [Stentor coeruleus] diamond 192 45.4 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
32665600 32665600 PRJNA1240804_P_NODE_42320_length_233_cov_0.994565_g41954_i0 PRJNA1240804 42320 233 0.994565 2.31733645 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 56.2 1.4e-7   NR KRX01081.1 266149 g41954 i0 55.8 0.669527896995708 52 23 67 0 209 54 26 77 KRX01081.1 hypothetical protein PPERSA_02177 [Pseudocohnilembus persalinus] diamond 156 56.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus

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