contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA493632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3019626 | 3019626 | PRJNA493632_P_NODE_721643_length_208_cov_110.844444_g718201_i0 | PRJNA493632 | 721643 | 208 | 110.844444 | 230.55644352 | Persicimonas caeni | 2292766 | Bacteria | Bacteria | 154 | 4.85e-33 | NTclustered | gi|1695542189|gb|CP041186.1| | 2292766 | g718201 | i0 | 82.857 | 89.1346153846154 | 175 | 26 | 83 | 3 | 1 | 173 | 6456136 | 6455964 | Persicimonas caeni strain YN101 chromosome | blastn | 18540 | 154 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 6846100 | 6846100 | PRJNA493632_P_NODE_704646_length_226_cov_2.013072_g701205_i0 | PRJNA493632 | 704646 | 226 | 2.013072 | 4.54954272 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 401 | 1.7299999999999993e-107 | NTclustered | gi|430803059|gb|KC011168.1| | 34034 | g701205 | i0 | 98.673 | 98.4380530973451 | 226 | 3 | 100 | 0 | 1 | 226 | 457 | 682 | Uncultured delta proteobacterium clone bsc69 16S ribosomal RNA gene, partial sequence | blastn | 22247 | 401 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 11937567 | 11937567 | PRJNA493632_P_NODE_163330_length_373_cov_17.470000_g159905_i0 | PRJNA493632 | 163330 | 373 | 17.47 | 65.1631 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 628 | 1.2899999999999998e-175 | NTclustered | gi|1597772012|gb|MK682782.1| | 34034 | g159905 | i0 | 97.051 | 96.887399463807 | 373 | 11 | 100 | 0 | 1 | 373 | 5 | 377 | Uncultured delta proteobacterium clone 13 16S ribosomal RNA gene, partial sequence | blastn | 36139 | 628 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 22136964 | 22136964 | PRJNA493632_P_NODE_258858_length_310_cov_6.388186_g255422_i0 | PRJNA493632 | 258858 | 310 | 6.388186 | 19.8033766 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 95.3 | 4.74e-15 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g255422 | i0 | 92.537 | 96.4064516129032 | 67 | 4 | 32 | 1 | 5 | 70 | 83878 | 83944 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 29886 | 95.3 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 23418640 | 23418640 | PRJNA493632_P_NODE_573939_length_246_cov_10.173410_g570498_i0 | PRJNA493632 | 573939 | 246 | 10.17341 | 25.0265886 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 392 | 1.15e-104 | NTclustered | gi|927354504|gb|KT323038.1| | 34034 | g570498 | i0 | 95.528 | 100.463414634146 | 246 | 10 | 99 | 1 | 1 | 245 | 92 | 337 | Uncultured delta proteobacterium clone TGR_WLFZ-858 16S ribosomal RNA gene, partial sequence | blastn | 24714 | 392 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 24053314 | 24053314 | PRJNA493632_P_NODE_2439_length_1979_cov_15.026233_g1731_i0 | PRJNA493632 | 2439 | 1979 | 15.026233 | 297.36915107 | Bacteria | 2 | Bacteria | Bacteria | 566 | 5.9e-156 | NTclustered | gi|2874253888|emb|OY970063.1| | 34034 | g1731 | i0 | 74.964 | 149.947448206165 | 1370 | 274 | 68 | 57 | 454 | 1797 | 628052 | 629378 | MAG: uncultured delta proteobacterium isolate MFD10007.bin.1.119 genome assembly, chromosome: 1 | blastn | 296746 | 569 | 0.994727592267135 | 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);;