RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA1010662", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 7 ✖

tax_kingdom 1

  • Pseudomonadati · 7 ✖

bioproject 1

  • PRJNA1010662 · 7 ✖

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
2276580 2276580 PRJNA1010662_P_NODE_14842_length_165_cov_0.887931_g14783_i0 PRJNA1010662 14842 165 0.887931 1.46508615 Spirochaetales bacterium 2026792 Bacteria Bacteria 77.4 7.61e-15   NR MBN2535219.1 2026792 g14783 i0 71.4 7.45454545454545 49 14 89.1 0 148 2 646 694 MBN2535219.1 pyruvate, phosphate dikinase [Spirochaetales bacterium] diamond 1230 77.4 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
21831728 21831728 PRJNA1010662_P_NODE_8178_length_199_cov_1.380000_g8119_i0 PRJNA1010662 8178 199 1.38 2.7462 Spirochaetota bacterium 2202144 Bacteria Bacteria 112 3.47e-27   NR HPY04359.1 2202144 g8119 i0 77.3 3.97989949748744 66 15 99.5 0 199 2 41 106 HPY04359.1 glucose-6-phosphate isomerase [Spirochaetota bacterium] diamond 792 112 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetota bacterium
27729891 27729891 PRJNA1010662_P_NODE_14704_length_165_cov_0.896552_g14645_i0 PRJNA1010662 14704 165 0.896552 1.4793108 Marispirochaeta aestuarii 1963862 Bacteria Bacteria 100 6.03e-23   NR WP_083048245.1 1963862 g14645 i0 80 4 55 11 100 0 1 165 227 281 WP_083048245.1 glutamate synthase large subunit [Marispirochaeta aestuarii] diamond 660 100 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Spirochaetaceae Marispirochaeta Marispirochaeta aestuarii
28455899 28455899 PRJNA1010662_P_NODE_6886_length_212_cov_1.668712_g6827_i0 PRJNA1010662 6886 212 1.668712 3.53766944 Spirochaetales bacterium 2026792 Bacteria Bacteria 52.8 6.38e-6   NR MBI9103804.1 2026792 g6827 i0 39.7 0.891509433962264 63 32 89.2 1 189 1 2 58 MBI9103804.1 hemerythrin family protein [Spirochaetales bacterium] diamond 189 52.8 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales     Spirochaetales bacterium
29553074 29553074 PRJNA1010662_P_NODE_8210_length_199_cov_1.246667_g8151_i0 PRJNA1010662 8210 199 1.246667 2.48086733 Bacteria 2 Bacteria Bacteria 73.9 1.88e-13   NR MBR6080652.1 166 g8151 i0 54.7 18.572864321608 53 24 79.9 0 8 166 301 353 MBR6080652.1 elongation factor Tu [Treponema sp.] diamond 3696 73.9 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae Treponema Treponema sp.
31772817 31772817 PRJNA1010662_P_NODE_3937_length_264_cov_2.888372_g3878_i0 PRJNA1010662 3937 264 2.888372 7.62530208 Turneriella sp. 2717305 Bacteria Bacteria 63.2 3.07e-9   NR MFO1471830.1 2717305 g3878 i0 39.5 2.03409090909091 81 49 92 0 264 22 235 315 MFO1471830.1 saccharopine dehydrogenase NADP-binding domain-containing protein [Turneriella sp.] diamond 537 63.2 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Turneriella Turneriella sp.
32018475 32018475 PRJNA1010662_P_NODE_5858_length_225_cov_1.778409_g5799_i0 PRJNA1010662 5858 225 1.778409 4.00142025 root 1 Root_unresolved Root_unresolved 132 1.14e-33   NR OHD57800.1 1802189 g5799 i0 83.8 19.7466666666667 74 12 98.7 0 223 2 214 287 OHD57800.1 MAG: pyruvate, phosphate dikinase [Spirochaetes bacterium GWF1_49_6] diamond 4443 132 1 Bacteria   Pseudomonadati Spirochaetota         Spirochaetes bacterium GWF1_49_6

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