contig_metadata
22 rows where bioproject = "PRJNA599026" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5675778 | 5675778 | PRJNA599026_S_NODE_66325_length_162_cov_0.902655_g65869_i0 | PRJNA599026 | 66325 | 162 | 0.902655 | 1.4623011 | uncultured Gemmatimonadaceae bacterium | 246130 | Bacteria | Bacteria | 57.8 | 2.29e-9 | NR | CAA9322868.1 | 246130 | g65869 | i0 | 83.9 | 0.574074074074074 | 31 | 5 | 57.4 | 0 | 3 | 95 | 44 | 74 | CAA9322868.1 MAG: Nitrile hydratase beta subunit, partial [uncultured Gemmatimonadaceae bacterium] | diamond | 93 | 57.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | uncultured Gemmatimonadaceae bacterium | ||
| 5675783 | 5675783 | PRJNA599026_S_NODE_66685_length_162_cov_0.902655_g66229_i0 | PRJNA599026 | 66685 | 162 | 0.902655 | 1.4623011 | uncultured Gemmatimonadetes bacterium Rifle_16ft_4_minimus_37772 | 1665097 | Bacteria | Bacteria | 115 | 1.7e-21 | NTclustered | gi|874575674|gb|KT007003.1| | 1665097 | g66229 | i0 | 80.255 | 0.969135802469136 | 157 | 27 | 96 | 4 | 3 | 157 | 25041 | 24887 | Uncultured Gemmatimonadetes bacterium Rifle_16ft_4_minimus_37772 genomic sequence | blastn | 157 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | uncultured Gemmatimonadetes bacterium Rifle_16ft_4_minimus_37772 | |||||
| 5675819 | 5675819 | PRJNA599026_S_NODE_70085_length_161_cov_0.910714_g69629_i0 | PRJNA599026 | 70085 | 161 | 0.910714 | 1.46624954 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 66.6 | 4.56e-11 | NR | HJR42308.1 | 2026741 | g69629 | i0 | 70 | 1.86335403726708 | 50 | 15 | 93.2 | 0 | 5 | 154 | 426 | 475 | HJR42308.1 TonB-dependent receptor [Gemmatimonadaceae bacterium] | diamond | 300 | 66.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 13326036 | 13326036 | PRJNA599026_S_NODE_71071_length_161_cov_0.910714_g70615_i0 | PRJNA599026 | 71071 | 161 | 0.910714 | 1.46624954 | Gemmatirosa sp. | 2510638 | Bacteria | Bacteria | 91.7 | 6.01e-20 | NR | HZF67384.1 | 2510638 | g70615 | i0 | 83 | 0.987577639751553 | 53 | 9 | 98.8 | 0 | 159 | 1 | 171 | 223 | HZF67384.1 NAD(P)/FAD-dependent oxidoreductase [Gemmatirosa sp.] | diamond | 159 | 91.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 15874589 | 15874589 | PRJNA599026_S_NODE_52653_length_167_cov_0.864407_g52197_i0 | PRJNA599026 | 52653 | 167 | 0.864407 | 1.44355969 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 189 | 1.0199999999999999e-43 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g52197 | i0 | 87.273 | 68.4910179640719 | 165 | 21 | 99 | 0 | 3 | 167 | 1479964 | 1480128 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 11438 | 189 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 26604813 | 26604813 | PRJNA599026_S_NODE_50881_length_167_cov_0.864407_g50425_i0 | PRJNA599026 | 50881 | 167 | 0.864407 | 1.44355969 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 85.5 | 2.94e-19 | NR | HEX4937017.1 | 2026741 | g50425 | i0 | 86.4 | 1.58083832335329 | 44 | 6 | 79 | 0 | 36 | 167 | 33 | 76 | HEX4937017.1 ACT domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 264 | 85.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 26763363 | 26763363 | PRJNA599026_S_NODE_53441_length_166_cov_1.213675_g52985_i0 | PRJNA599026 | 53441 | 166 | 1.213675 | 2.0147005 | Gemmatirosa sp. | 2510638 | Bacteria | Bacteria | 82.8 | 9.65e-17 | NR | MBV9880088.1 | 2510638 | g52985 | i0 | 71.2 | 1.89759036144578 | 52 | 15 | 94 | 0 | 158 | 3 | 140 | 191 | MBV9880088.1 hypothetical protein [Gemmatirosa sp.] | diamond | 315 | 82.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 27237864 | 27237864 | PRJNA599026_S_NODE_66563_length_162_cov_0.902655_g66107_i0 | PRJNA599026 | 66563 | 162 | 0.902655 | 1.4623011 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 84.3 | 3.18e-18 | NR | MBT3326408.1 | 2448054 | g66107 | i0 | 69.8 | 2.94444444444444 | 53 | 16 | 98.1 | 0 | 160 | 2 | 170 | 222 | MBT3326408.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 477 | 84.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27332928 | 27332928 | PRJNA599026_S_NODE_71863_length_161_cov_0.910714_g71407_i0 | PRJNA599026 | 71863 | 161 | 0.910714 | 1.46624954 | Roseisolibacter sp. H3M3-2 | 3031323 | Bacteria | Bacteria | 99.8 | 1.71e-24 | NR | WP_275836585.1 | 3031323 | g71407 | i0 | 90.6 | 0.987577639751553 | 53 | 5 | 98.8 | 0 | 2 | 160 | 73 | 125 | WP_275836585.1 PH domain-containing protein [Roseisolibacter sp. H3M3-2] | diamond | 159 | 99.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Roseisolibacter | Roseisolibacter sp. H3M3-2 | |
| 27585410 | 27585410 | PRJNA599026_S_NODE_64864_length_163_cov_0.894737_g64408_i0 | PRJNA599026 | 64864 | 163 | 0.894737 | 1.45842131 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 47 | 4.03e-4 | NR | NUQ11404.1 | 2026741 | g64408 | i0 | 63 | 0.496932515337423 | 27 | 10 | 49.7 | 0 | 162 | 82 | 352 | 378 | NUQ11404.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 81 | 47 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27617092 | 27617092 | PRJNA599026_S_NODE_41764_length_179_cov_1.176923_g41308_i0 | PRJNA599026 | 41764 | 179 | 1.176923 | 2.10669217 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 44.7 | 0.00334 | NR | PYO74039.1 | 2026742 | g41308 | i0 | 42.6 | 3.03351955307263 | 61 | 33 | 98.9 | 1 | 179 | 3 | 442 | 502 | PYO74039.1 MAG: hypothetical protein DMD64_05305, partial [Gemmatimonadota bacterium] | diamond | 543 | 44.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27837824 | 27837824 | PRJNA599026_S_NODE_70064_length_161_cov_0.910714_g69608_i0 | PRJNA599026 | 70064 | 161 | 0.910714 | 1.46624954 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 97.4 | 5.66e-23 | NR | HEV7992185.1 | 2026741 | g69608 | i0 | 81.1 | 5.88819875776398 | 53 | 10 | 98.8 | 0 | 1 | 159 | 215 | 267 | HEV7992185.1 murein L,D-transpeptidase catalytic domain family protein [Gemmatimonadaceae bacterium] | diamond | 948 | 97.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28627583 | 28627583 | PRJNA599026_S_NODE_55387_length_166_cov_0.871795_g54931_i0 | PRJNA599026 | 55387 | 166 | 0.871795 | 1.4471797 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 58.9 | 2.48e-8 | NR | WP_025414805.1 | 861299 | g54931 | i0 | 52 | 0.903614457831325 | 50 | 24 | 90.4 | 0 | 15 | 164 | 684 | 733 | WP_025414805.1 DUF4011 domain-containing protein [Gemmatirosa kalamazoonensis] | diamond | 150 | 58.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 29953546 | 29953546 | PRJNA599026_S_NODE_56491_length_165_cov_1.198276_g56035_i0 | PRJNA599026 | 56491 | 165 | 1.198276 | 1.9771554 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 68.2 | 1.37e-11 | NR | HEY0970875.1 | 2448054 | g56035 | i0 | 61.1 | 0.981818181818182 | 54 | 21 | 98.2 | 0 | 3 | 164 | 27 | 80 | HEY0970875.1 exodeoxyribonuclease V subunit gamma [Gemmatimonadales bacterium] | diamond | 162 | 68.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29985132 | 29985132 | PRJNA599026_S_NODE_64811_length_163_cov_0.894737_g64355_i0 | PRJNA599026 | 64811 | 163 | 0.894737 | 1.45842131 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 52.8 | 1.74e-6 | NR | HKG91596.1 | 2026741 | g64355 | i0 | 52.3 | 0.809815950920245 | 44 | 21 | 81 | 0 | 132 | 1 | 9 | 52 | HKG91596.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 132 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30206013 | 30206013 | PRJNA599026_S_NODE_70632_length_161_cov_0.910714_g70176_i0 | PRJNA599026 | 70632 | 161 | 0.910714 | 1.46624954 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 68.9 | 2.45e-12 | NR | MBA3889328.1 | 2026741 | g70176 | i0 | 71.2 | 0.968944099378882 | 52 | 15 | 96.9 | 0 | 157 | 2 | 134 | 185 | MBA3889328.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 156 | 68.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30333147 | 30333147 | PRJNA599026_S_NODE_63112_length_163_cov_0.894737_g62656_i0 | PRJNA599026 | 63112 | 163 | 0.894737 | 1.45842131 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 53.1 | 2.58e-6 | NR | HWG34296.1 | 2026741 | g62656 | i0 | 56.6 | 0.975460122699387 | 53 | 22 | 95.7 | 1 | 161 | 6 | 228 | 280 | HWG34296.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 159 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30364661 | 30364661 | PRJNA599026_S_NODE_56632_length_165_cov_0.879310_g56176_i0 | PRJNA599026 | 56632 | 165 | 0.87931 | 1.4508615 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 45.1 | 0.00182 | NR | HEY2855356.1 | 2026741 | g56176 | i0 | 46.3 | 1.49090909090909 | 41 | 21 | 74.5 | 1 | 42 | 164 | 66 | 105 | HEY2855356.1 lysophospholipid acyltransferase family protein [Gemmatimonadaceae bacterium] | diamond | 246 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31153758 | 31153758 | PRJNA599026_S_NODE_57415_length_165_cov_0.879310_g56959_i0 | PRJNA599026 | 57415 | 165 | 0.87931 | 1.4508615 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 50.1 | 4.88e-6 | NR | MFL5521582.1 | 2448054 | g56959 | i0 | 74.2 | 1.12727272727273 | 31 | 8 | 56.4 | 0 | 1 | 93 | 68 | 98 | MFL5521582.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 186 | 50.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31248902 | 31248902 | PRJNA599026_S_NODE_64695_length_163_cov_0.894737_g64239_i0 | PRJNA599026 | 64695 | 163 | 0.894737 | 1.45842131 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 82 | 1.03e-16 | NR | MBA3890469.1 | 2026741 | g64239 | i0 | 82.7 | 0.957055214723926 | 52 | 9 | 95.7 | 0 | 6 | 161 | 287 | 338 | MBA3890469.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 156 | 82 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32229807 | 32229807 | PRJNA599026_S_NODE_61598_length_164_cov_0.886957_g61142_i0 | PRJNA599026 | 61598 | 164 | 0.886957 | 1.45460948 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 58.9 | 2.47e-8 | NR | NUQ21020.1 | 2026741 | g61142 | i0 | 64.4 | 0.823170731707317 | 45 | 16 | 82.3 | 0 | 28 | 162 | 271 | 315 | NUQ21020.1 PAS domain S-box protein [Gemmatimonadaceae bacterium] | diamond | 135 | 58.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32640327 | 32640327 | PRJNA599026_S_NODE_61460_length_164_cov_0.886957_g61004_i0 | PRJNA599026 | 61460 | 164 | 0.886957 | 1.45460948 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 48.9 | 8.48e-5 | NR | MBA2459053.1 | 2448054 | g61004 | i0 | 49 | 2.8719512195122 | 51 | 25 | 93.3 | 1 | 6 | 158 | 310 | 359 | MBA2459053.1 ABC transporter ATP-binding protein [Gemmatimonadales bacterium] | diamond | 471 | 48.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales 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);;