contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA630877" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4430823 | 4430823 | PRJNA630877_S_NODE_45484_length_650_cov_12.014778_g27139_i1 | PRJNA630877 | 45484 | 650 | 12.014778 | 78.096057 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 989 | 0 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g27139 | i1 | 94.172 | 106.669230769231 | 652 | 33 | 99 | 5 | 3 | 650 | 3558777 | 3558127 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 69335 | 989 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 5706716 | 5706716 | PRJNA630877_S_NODE_103945_length_218_cov_2.231638_g84808_i0 | PRJNA630877 | 103945 | 218 | 2.231638 | 4.86497084 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 331 | 2.21e-86 | NTclustered | gi|2874253885|emb|OY970060.1| | 171953 | g84808 | i0 | 94.037 | 18.8073394495413 | 218 | 13 | 100 | 0 | 1 | 218 | 4841925 | 4841708 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 | blastn | 4100 | 331 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 6981553 | 6981553 | PRJNA630877_S_NODE_111546_length_203_cov_1.956790_g92409_i0 | PRJNA630877 | 111546 | 203 | 1.95679 | 3.9722837 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 261 | 2.7000000000000007e-65 | NTclustered | gi|2874253885|emb|OY970060.1| | 171953 | g92409 | i0 | 89.756 | 128.320197044335 | 205 | 19 | 100 | 2 | 1 | 203 | 4840574 | 4840778 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 | blastn | 26049 | 261 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 6981560 | 6981560 | PRJNA630877_S_NODE_156466_length_153_cov_1.178571_g137329_i0 | PRJNA630877 | 156466 | 153 | 1.178571 | 1.80321363 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 250 | 4.14e-62 | NTclustered | gi|2874253796|emb|OY969780.1| | 194844 | g137329 | i0 | 96.078 | 61.5882352941176 | 153 | 6 | 100 | 0 | 1 | 153 | 285252 | 285100 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1 | blastn | 9423 | 250 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 10807316 | 10807316 | PRJNA630877_S_NODE_91489_length_250_cov_7.947368_g72352_i0 | PRJNA630877 | 91489 | 250 | 7.947368 | 19.86842 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 285 | 2.05e-72 | NTclustered | gi|76574293|gb|DQ139441.1| | 171953 | g72352 | i0 | 87.449 | 309.188 | 247 | 31 | 99 | 0 | 4 | 250 | 305 | 59 | Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence | blastn | 77297 | 285 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 12082562 | 12082562 | PRJNA630877_S_NODE_160690_length_150_cov_1.165138_g141553_i0 | PRJNA630877 | 160690 | 150 | 1.165138 | 1.747707 | Edaphobacter paludis | 3035702 | Bacteria | Bacteria | 250 | 4.04e-62 | NTclustered | gi|2737763816|gb|CP121194.1| | 3035702 | g141553 | i0 | 96.667 | 52.14 | 150 | 5 | 100 | 0 | 1 | 150 | 661304 | 661155 | Edaphobacter paludis strain DSM 109919 chromosome, complete genome | blastn | 7821 | 250 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter paludis | ||
| 12630827 | 12630827 | PRJNA630877_S_NODE_45590_length_648_cov_12.257002_g27667_i0 | PRJNA630877 | 45590 | 648 | 12.257002 | 79.42537296 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 946 | 0 | NTclustered | gi|2874253750|emb|OY969625.1| | 194844 | g27667 | i0 | 93.077 | 108.983024691358 | 650 | 40 | 100 | 5 | 1 | 648 | 2136 | 1490 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1 | blastn | 70621 | 946 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 15905941 | 15905941 | PRJNA630877_S_NODE_71953_length_338_cov_14.158249_g52816_i0 | PRJNA630877 | 71953 | 338 | 14.158249 | 47.85488162 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 501 | 2.64e-137 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g52816 | i0 | 93.491 | 107.532544378698 | 338 | 21 | 100 | 1 | 1 | 338 | 3558114 | 3558450 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 36346 | 501 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 18455190 | 18455190 | PRJNA630877_S_NODE_84775_length_274_cov_1.158798_g65638_i0 | PRJNA630877 | 84775 | 274 | 1.158798 | 3.17510652 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 385 | 2.18e-102 | NTclustered | gi|338189354|gb|JF989862.1| | 171953 | g65638 | i0 | 92.593 | 77.3576642335766 | 270 | 16 | 98 | 3 | 1 | 268 | 225 | 492 | Uncultured Acidobacteria bacterium clone Paddy_500_9163 16S ribosomal RNA gene, partial sequence | blastn | 21196 | 385 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 22280241 | 22280241 | PRJNA630877_S_NODE_88018_length_262_cov_1.597285_g68881_i0 | PRJNA630877 | 88018 | 262 | 1.597285 | 4.1848867 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 316 | 7.679999999999998e-82 | NTclustered | gi|217038907|gb|EU810998.1| | 171953 | g68881 | i0 | 89.147 | 136.629770992366 | 258 | 22 | 97 | 6 | 1 | 255 | 332 | 78 | Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence | blastn | 35797 | 316 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota 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);;