RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA1123309" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 2 ✖

tax_phylum 1

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1123309 · 2 ✖

analysis 1

  • blastn · 2 ✖
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
20155400 20155400 PRJNA1123309_P_NODE_39096_length_273_cov_1.160000_g38716_i0 PRJNA1123309 39096 273 1.16 3.1668 root 1 Root_unresolved Root_unresolved 492 1.2499999999999996e-134   NTclustered gi|2515741548|gb|CP117271.1| 2209 g38716 i0 100 98.0476190476191 266 0 97 0 1 266 3941703 3941968 Mutant Methanosarcina mazei strain Mm Mut 208, complete genome blastn 26767 492 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Methanosarcinaceae Methanosarcina Methanosarcina mazei
23230732 23230732 PRJNA1123309_P_NODE_46699_length_253_cov_1.700000_g46319_i0 PRJNA1123309 46699 253 1.7 4.301 Salinirarus marinus 3068310 Archaea Archaea 56.5 0.002   NTclustered gi|2563036160|gb|CP132292.1| 3068310 g46319 i0 96.97 0.130434782608696 33 1 13 0 180 212 930919 930887 Haloferacaceae archaeon XH8 chromosome, complete genome blastn 33 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Salinirarus Salinirarus marinus

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