contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1237347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4172163 | 4172163 | PRJNA1237347_P_NODE_536924_length_243_cov_0.905882_g530351_i0 | PRJNA1237347 | 536924 | 243 | 0.905882 | 2.20129326 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 219 | 2.0399999999999998e-52 | NTclustered | gi|2874254016|emb|OY970341.1| | 34034 | g530351 | i0 | 84.615 | 3.11111111111111 | 221 | 32 | 91 | 2 | 23 | 242 | 236397 | 236616 | MAG: uncultured delta proteobacterium isolate MFD01231.bin.c.2 genome assembly, chromosome: 1 | blastn | 756 | 219 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 4173230 | 4173230 | PRJNA1237347_P_NODE_77244_length_804_cov_3.708618_g71210_i0 | PRJNA1237347 | 77244 | 804 | 3.708618 | 29.81728872 | Microvenator marinus | 2600177 | Bacteria | Bacteria | 841 | 0 | NTclustered | gi|1722470586|gb|CP042467.1| | 2600177 | g71210 | i0 | 86.111 | 202.725124378109 | 792 | 96 | 98 | 13 | 1 | 785 | 703812 | 703028 | Microvenator marinus strain V1718 chromosome, complete genome | blastn | 162991 | 841 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Microvenatoraceae | Microvenator | Microvenator marinus | |||
| 6150455 | 6150455 | PRJNA1237347_P_NODE_193585_length_443_cov_1.613514_g187013_i0 | PRJNA1237347 | 193585 | 443 | 1.613514 | 7.14786702 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 383 | 1.3399999999999998e-101 | NTclustered | gi|1722470586|gb|CP042467.1| | 2600177 | g187013 | i0 | 82.483 | 188.79006772009 | 451 | 66 | 100 | 13 | 1 | 443 | 702476 | 702031 | Microvenator marinus strain V1718 chromosome, complete genome | blastn | 83634 | 383 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Microvenatoraceae | Microvenator | Microvenator marinus | |||
| 6723929 | 6723929 | PRJNA1237347_P_NODE_77526_length_802_cov_4.746228_g71480_i0 | PRJNA1237347 | 77526 | 802 | 4.746228 | 38.06474856 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 957 | 0 | NTclustered | gi|374854163|dbj|AP011765.1| | 34034 | g71480 | i0 | 88.323 | 152.931421446384 | 805 | 85 | 100 | 8 | 1 | 802 | 13467 | 12669 | Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 | blastn | 122651 | 957 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 7993850 | 7993850 | PRJNA1237347_P_NODE_295487_length_337_cov_1.583333_g288914_i0 | PRJNA1237347 | 295487 | 337 | 1.583333 | 5.33583221 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 518 | 2.6099999999999998e-142 | NTclustered | gi|451917584|gb|KC451448.1| | 34034 | g288914 | i0 | 95.122 | 96.2017804154303 | 328 | 16 | 97 | 0 | 10 | 337 | 1 | 328 | Uncultured delta proteobacterium clone RLBp5787 16S ribosomal RNA gene, partial sequence | blastn | 32420 | 518 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 11816321 | 11816321 | PRJNA1237347_P_NODE_161570_length_499_cov_1.561033_g155009_i0 | PRJNA1237347 | 161570 | 499 | 1.561033 | 7.78955467 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 52.8 | 0.049 | NTclustered | gi|2874253888|emb|OY970063.1| | 34034 | g155009 | i0 | 100 | 0.0561122244488978 | 28 | 0 | 6 | 0 | 210 | 237 | 1130402 | 1130375 | MAG: uncultured delta proteobacterium isolate MFD10007.bin.1.119 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 13091309 | 13091309 | PRJNA1237347_P_NODE_159751_length_502_cov_12.100233_g153190_i0 | PRJNA1237347 | 159751 | 502 | 12.100233 | 60.74316966 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 789 | 0 | NTclustered | gi|374854163|dbj|AP011765.1| | 34034 | g153190 | i0 | 95.02 | 173.5 | 502 | 25 | 100 | 0 | 1 | 502 | 14653 | 14152 | Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 | blastn | 87097 | 789 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 18191989 | 18191989 | PRJNA1237347_P_NODE_296055_length_337_cov_1.090909_g289482_i0 | PRJNA1237347 | 296055 | 337 | 1.090909 | 3.67636333 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 222 | 2.29e-53 | NTclustered | gi|374854163|dbj|AP011765.1| | 34034 | g289482 | i0 | 79.612 | 9.19881305637982 | 309 | 63 | 92 | 0 | 8 | 316 | 3168 | 3476 | Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 | blastn | 3100 | 222 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 20747035 | 20747035 | PRJNA1237347_P_NODE_567677_length_219_cov_5.452055_g561103_i0 | PRJNA1237347 | 567677 | 219 | 5.452055 | 11.94000045 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 93.5 | 1.14e-14 | NTclustered | gi|2874253659|emb|OY969087.1| | 34034 | g561103 | i0 | 86.747 | 15.6712328767123 | 83 | 11 | 38 | 0 | 46 | 128 | 3055992 | 3055910 | MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1 | blastn | 3432 | 93.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 23293488 | 23293488 | PRJNA1237347_P_NODE_327999_length_316_cov_1.259259_g321426_i0 | PRJNA1237347 | 327999 | 316 | 1.259259 | 3.97925844 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 383 | 9.24e-102 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g321426 | i0 | 88.608 | 156.401898734177 | 316 | 34 | 99 | 2 | 2 | 316 | 82812 | 83126 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 49423 | 383 | 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);;