RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA692200" 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

  • PRJNA692200 · 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
9601093 9601093 PRJNA692200_S_NODE_15708_length_184_cov_3.696296_g15651_i0 PRJNA692200 15708 184 3.696296 6.80118464 root 1 Root_unresolved Root_unresolved 80.1 3.72e-18   NR MDK0835637.1 1502 g15651 i0 71.4 27.3260869565217 49 14 79.9 0 3 149 18 66 MDK0835637.1 peptidylprolyl isomerase [Clostridium perfringens] diamond 5028 80.9 0.990111248454882 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae Clostridium Clostridium perfringens
12152105 12152105 PRJNA692200_S_NODE_530_length_499_cov_145.008889_g497_i0 PRJNA692200 530 499 145.008889 723.59435611 Brevibacillus fulvus 1125967 Bacteria Bacteria 143 7.079999999999998e-41   NR WP_204516782.1 1125967 g497 i0 61.1 4.15430861723447 113 44 67.9 0 61 399 2 114 WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus] diamond 2073 143 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Brevibacillus Brevibacillus fulvus
27114000 27114000 PRJNA692200_S_NODE_13782_length_195_cov_1.267123_g13725_i0 PRJNA692200 13782 195 1.267123 2.47088985 Defluviitaleaceae bacterium 2660712 Bacteria Bacteria 41.6 0.0492   NR MCL2378803.1 2660712 g13725 i0 45.2 0.646153846153846 42 20 61.5 2 136 17 265 305 MCL2378803.1 hypothetical protein [Defluviitaleaceae bacterium] diamond 126 41.6 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Defluviitaleaceae   Defluviitaleaceae bacterium
27978269 27978269 PRJNA692200_S_NODE_4105_length_309_cov_1.507692_g4048_i0 PRJNA692200 4105 309 1.507692 4.65876828 Peptostreptococcus 1257 Bacteria Bacteria 112 2.28e-29   NR WP_002845271.1 1257 g4048 i0 58.9 7.96116504854369 90 37 87.4 0 5 274 32 121 WP_002845271.1 MULTISPECIES: RidA family protein [Peptostreptococcus] diamond 2460 112 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Peptostreptococcus  
28420522 28420522 PRJNA692200_S_NODE_726_length_472_cov_4.680851_g688_i0 PRJNA692200 726 472 4.680851 22.09361672 root 1 Root_unresolved Root_unresolved 47.4 8.05e-4   NR MER2170548.1 126157 g688 i0 46.2 0.889830508474576 52 27 32.4 1 208 56 1 52 MER2170548.1 hypothetical protein [Psychrobacillus psychrodurans] diamond 420 47.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Psychrobacillus Psychrobacillus psychrodurans
30335750 30335750 PRJNA692200_S_NODE_20272_length_166_cov_1.384615_g20215_i0 PRJNA692200 20272 166 1.384615 2.2984609 Lachnospiraceae bacterium 1898203 Bacteria Bacteria 46.2 7.85e-4   NR MCH4039956.1 1898203 g20215 i0 40 0.903614457831325 50 30 90.4 0 16 165 153 202 MCH4039956.1 glycosyltransferase [Lachnospiraceae bacterium] diamond 150 46.2 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae   Lachnospiraceae bacterium
32074129 32074129 PRJNA692200_S_NODE_9658_length_227_cov_1.612360_g9601_i0 PRJNA692200 9658 227 1.61236 3.6600572 Erysipelotrichaceae bacterium 2049044 Bacteria Bacteria 45.4 0.003   NR MEA5018092.1 2049044 g9601 i0 50 0.475770925110132 36 18 47.6 0 222 115 188 223 MEA5018092.1 dienelactone hydrolase family protein [Erysipelotrichaceae bacterium] diamond 108 45.4 1 Bacteria   Bacillati Bacillota Erysipelotrichia Erysipelotrichales Erysipelotrichaceae   Erysipelotrichaceae bacterium

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