contig_metadata
12 rows where bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1065366 | 1065366 | PRJNA315314_S_NODE_29681_length_155_cov_54.301587_g29360_i0 | PRJNA315314 | 29681 | 155 | 54.301587 | 84.16745985 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 254 | 3.25e-63 | NTclustered | gi|26801211|emb|AJ532713.1| | 34034 | g29360 | i0 | 97.315 | 96.1290322580645 | 149 | 4 | 96 | 0 | 4 | 152 | 910 | 762 | Uncultured delta proteobacterium partial 16S rRNA gene, clone JG34-KF-14 | blastn | 14900 | 254 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 4208288 | 4208288 | PRJNA315314_S_NODE_7544_length_293_cov_56.170455_g7223_i0 | PRJNA315314 | 7544 | 293 | 56.170455 | 164.57943315 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 486 | 6.2799999999999984e-133 | NTclustered | gi|375245443|gb|JQ653850.1| | 34034 | g7223 | i0 | 97.872 | 94.6825938566553 | 282 | 4 | 96 | 2 | 2 | 283 | 1 | 280 | Uncultured delta proteobacterium clone 199 16S ribosomal RNA gene, partial sequence | blastn | 27742 | 486 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 20782301 | 20782301 | PRJNA315314_S_NODE_19577_length_186_cov_187.063694_g19256_i0 | PRJNA315314 | 19577 | 186 | 187.063694 | 347.93847084 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 200 | 5.369999999999999e-47 | NTclustered | gi|2874253674|emb|OY969108.1| | 34034 | g19256 | i0 | 88.554 | 210.134408602151 | 166 | 17 | 88 | 2 | 1 | 164 | 1543951 | 1544116 | MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1 | blastn | 39085 | 200 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 21467117 | 21467117 | PRJNA315314_S_NODE_29677_length_155_cov_77.230159_g29356_i0 | PRJNA315314 | 29677 | 155 | 77.230159 | 119.70674645 | root | 1 | Root_unresolved | Root_unresolved | 137 | 3.42e-28 | NTclustered | gi|2874253659|emb|OY969087.1| | 34034 | g29356 | i0 | 83.019 | 190.296774193548 | 159 | 20 | 100 | 7 | 1 | 155 | 1501746 | 1501901 | MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1 | blastn | 29496 | 137 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 25291347 | 25291347 | PRJNA315314_S_NODE_10040_length_255_cov_504.871681_g9719_i0 | PRJNA315314 | 10040 | 255 | 504.871681 | 1287.42278655 | Pseudomonadota | 1224 | Bacteria | Bacteria | 466 | 6.98e-127 | NTclustered | gi|202950689|emb|FM206054.1| | 34034 | g9719 | i0 | 100 | 104.917647058824 | 252 | 0 | 99 | 0 | 1 | 252 | 252 | 1 | Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1 | blastn | 26754 | 466 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 27990451 | 27990451 | PRJNA315314_S_NODE_8325_length_280_cov_3.749004_g8004_i0 | PRJNA315314 | 8325 | 280 | 3.749004 | 10.4972112 | Deltaproteobacteria bacterium RIFCSPLOWO2_ | 2026735 | Bacteria | Bacteria | 164 | 4.68e-49 | NR | OGQ60211.1 | 1797882 | g8004 | i0 | 83.7 | 0.985714285714286 | 92 | 15 | 98.6 | 0 | 3 | 278 | 13 | 104 | OGQ60211.1 MAG: neutral zinc metallopeptidase [Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8] | diamond | 276 | 164 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8 | ||||||
| 29001064 | 29001064 | PRJNA315314_S_NODE_3368_length_435_cov_7.024631_g3048_i0 | PRJNA315314 | 3368 | 435 | 7.024631 | 30.55714485 | Deltaproteobacteria bacterium RIFCSPLOWO2_ | 2026735 | Bacteria | Bacteria | 223 | 6.880000000000001e-73 | NR | OGQ60210.1 | 1797882 | g3048 | i0 | 97.5 | 0.813793103448276 | 118 | 3 | 81.4 | 0 | 6 | 359 | 1 | 118 | OGQ60210.1 MAG: hypothetical protein A3J24_09855 [Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8] | diamond | 354 | 223 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8 | ||||||
| 29032510 | 29032510 | PRJNA315314_S_NODE_21048_length_180_cov_12.185430_g20727_i0 | PRJNA315314 | 21048 | 180 | 12.18543 | 21.933774 | Deltaproteobacteria bacterium RIFCSPLOWO2_ | 2026735 | Bacteria | Bacteria | 73.2 | 1.99e-15 | NR | OGQ60212.1 | 1797882 | g20727 | i0 | 92.1 | 0.633333333333333 | 38 | 3 | 63.3 | 0 | 66 | 179 | 1 | 38 | OGQ60212.1 MAG: hypothetical protein A3J24_09865 [Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8] | diamond | 114 | 73.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8 | ||||||
| 29049885 | 29049885 | PRJNA315314_S_NODE_25728_length_165_cov_3.639706_g25407_i0 | PRJNA315314 | 25728 | 165 | 3.639706 | 6.0055149 | Pseudomonadota | 1224 | Bacteria | Bacteria | 95.1 | 6.15e-22 | NR | OGQ51038.1 | 1797882 | g25407 | i0 | 83.3 | 5.85454545454545 | 54 | 9 | 98.2 | 0 | 163 | 2 | 150 | 203 | OGQ51038.1 MAG: F0F1 ATP synthase subunit gamma [Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8] | diamond | 966 | 95.9 | 0.991657977059437 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8 | ||||||
| 29680907 | 29680907 | PRJNA315314_S_NODE_15850_length_206_cov_1.915254_g15529_i0 | PRJNA315314 | 15850 | 206 | 1.915254 | 3.94542324 | root | 1 | Root_unresolved | Root_unresolved | 128 | 4.59e-35 | NR | OGQ36880.1 | 1797871 | g15529 | i0 | 82.4 | 9.90291262135922 | 68 | 12 | 99 | 0 | 1 | 204 | 45 | 112 | OGQ36880.1 MAG: NAD-dependent dehydratase, partial [Deltaproteobacteria bacterium RIFCSPLOWO2_01_FULL_42_9] | diamond | 2040 | 129 | 0.992248062015504 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_01_FULL_42_9 | ||||||
| 30105817 | 30105817 | PRJNA315314_S_NODE_17012_length_199_cov_4.364706_g16691_i0 | PRJNA315314 | 17012 | 199 | 4.364706 | 8.68576494 | Deltaproteobacteria bacterium RIFCSPLOWO2_ | 2026735 | Bacteria | Bacteria | 112 | 2.19e-29 | NR | OGQ60211.1 | 1797882 | g16691 | i0 | 87.9 | 0.994974874371859 | 66 | 8 | 99.5 | 0 | 199 | 2 | 103 | 168 | OGQ60211.1 MAG: neutral zinc metallopeptidase [Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8] | diamond | 198 | 112 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8 | ||||||
| 30200511 | 30200511 | PRJNA315314_S_NODE_27272_length_161_cov_3.030303_g26951_i0 | PRJNA315314 | 27272 | 161 | 3.030303 | 4.87878783 | Deltaproteobacteria bacterium RIFCSPLOWO2_ | 2026735 | Bacteria | Bacteria | 41.2 | 0.0226 | NR | OGQ60213.1 | 1797882 | g26951 | i0 | 66.7 | 0.503105590062112 | 27 | 9 | 50.3 | 0 | 81 | 161 | 1 | 27 | OGQ60213.1 MAG: hypothetical protein A3J24_09870 [Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8] | diamond | 81 | 41.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8 |
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);;