contig_metadata
10 rows where bioproject = "PRJNA1136505" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27418275 | 27418275 | PRJNA1136505_P_NODE_154903_length_241_cov_0.916667_g148043_i0 | PRJNA1136505 | 154903 | 241 | 0.916667 | 2.20916747 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 144 | 9.75e-41 | NR | HNM49843.1 | 2711154 | g148043 | i0 | 88.8 | 4.9792531120332 | 80 | 9 | 99.6 | 0 | 241 | 2 | 104 | 183 | HNM49843.1 AAA family ATPase [Candidatus Obscuribacter sp.] | diamond | 1200 | 144 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 28144440 | 28144440 | PRJNA1136505_P_NODE_74965_length_339_cov_1.447368_g68105_i0 | PRJNA1136505 | 74965 | 339 | 1.447368 | 4.90657752 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 50.1 | 2.3e-4 | NR | HEY9814218.1 | 2364082 | g68105 | i0 | 30.7 | 0.893805309734513 | 101 | 65 | 87.6 | 2 | 307 | 11 | 113 | 210 | HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 303 | 50.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28428471 | 28428471 | PRJNA1136505_P_NODE_12746_length_1930_cov_29.281637_g8836_i0 | PRJNA1136505 | 12746 | 1930 | 29.281637 | 565.1355941 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 155 | 4.96e-39 | NR | HEY9814218.1 | 2364082 | g8836 | i0 | 39.1 | 0.385492227979275 | 248 | 141 | 37.5 | 5 | 1456 | 734 | 14 | 258 | HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 744 | 155 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28901808 | 28901808 | PRJNA1136505_P_NODE_20948_length_1083_cov_1.367327_g14988_i0 | PRJNA1136505 | 20948 | 1083 | 1.367327 | 14.80815141 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 145 | 1.7699999999999998e-37 | NR | HEY9814218.1 | 2364082 | g14988 | i0 | 36.2 | 0.742382271468144 | 268 | 144 | 70.9 | 11 | 18 | 785 | 6 | 258 | HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 804 | 145 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28965291 | 28965291 | PRJNA1136505_P_NODE_110168_length_275_cov_1.386139_g103308_i0 | PRJNA1136505 | 110168 | 275 | 1.386139 | 3.81188225 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 159 | 5.26e-46 | NR | HMY05009.1 | 2711154 | g103308 | i0 | 83.5 | 3.97090909090909 | 91 | 15 | 99.3 | 0 | 274 | 2 | 50 | 140 | HMY05009.1 hypothetical protein [Candidatus Obscuribacter sp.] | diamond | 1092 | 159 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 29944112 | 29944112 | PRJNA1136505_P_NODE_41431_length_516_cov_1.769752_g34579_i0 | PRJNA1136505 | 41431 | 516 | 1.769752 | 9.13192032 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 70.5 | 4.63e-11 | NR | HEY9814218.1 | 2364082 | g34579 | i0 | 28.1 | 0.930232558139535 | 160 | 106 | 90.7 | 5 | 24 | 491 | 18 | 172 | HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 480 | 70.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31386764 | 31386764 | PRJNA1136505_P_NODE_98736_length_290_cov_1.350230_g91876_i0 | PRJNA1136505 | 98736 | 290 | 1.35023 | 3.915667 | Bacillati | 1783272 | Bacteria | Bacteria | 127 | 9.769999999999999e-34 | NR | MDZ4832751.1 | 2052166 | g91876 | i0 | 81.3 | 2.51379310344828 | 80 | 15 | 82.8 | 0 | 51 | 290 | 73 | 152 | MDZ4832751.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 729 | 128 | 0.9921875 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31829247 | 31829247 | PRJNA1136505_P_NODE_25977_length_826_cov_1.079681_g19455_i0 | PRJNA1136505 | 25977 | 826 | 1.079681 | 8.91816506 | Vampirovibrio | 213484 | Bacteria | Bacteria | 88.2 | 1.57e-16 | NR | MBI3591571.1 | 2052166 | g19455 | i0 | 30.1 | 1.70702179176755 | 239 | 107 | 82.1 | 10 | 95 | 772 | 69 | 260 | MBI3591571.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 1410 | 88.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 32125346 | 32125346 | PRJNA1136505_P_NODE_12238_length_2008_cov_3.137468_g8482_i0 | PRJNA1136505 | 12238 | 2008 | 3.137468 | 63.00035744 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 152 | 5.929999999999999e-38 | NR | HEY9814218.1 | 2364082 | g8482 | i0 | 37.9 | 0.370517928286853 | 248 | 144 | 36 | 5 | 1520 | 798 | 14 | 258 | HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 744 | 152 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32156948 | 32156948 | PRJNA1136505_P_NODE_12678_length_1939_cov_3.356377_g8799_i0 | PRJNA1136505 | 12678 | 1939 | 3.356377 | 65.08015003 | Vampirovibrio sp. | 2717857 | Bacteria | Bacteria | 58.2 | 1.25e-4 | NR | WP_373533563.1 | 2717857 | g8799 | i0 | 55 | 0.0618875709128417 | 40 | 18 | 6.2 | 0 | 1807 | 1926 | 556 | 595 | WP_373533563.1 hypothetical protein [Vampirovibrio sp.] | diamond | 120 | 58.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Vampirovibriophyceae | Vampirovibrionales | Vampirovibrio | Vampirovibrio 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);;