contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1004255" and tax_phylum = "Bacillota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14181948 | 14181948 | PRJNA1004255_S_NODE_3292_length_303_cov_2.892308_g3084_i0 | PRJNA1004255 | 3292 | 303 | 2.892308 | 8.76369324 | Anaerococcus | 165779 | Bacteria | Bacteria | 191 | 5.55e-58 | NR | WP_101539319.1 | 165779 | g3084 | i0 | 94.1 | 1 | 101 | 6 | 100 | 0 | 303 | 1 | 79 | 179 | WP_101539319.1 MULTISPECIES: electron transfer flavoprotein subunit alpha/FixB family protein [Anaerococcus] | diamond | 303 | 191 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Anaerococcus | |||
| 27287315 | 27287315 | PRJNA1004255_S_NODE_14103_length_172_cov_11.449612_g13895_i0 | PRJNA1004255 | 14103 | 172 | 11.449612 | 19.69333264 | Tissierellia bacterium | 2049431 | Bacteria | Bacteria | 82 | 1.25e-16 | NR | NLW43105.1 | 2049431 | g13895 | i0 | 67.9 | 2.93023255813953 | 56 | 18 | 97.7 | 0 | 170 | 3 | 59 | 114 | NLW43105.1 undecaprenyldiphospho-muramoylpentapeptide beta-N-acetylglucosaminyltransferase [Tissierellia bacterium] | diamond | 504 | 82 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellia bacterium | |||||
| 27824345 | 27824345 | PRJNA1004255_S_NODE_2444_length_334_cov_5.707904_g2236_i0 | PRJNA1004255 | 2444 | 334 | 5.707904 | 19.06439936 | Blautia sp. An46 | 1965636 | Bacteria | Bacteria | 201 | 1.04e-61 | NR | WP_242971269.1 | 1965636 | g2236 | i0 | 96.4 | 0.997005988023952 | 111 | 4 | 99.7 | 0 | 334 | 2 | 12 | 122 | WP_242971269.1 DUF5979 domain-containing protein [Blautia sp. An46] | diamond | 333 | 201 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Blautia | Blautia sp. An46 | ||
| 29560574 | 29560574 | PRJNA1004255_S_NODE_18090_length_153_cov_3.418182_g17882_i0 | PRJNA1004255 | 18090 | 153 | 3.418182 | 5.22981846 | Paenibacillus polymyxa SC2 | 886882 | Bacteria | Bacteria | 46.6 | 2.64e-4 | NR | ADO59525.2 | 886882 | g17882 | i0 | 67.7 | 2.58823529411765 | 31 | 9 | 60.8 | 1 | 94 | 2 | 110 | 139 | ADO59525.2 hypothetical protein PPSC2_27470 [Paenibacillus polymyxa SC2] | diamond | 396 | 46.6 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | Paenibacillus polymyxa | ||
| 30097544 | 30097544 | PRJNA1004255_S_NODE_11632_length_188_cov_2.268966_g11424_i0 | PRJNA1004255 | 11632 | 188 | 2.268966 | 4.26565608 | Peptoniphilus sp. | 1971214 | Bacteria | Bacteria | 94.7 | 8.720000000000001e-21 | NR | WP_412446334.1 | 1971214 | g11424 | i0 | 89.3 | 0.893617021276596 | 56 | 6 | 89.4 | 0 | 170 | 3 | 721 | 776 | WP_412446334.1 S-layer homology domain-containing protein [Peptoniphilus sp.] | diamond | 168 | 94.7 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Peptoniphilus | Peptoniphilus sp. | ||
| 30097545 | 30097545 | PRJNA1004255_S_NODE_14512_length_170_cov_6.259843_g14304_i0 | PRJNA1004255 | 14512 | 170 | 6.259843 | 10.6417331 | Hominiventricola aquisgranensis | 3133164 | Bacteria | Bacteria | 63.5 | 1.76e-10 | NR | WP_349144885.1 | 3133164 | g14304 | i0 | 100 | 0.547058823529412 | 31 | 0 | 54.7 | 0 | 78 | 170 | 1 | 31 | WP_349144885.1 hypothetical protein [Hominiventricola aquisgranensis] | diamond | 93 | 63.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Hominiventricola | Hominiventricola aquisgranensis | ||
| 30160604 | 30160604 | PRJNA1004255_S_NODE_14572_length_170_cov_3.259843_g14364_i0 | PRJNA1004255 | 14572 | 170 | 3.259843 | 5.5417331 | Finegoldia magna | 1260 | Bacteria | Bacteria | 103 | 3.819999999999999e-24 | NR | WP_412646238.1 | 1260 | g14364 | i0 | 78.6 | 1.97647058823529 | 56 | 12 | 98.8 | 0 | 169 | 2 | 680 | 735 | WP_412646238.1 DEAD/DEAH box helicase family protein [Finegoldia magna] | diamond | 336 | 103 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Finegoldia | Finegoldia magna | ||
| 30563831 | 30563831 | PRJNA1004255_S_NODE_12513_length_182_cov_2.280576_g12305_i0 | PRJNA1004255 | 12513 | 182 | 2.280576 | 4.15064832 | Veillonella | 29465 | Bacteria | Bacteria | 47.8 | 1.24e-4 | NR | ETJ17454.1 | 1403932 | g12305 | i0 | 54.5 | 2.12637362637363 | 44 | 20 | 72.5 | 0 | 50 | 181 | 107 | 150 | ETJ17454.1 MAG: hypothetical protein Q620_VSAC00705G0001, partial [Veillonella sp. DORA_A_3_16_22] | diamond | 387 | 47.8 | 1 | Bacteria | Bacillati | Bacillota | Negativicutes | Veillonellales | Veillonellaceae | Veillonella | Veillonella sp. DORA_A_3_16_22 | ||
| 30855912 | 30855912 | PRJNA1004255_S_NODE_8934_length_211_cov_1.958333_g8726_i0 | PRJNA1004255 | 8934 | 211 | 1.958333 | 4.13208263 | Clostridium polynesiense | 1325933 | Bacteria | Bacteria | 133 | 2.51e-35 | NR | WP_040212244.1 | 1325933 | g8726 | i0 | 92.9 | 0.995260663507109 | 70 | 5 | 99.5 | 0 | 211 | 2 | 33 | 102 | WP_040212244.1 ATP-dependent Clp protease ATP-binding subunit ClpX [Clostridium polynesiense] | diamond | 210 | 133 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium polynesiense | ||
| 30919309 | 30919309 | PRJNA1004255_S_NODE_4274_length_278_cov_2.000000_g4066_i0 | PRJNA1004255 | 4274 | 278 | 2 | 5.56 | Anaerococcus | 165779 | Bacteria | Bacteria | 72 | 3.59e-13 | NR | WP_219350665.1 | 165779 | g4066 | i0 | 100 | 0.399280575539568 | 37 | 0 | 39.9 | 0 | 278 | 168 | 73 | 109 | WP_219350665.1 MULTISPECIES: hypothetical protein [Anaerococcus] | diamond | 111 | 72 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Anaerococcus | |||
| 31139928 | 31139928 | PRJNA1004255_S_NODE_5735_length_250_cov_5.246377_g5527_i0 | PRJNA1004255 | 5735 | 250 | 5.246377 | 13.1159425 | Staphylococcus sp. GDB8P25P | 2804446 | Bacteria | Bacteria | 41.2 | 0.0216 | NR | WP_204254755.1 | 2804446 | g5527 | i0 | 58.8 | 0.408 | 34 | 13 | 40.8 | 1 | 103 | 2 | 1 | 33 | WP_204254755.1 hypothetical protein, partial [Staphylococcus sp. GDB8P25P] | diamond | 102 | 41.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus sp. GDB8P25P | ||
| 31203030 | 31203030 | PRJNA1004255_S_NODE_18155_length_153_cov_1.709091_g17947_i0 | PRJNA1004255 | 18155 | 153 | 1.709091 | 2.61490923 | Tissierellia bacterium | 2049431 | Bacteria | Bacteria | 79.7 | 6.75e-16 | NR | NLD17735.1 | 2049431 | g17947 | i0 | 77.1 | 0.941176470588235 | 48 | 11 | 94.1 | 0 | 151 | 8 | 17 | 64 | NLD17735.1 undecaprenyldiphospho-muramoylpentapeptide beta-N-acetylglucosaminyltransferase [Tissierellia bacterium] | diamond | 144 | 79.7 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellia bacterium | |||||
| 32089200 | 32089200 | PRJNA1004255_S_NODE_16478_length_160_cov_2.726496_g16270_i0 | PRJNA1004255 | 16478 | 160 | 2.726496 | 4.3623936 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 41.6 | 0.0277 | NR | MBP5467126.1 | 2044939 | g16270 | i0 | 48.7 | 0.73125 | 39 | 16 | 65.6 | 1 | 47 | 151 | 40 | 78 | MBP5467126.1 SGNH/GDSL hydrolase family protein [Clostridia bacterium] | diamond | 117 | 41.6 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;