RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA798511", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 4 ✖

tax_kingdom 1

  • Pseudomonadati · 4 ✖

bioproject 1

  • PRJNA798511 · 4 ✖

analysis 1

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
7169110 7169110 PRJNA798511_P_NODE_6126_length_2163_cov_16.372727_g1518_i3 PRJNA798511 6126 2163 16.372727 354.14208501 Pseudomonadati 3379134 Bacteria Bacteria 77 6.28e-12   NR OFV89174.1 1797174 g1518 i3 44.6 1.80582524271845 101 55 14 1 288 590 96 195 OFV89174.1 MAG: ATP-dependent Clp endopeptidase, proteolytic subunit ClpP [Acidobacteria bacterium RBG_16_70_10] diamond 3906 77.4 0.994832041343669 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteria bacterium RBG_16_70_10
28317310 28317310 PRJNA798511_P_NODE_83726_length_259_cov_1.247312_g79460_i0 PRJNA798511 83726 259 1.247312 3.23053808 Thermoanaerobaculales bacterium 2873827 Bacteria Bacteria 46.2 0.00263   NR MFV2073251.1 2873827 g79460 i0 41 0.706563706563707 61 31 64.9 1 232 65 193 253 MFV2073251.1 ABC transporter permease [Thermoanaerobaculales bacterium] diamond 183 46.2 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia Thermoanaerobaculales     Thermoanaerobaculales bacterium
30338757 30338757 PRJNA798511_P_NODE_79932_length_267_cov_1.108247_g75666_i0 PRJNA798511 79932 267 1.108247 2.95901949 Vicinamibacteria bacterium 2793154 Bacteria Bacteria 42.7 0.0432   NR HEY5908289.1 2793154 g75666 i0 37 0.820224719101124 73 36 70.8 1 236 48 49 121 HEY5908289.1 ABC transporter ATP-binding protein [Vicinamibacteria bacterium] diamond 219 42.7 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria       Vicinamibacteria bacterium
31855556 31855556 PRJNA798511_P_NODE_98817_length_244_cov_0.900585_g94551_i0 PRJNA798511 98817 244 0.900585 2.1974274 Terriglobia bacterium 2081523 Bacteria Bacteria 43.1 0.0177   NR HET7840884.1 2081523 g94551 i0 30.2 0.651639344262295 53 37 65.2 0 168 10 65 117 HET7840884.1 DUF6580 family putative transport protein [Terriglobia bacterium] diamond 159 43.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia 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);;