contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA407368" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7459678 | 7459678 | PRJNA407368_S_NODE_8726_length_171_cov_2356.049296_g8624_i0 | PRJNA407368 | 8726 | 171 | 2356.049296 | 4028.84429616 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 300 | 4.63e-77 | NTclustered | gi|343206979|gb|JN371756.1| | 34034 | g8624 | i0 | 98.246 | 100.023391812865 | 171 | 3 | 100 | 0 | 1 | 171 | 370 | 200 | Uncultured delta proteobacterium clone B12-54 16S ribosomal RNA gene, partial sequence | blastn | 17104 | 300 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 12560394 | 12560394 | PRJNA407368_S_NODE_5030_length_247_cov_2426.334862_g4928_i0 | PRJNA407368 | 5030 | 247 | 2426.334862 | 5993.04710914 | Bacteria | 2 | Bacteria | Bacteria | 457 | 4.05e-124 | NTclustered | gi|202950689|emb|FM206054.1| | 34034 | g4928 | i0 | 100 | 99.9838056680162 | 247 | 0 | 100 | 0 | 1 | 247 | 13 | 259 | Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1 | blastn | 24696 | 457 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 15109416 | 15109416 | PRJNA407368_S_NODE_1112_length_598_cov_17.231986_g1035_i0 | PRJNA407368 | 1112 | 598 | 17.231986 | 103.04727628 | Bacteria | 2 | Bacteria | Bacteria | 549 | 1.7199999999999993e-151 | NTclustered | gi|374854163|dbj|AP011765.1| | 34034 | g1035 | i0 | 83.416 | 124.464882943144 | 603 | 88 | 100 | 11 | 1 | 598 | 13824 | 13229 | Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 | blastn | 74430 | 551 | 0.996370235934664 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 17659248 | 17659248 | PRJNA407368_S_NODE_3054_length_339_cov_34.032258_g2952_i0 | PRJNA407368 | 3054 | 339 | 34.032258 | 115.36935462 | Aetherobacter | 888829 | Bacteria | Bacteria | 453 | 7.51e-123 | NTclustered | gi|146428836|gb|EF219652.1| | 34034 | g2952 | i0 | 92.744 | 98.8230088495575 | 317 | 17 | 93 | 5 | 1 | 315 | 313 | 1 | Uncultured delta proteobacterium clone AI-1M_A12 16S ribosomal RNA gene, partial sequence | blastn | 33501 | 453 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium |
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);;