RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB36940" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB36940 · 4 ✖

analysis 1

  • diamond · 4 ✖

tax_clade 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
27127726 27127726 PRJEB36940_P_NODE_10762_length_268_cov_1.558974_g10633_i0 PRJEB36940 10762 268 1.558974 4.17805032 Nitrospirota bacterium 2026887 Bacteria Bacteria 95.1 7.340000000000001e-21   NR RMH33589.1 2026887 g10633 i0 47.1 0.973880597014925 87 45 97.4 1 1 261 266 351 RMH33589.1 MAG: glucokinase [Nitrospirota bacterium] diamond 261 95.1 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
27595627 27595627 PRJEB36940_P_NODE_7244_length_321_cov_1.254032_g7115_i0 PRJEB36940 7244 321 1.254032 4.02544272 Pseudomonadati 3379134 Bacteria Bacteria 60.5 4.56e-8   NR MBI2889882.1 2026887 g7115 i0 37.8 2.66355140186916 74 42 67.3 2 224 9 63 134 MBI2889882.1 endonuclease/exonuclease/phosphatase family protein [Nitrospirota bacterium] diamond 855 60.5 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
28423137 28423137 PRJEB36940_P_NODE_12066_length_254_cov_1.530387_g11937_i0 PRJEB36940 12066 254 1.530387 3.88718298 Nitrospirota bacterium 2026887 Bacteria Bacteria 66.6 1.46e-10   NR MBI2061238.1 2026887 g11937 i0 44.6 1.97244094488189 83 45 98 1 252 4 245 326 MBI2061238.1 saccharopine dehydrogenase NADP-binding domain-containing protein [Nitrospirota bacterium] diamond 501 66.6 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30248174 30248174 PRJEB36940_P_NODE_12832_length_251_cov_0.870787_g12703_i0 PRJEB36940 12832 251 0.870787 2.18567537 Bacteria 2 Bacteria Bacteria 45.1 0.00282   NR WP_014450545.1 180 g12703 i0 63.3 6.02390438247012 30 11 35.9 0 160 249 3 32 WP_014450545.1 50S ribosomal protein L9 [Leptospirillum ferrooxidans] diamond 1512 45.4 0.993392070484582 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Leptospirillum Leptospirillum ferrooxidans

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