contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA949785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13686824 | 13686824 | PRJNA949785_P_NODE_15591_length_251_cov_0.865169_g15394_i0 | PRJNA949785 | 15591 | 251 | 0.865169 | 2.17157419 | Veillonella | 29465 | Bacteria | Bacteria | 171 | 1.8999999999999998e-47 | NR | WP_127160167.1 | 741828 | g15394 | i0 | 98.8 | 1.9840637450199201 | 83 | 1 | 99.2 | 0 | 2 | 250 | 843 | 925 | WP_127160167.1 FAD-binding and (Fe-S)-binding domain-containing protein [Veillonella sp. VA137] | diamond | 498 | 171 | 1 | Bacteria | Bacillati | Bacillota | Negativicutes | Veillonellales | Veillonellaceae | Veillonella | Veillonella sp. VA137 | ||
| 26613803 | 26613803 | PRJNA949785_P_NODE_18421_length_242_cov_3.189349_g18224_i0 | PRJNA949785 | 18421 | 242 | 3.189349 | 7.71822458 | Ruminococcus sp. | 41978 | Bacteria | Bacteria | 48.9 | 2.4e-4 | NR | MDE6790050.1 | 41978 | g18224 | i0 | 44.4 | 1.56198347107438 | 63 | 31 | 73.1 | 2 | 5 | 181 | 379 | 441 | MDE6790050.1 trypsin-like peptidase domain-containing protein [Ruminococcus sp.] | diamond | 378 | 48.9 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Ruminococcus | Ruminococcus sp. | ||
| 26740210 | 26740210 | PRJNA949785_P_NODE_14881_length_257_cov_2.510870_g14684_i0 | PRJNA949785 | 14881 | 257 | 2.51087 | 6.4529359 | Cohnella thailandensis | 557557 | Bacteria | Bacteria | 67 | 8.16e-11 | NR | WP_185120179.1 | 557557 | g14684 | i0 | 43.9 | 2.25291828793774 | 66 | 33 | 72.4 | 1 | 254 | 69 | 230 | 295 | WP_185120179.1 fumarylacetoacetate hydrolase family protein [Cohnella thailandensis] | diamond | 579 | 67 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Paenibacillaceae | Cohnella | Cohnella thailandensis | ||
| 27246771 | 27246771 | PRJNA949785_P_NODE_17923_length_244_cov_0.900585_g17726_i0 | PRJNA949785 | 17923 | 244 | 0.900585 | 2.1974274 | Anaerovoracaceae bacterium | 3030912 | Bacteria | Bacteria | 70.1 | 3.63e-12 | NR | HVI40082.1 | 3030912 | g17726 | i0 | 58.1 | 0.762295081967213 | 62 | 25 | 75 | 1 | 3 | 185 | 101 | 162 | HVI40082.1 TPM domain-containing protein [Anaerovoracaceae bacterium] | diamond | 186 | 70.1 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Anaerovoracaceae | Anaerovoracaceae bacterium | |||
| 27878402 | 27878402 | PRJNA949785_P_NODE_17045_length_246_cov_1.780347_g16848_i0 | PRJNA949785 | 17045 | 246 | 1.780347 | 4.37965362 | Halanaerobium kushneri | 56779 | Bacteria | Bacteria | 163 | 3.62e-45 | NR | WP_234978057.1 | 56779 | g16848 | i0 | 100 | 0.98780487804878 | 81 | 0 | 98.8 | 0 | 2 | 244 | 401 | 481 | WP_234978057.1 retron Eco8 family effector endonuclease [Halanaerobium kushneri] | diamond | 243 | 163 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Halanaerobiales | Halanaerobiaceae | Halanaerobium | Halanaerobium kushneri | ||
| 28193942 | 28193942 | PRJNA949785_P_NODE_17626_length_245_cov_0.895349_g17429_i0 | PRJNA949785 | 17626 | 245 | 0.895349 | 2.19360505 | Hominilimicola sp. | 3073571 | Bacteria | Bacteria | 161 | 4.1399999999999995e-45 | NR | WP_337600236.1 | 3073571 | g17429 | i0 | 97.5 | 0.991836734693878 | 81 | 2 | 99.2 | 0 | 245 | 3 | 3 | 83 | WP_337600236.1 recombinase family protein [Hominilimicola sp.] | diamond | 243 | 161 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Oscillospiraceae | Hominilimicola | Hominilimicola sp. | ||
| 28509932 | 28509932 | PRJNA949785_P_NODE_18967_length_241_cov_0.916667_g18770_i0 | PRJNA949785 | 18967 | 241 | 0.916667 | 2.20916747 | Clostridia | 186801 | Bacteria | Bacteria | 42.4 | 0.0143 | NR | WP_118702583.1 | 186801 | g18770 | i0 | 40.7 | 0.672199170124481 | 54 | 31 | 66 | 1 | 169 | 11 | 46 | 99 | WP_118702583.1 MULTISPECIES: hypothetical protein [Clostridia] | diamond | 162 | 42.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | ||||||
| 28642948 | 28642948 | PRJNA949785_P_NODE_13267_length_277_cov_1.509804_g13070_i0 | PRJNA949785 | 13267 | 277 | 1.509804 | 4.18215708 | FCB group | 1783270 | Bacteria | Bacteria | 87.4 | 1.02e-17 | NR | PKM82865.1 | 2013775 | g13070 | i0 | 50 | 3.6173285198556 | 90 | 45 | 97.5 | 0 | 275 | 6 | 262 | 351 | PKM82865.1 MAG: Na+/Picotransporter [Firmicutes bacterium HGW-Firmicutes-14] | diamond | 1002 | 87.4 | 1 | Bacteria | Bacillati | Bacillota | Firmicutes bacterium HGW-Firmicutes-14 | ||||||
| 28730957 | 28730957 | PRJNA949785_P_NODE_17987_length_244_cov_0.900585_g17790_i0 | PRJNA949785 | 17987 | 244 | 0.900585 | 2.1974274 | Alkalibacterium subtropicum | 753702 | Bacteria | Bacteria | 141 | 1.41e-38 | NR | WP_091530997.1 | 753702 | g17790 | i0 | 87.7 | 0.995901639344262 | 81 | 10 | 99.6 | 0 | 1 | 243 | 97 | 177 | WP_091530997.1 ABC transporter permease [Alkalibacterium subtropicum] | diamond | 243 | 141 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Carnobacteriaceae | Alkalibacterium | Alkalibacterium subtropicum | ||
| 29109903 | 29109903 | PRJNA949785_P_NODE_18848_length_241_cov_1.684524_g18651_i0 | PRJNA949785 | 18848 | 241 | 1.684524 | 4.05970284 | Lacicoccus qingdaonensis | 576118 | Bacteria | Bacteria | 54.7 | 2.19e-6 | NR | WP_092986317.1 | 576118 | g18651 | i0 | 89.3 | 0.348547717842324 | 28 | 3 | 34.9 | 0 | 1 | 84 | 414 | 441 | WP_092986317.1 LLM class flavin-dependent oxidoreductase [Lacicoccus qingdaonensis] | diamond | 84 | 54.7 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Salinicoccaceae | Lacicoccus | Lacicoccus qingdaonensis | ||
| 29330760 | 29330760 | PRJNA949785_P_NODE_17209_length_246_cov_0.890173_g17012_i0 | PRJNA949785 | 17209 | 246 | 0.890173 | 2.18982558 | Halanaerobiales bacterium | 2094029 | Bacteria | Bacteria | 119 | 5.24e-32 | NR | HKL13546.1 | 2094029 | g17012 | i0 | 65.4 | 0.98780487804878 | 81 | 28 | 98.8 | 0 | 2 | 244 | 97 | 177 | HKL13546.1 zinc dependent phospholipase C family protein [Halanaerobiales bacterium] | diamond | 243 | 119 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Halanaerobiales | Halanaerobiales bacterium | ||||
| 29394044 | 29394044 | PRJNA949785_P_NODE_16929_length_247_cov_0.885057_g16732_i0 | PRJNA949785 | 16929 | 247 | 0.885057 | 2.18609079 | Romboutsia sp. | 1965302 | Bacteria | Bacteria | 75.5 | 3.48e-15 | NR | MCA9750206.1 | 1965302 | g16732 | i0 | 48.2 | 1.0080971659919 | 83 | 40 | 98.4 | 3 | 2 | 244 | 46 | 127 | MCA9750206.1 HNH endonuclease [Romboutsia sp.] | diamond | 249 | 75.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Peptostreptococcaceae | Romboutsia | Romboutsia sp. | ||
| 29520200 | 29520200 | PRJNA949785_P_NODE_18010_length_244_cov_0.900585_g17813_i0 | PRJNA949785 | 18010 | 244 | 0.900585 | 2.1974274 | Alicyclobacillus fructus | 2816082 | Bacteria | Bacteria | 164 | 1.21e-47 | NR | WP_206830813.1 | 2816082 | g17813 | i0 | 100 | 0.983606557377049 | 80 | 0 | 98.4 | 0 | 3 | 242 | 151 | 230 | WP_206830813.1 DNA-processing protein DprA [Alicyclobacillus fructus] | diamond | 240 | 164 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Alicyclobacillaceae | Alicyclobacillus | Alicyclobacillus fructus | ||
| 29551626 | 29551626 | PRJNA949785_P_NODE_18990_length_241_cov_0.916667_g18793_i0 | PRJNA949785 | 18990 | 241 | 0.916667 | 2.20916747 | Halanaerobium saccharolyticum | 43595 | Bacteria | Bacteria | 126 | 1.02e-35 | NR | WP_005490284.1 | 43595 | g18793 | i0 | 85.9 | 0.883817427385892 | 71 | 10 | 88.4 | 0 | 240 | 28 | 28 | 98 | WP_005490284.1 AbrB/MazE/SpoVT family DNA-binding domain-containing protein [Halanaerobium saccharolyticum] | diamond | 213 | 126 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Halanaerobiales | Halanaerobiaceae | Halanaerobium | Halanaerobium saccharolyticum | ||
| 29583085 | 29583085 | PRJNA949785_P_NODE_17830_length_244_cov_0.900585_g17633_i0 | PRJNA949785 | 17830 | 244 | 0.900585 | 2.1974274 | Bacilli bacterium | 1903720 | Bacteria | Bacteria | 78.6 | 5.59e-16 | NR | MCX4249745.1 | 1903720 | g17633 | i0 | 42.7 | 0.922131147540984 | 75 | 43 | 92.2 | 0 | 241 | 17 | 77 | 151 | MCX4249745.1 IS630 family transposase [Bacilli bacterium] | diamond | 225 | 78.6 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacilli bacterium | |||||
| 29583086 | 29583086 | PRJNA949785_P_NODE_18110_length_243_cov_1.811765_g17913_i0 | PRJNA949785 | 18110 | 243 | 1.811765 | 4.40258895 | Anaerovoracaceae bacterium | 3030912 | Bacteria | Bacteria | 62.4 | 1.93e-9 | NR | HVI41791.1 | 3030912 | g17913 | i0 | 62.2 | 0.555555555555556 | 45 | 17 | 55.6 | 0 | 143 | 9 | 1 | 45 | HVI41791.1 hypothetical protein [Anaerovoracaceae bacterium] | diamond | 135 | 62.4 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Anaerovoracaceae | Anaerovoracaceae bacterium | |||
| 29677792 | 29677792 | PRJNA949785_P_NODE_7650_length_388_cov_1.955556_g7453_i0 | PRJNA949785 | 7650 | 388 | 1.955556 | 7.58755728 | Lachnospiraceae bacterium | 1898203 | Bacteria | Bacteria | 88.2 | 8.05e-20 | NR | MBQ5561215.1 | 1898203 | g7453 | i0 | 40.7 | 1.45360824742268 | 86 | 51 | 66.5 | 0 | 308 | 51 | 16 | 101 | MBQ5561215.1 thioredoxin [Lachnospiraceae bacterium] | diamond | 564 | 88.2 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Lachnospirales | Lachnospiraceae | Lachnospiraceae bacterium | |||
| 30183479 | 30183479 | PRJNA949785_P_NODE_11992_length_294_cov_1.846154_g11795_i0 | PRJNA949785 | 11992 | 294 | 1.846154 | 5.42769276 | Allobacillus | 1400133 | Bacteria | Bacteria | 46.2 | 0.00412 | NR | WP_186279493.1 | 1400133 | g11795 | i0 | 37 | 0.744897959183674 | 73 | 42 | 70.4 | 1 | 223 | 17 | 4 | 76 | WP_186279493.1 MULTISPECIES: ATP-dependent DNA helicase DinG [Allobacillus] | diamond | 219 | 46.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Allobacillus | |||
| 30657393 | 30657393 | PRJNA949785_P_NODE_18013_length_244_cov_0.900585_g17816_i0 | PRJNA949785 | 18013 | 244 | 0.900585 | 2.1974274 | Halanaerobiales bacterium | 2094029 | Bacteria | Bacteria | 107 | 3.4999999999999997e-25 | NR | MFP4661685.1 | 2094029 | g17816 | i0 | 70.1 | 0.94672131147541 | 77 | 23 | 94.7 | 0 | 233 | 3 | 1 | 77 | MFP4661685.1 family 16 glycosylhydrolase [Halanaerobiales bacterium] | diamond | 231 | 107 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Halanaerobiales | Halanaerobiales bacterium | ||||
| 30695584 | 30695584 | PRJNA949785_P_NODE_6073_length_449_cov_2.492021_g5876_i0 | PRJNA949785 | 6073 | 449 | 2.492021 | 11.18917429 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.0478 | NR | WP_311537223.1 | 293428 | g5876 | i0 | 24.1 | 2.57906458797327 | 141 | 95 | 88.9 | 3 | 8 | 406 | 540 | 676 | WP_311537223.1 phage tail spike protein [uncultured Anaerococcus sp.] | diamond | 1158 | 45.4 | 0.993392070484582 | Bacteria | Bacillati | Bacillota | Tissierellia | Tissierellales | Peptoniphilaceae | Anaerococcus | uncultured Anaerococcus sp. | ||
| 30815386 | 30815386 | PRJNA949785_P_NODE_18654_length_242_cov_0.911243_g18457_i0 | PRJNA949785 | 18654 | 242 | 0.911243 | 2.20520806 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 65.5 | 3.68e-10 | NR | MFA5758336.1 | 2044939 | g18457 | i0 | 47.5 | 0.991735537190083 | 80 | 40 | 97.9 | 2 | 241 | 5 | 604 | 682 | MFA5758336.1 hypothetical protein [Clostridia bacterium] | diamond | 240 | 65.5 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 31352779 | 31352779 | PRJNA949785_P_NODE_17196_length_246_cov_0.890173_g16999_i0 | PRJNA949785 | 17196 | 246 | 0.890173 | 2.18982558 | Halanaerobium | 2330 | Bacteria | Bacteria | 54.7 | 5.83e-7 | NR | WP_089719441.1 | 2330 | g16999 | i0 | 77.4 | 0.378048780487805 | 31 | 7 | 37.8 | 0 | 246 | 154 | 121 | 151 | WP_089719441.1 MULTISPECIES: chemotaxis protein CheX [Halanaerobium] | diamond | 93 | 54.7 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Halanaerobiales | Halanaerobiaceae | Halanaerobium | |||
| 31890362 | 31890362 | PRJNA949785_P_NODE_18477_length_242_cov_1.366864_g18280_i0 | PRJNA949785 | 18477 | 242 | 1.366864 | 3.30781088 | Aceticella autotrophica | 2755338 | Bacteria | Bacteria | 59.3 | 5.32e-8 | NR | WP_284680459.1 | 2755338 | g18280 | i0 | 54.2 | 1.21487603305785 | 48 | 22 | 59.5 | 0 | 241 | 98 | 720 | 767 | WP_284680459.1 endopeptidase La [Aceticella autotrophica] | diamond | 294 | 59.3 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Thermoanaerobacterales | Thermoanaerobacteraceae | Aceticella | Aceticella autotrophica | ||
| 32181896 | 32181896 | PRJNA949785_P_NODE_10538_length_318_cov_2.106122_g10341_i0 | PRJNA949785 | 10538 | 318 | 2.106122 | 6.69746796 | Bacillota | 1239 | Bacteria | Bacteria | 48.9 | 5.67e-4 | NR | NMA68735.1 | 49981 | g10341 | i0 | 38.8 | 4.93396226415094 | 85 | 44 | 80.2 | 3 | 63 | 317 | 22 | 98 | NMA68735.1 TraB/GumN family protein [Desulfitobacterium sp.] | diamond | 1569 | 49.3 | 0.991886409736308 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Desulfitobacteriaceae | Desulfitobacterium | Desulfitobacterium sp. | ||
| 32593125 | 32593125 | PRJNA949785_P_NODE_15579_length_251_cov_0.865169_g15382_i0 | PRJNA949785 | 15579 | 251 | 0.865169 | 2.17157419 | Lactobacillales | 186826 | Bacteria | Bacteria | 41.2 | 0.0312 | NR | MCP9190998.1 | 1311 | g15382 | i0 | 32.9 | 1.88844621513944 | 79 | 52 | 93.2 | 1 | 9 | 242 | 10 | 88 | MCP9190998.1 hypothetical protein [Streptococcus agalactiae] | diamond | 474 | 41.2 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus agalactiae | ||
| 32649050 | 32649050 | PRJNA949785_P_NODE_260_length_1827_cov_1.892816_g228_i0 | PRJNA949785 | 260 | 1827 | 1.892816 | 34.58174832 | Romboutsia faecis | 2764597 | Bacteria | Bacteria | 49.7 | 0.0435 | NR | WP_172976758.1 | 2764597 | g228 | i0 | 22.5 | 0.614121510673235 | 374 | 227 | 60.9 | 15 | 1748 | 636 | 258 | 571 | WP_172976758.1 dynamin family protein [Romboutsia faecis] | diamond | 1122 | 49.7 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Peptostreptococcales | Peptostreptococcaceae | Romboutsia | Romboutsia faecis |
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);;