contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA900999" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3428862 | 3428862 | PRJNA900999_S_NODE_4963_length_196_cov_4.700599_g4907_i0 | PRJNA900999 | 4963 | 196 | 4.700599 | 9.21317404 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 219 | 1.58e-52 | NTclustered | gi|1015624362|gb|AH012920.2| | 171953 | g4907 | i0 | 86.869 | 3.51020408163265 | 198 | 22 | 100 | 3 | 1 | 196 | 31419 | 31224 | Uncultured Acidobacteria bacterium clone 46h5 hypothetical protein, putative O-linked GlcNAc transferase, putative two-component response regulator, hypothetical protein, putative penicillin-resistance DD-carboxypeptidase, putative glycosyl transferase, hypothetical protein, conserved hypothetical protein, hypothetical protein, putative MaoC family dehydratase, putative D-3-phosphoglycerate dehydrogenase, putative magnesium and cobalt transport protein, putative phosphatidyl-glycerophosphatase, putative 2-methylthioadenine synthetase, hypothetical protein, putative glutamine cyclotransferase, and hypothetical protein genes, complete cds; 5S ribosomal RNA, 23S ribosomal RNA, tRNA-Ala, tRNA-Met, tRNA-Ile, and 16S ribosomal RNA genes, complete sequence; and hypothetical protein genes, complete cds | blastn | 688 | 219 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 3797980 | 3797980 | PRJNA900999_S_NODE_8923_length_155_cov_12.793651_g8867_i0 | PRJNA900999 | 8923 | 155 | 12.793651 | 19.83015905 | Bacteria | 2 | Bacteria | Bacteria | 171 | 3.37e-38 | NTclustered | gi|2874253677|emb|OY969111.1| | 171953 | g8867 | i0 | 86.957 | 66.5806451612903 | 161 | 9 | 100 | 11 | 1 | 155 | 715995 | 716149 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1 | blastn | 10320 | 171 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 4706732 | 4706732 | PRJNA900999_S_NODE_504_length_428_cov_27.483709_g451_i0 | PRJNA900999 | 504 | 428 | 27.483709 | 117.63027452 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 512 | 1.58e-140 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g451 | i0 | 88.222 | 480.42523364486 | 433 | 45 | 100 | 5 | 1 | 428 | 4233442 | 4233873 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 205622 | 512 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 4706770 | 4706770 | PRJNA900999_S_NODE_904_length_351_cov_35.108696_g848_i0 | PRJNA900999 | 904 | 351 | 35.108696 | 123.23152296 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 444 | 4.68e-120 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g848 | i0 | 89.855 | 443.518518518519 | 345 | 35 | 98 | 0 | 7 | 351 | 4233786 | 4233442 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 155675 | 444 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 7256213 | 7256213 | PRJNA900999_S_NODE_6526_length_176_cov_14.605442_g6470_i0 | PRJNA900999 | 6526 | 176 | 14.605442 | 25.70557792 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 241 | 2.950000000000001e-59 | NTclustered | gi|217038899|gb|EU810989.1| | 171953 | g6470 | i0 | 93.293 | 154.306818181818 | 164 | 9 | 93 | 2 | 7 | 169 | 163 | 1 | Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence | blastn | 27158 | 241 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 9805989 | 9805989 | PRJNA900999_S_NODE_2388_length_258_cov_5.117904_g2332_i0 | PRJNA900999 | 2388 | 258 | 5.117904 | 13.20419232 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 320 | 5.83e-83 | NTclustered | gi|1958098837|gb|CP065005.1| | 1978231 | g2332 | i0 | 89.641 | 111.445736434109 | 251 | 26 | 97 | 0 | 8 | 258 | 4648920 | 4648670 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome | blastn | 28753 | 320 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 12357030 | 12357030 | PRJNA900999_S_NODE_3050_length_236_cov_24.130435_g2994_i0 | PRJNA900999 | 3050 | 236 | 24.130435 | 56.9478266 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 261 | 3.23e-65 | NTclustered | gi|1958093598|gb|CP065003.1| | 1978231 | g2994 | i0 | 88.889 | 41.6059322033898 | 216 | 19 | 90 | 5 | 1 | 213 | 317465 | 317252 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome | blastn | 9819 | 261 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | 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);;