contig_metadata
10 rows where bioproject = "PRJNA283169", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 371803 | 371803 | PRJNA283169_P_NODE_6381_length_169_cov_1.733333_g6318_i0 | PRJNA283169 | 6381 | 169 | 1.733333 | 2.92933277 | Desulfuromonas sp. DDH964 | 1823759 | Bacteria | Bacteria | 141 | 2.93e-29 | NTclustered | gi|1015516084|gb|CP015080.1| | 1823759 | g6318 | i0 | 89.474 | 2.69822485207101 | 114 | 9 | 66 | 2 | 14 | 124 | 2846962 | 2847075 | Desulfuromonas sp. DDH964 chromosome, complete genome | blastn | 456 | 141 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Desulfuromonadales | Desulfuromonadaceae | Desulfuromonas | Desulfuromonas sp. DDH964 | ||
| 4198868 | 4198868 | PRJNA283169_P_NODE_2224_length_275_cov_1.079646_g2162_i0 | PRJNA283169 | 2224 | 275 | 1.079646 | 2.9690265 | uncultured Desulfosarcina sp. | 218289 | Bacteria | Bacteria | 189 | 1.8499999999999993e-43 | NTclustered | gi|2621713517|emb|OY771548.1| | 218289 | g2162 | i0 | 84.974 | 311.832727272727 | 193 | 21 | 69 | 7 | 6 | 195 | 92241 | 92428 | MAG: uncultured Desulfosarcina sp. isolate c75788b4-9dc9-432e-af07-dc879bdb42fc genome assembly, chromosome: 1 | blastn | 85754 | 189 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfosarcinaceae | Desulfosarcina | uncultured Desulfosarcina sp. | ||
| 26870621 | 26870621 | PRJNA283169_P_NODE_3621_length_218_cov_1.479290_g3558_i0 | PRJNA283169 | 3621 | 218 | 1.47929 | 3.2248522 | Bacteria | 2 | Bacteria | Bacteria | 59.7 | 2.67e-8 | NR | MDY6905823.1 | 2202153 | g3558 | i0 | 49.2 | 1.69266055045872 | 61 | 28 | 79.8 | 1 | 43 | 216 | 136 | 196 | MDY6905823.1 glycosyltransferase family 4 protein [Thermodesulfobacteriota bacterium] | diamond | 369 | 60.1 | 0.993344425956739 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Thermodesulfobacteriota bacterium | ||||||
| 27755427 | 27755427 | PRJNA283169_P_NODE_6264_length_171_cov_1.270492_g6201_i0 | PRJNA283169 | 6264 | 171 | 1.270492 | 2.17254132 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.00128 | NR | MCP3899137.1 | 2049433 | g6201 | i0 | 41.7 | 8.07017543859649 | 48 | 28 | 84.2 | 0 | 171 | 28 | 77 | 124 | MCP3899137.1 HNH endonuclease [Desulfobacteraceae bacterium] | diamond | 1380 | 45.8 | 0.991266375545852 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfobacteria | Desulfobacterales | Desulfobacteraceae | Desulfobacteraceae bacterium | |||
| 28558596 | 28558596 | PRJNA283169_P_NODE_647_length_478_cov_1.069930_g585_i0 | PRJNA283169 | 647 | 478 | 1.06993 | 5.1142654 | Syntrophaceae bacterium | 2052184 | Bacteria | Bacteria | 63.2 | 1.7e-9 | NR | MBN1545415.1 | 2052184 | g585 | i0 | 68.3 | 0.257322175732218 | 41 | 13 | 25.7 | 0 | 345 | 467 | 1 | 41 | MBN1545415.1 HNH endonuclease [Syntrophaceae bacterium] | diamond | 123 | 63.2 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophaceae | Syntrophaceae bacterium | |||
| 29158532 | 29158532 | PRJNA283169_S_NODE_3009_length_168_cov_0.184874_g2995_i0 | PRJNA283169 | 3009 | 168 | 0.184874 | 0.31058832 | Syntrophobacter sp. | 66700 | Bacteria | Bacteria | 45.4 | 0.00148 | NR | MEN6441859.1 | 66700 | g2995 | i0 | 72.4 | 1.16071428571429 | 29 | 8 | 51.8 | 0 | 149 | 63 | 268 | 296 | MEN6441859.1 site-specific DNA-methyltransferase [Syntrophobacter sp.] | diamond | 195 | 45.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophobacteria | Syntrophobacterales | Syntrophobacteraceae | Syntrophobacter | Syntrophobacter sp. | ||
| 29663153 | 29663153 | PRJNA283169_P_NODE_3630_length_218_cov_1.177515_g3567_i0 | PRJNA283169 | 3630 | 218 | 1.177515 | 2.5669827 | Geobacter sp. SVR | 2495594 | Bacteria | Bacteria | 58.5 | 5.75e-8 | NR | WP_173202292.1 | 2495594 | g3567 | i0 | 41.1 | 1.0045871559633 | 73 | 35 | 92.2 | 2 | 203 | 3 | 30 | 100 | WP_173202292.1 hypothetical protein [Geobacter sp. SVR] | diamond | 219 | 58.5 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfuromonadia | Geobacterales | Geobacteraceae | Geobacter | Geobacter sp. SVR | ||
| 30073979 | 30073979 | PRJNA283169_P_NODE_7772_length_163_cov_0.912281_g7709_i0 | PRJNA283169 | 7772 | 163 | 0.912281 | 1.48701803 | Fundidesulfovibrio soli | 2922716 | Bacteria | Bacteria | 62.4 | 1.47e-9 | NR | WP_243366459.1 | 2922716 | g7709 | i0 | 63 | 1.69325153374233 | 46 | 17 | 84.7 | 0 | 139 | 2 | 260 | 305 | WP_243366459.1 DNA primase family protein [Fundidesulfovibrio soli] | diamond | 276 | 62.4 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Desulfovibrionia | Desulfovibrionales | Desulfovibrionaceae | Fundidesulfovibrio | Fundidesulfovibrio soli | ||
| 31085192 | 31085192 | PRJNA283169_P_NODE_4055_length_208_cov_1.150943_g3992_i0 | PRJNA283169 | 4055 | 208 | 1.150943 | 2.39396144 | Smithella sp. | 2053614 | Bacteria | Bacteria | 74.3 | 5.07e-14 | NR | MEN6623838.1 | 2053614 | g3992 | i0 | 52.3 | 0.9375 | 65 | 31 | 93.8 | 0 | 11 | 205 | 22 | 86 | MEN6623838.1 hypothetical protein [Smithella sp.] | diamond | 195 | 74.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Smithellaceae | Smithella | Smithella sp. | ||
| 31559682 | 31559682 | PRJNA283169_S_NODE_2276_length_189_cov_0.100000_g2262_i0 | PRJNA283169 | 2276 | 189 | 0.1 | 0.189 | Syntrophales bacterium LBB04 | 2914040 | Bacteria | Bacteria | 44.3 | 0.00527 | NR | MCG6537805.1 | 2914040 | g2262 | i0 | 38 | 0.793650793650794 | 50 | 31 | 79.4 | 0 | 13 | 162 | 317 | 366 | MCG6537805.1 hypothetical protein [Syntrophales bacterium LBB04] | diamond | 150 | 44.3 | 1 | Bacteria | Pseudomonadati | Thermodesulfobacteriota | Syntrophia | Syntrophales | Syntrophales bacterium LBB04 |
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);;