contig_metadata
7 rows where bioproject = "PRJNA929522" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26835142 | 26835142 | PRJNA929522_S_NODE_9761_length_243_cov_0.905882_g9691_i0 | PRJNA929522 | 9761 | 243 | 0.905882 | 2.20129326 | Desulfobacteraceae bacterium | 2049433 | Bacteria | Bacteria | 85.9 | 1.53e-17 | NR | HDI78119.1 | 2049433 | g9691 | i0 | 61.2 | 0.827160493827161 | 67 | 25 | 82.7 | 1 | 239 | 39 | 93 | 158 | HDI78119.1 AMP-dependent synthetase [Desulfobacteraceae bacterium] | diamond | 201 | 85.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 27404296 | 27404296 | PRJNA929522_S_NODE_8723_length_249_cov_1.750000_g8653_i0 | PRJNA929522 | 8723 | 249 | 1.75 | 4.3575 | Desulfonatronospira | 488937 | Bacteria | Bacteria | 76.6 | 3.3e-16 | NR | WP_008868844.1 | 488937 | g8653 | i0 | 50.6 | 1.91566265060241 | 79 | 36 | 94 | 2 | 2 | 235 | 7 | 83 | WP_008868844.1 MULTISPECIES: RNA recognition motif domain-containing protein [Desulfonatronospira] | diamond | 477 | 76.6 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfonatronovibrionaceae | Desulfonatronospira | |||
| 27783213 | 27783213 | PRJNA929522_S_NODE_9104_length_247_cov_0.885057_g9034_i0 | PRJNA929522 | 9104 | 247 | 0.885057 | 2.18609079 | Desulfobacterales bacterium C | 2044940 | Bacteria | Bacteria | 62 | 6.12e-9 | NR | OEU54199.1 | 1869301 | g9034 | i0 | 43 | 1.04453441295547 | 86 | 38 | 97.2 | 2 | 242 | 3 | 216 | 296 | OEU54199.1 MAG: hypothetical protein BA868_00305 [Desulfobacterales bacterium C00003106] | diamond | 258 | 62 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium C00003106 | ||||
| 28035718 | 28035718 | PRJNA929522_S_NODE_3785_length_347_cov_1.583942_g3715_i0 | PRJNA929522 | 3785 | 347 | 1.583942 | 5.49627874 | Geobacteraceae bacterium | 2282154 | Bacteria | Bacteria | 58.9 | 9e-8 | NR | NTV48441.1 | 2282154 | g3715 | i0 | 45.5 | 1.11527377521614 | 66 | 34 | 57.1 | 1 | 75 | 272 | 25 | 88 | NTV48441.1 sel1 repeat family protein [Geobacteraceae bacterium] | diamond | 387 | 58.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacteraceae bacterium | |||
| 29898630 | 29898630 | PRJNA929522_S_NODE_1031_length_629_cov_3.350719_g967_i0 | PRJNA929522 | 1031 | 629 | 3.350719 | 21.07602251 | Candidatus Desulfatibia sp. | 3101189 | Bacteria | Bacteria | 47.8 | 0.0158 | NR | WP_413886086.1 | 3101189 | g967 | i0 | 58.8 | 0.162162162162162 | 34 | 14 | 16.2 | 0 | 254 | 153 | 272 | 305 | WP_413886086.1 MORN repeat-containing protein [Candidatus Desulfatibia sp.] | diamond | 102 | 47.8 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Candidatus Desulfatibia | Candidatus Desulfatibia sp. | |||
| 30435933 | 30435933 | PRJNA929522_S_NODE_7053_length_270_cov_2.989848_g6983_i0 | PRJNA929522 | 7053 | 270 | 2.989848 | 8.0725896 | Desulfobacula sp. | 2593537 | Bacteria | Bacteria | 64.7 | 5.76e-10 | NR | WP_291460074.1 | 2593537 | g6983 | i0 | 48.4 | 2.66666666666667 | 64 | 28 | 67.8 | 2 | 86 | 268 | 2 | 63 | WP_291460074.1 class I SAM-dependent methyltransferase [Desulfobacula sp.] | diamond | 720 | 64.7 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacula | Desulfobacula sp. | ||
| 32086724 | 32086724 | PRJNA929522_S_NODE_398_length_938_cov_2.943353_g355_i0 | PRJNA929522 | 398 | 938 | 2.943353 | 27.60865114 | Bacteria | 2 | Bacteria | Bacteria | 136 | 1.63e-33 | NR | HOV86291.1 | 2052185 | g355 | i0 | 38.3 | 4.33049040511727 | 230 | 128 | 70.4 | 8 | 688 | 29 | 126 | 351 | HOV86291.1 hypothetical protein [Syntrophobacteraceae bacterium] | diamond | 4062 | 136 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Syntrophobacteraceae 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);;