contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA557436" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3086665 | 3086665 | PRJNA557436_S_NODE_6703_length_167_cov_0.992424_g6655_i0 | PRJNA557436 | 6703 | 167 | 0.992424 | 1.65734808 | Candidatus Kaiserbacteria bacterium | 2030810 | Bacteria | Bacteria | 183 | 4.759999999999998e-42 | NTclustered | gi|2874253687|emb|OY969413.1| | 2030810 | g6655 | i0 | 96.396 | 2.01197604790419 | 111 | 4 | 66 | 0 | 57 | 167 | 487955 | 487845 | MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1 | blastn | 336 | 183 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Kaiseribacteriota | Candidatus Kaiserbacteria bacterium | ||||||
| 5639547 | 5639547 | PRJNA557436_S_NODE_6305_length_170_cov_1.437037_g6257_i0 | PRJNA557436 | 6305 | 170 | 1.437037 | 2.4429629 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 315 | 1.64e-81 | NTclustered | gi|1958015594|gb|CP064967.1| | 2282149 | g6257 | i0 | 100 | 1 | 170 | 0 | 100 | 0 | 1 | 170 | 351980 | 352149 | MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome | blastn | 170 | 315 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 8188595 | 8188595 | PRJNA557436_S_NODE_8147_length_157_cov_1.065574_g8099_i0 | PRJNA557436 | 8147 | 157 | 1.065574 | 1.67295118 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 174 | 2.65e-39 | NTclustered | gi|1958015594|gb|CP064967.1| | 2282149 | g8099 | i0 | 87.097 | 0.987261146496815 | 155 | 19 | 98 | 1 | 4 | 157 | 823005 | 823159 | MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome | blastn | 155 | 174 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 13289734 | 13289734 | PRJNA557436_S_NODE_4931_length_185_cov_1.513333_g4883_i0 | PRJNA557436 | 4931 | 185 | 1.513333 | 2.79966605 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 342 | 8.369999999999999e-90 | NTclustered | gi|1958015594|gb|CP064967.1| | 2282149 | g4883 | i0 | 100 | 1 | 185 | 0 | 100 | 0 | 1 | 185 | 415083 | 415267 | MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome | blastn | 185 | 342 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 15838483 | 15838483 | PRJNA557436_S_NODE_6433_length_169_cov_1.358209_g6385_i0 | PRJNA557436 | 6433 | 169 | 1.358209 | 2.29537321 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 307 | 2.73e-79 | NTclustered | gi|1958015594|gb|CP064967.1| | 2282149 | g6385 | i0 | 99.408 | 1 | 169 | 1 | 100 | 0 | 1 | 169 | 136220 | 136388 | MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome | blastn | 169 | 307 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 17113468 | 17113468 | PRJNA557436_S_NODE_9094_length_152_cov_1.461538_g9046_i0 | PRJNA557436 | 9094 | 152 | 1.461538 | 2.22153776 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 281 | 1.46e-71 | NTclustered | gi|1958015594|gb|CP064967.1| | 2282149 | g9046 | i0 | 100 | 1 | 152 | 0 | 100 | 0 | 1 | 152 | 850014 | 850165 | MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome | blastn | 152 | 281 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 18387601 | 18387601 | PRJNA557436_S_NODE_5715_length_176_cov_1.049645_g5667_i0 | PRJNA557436 | 5715 | 176 | 1.049645 | 1.8473752 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 320 | 3.69e-83 | NTclustered | gi|1958015594|gb|CP064967.1| | 2282149 | g5667 | i0 | 100 | 0.982954545454545 | 173 | 0 | 98 | 0 | 1 | 173 | 810509 | 810337 | MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome | blastn | 173 | 320 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 19662012 | 19662012 | PRJNA557436_S_NODE_6816_length_166_cov_1.190840_g6768_i0 | PRJNA557436 | 6816 | 166 | 1.19084 | 1.9767944 | Candidatus Moraniibacteriota bacterium | 2045217 | Bacteria | Bacteria | 204 | 3.629999999999999e-48 | NTclustered | gi|1958115141|gb|CP065011.1| | 2045217 | g6768 | i0 | 91.892 | 1.78313253012048 | 148 | 9 | 89 | 3 | 1 | 147 | 454189 | 454334 | MAG: Candidatus Moraniibacteriota bacterium isolate Mari_18-Q3-R65-66_MAXAC.243_uni chromosome, complete genome | blastn | 296 | 204 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Moraniibacteriota | Candidatus Moraniibacteriota bacterium | ||||||
| 20937741 | 20937741 | PRJNA557436_S_NODE_237_length_690_cov_3.174046_g204_i0 | PRJNA557436 | 237 | 690 | 3.174046 | 21.9009174 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 1264 | 0 | NTclustered | gi|1958015594|gb|CP064967.1| | 2282149 | g204 | i0 | 99.71 | 15.4594202898551 | 690 | 2 | 100 | 0 | 1 | 690 | 88533 | 89222 | MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome | blastn | 10667 | 1264 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 20937755 | 20937755 | PRJNA557436_S_NODE_6217_length_171_cov_1.176471_g6169_i0 | PRJNA557436 | 6217 | 171 | 1.176471 | 2.01176541 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 311 | 2.14e-80 | NTclustered | gi|1958015594|gb|CP064967.1| | 2282149 | g6169 | i0 | 99.415 | 1 | 171 | 1 | 100 | 0 | 1 | 171 | 511931 | 512101 | MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome | blastn | 171 | 311 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 22212764 | 22212764 | PRJNA557436_S_NODE_8958_length_153_cov_1.016949_g8910_i0 | PRJNA557436 | 8958 | 153 | 1.016949 | 1.55593197 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 272 | 8.84e-69 | NTclustered | gi|1958015594|gb|CP064967.1| | 2282149 | g8910 | i0 | 98.693 | 1 | 153 | 2 | 100 | 0 | 1 | 153 | 748244 | 748092 | MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome | blastn | 153 | 272 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria 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);;