contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA379145" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11277251 | 11277251 | PRJNA379145_P_NODE_54669_length_210_cov_1.824859_g52515_i0 | PRJNA379145 | 54669 | 210 | 1.824859 | 3.8322039 | delta/epsilon subdivisions | 68525 | Bacteria | Bacteria | 104 | 3.59e-24 | NR | OIP40594.1 | 1805126 | g52515 | i0 | 62.7 | 36.3857142857143 | 67 | 25 | 95.7 | 0 | 8 | 208 | 370 | 436 | OIP40594.1 MAG: 2-oxoglutarate dehydrogenase E1 component [Deltaproteobacteria bacterium CG2_30_63_29] | diamond | 7641 | 104 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG2_30_63_29 | ||||||
| 22077671 | 22077671 | PRJNA379145_P_NODE_718_length_2663_cov_8.373004_g598_i0 | PRJNA379145 | 718 | 2663 | 8.373004 | 222.97309652 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 965 | 0 | NR | MBF0287513.1 | 2024889 | g598 | i0 | 57 | 1.84866691701089 | 823 | 352 | 92.6 | 2 | 2532 | 67 | 4 | 825 | MBF0287513.1 glycogen/starch/alpha-glucan phosphorylase [SAR324 cluster bacterium] | diamond | 4923 | 965 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 24626909 | 24626909 | PRJNA379145_P_NODE_20220_length_590_cov_8.922801_g18346_i0 | PRJNA379145 | 20220 | 590 | 8.922801 | 52.6445259 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 188 | 5.72e-57 | NR | MBF0289824.1 | 2024889 | g18346 | i0 | 52.6 | 4.89152542372881 | 192 | 82 | 97.6 | 3 | 585 | 10 | 1 | 183 | MBF0289824.1 riboflavin synthase subunit alpha [SAR324 cluster bacterium] | diamond | 2886 | 188 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 26631835 | 26631835 | PRJNA379145_P_NODE_6741_length_1173_cov_2.352632_g5922_i1 | PRJNA379145 | 6741 | 1173 | 2.352632 | 27.59637336 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 303 | 1.0599999999999999e-95 | NR | MBF0350779.1 | 2024889 | g5922 | i1 | 45.4 | 5.9923273657289 | 335 | 179 | 85.2 | 3 | 1122 | 124 | 97 | 429 | MBF0350779.1 threonine synthase [SAR324 cluster bacterium] | diamond | 7029 | 303 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 27534410 | 27534410 | PRJNA379145_P_NODE_4703_length_1370_cov_7.054600_g4121_i0 | PRJNA379145 | 4703 | 1370 | 7.0546 | 96.64802 | Bradymonadales | 1779134 | Bacteria | Bacteria | 540 | 2.7199999999999998e-188 | NR | WP_141197284.1 | 2292766 | g4121 | i0 | 64.6 | 3.57591240875912 | 407 | 135 | 89.1 | 2 | 138 | 1358 | 7 | 404 | WP_141197284.1 M20/M25/M40 family metallo-hydrolase [Persicimonas caeni] | diamond | 4899 | 541 | 0.99815157116451 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni | |||
| 27565815 | 27565815 | PRJNA379145_P_NODE_9384_length_988_cov_2.385340_g8288_i0 | PRJNA379145 | 9384 | 988 | 2.38534 | 23.5671592 | Bdellovibrionota | 3018035 | Bacteria | Bacteria | 139 | 7.91e-34 | NR | MDX2470420.1 | 2024889 | g8288 | i0 | 56.6 | 1.63056680161943 | 129 | 54 | 38.6 | 1 | 383 | 3 | 298 | 426 | MDX2470420.1 cyclic nucleotide-binding domain-containing protein [SAR324 cluster bacterium] | diamond | 1611 | 139 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 28306679 | 28306679 | PRJNA379145_P_NODE_37106_length_330_cov_1.622896_g34956_i0 | PRJNA379145 | 37106 | 330 | 1.622896 | 5.3555568 | Lujinxingia sediminis | 2480984 | Bacteria | Bacteria | 94.4 | 7.91e-20 | NR | WP_127780369.1 | 2480984 | g34956 | i0 | 46 | 6.16363636363636 | 100 | 54 | 90.9 | 0 | 14 | 313 | 93 | 192 | WP_127780369.1 3-hydroxyacyl-CoA dehydrogenase NAD-binding domain-containing protein [Lujinxingia sediminis] | diamond | 2034 | 94.4 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Lujinxingiaceae | Lujinxingia | Lujinxingia sediminis | |||
| 28401379 | 28401379 | PRJNA379145_P_NODE_30926_length_403_cov_2.737838_g28799_i0 | PRJNA379145 | 30926 | 403 | 2.737838 | 11.03348714 | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-7 | 2013757 | Bacteria | Bacteria | 120 | 1.32e-30 | NR | PKN10507.1 | 2013757 | g28799 | i0 | 52.5 | 1.77915632754342 | 118 | 50 | 84.9 | 5 | 402 | 61 | 123 | 238 | PKN10507.1 MAG: hypothetical protein CVU72_00980 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-7] | diamond | 717 | 120 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-7 | ||||||
| 29144970 | 29144970 | PRJNA379145_P_NODE_27189_length_458_cov_3.134118_g25120_i0 | PRJNA379145 | 27189 | 458 | 3.134118 | 14.35426044 | Bdellovibrionota | 3018035 | Bacteria | Bacteria | 107 | 2.9199999999999998e-24 | NR | MDX2470420.1 | 2024889 | g25120 | i0 | 56.7 | 2.11572052401747 | 104 | 43 | 66.8 | 1 | 306 | 1 | 298 | 401 | MDX2470420.1 cyclic nucleotide-binding domain-containing protein [SAR324 cluster bacterium] | diamond | 969 | 108 | 0.990740740740741 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 29681061 | 29681061 | PRJNA379145_P_NODE_11250_length_889_cov_2.325935_g9970_i0 | PRJNA379145 | 11250 | 889 | 2.325935 | 20.67756215 | Myxococcota | 2818505 | Bacteria | Bacteria | 285 | 2.87e-92 | NR | PKN64178.1 | 2013742 | g9970 | i0 | 63.4 | 7.83914510686164 | 232 | 73 | 74.6 | 3 | 58 | 720 | 14 | 244 | PKN64178.1 MAG: enoyl-CoA hydratase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-15] | diamond | 6969 | 287 | 0.993031358885017 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-15 | ||||||
| 29965700 | 29965700 | PRJNA379145_P_NODE_10231_length_940_cov_2.012128_g9062_i0 | PRJNA379145 | 10231 | 940 | 2.012128 | 18.9140032 | Thermodesulfobacteriota | 200940 | Bacteria | Bacteria | 255 | 3.05e-79 | NR | CAB1059390.1 | 698986 | g9062 | i0 | 45.3 | 6.89042553191489 | 307 | 159 | 95.7 | 5 | 40 | 939 | 47 | 351 | CAB1059390.1 low-specificity D-threonine aldolase [Olavius sp. associated proteobacterium Delta 1] | diamond | 6477 | 255 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Olavius sp. associated proteobacterium Delta 1 | ||||||
| 30502783 | 30502783 | PRJNA379145_P_NODE_25333_length_490_cov_1.724289_g23298_i0 | PRJNA379145 | 25333 | 490 | 1.724289 | 8.4490161 | Myxococcota | 2818505 | Bacteria | Bacteria | 126 | 2.76e-33 | NR | MCS5552965.1 | 2024889 | g23298 | i0 | 47.7 | 4.9469387755102 | 130 | 62 | 79.6 | 1 | 448 | 59 | 19 | 142 | MCS5552965.1 CoA pyrophosphatase [SAR324 cluster bacterium] | diamond | 2424 | 127 | 0.992125984251969 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 32855940 | 32855940 | PRJNA379145_P_NODE_17920_length_646_cov_31.923328_g16146_i0 | PRJNA379145 | 17920 | 646 | 31.923328 | 206.22469888 | Persicimonas caeni | 2292766 | Bacteria | Bacteria | 185 | 2.849999999999999e-55 | NR | WP_141200113.1 | 2292766 | g16146 | i0 | 53.7 | 0.882352941176471 | 190 | 78 | 88.2 | 4 | 20 | 589 | 1 | 180 | WP_141200113.1 cupin domain-containing protein [Persicimonas caeni] | diamond | 570 | 185 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas caeni |
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);;