contig_metadata
13 rows where bioproject = "PRJNA734348", tax_clade = "FCB group" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13472347 | 13472347 | PRJNA734348_P_NODE_57591_length_282_cov_1.444976_g56894_i0 | PRJNA734348 | 57591 | 282 | 1.444976 | 4.07483232 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 390 | 4.8499999999999996e-104 | NTclustered | gi|1938788434|gb|CP054181.1| | 2053306 | g56894 | i0 | 95.492 | 47.7659574468085 | 244 | 11 | 100 | 0 | 1 | 244 | 547033 | 547276 | Ignavibacteria bacterium isolate H1_BAC2 chromosome | blastn | 13470 | 390 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 17295488 | 17295488 | PRJNA734348_P_NODE_138934_length_234_cov_2.260870_g138236_i0 | PRJNA734348 | 138934 | 234 | 2.26087 | 5.2904358 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 162 | 1.5e-46 | NR | MBK6771184.1 | 2053306 | g138236 | i0 | 100 | 3 | 78 | 0 | 100 | 0 | 234 | 1 | 117 | 194 | MBK6771184.1 carboxylate-amine ligase [Ignavibacteria bacterium] | diamond | 702 | 162 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 21119514 | 21119514 | PRJNA734348_P_NODE_112577_length_246_cov_0.890173_g111879_i0 | PRJNA734348 | 112577 | 246 | 0.890173 | 2.18982558 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2621704225|emb|OY761615.1| | 2651163 | g111879 | i0 | 100 | 0.117886178861789 | 29 | 0 | 12 | 0 | 53 | 81 | 3594714 | 3594742 | MAG: Ignavibacteriaceae bacterium isolate 0c874fb2-9291-49ee-bde1-826c4484edf3 genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 27020835 | 27020835 | PRJNA734348_P_NODE_35522_length_327_cov_2.062992_g34826_i0 | PRJNA734348 | 35522 | 327 | 2.062992 | 6.74598384 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 47.4 | 0.00249 | NR | MBZ0184290.1 | 2614255 | g34826 | i0 | 31.4 | 0.963302752293578 | 105 | 58 | 90.8 | 3 | 4 | 300 | 1043 | 1139 | MBZ0184290.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Melioribacteraceae bacterium] | diamond | 315 | 47.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 27052515 | 27052515 | PRJNA734348_P_NODE_103742_length_248_cov_0.880000_g103044_i0 | PRJNA734348 | 103742 | 248 | 0.88 | 2.1824 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 129 | 4.32e-33 | NR | HQY20205.1 | 2053306 | g103044 | i0 | 74.4 | 1.98387096774194 | 82 | 21 | 99.2 | 0 | 246 | 1 | 285 | 366 | HQY20205.1 SBBP repeat-containing protein [Ignavibacteria bacterium] | diamond | 492 | 129 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 27557767 | 27557767 | PRJNA734348_P_NODE_61784_length_278_cov_1.234146_g61087_i0 | PRJNA734348 | 61784 | 278 | 1.234146 | 3.43092588 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 163 | 8.69e-49 | NR | MEO6694559.1 | 2053306 | g61087 | i0 | 81.5 | 0.992805755395683 | 92 | 17 | 99.3 | 0 | 277 | 2 | 55 | 146 | MEO6694559.1 FMN-binding negative transcriptional regulator [Ignavibacteria bacterium] | diamond | 276 | 163 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28442182 | 28442182 | PRJNA734348_P_NODE_106766_length_247_cov_1.649425_g106068_i0 | PRJNA734348 | 106766 | 247 | 1.649425 | 4.07407975 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 150 | 2.89e-44 | NR | MEZ4689852.1 | 2053306 | g106068 | i0 | 95.1 | 2.95141700404858 | 81 | 4 | 98.4 | 0 | 245 | 3 | 67 | 147 | MEZ4689852.1 polymer-forming cytoskeletal protein [Ignavibacteria bacterium] | diamond | 729 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28505163 | 28505163 | PRJNA734348_P_NODE_58147_length_281_cov_2.370192_g57450_i0 | PRJNA734348 | 58147 | 281 | 2.370192 | 6.66023952 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 168 | 9.64e-49 | NR | MEO6695344.1 | 2053306 | g57450 | i0 | 78.5 | 0.99288256227758 | 93 | 20 | 99.3 | 0 | 3 | 281 | 233 | 325 | MEO6695344.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Ignavibacteria bacterium] | diamond | 279 | 168 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 28537020 | 28537020 | PRJNA734348_P_NODE_69807_length_270_cov_1.375635_g69109_i0 | PRJNA734348 | 69807 | 270 | 1.375635 | 3.7142145 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 135 | 2.59e-38 | NR | MBK9405388.1 | 2053306 | g69109 | i0 | 91.3 | 1.53333333333333 | 69 | 6 | 76.7 | 0 | 209 | 3 | 1 | 69 | MBK9405388.1 dCTP deaminase [Ignavibacteria bacterium] | diamond | 414 | 135 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30021053 | 30021053 | PRJNA734348_P_NODE_72611_length_267_cov_1.752577_g71913_i0 | PRJNA734348 | 72611 | 267 | 1.752577 | 4.67938059 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 75.5 | 7.97e-15 | NR | KAB2847128.1 | 2614255 | g71913 | i0 | 40.7 | 1.93258426966292 | 86 | 51 | 96.6 | 0 | 266 | 9 | 33 | 118 | KAB2847128.1 MAG: hypothetical protein F9K45_00365 [Melioribacteraceae bacterium] | diamond | 516 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 30273892 | 30273892 | PRJNA734348_P_NODE_141952_length_229_cov_3.339744_g141254_i0 | PRJNA734348 | 141952 | 229 | 3.339744 | 7.64801376 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 139 | 1.6e-37 | NR | MBK6773539.1 | 2053306 | g141254 | i0 | 96.1 | 0.995633187772926 | 76 | 3 | 99.6 | 0 | 1 | 228 | 105 | 180 | MBK6773539.1 AAA family ATPase [Ignavibacteria bacterium] | diamond | 228 | 139 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31632620 | 31632620 | PRJNA734348_P_NODE_95176_length_250_cov_1.734463_g94478_i0 | PRJNA734348 | 95176 | 250 | 1.734463 | 4.3361575 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 139 | 8.25e-37 | NR | MBK8549615.1 | 2053306 | g94478 | i0 | 92.7 | 0.984 | 82 | 6 | 98.4 | 0 | 248 | 3 | 271 | 352 | MBK8549615.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 246 | 139 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32360602 | 32360602 | PRJNA734348_P_NODE_113039_length_246_cov_0.890173_g112341_i0 | PRJNA734348 | 113039 | 246 | 0.890173 | 2.18982558 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 154 | 9.749999999999999e-43 | NR | MEO6694617.1 | 2053306 | g112341 | i0 | 93.8 | 1.97560975609756 | 81 | 5 | 98.8 | 0 | 2 | 244 | 320 | 400 | MEO6694617.1 phosphoglucomutase/phosphomannomutase family protein [Ignavibacteria bacterium] | diamond | 486 | 154 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria 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);;