RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA756891", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 2 ✖

tax_clade 1

  • delta/epsilon subdivisions · 2 ✖

bioproject 1

  • PRJNA756891 · 2 ✖

analysis 1

tax_phylum 0

tax_kingdom 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
28325925 28325925 PRJNA756891_P_NODE_66_length_2097_cov_5.043478_g57_i0 PRJNA756891 66 2097 5.043478 105.76173366 Abditibacteriota 2109258 Bacteria Bacteria 53.1 0.00557   NR AWV88593.1 1548548 g57 i0 25.9 0.911301859799714 313 190 40.2 13 1690 848 687 989 AWV88593.1 hypothetical protein DN745_04270 [Bradymonas sediminis] diamond 1911 53.1 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria Bradymonadales Bradymonadaceae Bradymonas Bradymonas sediminis
31791126 31791126 PRJNA756891_P_NODE_6177_length_343_cov_1.907407_g6108_i0 PRJNA756891 6177 343 1.907407 6.54240601 SAR324 cluster bacterium 2024889 Bacteria Bacteria 79.3 1.67e-14   NR MCH8884323.1 2024889 g6108 i0 45.7 2.7463556851312 105 56 91.8 1 2 316 205 308 MCH8884323.1 SLC13 family permease [SAR324 cluster bacterium] diamond 942 79.3 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       SAR324 cluster 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);;