contig_metadata
23 rows where bioproject = "PRJNA891846" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 867008 | 867008 | PRJNA891846_P_NODE_24821_length_305_cov_2.034483_g24602_i0 | PRJNA891846 | 24821 | 305 | 2.034483 | 6.20517315 | Planococcus sp. 107-1 | 2908840 | Bacteria | Bacteria | 451 | 2.3999999999999996e-122 | NTclustered | gi|2180345768|gb|CP090977.1| | 2908840 | g24602 | i0 | 93.485 | 798.963934426229 | 307 | 14 | 99 | 4 | 1 | 304 | 484683 | 484986 | Planococcus sp. 107-1 chromosome, complete genome | blastn | 243684 | 451 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Caryophanaceae | Planococcus | Planococcus sp. 107-1 | ||
| 1243171 | 1243171 | PRJNA891846_P_NODE_8621_length_503_cov_2.327907_g8406_i0 | PRJNA891846 | 8621 | 503 | 2.327907 | 11.70937221 | Bacillus | 1386 | Bacteria | Bacteria | 852 | 0 | NTclustered | gi|152022606|gb|CP000764.1| | 315749 | g8406 | i0 | 97.222 | 1247.50894632207 | 504 | 13 | 100 | 1 | 1 | 503 | 90912 | 90409 | Bacillus cytotoxicus NVH 391-98, complete genome | blastn | 627497 | 852 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus cytotoxicus | ||
| 3417939 | 3417939 | PRJNA891846_P_NODE_33003_length_266_cov_1.196891_g32784_i0 | PRJNA891846 | 33003 | 266 | 1.196891 | 3.18373006 | Anaerococcus mediterraneensis | 1870984 | Bacteria | Bacteria | 472 | 1.5799999999999998e-128 | NTclustered | gi|1105524756|emb|LT635772.1| | 1870984 | g32784 | i0 | 98.864 | 328.868421052632 | 264 | 3 | 99 | 0 | 3 | 266 | 437257 | 437520 | Anaerococcus sp. Marseille-P2765 strain Marseille-P2765T genome assembly, chromosome: contig00001 | blastn | 87479 | 472 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Anaerococcus | Anaerococcus mediterraneensis | ||
| 9795484 | 9795484 | PRJNA891846_P_NODE_5968_length_595_cov_1.408046_g5758_i0 | PRJNA891846 | 5968 | 595 | 1.408046 | 8.3778737 | Clostridium beijerinckii | 1520 | Bacteria | Bacteria | 1020 | 0 | NTclustered | gi|1491812680|gb|CP011966.3| | 1428454 | g5758 | i0 | 97.647 | 1004.43865546218 | 595 | 13 | 99 | 1 | 2 | 595 | 2163159 | 2162565 | Clostridium beijerinckii NRRL B-598, complete genome | blastn | 597641 | 1020 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium beijerinckii | ||
| 10171680 | 10171680 | PRJNA891846_P_NODE_37468_length_250_cov_1.305085_g37248_i0 | PRJNA891846 | 37468 | 250 | 1.305085 | 3.2627125 | root | 1 | Root_unresolved | Root_unresolved | 462 | 8.83e-126 | NTclustered | gi|1796975023|gb|CP033086.1| | 1280 | g37248 | i0 | 100 | 38.708 | 250 | 0 | 100 | 0 | 1 | 250 | 2427794 | 2427545 | Staphylococcus aureus strain WH9628 chromosome | blastn | 9677 | 462 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus aureus | ||
| 11070574 | 11070574 | PRJNA891846_P_NODE_26029_length_298_cov_1.293333_g25810_i0 | PRJNA891846 | 26029 | 298 | 1.293333 | 3.85413234 | root | 1 | Root_unresolved | Root_unresolved | 95.5 | 2.04e-20 | NR | WP_330942623.1 | 1328 | g25810 | i0 | 64.4 | 7.3489932885906 | 73 | 26 | 73.5 | 0 | 296 | 78 | 411 | 483 | WP_330942623.1 reverse transcriptase domain-containing protein, partial [Streptococcus anginosus] | diamond | 2190 | 95.9 | 0.995828988529718 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus anginosus | ||
| 13620997 | 13620997 | PRJNA891846_P_NODE_38331_length_249_cov_2.471591_g38111_i0 | PRJNA891846 | 38331 | 249 | 2.471591 | 6.15426159 | Lachnospiraceae bacterium | 1898203 | Bacteria | Bacteria | 156 | 2.32e-44 | NR | MBD5551612.1 | 1898203 | g38111 | i0 | 95.1 | 1.97590361445783 | 82 | 4 | 98.8 | 0 | 248 | 3 | 30 | 111 | MBD5551612.1 GDP-mannose 4,6-dehydratase [Lachnospiraceae bacterium] | diamond | 492 | 156 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium | |||
| 13621199 | 13621199 | PRJNA891846_P_NODE_46511_length_242_cov_0.911243_g46291_i0 | PRJNA891846 | 46511 | 242 | 0.911243 | 2.20520806 | Enterococcus cecorum | 44008 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|2737623164|gb|CP144500.1| | 44008 | g46291 | i0 | 100 | 1.15702479338843 | 28 | 0 | 12 | 0 | 98 | 125 | 981007 | 981034 | Enterococcus cecorum strain 65 chromosome, complete genome | blastn | 280 | 52.8 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Enterococcaceae | Enterococcus | Enterococcus cecorum | ||
| 17445547 | 17445547 | PRJNA891846_P_NODE_38654_length_249_cov_0.875000_g38434_i0 | PRJNA891846 | 38654 | 249 | 0.875 | 2.17875 | Coprococcus phoceensis | 1870993 | Bacteria | Bacteria | 444 | 3.18e-120 | NTclustered | gi|2777535726|dbj|AP031412.1| | 1870993 | g38434 | i0 | 98.795 | 439.421686746988 | 249 | 3 | 100 | 0 | 1 | 249 | 40693 | 40941 | Coprococcus phoceensis f14 DNA, complete genome | blastn | 109416 | 444 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Coprococcus | Coprococcus phoceensis | ||
| 19094657 | 19094657 | PRJNA891846_P_NODE_38595_length_249_cov_0.875000_g38375_i0 | PRJNA891846 | 38595 | 249 | 0.875 | 2.17875 | Clostridium | 1485 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|2385532608|gb|CP086246.1| | 2843318 | g38375 | i0 | 100 | 0.337349397590361 | 28 | 0 | 11 | 0 | 169 | 196 | 2522151 | 2522178 | Clostridium sp. CF011 chromosome, complete genome | blastn | 84 | 52.8 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Clostridiaceae | Clostridium | Clostridium sp. CF011 | ||
| 22920720 | 22920720 | PRJNA891846_P_NODE_34618_length_259_cov_1.241935_g34398_i0 | PRJNA891846 | 34618 | 259 | 1.241935 | 3.21661165 | Clostridia | 186801 | Bacteria | Bacteria | 479 | 9.13e-131 | NTclustered | gi|2299490668|gb|CP102292.1| | 471875 | g34398 | i0 | 100 | 453.540540540541 | 259 | 0 | 100 | 0 | 1 | 259 | 373447 | 373189 | [Ruminococcus] lactaris ATCC 29176 chromosome, complete genome | blastn | 117467 | 479 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Mediterraneibacter | [Ruminococcus] lactaris | ||
| 23819385 | 23819385 | PRJNA891846_P_NODE_34239_length_261_cov_1.180851_g34019_i0 | PRJNA891846 | 34239 | 261 | 1.180851 | 3.08202111 | Staphylococcus simulans | 1286 | Bacteria | Bacteria | 58.4 | 5.12e-4 | NTclustered | gi|2312988506|gb|CP094697.1| | 1286 | g34019 | i0 | 90.909 | 0.168582375478927 | 44 | 2 | 16 | 2 | 53 | 95 | 324494 | 324452 | Staphylococcus simulans strain IVB6244 chromosome, complete genome | blastn | 44 | 58.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Staphylococcaceae | Staphylococcus | Staphylococcus simulans | ||
| 26738628 | 26738628 | PRJNA891846_P_NODE_40161_length_248_cov_0.880000_g39941_i0 | PRJNA891846 | 40161 | 248 | 0.88 | 2.1824 | Lachnospiraceae bacterium | 1898203 | Bacteria | Bacteria | 159 | 6.499999999999998e-44 | NR | MDE6951147.1 | 1898203 | g39941 | i0 | 100 | 1.98387096774194 | 82 | 0 | 99.2 | 0 | 1 | 246 | 37 | 118 | MDE6951147.1 flagellar biosynthesis protein FlhA [Lachnospiraceae bacterium] | diamond | 492 | 159 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium | |||
| 26778658 | 26778658 | PRJNA891846_P_NODE_38421_length_249_cov_1.426136_g38201_i0 | PRJNA891846 | 38421 | 249 | 1.426136 | 3.55107864 | Brevibacillus | 55080 | Bacteria | Bacteria | 91.7 | 2.33e-19 | NR | WP_238504446.1 | 51101 | g38201 | i0 | 59.7 | 8.55421686746988 | 72 | 29 | 86.7 | 0 | 25 | 240 | 396 | 467 | WP_238504446.1 M4 family metallopeptidase [Brevibacillus agri] | diamond | 2130 | 92.4 | 0.992424242424242 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Brevibacillus | Brevibacillus agri | ||
| 26960479 | 26960479 | PRJNA891846_P_NODE_27562_length_290_cov_1.202765_g27343_i0 | PRJNA891846 | 27562 | 290 | 1.202765 | 3.4880185 | Lachnospiraceae bacterium 45-P1 | 3142752 | Bacteria | Bacteria | 166 | 2.2099999999999997e-47 | NR | MEY8396017.1 | 3142752 | g27343 | i0 | 94.8 | 0.993103448275862 | 96 | 5 | 99.3 | 0 | 1 | 288 | 249 | 344 | MEY8396017.1 MATE family efflux transporter [Lachnospiraceae bacterium 45-P1] | diamond | 288 | 166 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium 45-P1 | |||
| 28950598 | 28950598 | PRJNA891846_P_NODE_27028_length_292_cov_2.287671_g26809_i0 | PRJNA891846 | 27028 | 292 | 2.287671 | 6.67999932 | Oscillospiraceae bacterium | 2485925 | Bacteria | Bacteria | 45.4 | 0.00644 | NR | MBE6645655.1 | 2485925 | g26809 | i0 | 34.7 | 1.00684931506849 | 98 | 44 | 88.4 | 4 | 280 | 23 | 123 | 212 | MBE6645655.1 ABC transporter permease [Oscillospiraceae bacterium] | diamond | 294 | 45.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Oscillospiraceae bacterium | |||
| 28982158 | 28982158 | PRJNA891846_P_NODE_38568_length_249_cov_0.875000_g38348_i0 | PRJNA891846 | 38568 | 249 | 0.875 | 2.17875 | Lachnospiraceae bacterium | 1898203 | Bacteria | Bacteria | 152 | 5.309999999999999e-42 | NR | HCT90685.1 | 1898203 | g38348 | i0 | 90.1 | 0.975903614457831 | 81 | 8 | 97.6 | 0 | 5 | 247 | 231 | 311 | HCT90685.1 D-xylose ABC transporter ATP-binding protein [Lachnospiraceae bacterium] | diamond | 243 | 152 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium | |||
| 29013850 | 29013850 | PRJNA891846_P_NODE_44468_length_244_cov_0.900585_g44248_i0 | PRJNA891846 | 44468 | 244 | 0.900585 | 2.1974274 | uncultured Anaerococcus sp. | 293428 | Bacteria | Bacteria | 140 | 4.409999999999999e-37 | NR | WP_311531217.1 | 293428 | g44248 | i0 | 88.8 | 0.983606557377049 | 80 | 9 | 98.4 | 0 | 4 | 243 | 27 | 106 | WP_311531217.1 formate--tetrahydrofolate ligase [uncultured Anaerococcus sp.] | diamond | 240 | 140 | 1 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Anaerococcus | uncultured Anaerococcus sp. | ||
| 29676236 | 29676236 | PRJNA891846_P_NODE_46590_length_242_cov_0.911243_g46370_i0 | PRJNA891846 | 46590 | 242 | 0.911243 | 2.20520806 | Lawsonibacter sp. | 2185275 | Bacteria | Bacteria | 141 | 3.75e-38 | NR | MCI9242031.1 | 2185275 | g46370 | i0 | 97.5 | 0.991735537190083 | 80 | 2 | 99.2 | 0 | 3 | 242 | 340 | 419 | MCI9242031.1 S-layer homology domain-containing protein [Lawsonibacter sp.] | diamond | 240 | 141 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Lawsonibacter | Lawsonibacter sp. | ||
| 31066845 | 31066845 | PRJNA891846_P_NODE_1155_length_1223_cov_32.578261_g1050_i0 | PRJNA891846 | 1155 | 1223 | 32.578261 | 398.43213203 | Virgibacillus sp. 19R1-5 | 2834410 | Bacteria | Bacteria | 374 | 8.43e-126 | NR | WP_213406776.1 | 2834410 | g1050 | i0 | 99.3 | 0.662305805396566 | 270 | 2 | 66.2 | 0 | 1221 | 412 | 1 | 270 | WP_213406776.1 hypothetical protein, partial [Virgibacillus sp. 19R1-5] | diamond | 810 | 374 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Virgibacillus | Virgibacillus sp. 19R1-5 | ||
| 31066858 | 31066858 | PRJNA891846_P_NODE_46275_length_242_cov_0.911243_g46055_i0 | PRJNA891846 | 46275 | 242 | 0.911243 | 2.20520806 | Angelakisella sp. | 1935177 | Bacteria | Bacteria | 110 | 1.07e-27 | NR | MCI9194912.1 | 1935177 | g46055 | i0 | 96.6 | 0.71900826446281 | 58 | 2 | 71.9 | 0 | 241 | 68 | 9 | 66 | MCI9194912.1 ATP-binding cassette domain-containing protein [Angelakisella sp.] | diamond | 174 | 110 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Angelakisella | Angelakisella sp. | ||
| 31066859 | 31066859 | PRJNA891846_P_NODE_7935_length_523_cov_1.304444_g7720_i0 | PRJNA891846 | 7935 | 523 | 1.304444 | 6.82224212 | Lactobacillales bacterium | 1993866 | Bacteria | Bacteria | 45.4 | 0.0206 | NR | MBE6159497.1 | 1993866 | g7720 | i0 | 29 | 0.573613766730402 | 100 | 58 | 49.9 | 2 | 348 | 88 | 49 | 148 | MBE6159497.1 hypothetical protein [Lactobacillales bacterium] | diamond | 300 | 45.4 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Lactobacillales bacterium | ||||
| 32585085 | 32585085 | PRJNA891846_P_NODE_45299_length_243_cov_0.905882_g45079_i0 | PRJNA891846 | 45299 | 243 | 0.905882 | 2.20129326 | Lachnospiraceae bacterium | 1898203 | Bacteria | Bacteria | 41.6 | 0.0185 | NR | MCI8696622.1 | 1898203 | g45079 | i0 | 44.1 | 0.728395061728395 | 59 | 29 | 72.8 | 1 | 224 | 48 | 19 | 73 | MCI8696622.1 hypothetical protein [Lachnospiraceae bacterium] | diamond | 177 | 41.6 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae 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);;