contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA900028" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26897695 | 26897695 | PRJNA900028_P_NODE_148121_length_165_cov_0.879310_g147372_i0 | PRJNA900028 | 148121 | 165 | 0.87931 | 1.4508615 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 99.4 | 1.47e-22 | NR | RAI12582.1 | 2052166 | g147372 | i0 | 87 | 0.981818181818182 | 54 | 7 | 98.2 | 0 | 2 | 163 | 346 | 399 | RAI12582.1 MAG: hypothetical protein DKM23_03500 [Candidatus Melainabacteria bacterium] | diamond | 162 | 99.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27063401 | 27063401 | PRJNA900028_P_NODE_40122_length_221_cov_0.889535_g39373_i0 | PRJNA900028 | 40122 | 221 | 0.889535 | 1.96587235 | Bacillati | 1783272 | Bacteria | Bacteria | 115 | 5.11e-28 | NR | HEY9867279.1 | 2364082 | g39373 | i0 | 80.6 | 1.94117647058824 | 72 | 14 | 97.7 | 0 | 216 | 1 | 366 | 437 | HEY9867279.1 dynamin family protein [Candidatus Obscuribacterales bacterium] | diamond | 429 | 115 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 27118733 | 27118733 | PRJNA900028_P_NODE_104862_length_173_cov_1.645161_g104113_i0 | PRJNA900028 | 104862 | 173 | 1.645161 | 2.84612853 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 62 | 4.07e-10 | NR | HEY9805627.1 | 2364082 | g104113 | i0 | 51.9 | 0.936416184971098 | 54 | 26 | 93.6 | 0 | 167 | 6 | 7 | 60 | HEY9805627.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 162 | 62 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29297924 | 29297924 | PRJNA900028_P_NODE_192009_length_161_cov_0.910714_g191260_i0 | PRJNA900028 | 192009 | 161 | 0.910714 | 1.46624954 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 47.4 | 2.41e-4 | NR | HEY9791151.1 | 2364082 | g191260 | i0 | 49.1 | 0.987577639751553 | 53 | 27 | 98.8 | 0 | 1 | 159 | 139 | 191 | HEY9791151.1 DUF6431 domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 159 | 47.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29613278 | 29613278 | PRJNA900028_P_NODE_144250_length_165_cov_0.879310_g143501_i0 | PRJNA900028 | 144250 | 165 | 0.87931 | 1.4508615 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 117 | 8.31e-30 | NR | HIA52931.1 | 2052166 | g143501 | i0 | 100 | 1 | 55 | 0 | 100 | 0 | 1 | 165 | 63 | 117 | HIA52931.1 DNA polymerase IV [Candidatus Melainabacteria bacterium] | diamond | 165 | 117 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30024371 | 30024371 | PRJNA900028_P_NODE_183351_length_162_cov_0.902655_g182602_i0 | PRJNA900028 | 183351 | 162 | 0.902655 | 1.4623011 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 109 | 3.64e-27 | NR | RAI12373.1 | 2052166 | g182602 | i0 | 96.2 | 0.981481481481482 | 53 | 2 | 98.1 | 0 | 160 | 2 | 194 | 246 | RAI12373.1 MAG: hypothetical protein DKM23_02420 [Candidatus Melainabacteria bacterium] | diamond | 159 | 109 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30253230 | 30253230 | PRJNA900028_P_NODE_88132_length_181_cov_1.545455_g87383_i0 | PRJNA900028 | 88132 | 181 | 1.545455 | 2.79727355 | Bacillati | 1783272 | Bacteria | Bacteria | 111 | 1.2e-26 | NR | MCC7531589.1 | 2052166 | g87383 | i0 | 86.7 | 4.97237569060773 | 60 | 8 | 99.4 | 0 | 181 | 2 | 245 | 304 | MCC7531589.1 serine/threonine protein kinase [Candidatus Melainabacteria bacterium] | diamond | 900 | 111 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30309012 | 30309012 | PRJNA900028_P_NODE_113432_length_169_cov_1.700000_g112683_i0 | PRJNA900028 | 113432 | 169 | 1.7 | 2.873 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 107 | 3.74e-26 | NR | MBX9573106.1 | 2364082 | g112683 | i0 | 100 | 0.976331360946746 | 55 | 0 | 97.6 | 0 | 167 | 3 | 151 | 205 | MBX9573106.1 hybrid sensor histidine kinase/response regulator [Candidatus Obscuribacterales bacterium] | diamond | 165 | 107 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30972171 | 30972171 | PRJNA900028_P_NODE_180834_length_162_cov_0.902655_g180085_i0 | PRJNA900028 | 180834 | 162 | 0.902655 | 1.4623011 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 72 | 5.21e-13 | NR | MFN8659159.1 | 2364082 | g180085 | i0 | 68 | 1.83333333333333 | 50 | 16 | 92.6 | 0 | 161 | 12 | 102 | 151 | MFN8659159.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 297 | 72 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31635940 | 31635940 | PRJNA900028_P_NODE_159976_length_164_cov_0.886957_g159227_i0 | PRJNA900028 | 159976 | 164 | 0.886957 | 1.45460948 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 87.4 | 2.29e-18 | NR | MBC8000457.1 | 2052166 | g159227 | i0 | 86.8 | 0.969512195121951 | 53 | 7 | 97 | 0 | 6 | 164 | 552 | 604 | MBC8000457.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 159 | 87.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32047350 | 32047350 | PRJNA900028_P_NODE_71578_length_189_cov_0.900000_g70829_i0 | PRJNA900028 | 71578 | 189 | 0.9 | 1.701 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 120 | 2.11e-30 | NR | MBC8000122.1 | 2052166 | g70829 | i0 | 90.3 | 0.984126984126984 | 62 | 6 | 98.4 | 0 | 188 | 3 | 187 | 248 | MBC8000122.1 TIGR01777 family protein [Candidatus Melainabacteria bacterium] | diamond | 186 | 120 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32110578 | 32110578 | PRJNA900028_P_NODE_102978_length_174_cov_1.632000_g102229_i0 | PRJNA900028 | 102978 | 174 | 1.632 | 2.83968 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 102 | 1.29e-23 | NR | MBK9205297.1 | 2711154 | g102229 | i0 | 91.2 | 1.96551724137931 | 57 | 5 | 98.3 | 0 | 173 | 3 | 447 | 503 | MBK9205297.1 heavy metal translocating P-type ATPase [Candidatus Obscuribacter sp.] | diamond | 342 | 102 | 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);;