contig_metadata
8 rows where bioproject = "PRJNA1061474" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179078 | 179078 | PRJNA1061474_P_NODE_55581_length_243_cov_0.905882_g55335_i0 | PRJNA1061474 | 55581 | 243 | 0.905882 | 2.20129326 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 228 | 3.389999999999999e-55 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g55335 | i0 | 83.607 | 1.14814814814815 | 244 | 38 | 100 | 2 | 1 | 243 | 1576490 | 1576732 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 279 | 228 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 12932518 | 12932518 | PRJNA1061474_P_NODE_46691_length_250_cov_0.870056_g46445_i0 | PRJNA1061474 | 46691 | 250 | 0.870056 | 2.17514 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 198 | 2.75e-46 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g46445 | i0 | 83.256 | 15.68 | 215 | 36 | 86 | 0 | 6 | 220 | 2789366 | 2789152 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 3920 | 198 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 14207550 | 14207550 | PRJNA1061474_P_NODE_47872_length_249_cov_0.875000_g47626_i0 | PRJNA1061474 | 47872 | 249 | 0.875 | 2.17875 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 180 | 9.91e-41 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g47626 | i0 | 80.335 | 4.57429718875502 | 239 | 45 | 96 | 2 | 1 | 238 | 2280744 | 2280981 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 1139 | 180 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 26932326 | 26932326 | PRJNA1061474_P_NODE_46822_length_250_cov_0.870056_g46576_i0 | PRJNA1061474 | 46822 | 250 | 0.870056 | 2.17514 | Myxococcota | 2818505 | Bacteria | Bacteria | 148 | 8.559999999999998e-41 | NR | OGP47982.1 | 1797823 | g46576 | i0 | 87.8 | 4.92 | 82 | 10 | 98.4 | 0 | 3 | 248 | 82 | 163 | OGP47982.1 MAG: pyruvate synthase [Deltaproteobacteria bacterium GWD2_55_8] | diamond | 1230 | 148 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium GWD2_55_8 | ||||||
| 27469761 | 27469761 | PRJNA1061474_P_NODE_47423_length_250_cov_0.870056_g47177_i0 | PRJNA1061474 | 47423 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 116 | 3.88e-28 | NR | OGQ78446.1 | 1797894 | g47177 | i0 | 67.5 | 1.992 | 83 | 25 | 97.2 | 1 | 3 | 245 | 73 | 155 | OGQ78446.1 MAG: hypothetical protein A3F90_04875 [Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19] | diamond | 498 | 116 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19 | ||||||
| 28258837 | 28258837 | PRJNA1061474_P_NODE_49286_length_248_cov_0.880000_g49040_i0 | PRJNA1061474 | 49286 | 248 | 0.88 | 2.1824 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 124 | 4.53e-33 | NR | OGP70583.1 | 1797832 | g49040 | i0 | 73.2 | 2.9758064516129 | 82 | 22 | 99.2 | 0 | 1 | 246 | 102 | 183 | OGP70583.1 MAG: pyridoxine 5'-phosphate synthase [Deltaproteobacteria bacterium RBG_13_58_19] | diamond | 738 | 124 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_13_58_19 | ||||||
| 30532734 | 30532734 | PRJNA1061474_P_NODE_47973_length_249_cov_0.875000_g47727_i0 | PRJNA1061474 | 47973 | 249 | 0.875 | 2.17875 | Myxococcota | 2818505 | Bacteria | Bacteria | 89.4 | 1.56e-18 | NR | OGQ13796.1 | 1797850 | g47727 | i0 | 75 | 1.89156626506024 | 52 | 13 | 62.7 | 0 | 247 | 92 | 647 | 698 | OGQ13796.1 MAG: hypothetical protein A2026_10100 [Deltaproteobacteria bacterium RBG_19FT_COMBO_46_12] | diamond | 471 | 90.1 | 0.992230854605993 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_19FT_COMBO_46_12 | ||||||
| 31299374 | 31299374 | PRJNA1061474_P_NODE_57235_length_241_cov_0.916667_g56989_i0 | PRJNA1061474 | 57235 | 241 | 0.916667 | 2.20916747 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 135 | 8.35e-36 | NR | MFI5399532.1 | 2024889 | g56989 | i0 | 83.8 | 0.995850622406639 | 80 | 13 | 99.6 | 0 | 241 | 2 | 226 | 305 | MFI5399532.1 diaminopimelate decarboxylase [SAR324 cluster bacterium] | diamond | 240 | 135 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium |
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);;