contig_metadata
7 rows where bioproject = "PRJNA603943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9505436 | 9505436 | PRJNA603943_P_NODE_34368_length_312_cov_0.995816_g34176_i0 | PRJNA603943 | 34368 | 312 | 0.995816 | 3.10694592 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 346 | 1.19e-90 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g34176 | i0 | 91.12 | 411.772435897436 | 259 | 17 | 82 | 6 | 57 | 312 | 1904483 | 1904738 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 128473 | 346 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 23529985 | 23529985 | PRJNA603943_P_NODE_49419_length_261_cov_1.382979_g49227_i0 | PRJNA603943 | 49419 | 261 | 1.382979 | 3.60957519 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 361 | 3.48e-95 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g49227 | i0 | 91.571 | 4 | 261 | 22 | 100 | 0 | 1 | 261 | 3485892 | 3485632 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 1044 | 361 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 26763436 | 26763436 | PRJNA603943_P_NODE_31281_length_324_cov_1.007968_g31089_i0 | PRJNA603943 | 31281 | 324 | 1.007968 | 3.26581632 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 121 | 9.21e-30 | NR | MCH6547985.1 | 2026742 | g31089 | i0 | 50.9 | 3 | 108 | 52 | 100 | 1 | 324 | 1 | 159 | 265 | MCH6547985.1 aspartate aminotransferase family protein [Gemmatimonadota bacterium] | diamond | 972 | 121 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27648765 | 27648765 | PRJNA603943_P_NODE_63304_length_245_cov_0.895349_g63112_i0 | PRJNA603943 | 63304 | 245 | 0.895349 | 2.19360505 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 42.7 | 0.0369 | NR | MDB4899669.1 | 2026742 | g63112 | i0 | 50 | 0.489795918367347 | 40 | 20 | 49 | 0 | 177 | 58 | 267 | 306 | MDB4899669.1 Polynucleotide adenylyltransferase region [Gemmatimonadota bacterium] | diamond | 120 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27680531 | 27680531 | PRJNA603943_P_NODE_63524_length_245_cov_0.895349_g63332_i0 | PRJNA603943 | 63524 | 245 | 0.895349 | 2.19360505 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 71.2 | 5.52e-14 | NR | HZI73724.1 | 2448054 | g63332 | i0 | 92.3 | 0.477551020408163 | 39 | 3 | 47.8 | 0 | 129 | 245 | 1 | 39 | HZI73724.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 117 | 71.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 27869485 | 27869485 | PRJNA603943_P_NODE_17645_length_402_cov_0.896657_g17453_i0 | PRJNA603943 | 17645 | 402 | 0.896657 | 3.60456114 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 43.5 | 0.0174 | NR | MDH3457777.1 | 2026742 | g17453 | i0 | 41.7 | 0.447761194029851 | 60 | 24 | 36.6 | 2 | 168 | 314 | 29 | 88 | MDH3457777.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 180 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29353789 | 29353789 | PRJNA603943_P_NODE_63169_length_245_cov_0.895349_g62977_i0 | PRJNA603943 | 63169 | 245 | 0.895349 | 2.19360505 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 43.5 | 0.0177 | NR | HEY6224233.1 | 2448054 | g62977 | i0 | 43.6 | 1.43265306122449 | 39 | 22 | 47.8 | 0 | 114 | 230 | 156 | 194 | HEY6224233.1 beta-ribofuranosylaminobenzene 5'-phosphate synthase family protein [Gemmatimonadales bacterium] | diamond | 351 | 43.5 | 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);;