contig_metadata
4 rows where bioproject = "PRJNA977246", tax_clade = "Bacteria candidate phyla" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 951797 | 951797 | PRJNA977246_S_NODE_8381_length_538_cov_8.754420_g7522_i0 | PRJNA977246 | 8381 | 538 | 8.75442 | 47.0987796 | uncultured candidate division SR1 bacterium | 221237 | Bacteria | Bacteria | 580 | 5.4499999999999985e-161 | NTclustered | gi|336020567|gb|JF917288.1| | 221237 | g7522 | i0 | 88.32 | 94.1486988847584 | 488 | 52 | 90 | 5 | 53 | 538 | 115 | 599 | Uncultured candidate division SR1 bacterium clone B1Q1E-91f-JRD28 16S ribosomal RNA gene, partial sequence | blastn | 50652 | 580 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | uncultured candidate division SR1 bacterium | ||||||
| 6054972 | 6054972 | PRJNA977246_S_NODE_4605_length_763_cov_11.337875_g4013_i0 | PRJNA977246 | 4605 | 763 | 11.337875 | 86.50798625 | candidate division SR1 bacterium RAAC1_SR1_1 | 1394709 | Bacteria | Bacteria | 804 | 0 | NTclustered | gi|563351663|gb|CP006913.1| | 1394709 | g4013 | i0 | 86.28 | 88.0943643512451 | 758 | 83 | 98 | 20 | 1 | 746 | 128834 | 129582 | Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome | blastn | 67216 | 804 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium RAAC1_SR1_1 | ||||||
| 29678392 | 29678392 | PRJNA977246_S_NODE_30610_length_223_cov_3.221649_g29618_i0 | PRJNA977246 | 30610 | 223 | 3.221649 | 7.18427727 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 42.7 | 0.00557 | NR | PID34526.1 | 2044938 | g29618 | i0 | 73.9 | 1.23766816143498 | 23 | 6 | 30.9 | 0 | 130 | 62 | 3 | 25 | PID34526.1 MAG: hypothetical protein CR971_02820 [candidate division SR1 bacterium] | diamond | 276 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 bacterium | ||||||
| 31890994 | 31890994 | PRJNA977246_S_NODE_37717_length_190_cov_2.565217_g36725_i0 | PRJNA977246 | 37717 | 190 | 2.565217 | 4.8739123 | candidate division SR1 bacterium | 2044938 | Bacteria | Bacteria | 53.1 | 4.56e-7 | NR | MCX6822792.1 | 2044938 | g36725 | i0 | 61 | 1.29473684210526 | 41 | 16 | 64.7 | 0 | 125 | 3 | 1 | 41 | MCX6822792.1 hypothetical protein [candidate division SR1 bacterium] | diamond | 246 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Absconditibacteriota | candidate division SR1 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);;