RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA733995" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA733995 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
27062587 27062587 PRJNA733995_P_NODE_2062_length_623_cov_3.594545_g2015_i0 PRJNA733995 2062 623 3.594545 22.39401535 Nostocales 1161 Bacteria Bacteria 47.8 0.00948   NR WP_017748227.1 34078 g2015 i0 38.5 5.00802568218299 91 50 41.9 2 366 106 30 118 WP_017748227.1 hypothetical protein [Scytonema hofmannii] diamond 3120 47.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonema Scytonema hofmannii
27305384 27305384 PRJNA733995_P_NODE_6123_length_346_cov_1.974359_g6076_i0 PRJNA733995 6123 346 1.974359 6.83128214 Nostoc sp. 1180 Bacteria Bacteria 53.9 1.13e-6   NR WP_334733461.1 1180 g6076 i0 55.8 0.710982658959538 43 19 37.3 0 9 137 1 43 WP_334733461.1 tetratricopeptide repeat protein [Nostoc sp.] diamond 246 53.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp.
31664124 31664124 PRJNA733995_P_NODE_6017_length_350_cov_1.111913_g5970_i0 PRJNA733995 6017 350 1.111913 3.8916955 Cyanobacteria bacterium J06555_13 3023131 Bacteria Bacteria 48.9 8.23e-4   NR MEN8443588.1 3023131 g5970 i0 50 0.788571428571429 46 23 39.4 0 348 211 376 421 MEN8443588.1 tetratricopeptide repeat protein [Cyanobacteria bacterium J06555_13] diamond 276 48.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06555_13

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