RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA638138" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA638138 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
609261 609261 PRJNA638138_P_NODE_16081_length_274_cov_1.039801_g15866_i0 PRJNA638138 16081 274 1.039801 2.84905474 Murimonas intestini 1337051 Bacteria Bacteria 72.8 6.03e-15   NR WP_301546617.1 1337051 g15866 i0 71.7 0.503649635036496 46 13 50.4 0 84 221 1 46 WP_301546617.1 hypothetical protein [Murimonas intestini] diamond 138 72.8 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Murimonas Murimonas intestini
26985984 26985984 PRJNA638138_P_NODE_1162_length_842_cov_1.322497_g978_i0 PRJNA638138 1162 842 1.322497 11.13542474 Bacillus obstructivus 1914540 Bacteria Bacteria 46.6 0.00769   NR OJH16067.1 1914540 g978 i0 55.6 0.128266033254157 36 16 12.8 0 108 1 57 92 OJH16067.1 hypothetical protein BLX88_25585, partial [Bacillus obstructivus] diamond 108 46.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus obstructivus
27093439 27093439 PRJNA638138_P_NODE_2322_length_624_cov_1.381125_g2111_i0 PRJNA638138 2322 624 1.381125 8.61822 Bacillota 1239 Bacteria Bacteria 85.9 3.82e-18   NR WP_220377383.1 1280 g2111 i0 68.9 0.879807692307692 61 19 29.3 0 234 416 4 64 WP_220377383.1 hypothetical protein, partial [Staphylococcus aureus] diamond 549 85.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
27554704 27554704 PRJNA638138_P_NODE_33704_length_242_cov_0.911243_g33489_i0 PRJNA638138 33704 242 0.911243 2.20520806 uncultured Parvimonas sp. 747372 Bacteria Bacteria 42.7 0.0281   NR WP_313961479.1 747372 g33489 i0 52.9 0.421487603305785 34 16 42.1 0 62 163 149 182 WP_313961479.1 helix-turn-helix domain-containing protein [uncultured Parvimonas sp.] diamond 102 42.7 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Parvimonas uncultured Parvimonas sp.
28249405 28249405 PRJNA638138_P_NODE_36106_length_241_cov_0.880952_g35891_i0 PRJNA638138 36106 241 0.880952 2.12309432 Clostridia bacterium 2044939 Bacteria Bacteria 43.9 0.0131   NR MBQ8374131.1 2044939 g35891 i0 35.7 0.871369294605809 70 32 74.7 2 188 9 181 247 MBQ8374131.1 prolipoprotein diacylglyceryl transferase [Clostridia bacterium] diamond 210 43.9 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28754767 28754767 PRJNA638138_P_NODE_27347_length_246_cov_0.890173_g27132_i0 PRJNA638138 27347 246 0.890173 2.18982558 Clostridia bacterium 2044939 Bacteria Bacteria 42.4 0.0498   NR MBQ8313234.1 2044939 g27132 i0 43.8 0.585365853658537 48 27 58.5 0 35 178 91 138 MBQ8313234.1 ATP-binding cassette domain-containing protein [Clostridia bacterium] diamond 144 42.4 1 Bacteria   Bacillati Bacillota Clostridia       Clostridia bacterium
28849282 28849282 PRJNA638138_P_NODE_6588_length_389_cov_0.924051_g6373_i0 PRJNA638138 6588 389 0.924051 3.59455839 Aerococcus urinae 1376 Bacteria Bacteria 62.4 4.29e-10   NR WP_284784852.1 1376 g6373 i0 54.2 0.370179948586118 48 22 37 0 152 9 20 67 WP_284784852.1 hypothetical protein, partial [Aerococcus urinae] diamond 144 62.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Aerococcaceae Aerococcus Aerococcus urinae
29638462 29638462 PRJNA638138_P_NODE_19010_length_251_cov_1.657303_g18795_i0 PRJNA638138 19010 251 1.657303 4.15983053 Candidatus Alectryocaccobium stercorigallinarum 2840667 Bacteria Bacteria 42.7 0.0322   NR HIV17152.1 2840667 g18795 i0 48.9 0.537848605577689 45 20 50.2 1 28 153 79 123 HIV17152.1 flavodoxin family protein [Candidatus Alectryocaccobium stercorigallinarum] diamond 135 42.7 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales   Candidatus Alectryocaccobium Candidatus Alectryocaccobium stercorigallinarum
29638464 29638464 PRJNA638138_P_NODE_32090_length_243_cov_0.905882_g31875_i0 PRJNA638138 32090 243 0.905882 2.20129326 Bacillus subtilis 1423 Bacteria Bacteria 65.9 4.16e-12   NR WP_326066412.1 1423 g31875 i0 54.7 0.790123456790123 64 29 79 0 235 44 3 66 WP_326066412.1 hypothetical protein, partial [Bacillus subtilis] diamond 192 65.9 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus subtilis
30238963 30238963 PRJNA638138_P_NODE_5652_length_415_cov_0.959064_g5437_i0 PRJNA638138 5652 415 0.959064 3.9801156 Paenibacillus sp. GCM1 58172 Bacteria Bacteria 41.2 0.0493   NR WP_379205552.1 3317342 g5437 i0 41.5 0.296385542168675 41 24 29.6 0 325 203 4 44 WP_379205552.1 hypothetical protein [Paenibacillus sp. GCM10012306] diamond 123 41.2 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus sp. GCM10012306
30523283 30523283 PRJNA638138_P_NODE_10213_length_329_cov_0.820312_g9998_i0 PRJNA638138 10213 329 0.820312 2.69882648 Enterococcus faecium 1352 Bacteria Bacteria 47.4 4.58e-4   NR WP_163311100.1 1352 g9998 i0 64 0.455927051671733 50 18 45.6 0 176 325 5 54 WP_163311100.1 hypothetical protein, partial [Enterococcus faecium] diamond 150 47.4 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Enterococcaceae Enterococcus Enterococcus faecium
31029094 31029094 PRJNA638138_P_NODE_32415_length_243_cov_0.905882_g32200_i0 PRJNA638138 32415 243 0.905882 2.20129326 Aerococcus urinae 1376 Bacteria Bacteria 40 0.0449   NR WP_284880770.1 1376 g32200 i0 57.7 0.320987654320988 26 11 32.1 0 162 239 18 43 WP_284880770.1 hypothetical protein, partial [Aerococcus urinae] diamond 78 40 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Aerococcaceae Aerococcus Aerococcus urinae
31294140 31294140 PRJNA638138_P_NODE_29895_length_244_cov_0.900585_g29680_i0 PRJNA638138 29895 244 0.900585 2.1974274 Bacteria 2 Bacteria Bacteria 72 1.53e-12   NR EEK75686.1 526968 g29680 i0 57.1 3.77459016393443 77 33 94.7 0 1 231 270 346 EEK75686.1 hypothetical protein bcere0009_54610 [Bacillus cereus R309803] diamond 921 72 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus cereus
31724434 31724434 PRJNA638138_P_NODE_16977_length_267_cov_1.061856_g16762_i0 PRJNA638138 16977 267 1.061856 2.83515552 Alicyclobacillus herbarius 122960 Bacteria Bacteria 42.7 0.05   NR WP_026962601.1 122960 g16762 i0 42.6 0.528089887640449 47 26 52.8 1 33 173 73 118 WP_026962601.1 alpha-L-rhamnosidase [Alicyclobacillus herbarius] diamond 141 42.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Alicyclobacillaceae Alicyclobacillus Alicyclobacillus herbarius

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