contig_metadata
10 rows where bioproject = "PRJNA573544" and tax_kingdom = "Bacillati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3110295 | 3110295 | PRJNA573544_P_NODE_4463_length_274_cov_1.363184_g4445_i0 | PRJNA573544 | 4463 | 274 | 1.363184 | 3.73512416 | Microbacterium sp. BH-3-3-3 | 1906742 | Bacteria | Bacteria | 261 | 3.84e-65 | NTclustered | gi|1084379694|gb|CP017674.1| | 1906742 | g4445 | i0 | 84.47 | 2.95255474452555 | 264 | 41 | 96 | 0 | 1 | 264 | 2478463 | 2478726 | Microbacterium sp. BH-3-3-3 chromosome, complete genome | blastn | 809 | 261 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. BH-3-3-3 | ||
| 5663185 | 5663185 | PRJNA573544_P_NODE_7125_length_246_cov_0.901734_g7107_i0 | PRJNA573544 | 7125 | 246 | 0.901734 | 2.21826564 | Mycobacterium sp. ITM-2016-00316 | 2099695 | Bacteria | Bacteria | 411 | 3.1799999999999995e-110 | NTclustered | gi|2579898707|gb|CP134398.1| | 2099695 | g7107 | i0 | 96.748 | 46.6707317073171 | 246 | 8 | 100 | 0 | 1 | 246 | 4955786 | 4955541 | Mycobacterium sp. ITM-2016-00316 chromosome | blastn | 11481 | 411 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. ITM-2016-00316 | ||
| 8789005 | 8789005 | PRJNA573544_P_NODE_4027_length_286_cov_1.821596_g4009_i0 | PRJNA573544 | 4027 | 286 | 1.821596 | 5.20976456 | root | 1 | Root_unresolved | Root_unresolved | 512 | 1.01e-140 | NTclustered | gi|2660106423|gb|CP138905.1| | 1831 | g4009 | i0 | 98.955 | 422.493006993007 | 287 | 2 | 100 | 1 | 1 | 286 | 561613 | 561327 | MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome | blastn | 120833 | 512 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcus | Rhodococcus sp. (in: high G+C Gram-positive bacteria) | ||
| 13890139 | 13890139 | PRJNA573544_P_NODE_2331_length_354_cov_1.110320_g2313_i0 | PRJNA573544 | 2331 | 354 | 1.11032 | 3.9305328 | Enterococcus | 1350 | Bacteria | Bacteria | 654 | 0 | NTclustered | gi|939198273|gb|CP010060.1| | 44008 | g2313 | i0 | 100 | 484.629943502825 | 354 | 0 | 100 | 0 | 1 | 354 | 141236 | 140883 | Enterococcus cecorum strain SA1 genome | blastn | 171559 | 654 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Enterococcaceae | Enterococcus | Enterococcus cecorum | ||
| 18411294 | 18411294 | PRJNA573544_P_NODE_3775_length_294_cov_1.565611_g3757_i0 | PRJNA573544 | 3775 | 294 | 1.565611 | 4.60289634 | Microbacterium testaceum | 2033 | Bacteria | Bacteria | 200 | 9.2e-47 | NTclustered | gi|2488004109|gb|CP121699.1| | 2033 | g3757 | i0 | 90.667 | 3.06462585034014 | 150 | 14 | 51 | 0 | 145 | 294 | 1093696 | 1093547 | Microbacterium testaceum strain HW4 chromosome, complete genome | blastn | 901 | 200 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium testaceum | ||
| 21538065 | 21538065 | PRJNA573544_P_NODE_357_length_732_cov_2.062215_g341_i0 | PRJNA573544 | 357 | 732 | 2.062215 | 15.0954138 | Rhodococcus | 1827 | Bacteria | Bacteria | 1341 | 0 | NTclustered | gi|2660106423|gb|CP138905.1| | 1831 | g341 | i0 | 99.727 | 413.687158469945 | 732 | 2 | 100 | 0 | 1 | 732 | 559870 | 560601 | MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome | blastn | 302819 | 1347 | 0.99554565701559 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcus | Rhodococcus sp. (in: high G+C Gram-positive bacteria) | ||
| 22813363 | 22813363 | PRJNA573544_P_NODE_7378_length_245_cov_0.906977_g7360_i0 | PRJNA573544 | 7378 | 245 | 0.906977 | 2.22209365 | Mycobacteriales | 85007 | Bacteria | Bacteria | 318 | 1.9699999999999998e-82 | NTclustered | gi|2658946156|gb|CP108021.1| | 1603258 | g7360 | i0 | 90.795 | 253.542857142857 | 239 | 21 | 98 | 1 | 7 | 245 | 2421 | 2184 | Williamsia herbipolensis strain NBC_00319 chromosome, complete genome | blastn | 62118 | 320 | 0.99375 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Williamsia | Williamsia herbipolensis | ||
| 28658713 | 28658713 | PRJNA573544_P_NODE_4987_length_260_cov_0.930481_g4969_i0 | PRJNA573544 | 4987 | 260 | 0.930481 | 2.4192506 | Clostridia bacterium | 2044939 | Bacteria | Bacteria | 45.1 | 0.00339 | NR | MBQ8149526.1 | 2044939 | g4969 | i0 | 48.7 | 0.45 | 39 | 20 | 45 | 0 | 50 | 166 | 80 | 118 | MBQ8149526.1 hypothetical protein [Clostridia bacterium] | diamond | 117 | 45.1 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Clostridia bacterium | |||||
| 28974441 | 28974441 | PRJNA573544_P_NODE_4708_length_267_cov_1.551546_g4690_i0 | PRJNA573544 | 4708 | 267 | 1.551546 | 4.14262782 | Micromonosporaceae bacterium | 1873464 | Bacteria | Bacteria | 44.7 | 0.0099 | NR | HEX6073767.1 | 1873464 | g4690 | i0 | 44.6 | 0.730337078651685 | 65 | 20 | 71.9 | 3 | 217 | 26 | 145 | 194 | HEX6073767.1 thiolase family protein [Micromonosporaceae bacterium] | diamond | 195 | 44.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonosporaceae bacterium | |||
| 32797422 | 32797422 | PRJNA573544_P_NODE_7020_length_246_cov_0.901734_g7002_i0 | PRJNA573544 | 7020 | 246 | 0.901734 | 2.21826564 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 164 | 2.0299999999999998e-47 | NR | HMY02784.1 | 2711154 | g7002 | i0 | 100 | 0.98780487804878 | 81 | 0 | 98.8 | 0 | 2 | 244 | 114 | 194 | HMY02784.1 hypothetical protein [Candidatus Obscuribacter sp.] | diamond | 243 | 164 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. |
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);;