contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA939415" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3466236 | 3466236 | PRJNA939415_P_NODE_36623_length_298_cov_4.662222_g36201_i0 | PRJNA939415 | 36623 | 298 | 4.662222 | 13.89342156 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 148 | 3.4299999999999996e-31 | NTclustered | gi|2107813725|gb|CP070823.1| | 2026742 | g36201 | i0 | 86.131 | 0.88255033557047 | 137 | 19 | 46 | 0 | 13 | 149 | 124124 | 124260 | MAG: Gemmatimonadetes bacterium isolate bin113 chromosome | blastn | 263 | 148 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 4744760 | 4744760 | PRJNA939415_P_NODE_93324_length_243_cov_0.905882_g92902_i0 | PRJNA939415 | 93324 | 243 | 0.905882 | 2.20129326 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|2874254163|emb|OY970395.1| | 412054 | g92902 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 172 | 199 | 3902468 | 3902495 | MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 7293936 | 7293936 | PRJNA939415_P_NODE_54986_length_278_cov_7.946341_g54564_i0 | PRJNA939415 | 54986 | 278 | 7.946341 | 22.09082798 | Gemmatimonas aurantiaca | 173480 | Bacteria | Bacteria | 75 | 5.46e-9 | NTclustered | gi|226088597|dbj|AP009153.1| | 379066 | g54564 | i0 | 85.915 | 4.91726618705036 | 71 | 8 | 25 | 2 | 1 | 70 | 512740 | 512809 | Gemmatimonas aurantiaca T-27 DNA, complete genome | blastn | 1367 | 75 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas aurantiaca | |
| 9843555 | 9843555 | PRJNA939415_P_NODE_45168_length_288_cov_3.400000_g44746_i0 | PRJNA939415 | 45168 | 288 | 3.4 | 9.792 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 196 | 1.16e-45 | NTclustered | gi|2874254163|emb|OY970395.1| | 412054 | g44746 | i0 | 81.377 | 46.7881944444444 | 247 | 40 | 85 | 6 | 45 | 288 | 938789 | 939032 | MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1 | blastn | 13475 | 196 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 9843895 | 9843895 | PRJNA939415_P_NODE_63268_length_270_cov_3.664975_g62846_i0 | PRJNA939415 | 63268 | 270 | 3.664975 | 9.8954325 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 403 | 5.93e-108 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g62846 | i0 | 93.704 | 296.611111111111 | 270 | 15 | 100 | 2 | 1 | 270 | 3042966 | 3043233 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 80085 | 403 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 13669050 | 13669050 | PRJNA939415_P_NODE_40431_length_294_cov_2.352941_g40009_i0 | PRJNA939415 | 40431 | 294 | 2.352941 | 6.91764654 | uncultured Gemmatimonadaceae bacterium | 246130 | Bacteria | Bacteria | 130 | 1.22e-25 | NTclustered | gi|2874253995|emb|OY970320.1| | 246130 | g40009 | i0 | 75.472 | 1.81292517006803 | 318 | 51 | 100 | 22 | 1 | 294 | 1635433 | 1635119 | MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 | blastn | 533 | 130 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | uncultured Gemmatimonadaceae bacterium | ||
| 16218290 | 16218290 | PRJNA939415_P_NODE_31893_length_310_cov_2.860759_g31471_i0 | PRJNA939415 | 31893 | 310 | 2.860759 | 8.8683529 | Roseisolibacter agri | 2014610 | Bacteria | Bacteria | 481 | 3.12e-131 | NTclustered | gi|1679775923|ref|NR_163645.1| | 2014610 | g31471 | i0 | 95.161 | 101.087096774194 | 310 | 4 | 100 | 3 | 1 | 310 | 39 | 337 | Roseisolibacter agri strain AW1220 16S ribosomal RNA, partial sequence | blastn | 31337 | 481 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Roseisolibacter | Roseisolibacter agri | |
| 16219395 | 16219395 | PRJNA939415_P_NODE_93793_length_242_cov_3.248521_g93371_i0 | PRJNA939415 | 93793 | 242 | 3.248521 | 7.86142082 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 126 | 1.2699999999999999e-24 | NTclustered | gi|2621703971|emb|OY762926.1| | 2026742 | g93371 | i0 | 89.109 | 32.4834710743802 | 101 | 11 | 42 | 0 | 71 | 171 | 1216497 | 1216597 | MAG: Gemmatimonadota bacterium isolate 6e3ee631-f785-49ea-85f7-2f24cfa146af genome assembly, chromosome: 1 | blastn | 7861 | 126 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota 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);;