RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA591127" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA591127 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
28658888 28658888 PRJNA591127_P_NODE_18267_length_197_cov_2.256250_g18098_i0 PRJNA591127 18267 197 2.25625 4.4448125 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 54.3 1.69e-6   NR MEJ7860460.1 2283092 g18098 i0 92 1.14213197969543 25 2 38.1 0 197 123 447 471 MEJ7860460.1 S8 family serine peptidase [Pyrinomonadaceae bacterium] diamond 225 54.3 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28721967 28721967 PRJNA591127_P_NODE_18767_length_197_cov_2.143750_g18598_i0 PRJNA591127 18767 197 2.14375 4.2231875 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 65.5 1.96e-10   NR HWB87206.1 2212468 g18598 i0 50.7 2.11675126903553 69 30 99 1 2 196 675 743 HWB87206.1 TonB-dependent receptor [Bryobacteraceae bacterium] diamond 417 65.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
28893056 28893056 PRJNA591127_P_NODE_14968_length_197_cov_3.643750_g14799_i0 PRJNA591127 14968 197 3.64375 7.1781875 Pseudomonadati 3379134 Bacteria Bacteria 48.1 8.45e-5   NR PYR90542.1 1978231 g14799 i0 88 3.41116751269036 25 3 38.1 0 196 122 10 34 PYR90542.1 MAG: glyoxalase [Acidobacteriota bacterium] diamond 672 48.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29258349 29258349 PRJNA591127_P_NODE_11789_length_215_cov_1.286517_g11620_i0 PRJNA591127 11789 215 1.286517 2.76601155 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 50.1 6.6e-5   NR MBP9936645.1 2283092 g11620 i0 71.4 0.488372093023256 35 10 48.8 0 75 179 2 36 MBP9936645.1 GTPase ObgE [Pyrinomonadaceae bacterium] diamond 105 50.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
30030077 30030077 PRJNA591127_P_NODE_28691_length_151_cov_6.157895_g28522_i0 PRJNA591127 28691 151 6.157895 9.29842145 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 46.2 5.5e-4   NR HZS07219.1 2052146 g28522 i0 80 2.54304635761589 25 5 49.7 0 150 76 144 168 HZS07219.1 acetyltransferase [Blastocatellia bacterium] diamond 384 46.2 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
31565290 31565290 PRJNA591127_P_NODE_22236_length_186_cov_4.926174_g22067_i0 PRJNA591127 22236 186 4.926174 9.16268364 Geothrix limicola 2927978 Bacteria Bacteria 77.4 8.43e-15   NR WP_285576364.1 2927978 g22067 i0 54.8 1.98387096774194 62 27 100 1 1 186 110 170 WP_285576364.1 O-antigen ligase family protein [Geothrix limicola] diamond 369 77.4 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix limicola
32432924 32432924 PRJNA591127_P_NODE_22919_length_181_cov_8.604167_g22750_i0 PRJNA591127 22919 181 8.604167 15.57354227 Pseudomonadati 3379134 Bacteria Bacteria 78.6 1.98e-16   NR MFN0164788.1 2212468 g22750 i0 69.6 15.3812154696133 46 14 76.2 0 43 180 2 47 MFN0164788.1 phage tail protein [Bryobacteraceae bacterium] diamond 2784 78.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae 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);;