contig_metadata
8 rows where bioproject = "PRJNA429937", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7465796 | 7465796 | PRJNA429937_P_NODE_77766_length_373_cov_220.651163_g55507_i0 | PRJNA429937 | 77766 | 373 | 220.651163 | 823.02883799 | Bacillati | 1783272 | Bacteria | Bacteria | 505 | 2.2699999999999991e-138 | NTclustered | gi|823651831|gb|KP400455.1| | 34034 | g55507 | i0 | 91.553 | 98.9463806970509 | 367 | 30 | 98 | 1 | 1 | 366 | 208 | 574 | Uncultured delta proteobacterium clone SS42 16S ribosomal RNA gene, partial sequence | blastn | 36907 | 510 | 0.990196078431373 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 12566603 | 12566603 | PRJNA429937_P_NODE_86170_length_346_cov_2.088328_g63625_i0 | PRJNA429937 | 86170 | 346 | 2.088328 | 7.22561488 | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-1 | 2013736 | Bacteria | Bacteria | 81.3 | 1.67e-15 | NR | PKN80627.1 | 2013736 | g63625 | i0 | 62.5 | 0.624277456647399 | 72 | 4 | 42.5 | 1 | 200 | 346 | 1 | 72 | PKN80627.1 MAG: GDP-mannose 4,6-dehydratase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-1] | diamond | 216 | 81.3 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-1 | ||||||
| 22764725 | 22764725 | PRJNA429937_P_NODE_85738_length_347_cov_3.487421_g63202_i0 | PRJNA429937 | 85738 | 347 | 3.487421 | 12.10135087 | root | 1 | Root_unresolved | Root_unresolved | 435 | 2.7900000000000003e-117 | NTclustered | gi|1139283245|emb|LT697265.1| | 34034 | g63202 | i0 | 98.78 | 79.0201729106628 | 246 | 0 | 70 | 2 | 105 | 347 | 746 | 501 | uncultured delta proteobacterium partial 16S rRNA gene, isolate 10T_22683 | blastn | 27420 | 435 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 27138543 | 27138543 | PRJNA429937_P_NODE_59482_length_450_cov_1.577197_g39935_i0 | PRJNA429937 | 59482 | 450 | 1.577197 | 7.0973865 | Deltaproteobacteria bacterium RIFCSPLOWO2_12_55_13 | 1797885 | Bacteria | Bacteria | 185 | 4.48e-51 | NR | OGQ72666.1 | 1797885 | g39935 | i0 | 85 | 0.753333333333333 | 113 | 10 | 75.3 | 1 | 450 | 112 | 197 | 302 | OGQ72666.1 MAG: hypothetical protein A2W73_07885, partial [Deltaproteobacteria bacterium RIFCSPLOWO2_12_55_13] | diamond | 339 | 185 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_12_55_13 | ||||||
| 30549567 | 30549567 | PRJNA429937_P_NODE_45953_length_526_cov_11.446680_g29636_i0 | PRJNA429937 | 45953 | 526 | 11.44668 | 60.2095368 | Deltaproteobacteria bacterium ADurb.Bin135 | 1852867 | Bacteria | Bacteria | 52.8 | 1.53e-4 | NR | OQB71626.1 | 1852867 | g29636 | i0 | 44.6 | 0.319391634980989 | 56 | 31 | 31.9 | 0 | 355 | 188 | 25 | 80 | OQB71626.1 MAG: Chromosome partitioning protein ParA [Deltaproteobacteria bacterium ADurb.Bin135] | diamond | 168 | 52.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium ADurb.Bin135 | ||||||
| 30850478 | 30850478 | PRJNA429937_P_NODE_27474_length_698_cov_4.496263_g16538_i0 | PRJNA429937 | 27474 | 698 | 4.496263 | 31.38391574 | Myxococcota | 2818505 | Bacteria | Bacteria | 130 | 9.14e-34 | NR | PKN16992.1 | 2013756 | g16538 | i0 | 45.3 | 1.19914040114613 | 139 | 76 | 59.7 | 0 | 698 | 282 | 58 | 196 | PKN16992.1 MAG: hypothetical protein CVU71_18110 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-6] | diamond | 837 | 130 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-6 | ||||||
| 30992119 | 30992119 | PRJNA429937_P_NODE_51354_length_493_cov_2.724138_g33711_i0 | PRJNA429937 | 51354 | 493 | 2.724138 | 13.43000034 | Deltaproteobacteria bacterium RIFCSPLOWO2_12_55_13 | 1797885 | Bacteria | Bacteria | 165 | 7.05e-44 | NR | OGQ72666.1 | 1797885 | g33711 | i0 | 80 | 0.730223123732252 | 120 | 16 | 68.2 | 1 | 1 | 336 | 380 | 499 | OGQ72666.1 MAG: hypothetical protein A2W73_07885, partial [Deltaproteobacteria bacterium RIFCSPLOWO2_12_55_13] | diamond | 360 | 165 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_12_55_13 | ||||||
| 31434493 | 31434493 | PRJNA429937_P_NODE_44856_length_534_cov_2.954455_g28812_i0 | PRJNA429937 | 44856 | 534 | 2.954455 | 15.7767897 | Deltaproteobacteria bacterium RIFCSPLOWO2_12_55_13 | 1797885 | Bacteria | Bacteria | 282 | 1.96e-86 | NR | OGQ72666.1 | 1797885 | g28812 | i0 | 83.9 | 1.04494382022472 | 186 | 22 | 100 | 1 | 534 | 1 | 380 | 565 | OGQ72666.1 MAG: hypothetical protein A2W73_07885, partial [Deltaproteobacteria bacterium RIFCSPLOWO2_12_55_13] | diamond | 558 | 282 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_12_55_13 |
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);;