RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJEB7799 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
26072820 26072820 PRJEB7799n_S_NODE_8725_length_172_cov_1.102190_g8688_i0 PRJEB7799 8725 172 1.10219 1.8957668 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 107 1.37e-26   NR HNY41858.1 2212468 g8688 i0 96.4 0.959302325581395 55 2 95.9 0 1 165 150 204 HNY41858.1 DNA-directed RNA polymerase subunit alpha [Bryobacteraceae bacterium] diamond 165 107 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
26478485 26478485 PRJEB7799a_S_NODE_1376_length_342_cov_3.384365_g1341_i0 PRJEB7799 1376 342 3.384365 11.5745283 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 203 2.32e-63   NR HNY41858.1 2212468 g1341 i0 96.3 0.93859649122807 107 4 93.9 0 340 20 60 166 HNY41858.1 DNA-directed RNA polymerase subunit alpha [Bryobacteraceae bacterium] diamond 321 203 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
32930045 32930045 PRJEB7799d_S_NODE_6873_length_165_cov_1.169231_g6863_i0 PRJEB7799 6873 165 1.169231 1.92923115 Terriglobia bacterium 2081523 Bacteria Bacteria 47.4 1.97e-4   NR HTG73845.1 2081523 g6863 i0 66.7 0.490909090909091 27 9 49.1 0 57 137 14 40 HTG73845.1 hypothetical protein [Terriglobia bacterium] diamond 81 47.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
32998533 32998533 PRJEB7799i_S_NODE_3483_length_244_cov_1.837321_g3453_i0 PRJEB7799 3483 244 1.837321 4.48306324 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 89.4 6.8e-21   NR HEY8560781.1 2283092 g3453 i0 84.2 2.75409836065574 76 12 93.4 0 3 230 33 108 HEY8560781.1 YMGG-like glycine zipper-containing protein [Pyrinomonadaceae bacterium] diamond 672 89.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
32998625 32998625 PRJEB7799i_S_NODE_7795_length_176_cov_1.219858_g7765_i0 PRJEB7799 7795 176 1.219858 2.14695008 Acidobacteriota bacterium 1978231 Bacteria Bacteria 51.2 1.52e-5   NR MDQ2898304.1 1978231 g7765 i0 49.1 1.85795454545455 57 29 97.2 0 176 6 306 362 MDQ2898304.1 tetratricopeptide repeat protein [Acidobacteriota bacterium] diamond 327 51.2 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
33042739 33042739 PRJEB7799a_S_NODE_15132_length_164_cov_1.217054_g15097_i0 PRJEB7799 15132 164 1.217054 1.99596856 Pseudomonadati 3379134 Bacteria Bacteria 57.4 8.65e-8   NR MDP1832712.1 1962974 g15097 i0 53.8 4.73780487804878 52 23 93.3 1 162 10 456 507 MDP1832712.1 hypothetical protein [Geothrix sp.] diamond 777 57.8 0.993079584775087 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp.
33066931 33066931 PRJEB7799l_S_NODE_11253_length_164_cov_1.798450_g11224_i0 PRJEB7799 11253 164 1.79845 2.949458 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 59.3 1.72e-8   NR MDX1980168.1 2212468 g11224 i0 61.2 2.6890243902439 49 19 89.6 0 160 14 162 210 MDX1980168.1 hypothetical protein [Bryobacteraceae bacterium] diamond 441 59.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
33083939 33083939 PRJEB7799i_S_NODE_7422_length_180_cov_1.634483_g7392_i0 PRJEB7799 7422 180 1.634483 2.9420694 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 93.2 2.6499999999999996e-23   NR HEX8287547.1 2283092 g7392 i0 87.5 2.85 56 7 93.3 0 179 12 13 68 HEX8287547.1 DUF2945 domain-containing protein [Pyrinomonadaceae bacterium] diamond 513 93.2 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
33094040 33094040 PRJEB7799g_S_NODE_12046_length_162_cov_1.763780_g11830_i0 PRJEB7799 12046 162 1.76378 2.8573236 Bacteria 2 Bacteria Bacteria 52.4 7.5e-7   NR MCU1287814.1 1978231 g11830 i0 58 1.85185185185185 50 21 92.6 0 2 151 58 107 MCU1287814.1 hypothetical protein [Acidobacteriota bacterium] diamond 300 52.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
33101619 33101619 PRJEB7799p_S_NODE_3462_length_266_cov_4.714286_g3439_i0 PRJEB7799 3462 266 4.714286 12.54000076 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 44.7 0.0102   NR HEX4498831.1 2651171 g3439 i0 46.6 0.654135338345865 58 28 64.3 2 265 95 90 145 HEX4498831.1 IPTL-CTERM sorting domain-containing protein [Thermoanaerobaculia bacterium] diamond 174 44.7 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
33152237 33152237 PRJEB7799i_S_NODE_9864_length_160_cov_0.960000_g9834_i0 PRJEB7799 9864 160 0.96 1.536 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 55.8 2.88e-7   NR MEP6925264.1 2283092 g9834 i0 67.5 1.5375 40 13 75 0 157 38 474 513 MEP6925264.1 DegQ family serine endoprotease [Pyrinomonadaceae bacterium] diamond 246 55.8 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae 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);;