RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB81171" and tax_phylum = "Candidatus Melainabacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Melainabacteria · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB81171 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
27255443 27255443 PRJEB81171_P_NODE_2823_length_393_cov_0.940625_g2696_i0 PRJEB81171 2823 393 0.940625 3.69665625 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 105 7.05e-25   NR HEY9814218.1 2364082 g2696 i0 46 0.961832061068702 126 63 96.2 3 391 14 75 195 HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 378 105 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
29908070 29908070 PRJEB81171_P_NODE_5791_length_282_cov_1.052632_g5664_i0 PRJEB81171 5791 282 1.052632 2.96842224 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 171 3.45e-47   NR MBN9395629.1 2052166 g5664 i0 94.6 0.98936170212766 93 5 98.9 0 3 281 758 850 MBN9395629.1 tetratricopeptide repeat protein [Candidatus Melainabacteria bacterium] diamond 279 171 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
32405497 32405497 PRJEB81171_P_NODE_7899_length_252_cov_0.871508_g7772_i0 PRJEB81171 7899 252 0.871508 2.19620016 Candidatus Melainabacteria bacterium 2052166 Bacteria Bacteria 91.7 9.46e-20   NR MBN9394380.1 2052166 g7772 i0 93.9 0.785714285714286 66 4 78.6 0 2 199 235 300 MBN9394380.1 tetratricopeptide repeat protein [Candidatus Melainabacteria bacterium] diamond 198 91.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
32657757 32657757 PRJEB81171_P_NODE_2040_length_464_cov_1.370844_g1915_i0 PRJEB81171 2040 464 1.370844 6.36071616 Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11 1801609 Bacteria Bacteria 56.2 5.67e-6   NR OGI09100.1 1801609 g1915 i0 51 0.316810344827586 49 22 30.4 1 214 354 114 162 OGI09100.1 MAG: hypothetical protein A3F80_00030 [Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11] diamond 147 56.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11

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