contig_metadata
13 rows where bioproject = "PRJNA908278", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2165512 | 2165512 | PRJNA908278_P_NODE_14342_length_331_cov_1.414729_g14239_i0 | PRJNA908278 | 14342 | 331 | 1.414729 | 4.68275299 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 99.4 | 1.44e-21 | NR | MBI5727440.1 | 2049428 | g14239 | i0 | 45.9 | 2.59214501510574 | 98 | 47 | 87.9 | 2 | 5 | 295 | 471 | 563 | MBI5727440.1 S9 family peptidase [Ignavibacteriales bacterium] | diamond | 858 | 99.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 25116491 | 25116491 | PRJNA908278_P_NODE_7300_length_438_cov_1.265753_g7197_i0 | PRJNA908278 | 7300 | 438 | 1.265753 | 5.54399814 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 246 | 5.59e-76 | NR | KXK04718.1 | 1617411 | g7197 | i0 | 78.6 | 22.8424657534247 | 145 | 30 | 99.3 | 1 | 438 | 4 | 145 | 288 | KXK04718.1 MAG: Phosphoenolpyruvate carboxykinase (GTP) [Chlorobi bacterium OLB4] | diamond | 10005 | 248 | 0.991935483870968 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Candidatus Tepidiaquacellales | Candidatus Tepidiaquacellales bacterium OLB4/UTCHB1 | |||
| 26897925 | 26897925 | PRJNA908278_P_NODE_28701_length_249_cov_0.875000_g28598_i0 | PRJNA908278 | 28701 | 249 | 0.875 | 2.17875 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 108 | 1.05e-25 | NR | MBN1301843.1 | 2614255 | g28598 | i0 | 59.8 | 0.987951807228916 | 82 | 33 | 98.8 | 0 | 247 | 2 | 177 | 258 | MBN1301843.1 Glu/Leu/Phe/Val dehydrogenase [Melioribacteraceae bacterium] | diamond | 246 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 27537489 | 27537489 | PRJNA908278_P_NODE_30703_length_246_cov_0.890173_g30600_i0 | PRJNA908278 | 30703 | 246 | 0.890173 | 2.18982558 | Bacteria | 2 | Bacteria | Bacteria | 79.7 | 3.09e-15 | NR | MBN2572021.1 | 2049428 | g30600 | i0 | 48.7 | 3.82926829268293 | 78 | 38 | 95.1 | 1 | 235 | 2 | 326 | 401 | MBN2572021.1 adenylosuccinate synthase [Ignavibacteriales bacterium] | diamond | 942 | 80.5 | 0.990062111801242 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 28098203 | 28098203 | PRJNA908278_P_NODE_13845_length_336_cov_1.171103_g13742_i0 | PRJNA908278 | 13845 | 336 | 1.171103 | 3.93490608 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 53.1 | 5.81e-6 | NR | MBI2619679.1 | 2049428 | g13742 | i0 | 39.4 | 0.633928571428571 | 71 | 35 | 63.4 | 2 | 215 | 3 | 7 | 69 | MBI2619679.1 Hsp20/alpha crystallin family protein [Ignavibacteriales bacterium] | diamond | 213 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 28508822 | 28508822 | PRJNA908278_P_NODE_35887_length_234_cov_2.242236_g35784_i0 | PRJNA908278 | 35887 | 234 | 2.242236 | 5.24683224 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 48.9 | 2.26e-4 | NR | MCX6150667.1 | 2049428 | g35784 | i0 | 47.2 | 0.67948717948718 | 53 | 25 | 67.9 | 1 | 210 | 52 | 115 | 164 | MCX6150667.1 CHRD domain-containing protein [Ignavibacteriales bacterium] | diamond | 159 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 28635330 | 28635330 | PRJNA908278_P_NODE_7767_length_425_cov_3.724432_g7664_i0 | PRJNA908278 | 7767 | 425 | 3.724432 | 15.828836 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 45.1 | 0.0387 | NR | HEY3249713.1 | 2053306 | g7664 | i0 | 29.6 | 0.762352941176471 | 108 | 63 | 75.5 | 3 | 389 | 69 | 412 | 507 | HEY3249713.1 M14 family zinc carboxypeptidase [Ignavibacteria bacterium] | diamond | 324 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29203586 | 29203586 | PRJNA908278_P_NODE_6749_length_453_cov_2.692105_g6646_i0 | PRJNA908278 | 6749 | 453 | 2.692105 | 12.19523565 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 89.7 | 1.71e-18 | NR | HKJ81916.1 | 2651163 | g6646 | i0 | 35.4 | 4.63576158940397 | 144 | 85 | 95.4 | 4 | 16 | 447 | 122 | 257 | HKJ81916.1 carbonic anhydrase [Ignavibacteriaceae bacterium] | diamond | 2100 | 89.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 30245799 | 30245799 | PRJNA908278_P_NODE_7072_length_444_cov_5.183288_g6969_i0 | PRJNA908278 | 7072 | 444 | 5.183288 | 23.01379872 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 150 | 1.7399999999999999e-43 | NR | MBI1938478.1 | 2049428 | g6969 | i0 | 48.6 | 0.986486486486487 | 146 | 69 | 95.9 | 3 | 18 | 443 | 1 | 144 | MBI1938478.1 hypothetical protein [Ignavibacteriales bacterium] | diamond | 438 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 32498163 | 32498163 | PRJNA908278_P_NODE_14759_length_327_cov_1.515748_g14656_i0 | PRJNA908278 | 14759 | 327 | 1.515748 | 4.95649596 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 77 | 9.1e-14 | NR | MBK6915182.1 | 2049428 | g14656 | i0 | 38.2 | 2.12844036697248 | 110 | 59 | 95.4 | 3 | 326 | 15 | 134 | 240 | MBK6915182.1 PKD domain-containing protein [Ignavibacteriales bacterium] | diamond | 696 | 77 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 32624106 | 32624106 | PRJNA908278_P_NODE_35320_length_241_cov_0.916667_g35217_i0 | PRJNA908278 | 35320 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 44.3 | 0.00926 | NR | MDP2303189.1 | 2053306 | g35217 | i0 | 39.7 | 3.01244813278008 | 68 | 36 | 84.6 | 3 | 34 | 237 | 31 | 93 | MDP2303189.1 SdiA-regulated domain-containing protein [Ignavibacteria bacterium] | diamond | 726 | 44.7 | 0.991051454138702 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32805655 | 32805655 | PRJNA908278_P_NODE_32300_length_245_cov_0.895349_g32197_i0 | PRJNA908278 | 32300 | 245 | 0.895349 | 2.19360505 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 47 | 6.25e-4 | NR | MCX7875075.1 | 2614255 | g32197 | i0 | 54.3 | 1.13877551020408 | 46 | 18 | 52.7 | 1 | 223 | 95 | 1 | 46 | MCX7875075.1 lipocalin family protein [Melioribacteraceae bacterium] | diamond | 279 | 47 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 32868604 | 32868604 | PRJNA908278_P_NODE_10980_length_369_cov_0.969595_g10877_i0 | PRJNA908278 | 10980 | 369 | 0.969595 | 3.57780555 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 45.1 | 0.0229 | NR | MBI5473542.1 | 2026749 | g10877 | i0 | 43.4 | 0.430894308943089 | 53 | 24 | 43.1 | 1 | 216 | 58 | 11 | 57 | MBI5473542.1 serine/threonine protein kinase [Ignavibacteriota bacterium] | diamond | 159 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota 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);;