RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA915212", 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 · 6 ✖

tax_kingdom 1

  • Pseudomonadati · 6 ✖

bioproject 1

  • PRJNA915212 · 6 ✖

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
17473310 17473310 PRJNA915212_P_NODE_13414_length_164_cov_0.886957_g13376_i0 PRJNA915212 13414 164 0.886957 1.45460948 Treponema bryantii 163 Bacteria Bacteria 52.8 0.014   NTclustered gi|2581915939|dbj|AP025286.1| 163 g13376 i0 100 0.170731707317073 28 0 17 0 53 80 1397620 1397593 Treponema bryantii JCM 32280 DNA, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema bryantii
17473331 17473331 PRJNA915212_P_NODE_254_length_1256_cov_2.443248_g240_i0 PRJNA915212 254 1256 2.443248 30.68719488 root 1 Root_unresolved Root_unresolved 393 5.01e-127   NR PJE02932.1 178 g240 i0 54.7 16.1727707006369 419 172 99.8 7 1256 3 220 621 PJE02932.1 MAG: sodium-translocating pyrophosphatase [Leptospira sp.] diamond 20313 395 0.994936708860759 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptospira Leptospira sp.
28761407 28761407 PRJNA915212_P_NODE_11787_length_167_cov_0.864407_g11749_i0 PRJNA915212 11787 167 0.864407 1.44355969 Spirochaetota bacterium 2202144 Bacteria Bacteria 53.5 6.02e-7   NR MBP7901802.1 2202144 g11749 i0 54.2 0.862275449101796 48 20 86.2 1 14 157 103 148 MBP7901802.1 hypothetical protein [Spirochaetota bacterium] diamond 144 53.5 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
29393131 29393131 PRJNA915212_P_NODE_5669_length_249_cov_0.745000_g5631_i0 PRJNA915212 5669 249 0.745 1.85505 Treponema sp. 166 Bacteria Bacteria 53.9 2.59e-6   NR MBQ3670459.1 166 g5631 i0 44 1.83132530120482 50 28 60.2 0 187 38 163 212 MBQ3670459.1 CAP domain-containing protein [Treponema sp.] diamond 456 53.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31643570 31643570 PRJNA915212_P_NODE_236_length_1284_cov_3.009717_g222_i0 PRJNA915212 236 1284 3.009717 38.64476628 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 73.9 9.77e-11   NR MDR2632347.1 166 g222 i0 28.6 1.32009345794393 189 119 41.4 6 43 573 80 264 MDR2632347.1 CAP domain-containing protein [Treponema sp.] diamond 1695 73.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
32142663 32142663 PRJNA915212_P_NODE_1198_length_613_cov_2.260638_g1166_i0 PRJNA915212 1198 613 2.260638 13.85771094 Treponema sp. 166 Bacteria Bacteria 99.8 3.96e-22   NR MDR2304142.1 166 g1166 i0 41 4.22349102773246 173 84 80.3 5 494 3 7 170 MDR2304142.1 DUF2589 domain-containing protein [Treponema sp.] diamond 2589 99.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.

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