contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB11748" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17235 | 17235 | PRJEB11748_P_NODE_270441_length_235_cov_1.350575_g268258_i0 | PRJEB11748 | 270441 | 235 | 1.350575 | 3.17385125 | Persicimonas caeni | 2292766 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|1695542189|gb|CP041186.1| | 2292766 | g268258 | i0 | 100 | 0.246808510638298 | 29 | 0 | 12 | 0 | 36 | 64 | 1785079 | 1785107 | Persicimonas caeni strain YN101 chromosome | blastn | 58 | 54.7 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 1291046 | 1291046 | PRJEB11748_P_NODE_245282_length_250_cov_1.534392_g243099_i0 | PRJEB11748 | 245282 | 250 | 1.534392 | 3.83598 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 73.1 | 1.74e-8 | NTclustered | gi|2874253659|emb|OY969087.1| | 34034 | g243099 | i0 | 79.13 | 2.06 | 115 | 17 | 45 | 6 | 33 | 144 | 3125296 | 3125186 | MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1 | blastn | 515 | 73.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 4811604 | 4811604 | PRJEB11748_P_NODE_227464_length_262_cov_2.223881_g225281_i0 | PRJEB11748 | 227464 | 262 | 2.223881 | 5.82656822 | root | 1 | Root_unresolved | Root_unresolved | 409 | 1.23e-109 | NTclustered | gi|281324647|gb|GU236012.1| | 34034 | g225281 | i0 | 97.119 | 92.7519083969466 | 243 | 5 | 92 | 2 | 22 | 262 | 534 | 776 | Uncultured delta proteobacterium clone RLT34_02 16S ribosomal RNA gene, partial sequence | blastn | 24301 | 411 | 0.995133819951338 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 15317786 | 15317786 | PRJEB11748_P_NODE_181453_length_300_cov_10.246862_g179270_i0 | PRJEB11748 | 181453 | 300 | 10.246862 | 30.740586 | uncultured delta proteobacterium HF0010_01J10 | 710820 | Bacteria | Bacteria | 285 | 2.5299999999999996e-72 | NTclustered | gi|297180392|gb|GU474842.1| | 710820 | g179270 | i0 | 87.705 | 135.316666666667 | 244 | 30 | 81 | 0 | 23 | 266 | 12899 | 12656 | Uncultured delta proteobacterium HF0010_01J10 genomic sequence | blastn | 40595 | 285 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0010_01J10 | ||||||
| 20110619 | 20110619 | PRJEB11748_P_NODE_280516_length_229_cov_3.672619_g278333_i0 | PRJEB11748 | 280516 | 229 | 3.672619 | 8.41029751 | Bacteria | 2 | Bacteria | Bacteria | 407 | 3.7799999999999995e-109 | NTclustered | gi|430803027|gb|KC011136.1| | 34034 | g278333 | i0 | 98.69 | 100.275109170306 | 229 | 3 | 100 | 0 | 1 | 229 | 91 | 319 | Uncultured delta proteobacterium clone bsc37 16S ribosomal RNA gene, partial sequence | blastn | 22963 | 407 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 21386497 | 21386497 | PRJEB11748_P_NODE_322597_length_209_cov_3.560811_g320414_i0 | PRJEB11748 | 322597 | 209 | 3.560811 | 7.44209499 | root | 1 | Root_unresolved | Root_unresolved | 73.1 | 1.41e-8 | NTclustered | gi|58045904|gb|AY868169.1| | 34034 | g320414 | i0 | 100 | 18.6267942583732 | 39 | 0 | 19 | 0 | 150 | 188 | 313 | 275 | Uncultured delta proteobacterium clone I3K-0064 16S ribosomal RNA gene, partial sequence | blastn | 3893 | 73.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 24243850 | 24243850 | PRJEB11748_P_NODE_314140_length_213_cov_1.684211_g311957_i0 | PRJEB11748 | 314140 | 213 | 1.684211 | 3.58736943 | Bradymonas sediminis | 1548548 | Bacteria | Bacteria | 93.5 | 1.1e-14 | NTclustered | gi|1406952946|gb|CP030032.1| | 1548548 | g311957 | i0 | 82.569 | 0.7981220657277 | 109 | 15 | 50 | 4 | 63 | 169 | 1769039 | 1769145 | Bradymonas sediminis strain FA350 chromosome, complete genome | blastn | 170 | 93.5 | 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);;