contig_metadata
5 rows where bioproject = "PRJNA1031674", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27153142 | 27153142 | PRJNA1031674_P_NODE_27602_length_241_cov_2.726190_g27391_i0 | PRJNA1031674 | 27602 | 241 | 2.72619 | 6.5701179 | Bacillati | 1783272 | Bacteria | Bacteria | 121 | 5.400000000000001e-30 | NR | HNB20838.1 | 2052166 | g27391 | i0 | 87.9 | 7.39419087136929 | 66 | 8 | 82.2 | 0 | 200 | 3 | 1 | 66 | HNB20838.1 type IV secretory system conjugative DNA transfer family protein [Candidatus Melainabacteria bacterium] | diamond | 1782 | 121 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 28329911 | 28329911 | PRJNA1031674_P_NODE_15406_length_276_cov_1.241379_g15195_i0 | PRJNA1031674 | 15406 | 276 | 1.241379 | 3.42620604 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 89.7 | 7.43e-20 | NR | MFA6559124.1 | 2364082 | g15195 | i0 | 100 | 3.65217391304348 | 48 | 0 | 52.2 | 0 | 2 | 145 | 158 | 205 | MFA6559124.1 Na+ dependent nucleoside transporter N-terminal domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 1008 | 89.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29174748 | 29174748 | PRJNA1031674_P_NODE_18549_length_264_cov_2.214660_g18338_i0 | PRJNA1031674 | 18549 | 264 | 2.21466 | 5.8467024 | Bacillati | 1783272 | Bacteria | Bacteria | 130 | 2.63e-33 | NR | MDP3508783.1 | 2052166 | g18338 | i0 | 68.2 | 5.04545454545455 | 88 | 28 | 100 | 0 | 1 | 264 | 101 | 188 | MDP3508783.1 GIY-YIG nuclease family protein [Candidatus Melainabacteria bacterium] | diamond | 1332 | 131 | 0.99236641221374 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30793326 | 30793326 | PRJNA1031674_P_NODE_24014_length_248_cov_0.880000_g23803_i0 | PRJNA1031674 | 24014 | 248 | 0.88 | 2.1824 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 149 | 9.9e-40 | NR | MBX9724063.1 | 2364082 | g23803 | i0 | 85.4 | 0.991935483870968 | 82 | 12 | 99.2 | 0 | 248 | 3 | 379 | 460 | MBX9724063.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 246 | 149 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30919998 | 30919998 | PRJNA1031674_P_NODE_24794_length_246_cov_1.780347_g24583_i0 | PRJNA1031674 | 24794 | 246 | 1.780347 | 4.37965362 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 104 | 8.289999999999999e-24 | NR | MFA7339202.1 | 2364082 | g24583 | i0 | 59.3 | 2.96341463414634 | 81 | 33 | 98.8 | 0 | 2 | 244 | 1040 | 1120 | MFA7339202.1 diguanylate cyclase [Candidatus Obscuribacterales bacterium] | diamond | 729 | 104 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales 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);;