RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1136957", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Acidobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1136957 · 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
30575634 30575634 PRJNA1136957_S_NODE_12633_length_242_cov_2.000000_g12536_i0 PRJNA1136957 12633 242 2 4.84 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 43.9 0.014   NR HEU4479609.1 2283092 g12536 i0 45.2 0.520661157024793 42 22 50.8 1 31 153 365 406 HEU4479609.1 amino acid permease [Pyrinomonadaceae bacterium] diamond 126 43.9 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
30986802 30986802 PRJNA1136957_S_NODE_9814_length_271_cov_3.396226_g9717_i0 PRJNA1136957 9814 271 3.396226 9.20377246 Holophagales bacterium 2478486 Bacteria Bacteria 43.9 0.0208   NR MBK9969167.1 2478486 g9717 i0 39 0.907749077490775 82 36 83 3 225 1 462 536 MBK9969167.1 hypothetical protein [Holophagales bacterium] diamond 246 43.9 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales     Holophagales bacterium
32346919 32346919 PRJNA1136957_S_NODE_18839_length_201_cov_0.859155_g18742_i0 PRJNA1136957 18839 201 0.859155 1.72690155 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 64.3 3.22e-10   NR HEV8630233.1 2651171 g18742 i0 54.8 0.925373134328358 62 23 85.1 1 2 172 181 242 HEV8630233.1 tail fiber domain-containing protein [Thermoanaerobaculia bacterium] diamond 186 64.3 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
32536687 32536687 PRJNA1136957_S_NODE_10399_length_265_cov_1.184466_g10302_i0 PRJNA1136957 10399 265 1.184466 3.1388349 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 43.1 0.0369   NR HEX2464767.1 2651171 g10302 i0 35.7 1.10943396226415 98 45 94 2 17 265 32 126 HEX2464767.1 SIS domain-containing protein [Thermoanaerobaculia bacterium] diamond 294 43.1 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia 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);;