contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax_clade = "delta/epsilon subdivisions"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1226471 | 1226471 | PRJNA814235_P_NODE_184481_length_151_cov_4.114035_g183086_i0 | PRJNA814235 | 184481 | 151 | 4.114035 | 6.21219285 | Bacillota | 1239 | Bacteria | Bacteria | 111 | 2e-20 | NTclustered | gi|2874253674|emb|OY969108.1| | 34034 | g183086 | i0 | 81.579 | 184.523178807947 | 152 | 13 | 91 | 4 | 4 | 141 | 1541568 | 1541718 | MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1 | blastn | 27863 | 111 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 2093689 | 2093689 | PRJNA814235_P_NODE_58302_length_249_cov_2.632075_g56908_i0 | PRJNA814235 | 58302 | 249 | 2.632075 | 6.55386675 | Persicimonas caeni | 2292766 | Bacteria | Bacteria | 169 | 2.1399999999999996e-37 | NTclustered | gi|1695542189|gb|CP041186.1| | 2292766 | g56908 | i0 | 79.253 | 3.92369477911647 | 241 | 38 | 95 | 9 | 1 | 237 | 7928360 | 7928592 | Persicimonas caeni strain YN101 chromosome | blastn | 977 | 169 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 3367003 | 3367003 | PRJNA814235_P_NODE_15303_length_487_cov_40.164444_g14001_i0 | PRJNA814235 | 15303 | 487 | 40.164444 | 195.60084228 | uncultured delta proteobacterium HF0010_01J10 | 710820 | Bacteria | Bacteria | 414 | 5.26e-111 | NTclustered | gi|297180392|gb|GU474842.1| | 710820 | g14001 | i0 | 82.258 | 139.989733059548 | 496 | 72 | 100 | 13 | 1 | 487 | 14390 | 14878 | Uncultured delta proteobacterium HF0010_01J10 genomic sequence | blastn | 68175 | 414 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0010_01J10 | ||||||
| 3367954 | 3367954 | PRJNA814235_P_NODE_195843_length_151_cov_1.000000_g194448_i0 | PRJNA814235 | 195843 | 151 | 1 | 1.51 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 237 | 3.17e-58 | NTclustered | gi|927353694|gb|KT322228.1| | 34034 | g194448 | i0 | 94.805 | 73.6225165562914 | 154 | 5 | 100 | 1 | 1 | 151 | 178 | 25 | Uncultured delta proteobacterium clone TGR_WLFZ-48 16S ribosomal RNA gene, partial sequence | blastn | 11117 | 237 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 9745499 | 9745499 | PRJNA814235_P_NODE_33648_length_329_cov_4.452055_g32260_i0 | PRJNA814235 | 33648 | 329 | 4.452055 | 14.64726095 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 544 | 4.1899999999999996e-150 | NTclustered | gi|339646456|gb|JN038845.1| | 34034 | g32260 | i0 | 96.636 | 99.0182370820669 | 327 | 11 | 99 | 0 | 1 | 327 | 1 | 327 | Uncultured delta proteobacterium clone P-R58 16S ribosomal RNA gene, partial sequence | blastn | 32577 | 544 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 23769653 | 23769653 | PRJNA814235_P_NODE_202319_length_150_cov_1.716814_g200924_i0 | PRJNA814235 | 202319 | 150 | 1.716814 | 2.575221 | Bradymonas sediminis | 1548548 | Bacteria | Bacteria | 132 | 1.53e-26 | NTclustered | gi|1406952946|gb|CP030032.1| | 1548548 | g200924 | i0 | 90.099 | 3.62 | 101 | 10 | 67 | 0 | 1 | 101 | 3700264 | 3700364 | Bradymonas sediminis strain FA350 chromosome, complete genome | blastn | 543 | 132 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Bradymonas | Bradymonas sediminis |
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);;