RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1156092" 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

  • PRJNA1156092 · 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
29156354 29156354 PRJNA1156092_P_NODE_22229_length_251_cov_0.865169_g22099_i0 PRJNA1156092 22229 251 0.865169 2.17157419 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 169 1.9e-46   NR KAK1741399.1 267567 g22099 i0 97.6 0.99203187250996006 83 2 99.2 0 1 249 718 800 KAK1741399.1 DENN domain-containing protein [Skeletonema marinoi] diamond 249 169 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
31272642 31272642 PRJNA1156092_P_NODE_32475_length_241_cov_0.916667_g32345_i0 PRJNA1156092 32475 241 0.916667 2.20916747 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 62.4 3.9e-9   NR KAL3794075.1 382360 g32345 i0 43.8 0.796680497925311 64 32 77.2 2 46 231 79 140 KAL3794075.1 hypothetical protein ACHAWO_010926 [Cyclotella atomus] diamond 192 62.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
31494154 31494154 PRJNA1156092_P_NODE_25676_length_248_cov_0.880000_g25546_i0 PRJNA1156092 25676 248 0.88 2.1824 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 140 1.25e-36   NR KAK1735133.1 267567 g25546 i0 81.3 0.967741935483871 80 15 96.8 0 242 3 388 467 KAK1735133.1 biopterin transporter family protein [Skeletonema marinoi] diamond 240 140 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);;