RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1156092" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1156092 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
27229880 27229880 PRJNA1156092_P_NODE_11983_length_328_cov_1.137255_g11853_i0 PRJNA1156092 11983 328 1.137255 3.7301964 Epulopiscium sp. Nele67-Bin 3100283 Bacteria Bacteria 47.8 1.49e-4   NR OON95515.1 1764963 g11853 i0 53.7 0.375 41 19 37.5 0 291 169 29 69 OON95515.1 MAG: hypothetical protein ATN36_08125 [Epulopiscium sp. Nele67-Bin005] diamond 123 47.8 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Candidatus Epulonipiscium Epulopiscium sp. Nele67-Bin005
28524778 28524778 PRJNA1156092_P_NODE_13427_length_314_cov_1.178423_g13297_i0 PRJNA1156092 13427 314 1.178423 3.70024822 Epulopiscium sp. Nele67-Bin 3100283 Bacteria Bacteria 75.9 1.22e-15   NR OON95515.1 1764963 g13297 i0 57.4 0.64968152866242 68 29 65 0 204 1 1 68 OON95515.1 MAG: hypothetical protein ATN36_08125 [Epulopiscium sp. Nele67-Bin005] diamond 204 75.9 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Candidatus Epulonipiscium Epulopiscium sp. Nele67-Bin005
28524789 28524789 PRJNA1156092_P_NODE_25967_length_247_cov_0.885057_g25837_i0 PRJNA1156092 25967 247 0.885057 2.18609079 Dialister sp. 1955814 Bacteria Bacteria 160 1.44e-43   NR MDU5282021.1 1955814 g25837 i0 100 0.995951417004049 82 0 99.6 0 246 1 192 273 MDU5282021.1 carbamoyl-phosphate synthase large subunit [Dialister sp.] diamond 246 160 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Dialister Dialister sp.
29882578 29882578 PRJNA1156092_P_NODE_24471_length_249_cov_0.875000_g24341_i0 PRJNA1156092 24471 249 0.875 2.17875 Peptoniphilus grossensis 1465756 Bacteria Bacteria 150 2.23e-43   NR WP_311565724.1 1465756 g24341 i0 91.6 2 83 7 100 0 249 1 55 137 WP_311565724.1 YidC/Oxa1 family membrane protein insertase [Peptoniphilus grossensis] diamond 498 150 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus grossensis
30040292 30040292 PRJNA1156092_P_NODE_2051_length_681_cov_1.506579_g1926_i0 PRJNA1156092 2051 681 1.506579 10.25980299 Epulopiscium sp. SCG-B1 3100283 Bacteria Bacteria 388 1.2899999999999996e-134   NR ONI46962.1 1712379 g1926 i0 95.3 0.837004405286344 190 9 83.7 0 572 3 1 190 ONI46962.1 hypothetical protein AN642_00410 [Epulopiscium sp. SCG-B10WGA-EpuloA2] diamond 570 388 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Candidatus Epulonipiscioides Candidatus Epulonipiscioides gigas
30166544 30166544 PRJNA1156092_P_NODE_3532_length_536_cov_1.161987_g3403_i0 PRJNA1156092 3532 536 1.161987 6.22825032 Epulopiscium sp. Nele67-Bin 3100283 Bacteria Bacteria 74.3 4.74e-14   NR OON95515.1 1764963 g3403 i0 52.6 0.425373134328358 76 36 42.5 0 532 305 1 76 OON95515.1 MAG: hypothetical protein ATN36_08125 [Epulopiscium sp. Nele67-Bin005] diamond 228 74.3 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Candidatus Epulonipiscium Epulopiscium sp. Nele67-Bin005
30281307 30281307 PRJNA1156092_P_NODE_9632_length_356_cov_1.088339_g9502_i0 PRJNA1156092 9632 356 1.088339 3.87448684 Bacillus 1386 Bacteria Bacteria 139 3.3499999999999996e-37   NR KND06263.1 1648923 g9502 i0 61.3 19.8286516853933 111 42 92.7 1 2 331 233 343 KND06263.1 hypothetical protein ACJ43_18015, partial [Bacillus paralicheniformis] diamond 7059 139 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus paralicheniformis
30545831 30545831 PRJNA1156092_P_NODE_27773_length_245_cov_12.226744_g27643_i0 PRJNA1156092 27773 245 12.226744 29.9555228 Staphylococcus aureus 1280 Bacteria Bacteria 53.1 5.06e-7   NR WP_206512634.1 1280 g27643 i0 69.7 0.404081632653061 33 10 40.4 0 146 244 2 34 WP_206512634.1 hypothetical protein, partial [Staphylococcus aureus] diamond 99 53.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30703758 30703758 PRJNA1156092_P_NODE_4614_length_478_cov_6.239506_g4485_i0 PRJNA1156092 4614 478 6.239506 29.82483868 Staphylococcus aureus 1280 Bacteria Bacteria 80.1 1.71e-16   NR WP_206512634.1 1280 g4485 i0 78.7 0.294979079497908 47 10 29.5 0 1 141 19 65 WP_206512634.1 hypothetical protein, partial [Staphylococcus aureus] diamond 141 80.1 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30925204 30925204 PRJNA1156092_P_NODE_1294_length_814_cov_27.743590_g1190_i0 PRJNA1156092 1294 814 27.74359 225.8328226 Staphylococcus aureus 1280 Bacteria Bacteria 99.4 1.05e-22   NR WP_206512634.1 1280 g1190 i0 69.1 0.250614250614251 68 17 25.1 1 483 280 1 64 WP_206512634.1 hypothetical protein, partial [Staphylococcus aureus] diamond 204 99.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
30956767 30956767 PRJNA1156092_P_NODE_4934_length_464_cov_2.460358_g4805_i0 PRJNA1156092 4934 464 2.460358 11.41606112 Staphylococcus aureus 1280 Bacteria Bacteria 103 9.01e-26   NR WP_206512634.1 1280 g4805 i0 72.3 0.420258620689655 65 18 42 0 213 407 1 65 WP_206512634.1 hypothetical protein, partial [Staphylococcus aureus] diamond 195 103 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus
31019831 31019831 PRJNA1156092_P_NODE_21255_length_255_cov_1.109890_g21125_i0 PRJNA1156092 21255 255 1.10989 2.8302195 Epulopiscium sp. SCG-B1 3100283 Bacteria Bacteria 107 2.49e-26   NR ONI46962.1 1712379 g21125 i0 94.5 2.58823529411765 55 3 64.7 0 1 165 192 246 ONI46962.1 hypothetical protein AN642_00410 [Epulopiscium sp. SCG-B10WGA-EpuloA2] diamond 660 107 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Candidatus Epulonipiscioides Candidatus Epulonipiscioides gigas
31208903 31208903 PRJNA1156092_P_NODE_9715_length_355_cov_0.882979_g9585_i0 PRJNA1156092 9715 355 0.882979 3.13457545 Paenibacillus xanthanilyticus 1783531 Bacteria Bacteria 44.7 0.00755   NR WP_377722673.1 1783531 g9585 i0 36.2 2.70422535211268 69 36 57.5 3 119 322 61 122 WP_377722673.1 DUF6463 family protein [Paenibacillus xanthanilyticus] diamond 960 44.7 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Paenibacillaceae Paenibacillus Paenibacillus xanthanilyticus
31557504 31557504 PRJNA1156092_P_NODE_18756_length_272_cov_1.160804_g18626_i0 PRJNA1156092 18756 272 1.160804 3.15738688 Clostridiaceae bacterium 1898204 Bacteria Bacteria 81.6 1.05e-15   NR NLD49962.1 1898204 g18626 i0 54.2 6.41911764705882 83 35 88.2 2 4 243 26 108 NLD49962.1 DUF3369 domain-containing protein [Clostridiaceae bacterium] diamond 1746 81.6 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Clostridiaceae   Clostridiaceae bacterium
32443405 32443405 PRJNA1156092_P_NODE_739_length_1029_cov_1.182008_g656_i0 PRJNA1156092 739 1029 1.182008 12.16286232 Epulopiscium sp. Nele67-Bin 3100283 Bacteria Bacteria 90.1 1.1e-18   NR OON95515.1 1764963 g656 i0 59.2 0.221574344023324 76 31 22.2 0 709 936 1 76 OON95515.1 MAG: hypothetical protein ATN36_08125 [Epulopiscium sp. Nele67-Bin005] diamond 228 90.1 1 Bacteria   Bacillati Bacillota Clostridia Lachnospirales Lachnospiraceae Candidatus Epulonipiscium Epulopiscium sp. Nele67-Bin005
32526134 32526134 PRJNA1156092_P_NODE_26179_length_247_cov_0.885057_g26049_i0 PRJNA1156092 26179 247 0.885057 2.18609079 Thermicanus 94008 Bacteria Bacteria 144 2.49e-38   NR WP_028986526.1 94009 g26049 i0 88.9 1.96761133603239 81 9 98.4 0 1 243 139 219 WP_028986526.1 ABC transporter transmembrane domain-containing protein [Thermicanus aegyptius] diamond 486 144 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillales Family X. Incertae Sedis Thermicanus Thermicanus aegyptius
32538244 32538244 PRJNA1156092_P_NODE_30919_length_242_cov_1.514793_g30789_i0 PRJNA1156092 30919 242 1.514793 3.66579906 Eubacterium brachy ATCC 33 35517 Bacteria Bacteria 62 4.7e-9   NR ESE31616.1 1321814 g30789 i0 100 0.371900826446281 30 0 37.2 0 92 3 1 30 ESE31616.1 hypothetical protein HMPREF9089_00082 [Eubacterium brachy ATCC 33089] diamond 90 62 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Anaerovoracaceae   [Eubacterium] brachy
32569933 32569933 PRJNA1156092_P_NODE_13079_length_317_cov_1.250000_g12949_i0 PRJNA1156092 13079 317 1.25 3.9625 Bacillus pumilus 1408 Bacteria Bacteria 108 1.97e-27   NR WP_282067001.1 1408 g12949 i0 100 0.936908517350158 50 0 47.3 0 167 316 1 50 WP_282067001.1 hypothetical protein [Bacillus pumilus] diamond 297 108 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus pumilus
32569950 32569950 PRJNA1156092_P_NODE_29339_length_244_cov_0.900585_g29209_i0 PRJNA1156092 29339 244 0.900585 2.1974274 Bacillus pumilus 1408 Bacteria Bacteria 161 9.38e-45   NR WP_111911101.1 1408 g29209 i0 97.5 0.983606557377049 80 2 98.4 0 3 242 452 531 WP_111911101.1 hypothetical protein [Bacillus pumilus] diamond 240 161 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus pumilus
32601195 32601195 PRJNA1156092_P_NODE_20540_length_260_cov_1.101604_g20410_i0 PRJNA1156092 20540 260 1.101604 2.8641704 Staphylococcus aureus 1280 Bacteria Bacteria 77.4 1.67e-16   NR WP_206512634.1 1280 g20410 i0 67.2 0.669230769230769 58 19 66.9 0 3 176 21 78 WP_206512634.1 hypothetical protein, partial [Staphylococcus aureus] diamond 174 77.4 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Staphylococcaceae Staphylococcus Staphylococcus aureus

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