contig_metadata
4 rows where bioproject = "PRJNA529224", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5601796 | 5601796 | PRJNA529224_S_NODE_765_length_228_cov_14.532663_g758_i0 | PRJNA529224 | 765 | 228 | 14.532663 | 33.13447164 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 193 | 1.15e-44 | NTclustered | gi|2621703062|emb|OY760504.1| | 2033014 | g758 | i0 | 84.058 | 176.605263157895 | 207 | 25 | 89 | 8 | 1 | 203 | 2410822 | 2410620 | MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1 | blastn | 40266 | 193 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 10701997 | 10701997 | PRJNA529224_S_NODE_1669_length_162_cov_14.661654_g1662_i0 | PRJNA529224 | 1669 | 162 | 14.661654 | 23.75187948 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 108 | 2.84e-19 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g1662 | i0 | 85.185 | 202.956790123457 | 108 | 13 | 66 | 3 | 2 | 108 | 1304881 | 1304776 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 32879 | 108 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 13251859 | 13251859 | PRJNA529224_S_NODE_31_length_621_cov_82.109797_g26_i0 | PRJNA529224 | 31 | 621 | 82.109797 | 509.90183937 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 499 | 1.83e-136 | NTclustered | gi|2874254000|emb|OY970325.1| | 157466 | g26 | i0 | 81.732 | 339.487922705314 | 635 | 83 | 99 | 25 | 2 | 621 | 1306471 | 1305855 | MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 | blastn | 210822 | 499 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 18349491 | 18349491 | PRJNA529224_S_NODE_1315_length_183_cov_230.025974_g1308_i0 | PRJNA529224 | 1315 | 183 | 230.025974 | 420.94753242 | Capsulimonas corticalis | 2219043 | Bacteria | Bacteria | 241 | 3.1e-59 | NTclustered | gi|2240447379|dbj|AP025739.1| | 2219043 | g1308 | i0 | 91.061 | 153.453551912568 | 179 | 14 | 98 | 2 | 1 | 179 | 593743 | 593567 | Capsulimonas corticalis AX-7 DNA, complete genome | blastn | 28082 | 241 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadia | Capsulimonadales | Capsulimonadaceae | Capsulimonas | Capsulimonas corticalis |
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);;