contig_metadata
10 rows where bioproject = "PRJNA599026", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 571953 | 571953 | PRJNA599026_S_NODE_61061_length_164_cov_0.886957_g60605_i0 | PRJNA599026 | 61061 | 164 | 0.886957 | 1.45460948 | Pseudodesulfovibrio indicus | 1716143 | Bacteria | Bacteria | 56.5 | 0.001 | NTclustered | gi|998152336|gb|CP014206.1| | 1716143 | g60605 | i0 | 89.362 | 0.463414634146341 | 47 | 1 | 29 | 3 | 19 | 65 | 3366568 | 3366526 | Pseudodesulfovibrio indicus strain J2 chromosome, complete genome | blastn | 76 | 56.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Pseudodesulfovibrio | Pseudodesulfovibrio indicus | ||
| 8793920 | 8793920 | PRJNA599026_S_NODE_14007_length_267_cov_8.669725_g13551_i0 | PRJNA599026 | 14007 | 267 | 8.669725 | 23.14816575 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 89 | 2.75e-18 | NR | WP_051305862.1 | 160661 | g13551 | i0 | 60 | 3.68539325842697 | 65 | 26 | 73 | 0 | 197 | 3 | 633 | 697 | WP_051305862.1 aconitate hydratase AcnA [Desulfogranum mediterraneum] | diamond | 984 | 89 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobulbia | Desulfobulbales | Desulfobulbaceae | Desulfogranum | Desulfogranum mediterraneum | ||
| 10069785 | 10069785 | PRJNA599026_S_NODE_31488_length_198_cov_1.369128_g31032_i0 | PRJNA599026 | 31488 | 198 | 1.369128 | 2.71087344 | root | 1 | Root_unresolved | Root_unresolved | 178 | 2.71e-40 | NTclustered | gi|85720936|gb|CP000252.1| | 56780 | g31032 | i0 | 85.799 | 156.272727272727 | 169 | 23 | 85 | 1 | 30 | 198 | 742330 | 742497 | Syntrophus aciditrophicus SB, complete genome | blastn | 30942 | 178 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophus | Syntrophus aciditrophicus | ||
| 13325883 | 13325883 | PRJNA599026_S_NODE_59351_length_164_cov_1.547826_g58895_i0 | PRJNA599026 | 59351 | 164 | 1.547826 | 2.53843464 | uncultured Desulfobacter sp. | 240139 | Bacteria | Bacteria | 63.9 | 6.33e-6 | NTclustered | gi|2621717585|emb|OY775937.1| | 240139 | g58895 | i0 | 87.273 | 4.70731707317073 | 55 | 7 | 34 | 0 | 1 | 55 | 1216100 | 1216046 | MAG: uncultured Desulfobacter sp. isolate 6579293f-26f5-4e71-a9db-d48b61c722da genome assembly, chromosome: 1 | blastn | 772 | 63.9 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacter | uncultured Desulfobacter sp. | ||
| 27156051 | 27156051 | PRJNA599026_S_NODE_47202_length_171_cov_1.614754_g46746_i0 | PRJNA599026 | 47202 | 171 | 1.614754 | 2.76122934 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 58.2 | 6.84e-9 | NR | MCG8472201.1 | 2044940 | g46746 | i0 | 45.5 | 3.80701754385965 | 55 | 29 | 96.5 | 1 | 167 | 3 | 18 | 71 | MCG8472201.1 6-carboxytetrahydropterin synthase QueD [Desulfobacterales bacterium] | diamond | 651 | 58.5 | 0.994871794871795 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacterales bacterium | ||||
| 28229914 | 28229914 | PRJNA599026_S_NODE_54326_length_166_cov_0.871795_g53870_i0 | PRJNA599026 | 54326 | 166 | 0.871795 | 1.4471797 | root | 1 | Root_unresolved | Root_unresolved | 63.2 | 3.07e-10 | NR | PLY02973.1 | 892 | g53870 | i0 | 60 | 24.5421686746988 | 55 | 22 | 99.4 | 0 | 166 | 2 | 111 | 165 | PLY02973.1 MAG: guanylate kinase [Desulfuromonas sp.] | diamond | 4074 | 63.5 | 0.995275590551181 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. | ||
| 29100998 | 29100998 | PRJNA599026_S_NODE_30228_length_201_cov_1.006579_g29772_i0 | PRJNA599026 | 30228 | 201 | 1.006579 | 2.02322379 | Syntrophobacteraceae bacterium | 2052185 | Bacteria | Bacteria | 63.2 | 1.23e-9 | NR | MEM5787735.1 | 2052185 | g29772 | i0 | 51.7 | 0.895522388059702 | 60 | 29 | 89.6 | 0 | 199 | 20 | 274 | 333 | MEM5787735.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Syntrophobacteraceae bacterium] | diamond | 180 | 63.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Syntrophobacteraceae bacterium | |||
| 29903764 | 29903764 | PRJNA599026_S_NODE_34311_length_192_cov_1.426573_g33855_i0 | PRJNA599026 | 34311 | 192 | 1.426573 | 2.73902016 | Bacteria | 2 | Bacteria | Bacteria | 42 | 0.0338 | NR | MCP4022144.1 | 2049433 | g33855 | i0 | 42.1 | 1.359375 | 38 | 22 | 59.4 | 0 | 77 | 190 | 14 | 51 | MCP4022144.1 alpha/beta hydrolase [Desulfobacteraceae bacterium] | diamond | 261 | 42.4 | 0.990566037735849 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 31533848 | 31533848 | PRJNA599026_S_NODE_70836_length_161_cov_0.910714_g70380_i0 | PRJNA599026 | 70836 | 161 | 0.910714 | 1.46624954 | Candidatus Dadabacteria bacterium | 2080303 | Bacteria | Bacteria | 101 | 7.27e-25 | NR | MCL4243683.1 | 2080303 | g70380 | i0 | 96.2 | 0.987577639751553 | 53 | 2 | 98.8 | 0 | 161 | 3 | 31 | 83 | MCL4243683.1 metal-dependent transcriptional regulator [Candidatus Dadabacteria bacterium] | diamond | 159 | 101 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Candidatus Dadabacteria | Candidatus Dadabacteria bacterium | |||||
| 32039810 | 32039810 | PRJNA599026_S_NODE_67098_length_162_cov_0.902655_g66642_i0 | PRJNA599026 | 67098 | 162 | 0.902655 | 1.4623011 | Thermodesulfobacteriota bacterium | 2202153 | Bacteria | Bacteria | 47 | 1.34e-4 | NR | MDY6880885.1 | 2202153 | g66642 | i0 | 72.4 | 0.537037037037037 | 29 | 8 | 53.7 | 0 | 1 | 87 | 104 | 132 | MDY6880885.1 hypothetical protein [Thermodesulfobacteriota bacterium] | diamond | 87 | 47 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota 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);;