contig_metadata
9 rows where bioproject = "PRJNA627467" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1875349 | 1875349 | PRJNA627467_P_NODE_3902_length_316_cov_1.898876_g3834_i0 | PRJNA627467 | 3902 | 316 | 1.898876 | 6.00044816 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 82.4 | 3.77e-11 | NTclustered | gi|2874254163|emb|OY970395.1| | 412054 | g3834 | i0 | 94.34 | 43.7278481012658 | 53 | 3 | 17 | 0 | 258 | 310 | 1607631 | 1607683 | MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1 | blastn | 13818 | 82.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 1875407 | 1875407 | PRJNA627467_P_NODE_9382_length_190_cov_1.418440_g9313_i0 | PRJNA627467 | 9382 | 190 | 1.41844 | 2.695036 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 113 | 2.17e-27 | NR | PYP42654.1 | 2026742 | g9313 | i0 | 90.2 | 0.963157894736842 | 61 | 6 | 96.3 | 0 | 184 | 2 | 239 | 299 | PYP42654.1 MAG: multidrug transporter AcrB, partial [Gemmatimonadota bacterium] | diamond | 183 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 8803706 | 8803706 | PRJNA627467_P_NODE_17607_length_164_cov_2.608696_g17538_i0 | PRJNA627467 | 17607 | 164 | 2.608696 | 4.27826144 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 100 | 3.5299999999999995e-23 | NR | HET9011844.1 | 2026741 | g17538 | i0 | 92.5 | 3.8780487804878 | 53 | 4 | 97 | 0 | 5 | 163 | 140 | 192 | HET9011844.1 FAD-dependent oxidoreductase [Gemmatimonadaceae bacterium] | diamond | 636 | 101 | 0.99009900990099 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 13353377 | 13353377 | PRJNA627467_P_NODE_17231_length_165_cov_1.724138_g17162_i0 | PRJNA627467 | 17231 | 165 | 1.724138 | 2.8448277 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 254 | 3.52e-63 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g17162 | i0 | 95.031 | 189.690909090909 | 161 | 8 | 98 | 0 | 1 | 161 | 173814 | 173654 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 31299 | 254 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 15902033 | 15902033 | PRJNA627467_P_NODE_10773_length_185_cov_1.485294_g10704_i0 | PRJNA627467 | 10773 | 185 | 1.485294 | 2.7477939 | uncultured Gemmatimonadaceae bacterium | 246130 | Bacteria | Bacteria | 167 | 5.41e-37 | NTclustered | gi|2874253995|emb|OY970320.1| | 246130 | g10704 | i0 | 84.302 | 3.38378378378378 | 172 | 25 | 92 | 2 | 2 | 172 | 3235741 | 3235571 | MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 | blastn | 626 | 167 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | uncultured Gemmatimonadaceae bacterium | ||
| 17177191 | 17177191 | PRJNA627467_P_NODE_5994_length_315_cov_1.969925_g5926_i0 | PRJNA627467 | 5994 | 315 | 1.969925 | 6.20526375 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 111 | 4.8e-20 | NTclustered | gi|2107779373|gb|CP070829.1| | 2448054 | g5926 | i0 | 87 | 3.70793650793651 | 100 | 11 | 31 | 2 | 217 | 315 | 3228492 | 3228394 | MAG: Gemmatimonadales bacterium isolate bin109 chromosome | blastn | 1168 | 111 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 26827568 | 26827568 | PRJNA627467_P_NODE_3981_length_316_cov_1.872659_g3913_i0 | PRJNA627467 | 3981 | 316 | 1.872659 | 5.91760244 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 68.6 | 7.09e-11 | NR | HTI64292.1 | 2026741 | g3913 | i0 | 100 | 0.30379746835443 | 32 | 0 | 30.4 | 0 | 100 | 5 | 125 | 156 | HTI64292.1 PQQ-dependent sugar dehydrogenase [Gemmatimonadaceae bacterium] | diamond | 96 | 68.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30504194 | 30504194 | PRJNA627467_P_NODE_4313_length_316_cov_1.775281_g4245_i0 | PRJNA627467 | 4313 | 316 | 1.775281 | 5.60988796 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 59.7 | 9.75e-8 | NR | HMI57385.1 | 2026741 | g4245 | i0 | 84.4 | 5.16455696202532 | 32 | 5 | 30.4 | 0 | 100 | 5 | 353 | 384 | HMI57385.1 ATP-binding cassette domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 1632 | 59.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32609810 | 32609810 | PRJNA627467_P_NODE_16140_length_167_cov_2.559322_g16071_i0 | PRJNA627467 | 16140 | 167 | 2.559322 | 4.27406774 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 112 | 1.6600000000000003e-27 | NR | HEU4649526.1 | 2448054 | g16071 | i0 | 100 | 0.970059880239521 | 54 | 0 | 97 | 0 | 1 | 162 | 338 | 391 | HEU4649526.1 amidophosphoribosyltransferase [Gemmatimonadales bacterium] | diamond | 162 | 112 | 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);;