contig_metadata
8 rows where bioproject = "PRJEB76780", tax_phylum = "Thermodesulfobacteriota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12892255 | 12892255 | PRJEB76780_P_NODE_4671_length_376_cov_1.029703_g4571_i0 | PRJEB76780 | 4671 | 376 | 1.029703 | 3.87168328 | Pseudodesulfovibrio aespoeensis | 182210 | Bacteria | Bacteria | 230 | 1.5399999999999995e-55 | NTclustered | gi|316941978|gb|CP002431.1| | 643562 | g4571 | i0 | 78.797 | 69.5718085106383 | 349 | 68 | 92 | 3 | 3 | 348 | 2475509 | 2475854 | Pseudodesulfovibrio aespoeensis Aspo-2 chromosome, complete genome | blastn | 26159 | 230 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Pseudodesulfovibrio | Pseudodesulfovibrio aespoeensis | ||
| 16715404 | 16715404 | PRJEB76780_P_NODE_11134_length_250_cov_0.881356_g11034_i0 | PRJEB76780 | 11134 | 250 | 0.881356 | 2.20339 | Desulfuromonas sp. DDH964 | 1823759 | Bacteria | Bacteria | 159 | 1.3e-34 | NTclustered | gi|1015516084|gb|CP015080.1| | 1823759 | g11034 | i0 | 80.583 | 2.104 | 206 | 40 | 82 | 0 | 1 | 206 | 1372927 | 1373132 | Desulfuromonas sp. DDH964 chromosome, complete genome | blastn | 526 | 159 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. DDH964 | ||
| 19264307 | 19264307 | PRJEB76780_P_NODE_4716_length_374_cov_1.013289_g4616_i0 | PRJEB76780 | 4716 | 374 | 1.013289 | 3.78970086 | Desulfolithobacter dissulfuricans | 2795293 | Bacteria | Bacteria | 322 | 2.46e-83 | NTclustered | gi|2304357171|dbj|AP024233.1| | 2795293 | g4616 | i0 | 83.242 | 426.213903743315 | 364 | 48 | 96 | 10 | 1 | 358 | 1926416 | 1926772 | Desulfobulbaceae bacterium GF1 GF1 DNA, complete genome | blastn | 159404 | 322 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfolithobacter | Desulfolithobacter dissulfuricans | ||
| 27438064 | 27438064 | PRJEB76780_P_NODE_7683_length_291_cov_2.096330_g7583_i0 | PRJEB76780 | 7683 | 291 | 2.09633 | 6.1003203 | root | 1 | Root_unresolved | Root_unresolved | 86.3 | 3.47e-17 | NR | RJP83704.1 | 2049433 | g7583 | i0 | 42 | 4.06185567010309 | 100 | 54 | 100 | 2 | 1 | 291 | 125 | 223 | RJP83704.1 MAG: hypothetical protein C4522_00045 [Desulfobacteraceae bacterium] | diamond | 1182 | 86.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 28487090 | 28487090 | PRJEB76780_P_NODE_13147_length_243_cov_0.917647_g13047_i0 | PRJEB76780 | 13147 | 243 | 0.917647 | 2.22988221 | Desulfohalobiaceae bacterium | 2683721 | Bacteria | Bacteria | 117 | 3.55e-29 | NR | MCF8030969.1 | 2683721 | g13047 | i0 | 69.1 | 1 | 81 | 24 | 98.8 | 1 | 3 | 242 | 111 | 191 | MCF8030969.1 outer membrane homotrimeric porin [Desulfohalobiaceae bacterium] | diamond | 243 | 117 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfohalobiaceae | Desulfohalobiaceae bacterium | |||
| 29300697 | 29300697 | PRJEB76780_P_NODE_12149_length_246_cov_1.335260_g12049_i0 | PRJEB76780 | 12149 | 246 | 1.33526 | 3.2847396 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 59.7 | 4.17e-8 | NR | WP_035247523.1 | 160661 | g12049 | i0 | 41 | 2.52439024390244 | 78 | 46 | 95.1 | 0 | 5 | 238 | 1628 | 1705 | WP_035247523.1 SBBP repeat-containing protein, partial [Desulfogranum mediterraneum] | diamond | 621 | 59.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfogranum | Desulfogranum mediterraneum | ||
| 30761021 | 30761021 | PRJEB76780_P_NODE_12574_length_245_cov_0.906977_g12474_i0 | PRJEB76780 | 12574 | 245 | 0.906977 | 2.22209365 | Desulfobacterales bacterium | 2044940 | Bacteria | Bacteria | 169 | 3.73e-47 | NR | MBS3756811.1 | 2044940 | g12474 | i0 | 93.8 | 1.98367346938776 | 81 | 5 | 99.2 | 0 | 244 | 2 | 576 | 656 | MBS3756811.1 molybdopterin-dependent oxidoreductase [Desulfobacterales bacterium] | diamond | 486 | 169 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 32145054 | 32145054 | PRJEB76780_P_NODE_6118_length_326_cov_1.845850_g6018_i0 | PRJEB76780 | 6118 | 326 | 1.84585 | 6.017471 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 68.9 | 1.22e-12 | NR | MFO7665801.1 | 2044940 | g6018 | i0 | 57.6 | 2.73312883435583 | 59 | 23 | 54.3 | 1 | 318 | 142 | 39 | 95 | MFO7665801.1 co-chaperone GroES [Desulfobacterales bacterium] | diamond | 891 | 68.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales 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);;