contig_metadata
9 rows where bioproject = "PRJNA688352" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27271870 | 27271870 | PRJNA688352_P_NODE_11543_length_242_cov_0.911243_g11440_i0 | PRJNA688352 | 11543 | 242 | 0.911243 | 2.20520806 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 77 | 6.91e-16 | NR | MCW8850692.1 | 2614255 | g11440 | i0 | 62.7 | 0.830578512396694 | 67 | 25 | 83.1 | 0 | 2 | 202 | 63 | 129 | MCW8850692.1 MerR family transcriptional regulator [Melioribacteraceae bacterium] | diamond | 201 | 77 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 27745852 | 27745852 | PRJNA688352_P_NODE_11084_length_243_cov_0.905882_g10981_i0 | PRJNA688352 | 11084 | 243 | 0.905882 | 2.20129326 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 158 | 4.63e-44 | NR | HEX9739701.1 | 2651163 | g10981 | i0 | 88.8 | 0.987654320987654 | 80 | 9 | 98.8 | 0 | 3 | 242 | 106 | 185 | HEX9739701.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 240 | 158 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 28641436 | 28641436 | PRJNA688352_P_NODE_10127_length_245_cov_0.895349_g10024_i0 | PRJNA688352 | 10127 | 245 | 0.895349 | 2.19360505 | Bacteria | 2 | Bacteria | Bacteria | 135 | 1.4099999999999998e-37 | NR | MFI5237741.1 | 2049428 | g10024 | i0 | 85.2 | 6.94285714285714 | 81 | 12 | 99.2 | 0 | 243 | 1 | 113 | 193 | MFI5237741.1 TolC family protein [Ignavibacteriales bacterium] | diamond | 1701 | 135 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 29292708 | 29292708 | PRJNA688352_P_NODE_9629_length_246_cov_0.890173_g9526_i0 | PRJNA688352 | 9629 | 246 | 0.890173 | 2.18982558 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 49.3 | 1.71e-4 | NR | MDH4070315.1 | 2053306 | g9526 | i0 | 57.6 | 0.402439024390244 | 33 | 14 | 40.2 | 0 | 146 | 244 | 1 | 33 | MDH4070315.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 99 | 49.3 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29513571 | 29513571 | PRJNA688352_P_NODE_10790_length_244_cov_0.900585_g10687_i0 | PRJNA688352 | 10790 | 244 | 0.900585 | 2.1974274 | Ignavibacteria bacterium RIFOXYA2_FULL_35_9 | 1798442 | Bacteria | Bacteria | 82.4 | 4.07e-16 | NR | OGU82870.1 | 1798442 | g10687 | i0 | 69.6 | 0.688524590163934 | 56 | 17 | 68.9 | 0 | 2 | 169 | 571 | 626 | OGU82870.1 MAG: hypothetical protein A2254_02045 [Ignavibacteria bacterium RIFOXYA2_FULL_35_9] | diamond | 168 | 82.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium RIFOXYA2_FULL_35_9 | ||||
| 29924375 | 29924375 | PRJNA688352_P_NODE_10231_length_245_cov_0.895349_g10128_i0 | PRJNA688352 | 10231 | 245 | 0.895349 | 2.19360505 | Ignavibacteria bacterium GWA2_36_19 | 1798419 | Bacteria | Bacteria | 144 | 2.1499999999999994e-42 | NR | OGU42187.1 | 1798419 | g10128 | i0 | 89.2 | 0.906122448979592 | 74 | 8 | 90.6 | 0 | 245 | 24 | 49 | 122 | OGU42187.1 MAG: glyoxalase [Ignavibacteria bacterium GWA2_36_19] | diamond | 222 | 144 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium GWA2_36_19 | ||||
| 30367019 | 30367019 | PRJNA688352_P_NODE_9192_length_247_cov_0.885057_g9089_i0 | PRJNA688352 | 9192 | 247 | 0.885057 | 2.18609079 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 99.4 | 1.9300000000000001e-22 | NR | MBK7256385.1 | 2026749 | g9089 | i0 | 93.8 | 1.74898785425101 | 48 | 3 | 58.3 | 0 | 3 | 146 | 353 | 400 | MBK7256385.1 6-phosphofructokinase [Ignavibacteriota bacterium] | diamond | 432 | 99.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 31187745 | 31187745 | PRJNA688352_P_NODE_12275_length_241_cov_0.916667_g12172_i0 | PRJNA688352 | 12275 | 241 | 0.916667 | 2.20916747 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 140 | 3.2499999999999996e-37 | NR | RJP63754.1 | 2049428 | g12172 | i0 | 92.5 | 0.995850622406639 | 80 | 6 | 99.6 | 0 | 2 | 241 | 9 | 88 | RJP63754.1 MAG: GAF domain-containing protein [Ignavibacteriales bacterium] | diamond | 240 | 140 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 32010503 | 32010503 | PRJNA688352_P_NODE_9678_length_246_cov_0.890173_g9575_i0 | PRJNA688352 | 9678 | 246 | 0.890173 | 2.18982558 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 163 | 5.83e-49 | NR | MBZ0201433.1 | 2053306 | g9575 | i0 | 100 | 0.98780487804878 | 81 | 0 | 98.8 | 0 | 245 | 3 | 47 | 127 | MBZ0201433.1 uracil phosphoribosyltransferase [Ignavibacteria bacterium] | diamond | 243 | 163 | 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);;