contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA550047" and tax_clade = "delta/epsilon subdivisions"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4949801 | 4949801 | PRJNA550047_P_NODE_469304_length_241_cov_3.386905_g467331_i0 | PRJNA550047 | 469304 | 241 | 3.386905 | 8.16244105 | Actinomycetota | 201174 | Bacteria | Bacteria | 429 | 8.58e-116 | NTclustered | gi|78183527|dbj|AB239012.1| | 34034 | g467331 | i0 | 98.755 | 104.04979253112 | 241 | 3 | 100 | 0 | 1 | 241 | 36 | 276 | Uncultured delta proteobacterium gene for 16S rRNA, partial sequence, clone: BJS81-068 | blastn | 25076 | 429 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 6895590 | 6895590 | PRJNA550047_P_NODE_546306_length_215_cov_4.943662_g544333_i0 | PRJNA550047 | 546306 | 215 | 4.943662 | 10.6288733 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 209 | 1.06e-49 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g544333 | i0 | 91.946 | 57.4883720930233 | 149 | 12 | 69 | 0 | 1 | 149 | 1657673 | 1657821 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 12360 | 209 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 9446992 | 9446992 | PRJNA550047_P_NODE_76408_length_345_cov_11.253676_g74448_i0 | PRJNA550047 | 76408 | 345 | 11.253676 | 38.8251822 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 171 | 8.64e-38 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g74448 | i0 | 89.051 | 31.3884057971014 | 137 | 15 | 40 | 0 | 203 | 339 | 32979 | 32843 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 10829 | 171 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 11993743 | 11993743 | PRJNA550047_P_NODE_308570_length_296_cov_7.394619_g306601_i0 | PRJNA550047 | 308570 | 296 | 7.394619 | 21.88807224 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 95.3 | 4.5e-15 | NTclustered | gi|2874253659|emb|OY969087.1| | 34034 | g306601 | i0 | 91.304 | 0.233108108108108 | 69 | 6 | 23 | 0 | 158 | 226 | 1030076 | 1030144 | MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1 | blastn | 69 | 95.3 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 11993930 | 11993930 | PRJNA550047_P_NODE_324210_length_293_cov_18.218182_g322240_i0 | PRJNA550047 | 324210 | 293 | 18.218182 | 53.37927326 | Persicimonas caeni | 2292766 | Bacteria | Bacteria | 100 | 9.57e-17 | NTclustered | gi|1695542189|gb|CP041186.1| | 2292766 | g322240 | i0 | 75.676 | 8.38566552901024 | 222 | 42 | 74 | 11 | 38 | 253 | 6198821 | 6198606 | Persicimonas caeni strain YN101 chromosome | blastn | 2457 | 100 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 17090939 | 17090939 | PRJNA550047_P_NODE_188834_length_344_cov_11.771218_g186873_i0 | PRJNA550047 | 188834 | 344 | 11.771218 | 40.49298992 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 108 | 6.85e-19 | NTclustered | gi|2874253659|emb|OY969087.1| | 34034 | g186873 | i0 | 80.42 | 12.4825581395349 | 143 | 26 | 41 | 2 | 195 | 336 | 5759525 | 5759666 | MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1 | blastn | 4294 | 108 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 21522986 | 21522986 | PRJNA550047_P_NODE_315517_length_295_cov_7.027027_g313548_i0 | PRJNA550047 | 315517 | 295 | 7.027027 | 20.72972965 | Bacteria | 2 | Bacteria | Bacteria | 121 | 7.4e-23 | NTclustered | gi|2874253674|emb|OY969108.1| | 34034 | g313548 | i0 | 83.088 | 115.728813559322 | 136 | 19 | 45 | 4 | 1 | 134 | 1542230 | 1542097 | MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1 | blastn | 34140 | 121 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 22195725 | 22195725 | PRJNA550047_P_NODE_93018_length_345_cov_9.128676_g91058_i0 | PRJNA550047 | 93018 | 345 | 9.128676 | 31.4939322 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 279 | 1.38e-70 | NTclustered | gi|151353320|gb|EF666029.1| | 34034 | g91058 | i0 | 100 | 62.1304347826087 | 151 | 0 | 88 | 0 | 1 | 151 | 300 | 450 | Uncultured delta proteobacterium clone GASP-MB3W3_F10 16S ribosomal RNA gene, partial sequence | blastn | 21435 | 279 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium |
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);;