RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA680334" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA680334 · 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
27239911 27239911 PRJNA680334_S_NODE_33743_length_217_cov_1.717391_g33257_i0 PRJNA680334 33743 217 1.717391 3.72673847 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 79.3 2.14e-16   NR GKY99837.1 2872254 g33257 i0 60.6 0.981566820276498 71 25 98.2 2 213 1 16 83 GKY99837.1 hypothetical protein MPSEU_000937500 [Mayamaea pseudoterrestris] diamond 213 79.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29734207 29734207 PRJNA680334_S_NODE_49850_length_192_cov_2.748428_g49364_i0 PRJNA680334 49850 192 2.748428 5.27698176 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 51.2 1.76e-5   NR GKY95538.1 2872254 g49364 i0 48.3 0.9375 60 31 93.8 0 188 9 236 295 GKY95538.1 hypothetical protein MPSEU_000515400 [Mayamaea pseudoterrestris] diamond 180 51.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
31262809 31262809 PRJNA680334_S_NODE_57815_length_183_cov_3.453333_g57329_i0 PRJNA680334 57815 183 3.453333 6.31959939 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 75.1 6.23e-14   NR KAK1742141.1 267567 g57329 i0 82.9 6.55737704918033 41 7 67.2 0 2 124 425 465 KAK1742141.1 UDP-glucose 6-dehydrogenase [Skeletonema marinoi] diamond 1200 75.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi

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