contig_metadata
10 rows where bioproject = "PRJNA737474" and tax_phylum = "Deferribacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25707093 | 25707093 | PRJNA737474c_S_NODE_18194_length_284_cov_1.843602_g17363_i0 | PRJNA737474 | 18194 | 284 | 1.843602 | 5.23582968 | Deferribacter | 53572 | Bacteria | Bacteria | 116 | 7.600000000000001e-28 | NR | WP_013008327.1 | 197162 | g17363 | i0 | 60.9 | 3.67605633802817 | 87 | 34 | 91.9 | 0 | 22 | 282 | 356 | 442 | WP_013008327.1 DUF3373 family protein [Deferribacter desulfuricans] | diamond | 1044 | 116 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Deferribacteraceae | Deferribacter | Deferribacter desulfuricans | ||
| 26443149 | 26443149 | PRJNA737474c_S_NODE_16695_length_292_cov_1.657534_g15864_i0 | PRJNA737474 | 16695 | 292 | 1.657534 | 4.83999928 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 183 | 1.15e-54 | NR | WP_013451327.1 | 477976 | g15864 | i0 | 96.9 | 1.99315068493151 | 97 | 3 | 99.7 | 0 | 291 | 1 | 192 | 288 | WP_013451327.1 type IV pilus twitching motility protein PilT [Calditerrivibrio nitroreducens] | diamond | 582 | 183 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 32969946 | 32969946 | PRJNA737474b_S_NODE_22826_length_336_cov_1.395437_g21787_i0 | PRJNA737474 | 22826 | 336 | 1.395437 | 4.68866832 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 179 | 4.2299999999999986e-55 | NR | WP_013451657.1 | 477976 | g21787 | i0 | 94.4 | 0.803571428571429 | 90 | 5 | 80.4 | 0 | 1 | 270 | 73 | 162 | WP_013451657.1 RNA chaperone Hfq [Calditerrivibrio nitroreducens] | diamond | 270 | 179 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 32986885 | 32986885 | PRJNA737474b_S_NODE_20523_length_354_cov_1.306050_g19484_i0 | PRJNA737474 | 20523 | 354 | 1.30605 | 4.623417 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 194 | 6.959999999999998e-55 | NR | WP_013450347.1 | 477976 | g19484 | i0 | 93.5 | 0.915254237288136 | 108 | 7 | 91.5 | 0 | 3 | 326 | 1034 | 1141 | WP_013450347.1 hypothetical protein [Calditerrivibrio nitroreducens] | diamond | 324 | 194 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 33003902 | 33003902 | PRJNA737474b_S_NODE_27507_length_306_cov_2.922747_g26468_i0 | PRJNA737474 | 27507 | 306 | 2.922747 | 8.94360582 | Denitrovibrio sp. | 2053308 | Bacteria | Bacteria | 123 | 2.8499999999999995e-31 | NR | PLX71695.1 | 2053308 | g26468 | i0 | 58.1 | 1.69607843137255 | 86 | 36 | 84.3 | 0 | 4 | 261 | 238 | 323 | PLX71695.1 MAG: cytochrome C [Denitrovibrio sp.] | diamond | 519 | 123 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Geovibrionaceae | Denitrovibrio | Denitrovibrio sp. | ||
| 33055035 | 33055035 | PRJNA737474b_S_NODE_23781_length_329_cov_2.386719_g22742_i0 | PRJNA737474 | 23781 | 329 | 2.386719 | 7.85230551 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 140 | 2.1e-40 | NR | WP_171789014.1 | 477976 | g22742 | i0 | 77 | 0.793313069908815 | 87 | 20 | 79.3 | 0 | 323 | 63 | 54 | 140 | WP_171789014.1 ATP-binding protein [Calditerrivibrio nitroreducens] | diamond | 261 | 140 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 33055108 | 33055108 | PRJNA737474b_S_NODE_32693_length_283_cov_1.090476_g31654_i0 | PRJNA737474 | 32693 | 283 | 1.090476 | 3.08604708 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 154 | 3.0499999999999998e-46 | NR | WP_013450762.1 | 477976 | g31654 | i0 | 83.9 | 0.985865724381625 | 93 | 15 | 98.6 | 0 | 3 | 281 | 8 | 100 | WP_013450762.1 ExbD/TolR family protein [Calditerrivibrio nitroreducens] | diamond | 279 | 154 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 33071991 | 33071991 | PRJNA737474b_S_NODE_19237_length_365_cov_2.794521_g18198_i0 | PRJNA737474 | 19237 | 365 | 2.794521 | 10.20000165 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 217 | 3.58e-70 | NR | WP_013450346.1 | 477976 | g18198 | i0 | 89 | 0.96986301369863 | 118 | 13 | 97 | 0 | 354 | 1 | 5 | 122 | WP_013450346.1 flagellar assembly protein FliW [Calditerrivibrio nitroreducens] | diamond | 354 | 217 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 33072090 | 33072090 | PRJNA737474b_S_NODE_31293_length_289_cov_1.824074_g30254_i0 | PRJNA737474 | 31293 | 289 | 1.824074 | 5.27157386 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 175 | 2.54e-50 | NR | WP_041723753.1 | 477976 | g30254 | i0 | 92.7 | 0.996539792387543 | 96 | 7 | 99.7 | 0 | 288 | 1 | 17 | 112 | WP_041723753.1 NADH-quinone oxidoreductase subunit M [Calditerrivibrio nitroreducens] | diamond | 288 | 175 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 33112100 | 33112100 | PRJNA737474d_S_NODE_29750_length_280_cov_2.980676_g29156_i0 | PRJNA737474 | 29750 | 280 | 2.980676 | 8.3458928 | Calditerrivibrio | 545865 | Bacteria | Bacteria | 120 | 9.65e-32 | NR | PMP72720.1 | 477976 | g29156 | i0 | 59.8 | 2.95714285714286 | 92 | 37 | 98.6 | 0 | 276 | 1 | 114 | 205 | PMP72720.1 MAG: dephospho-CoA kinase [Calditerrivibrio nitroreducens] | diamond | 828 | 121 | 0.991735537190083 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens |
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);;