contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA498309" and tax_phylum = "Candidatus Absconditibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1757444 | 1757444 | PRJNA498309_S_NODE_39242_length_217_cov_372.395604_g37074_i0 | PRJNA498309 | 39242 | 217 | 372.395604 | 808.09846068 | candidate division SR1 bacterium RAAC1_SR1_1 | 1394709 | Bacteria | Bacteria | 161 | 3.05e-35 | NTclustered | gi|563351663|gb|CP006913.1| | 1394709 | g37074 | i0 | 82.873 | 45.6267281105991 | 181 | 29 | 83 | 2 | 1 | 180 | 125727 | 125906 | Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome | blastn | 9901 | 161 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium RAAC1_SR1_1 | ||||||
| 13234909 | 13234909 | PRJNA498309_P_NODE_6191_length_1287_cov_13.224800_g5028_i0 | PRJNA498309 | 6191 | 1287 | 13.2248 | 170.203176 | candidate division SR1 bacterium RAAC1_SR1_1 | 1394709 | Bacteria | Bacteria | 1042 | 0 | NTclustered | gi|563351663|gb|CP006913.1| | 1394709 | g5028 | i0 | 82.898 | 137.776223776224 | 1187 | 175 | 91 | 27 | 94 | 1265 | 126091 | 124918 | Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome | blastn | 177318 | 1042 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium RAAC1_SR1_1 | ||||||
| 15785314 | 15785314 | PRJNA498309_S_NODE_6633_length_1081_cov_42.605163_g5134_i0 | PRJNA498309 | 6633 | 1081 | 42.605163 | 460.56181203 | candidate division SR1 bacterium RAAC1_SR1_1 | 1394709 | Bacteria | Bacteria | 728 | 0 | NTclustered | gi|563351663|gb|CP006913.1| | 1394709 | g5134 | i0 | 82.118 | 97.5235892691952 | 878 | 131 | 100 | 25 | 1 | 864 | 125766 | 124901 | Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome | blastn | 105423 | 728 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium RAAC1_SR1_1 | ||||||
| 23434062 | 23434062 | PRJNA498309_P_NODE_96899_length_201_cov_8.829268_g94750_i0 | PRJNA498309 | 96899 | 201 | 8.829268 | 17.74682868 | Candidatus Absconditicoccus praedator | 2735562 | Bacteria | Bacteria | 171 | 4.6299999999999996e-38 | NTclustered | gi|2160621446|gb|CP054059.1| | 2735562 | g94750 | i0 | 84.27 | 297.114427860697 | 178 | 25 | 87 | 2 | 26 | 200 | 728820 | 728643 | Candidatus Absconditicoccus praedator strain M39-6 chromosome, complete genome | blastn | 59720 | 171 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | Candidatus Absconditabacterales | Candidatus Absconditicoccaceae | Candidatus Absconditicoccus | Candidatus Absconditicoccus praedator |
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);;