contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA849646" and tax_phylum = "Deferribacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3388739 | 3388739 | PRJNA849646_P_NODE_10583_length_286_cov_4.018779_g10465_i0 | PRJNA849646 | 10583 | 286 | 4.018779 | 11.49370794 | Calditerrivibrio sp. | 2792612 | Bacteria | Bacteria | 181 | 6.64e-53 | NR | MCX8084312.1 | 2792612 | g10465 | i0 | 96.8 | 1.99300699300699 | 95 | 3 | 99.7 | 0 | 2 | 286 | 102 | 196 | MCX8084312.1 UDP-glucose/GDP-mannose dehydrogenase family protein [Calditerrivibrio sp.] | diamond | 570 | 181 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio sp. | ||
| 7216149 | 7216149 | PRJNA849646_P_NODE_11686_length_284_cov_2.464455_g11568_i0 | PRJNA849646 | 11686 | 284 | 2.464455 | 6.9990522 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 58.5 | 1.65e-7 | NR | PMP71354.1 | 477976 | g11568 | i0 | 53.8 | 0.549295774647887 | 52 | 24 | 54.9 | 0 | 158 | 3 | 1 | 52 | PMP71354.1 MAG: hypothetical protein C0187_04295 [Calditerrivibrio nitroreducens] | diamond | 156 | 58.5 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 26737936 | 26737936 | PRJNA849646_P_NODE_21221_length_266_cov_1.595855_g21103_i0 | PRJNA849646 | 21221 | 266 | 1.595855 | 4.2449743 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 151 | 1.0599999999999999e-42 | NR | WP_041724295.1 | 477976 | g21103 | i0 | 84.1 | 0.992481203007519 | 88 | 14 | 99.2 | 0 | 264 | 1 | 154 | 241 | WP_041724295.1 beta-ketoacyl-ACP synthase 3 [Calditerrivibrio nitroreducens] | diamond | 264 | 151 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 26928349 | 26928349 | PRJNA849646_P_NODE_8062_length_292_cov_2.954338_g7944_i0 | PRJNA849646 | 8062 | 292 | 2.954338 | 8.62666696 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 71.6 | 1.22e-13 | NR | WP_013452160.1 | 477976 | g7944 | i0 | 84.1 | 0.452054794520548 | 44 | 7 | 45.2 | 0 | 3 | 134 | 37 | 80 | WP_013452160.1 hypothetical protein [Calditerrivibrio nitroreducens] | diamond | 132 | 71.6 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 27086583 | 27086583 | PRJNA849646_P_NODE_11802_length_284_cov_1.919431_g11684_i0 | PRJNA849646 | 11802 | 284 | 1.919431 | 5.45118404 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 142 | 1.56e-39 | NR | WP_013450723.1 | 477976 | g11684 | i0 | 71.1 | 1.90140845070423 | 90 | 26 | 95.1 | 0 | 274 | 5 | 1 | 90 | WP_013450723.1 MBL fold metallo-hydrolase [Calditerrivibrio nitroreducens] | diamond | 540 | 142 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 27687081 | 27687081 | PRJNA849646_P_NODE_5024_length_310_cov_3.219409_g4906_i0 | PRJNA849646 | 5024 | 310 | 3.219409 | 9.9801679 | Calditerrivibrio sp. | 2792612 | Bacteria | Bacteria | 62.4 | 4.55e-9 | NR | MCA1926956.1 | 2792612 | g4906 | i0 | 50.9 | 0.532258064516129 | 55 | 27 | 53.2 | 0 | 168 | 4 | 26 | 80 | MCA1926956.1 precorrin-6A reductase [Calditerrivibrio sp.] | diamond | 165 | 62.4 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio sp. | ||
| 27844411 | 27844411 | PRJNA849646_P_NODE_39964_length_235_cov_3.425926_g39846_i0 | PRJNA849646 | 39964 | 235 | 3.425926 | 8.0509261 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 145 | 3.89e-39 | NR | WP_013450900.1 | 477976 | g39846 | i0 | 87.2 | 0.995744680851064 | 78 | 10 | 99.6 | 0 | 2 | 235 | 127 | 204 | WP_013450900.1 phosphate acyltransferase [Calditerrivibrio nitroreducens] | diamond | 234 | 145 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 28191650 | 28191650 | PRJNA849646_P_NODE_24626_length_259_cov_4.048387_g24508_i0 | PRJNA849646 | 24626 | 259 | 4.048387 | 10.48532233 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 117 | 3.31e-28 | NR | WP_171789024.1 | 477976 | g24508 | i0 | 67.5 | 1.85328185328185 | 80 | 26 | 92.7 | 0 | 242 | 3 | 619 | 698 | WP_171789024.1 HD domain-containing phosphohydrolase [Calditerrivibrio nitroreducens] | diamond | 480 | 117 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 28254954 | 28254954 | PRJNA849646_P_NODE_7966_length_293_cov_1.936364_g7848_i0 | PRJNA849646 | 7966 | 293 | 1.936364 | 5.67354652 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 99.4 | 4.39e-22 | NR | WP_013451025.1 | 477976 | g7848 | i0 | 92.3 | 1.06484641638225 | 52 | 4 | 53.2 | 0 | 293 | 138 | 90 | 141 | WP_013451025.1 dihydroorotase [Calditerrivibrio nitroreducens] | diamond | 312 | 99.4 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 28294866 | 28294866 | PRJNA849646_P_NODE_4926_length_310_cov_3.291139_g4808_i0 | PRJNA849646 | 4926 | 310 | 3.291139 | 10.2025309 | Calditerrivibrio | 545865 | Bacteria | Bacteria | 129 | 2.67e-33 | NR | WP_013450333.1 | 477976 | g4808 | i0 | 63.9 | 2.05161290322581 | 108 | 30 | 98.7 | 2 | 308 | 3 | 29 | 133 | WP_013450333.1 HD-GYP domain-containing protein [Calditerrivibrio nitroreducens] | diamond | 636 | 129 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 28697269 | 28697269 | PRJNA849646_P_NODE_41327_length_229_cov_4.871795_g41209_i0 | PRJNA849646 | 41327 | 229 | 4.871795 | 11.15641055 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 139 | 4.59e-37 | NR | WP_013451338.1 | 477976 | g41209 | i0 | 90.8 | 0.995633187772926 | 76 | 7 | 99.6 | 0 | 2 | 229 | 369 | 444 | WP_013451338.1 TrkH family potassium uptake protein [Calditerrivibrio nitroreducens] | diamond | 228 | 139 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 28854794 | 28854794 | PRJNA849646_P_NODE_19888_length_268_cov_3.846154_g19770_i0 | PRJNA849646 | 19888 | 268 | 3.846154 | 10.30769272 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 161 | 6.01e-48 | NR | WP_013451946.1 | 477976 | g19770 | i0 | 93.2 | 0.985074626865672 | 88 | 6 | 98.5 | 0 | 266 | 3 | 23 | 110 | WP_013451946.1 GntR family transcriptional regulator [Calditerrivibrio nitroreducens] | diamond | 264 | 161 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 29107662 | 29107662 | PRJNA849646_P_NODE_11688_length_284_cov_2.450237_g11570_i0 | PRJNA849646 | 11688 | 284 | 2.450237 | 6.95867308 | Calditerrivibrio sp. | 2792612 | Bacteria | Bacteria | 142 | 8.299999999999998e-41 | NR | MCX8084670.1 | 2792612 | g11570 | i0 | 90.9 | 1.63732394366197 | 77 | 7 | 81.3 | 0 | 51 | 281 | 1 | 77 | MCX8084670.1 peptide deformylase [Calditerrivibrio sp.] | diamond | 465 | 142 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio sp. | ||
| 29486196 | 29486196 | PRJNA849646_P_NODE_17410_length_273_cov_2.210000_g17292_i0 | PRJNA849646 | 17410 | 273 | 2.21 | 6.0333 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 131 | 3.1899999999999996e-35 | NR | WP_013451193.1 | 477976 | g17292 | i0 | 67 | 1 | 91 | 30 | 100 | 0 | 273 | 1 | 73 | 163 | WP_013451193.1 tRNA (adenosine(37)-N6)-dimethylallyltransferase MiaA [Calditerrivibrio nitroreducens] | diamond | 273 | 131 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 29486200 | 29486200 | PRJNA849646_P_NODE_28090_length_253_cov_1.711111_g27972_i0 | PRJNA849646 | 28090 | 253 | 1.711111 | 4.32911083 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 157 | 7.62e-46 | NR | WP_013451142.1 | 477976 | g27972 | i0 | 92.9 | 0.99604743083004 | 84 | 6 | 99.6 | 0 | 1 | 252 | 85 | 168 | WP_013451142.1 slipin family protein [Calditerrivibrio nitroreducens] | diamond | 252 | 157 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 29612388 | 29612388 | PRJNA849646_P_NODE_29730_length_250_cov_3.677966_g29612_i0 | PRJNA849646 | 29730 | 250 | 3.677966 | 9.194915 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 155 | 4.11e-44 | NR | WP_013451120.1 | 477976 | g29612 | i0 | 96.1 | 0.924 | 77 | 3 | 92.4 | 0 | 250 | 20 | 265 | 341 | WP_013451120.1 aspartate-semialdehyde dehydrogenase [Calditerrivibrio nitroreducens] | diamond | 231 | 155 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 29770463 | 29770463 | PRJNA849646_P_NODE_15091_length_278_cov_1.351220_g14973_i0 | PRJNA849646 | 15091 | 278 | 1.35122 | 3.7563916 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 160 | 3.459999999999999e-43 | NR | WP_013450561.1 | 477976 | g14973 | i0 | 90.2 | 0.992805755395683 | 92 | 9 | 99.3 | 0 | 277 | 2 | 782 | 873 | WP_013450561.1 SpoIIE family protein phosphatase [Calditerrivibrio nitroreducens] | diamond | 276 | 160 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 30718307 | 30718307 | PRJNA849646_P_NODE_11534_length_285_cov_1.193396_g11416_i0 | PRJNA849646 | 11534 | 285 | 1.193396 | 3.4011786 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 187 | 6.809999999999999e-55 | NR | WP_013451248.1 | 477976 | g11416 | i0 | 95.8 | 1 | 95 | 4 | 100 | 0 | 1 | 285 | 73 | 167 | WP_013451248.1 L-aspartate oxidase [Calditerrivibrio nitroreducens] | diamond | 285 | 187 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 31160336 | 31160336 | PRJNA849646_P_NODE_10035_length_288_cov_1.232558_g9917_i0 | PRJNA849646 | 10035 | 288 | 1.232558 | 3.54976704 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 179 | 3.639999999999999e-55 | NR | WP_013450324.1 | 477976 | g9917 | i0 | 84.4 | 1 | 96 | 15 | 100 | 0 | 1 | 288 | 28 | 123 | WP_013450324.1 isochorismatase family protein [Calditerrivibrio nitroreducens] | diamond | 288 | 179 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 31390548 | 31390548 | PRJNA849646_P_NODE_30796_length_249_cov_2.267045_g30678_i0 | PRJNA849646 | 30796 | 249 | 2.267045 | 5.64494205 | Calditerrivibrio | 545865 | Bacteria | Bacteria | 89 | 1.91e-18 | NR | WP_013450164.1 | 477976 | g30678 | i0 | 97.6 | 2.02409638554217 | 42 | 1 | 50.6 | 0 | 1 | 126 | 433 | 474 | WP_013450164.1 aldehyde dehydrogenase family protein [Calditerrivibrio nitroreducens] | diamond | 504 | 89 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 31508783 | 31508783 | PRJNA849646_P_NODE_15716_length_276_cov_2.788177_g15598_i0 | PRJNA849646 | 15716 | 276 | 2.788177 | 7.69536852 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 167 | 1.6399999999999998e-47 | NR | WP_013451075.1 | 477976 | g15598 | i0 | 90.1 | 0.989130434782609 | 91 | 9 | 98.9 | 0 | 274 | 2 | 298 | 388 | WP_013451075.1 DegQ family serine endoprotease [Calditerrivibrio nitroreducens] | diamond | 273 | 167 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 32046453 | 32046453 | PRJNA849646_P_NODE_26618_length_256_cov_1.306011_g26500_i0 | PRJNA849646 | 26618 | 256 | 1.306011 | 3.34338816 | Calditerrivibrio sp. | 2792612 | Bacteria | Bacteria | 140 | 6.95e-39 | NR | MCX8083301.1 | 2792612 | g26500 | i0 | 81 | 1.96875 | 84 | 16 | 98.4 | 0 | 3 | 254 | 26 | 109 | MCX8083301.1 ParB/RepB/Spo0J family partition protein [Calditerrivibrio sp.] | diamond | 504 | 140 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio sp. | ||
| 32615683 | 32615683 | PRJNA849646_P_NODE_30480_length_250_cov_0.870056_g30362_i0 | PRJNA849646 | 30480 | 250 | 0.870056 | 2.17514 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 137 | 7.07e-39 | NR | WP_013450181.1 | 477976 | g30362 | i0 | 82.3 | 0.948 | 79 | 14 | 94.8 | 0 | 250 | 14 | 113 | 191 | WP_013450181.1 DedA family protein [Calditerrivibrio nitroreducens] | diamond | 237 | 137 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens | ||
| 32773002 | 32773002 | PRJNA849646_P_NODE_10140_length_287_cov_2.850467_g10022_i0 | PRJNA849646 | 10140 | 287 | 2.850467 | 8.18084029 | Calditerrivibrio nitroreducens | 477976 | Bacteria | Bacteria | 165 | 8.77e-47 | NR | WP_013451819.1 | 477976 | g10022 | i0 | 89.5 | 1.98606271777003 | 95 | 10 | 99.3 | 0 | 1 | 285 | 65 | 159 | WP_013451819.1 sigma-54-dependent transcriptional regulator [Calditerrivibrio nitroreducens] | diamond | 570 | 165 | 1 | Bacteria | Pseudomonadati | Deferribacterota | Deferribacteres | Deferribacterales | Calditerrivibrionaceae | Calditerrivibrio | Calditerrivibrio nitroreducens |
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);;