RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1237347" and tax_phylum = "Deferribacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deferribacterota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1237347 · 3 ✖

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
9977879 9977879 PRJNA1237347_P_NODE_99608_length_683_cov_2.090164_g93226_i0 PRJNA1237347 99608 683 2.090164 14.27582012 Pseudomonadati 3379134 Bacteria Bacteria 189 1.4899999999999995e-55   NR WP_303852680.1 1078050 g93226 i0 43.4 1.99414348462665 226 128 99.3 0 680 3 4 229 WP_303852680.1 IS3 family transposase [Seleniivibrio woodruffii] diamond 1362 189 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Geovibrionaceae Seleniivibrio Seleniivibrio woodruffii
29567460 29567460 PRJNA1237347_P_NODE_200370_length_433_cov_1.494444_g193798_i0 PRJNA1237347 200370 433 1.494444 6.47094252 Mucispirillum sp. 1965235 Bacteria Bacteria 57.4 2.07e-6   NR MDT3694183.1 1965235 g193798 i0 33.3 1.48267898383372 117 72 78.3 3 341 3 358 472 MDT3694183.1 hypothetical protein [Mucispirillum sp.] diamond 642 57.4 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Mucispirillaceae Mucispirillum Mucispirillum sp.
30104784 30104784 PRJNA1237347_P_NODE_488532_length_249_cov_0.875000_g481959_i0 PRJNA1237347 488532 249 0.875 2.17875 Deferrivibrio essentukiensis 2880922 Bacteria Bacteria 45.8 0.00319   NR WP_242819045.1 2880922 g481959 i0 36.4 0.795180722891566 66 42 79.5 0 9 206 232 297 WP_242819045.1 tetratricopeptide repeat protein [Deferrivibrio essentukiensis] diamond 198 45.8 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Deferrivibrionaceae Deferrivibrio Deferrivibrio essentukiensis

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