contig_metadata
10 rows where bioproject = "PRJNA400391", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2356449 | 2356449 | PRJNA400391_S_NODE_2362_length_259_cov_251.781250_g2301_i0 | PRJNA400391 | 2362 | 259 | 251.78125 | 652.1134375 | Bacteria | 2 | Bacteria | Bacteria | 429 | 9.329999999999999e-116 | NTclustered | gi|927353967|gb|KT322501.1| | 34034 | g2301 | i0 | 96.525 | 99.980694980695 | 259 | 9 | 100 | 0 | 1 | 259 | 285 | 27 | Uncultured delta proteobacterium clone TGR_WLFZ-321 16S ribosomal RNA gene, partial sequence | blastn | 25895 | 429 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 3631914 | 3631914 | PRJNA400391_S_NODE_883_length_368_cov_138.438438_g822_i0 | PRJNA400391 | 883 | 368 | 138.438438 | 509.45345184 | Myxococcota | 2818505 | Bacteria | Bacteria | 651 | 0 | NTclustered | gi|146429756|gb|EF220572.1| | 34034 | g822 | i0 | 99.169 | 101.83152173913 | 361 | 3 | 98 | 0 | 8 | 368 | 10 | 370 | Uncultured delta proteobacterium clone FI-1M_B12 16S ribosomal RNA gene, partial sequence | blastn | 37474 | 656 | 0.992378048780488 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 4909074 | 4909074 | PRJNA400391_S_NODE_884_length_368_cov_134.714715_g823_i0 | PRJNA400391 | 884 | 368 | 134.714715 | 495.7501512 | Bacteria | 2 | Bacteria | Bacteria | 621 | 2.12e-173 | NTclustered | gi|451917577|gb|KC451441.1| | 34034 | g823 | i0 | 97.778 | 96.070652173913 | 360 | 8 | 98 | 0 | 9 | 368 | 1 | 360 | Uncultured delta proteobacterium clone RLBp5719 16S ribosomal RNA gene, partial sequence | blastn | 35354 | 623 | 0.996789727126806 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 6184132 | 6184132 | PRJNA400391_S_NODE_3705_length_209_cov_4.695402_g3644_i0 | PRJNA400391 | 3705 | 209 | 4.695402 | 9.81339018 | root | 1 | Root_unresolved | Root_unresolved | 387 | 4.42e-103 | NTclustered | gi|219960833|gb|FJ568373.1| | 34034 | g3644 | i0 | 100 | 99.9904306220096 | 209 | 0 | 100 | 0 | 1 | 209 | 180 | 388 | Uncultured delta proteobacterium clone A19YC02RM small subunit ribosomal RNA gene, partial sequence | blastn | 20898 | 387 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 7458960 | 7458960 | PRJNA400391_S_NODE_2706_length_243_cov_58.057692_g2645_i0 | PRJNA400391 | 2706 | 243 | 58.057692 | 141.08019156 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 449 | 6.65e-122 | NTclustered | gi|194305077|emb|CU466773.1| | 34034 | g2645 | i0 | 100 | 97.1646090534979 | 243 | 0 | 100 | 0 | 1 | 243 | 712 | 470 | Environmental 16s rDNA sequence from Evry wastewater treatment plant anoxic basin | blastn | 23611 | 449 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 7458973 | 7458973 | PRJNA400391_S_NODE_3486_length_215_cov_4.511111_g3425_i0 | PRJNA400391 | 3486 | 215 | 4.511111 | 9.69888865 | Bacteria | 2 | Bacteria | Bacteria | 224 | 3.8e-54 | NTclustered | gi|374854163|dbj|AP011765.1| | 34034 | g3425 | i0 | 86.111 | 192.33488372093 | 216 | 21 | 98 | 8 | 1 | 211 | 12366 | 12155 | Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 | blastn | 41352 | 224 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 8733889 | 8733889 | PRJNA400391_S_NODE_5887_length_161_cov_207.920635_g5826_i0 | PRJNA400391 | 5887 | 161 | 207.920635 | 334.75222235 | Bacteria | 2 | Bacteria | Bacteria | 287 | 3.37e-73 | NTclustered | gi|295790297|gb|GQ893119.1| | 34034 | g5826 | i0 | 98.758 | 100 | 161 | 2 | 100 | 0 | 1 | 161 | 164 | 324 | Uncultured delta proteobacterium clone T3-0B_D07 16S ribosomal RNA gene, partial sequence | blastn | 16100 | 287 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 10009090 | 10009090 | PRJNA400391_S_NODE_2248_length_266_cov_25.090909_g2187_i0 | PRJNA400391 | 2248 | 266 | 25.090909 | 66.74181794 | Bacteria | 2 | Bacteria | Bacteria | 418 | 2.0799999999999995e-112 | NTclustered | gi|339646553|gb|JN038942.1| | 34034 | g2187 | i0 | 96.094 | 113.714285714286 | 256 | 10 | 96 | 0 | 4 | 259 | 256 | 1 | Uncultured delta proteobacterium clone M-B221 16S ribosomal RNA gene, partial sequence | blastn | 30248 | 418 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 20207232 | 20207232 | PRJNA400391_S_NODE_3976_length_202_cov_3.514970_g3915_i0 | PRJNA400391 | 3976 | 202 | 3.51497 | 7.1002394 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 322 | 1.21e-83 | NTclustered | gi|38373451|gb|AY455847.1| | 34034 | g3915 | i0 | 95.545 | 97.0049504950495 | 202 | 8 | 100 | 1 | 1 | 202 | 441 | 241 | Uncultured delta proteobacterium clone AL19 16S ribosomal RNA gene, partial sequence | blastn | 19595 | 322 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 25307148 | 25307148 | PRJNA400391_S_NODE_1040_length_353_cov_128.685535_g979_i0 | PRJNA400391 | 1040 | 353 | 128.685535 | 454.25993855 | Bacteria | 2 | Bacteria | Bacteria | 529 | 1.2599999999999996e-145 | NTclustered | gi|927354279|gb|KT322813.1| | 34034 | g979 | i0 | 95.758 | 95.0793201133145 | 330 | 11 | 93 | 2 | 26 | 352 | 1 | 330 | Uncultured delta proteobacterium clone TGR_WLFZ-633 16S ribosomal RNA gene, partial sequence | blastn | 33563 | 531 | 0.99623352165725 | 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);;