contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA630162" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1877890 | 1877890 | PRJNA630162_P_NODE_147102_length_165_cov_1.387931_g145579_i0 | PRJNA630162 | 147102 | 165 | 1.387931 | 2.29008615 | Deltaproteobacteria bacterium RIFCSPHIGHO2_ | 2026735 | Bacteria | Bacteria | 94.7 | 9.3e-22 | NR | OGQ04046.1 | 1797856 | g145579 | i0 | 81.5 | 2.92727272727273 | 54 | 10 | 98.2 | 0 | 1 | 162 | 135 | 188 | OGQ04046.1 MAG: protoheme IX farnesyltransferase [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49] | diamond | 483 | 94.7 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49 | ||||||
| 27428715 | 27428715 | PRJNA630162_P_NODE_87603_length_193_cov_4.298611_g86080_i0 | PRJNA630162 | 87603 | 193 | 4.298611 | 8.29631923 | Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_44_9 | 1973965 | Bacteria | Bacteria | 80.5 | 4.97e-18 | NR | PJB41914.1 | 1973965 | g86080 | i0 | 75.5 | 2.44041450777202 | 53 | 12 | 80.8 | 1 | 37 | 192 | 20 | 72 | PJB41914.1 MAG: hypothetical protein CO106_06590, partial [Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_44_9] | diamond | 471 | 80.5 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_44_9 | ||||||
| 27757042 | 27757042 | PRJNA630162_P_NODE_132004_length_169_cov_0.866667_g130481_i0 | PRJNA630162 | 132004 | 169 | 0.866667 | 1.46466723 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 62 | 2.23e-9 | NR | PKN36610.1 | 2013747 | g130481 | i0 | 67.5 | 2.1301775147929 | 40 | 13 | 71 | 0 | 166 | 47 | 2426 | 2465 | PKN36610.1 MAG: hypothetical protein CVU62_13915 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-2] | diamond | 360 | 62 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-2 | ||||||
| 28154702 | 28154702 | PRJNA630162_P_NODE_122505_length_173_cov_1.604839_g120982_i0 | PRJNA630162 | 122505 | 173 | 1.604839 | 2.77637147 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 47.8 | 2.38e-4 | NR | NMC62837.1 | 2024889 | g120982 | i0 | 46.8 | 0.815028901734104 | 47 | 25 | 81.5 | 0 | 171 | 31 | 108 | 154 | NMC62837.1 hypothetical protein [SAR324 cluster bacterium] | diamond | 141 | 47.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 28217342 | 28217342 | PRJNA630162_P_NODE_105686_length_182_cov_1.736842_g104163_i0 | PRJNA630162 | 105686 | 182 | 1.736842 | 3.16105244 | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | 1797895 | Bacteria | Bacteria | 45.1 | 0.00255 | NR | OGQ90120.1 | 1797895 | g104163 | i0 | 43.9 | 0.675824175824176 | 41 | 23 | 67.6 | 0 | 1 | 123 | 52 | 92 | OGQ90120.1 MAG: hypothetical protein A2289_03855 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15] | diamond | 123 | 45.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15 | ||||||
| 29543763 | 29543763 | PRJNA630162_P_NODE_60490_length_227_cov_1.556180_g58967_i0 | PRJNA630162 | 60490 | 227 | 1.55618 | 3.5325286 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 56.2 | 3.26e-7 | NR | NMC62025.1 | 2024889 | g58967 | i0 | 67.6 | 1.28193832599119 | 34 | 11 | 44.9 | 0 | 217 | 116 | 93 | 126 | NMC62025.1 hypothetical protein [SAR324 cluster bacterium] | diamond | 291 | 56.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 29764567 | 29764567 | PRJNA630162_P_NODE_112251_length_178_cov_2.635659_g110728_i0 | PRJNA630162 | 112251 | 178 | 2.635659 | 4.69147302 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 42 | 0.0283 | NR | MEC7217655.1 | 2024889 | g110728 | i0 | 32.8 | 0.97752808988764 | 58 | 39 | 97.8 | 0 | 176 | 3 | 251 | 308 | MEC7217655.1 glycosyltransferase family 1 protein [SAR324 cluster bacterium] | diamond | 174 | 42 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 30933994 | 30933994 | PRJNA630162_P_NODE_98674_length_186_cov_2.364964_g97151_i0 | PRJNA630162 | 98674 | 186 | 2.364964 | 4.39883304 | uncultured delta proteobacterium HF | 34034 | Bacteria | Bacteria | 46.6 | 4.1e-4 | NR | ADI19064.1 | 710825 | g97151 | i0 | 43.3 | 0.967741935483871 | 60 | 31 | 96.8 | 1 | 1 | 180 | 93 | 149 | ADI19064.1 hypothetical protein [uncultured delta proteobacterium HF0070_15B21] | diamond | 180 | 46.6 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0070_15B21 | ||||||
| 31629337 | 31629337 | PRJNA630162_P_NODE_145276_length_165_cov_4.146552_g143753_i0 | PRJNA630162 | 145276 | 165 | 4.146552 | 6.8418108 | uncultured delta proteobacterium HF4 | 34034 | Bacteria | Bacteria | 45.1 | 5.23e-4 | NR | ADI18411.1 | 710836 | g143753 | i0 | 62.5 | 0.727272727272727 | 40 | 10 | 63.6 | 1 | 6 | 110 | 27 | 66 | ADI18411.1 hypothetical protein [uncultured delta proteobacterium HF4000_08N17] | diamond | 120 | 45.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF4000_08N17 | ||||||
| 32685432 | 32685432 | PRJNA630162_P_NODE_88300_length_193_cov_1.756944_g86777_i0 | PRJNA630162 | 88300 | 193 | 1.756944 | 3.39090192 | Bacteria | 2 | Bacteria | Bacteria | 45.4 | 0.00132 | NR | ADI17622.1 | 710828 | g86777 | i0 | 67.6 | 1.9740932642487 | 34 | 11 | 52.8 | 0 | 190 | 89 | 86 | 119 | ADI17622.1 hypothetical protein [uncultured delta proteobacterium HF0130_19C20] | diamond | 381 | 45.8 | 0.991266375545852 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium HF0130_19C20 |
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);;