RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA575566" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA575566 · 6 ✖

analysis 1

  • diamond · 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
8213275 8213275 PRJNA575566_P_NODE_30467_length_188_cov_2.015748_g30270_i0 PRJNA575566 30467 188 2.015748 3.78960624 Firmicutes bacterium ADurb.Bin356 1852890 Bacteria Bacteria 102 3.02e-24   NR OQA16478.1 1852890 g30270 i0 82.3 0.98936170212766 62 11 98.9 0 186 1 244 305 OQA16478.1 MAG: Glyceraldehyde-3-phosphate dehydrogenase A [Firmicutes bacterium ADurb.Bin356] diamond 186 102 1 Bacteria   Bacillati Bacillota         Firmicutes bacterium ADurb.Bin356
26921340 26921340 PRJNA575566_P_NODE_28522_length_203_cov_0.901408_g28325_i0 PRJNA575566 28522 203 0.901408 1.82985824 Clostridium lundense 319475 Bacteria Bacteria 72.8 5.57e-13   NR WP_027623033.1 319475 g28325 i0 48.5 2.89655172413793 66 34 97.5 0 203 6 378 443 WP_027623033.1 pyridoxal phosphate-dependent decarboxylase family protein [Clostridium lundense] diamond 588 72.8 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium lundense
28311363 28311363 PRJNA575566_P_NODE_28186_length_203_cov_1.352113_g27989_i0 PRJNA575566 28186 203 1.352113 2.74478939 Lachnospira sp. 2049031 Bacteria Bacteria 46.2 0.00132   NR MCI8426399.1 2049031 g27989 i0 34.4 3.59113300492611 64 35 94.6 1 12 203 550 606 MCI8426399.1 DNA internalization-related competence protein ComEC/Rec2 [Lachnospira sp.] diamond 729 46.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Lachnospira Lachnospira sp.
29858307 29858307 PRJNA575566_P_NODE_21471_length_225_cov_1.853659_g21274_i0 PRJNA575566 21471 225 1.853659 4.17073275 Clostridia bacterium 2044939 Bacteria Bacteria 47.4 7.14e-4   NR MBQ7391938.1 2044939 g21274 i0 43.1 0.68 51 27 65.3 1 7 153 388 438 MBQ7391938.1 InlB B-repeat-containing protein [Clostridia bacterium] diamond 153 47.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
31090590 31090590 PRJNA575566_P_NODE_23735_length_211_cov_1.280000_g23538_i0 PRJNA575566 23735 211 1.28 2.7008 Bacillus kwashiorkori 1522318 Bacteria Bacteria 95.1 4.41e-21   NR WP_062350715.1 1522318 g23538 i0 62.3 1.97630331753555 69 26 98.1 0 207 1 91 159 WP_062350715.1 FAD/NAD(P)-binding oxidoreductase [Bacillus kwashiorkori] diamond 417 95.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus kwashiorkori
31578567 31578567 PRJNA575566_P_NODE_13836_length_283_cov_1.153153_g13639_i0 PRJNA575566 13836 283 1.153153 3.26342299 Bacilli 91061 Bacteria Bacteria 77 3.24e-14   NR MCA9766345.1 48221 g13639 i0 44.8 11.1519434628975 96 47 99.6 3 282 1 92 183 MCA9766345.1 inositol 2-dehydrogenase [Carnobacterium sp.] diamond 3156 77.4 0.994832041343669 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Carnobacteriaceae Carnobacterium Carnobacterium 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);;