contig_metadata
13 rows where bioproject = "PRJNA453567", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11920656 | 11920656 | PRJNA453567_P_NODE_28210_length_165_cov_1.218750_g27973_i0 | PRJNA453567 | 28210 | 165 | 1.21875 | 2.0109375 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 111 | 2.24e-20 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g27973 | i0 | 80 | 54.5393939393939 | 155 | 28 | 93 | 3 | 1 | 154 | 1524637 | 1524789 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 8999 | 111 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 18293446 | 18293446 | PRJNA453567_P_NODE_1915_length_837_cov_2.653750_g1765_i0 | PRJNA453567 | 1915 | 837 | 2.65375 | 22.2118875 | Roseisolibacter | 2093335 | Bacteria | Bacteria | 214 | 1.1000000000000001e-65 | NR | WP_284348513.1 | 2014610 | g1765 | i0 | 72.1 | 0.974910394265233 | 136 | 37 | 48.7 | 1 | 1 | 408 | 81 | 215 | WP_284348513.1 pyridoxamine 5'-phosphate oxidase [Roseisolibacter agri] | diamond | 816 | 216 | 0.990740740740741 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Roseisolibacter | Roseisolibacter agri | |
| 26791374 | 26791374 | PRJNA453567_P_NODE_17381_length_214_cov_1.762712_g17144_i0 | PRJNA453567 | 17381 | 214 | 1.762712 | 3.77220368 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 50.1 | 6.69e-5 | NR | MDH3495164.1 | 2026742 | g17144 | i0 | 63.9 | 0.504672897196262 | 36 | 12 | 50.5 | 1 | 145 | 38 | 6 | 40 | MDH3495164.1 NAD-dependent malic enzyme [Gemmatimonadota bacterium] | diamond | 108 | 50.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27138924 | 27138924 | PRJNA453567_P_NODE_15082_length_233_cov_1.193878_g14845_i0 | PRJNA453567 | 15082 | 233 | 1.193878 | 2.78173574 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 70.5 | 2.42e-12 | NR | MFL5495210.1 | 2448054 | g14845 | i0 | 48.1 | 1.7381974248927 | 77 | 34 | 96.6 | 2 | 9 | 233 | 9 | 81 | MFL5495210.1 MOSC domain-containing protein [Gemmatimonadales bacterium] | diamond | 405 | 70.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27503312 | 27503312 | PRJNA453567_P_NODE_21403_length_190_cov_1.797386_g21166_i0 | PRJNA453567 | 21403 | 190 | 1.797386 | 3.4150334 | Bacteria | 2 | Bacteria | Bacteria | 62 | 1.8e-9 | NR | MEJ2540457.1 | 2026742 | g21166 | i0 | 63.8 | 2.27368421052632 | 47 | 16 | 74.2 | 1 | 175 | 35 | 170 | 215 | MEJ2540457.1 SDR family NAD(P)-dependent oxidoreductase [Gemmatimonadota bacterium] | diamond | 432 | 62 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28592116 | 28592116 | PRJNA453567_P_NODE_22067_length_187_cov_1.560000_g21830_i0 | PRJNA453567 | 22067 | 187 | 1.56 | 2.9172 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 57.8 | 5.93e-8 | NR | MBU6365795.1 | 2026742 | g21830 | i0 | 45.8 | 7.47593582887701 | 59 | 31 | 94.7 | 1 | 9 | 185 | 58 | 115 | MBU6365795.1 triose-phosphate isomerase [Gemmatimonadota bacterium] | diamond | 1398 | 57.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28812679 | 28812679 | PRJNA453567_P_NODE_13548_length_249_cov_1.466981_g13311_i0 | PRJNA453567 | 13548 | 249 | 1.466981 | 3.65278269 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 65.1 | 3.7e-10 | NR | HEX6106214.1 | 2448054 | g13311 | i0 | 46 | 3.46987951807229 | 63 | 31 | 75.9 | 1 | 17 | 205 | 7 | 66 | HEX6106214.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 864 | 65.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29065750 | 29065750 | PRJNA453567_P_NODE_4208_length_516_cov_2.367432_g3975_i0 | PRJNA453567 | 4208 | 516 | 2.367432 | 12.21594912 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 174 | 1.05e-51 | NR | HEX8430849.1 | 2029185 | g3975 | i0 | 56.5 | 2.91860465116279 | 168 | 69 | 97.1 | 4 | 14 | 514 | 28 | 192 | HEX8430849.1 SDR family NAD(P)-dependent oxidoreductase [Longimicrobium sp.] | diamond | 1506 | 174 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 29412787 | 29412787 | PRJNA453567_P_NODE_11449_length_275_cov_1.474790_g11212_i0 | PRJNA453567 | 11449 | 275 | 1.47479 | 4.0556725 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 90.9 | 6.42e-19 | NR | MDQ6872943.1 | 2026742 | g11212 | i0 | 48.9 | 0.96 | 88 | 44 | 96 | 1 | 273 | 10 | 59 | 145 | MDQ6872943.1 beta galactosidase jelly roll domain-containing protein [Gemmatimonadota bacterium] | diamond | 264 | 90.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29981365 | 29981365 | PRJNA453567_P_NODE_17311_length_215_cov_1.258427_g17074_i0 | PRJNA453567 | 17311 | 215 | 1.258427 | 2.70561805 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 51.2 | 2.68e-5 | NR | HEV7990963.1 | 2026741 | g17074 | i0 | 36.8 | 0.795348837209302 | 57 | 33 | 75.3 | 1 | 215 | 54 | 356 | 412 | HEV7990963.1 protein kinase [Gemmatimonadaceae bacterium] | diamond | 171 | 51.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30707952 | 30707952 | PRJNA453567_P_NODE_10514_length_289_cov_2.777778_g10277_i0 | PRJNA453567 | 10514 | 289 | 2.777778 | 8.02777842 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 45.4 | 0.00653 | NR | MEP6779286.1 | 2026741 | g10277 | i0 | 39.2 | 0.768166089965398 | 74 | 28 | 70.6 | 3 | 227 | 24 | 44 | 106 | MEP6779286.1 alpha/beta fold hydrolase [Gemmatimonadaceae bacterium] | diamond | 222 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31055915 | 31055915 | PRJNA453567_P_NODE_3115_length_621_cov_2.988014_g2905_i0 | PRJNA453567 | 3115 | 621 | 2.988014 | 18.55556694 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 53.1 | 2.59e-4 | NR | MCL7926990.1 | 2026742 | g2905 | i0 | 29.8 | 3.29468599033816 | 168 | 102 | 81.2 | 5 | 15 | 518 | 23 | 174 | MCL7926990.1 long-chain fatty acid--CoA ligase [Gemmatimonadota bacterium] | diamond | 2046 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32194261 | 32194261 | PRJNA453567_P_NODE_12758_length_258_cov_1.285068_g12521_i0 | PRJNA453567 | 12758 | 258 | 1.285068 | 3.31547544 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 53.1 | 2.57e-6 | NR | MEA2063503.1 | 2026742 | g12521 | i0 | 67.6 | 7.6046511627907 | 34 | 11 | 39.5 | 0 | 103 | 2 | 3 | 36 | MEA2063503.1 50S ribosomal protein L9 [Gemmatimonadota bacterium] | diamond | 1962 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota 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);;