RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA168635 · 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
27295181 27295181 PRJNA168635_P_NODE_35243_length_152_cov_2.941748_g34827_i0 PRJNA168635 35243 152 2.941748 4.47145696 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 97.4 2.4699999999999994e-23   NR MBX9725419.1 2364082 g34827 i0 95.9 0.967105263157895 49 2 96.7 0 151 5 133 181 MBX9725419.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 147 97.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
29239181 29239181 PRJNA168635_P_NODE_29049_length_165_cov_0.896552_g28633_i0 PRJNA168635 29049 165 0.896552 1.4793108 root 1 Root_unresolved Root_unresolved 51.2 8.21e-6   NR HEY9817448.1 2364082 g28633 i0 65.5 1.90909090909091 29 10 52.7 0 88 2 165 193 HEY9817448.1 gamma-glutamyl-gamma-aminobutyrate hydrolase family protein [Candidatus Obscuribacterales bacterium] diamond 315 51.6 0.992248062015504 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
30390293 30390293 PRJNA168635_P_NODE_25293_length_169_cov_0.866667_g24877_i0 PRJNA168635 25293 169 0.866667 1.46466723 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 65.1 1.53e-10   NR HEY9805490.1 2364082 g24877 i0 57.4 1.08284023668639 61 19 95.9 1 167 6 170 230 HEY9805490.1 reverse transcriptase domain-containing protein [Candidatus Obscuribacterales bacterium] diamond 183 65.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium

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