RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA416866" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA416866 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
8736636 8736636 PRJNA416866_P_NODE_4247_length_320_cov_1.320463_g4104_i0 PRJNA416866 4247 320 1.320463 4.2254816 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 150 4.81e-44   NR CDW82785.1 5949 g4104 i0 71.7 13.875 106 30 99.4 0 319 2 4 109 CDW82785.1 40s ribosomal protein [Stylonychia lemnae] diamond 4440 151 0.993377483443709 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
26617383 26617383 PRJNA416866_P_NODE_9581_length_209_cov_0.864865_g9437_i0 PRJNA416866 9581 209 0.864865 1.80756785 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 59.7 2.55e-8   NR CAI2363781.1 5936 g9437 i0 44.6 1.60765550239234 56 30 80.4 1 3 170 2183 2237 CAI2363781.1 unnamed protein product [Moneuplotes crassus] diamond 336 59.7 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
26839291 26839291 PRJNA416866_P_NODE_1181_length_652_cov_2.583756_g1044_i0 PRJNA416866 1181 652 2.583756 16.84608912 Spirotrichea 33829 SAR_Eukaryotes SAR_Eukaryotes 55.5 4.72e-5   NR CAI2365810.1 5936 g1044 i0 41.9 0.579754601226994 62 35 28.5 1 435 620 62 122 CAI2365810.1 unnamed protein product [Moneuplotes crassus] diamond 378 55.5 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
26980604 26980604 PRJNA416866_P_NODE_1522_length_564_cov_2.147117_g1382_i0 PRJNA416866 1522 564 2.147117 12.10973988 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 213 2.93e-65   NR OMJ65538.1 5963 g1382 i0 61.8 2.03191489361702 191 57 98.4 5 562 8 52 232 OMJ65538.1 hypothetical protein SteCoe_38039 [Stentor coeruleus] diamond 1146 213 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28465305 28465305 PRJNA416866_P_NODE_11326_length_203_cov_0.901408_g11182_i0 PRJNA416866 11326 203 0.901408 1.82985824 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 53.5 2.48e-6   NR KRX05637.1 266149 g11182 i0 65.7 0.517241379310345 35 12 51.7 0 13 117 204 238 KRX05637.1 hypothetical protein PPERSA_09777 [Pseudocohnilembus persalinus] diamond 105 53.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
31466249 31466249 PRJNA416866_P_NODE_4796_length_300_cov_1.606695_g4652_i0 PRJNA416866 4796 300 1.606695 4.820085 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 91.3 1.28e-20   NR CAG9318382.1 1481888 g4652 i0 73.9 0.46 46 12 46 0 1 138 90 135 CAG9318382.1 unnamed protein product [Blepharisma stoltei] diamond 138 91.3 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);;