RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1199893" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1199893 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
6704578 6704578 PRJNA1199893_P_NODE_2106_length_659_cov_21.923208_g2033_i0 PRJNA1199893 2106 659 21.923208 144.47394072 Vibrio vulnificus 672 Bacteria Bacteria 72.4 8.06e-13   NR WP_224642647.1 672 g2033 i0 54.4 0.359635811836115 79 31 33.7 3 395 174 5 83 WP_224642647.1 hypothetical protein, partial [Vibrio vulnificus] diamond 237 72.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio vulnificus
28525478 28525478 PRJNA1199893_P_NODE_8727_length_323_cov_1.232000_g8652_i0 PRJNA1199893 8727 323 1.232 3.97936 Mariprofundaceae bacterium 2306050 Bacteria Bacteria 97.1 2.64e-21   NR HKI62304.1 2306050 g8652 i0 65.6 0.56656346749226 61 21 56.7 0 321 139 303 363 HKI62304.1 hypothetical protein [Mariprofundaceae bacterium] diamond 183 97.1 1 Bacteria   Pseudomonadati Pseudomonadota Candidatius Mariprofundia Mariprofundales Mariprofundaceae   Mariprofundaceae bacterium
29807039 29807039 PRJNA1199893_P_NODE_11171_length_286_cov_2.032864_g11096_i0 PRJNA1199893 11171 286 2.032864 5.81399104 Enterobacteriaceae 543 Bacteria Bacteria 157 3.12e-46   NR WP_317869804.1 573 g11096 i0 88.8 1.87762237762238 89 9 93.4 1 19 285 1 88 WP_317869804.1 Kunitz family serine protease inhibitor, partial [Klebsiella pneumoniae] diamond 537 157 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae

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