contig_metadata
8 rows where bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2148219 | 2148219 | PRJNA896758_P_NODE_25922_length_242_cov_0.911243_g25532_i0 | PRJNA896758 | 25922 | 242 | 0.911243 | 2.20520806 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 130 | 9.79e-26 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g25532 | i0 | 86.441 | 13.3305785123967 | 118 | 16 | 49 | 0 | 1 | 118 | 3774005 | 3773888 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 3226 | 130 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 7250954 | 7250954 | PRJNA896758_P_NODE_21666_length_250_cov_1.175141_g21276_i0 | PRJNA896758 | 21666 | 250 | 1.175141 | 2.9378525 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 217 | 7.59e-52 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g21276 | i0 | 90.476 | 158.468 | 168 | 11 | 66 | 5 | 85 | 250 | 3484289 | 3484453 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 39617 | 217 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 11076431 | 11076431 | PRJNA896758_P_NODE_4889_length_515_cov_0.857466_g4501_i0 | PRJNA896758 | 4889 | 515 | 0.857466 | 4.4159499 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 676 | 0 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g4501 | i0 | 90.559 | 91.3106796116505 | 519 | 37 | 99 | 8 | 3 | 515 | 5916994 | 5916482 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 47025 | 676 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 21274758 | 21274758 | PRJNA896758_P_NODE_21497_length_251_cov_0.865169_g21107_i0 | PRJNA896758 | 21497 | 251 | 0.865169 | 2.17157419 | Gemmatimonas groenlandica | 2732249 | Bacteria | Bacteria | 342 | 1.21e-89 | NTclustered | gi|1839994010|gb|CP053085.1| | 2732249 | g21107 | i0 | 91.27 | 1.00398406374502 | 252 | 20 | 100 | 2 | 1 | 251 | 2284153 | 2283903 | Gemmatimonas groenlandica strain TET16 chromosome, complete genome | blastn | 252 | 342 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas groenlandica | |
| 22549625 | 22549625 | PRJNA896758_P_NODE_16138_length_286_cov_1.446009_g15748_i0 | PRJNA896758 | 16138 | 286 | 1.446009 | 4.13558574 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 135 | 2.5500000000000003e-27 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g15748 | i0 | 89.72 | 0.374125874125874 | 107 | 9 | 37 | 2 | 181 | 286 | 4916867 | 4916762 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 107 | 135 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 24195468 | 24195468 | PRJNA896758_P_NODE_20419_length_256_cov_1.683060_g20029_i0 | PRJNA896758 | 20419 | 256 | 1.68306 | 4.3086336 | Gemmatimonas | 173479 | Bacteria | Bacteria | 446 | 9.139999999999999e-121 | NTclustered | gi|470475286|ref|NR_076270.1| | 173480 | g20029 | i0 | 98.047 | 429.29296875 | 256 | 5 | 100 | 0 | 1 | 256 | 929 | 674 | Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence | blastn | 109899 | 446 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 27561016 | 27561016 | PRJNA896758_P_NODE_20304_length_257_cov_1.635870_g19914_i0 | PRJNA896758 | 20304 | 257 | 1.63587 | 4.2041859 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 84.3 | 1.47e-17 | NR | HLB09127.1 | 2026741 | g19914 | i0 | 44.6 | 0.968871595330739 | 83 | 45 | 96.9 | 1 | 3 | 251 | 130 | 211 | HLB09127.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 249 | 84.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31422221 | 31422221 | PRJNA896758_P_NODE_24476_length_245_cov_0.895349_g24086_i0 | PRJNA896758 | 24476 | 245 | 0.895349 | 2.19360505 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 63.5 | 1.68e-9 | NR | HLV27416.1 | 2448054 | g24086 | i0 | 51.5 | 1.66530612244898 | 68 | 32 | 82 | 1 | 44 | 244 | 199 | 266 | HLV27416.1 serine hydrolase [Gemmatimonadales bacterium] | diamond | 408 | 63.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);;