RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA564810" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA564810 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
29763272 29763272 PRJNA564810_S_NODE_1731_length_349_cov_1.369718_g1709_i0 PRJNA564810 1731 349 1.369718 4.78031582 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.46e-5   NR TNV79531.1 5974 g1709 i0 56.8 0.378223495702006 44 19 37.8 0 19 150 456 499 TNV79531.1 hypothetical protein FGO68_gene3345 [Halteria grandinella] diamond 132 53.9 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
30630016 30630016 PRJNA564810_S_NODE_3813_length_277_cov_2.566038_g3791_i0 PRJNA564810 3813 277 2.566038 7.10792526 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 88.2 6.2e-18   NR CAI2358991.1 5936 g3791 i0 49.5 7.2129963898917 97 43 99.6 3 2 277 2281 2376 CAI2358991.1 unnamed protein product [Moneuplotes crassus] diamond 1998 88.2 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
31722734 31722734 PRJNA564810_S_NODE_3357_length_288_cov_3.847534_g3335_i0 PRJNA564810 3357 288 3.847534 11.08089792 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 67 3.18e-11   NR TNV78448.1 5974 g3335 i0 49.3 0.697916666666667 67 34 69.8 0 1 201 118 184 TNV78448.1 hypothetical protein FGO68_gene527 [Halteria grandinella] diamond 201 67 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella

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