contig_metadata
14 rows where bioproject = "PRJEB75017", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6513549 | 6513549 | PRJEB75017_P_NODE_9886_length_290_cov_1.428571_g9757_i0 | PRJEB75017 | 9886 | 290 | 1.428571 | 4.1428559 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 119 | 8.05e-32 | NR | MBX3132884.1 | 2026741 | g9757 | i0 | 88.6 | 0.724137931034483 | 70 | 8 | 72.4 | 0 | 290 | 81 | 97 | 166 | MBX3132884.1 acetyl-CoA carboxylase biotin carboxyl carrier protein subunit [Gemmatimonadaceae bacterium] | diamond | 210 | 119 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 12888875 | 12888875 | PRJEB75017_P_NODE_11071_length_278_cov_2.258537_g10942_i0 | PRJEB75017 | 11071 | 278 | 2.258537 | 6.27873286 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 383 | 7.99e-102 | NTclustered | gi|2874253938|emb|OY970263.1| | 412054 | g10942 | i0 | 91.459 | 56.568345323741 | 281 | 20 | 100 | 4 | 1 | 278 | 801409 | 801130 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 | blastn | 15726 | 383 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 13748993 | 13748993 | PRJEB75017_P_NODE_8731_length_305_cov_1.681034_g8602_i0 | PRJEB75017 | 8731 | 305 | 1.681034 | 5.1271537 | Bacteria | 2 | Bacteria | Bacteria | 370 | 6.91e-98 | NTclustered | gi|2874253938|emb|OY970263.1| | 412054 | g8602 | i0 | 88.636 | 141.426229508197 | 308 | 29 | 100 | 5 | 1 | 305 | 803437 | 803133 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 | blastn | 43135 | 370 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 16712019 | 16712019 | PRJEB75017_P_NODE_1494_length_706_cov_1.568720_g1371_i0 | PRJEB75017 | 1494 | 706 | 1.56872 | 11.0751632 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 957 | 0 | NTclustered | gi|2874253938|emb|OY970263.1| | 412054 | g1371 | i0 | 91.292 | 599.407932011331 | 712 | 46 | 99 | 12 | 1 | 704 | 801768 | 802471 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 | blastn | 423182 | 957 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 27950258 | 27950258 | PRJEB75017_P_NODE_2345_length_570_cov_1.309859_g2216_i0 | PRJEB75017 | 2345 | 570 | 1.309859 | 7.4661963 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 46.6 | 0.0262 | NR | HEY7394616.1 | 2026741 | g2216 | i0 | 42.3 | 0.373684210526316 | 71 | 38 | 36.3 | 2 | 196 | 402 | 112 | 181 | HEY7394616.1 biotin-dependent carboxyltransferase family protein [Gemmatimonadaceae bacterium] | diamond | 213 | 46.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28486993 | 28486993 | PRJEB75017_P_NODE_10247_length_286_cov_2.028169_g10118_i0 | PRJEB75017 | 10247 | 286 | 2.028169 | 5.80056334 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 147 | 2.74e-41 | NR | MBX3133551.1 | 2026741 | g10118 | i0 | 76.8 | 2.98951048951049 | 95 | 22 | 99.7 | 0 | 1 | 285 | 179 | 273 | MBX3133551.1 MerR family transcriptional regulator [Gemmatimonadaceae bacterium] | diamond | 855 | 147 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28708121 | 28708121 | PRJEB75017_P_NODE_8767_length_305_cov_0.961207_g8638_i0 | PRJEB75017 | 8767 | 305 | 0.961207 | 2.93168135 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 61.6 | 1.75e-8 | NR | MDP3774453.1 | 2448054 | g8638 | i0 | 38.8 | 0.836065573770492 | 85 | 50 | 83.6 | 1 | 43 | 297 | 177 | 259 | MDP3774453.1 reverse transcriptase domain-containing protein [Gemmatimonadales bacterium] | diamond | 255 | 61.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 28834225 | 28834225 | PRJEB75017_P_NODE_1948_length_622_cov_1.479053_g1821_i0 | PRJEB75017 | 1948 | 622 | 1.479053 | 9.19970966 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 45.4 | 0.0253 | NR | HEX5727651.1 | 3047548 | g1821 | i0 | 37 | 0.390675241157556 | 81 | 36 | 34.7 | 3 | 527 | 312 | 68 | 142 | HEX5727651.1 hypothetical protein [Longimicrobiaceae bacterium] | diamond | 243 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 29402560 | 29402560 | PRJEB75017_P_NODE_16629_length_246_cov_0.901734_g16500_i0 | PRJEB75017 | 16629 | 246 | 0.901734 | 2.21826564 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 141 | 8.37e-40 | NR | HET9041419.1 | 2448054 | g16500 | i0 | 91.4 | 3.95121951219512 | 81 | 7 | 98.8 | 0 | 2 | 244 | 116 | 196 | HET9041419.1 methylmalonyl-CoA mutase family protein [Gemmatimonadales bacterium] | diamond | 972 | 141 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29433852 | 29433852 | PRJEB75017_P_NODE_15210_length_250_cov_0.881356_g15081_i0 | PRJEB75017 | 15210 | 250 | 0.881356 | 2.20339 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 137 | 2.95e-35 | NR | HEY5491996.1 | 2026741 | g15081 | i0 | 80.7 | 0.996 | 83 | 16 | 99.6 | 0 | 2 | 250 | 616 | 698 | HEY5491996.1 efflux RND transporter permease subunit [Gemmatimonadaceae bacterium] | diamond | 249 | 137 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31544003 | 31544003 | PRJEB75017_P_NODE_10676_length_282_cov_1.492823_g10547_i0 | PRJEB75017 | 10676 | 282 | 1.492823 | 4.20976086 | FCB group | 1783270 | Bacteria | Bacteria | 123 | 6.249999999999999e-34 | NR | HWA55626.1 | 2448054 | g10547 | i0 | 61.3 | 16.7021276595745 | 93 | 36 | 98.9 | 0 | 281 | 3 | 27 | 119 | HWA55626.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 4710 | 124 | 0.991935483870968 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32025682 | 32025682 | PRJEB75017_P_NODE_15818_length_248_cov_0.891429_g15689_i0 | PRJEB75017 | 15818 | 248 | 0.891429 | 2.21074392 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 53.1 | 7.94e-6 | NR | MEQ1855701.1 | 2910168 | g15689 | i0 | 45.9 | 0.737903225806452 | 61 | 32 | 72.6 | 1 | 10 | 189 | 261 | 321 | MEQ1855701.1 response regulator transcription factor [Longimicrobiales bacterium] | diamond | 183 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 32176788 | 32176788 | PRJEB75017_P_NODE_13738_length_253_cov_1.300000_g13609_i0 | PRJEB75017 | 13738 | 253 | 1.3 | 3.289 | Bacteria | 2 | Bacteria | Bacteria | 102 | 2.39e-23 | NR | MBX3146122.1 | 2448054 | g13609 | i0 | 56.3 | 5.39525691699605 | 80 | 35 | 94.9 | 0 | 240 | 1 | 2 | 81 | MBX3146122.1 aspartate aminotransferase family protein [Gemmatimonadales bacterium] | diamond | 1365 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32689346 | 32689346 | PRJEB75017_P_NODE_12120_length_268_cov_1.487179_g11991_i0 | PRJEB75017 | 12120 | 268 | 1.487179 | 3.98563972 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 45.1 | 0.00252 | NR | MCX5768266.1 | 2026742 | g11991 | i0 | 41.5 | 0.593283582089552 | 53 | 25 | 59.3 | 1 | 17 | 175 | 8 | 54 | MCX5768266.1 type II toxin-antitoxin system PemK/MazF family toxin [Gemmatimonadota bacterium] | diamond | 159 | 45.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);;