RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA743294" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 4 ✖

bioproject 1

  • PRJNA743294 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
27757955 27757955 PRJNA743294_P_NODE_24004_length_335_cov_1.824427_g23548_i0 PRJNA743294 24004 335 1.824427 6.11183045 Bacteria 2 Bacteria Bacteria 70.5 6.51e-12   NR WP_291816385.1 104608 g23548 i0 45.2 1.96119402985075 73 38 63.6 1 123 335 17 89 WP_291816385.1 glycosyltransferase [Leptotrichia sp.] diamond 657 70.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
28041910 28041910 PRJNA743294_P_NODE_31145_length_299_cov_1.292035_g30689_i0 PRJNA743294 31145 299 1.292035 3.86318465 Psychrilyobacter 623282 Bacteria Bacteria 45.4 0.00769   NR WP_028856373.1 271091 g30689 i0 36.8 1.7859531772575299 68 41 67.2 2 238 38 202 268 WP_028856373.1 tetratricopeptide repeat protein [Psychrilyobacter atlanticus] diamond 534 45.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Psychrilyobacter Psychrilyobacter atlanticus
29746560 29746560 PRJNA743294_P_NODE_56610_length_242_cov_0.923077_g56154_i0 PRJNA743294 56610 242 0.923077 2.23384634 Cetobacterium 180162 Bacteria Bacteria 42.4 0.0475   NR MEG0425332.1 2071632 g56154 i0 38.5 1.61157024793388 65 40 80.6 0 23 217 148 212 MEG0425332.1 ATP-binding cassette domain-containing protein [Cetobacterium sp.] diamond 390 42.4 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium sp.
30400625 30400625 PRJNA743294_P_NODE_22213_length_346_cov_9.161172_g21757_i0 PRJNA743294 22213 346 9.161172 31.69765512 Cetobacterium 180162 Bacteria Bacteria 43.9 0.00887   NR WP_240218384.1 180162 g21757 i0 50 0.364161849710983 42 20 36.4 1 158 33 58 98 WP_240218384.1 MULTISPECIES: hypothetical protein [Cetobacterium] diamond 126 43.9 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  

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);;