contig_metadata
8 rows where bioproject = "PRJNA577580", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3689531 | 3689531 | PRJNA577580_P_NODE_9363_length_298_cov_1.364444_g9285_i0 | PRJNA577580 | 9363 | 298 | 1.364444 | 4.06604312 | Bacteria | 2 | Bacteria | Bacteria | 65.9 | 5.26e-10 | NR | MDR3617278.1 | 2364082 | g9285 | i0 | 37 | 4.67114093959732 | 92 | 57 | 92.6 | 1 | 281 | 6 | 335 | 425 | MDR3617278.1 glycosyltransferase [Candidatus Obscuribacterales bacterium] | diamond | 1392 | 65.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 6942242 | 6942242 | PRJNA577580_P_NODE_5006_length_401_cov_1.408537_g4928_i0 | PRJNA577580 | 5006 | 401 | 1.408537 | 5.64823337 | Vampirovibrio | 213484 | Bacteria | Bacteria | 187 | 2.64e-54 | NR | WP_303673202.1 | 758823 | g4928 | i0 | 66.7 | 7.85536159600997 | 132 | 43 | 98.8 | 1 | 399 | 4 | 341 | 471 | WP_303673202.1 IMP dehydrogenase [Vampirovibrio chlorellavorus] | diamond | 3150 | 187 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Vampirovibriophyceae | Vampirovibrionales | Vampirovibrio | Vampirovibrio chlorellavorus | ||
| 26667872 | 26667872 | PRJNA577580_P_NODE_13061_length_257_cov_1.467391_g12983_i0 | PRJNA577580 | 13061 | 257 | 1.467391 | 3.77119487 | Vampirovibrionales bacterium | 2692181 | Bacteria | Bacteria | 110 | 5.850000000000001e-26 | NR | MDH4379041.1 | 2692181 | g12983 | i0 | 61.4 | 3.87548638132296 | 83 | 32 | 96.9 | 0 | 6 | 254 | 120 | 202 | MDH4379041.1 IMP dehydrogenase [Vampirovibrionales bacterium] | diamond | 996 | 110 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Vampirovibriophyceae | Vampirovibrionales | Vampirovibrionales bacterium | |||
| 28627356 | 28627356 | PRJNA577580_P_NODE_3667_length_470_cov_6.057935_g3589_i0 | PRJNA577580 | 3667 | 470 | 6.057935 | 28.4722945 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 62.4 | 2.65e-9 | NR | MBY0549840.1 | 2364082 | g3589 | i0 | 34.3 | 0.651063829787234 | 102 | 67 | 65.1 | 0 | 113 | 418 | 4 | 105 | MBY0549840.1 TMEM14 family protein [Candidatus Obscuribacterales bacterium] | diamond | 306 | 62.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30679756 | 30679756 | PRJNA577580_P_NODE_14333_length_250_cov_0.881356_g14255_i0 | PRJNA577580 | 14333 | 250 | 0.881356 | 2.20339 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 48.1 | 4.49e-4 | NR | MBX9951741.1 | 2364082 | g14255 | i0 | 35.2 | 0.852 | 71 | 45 | 84 | 1 | 211 | 2 | 51 | 121 | MBX9951741.1 MOSC N-terminal beta barrel domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 213 | 48.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32545999 | 32545999 | PRJNA577580_P_NODE_4179_length_441_cov_0.826087_g4101_i0 | PRJNA577580 | 4179 | 441 | 0.826087 | 3.64304367 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 77.4 | 1.75e-13 | NR | MBX9671181.1 | 2364082 | g4101 | i0 | 45.5 | 0.748299319727891 | 110 | 52 | 72.1 | 3 | 437 | 120 | 60 | 165 | MBX9671181.1 PAS domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 330 | 77.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32874164 | 32874164 | PRJNA577580_P_NODE_8180_length_316_cov_2.255144_g8102_i0 | PRJNA577580 | 8180 | 316 | 2.255144 | 7.12625504 | Bacillati | 1783272 | Bacteria | Bacteria | 85.5 | 8.63e-17 | NR | MDR3617424.1 | 2364082 | g8102 | i0 | 40.6 | 1.90822784810127 | 101 | 57 | 93 | 1 | 316 | 23 | 82 | 182 | MDR3617424.1 serine/threonine-protein kinase [Candidatus Obscuribacterales bacterium] | diamond | 603 | 86.3 | 0.990730011587486 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32892118 | 32892118 | PRJNA577580_P_NODE_13700_length_252_cov_1.698324_g13622_i0 | PRJNA577580 | 13700 | 252 | 1.698324 | 4.27977648 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 103 | 1.03e-24 | NR | MBX9939906.1 | 2364082 | g13622 | i0 | 58.4 | 0.916666666666667 | 77 | 31 | 91.7 | 1 | 231 | 1 | 26 | 101 | MBX9939906.1 NUDIX domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 231 | 103 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales 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);;