contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA688655" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8320238 | 8320238 | PRJNA688655_P_NODE_11567_length_247_cov_0.885057_g11502_i0 | PRJNA688655 | 11567 | 247 | 0.885057 | 2.18609079 | Myxococcota | 2818505 | Bacteria | Bacteria | 99 | 1.2500000000000001e-22 | NR | OGP33838.1 | 1797820 | g11502 | i0 | 84.9 | 5.1497975708502 | 53 | 8 | 64.4 | 0 | 89 | 247 | 1 | 53 | OGP33838.1 MAG: 3-oxoacyl-ACP synthase [Deltaproteobacteria bacterium GWC2_65_14] | diamond | 1272 | 99 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium GWC2_65_14 | ||||||
| 15969779 | 15969779 | PRJNA688655_P_NODE_11113_length_247_cov_0.885057_g11048_i0 | PRJNA688655 | 11113 | 247 | 0.885057 | 2.18609079 | Deltaproteobacteria bacterium RBG_13_49_15 | 1797827 | Bacteria | Bacteria | 94 | 1.91e-20 | NR | OGP62501.1 | 1797827 | g11048 | i0 | 54.3 | 5.96356275303644 | 81 | 37 | 98.4 | 0 | 5 | 247 | 22 | 102 | OGP62501.1 MAG: hypothetical protein A2V65_08580 [Deltaproteobacteria bacterium RBG_13_49_15] | diamond | 1473 | 94 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_13_49_15 | ||||||
| 23619994 | 23619994 | PRJNA688655_P_NODE_16139_length_241_cov_0.916667_g16074_i0 | PRJNA688655 | 16139 | 241 | 0.916667 | 2.20916747 | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-6 | 2013756 | Bacteria | Bacteria | 143 | 1.4999999999999999e-40 | NR | PKN20994.1 | 2013756 | g16074 | i0 | 90.5 | 3.68464730290456 | 74 | 7 | 92.1 | 0 | 2 | 223 | 172 | 245 | PKN20994.1 MAG: hypothetical protein CVU71_04245 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-6] | diamond | 888 | 143 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-6 | ||||||
| 27587857 | 27587857 | PRJNA688655_P_NODE_12444_length_246_cov_0.890173_g12379_i0 | PRJNA688655 | 12444 | 246 | 0.890173 | 2.18982558 | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-22 | 2013750 | Bacteria | Bacteria | 144 | 2.86e-40 | NR | PKN27844.1 | 2013750 | g12379 | i0 | 87.7 | 0.98780487804878 | 81 | 10 | 98.8 | 0 | 244 | 2 | 128 | 208 | PKN27844.1 MAG: UTP--glucose-1-phosphate uridylyltransferase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-22] | diamond | 243 | 144 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-22 | ||||||
| 27745879 | 27745879 | PRJNA688655_P_NODE_8104_length_251_cov_0.865169_g8039_i0 | PRJNA688655 | 8104 | 251 | 0.865169 | 2.17157419 | SAR324 cluster bacterium | 2024889 | Bacteria | Bacteria | 88.2 | 1.19e-18 | NR | NMC63969.1 | 2024889 | g8039 | i0 | 53.1 | 0.968127490039841 | 81 | 33 | 94.4 | 2 | 1 | 237 | 154 | 231 | NMC63969.1 glycosyltransferase family 4 protein [SAR324 cluster bacterium] | diamond | 243 | 88.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 27903286 | 27903286 | PRJNA688655_P_NODE_14905_length_243_cov_0.905882_g14840_i0 | PRJNA688655 | 14905 | 243 | 0.905882 | 2.20129326 | Deltaproteobacteria bacterium ADurb.Bin | 2026735 | Bacteria | Bacteria | 154 | 1.5e-45 | NR | OQC72862.1 | 1852862 | g14840 | i0 | 96.3 | 2 | 81 | 3 | 100 | 0 | 243 | 1 | 72 | 152 | OQC72862.1 MAG: putative periplasmic serine endoprotease DegP-like precursor [Deltaproteobacteria bacterium ADurb.Bin002] | diamond | 486 | 154 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium ADurb.Bin002 | ||||||
| 28041446 | 28041446 | PRJNA688655_P_NODE_8465_length_250_cov_0.870056_g8400_i0 | PRJNA688655 | 8465 | 250 | 0.870056 | 2.17514 | Myxococcota | 2818505 | Bacteria | Bacteria | 97.8 | 9.96e-23 | NR | OQC41215.1 | 1852865 | g8400 | i0 | 60.5 | 1.944 | 81 | 29 | 96 | 2 | 250 | 11 | 66 | 144 | OQC41215.1 MAG: CDP-alcohol phosphatidyltransferase [Deltaproteobacteria bacterium ADurb.Bin058] | diamond | 486 | 97.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium ADurb.Bin058 | ||||||
| 28451977 | 28451977 | PRJNA688655_P_NODE_13426_length_244_cov_0.900585_g13361_i0 | PRJNA688655 | 13426 | 244 | 0.900585 | 2.1974274 | Myxococcota | 2818505 | Bacteria | Bacteria | 52 | 2.08e-5 | NR | OIP38123.1 | 1805126 | g13361 | i0 | 65.8 | 1.79508196721311 | 38 | 13 | 46.7 | 0 | 235 | 122 | 117 | 154 | OIP38123.1 MAG: hypothetical protein AUK47_12580 [Deltaproteobacteria bacterium CG2_30_63_29] | diamond | 438 | 52 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG2_30_63_29 | ||||||
| 29103476 | 29103476 | PRJNA688655_P_NODE_5448_length_287_cov_1.079439_g5383_i0 | PRJNA688655 | 5448 | 287 | 1.079439 | 3.09798993 | Deltaproteobacteria bacterium ADurb.Bin | 2026735 | Bacteria | Bacteria | 190 | 1.6999999999999997e-56 | NR | OQC51018.1 | 1852864 | g5383 | i0 | 96.8 | 0.993031358885017 | 95 | 3 | 99.3 | 0 | 285 | 1 | 278 | 372 | OQC51018.1 MAG: Archaeal ATPase [Deltaproteobacteria bacterium ADurb.Bin026] | diamond | 285 | 190 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium ADurb.Bin026 | ||||||
| 30113772 | 30113772 | PRJNA688655_P_NODE_9532_length_249_cov_0.875000_g9467_i0 | PRJNA688655 | 9532 | 249 | 0.875 | 2.17875 | Bradymonadaceae bacterium | 2740543 | Bacteria | Bacteria | 57.8 | 2.11e-7 | NR | MFU8804319.1 | 2740543 | g9467 | i0 | 41.6 | 1.91566265060241 | 77 | 41 | 90.4 | 3 | 231 | 7 | 60 | 134 | MFU8804319.1 PKD domain-containing protein [Bradymonadaceae bacterium] | diamond | 477 | 57.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Bradymonadaceae bacterium | ||||
| 31042012 | 31042012 | PRJNA688655_P_NODE_8475_length_250_cov_0.870056_g8410_i0 | PRJNA688655 | 8475 | 250 | 0.870056 | 2.17514 | Chondromyces | 50 | Bacteria | Bacteria | 132 | 6.09e-35 | NR | OQB18964.1 | 1852869 | g8410 | i0 | 74.7 | 2.988 | 83 | 21 | 99.6 | 0 | 2 | 250 | 205 | 287 | OQB18964.1 MAG: putative Ni/Fe-hydrogenase 2 b-type cytochrome subunit [Deltaproteobacteria bacterium ADurb.Bin207] | diamond | 747 | 133 | 0.992481203007519 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium ADurb.Bin207 | ||||||
| 31282859 | 31282859 | PRJNA688655_P_NODE_10955_length_247_cov_0.885057_g10890_i0 | PRJNA688655 | 10955 | 247 | 0.885057 | 2.18609079 | Olavius sp. associated proteobacterium Delta 1 | 698986 | Bacteria | Bacteria | 158 | 6.0799999999999986e-43 | NR | CAB1059744.1 | 698986 | g10890 | i0 | 94.8 | 0.935222672064777 | 77 | 4 | 93.5 | 0 | 233 | 3 | 1 | 77 | CAB1059744.1 Anaerobic dimethyl sulfoxide reductase chain A (EC, molybdopterin-binding domain [Olavius sp. associated proteobacterium Delta 1] | diamond | 231 | 158 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Olavius sp. associated proteobacterium Delta 1 | ||||||
| 32780226 | 32780226 | PRJNA688655_P_NODE_14120_length_244_cov_0.900585_g14055_i0 | PRJNA688655 | 14120 | 244 | 0.900585 | 2.1974274 | Bacteria | 2 | Bacteria | Bacteria | 59.7 | 3.35e-8 | NR | MBL4824156.1 | 2024889 | g14055 | i0 | 71.1 | 1.86885245901639 | 38 | 11 | 46.7 | 0 | 242 | 129 | 276 | 313 | MBL4824156.1 sigma-54-dependent Fis family transcriptional regulator [SAR324 cluster bacterium] | diamond | 456 | 59.7 | 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);;