contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA792582" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 776895 | 776895 | PRJNA792582_P_NODE_35901_length_288_cov_2.548837_g35087_i0 | PRJNA792582 | 35901 | 288 | 2.548837 | 7.34065056 | uncultured delta proteobacterium HF0070_10I02 | 710824 | Bacteria | Bacteria | 211 | 4.1500000000000002e-50 | NTclustered | gi|297181000|gb|GU474857.1| | 710824 | g35087 | i0 | 82.213 | 294.048611111111 | 253 | 38 | 87 | 4 | 37 | 287 | 6428 | 6181 | Uncultured delta proteobacterium HF0070_10I02 genomic sequence | blastn | 84686 | 211 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0070_10I02 | ||||||
| 7155274 | 7155274 | PRJNA792582_P_NODE_2906_length_946_cov_1.939290_g2326_i0 | PRJNA792582 | 2906 | 946 | 1.93929 | 18.3456834 | uncultured delta proteobacterium HF0070_10I02 | 710824 | Bacteria | Bacteria | 710 | 0 | NTclustered | gi|297181000|gb|GU474857.1| | 710824 | g2326 | i0 | 80.781 | 252.305496828753 | 947 | 149 | 98 | 29 | 18 | 946 | 7196 | 8127 | Uncultured delta proteobacterium HF0070_10I02 genomic sequence | blastn | 238681 | 710 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0070_10I02 | ||||||
| 8430166 | 8430166 | PRJNA792582_P_NODE_44067_length_266_cov_4.777202_g43253_i0 | PRJNA792582 | 44067 | 266 | 4.777202 | 12.70735732 | uncultured delta proteobacterium HF0070_10I02 | 710824 | Bacteria | Bacteria | 300 | 7.87e-77 | NTclustered | gi|297181000|gb|GU474857.1| | 710824 | g43253 | i0 | 87.597 | 258.067669172932 | 258 | 32 | 97 | 0 | 9 | 266 | 9088 | 8831 | Uncultured delta proteobacterium HF0070_10I02 genomic sequence | blastn | 68646 | 300 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0070_10I02 | ||||||
| 9705407 | 9705407 | PRJNA792582_P_NODE_52788_length_248_cov_0.880000_g51974_i0 | PRJNA792582 | 52788 | 248 | 0.88 | 2.1824 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 224 | 4.489999999999999e-54 | NTclustered | gi|374854163|dbj|AP011765.1| | 34034 | g51974 | i0 | 83.607 | 187.947580645161 | 244 | 35 | 98 | 4 | 7 | 248 | 15063 | 14823 | Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 | blastn | 46611 | 224 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 12256483 | 12256483 | PRJNA792582_P_NODE_3230_length_901_cov_5.836957_g2616_i0 | PRJNA792582 | 3230 | 901 | 5.836957 | 52.59098257 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 859 | 0 | NTclustered | gi|374854163|dbj|AP011765.1| | 34034 | g2616 | i0 | 84.066 | 139.945615982242 | 910 | 126 | 100 | 15 | 1 | 901 | 13080 | 13979 | Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 | blastn | 126091 | 859 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 12256817 | 12256817 | PRJNA792582_P_NODE_8010_length_595_cov_1.264368_g7216_i0 | PRJNA792582 | 8010 | 595 | 1.264368 | 7.5229896 | Microvenator marinus | 2600177 | Bacteria | Bacteria | 558 | 2.84e-154 | NTclustered | gi|1722470586|gb|CP042467.1| | 2600177 | g7216 | i0 | 85.958 | 184.536134453782 | 527 | 68 | 88 | 5 | 3 | 526 | 703602 | 703079 | Microvenator marinus strain V1718 chromosome, complete genome | blastn | 109799 | 558 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Microvenatoraceae | Microvenator | Microvenator marinus | |||
| 25003668 | 25003668 | PRJNA792582_P_NODE_59080_length_241_cov_1.375000_g58266_i0 | PRJNA792582 | 59080 | 241 | 1.375 | 3.31375 | uncultured delta proteobacterium HF0200_19J16 | 710831 | Bacteria | Bacteria | 89.8 | 1.65e-13 | NTclustered | gi|297181813|gb|GU474879.1| | 710831 | g58266 | i0 | 84.615 | 0.75103734439834 | 91 | 12 | 37 | 2 | 2 | 91 | 15878 | 15967 | Uncultured delta proteobacterium HF0200_19J16 genomic sequence | blastn | 181 | 89.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0200_19J16 |
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);;