contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA724039" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3262534 | 3262534 | PRJNA724039_S_NODE_5663_length_291_cov_1.811024_g5456_i0 | PRJNA724039 | 5663 | 291 | 1.811024 | 5.27007984 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 152 | 2.58e-32 | NTclustered | gi|2893358400|emb|OZ220691.1| | 2026742 | g5456 | i0 | 83.529 | 148.199312714777 | 170 | 21 | 57 | 6 | 1 | 165 | 2518902 | 2519069 | MAG: Gemmatimonadota bacterium isolate 1766b9ea-3269-4cc1-97f5-695b05480569 genome assembly, chromosome: 1 | blastn | 43126 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 4539643 | 4539643 | PRJNA724039_S_NODE_7344_length_247_cov_3.642857_g7137_i0 | PRJNA724039 | 7344 | 247 | 3.642857 | 8.99785679 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 220 | 5.78e-53 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g7137 | i0 | 83.265 | 188.234817813765 | 245 | 35 | 98 | 6 | 4 | 246 | 3042716 | 3042476 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 46494 | 220 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 4539654 | 4539654 | PRJNA724039_S_NODE_844_length_996_cov_18.532847_g719_i0 | PRJNA724039 | 844 | 996 | 18.532847 | 184.58715612 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 1352 | 0 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g719 | i0 | 91.44 | 145.718875502008 | 993 | 74 | 99 | 6 | 6 | 996 | 3044222 | 3043239 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 145136 | 1352 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 7089861 | 7089861 | PRJNA724039_S_NODE_1546_length_638_cov_17.008319_g719_i2 | PRJNA724039 | 1546 | 638 | 17.008319 | 108.51307522 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 863 | 0 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g719 | i2 | 91.25 | 42.5329153605016 | 640 | 47 | 99 | 8 | 3 | 638 | 3043873 | 3043239 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 27136 | 863 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 9639573 | 9639573 | PRJNA724039_S_NODE_1388_length_688_cov_16.897081_g719_i1 | PRJNA724039 | 1388 | 688 | 16.897081 | 116.25191728 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 911 | 0 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g719 | i1 | 92.178 | 35.3880813953488 | 652 | 40 | 94 | 11 | 42 | 688 | 3043884 | 3043239 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 24347 | 911 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 9639777 | 9639777 | PRJNA724039_S_NODE_8848_length_220_cov_9.289617_g8641_i0 | PRJNA724039 | 8848 | 220 | 9.289617 | 20.4371574 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 285 | 1.7599999999999998e-72 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g8641 | i0 | 90.09 | 54.45 | 222 | 18 | 100 | 4 | 1 | 220 | 3042548 | 3042329 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 11979 | 285 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 12190372 | 12190372 | PRJNA724039_S_NODE_1290_length_728_cov_13.030391_g1127_i0 | PRJNA724039 | 1290 | 728 | 13.030391 | 94.86124648 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 918 | 0 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g1127 | i0 | 89.581 | 289.167582417582 | 739 | 55 | 100 | 18 | 1 | 728 | 3043250 | 3042523 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 210514 | 918 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis |
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);;