contig_metadata
19 rows where bioproject = "PRJNA415856" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 419171 | 419171 | PRJNA415856_P_NODE_15801_length_219_cov_1.058824_g15540_i0 | PRJNA415856 | 15801 | 219 | 1.058824 | 2.31882456 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 272 | 1.37e-68 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g15540 | i0 | 89.189 | 44.7716894977169 | 222 | 18 | 100 | 5 | 1 | 219 | 172720 | 172502 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 9805 | 272 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 9347307 | 9347307 | PRJNA415856_P_NODE_15628_length_220_cov_1.192982_g15367_i0 | PRJNA415856 | 15628 | 220 | 1.192982 | 2.6245604 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 311 | 2.91e-80 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g15367 | i0 | 93.056 | 296.3 | 216 | 9 | 97 | 6 | 8 | 220 | 5915218 | 5915430 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 65186 | 311 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 10623137 | 10623137 | PRJNA415856_P_NODE_25829_length_182_cov_1.157895_g25568_i0 | PRJNA415856 | 25829 | 182 | 1.157895 | 2.1073689 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 115 | 1.22e-28 | NR | HEX5072802.1 | 2026741 | g25568 | i0 | 98.3 | 0.989010989010989 | 60 | 1 | 98.9 | 0 | 2 | 181 | 239 | 298 | HEX5072802.1 M20 family metallo-hydrolase [Gemmatimonadaceae bacterium] | diamond | 180 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 11286831 | 11286831 | PRJNA415856_P_NODE_48509_length_162_cov_1.353982_g48248_i0 | PRJNA415856 | 48509 | 162 | 1.353982 | 2.19345084 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 89.4 | 3.12e-19 | NR | MBA2459169.1 | 2448054 | g48248 | i0 | 88.5 | 3.85185185185185 | 52 | 6 | 96.3 | 0 | 2 | 157 | 195 | 246 | MBA2459169.1 ammonium transporter [Gemmatimonadales bacterium] | diamond | 624 | 89.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 15721886 | 15721886 | PRJNA415856_P_NODE_19953_length_196_cov_1.027211_g19692_i0 | PRJNA415856 | 19953 | 196 | 1.027211 | 2.01333356 | uncultured Gemmatimonadales bacterium HF4000_15H13 | 723618 | Bacteria | Bacteria | 171 | 4.49e-38 | NTclustered | gi|297172678|gb|GU568020.1| | 723618 | g19692 | i0 | 90.769 | 169.061224489796 | 130 | 8 | 65 | 4 | 68 | 195 | 19354 | 19227 | Uncultured Gemmatimonadales bacterium HF4000_15H13 genomic sequence | blastn | 33136 | 171 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium HF4000_15H13 | |||
| 23371579 | 23371579 | PRJNA415856_P_NODE_51799_length_161_cov_0.910714_g51538_i0 | PRJNA415856 | 51799 | 161 | 0.910714 | 1.46624954 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 91.7 | 9.44e-22 | NR | HEY5415140.1 | 2026741 | g51538 | i0 | 83 | 1.97515527950311 | 53 | 9 | 98.8 | 0 | 159 | 1 | 46 | 98 | HEY5415140.1 ribosomal protein S18-alanine N-acetyltransferase [Gemmatimonadaceae bacterium] | diamond | 318 | 92 | 0.996739130434783 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 24645600 | 24645600 | PRJNA415856_P_NODE_18360_length_203_cov_2.597403_g18099_i0 | PRJNA415856 | 18360 | 203 | 2.597403 | 5.27272809 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 278 | 2.68e-70 | NTclustered | gi|2107953857|gb|CP070792.1| | 2026742 | g18099 | i0 | 91.584 | 192.369458128079 | 202 | 16 | 99 | 1 | 2 | 203 | 1095565 | 1095365 | MAG: Gemmatimonadetes bacterium isolate bin1440 chromosome | blastn | 39051 | 278 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 24645785 | 24645785 | PRJNA415856_P_NODE_43620_length_164_cov_0.886957_g43359_i0 | PRJNA415856 | 43620 | 164 | 0.886957 | 1.45460948 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 163 | 6.06e-36 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g43359 | i0 | 87.77 | 0.847560975609756 | 139 | 17 | 85 | 0 | 6 | 144 | 2193385 | 2193523 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 139 | 163 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 26822577 | 26822577 | PRJNA415856_P_NODE_38001_length_166_cov_0.871795_g37740_i0 | PRJNA415856 | 38001 | 166 | 0.871795 | 1.4471797 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 70.1 | 2.78e-12 | NR | PYP79602.1 | 2026742 | g37740 | i0 | 91.9 | 0.668674698795181 | 37 | 3 | 66.9 | 0 | 3 | 113 | 244 | 280 | PYP79602.1 MAG: amino acid dehydrogenase [Gemmatimonadota bacterium] | diamond | 111 | 70.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 26902546 | 26902546 | PRJNA415856_P_NODE_50161_length_162_cov_0.902655_g49900_i0 | PRJNA415856 | 50161 | 162 | 0.902655 | 1.4623011 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 43.9 | 0.00279 | NR | HET9453614.1 | 2026741 | g49900 | i0 | 60 | 1.85185185185185 | 35 | 9 | 55.6 | 1 | 137 | 48 | 100 | 134 | HET9453614.1 hotdog fold domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 300 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28117740 | 28117740 | PRJNA415856_P_NODE_34785_length_167_cov_1.635593_g34524_i0 | PRJNA415856 | 34785 | 167 | 1.635593 | 2.73144031 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 101 | 6.77e-24 | NR | HKP16651.1 | 2026741 | g34524 | i0 | 86.8 | 0.952095808383233 | 53 | 7 | 95.2 | 0 | 2 | 160 | 315 | 367 | HKP16651.1 ankyrin repeat domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 159 | 101 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28243956 | 28243956 | PRJNA415856_P_NODE_44206_length_164_cov_0.886957_g43945_i0 | PRJNA415856 | 44206 | 164 | 0.886957 | 1.45460948 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 55.8 | 8.5e-8 | NR | HUQ82535.1 | 2026741 | g43945 | i0 | 64.4 | 0.823170731707317 | 45 | 16 | 82.3 | 0 | 29 | 163 | 1 | 45 | HUQ82535.1 ribosomal protein S18-alanine N-acetyltransferase [Gemmatimonadaceae bacterium] | diamond | 135 | 55.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28338904 | 28338904 | PRJNA415856_P_NODE_47746_length_163_cov_0.894737_g47485_i0 | PRJNA415856 | 47746 | 163 | 0.894737 | 1.45842131 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 108 | 1.14e-25 | NR | HEX5072002.1 | 2026741 | g47485 | i0 | 98.1 | 0.993865030674847 | 54 | 1 | 99.4 | 0 | 1 | 162 | 455 | 508 | HEX5072002.1 protein kinase [Gemmatimonadaceae bacterium] | diamond | 162 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29254285 | 29254285 | PRJNA415856_P_NODE_27949_length_178_cov_1.209302_g27688_i0 | PRJNA415856 | 27949 | 178 | 1.209302 | 2.15255756 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 45.8 | 6.12e-4 | NR | HEX6966280.1 | 2026741 | g27688 | i0 | 80 | 0.825842696629214 | 25 | 5 | 42.1 | 0 | 2 | 76 | 129 | 153 | HEX6966280.1 peptidylprolyl isomerase [Gemmatimonadaceae bacterium] | diamond | 147 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30897244 | 30897244 | PRJNA415856_P_NODE_48274_length_162_cov_1.672566_g48013_i0 | PRJNA415856 | 48274 | 162 | 1.672566 | 2.70955692 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 96.3 | 4.65e-22 | NR | MFL5479803.1 | 2026741 | g48013 | i0 | 81.5 | 1 | 54 | 10 | 100 | 0 | 162 | 1 | 124 | 177 | MFL5479803.1 IS110 family transposase [Gemmatimonadaceae bacterium] | diamond | 162 | 96.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31339454 | 31339454 | PRJNA415856_P_NODE_36736_length_167_cov_0.864407_g36475_i0 | PRJNA415856 | 36736 | 167 | 0.864407 | 1.44355969 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 41.2 | 0.013 | NR | WP_331875366.1 | 2029185 | g36475 | i0 | 55.9 | 0.610778443113772 | 34 | 15 | 61.1 | 0 | 138 | 37 | 62 | 95 | WP_331875366.1 hypothetical protein, partial [Longimicrobium sp.] | diamond | 102 | 41.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 31529462 | 31529462 | PRJNA415856_P_NODE_50356_length_162_cov_0.902655_g50095_i0 | PRJNA415856 | 50356 | 162 | 0.902655 | 1.4623011 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 41.2 | 0.0437 | NR | MYG82094.1 | 2026742 | g50095 | i0 | 32.6 | 1.7037037037037 | 46 | 31 | 85.2 | 0 | 18 | 155 | 349 | 394 | MYG82094.1 TonB-dependent receptor plug domain-containing protein [Gemmatimonadota bacterium] | diamond | 276 | 41.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31655647 | 31655647 | PRJNA415856_P_NODE_53677_length_160_cov_2.657658_g53416_i0 | PRJNA415856 | 53677 | 160 | 2.657658 | 4.2522528 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 85.1 | 1.42e-17 | NR | HEY0038634.1 | 2029185 | g53416 | i0 | 84.3 | 0.95625 | 51 | 8 | 95.6 | 0 | 159 | 7 | 200 | 250 | HEY0038634.1 hypothetical protein [Longimicrobium sp.] | diamond | 153 | 85.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 31845487 | 31845487 | PRJNA415856_P_NODE_38077_length_166_cov_0.871795_g37816_i0 | PRJNA415856 | 38077 | 166 | 0.871795 | 1.4471797 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 103 | 3.36e-25 | NR | HEV3050267.1 | 2029185 | g37816 | i0 | 90.9 | 4.96987951807229 | 55 | 5 | 99.4 | 0 | 1 | 165 | 183 | 237 | HEV3050267.1 HAMP domain-containing sensor histidine kinase [Longimicrobium sp.] | diamond | 825 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. |
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);;