RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA400391" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA400391 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27296691 27296691 PRJNA400391_S_NODE_6163_length_158_cov_0.943089_g6102_i0 PRJNA400391 6163 158 0.943089 1.49008062 Thermicanus aegyptius 94009 Bacteria Bacteria 89.4 4.42e-19   NR WP_028986432.1 94009 g6102 i0 78.8 0.987341772151899 52 11 98.7 0 3 158 728 779 WP_028986432.1 phenylalanine--tRNA ligase subunit beta [Thermicanus aegyptius] diamond 156 89.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
28433504 28433504 PRJNA400391_S_NODE_4566_length_187_cov_1.526316_g4505_i0 PRJNA400391 4566 187 1.526316 2.85421092 Paenibacillus alvei 44250 Bacteria Bacteria 42.4 0.00932   NR MBG9732894.1 44250 g4505 i0 58.3 1.18716577540107 36 15 57.8 0 47 154 77 112 MBG9732894.1 hypothetical protein [Paenibacillus alvei] diamond 222 42.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus alvei
29759396 29759396 PRJNA400391_S_NODE_4971_length_178_cov_1.811189_g4910_i0 PRJNA400391 4971 178 1.811189 3.22391642 Clostridiales bacterium 1898207 Bacteria Bacteria 41.6 0.00806   NR GAA6393130.1 1898207 g4910 i0 70.4 0.455056179775281 27 8 45.5 0 81 1 31 57 GAA6393130.1 hypothetical protein I4100191B2_06120 [Clostridiales bacterium] diamond 81 41.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales     Clostridiales bacterium
30265298 30265298 PRJNA400391_S_NODE_3472_length_216_cov_2.127072_g3411_i0 PRJNA400391 3472 216 2.127072 4.59447552 Bacillus sp. SRB_28 1969378 Bacteria Bacteria 65.1 5.78e-12   NR RAN86401.1 1969378 g3411 i0 97 0.458333333333333 33 1 45.8 0 5 103 14 46 RAN86401.1 hypothetical protein B5P41_29460 [Bacillus sp. SRB_28] diamond 99 65.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. SRB_28
30486211 30486211 PRJNA400391_S_NODE_6473_length_153_cov_1.483051_g6412_i0 PRJNA400391 6473 153 1.483051 2.26906803 Calditerricola sp. 2885161 Bacteria Bacteria 94 2.71e-23   NR HEY8342644.1 2885161 g6412 i0 83.3 1.88235294117647 48 8 94.1 0 151 8 62 109 HEY8342644.1 AAA family ATPase [Calditerricola sp.] diamond 288 94 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Calditerricola Calditerricola sp.
31339301 31339301 PRJNA400391_S_NODE_5876_length_162_cov_0.929134_g5815_i0 PRJNA400391 5876 162 0.929134 1.50519708 Paenibacillus ginsengarvi 400777 Bacteria Bacteria 87.8 1.13e-18   NR WP_120748240.1 400777 g5815 i0 79.2 1.96296296296296 53 11 98.1 0 3 161 248 300 WP_120748240.1 peptidase T [Paenibacillus ginsengarvi] diamond 318 87.8 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus ginsengarvi
32431808 32431808 PRJNA400391_S_NODE_6419_length_154_cov_1.109244_g6358_i0 PRJNA400391 6419 154 1.109244 1.70823576 Bacillota 1239 Bacteria Bacteria 64.3 1.44e-10   NR WP_052330125.1 94009 g6358 i0 61.5 2.02597402597403 52 17 99.4 2 153 1 183 232 WP_052330125.1 ComF family protein [Thermicanus aegyptius] diamond 312 64.3 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius

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