contig_metadata
11 rows where bioproject = "PRJNA690592", tax_clade = "Cyanobacteriota/Melainabacteria group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1947896 | 1947896 | PRJNA690592_S_NODE_61182_length_403_cov_1.166667_g60168_i0 | PRJNA690592 | 61182 | 403 | 1.166667 | 4.70166801 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 246 | 3.59e-81 | NR | MBX9724270.1 | 2364082 | g60168 | i0 | 91.7 | 0.990074441687345 | 133 | 11 | 99 | 0 | 401 | 3 | 19 | 151 | MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] | diamond | 399 | 246 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 26777558 | 26777558 | PRJNA690592_S_NODE_187681_length_250_cov_2.553672_g186667_i0 | PRJNA690592 | 187681 | 250 | 2.553672 | 6.38418 | Bacillati | 1783272 | Bacteria | Bacteria | 70.1 | 8.6e-12 | NR | MBX9568760.1 | 2364082 | g186667 | i0 | 41.2 | 4.632 | 85 | 48 | 99.6 | 1 | 1 | 249 | 312 | 396 | MBX9568760.1 serpin family protein [Candidatus Obscuribacterales bacterium] | diamond | 1158 | 70.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27208778 | 27208778 | PRJNA690592_S_NODE_62382_length_399_cov_2.490798_g61368_i0 | PRJNA690592 | 62382 | 399 | 2.490798 | 9.93828402 | Candidatus Gastranaerophilaceae bacterium | 3022870 | Bacteria | Bacteria | 51.2 | 6.81e-5 | NR | MFQ9193840.1 | 3022870 | g61368 | i0 | 42.3 | 0.533834586466165 | 71 | 40 | 53.4 | 1 | 215 | 3 | 65 | 134 | MFQ9193840.1 type II secretion system protein [Candidatus Gastranaerophilaceae bacterium] | diamond | 213 | 51.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilaceae | Candidatus Gastranaerophilaceae bacterium | |||
| 27493251 | 27493251 | PRJNA690592_S_NODE_106143_length_320_cov_1.246964_g105129_i0 | PRJNA690592 | 106143 | 320 | 1.246964 | 3.9902848 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 63.2 | 1.31e-9 | NR | MBX9941978.1 | 2364082 | g105129 | i0 | 50 | 0.54375 | 58 | 28 | 54.4 | 1 | 318 | 145 | 122 | 178 | MBX9941978.1 TerD family protein [Candidatus Obscuribacterales bacterium] | diamond | 174 | 63.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28408969 | 28408969 | PRJNA690592_S_NODE_27086_length_579_cov_1.286561_g26091_i0 | PRJNA690592 | 27086 | 579 | 1.286561 | 7.44918819 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 108 | 3.66e-25 | NR | HEY9814218.1 | 2364082 | g26091 | i0 | 36.4 | 0.911917098445596 | 176 | 90 | 91.2 | 5 | 577 | 50 | 43 | 196 | HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 528 | 108 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29387806 | 29387806 | PRJNA690592_S_NODE_131789_length_293_cov_1.045455_g130775_i0 | PRJNA690592 | 131789 | 293 | 1.045455 | 3.06318315 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 172 | 2.42e-50 | NR | HEY9862327.1 | 2364082 | g130775 | i0 | 97.8 | 0.9419795221843 | 92 | 2 | 94.2 | 0 | 17 | 292 | 1 | 92 | HEY9862327.1 IS4 family transposase [Candidatus Obscuribacterales bacterium] | diamond | 276 | 172 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29671564 | 29671564 | PRJNA690592_S_NODE_214970_length_241_cov_1.059524_g213956_i0 | PRJNA690592 | 214970 | 241 | 1.059524 | 2.55345284 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 132 | 1.2e-37 | NR | MBX9722668.1 | 2364082 | g213956 | i0 | 75 | 1.99170124481328 | 80 | 20 | 99.6 | 0 | 240 | 1 | 14 | 93 | MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 480 | 132 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29798108 | 29798108 | PRJNA690592_S_NODE_64931_length_393_cov_0.818750_g63917_i0 | PRJNA690592 | 64931 | 393 | 0.81875 | 3.2176875 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 122 | 2.1599999999999998e-32 | NR | MBL8086383.1 | 2711154 | g63917 | i0 | 72.4 | 0.66412213740458 | 87 | 20 | 63.4 | 1 | 366 | 118 | 58 | 144 | MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] | diamond | 261 | 122 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 31662600 | 31662600 | PRJNA690592_S_NODE_218597_length_232_cov_4.861635_g217583_i0 | PRJNA690592 | 218597 | 232 | 4.861635 | 11.2789932 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 99 | 4.07e-24 | NR | MBX9724270.1 | 2364082 | g217583 | i0 | 92.3 | 0.672413793103448 | 52 | 4 | 67.2 | 0 | 6 | 161 | 119 | 170 | MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] | diamond | 156 | 99 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32042472 | 32042472 | PRJNA690592_S_NODE_83958_length_352_cov_1.250896_g82944_i0 | PRJNA690592 | 83958 | 352 | 1.250896 | 4.40315392 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 64.3 | 1.73e-9 | NR | HEY9814218.1 | 2364082 | g82944 | i0 | 34.5 | 0.963068181818182 | 113 | 50 | 93.8 | 4 | 338 | 9 | 40 | 131 | HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 339 | 64.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32580437 | 32580437 | PRJNA690592_S_NODE_216099_length_241_cov_0.916667_g215085_i0 | PRJNA690592 | 216099 | 241 | 0.916667 | 2.20916747 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 93.6 | 1.08e-20 | NR | MCC6976686.1 | 2052166 | g215085 | i0 | 61.5 | 7.20746887966805 | 78 | 29 | 97.1 | 1 | 6 | 239 | 129 | 205 | MCC6976686.1 ADP-ribosylglycohydrolase family protein [Candidatus Melainabacteria bacterium] | diamond | 1737 | 93.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria 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);;