contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA745553" and tax_phylum = "Candidatus Melainabacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4552934 | 4552934 | PRJNA745553_S_NODE_6824_length_451_cov_2.515873_g6630_i0 | PRJNA745553 | 6824 | 451 | 2.515873 | 11.34658723 | Bacillati | 1783272 | Bacteria | Bacteria | 57.8 | 4.52e-8 | NR | MDR3613109.1 | 2364082 | g6630 | i0 | 93.3 | 0.991130820399113 | 30 | 2 | 20 | 0 | 418 | 329 | 1 | 30 | MDR3613109.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 447 | 57.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 23677321 | 23677321 | PRJNA745553_S_NODE_28719_length_227_cov_7.967532_g28524_i0 | PRJNA745553 | 28719 | 227 | 7.967532 | 18.08629764 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 111 | 1.02e-28 | NR | HEY9840994.1 | 2364082 | g28524 | i0 | 96.7 | 0.79295154185022 | 60 | 2 | 79.3 | 0 | 17 | 196 | 132 | 191 | HEY9840994.1 sigma-70 family RNA polymerase sigma factor [Candidatus Obscuribacterales bacterium] | diamond | 180 | 111 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27653154 | 27653154 | PRJNA745553_S_NODE_26104_length_243_cov_5.741176_g25909_i0 | PRJNA745553 | 26104 | 243 | 5.741176 | 13.95105768 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 149 | 2.5399999999999993e-43 | NR | MBN9397140.1 | 2052166 | g25909 | i0 | 98.6 | 0.901234567901235 | 73 | 1 | 90.1 | 0 | 24 | 242 | 84 | 156 | MBN9397140.1 hydrogenase nickel incorporation protein HypB [Candidatus Melainabacteria bacterium] | diamond | 219 | 149 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27716550 | 27716550 | PRJNA745553_S_NODE_8704_length_408_cov_2.856716_g8509_i0 | PRJNA745553 | 8704 | 408 | 2.856716 | 11.65540128 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 256 | 1.8e-83 | NR | MBK9279865.1 | 2711154 | g8509 | i0 | 84.2 | 5.81617647058824 | 133 | 21 | 97.8 | 0 | 6 | 404 | 145 | 277 | MBK9279865.1 c-type cytochrome [Candidatus Obscuribacter sp.] | diamond | 2373 | 256 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 28095041 | 28095041 | PRJNA745553_S_NODE_18585_length_286_cov_5.774648_g18390_i0 | PRJNA745553 | 18585 | 286 | 5.774648 | 16.51549328 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 76.3 | 1.74e-14 | NR | MFA7341398.1 | 2364082 | g18390 | i0 | 55.1 | 0.818181818181818 | 78 | 33 | 79.7 | 1 | 271 | 44 | 38 | 115 | MFA7341398.1 DUF502 domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 234 | 76.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30021322 | 30021322 | PRJNA745553_S_NODE_21691_length_265_cov_8.557292_g21496_i0 | PRJNA745553 | 21691 | 265 | 8.557292 | 22.6768238 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 120 | 5.11e-33 | NR | HMX44475.1 | 2711154 | g21496 | i0 | 90.2 | 1.3811320754717 | 61 | 6 | 69.1 | 0 | 261 | 79 | 53 | 113 | HMX44475.1 hypothetical protein [Candidatus Obscuribacter sp.] | diamond | 366 | 120 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 30874216 | 30874216 | PRJNA745553_S_NODE_4014_length_541_cov_2.801282_g3826_i0 | PRJNA745553 | 4014 | 541 | 2.801282 | 15.15493562 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 251 | 4.38e-83 | NR | MBI5171366.1 | 2052166 | g3826 | i0 | 93.8 | 0.715341959334566 | 129 | 8 | 71.5 | 0 | 435 | 49 | 1 | 129 | MBI5171366.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 387 | 251 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32770868 | 32770868 | PRJNA745553_S_NODE_29320_length_221_cov_4.418919_g29125_i0 | PRJNA745553 | 29320 | 221 | 4.418919 | 9.76581099 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 82.4 | 2.97e-16 | NR | MBK8219603.1 | 2711154 | g29125 | i0 | 78.4 | 2.07692307692308 | 51 | 11 | 69.2 | 0 | 203 | 51 | 837 | 887 | MBK8219603.1 AAA family ATPase [Candidatus Obscuribacter sp.] | diamond | 459 | 82.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. |
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);;