RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJEB28062", tax_clade = "FCB group" and tax_phylum = "Balneolota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Balneolota · 3 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 3 ✖

bioproject 1

  • PRJEB28062 · 3 ✖

analysis 1

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
30064671 30064671 PRJEB28062_P_NODE_102332_length_308_cov_1.808511_g99969_i0 PRJEB28062 102332 308 1.808511 5.57021388 Fodinibius salsisoli 2820877 Bacteria Bacteria 43.9 0.0266   NR WP_265766531.1 2820877 g99969 i0 38.8 0.477272727272727 49 26 47.7 1 291 145 59 103 WP_265766531.1 enoyl-CoA hydratase/isomerase family protein [Fodinibius salsisoli] diamond 147 43.9 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Fodinibius Fodinibius salsisoli
32246476 32246476 PRJEB28062_P_NODE_125718_length_248_cov_8.502857_g123354_i0 PRJEB28062 125718 248 8.502857 21.08708536 Balneolaceae bacterium 2053516 Bacteria Bacteria 43.5 0.0183   NR MEQ9310307.1 2053516 g123354 i0 31.3 0.580645161290323 48 33 58.1 0 103 246 178 225 MEQ9310307.1 DUF1080 domain-containing protein [Balneolaceae bacterium] diamond 144 43.5 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
32751503 32751503 PRJEB28062_P_NODE_74860_length_394_cov_7.305296_g72498_i0 PRJEB28062 74860 394 7.305296 28.78286624 Fodinibius sp. 1872440 Bacteria Bacteria 183 4.3199999999999985e-55   NR NIT56800.1 1872440 g72498 i0 78 2.80964467005076 123 27 93.7 0 3 371 145 267 NIT56800.1 DUF92 domain-containing protein [Fodinibius sp.] diamond 1107 183 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Fodinibius Fodinibius 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);;