contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA416866" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26917393 | 26917393 | PRJNA416866_P_NODE_11202_length_203_cov_0.901408_g11058_i0 | PRJNA416866 | 11202 | 203 | 0.901408 | 1.82985824 | Candidatus Mediterraneibacter norwichensis | 2838680 | Bacteria | Bacteria | 47 | 6.74e-4 | NR | HIV52785.1 | 2838680 | g11058 | i0 | 51 | 1.49261083743842 | 49 | 24 | 72.4 | 0 | 7 | 153 | 257 | 305 | HIV52785.1 L-lactate dehydrogenase [Candidatus Mediterraneibacter norwichensis] | diamond | 303 | 47 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Mediterraneibacter | Candidatus Mediterraneibacter norwichensis | ||
| 27928446 | 27928446 | PRJNA416866_P_NODE_9085_length_213_cov_1.335526_g8941_i0 | PRJNA416866 | 9085 | 213 | 1.335526 | 2.84467038 | Mordavella massiliensis | 1871024 | Bacteria | Bacteria | 43.1 | 0.0188 | NR | WP_204909920.1 | 1871024 | g8941 | i0 | 29.5 | 1.73239436619718 | 61 | 42 | 85.9 | 1 | 201 | 19 | 295 | 354 | WP_204909920.1 lipopolysaccharide biosynthesis protein [Mordavella massiliensis] | diamond | 369 | 43.1 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Mordavella | Mordavella massiliensis | ||
| 28481822 | 28481822 | PRJNA416866_P_NODE_9286_length_211_cov_1.273333_g9142_i0 | PRJNA416866 | 9286 | 211 | 1.273333 | 2.68673263 | root | 1 | Root_unresolved | Root_unresolved | 43.5 | 0.0128 | NR | WP_063383612.1 | 1455 | g9142 | i0 | 37.7 | 2.77251184834123 | 61 | 36 | 83.9 | 1 | 190 | 14 | 63 | 123 | WP_063383612.1 sensor histidine kinase [Bacillus badius] | diamond | 585 | 43.9 | 0.990888382687927 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Pseudobacillus | Pseudobacillus badius | ||
| 29160031 | 29160031 | PRJNA416866_P_NODE_1589_length_552_cov_1.289206_g1448_i0 | PRJNA416866 | 1589 | 552 | 1.289206 | 7.11641712 | Clostridiaceae bacterium | 1898204 | Bacteria | Bacteria | 51.2 | 1.64e-4 | NR | NLF37365.1 | 1898204 | g1448 | i0 | 24.3 | 0.625 | 115 | 76 | 56.5 | 2 | 516 | 205 | 5 | 119 | NLF37365.1 GNAT family N-acetyltransferase [Clostridiaceae bacterium] | diamond | 345 | 51.2 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridiaceae bacterium | |||
| 29475244 | 29475244 | PRJNA416866_P_NODE_9470_length_209_cov_0.864865_g9326_i0 | PRJNA416866 | 9470 | 209 | 0.864865 | 1.80756785 | Streptococcus rubneri | 1234680 | Bacteria | Bacteria | 139 | 3.039999999999999e-38 | NR | WP_195563958.1 | 1234680 | g9326 | i0 | 100 | 0.976076555023923 | 68 | 0 | 97.6 | 0 | 207 | 4 | 245 | 312 | WP_195563958.1 hypothetical protein [Streptococcus rubneri] | diamond | 204 | 139 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus rubneri | ||
| 29507023 | 29507023 | PRJNA416866_P_NODE_10990_length_204_cov_0.895105_g10846_i0 | PRJNA416866 | 10990 | 204 | 0.895105 | 1.8260142 | Fusibacter sp. | 2004507 | Bacteria | Bacteria | 82 | 2.32e-16 | NR | HSN67109.1 | 2004507 | g10846 | i0 | 58.2 | 0.985294117647059 | 67 | 28 | 98.5 | 0 | 2 | 202 | 164 | 230 | HSN67109.1 transposase family protein [Fusibacter sp.] | diamond | 201 | 82 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Eubacteriales Family XII. Incertae Sedis | Fusibacter | Fusibacter sp. | ||
| 29727864 | 29727864 | PRJNA416866_P_NODE_3850_length_338_cov_2.079422_g3707_i0 | PRJNA416866 | 3850 | 338 | 2.079422 | 7.02844636 | Parasporobacterium sp. | 2740533 | Bacteria | Bacteria | 49.3 | 5.44e-4 | NR | MCF0228404.1 | 2740533 | g3707 | i0 | 35.7 | 0.621301775147929 | 70 | 45 | 62.1 | 0 | 100 | 309 | 122 | 191 | MCF0228404.1 MATE family efflux transporter [Parasporobacterium sp.] | diamond | 210 | 49.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Parasporobacterium | Parasporobacterium sp. | ||
| 30029138 | 30029138 | PRJNA416866_P_NODE_11751_length_201_cov_0.914286_g11607_i0 | PRJNA416866 | 11751 | 201 | 0.914286 | 1.83771486 | Pseudobutyrivibrio | 46205 | Bacteria | Bacteria | 55.1 | 5.16e-7 | NR | MCR4674174.1 | 1898203 | g11607 | i0 | 56.4 | 4.76119402985075 | 39 | 17 | 58.2 | 0 | 5 | 121 | 175 | 213 | MCR4674174.1 adenylate kinase [Lachnospiraceae bacterium] | diamond | 957 | 55.5 | 0.992792792792793 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium | |||
| 31798790 | 31798790 | PRJNA416866_P_NODE_8877_length_216_cov_1.238710_g8733_i0 | PRJNA416866 | 8877 | 216 | 1.23871 | 2.6756136 | Bacillati | 1783272 | Bacteria | Bacteria | 57.4 | 1.46e-7 | NR | WP_155704045.1 | 1778678 | g8733 | i0 | 43.1 | 3.68055555555556 | 72 | 36 | 93.1 | 1 | 15 | 215 | 187 | 258 | WP_155704045.1 ankyrin repeat domain-containing protein [Paenibacillus psychroresistens] | diamond | 795 | 57.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Paenibacillus | Paenibacillus psychroresistens | ||
| 32730832 | 32730832 | PRJNA416866_P_NODE_7460_length_237_cov_1.454545_g7316_i0 | PRJNA416866 | 7460 | 237 | 1.454545 | 3.44727165 | uncultured Clostridium sp. | 59620 | Bacteria | Bacteria | 108 | 1.79e-25 | NR | WP_297632933.1 | 59620 | g7316 | i0 | 66.2 | 1.91139240506329 | 74 | 25 | 93.7 | 0 | 2 | 223 | 375 | 448 | WP_297632933.1 amino acid permease [uncultured Clostridium sp.] | diamond | 453 | 108 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | uncultured Clostridium sp. | ||
| 32825252 | 32825252 | PRJNA416866_P_NODE_8540_length_220_cov_1.974843_g8396_i0 | PRJNA416866 | 8540 | 220 | 1.974843 | 4.3446546 | Enterococcus faecalis | 1351 | Bacteria | Bacteria | 97.1 | 2.11e-24 | NR | WP_375855466.1 | 1351 | g8396 | i0 | 91.4 | 0.790909090909091 | 58 | 5 | 79.1 | 0 | 218 | 45 | 31 | 88 | WP_375855466.1 hypothetical protein [Enterococcus faecalis] | diamond | 174 | 97.1 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Enterococcaceae | Enterococcus | Enterococcus faecalis |
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);;