RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA385396", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 6 ✖

tax_phylum 1

  • Spirochaetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA385396 · 6 ✖

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
5510668 5510668 PRJNA385396_P_NODE_19585_length_243_cov_0.905882_g19493_i0 PRJNA385396 19585 243 0.905882 2.20129326 Leptospira inadai 29506 Bacteria Bacteria 157 8.13e-45   NR WP_020989095.1 29506 g19493 i0 95 0.987654320987654 80 4 98.8 0 2 241 131 210 WP_020989095.1 alkene reductase [Leptospira inadai] diamond 240 157 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira inadai
15709659 15709659 PRJNA385396_P_NODE_18953_length_244_cov_0.900585_g18861_i0 PRJNA385396 18953 244 0.900585 2.1974274 Leptospira broomii serovar Hurstbridge str. 5399 1049789 Bacteria Bacteria 84 1.89e-19   NR EQA47139.1 1049789 g18861 i0 79.6 0.602459016393443 49 10 60.2 0 242 96 8 56 EQA47139.1 hypothetical protein LEP1GSC050_0833 [Leptospira broomii serovar Hurstbridge str. 5399] diamond 147 84 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira broomii
26980223 26980223 PRJNA385396_P_NODE_20062_length_243_cov_0.905882_g19970_i0 PRJNA385396 20062 243 0.905882 2.20129326 Leptospira broomii 301541 Bacteria Bacteria 137 2.71e-35   NR WP_010569517.1 301541 g19970 i0 88.9 1 81 9 100 0 1 243 1008 1088 WP_010569517.1 efflux RND transporter permease subunit [Leptospira broomii] diamond 243 137 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira broomii
27597768 27597768 PRJNA385396_P_NODE_16664_length_247_cov_0.885057_g16572_i0 PRJNA385396 16664 247 0.885057 2.18609079 Leptospira 171 Bacteria Bacteria 146 1.33e-40   NR WP_100714886.1 2023191 g16572 i0 90.9 1.87044534412955 77 7 93.5 0 233 3 1 77 WP_100714886.1 glutamine-hydrolyzing carbamoyl-phosphate synthase small subunit [Leptospira perolatii] diamond 462 146 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira perolatii
29948900 29948900 PRJNA385396_P_NODE_19831_length_243_cov_0.905882_g19739_i0 PRJNA385396 19831 243 0.905882 2.20129326 Leptospira inadai 29506 Bacteria Bacteria 138 1.04e-35   NR WP_010411946.1 29506 g19739 i0 95 0.987654320987654 80 4 98.8 0 3 242 1970 2049 WP_010411946.1 PD40 domain-containing protein [Leptospira inadai] diamond 240 138 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira inadai
30896880 30896880 PRJNA385396_P_NODE_20734_length_242_cov_0.911243_g20642_i0 PRJNA385396 20734 242 0.911243 2.20520806 Leptospira fainei 48782 Bacteria Bacteria 161 1.1699999999999999e-46   NR WP_016550784.1 48782 g20642 i0 98.8 0.991735537190083 80 1 99.2 0 242 3 114 193 WP_016550784.1 DUF1554 domain-containing protein [Leptospira fainei] diamond 240 161 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira fainei

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