contig_metadata
9 rows where bioproject = "PRJNA561138" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13884463 | 13884463 | PRJNA561138_P_NODE_15291_length_335_cov_34.721374_g15096_i0 | PRJNA561138 | 15291 | 335 | 34.721374 | 116.3166029 | Bacillales | 1385 | Bacteria | Bacteria | 278 | 4.79e-70 | NTclustered | gi|1348914887|gb|MG983975.1| | 1409 | g15096 | i0 | 100 | 104.331343283582 | 150 | 0 | 90 | 0 | 1 | 150 | 295 | 444 | Bacillus sp. (in: Bacteria) strain B7 16S ribosomal RNA gene, partial sequence | blastn | 34951 | 278 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus sp. (in: firmicutes) | ||
| 15158650 | 15158650 | PRJNA561138_P_NODE_15112_length_337_cov_1.477273_g14917_i0 | PRJNA561138 | 15112 | 337 | 1.477273 | 4.97841001 | Streptococcus | 1301 | Bacteria | Bacteria | 606 | 5.409999999999998e-169 | NTclustered | gi|1948603152|gb|CP066021.1| | 1303 | g14917 | i0 | 99.11 | 339.00296735905 | 337 | 3 | 100 | 0 | 1 | 337 | 673574 | 673238 | Streptococcus oralis strain FDAARGOS_1020 chromosome, complete genome | blastn | 114244 | 612 | 0.990196078431373 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Streptococcaceae | Streptococcus | Streptococcus oralis | ||
| 15847947 | 15847947 | PRJNA561138_P_NODE_25093_length_250_cov_0.870056_g24898_i0 | PRJNA561138 | 25093 | 250 | 0.870056 | 2.17514 | Veillonella rogosae | 423477 | Bacteria | Bacteria | 429 | 8.949999999999998e-116 | NTclustered | gi|2446175566|gb|CP117967.1| | 423477 | g24898 | i0 | 97.6 | 4.784 | 250 | 6 | 100 | 0 | 1 | 250 | 942366 | 942117 | Veillonella rogosae strain AC2811 AN NA 2 chromosome, complete genome | blastn | 1196 | 429 | 1 | Bacteria | Bacillati | Bacillota | Negativicutes | Veillonellales | Veillonellaceae | Veillonella | Veillonella rogosae | ||
| 16433306 | 16433306 | PRJNA561138_P_NODE_15293_length_335_cov_6.480916_g15098_i0 | PRJNA561138 | 15293 | 335 | 6.480916 | 21.7110686 | root | 1 | Root_unresolved | Root_unresolved | 278 | 4.79e-70 | NTclustered | gi|1002357967|gb|KU738862.1| | 1390 | g15098 | i0 | 100 | 98.1970149253731 | 150 | 0 | 80 | 0 | 186 | 335 | 656 | 805 | Bacillus amyloliquefaciens strain AZB42 16S ribosomal RNA gene, partial sequence | blastn | 32896 | 278 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus amyloliquefaciens | ||
| 27995133 | 27995133 | PRJNA561138_P_NODE_13045_length_362_cov_1.093426_g12850_i0 | PRJNA561138 | 13045 | 362 | 1.093426 | 3.95820212 | Bacillus sp. FSL W8- | 2954627 | Bacteria | Bacteria | 147 | 7.2e-40 | NR | WP_341026961.1 | 2954627 | g12850 | i0 | 61 | 3.90331491712707 | 118 | 45 | 97 | 1 | 1 | 351 | 311 | 428 | WP_341026961.1 restriction endonuclease [Bacillus sp. FSL W8-0645] | diamond | 1413 | 147 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacillales | Bacillaceae | Bacillus | Bacillus sp. FSL W8-0645 | ||
| 29257785 | 29257785 | PRJNA561138_P_NODE_27369_length_246_cov_0.890173_g27174_i0 | PRJNA561138 | 27369 | 246 | 0.890173 | 2.18982558 | Bacilli bacterium | 1903720 | Bacteria | Bacteria | 64.3 | 9.76e-10 | NR | MEG1494751.1 | 1903720 | g27174 | i0 | 43.6 | 0.951219512195122 | 78 | 41 | 93.9 | 2 | 11 | 241 | 731 | 806 | MEG1494751.1 hypothetical protein [Bacilli bacterium] | diamond | 234 | 64.3 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Bacilli bacterium | |||||
| 29826225 | 29826225 | PRJNA561138_P_NODE_12471_length_369_cov_1.135135_g12276_i0 | PRJNA561138 | 12471 | 369 | 1.135135 | 4.18864815 | Enterococcus faecium | 1352 | Bacteria | Bacteria | 139 | 6.92e-39 | NR | WP_230206348.1 | 1352 | g12276 | i0 | 94.6 | 0.601626016260163 | 74 | 4 | 60.2 | 0 | 367 | 146 | 135 | 208 | WP_230206348.1 hypothetical protein, partial [Enterococcus faecium] | diamond | 222 | 139 | 1 | Bacteria | Bacillati | Bacillota | Bacilli | Lactobacillales | Enterococcaceae | Enterococcus | Enterococcus faecium | ||
| 29857887 | 29857887 | PRJNA561138_P_NODE_28951_length_243_cov_0.905882_g28756_i0 | PRJNA561138 | 28951 | 243 | 0.905882 | 2.20129326 | Candidatus Fimenecus sp. | 3022888 | Bacteria | Bacteria | 56.2 | 6.29e-7 | NR | MDY4909386.1 | 3022888 | g28756 | i0 | 32.6 | 1.09876543209877 | 89 | 50 | 97.5 | 2 | 4 | 240 | 116 | 204 | MDY4909386.1 LPD28 domain-containing protein [Candidatus Fimenecus sp.] | diamond | 267 | 56.2 | 1 | Bacteria | Bacillati | Bacillota | Clostridia | Candidatus Fimenecus | Candidatus Fimenecus sp. | ||||
| 32559416 | 32559416 | PRJNA561138_P_NODE_24519_length_251_cov_0.865169_g24324_i0 | PRJNA561138 | 24519 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 99 | 3.1e-23 | NR | WP_209465717.1 | 557451 | g24324 | i0 | 58.1 | 4.49402390438247 | 74 | 31 | 88.4 | 0 | 3 | 224 | 173 | 246 | WP_209465717.1 VOC family protein [Symbiobacterium terraclitae] | diamond | 1128 | 100 | 0.99 | Bacteria | Bacillati | Bacillota | Clostridia | Eubacteriales | Symbiobacteriaceae | Symbiobacterium | Symbiobacterium terraclitae |
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);;