contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA450632" and tax_phylum = "Actinomycetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6195560 | 6195560 | PRJNA450632_P_NODE_1045_length_1152_cov_12.430618_g960_i0 | PRJNA450632 | 1045 | 1152 | 12.430618 | 143.20071936 | Cutibacterium | 1912216 | Bacteria | Bacteria | 2117 | 0 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g960 | i0 | 99.826 | 254.508680555556 | 1152 | 2 | 100 | 0 | 1 | 1152 | 55360 | 56511 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 293194 | 2117 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 11295675 | 11295675 | PRJNA450632_P_NODE_20709_length_164_cov_6.155039_g20530_i0 | PRJNA450632 | 20709 | 164 | 6.155039 | 10.09426396 | Actinomycetes | 1760 | Bacteria | Bacteria | 303 | 3.42e-78 | NTclustered | gi|255761303|gb|GQ338419.1| | 38284 | g20530 | i0 | 100 | 98.8780487804878 | 164 | 0 | 100 | 0 | 1 | 164 | 339 | 176 | Corynebacterium accolens strain CHL-B21438 16S ribosomal RNA gene, partial sequence | blastn | 16216 | 303 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium accolens | ||
| 11918145 | 11918145 | PRJNA450632_P_NODE_21430_length_161_cov_1.325397_g21251_i0 | PRJNA450632 | 21430 | 161 | 1.325397 | 2.13388917 | Curtobacterium sp. 9128 | 1793722 | Bacteria | Bacteria | 58.4 | 2.87e-4 | NTclustered | gi|1032524578|emb|LT576451.1| | 1793722 | g21251 | i0 | 100 | 0.192546583850932 | 31 | 0 | 19 | 0 | 111 | 141 | 408893 | 408923 | Curtobacterium sp. 9128 genome assembly, chromosome: I | blastn | 31 | 58.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Curtobacterium | Curtobacterium sp. 9128 | ||
| 13193030 | 13193030 | PRJNA450632_P_NODE_23731_length_151_cov_1.948276_g23552_i0 | PRJNA450632 | 23731 | 151 | 1.948276 | 2.94189676 | Nocardioides sp. S5 | 2017486 | Bacteria | Bacteria | 268 | 1.12e-67 | NTclustered | gi|1999037722|gb|CP022296.1| | 2017486 | g23552 | i0 | 98.675 | 293.397350993377 | 151 | 2 | 100 | 0 | 1 | 151 | 1843153 | 1843303 | Nocardioides sp. S5 chromosome, complete genome | blastn | 44303 | 268 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. S5 | ||
| 15741994 | 15741994 | PRJNA450632_P_NODE_19653_length_170_cov_2.296296_g19474_i0 | PRJNA450632 | 19653 | 170 | 2.296296 | 3.9037032 | Corynebacterium sp. LaCa97 | 3391431 | Bacteria | Bacteria | 313 | 5.91e-81 | NTclustered | gi|2888564179|gb|CP177110.1| | 3391431 | g19474 | i0 | 100 | 339.029411764706 | 169 | 0 | 99 | 0 | 1 | 169 | 770021 | 770189 | Corynebacterium sp. LaCa97 chromosome, complete genome | blastn | 57635 | 313 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium sp. LaCa97 | ||
| 17016492 | 17016492 | PRJNA450632_P_NODE_13374_length_220_cov_3.145946_g13195_i0 | PRJNA450632 | 13374 | 220 | 3.145946 | 6.9210812 | Corynebacterium sp. LaCa97 | 3391431 | Bacteria | Bacteria | 385 | 1.69e-102 | NTclustered | gi|2888564179|gb|CP177110.1| | 3391431 | g13195 | i0 | 98.624 | 319.75 | 218 | 2 | 99 | 1 | 3 | 220 | 768811 | 769027 | Corynebacterium sp. LaCa97 chromosome, complete genome | blastn | 70345 | 385 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium sp. LaCa97 | ||
| 19565144 | 19565144 | PRJNA450632_P_NODE_19056_length_174_cov_1.719424_g18877_i0 | PRJNA450632 | 19056 | 174 | 1.719424 | 2.99179776 | Cutibacterium granulosum | 33011 | Bacteria | Bacteria | 322 | 1.01e-83 | NTclustered | gi|2438329814|dbj|AP026710.1| | 33011 | g18877 | i0 | 100 | 182.902298850575 | 174 | 0 | 100 | 0 | 1 | 174 | 485888 | 486061 | Cutibacterium granulosum TP-CG7 DNA, complete genome | blastn | 31825 | 322 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium granulosum | ||
| 22769505 | 22769505 | PRJNA450632_P_NODE_4578_length_466_cov_3.779582_g4402_i0 | PRJNA450632 | 4578 | 466 | 3.779582 | 17.61285212 | Gordonia | 2053 | Bacteria | Bacteria | 616 | 1.2799999999999996e-171 | NTclustered | gi|2325992771|gb|CP085887.1| | 84595 | g4402 | i0 | 92.027 | 250.206008583691 | 439 | 33 | 94 | 2 | 29 | 466 | 102936 | 103373 | Gordonia polyisoprenivorans strain B251 chromosome, complete genome | blastn | 116596 | 616 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Gordoniaceae | Gordonia | Gordonia polyisoprenivorans | ||
| 24044390 | 24044390 | PRJNA450632_P_NODE_1959_length_810_cov_16.997419_g80_i2 | PRJNA450632 | 1959 | 810 | 16.997419 | 137.6790939 | Micrococcus | 1269 | Bacteria | Bacteria | 1256 | 0 | NTclustered | gi|1949953231|gb|CP066288.1| | 1270 | g80 | i2 | 94.704 | 324.233333333333 | 812 | 38 | 100 | 5 | 1 | 810 | 2260244 | 2261052 | Micrococcus luteus strain FDAARGOS_1034 chromosome | blastn | 262629 | 1262 | 0.995245641838352 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus luteus |
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);;