contig_metadata
10 rows where bioproject = "PRJNA944150", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17501676 | 17501676 | PRJNA944150_P_NODE_17534_length_210_cov_2.360248_g17283_i0 | PRJNA944150 | 17534 | 210 | 2.360248 | 4.9565208 | Desulfobulbus oligotrophicus | 1909699 | Bacteria | Bacteria | 119 | 1.79e-22 | NTclustered | gi|1951276582|gb|CP054140.1| | 1909699 | g17283 | i0 | 94.737 | 0.509523809523809 | 76 | 4 | 36 | 0 | 135 | 210 | 1232686 | 1232611 | Desulfobulbus oligotrophicus strain Prop6 chromosome, complete genome | blastn | 107 | 119 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus oligotrophicus | ||
| 17501946 | 17501946 | PRJNA944150_P_NODE_42554_length_162_cov_5.265487_g42303_i0 | PRJNA944150 | 42554 | 162 | 5.265487 | 8.53008894 | Desulfobulbus oralis | 1986146 | Bacteria | Bacteria | 54.7 | 0.004 | NTclustered | gi|1343450889|gb|CP021255.1| | 1986146 | g42303 | i0 | 78.652 | 0.728395061728395 | 89 | 13 | 56 | 6 | 46 | 131 | 1109106 | 1109191 | Desulfobulbus oralis strain HOT041/ORNL chromosome, complete genome | blastn | 118 | 54.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbus | Desulfobulbus oralis | ||
| 23876042 | 23876042 | PRJNA944150_P_NODE_22619_length_191_cov_2.042254_g22368_i0 | PRJNA944150 | 22619 | 191 | 2.042254 | 3.90070514 | Nitratidesulfovibrio liaohensis | 2604158 | Bacteria | Bacteria | 326 | 8.77e-85 | NTclustered | gi|2575677524|gb|CP133659.1| | 2604158 | g22368 | i0 | 97.382 | 7.93193717277487 | 191 | 5 | 100 | 0 | 1 | 191 | 2982999 | 2982809 | Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome | blastn | 1515 | 326 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Nitratidesulfovibrio | Nitratidesulfovibrio liaohensis | ||
| 27214711 | 27214711 | PRJNA944150_P_NODE_32622_length_172_cov_2.211382_g32371_i0 | PRJNA944150 | 32622 | 172 | 2.211382 | 3.80357704 | Smithella sp. | 2053614 | Bacteria | Bacteria | 45.4 | 0.00154 | NR | MEN6621316.1 | 2053614 | g32371 | i0 | 70 | 0.523255813953488 | 30 | 9 | 52.3 | 0 | 1 | 90 | 100 | 129 | MEN6621316.1 hypothetical protein [Smithella sp.] | diamond | 90 | 45.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Smithellaceae | Smithella | Smithella sp. | ||
| 27562170 | 27562170 | PRJNA944150_P_NODE_4004_length_427_cov_3.013228_g3755_i0 | PRJNA944150 | 4004 | 427 | 3.013228 | 12.86648356 | Smithella sp. | 2053614 | Bacteria | Bacteria | 74.3 | 1.33e-12 | NR | MEN6621319.1 | 2053614 | g3755 | i0 | 80.9 | 0.330210772833724 | 47 | 9 | 33 | 0 | 2 | 142 | 242 | 288 | MEN6621319.1 hypothetical protein [Smithella sp.] | diamond | 141 | 74.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Smithellaceae | Smithella | Smithella sp. | ||
| 27821999 | 27821999 | PRJNA944150_P_NODE_14844_length_221_cov_2.372093_g14593_i0 | PRJNA944150 | 14844 | 221 | 2.372093 | 5.24232553 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 109 | 6.68e-28 | NR | WP_164561688.1 | 881 | g14593 | i0 | 69.9 | 11.8642533936652 | 73 | 22 | 99.1 | 0 | 3 | 221 | 124 | 196 | WP_164561688.1 transglycosylase SLT domain-containing protein [Nitratidesulfovibrio vulgaris] | diamond | 2622 | 110 | 0.990909090909091 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Nitratidesulfovibrio | Nitratidesulfovibrio vulgaris | ||
| 28667655 | 28667655 | PRJNA944150_P_NODE_23387_length_189_cov_2.900000_g23136_i0 | PRJNA944150 | 23387 | 189 | 2.9 | 5.481 | Smithella sp. | 2053614 | Bacteria | Bacteria | 89.7 | 1.39e-19 | NR | MEN6621319.1 | 2053614 | g23136 | i0 | 77.6 | 0.920634920634921 | 58 | 13 | 92.1 | 0 | 4 | 177 | 102 | 159 | MEN6621319.1 hypothetical protein [Smithella sp.] | diamond | 174 | 89.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Smithellaceae | Smithella | Smithella sp. | ||
| 29488241 | 29488241 | PRJNA944150_P_NODE_40330_length_164_cov_0.886957_g40079_i0 | PRJNA944150 | 40330 | 164 | 0.886957 | 1.45460948 | Desulfohalobiaceae bacterium | 2683721 | Bacteria | Bacteria | 43.1 | 0.00934 | NR | MCF8029715.1 | 2683721 | g40079 | i0 | 90.9 | 0.804878048780488 | 22 | 2 | 40.2 | 0 | 67 | 2 | 1 | 22 | MCF8029715.1 tyrosine--tRNA ligase [Desulfohalobiaceae bacterium] | diamond | 132 | 43.1 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfohalobiaceae bacterium | |||
| 32435179 | 32435179 | PRJNA944150_P_NODE_14759_length_222_cov_1.179191_g14508_i0 | PRJNA944150 | 14759 | 222 | 1.179191 | 2.61780402 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 77.8 | 1.32e-15 | NR | PLX94609.1 | 892 | g14508 | i0 | 63.9 | 9.13513513513514 | 61 | 22 | 82.4 | 0 | 183 | 1 | 1 | 61 | PLX94609.1 MAG: methyltransferase [Desulfuromonas sp.] | diamond | 2028 | 77.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. | ||
| 32813304 | 32813304 | PRJNA944150_P_NODE_6960_length_325_cov_2.967391_g6709_i0 | PRJNA944150 | 6960 | 325 | 2.967391 | 9.64402075 | Bacteria | 2 | Bacteria | Bacteria | 43.9 | 0.0358 | NR | MCK5231445.1 | 2053307 | g6709 | i0 | 32.2 | 1.71692307692308 | 90 | 57 | 83.1 | 2 | 50 | 319 | 137 | 222 | MCK5231445.1 HAMP domain-containing protein [Desulfobulbaceae bacterium] | diamond | 558 | 43.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfobulbaceae bacterium |
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);;