RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA285816" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA285816 · 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
8025150 8025150 PRJNA285816_S_NODE_11667_length_218_cov_1.508876_g11565_i0 PRJNA285816 11667 218 1.508876 3.28934968 root 1 Root_unresolved Root_unresolved 111 1.2e-26   NR MES1916046.1 1215613 g11565 i0 73.5 6.71559633027523 68 18 93.6 0 208 5 328 395 MES1916046.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1464 111 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26884472 26884472 PRJNA285816_S_NODE_3821_length_346_cov_2.212121_g3719_i0 PRJNA285816 3821 346 2.212121 7.65393866 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 110 9.71e-28   NR MES1907612.1 1215613 g3719 i0 46.5 0.875722543352601 101 54 87.6 0 340 38 19 119 MES1907612.1 hypothetical protein [Cercozoa sp. M6MM] diamond 303 110 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29649221 29649221 PRJNA285816_S_NODE_17090_length_191_cov_1.000000_g16988_i0 PRJNA285816 17090 191 1 1.91 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 64.7 1.35e-10   NR MES1914924.1 1215613 g16988 i0 60 8.2303664921466 55 22 86.4 0 183 19 134 188 MES1914924.1 40S ribosomal protein S6 [Cercozoa sp. M6MM] diamond 1572 65.1 0.993855606758833 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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