contig_metadata
7 rows where bioproject = "PRJNA773247", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26704941 | 26704941 | PRJNA773247_P_NODE_36641_length_226_cov_2.222222_g36557_i0 | PRJNA773247 | 36641 | 226 | 2.222222 | 5.02222172 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 52.8 | 8.33e-6 | NR | MBK8225444.1 | 2711154 | g36557 | i0 | 36.7 | 0.79646017699115 | 60 | 38 | 79.6 | 0 | 202 | 23 | 147 | 206 | MBK8225444.1 hypothetical protein [Candidatus Obscuribacter sp.] | diamond | 180 | 52.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 27053416 | 27053416 | PRJNA773247_P_NODE_35662_length_235_cov_2.067901_g35578_i0 | PRJNA773247 | 35662 | 235 | 2.067901 | 4.85956735 | Candidatus Gastranaerophilaceae bacterium | 3022870 | Bacteria | Bacteria | 67 | 9.3e-13 | NR | MFA7658717.1 | 3022870 | g35578 | i0 | 73.5 | 1.2 | 49 | 9 | 57.4 | 1 | 234 | 100 | 10 | 58 | MFA7658717.1 hypothetical protein [Candidatus Gastranaerophilaceae bacterium] | diamond | 282 | 67 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilaceae | Candidatus Gastranaerophilaceae bacterium | |||
| 28979890 | 28979890 | PRJNA773247_P_NODE_36588_length_226_cov_3.209150_g36504_i0 | PRJNA773247 | 36588 | 226 | 3.20915 | 7.252679 | Candidatus Gastranaerophilaceae bacterium | 3022870 | Bacteria | Bacteria | 100 | 4.5e-25 | NR | MFA6990293.1 | 3022870 | g36504 | i0 | 63.5 | 0.836283185840708 | 63 | 23 | 83.6 | 0 | 37 | 225 | 1 | 63 | MFA6990293.1 hypothetical protein [Candidatus Gastranaerophilaceae bacterium] | diamond | 189 | 100 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilaceae | Candidatus Gastranaerophilaceae bacterium | |||
| 29421530 | 29421530 | PRJNA773247_P_NODE_25669_length_276_cov_1.842365_g25585_i0 | PRJNA773247 | 25669 | 276 | 1.842365 | 5.0849274 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 44.3 | 0.00178 | NR | PWT97514.1 | 2052166 | g25585 | i0 | 54.3 | 0.380434782608696 | 35 | 14 | 38 | 1 | 139 | 35 | 2 | 34 | PWT97514.1 MAG: nucleoside kinase, partial [Candidatus Melainabacteria bacterium] | diamond | 105 | 44.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 29832167 | 29832167 | PRJNA773247_P_NODE_23271_length_292_cov_6.607306_g23187_i0 | PRJNA773247 | 23271 | 292 | 6.607306 | 19.29333352 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 195 | 1.58e-57 | NR | MDZ4834737.1 | 2052166 | g23187 | i0 | 97.9 | 0.986301369863014 | 96 | 2 | 98.6 | 0 | 2 | 289 | 31 | 126 | MDZ4834737.1 glutamine-hydrolyzing GMP synthase [Candidatus Melainabacteria bacterium] | diamond | 288 | 195 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 31918245 | 31918245 | PRJNA773247_P_NODE_13517_length_410_cov_3.163205_g13433_i0 | PRJNA773247 | 13517 | 410 | 3.163205 | 12.9691405 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 49.3 | 0.00121 | NR | MFA6208737.1 | 2364082 | g13433 | i0 | 37.1 | 1.41951219512195 | 97 | 57 | 71 | 1 | 350 | 60 | 385 | 477 | MFA6208737.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 582 | 49.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32740212 | 32740212 | PRJNA773247_P_NODE_19040_length_331_cov_1.624031_g18956_i0 | PRJNA773247 | 19040 | 331 | 1.624031 | 5.37554261 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 105 | 4.74e-25 | NR | MBX9942029.1 | 2364082 | g18956 | i0 | 72.5 | 0.725075528700906 | 80 | 19 | 70.7 | 2 | 3 | 236 | 198 | 276 | MBX9942029.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 240 | 105 | 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);;