RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 18 ✖

tax_clade 1

bioproject 1

  • PRJEB20058 · 18 ✖

analysis 1

  • diamond · 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
25514051 25514051 PRJEB20058_P_NODE_129289_length_347_cov_2.818182_g126470_i0 PRJEB20058 129289 347 2.818182 9.77909154 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 135 3.37e-38   NR TNV75396.1 5974 g126470 i0 90.5 674.956772334294 74 7 64 0 124 345 64 137 TNV75396.1 hypothetical protein FGO68_gene14298 [Halteria grandinella] diamond 234210 135 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
25514864 25514864 PRJEB20058_P_NODE_147425_length_317_cov_14.968750_g144604_i0 PRJEB20058 147425 317 14.96875 47.4509375 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 62.4 9.13e-9   NR BAA31161.1 5908 g144604 i0 42.9 0.529968454258675 56 32 53 0 279 112 269 324 BAA31161.1 tetrain [Tetrahymena pyriformis] diamond 168 62.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
25930591 25930591 PRJEB20058_P_NODE_8932_length_1403_cov_19.827869_g7587_i0 PRJEB20058 8932 1403 19.827869 278.18500207 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 389 4.3999999999999996e-126   NR OMJ80408.1 5963 g7587 i0 61.3 22.1974340698503 310 112 65.6 3 282 1202 225 529 OMJ80408.1 hypothetical protein SteCoe_19310 [Stentor coeruleus] diamond 31143 390 0.997435897435897 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
26292244 26292244 PRJEB20058_P_NODE_10582_length_1280_cov_46.799016_g9087_i0 PRJEB20058 10582 1280 46.799016 599.0274048 Tetrahymenidae 291294 SAR_Eukaryotes SAR_Eukaryotes 269 3.239999999999999e-81   NR XP_004039492.1 5932 g9087 i0 39.5 1.97578125 425 224 95.9 12 1234 8 2 409 XP_004039492.1 ubiquitin specific peptidase, putative [Ichthyophthirius multifiliis] diamond 2529 269 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
32910549 32910549 PRJEB20058_P_NODE_136161_length_335_cov_2.854015_g133341_i0 PRJEB20058 136161 335 2.854015 9.56095025 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 93.6 1.45e-19   NR TNV84265.1 5974 g133341 i0 61 0.68955223880597 77 30 69 0 9 239 460 536 TNV84265.1 hypothetical protein FGO68_gene10754 [Halteria grandinella] diamond 231 93.6 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
32962545 32962545 PRJEB20058_P_NODE_211066_length_248_cov_9.171123_g208242_i0 PRJEB20058 211066 248 9.171123 22.74438504 Oxytricha trifallax 1172189 SAR_Eukaryotes SAR_Eukaryotes 69.7 1.2e-11   NR AEV66668.1 1172189 g208242 i0 48.5 0.798387096774194 66 34 79.8 0 201 4 289 354 AEV66668.1 rps4 [Oxytricha trifallax] diamond 198 69.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha trifallax
32962573 32962573 PRJEB20058_P_NODE_216274_length_245_cov_1.418478_g213450_i0 PRJEB20058 216274 245 1.418478 3.4752711 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 61.6 8.44e-9   NR TNV84098.1 5974 g213450 i0 53 0.808163265306122 66 29 78.4 1 211 20 568 633 TNV84098.1 hypothetical protein FGO68_gene5991 [Halteria grandinella] diamond 198 61.6 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
32991361 32991361 PRJEB20058_P_NODE_126283_length_352_cov_16.364261_g123464_i0 PRJEB20058 126283 352 16.364261 57.60219872 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 67.8 1.65e-10   NR CAD8102715.1 5886 g123464 i0 60 2.04545454545455 60 22 49.4 1 58 231 189 248 CAD8102715.1 unnamed protein product [Paramecium primaurelia] diamond 720 67.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
32996653 32996653 PRJEB20058_P_NODE_243883_length_207_cov_6.027397_g241058_i0 PRJEB20058 243883 207 6.027397 12.47671179 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 67.8 5.1e-12   NR TNV80077.1 5974 g241058 i0 81.6 0.550724637681159 38 7 55.1 0 184 71 141 178 TNV80077.1 hypothetical protein FGO68_gene12687 [Halteria grandinella] diamond 114 67.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
33012982 33012982 PRJEB20058_P_NODE_110164_length_384_cov_19.551084_g107353_i0 PRJEB20058 110164 384 19.551084 75.07616256 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 113 4.36e-28   NR XP_001031847.2 312017 g107353 i0 68.9 3.421875 74 23 57.8 0 361 140 166 239 XP_001031847.2 60S ribosomal protein L7 [Tetrahymena thermophila SB210] diamond 1314 113 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
33025664 33025664 PRJEB20058_P_NODE_83612_length_451_cov_175.566667_g80825_i0 PRJEB20058 83612 451 175.566667 791.80566817 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 113 7.26e-26   NR CAD8157183.1 43138 g80825 i0 70.9 4.2039911308204 79 23 52.5 0 286 50 3181 3259 CAD8157183.1 unnamed protein product [Paramecium pentaurelia] diamond 1896 114 0.991228070175439 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
33031151 33031151 PRJEB20058_P_NODE_68908_length_502_cov_18.732426_g66138_i0 PRJEB20058 68908 502 18.732426 94.03677852 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 140 1.63e-36   NR XP_004035427.1 5932 g66138 i0 60.4 1.19521912350598 101 40 60.4 0 19 321 282 382 XP_004035427.1 hypothetical protein IMG5_099690 [Ichthyophthirius multifiliis] diamond 600 140 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
33081326 33081326 PRJEB20058_P_NODE_135326_length_336_cov_15.978182_g132506_i0 PRJEB20058 135326 336 15.978182 53.68669152 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 79.3 2.56e-15   NR TNV71197.1 5974 g132506 i0 49.4 0.794642857142857 89 44 78.6 1 59 322 57 145 TNV71197.1 hypothetical protein FGO68_gene13617 [Halteria grandinella] diamond 267 79.3 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
33098678 33098678 PRJEB20058_P_NODE_179222_length_277_cov_1.453704_g176399_i0 PRJEB20058 179222 277 1.453704 4.02676008 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.0026   NR CDW89653.1 5949 g176399 i0 55.9 0.368231046931408 34 14 35.7 1 252 154 1896 1929 CDW89653.1 regulator of chromosome condensation [Stylonychia lemnae] diamond 102 46.6 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
33115571 33115571 PRJEB20058_P_NODE_15991_length_1035_cov_8.430185_g14121_i0 PRJEB20058 15991 1035 8.430185 87.25241475 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 167 2.67e-45   NR XP_004039659.1 5932 g14121 i0 41.2 1.21739130434783 228 107 64.1 7 50 712 1 208 XP_004039659.1 hypothetical protein IMG5_014930 [Ichthyophthirius multifiliis] diamond 1260 167 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
33166701 33166701 PRJEB20058_P_NODE_149472_length_314_cov_9.905138_g146650_i0 PRJEB20058 149472 314 9.9051380000000009 31.10213332 Thuricola similis 2784598 SAR_Eukaryotes SAR_Eukaryotes 60.1 9.58e-9   NR YP_010147343.1 2784598 g146650 i0 45.9 0.707006369426752 74 34 65 2 4 207 5 78 YP_010147343.1 50S ribosomal protein L16 [Thuricola similis] diamond 222 60.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vaginicolidae Thuricola Thuricola similis
33166789 33166789 PRJEB20058_P_NODE_16224_length_1028_cov_18.394002_g14341_i0 PRJEB20058 16224 1028 18.394002 189.09034056 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 52.4 0.00303   NR KAL4483218.1 5901 g14341 i0 57.1 0.122568093385214 42 18 12.3 0 18 143 2461 2502 KAL4483218.1 hypothetical protein ABPG74_019244 [Tetrahymena malaccensis] diamond 126 52.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
33166965 33166965 PRJEB20058_P_NODE_195456_length_259_cov_47.378788_g192632_i0 PRJEB20058 195456 259 47.378788 122.71106092 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 47 0.00143   NR XP_001007447.2 312017 g192632 i0 49.1 0.613899613899614 53 20 56.8 2 170 24 751 800 XP_001007447.2 transitional endoplasmic reticulum ATPase, putative [Tetrahymena thermophila SB210] diamond 159 47 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila

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