RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA533623" and tax_phylum = "Chlorobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorobiota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA533623 · 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
11985052 11985052 PRJNA533623_P_NODE_31790_length_399_cov_15.068047_g30019_i0 PRJNA533623 31790 399 15.068047 60.12150753 Chlorobiota bacterium 2268192 Bacteria Bacteria 212 7.2e-63   NR RMF35224.1 2268192 g30019 i0 89.3 0.909774436090226 121 13 91 0 377 15 32 152 RMF35224.1 MAG: ABC transporter ATP-binding protein [Chlorobiota bacterium] diamond 363 212 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium
27377485 27377485 PRJNA533623_P_NODE_29283_length_420_cov_8.565460_g27513_i0 PRJNA533623 29283 420 8.56546 35.974932 Bacteria 2 Bacteria Bacteria 101 5.07e-22   NR WP_059139550.1 1092 g27513 i0 71.9 8.69285714285714 64 18 45.7 0 97 288 31 94 WP_059139550.1 citrate synthase [Chlorobium limicola] diamond 3651 102 0.990196078431373 Bacteria FCB group Pseudomonadati Chlorobiota Chlorobiia Chlorobiales Chlorobiaceae Chlorobium Chlorobium limicola
29666846 29666846 PRJNA533623_P_NODE_75190_length_206_cov_2.731034_g73409_i0 PRJNA533623 75190 206 2.731034 5.62593004 Chlorobium sp. 1095 Bacteria Bacteria 42 0.0448   NR MBV5304086.1 1095 g73409 i0 40.4 0.684466019417476 47 26 68.4 1 152 12 1692 1736 MBV5304086.1 VCBS domain-containing protein [Chlorobium sp.] diamond 141 42 1 Bacteria FCB group Pseudomonadati Chlorobiota Chlorobiia Chlorobiales Chlorobiaceae Chlorobium Chlorobium sp.

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