contig_metadata
6 rows where bioproject = "PRJNA641707", tax_clade = "FCB group" and tax_phylum = "Candidatus Latescibacterota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5721036 | 5721036 | PRJNA641707_P_NODE_89665_length_246_cov_5.786802_g87002_i0 | PRJNA641707 | 89665 | 246 | 5.786802 | 14.23553292 | uncultured Latescibacterota bacterium | 199737 | Bacteria | Bacteria | 76.8 | 1.32e-9 | NTclustered | gi|82523633|emb|AJ937675.1| | 199737 | g87002 | i0 | 89.062 | 139.178861788618 | 64 | 3 | 25 | 4 | 39 | 99 | 3657 | 3719 | Uncultured candidate division WS3 bacterium 16S rRNA gene (partial), ITS1, tRNA-Ile gene, tRNA-Ala gene and 23S rRNA gene (partial), clone b1bcf1.1.f04.rrna.clone7 | blastn | 34238 | 76.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | uncultured Latescibacterota bacterium | |||||
| 16459962 | 16459962 | PRJNA641707_P_NODE_257553_length_179_cov_4.361538_g254890_i0 | PRJNA641707 | 257553 | 179 | 4.361538 | 7.80715302 | Bacteria | 2 | Bacteria | Bacteria | 174 | 3.1e-39 | NTclustered | gi|2518550840|emb|OX638317.1| | 199737 | g254890 | i0 | 88.356 | 274.631284916201 | 146 | 16 | 81 | 1 | 7 | 151 | 3961042 | 3960897 | MAG: uncultured Latescibacteria bacterium isolate cbbe8a84-e08a-4d06-a76e-2eb930d8ff24 genome assembly, chromosome: 1 | blastn | 49159 | 174 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | uncultured Latescibacterota bacterium | |||||
| 17189367 | 17189367 | PRJNA641707_P_NODE_127854_length_244_cov_9.189744_g125191_i0 | PRJNA641707 | 127854 | 244 | 9.189744 | 22.42297536 | uncultured Latescibacterota bacterium | 199737 | Bacteria | Bacteria | 65.8 | 2.83e-6 | NTclustered | gi|2531976039|emb|OY282377.1| | 199737 | g125191 | i0 | 90 | 0.475409836065574 | 50 | 5 | 20 | 0 | 51 | 100 | 916866 | 916817 | MAG: uncultured Latescibacteria bacterium genome assembly, chromosome: 1 | blastn | 116 | 65.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | uncultured Latescibacterota bacterium | |||||
| 27365873 | 27365873 | PRJNA641707_P_NODE_189583_length_199_cov_3.806667_g186920_i0 | PRJNA641707 | 189583 | 199 | 3.806667 | 7.57526733 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 70.9 | 2.55e-12 | NR | MCE2432431.1 | 2053570 | g186920 | i0 | 86 | 45.6633165829146 | 43 | 1 | 64.8 | 2 | 193 | 65 | 157 | 194 | MCE2432431.1 (E)-4-hydroxy-3-methylbut-2-enyl-diphosphate synthase [Candidatus Latescibacterota bacterium] | diamond | 9087 | 70.9 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 28502325 | 28502325 | PRJNA641707_P_NODE_211967_length_195_cov_5.630137_g209304_i0 | PRJNA641707 | 211967 | 195 | 5.630137 | 10.97876715 | Candidatus Latescibacterota bacterium | 2053570 | Bacteria | Bacteria | 57.8 | 9.99e-8 | NR | UCE02226.1 | 2053570 | g209304 | i0 | 44.4 | 1.96923076923077 | 63 | 35 | 96.9 | 0 | 189 | 1 | 137 | 199 | UCE02226.1 MAG: leucyl aminopeptidase family protein [Candidatus Latescibacterota bacterium] | diamond | 384 | 57.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacterota bacterium | |||||
| 29967193 | 29967193 | PRJNA641707_P_NODE_248471_length_183_cov_2.656716_g245808_i0 | PRJNA641707 | 248471 | 183 | 2.656716 | 4.86179028 | FCB group | 1783270 | Bacteria | Bacteria | 43.5 | 0.00307 | NR | OPX32995.1 | 1956174 | g245808 | i0 | 63.3 | 8.27868852459016 | 30 | 11 | 49.2 | 0 | 93 | 4 | 1 | 30 | OPX32995.1 MAG: hypothetical protein B1H40_01125 [Candidatus Latescibacteria bacterium 4484_181] | diamond | 1515 | 43.9 | 0.990888382687927 | Bacteria | FCB group | Pseudomonadati | Candidatus Latescibacterota | Candidatus Latescibacteria bacterium 4484_181 |
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);;