contig_metadata
6 rows where bioproject = "PRJNA674050" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 643831 | 643831 | PRJNA674050_P_NODE_29521_length_248_cov_0.874286_g29318_i0 | PRJNA674050 | 29521 | 248 | 0.874286 | 2.16822928 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 154 | 5.98e-33 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g29318 | i0 | 89.344 | 2.19354838709677 | 122 | 13 | 49 | 0 | 50 | 171 | 5682898 | 5682777 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 544 | 154 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 3194347 | 3194347 | PRJNA674050_P_NODE_17923_length_265_cov_1.614583_g17720_i0 | PRJNA674050 | 17923 | 265 | 1.614583 | 4.27864495 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 479 | 9.38e-131 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g17720 | i0 | 99.245 | 86.3132075471698 | 265 | 2 | 100 | 0 | 1 | 265 | 172312 | 172576 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 22873 | 479 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 22320688 | 22320688 | PRJNA674050_P_NODE_1438_length_559_cov_3.390947_g1240_i0 | PRJNA674050 | 1438 | 559 | 3.390947 | 18.95539373 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 616 | 1.5599999999999994e-171 | NTclustered | gi|2107953857|gb|CP070792.1| | 2026742 | g1240 | i0 | 86.842 | 184.976744186047 | 570 | 51 | 100 | 18 | 1 | 559 | 1095938 | 1095382 | MAG: Gemmatimonadetes bacterium isolate bin1440 chromosome | blastn | 103402 | 616 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 22321062 | 22321062 | PRJNA674050_P_NODE_25018_length_251_cov_0.865169_g24815_i0 | PRJNA674050 | 25018 | 251 | 0.865169 | 2.17157419 | Longimicrobium | 1804994 | Bacteria | Bacteria | 134 | 2.53e-36 | NR | CAA9356552.1 | 203437 | g24815 | i0 | 73.5 | 2.95219123505976 | 83 | 22 | 99.2 | 0 | 2 | 250 | 174 | 256 | CAA9356552.1 MAG: Glyoxalase family protein [uncultured Gemmatimonadota bacterium] | diamond | 741 | 135 | 0.992592592592593 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | uncultured Gemmatimonadota bacterium | |||||
| 27599381 | 27599381 | PRJNA674050_P_NODE_23624_length_252_cov_0.865922_g23421_i0 | PRJNA674050 | 23624 | 252 | 0.865922 | 2.18212344 | Bacteria | 2 | Bacteria | Bacteria | 103 | 1.87e-25 | NR | MBS1240794.1 | 2026742 | g23421 | i0 | 80.3 | 5.80952380952381 | 61 | 12 | 72.6 | 0 | 8 | 190 | 128 | 188 | MBS1240794.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 1464 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29355535 | 29355535 | PRJNA674050_P_NODE_39109_length_242_cov_0.923077_g38906_i0 | PRJNA674050 | 39109 | 242 | 0.923077 | 2.23384634 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 120 | 2.7599999999999996e-31 | NR | HEX8212551.1 | 2029185 | g38906 | i0 | 78.5 | 0.979338842975207 | 79 | 17 | 97.9 | 0 | 6 | 242 | 113 | 191 | HEX8212551.1 hypothetical protein [Longimicrobium sp.] | diamond | 237 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. |
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);;