RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA897077", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 3 ✖

tax_kingdom 1

  • Pseudomonadati · 3 ✖

bioproject 1

  • PRJNA897077 · 3 ✖

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
12723693 12723693 PRJNA897077_P_NODE_18710_length_245_cov_0.906977_g18583_i0 PRJNA897077 18710 245 0.906977 2.22209365 Treponema 157 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|2265166044|gb|CP051303.1| 158 g18583 i0 100 11 245 0 100 0 1 245 1235153 1234909 Treponema denticola strain OT2B chromosome, complete genome blastn 2695 453 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema denticola
28318990 28318990 PRJNA897077_P_NODE_19706_length_242_cov_0.923077_g19579_i0 PRJNA897077 19706 242 0.923077 2.23384634 Spirochaetia bacterium 2053615 Bacteria Bacteria 47 0.00113   NR NBK25894.1 2053615 g19579 i0 50 0.495867768595041 40 19 49.6 1 10 129 313 351 NBK25894.1 hypothetical protein [Spirochaetia bacterium] diamond 120 47 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia       Spirochaetia bacterium
32205470 32205470 PRJNA897077_P_NODE_16138_length_251_cov_0.876404_g16011_i0 PRJNA897077 16138 251 0.876404 2.19977404 Spirochaetaceae bacterium 1898206 Bacteria Bacteria 134 2.4e-35   NR MDD9986915.1 1898206 g16011 i0 75.9 0.99203187250996006 83 20 99.2 0 249 1 107 189 MDD9986915.1 ATP-binding protein [Spirochaetaceae bacterium] diamond 249 134 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae   Spirochaetaceae 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);;